3. Consider a manufacturing enterprise which produces 17,500 units for $834,500 and 22,500 units for $912,500. Each unit can be sold for $20. a) Find the cost, revenue, and profit functions and graph them in EXCEL. b) Use EXCEL to show the cost of producing 30,000 units? c) What is the break-even point?

Essentials of Economics (MindTap Course List)
8th Edition
ISBN:9781337091992
Author:N. Gregory Mankiw
Publisher:N. Gregory Mankiw
Chapter12: The Cost Of Production
Section: Chapter Questions
Problem 3CQQ
icon
Related questions
Question

please do all the subparts

3. Consider a manufacturing enterprise which produces 17,500 units for $834,500 and 22,500 units
for $912,500. Each unit can be sold for $20.
a) Find the cost, revenue, and profit functions and graph them in EXCEL.
b) Use EXCEL to show the cost of producing 30,000 units?
c) What is the break-even point?
Transcribed Image Text:3. Consider a manufacturing enterprise which produces 17,500 units for $834,500 and 22,500 units for $912,500. Each unit can be sold for $20. a) Find the cost, revenue, and profit functions and graph them in EXCEL. b) Use EXCEL to show the cost of producing 30,000 units? c) What is the break-even point?
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Government Revenue
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Economics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Economics
ISBN:
9781337091992
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Principles of Economics, 7th Edition (MindTap Cou…
Principles of Economics, 7th Edition (MindTap Cou…
Economics
ISBN:
9781285165875
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Economics:
Economics:
Economics
ISBN:
9781285859460
Author:
BOYES, William
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning