Mark is opening an ice cream stand. He believes the fixed cost per week of running the stand is $50.00. His best guess is that he can sell 300 cones per week at $0.50 per cone. The variable cost of producing a cone of ice cream is $0.20. A- while using goal seek, given his other assumptions, what level of sales volume will enable him to break even? B- while using a one way data table given his other assumptions, discuss how a change in sales volume affects profit.

Managerial Economics: A Problem Solving Approach
5th Edition
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Chapter5: Investment Decisions: Look Ahead And Reason Back
Section: Chapter Questions
Problem 5.6IP
icon
Related questions
Question

10

Mark is opening an ice cream stand. He
believes the fixed cost per week of running
the stand is $50.00. His best guess is that he
can sell 300 cones per week at $0.50 per
cone. The variable cost of producing a cone
of ice cream is $0.20.
A- while using goal seek, given his other
assumptions, what level of sales volume will
enable him to break even?
B- while using a one way data table given his
other assumptions, discuss how a change in
sales volume affects profit.
c- while using a two way data table, given his
other assumptions, discuss how a change in
sales volume and variable cost jointly affect
profit.
d- use excels formula auditing tools to show
which cells in your spread sheet affect profit
directly.
Transcribed Image Text:Mark is opening an ice cream stand. He believes the fixed cost per week of running the stand is $50.00. His best guess is that he can sell 300 cones per week at $0.50 per cone. The variable cost of producing a cone of ice cream is $0.20. A- while using goal seek, given his other assumptions, what level of sales volume will enable him to break even? B- while using a one way data table given his other assumptions, discuss how a change in sales volume affects profit. c- while using a two way data table, given his other assumptions, discuss how a change in sales volume and variable cost jointly affect profit. d- use excels formula auditing tools to show which cells in your spread sheet affect profit directly.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Exploring Economics
Exploring Economics
Economics
ISBN:
9781544336329
Author:
Robert L. Sexton
Publisher:
SAGE Publications, Inc
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Survey Of Economics
Survey Of Economics
Economics
ISBN:
9781337111522
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax
Economics: Private and Public Choice (MindTap Cou…
Economics: Private and Public Choice (MindTap Cou…
Economics
ISBN:
9781305506725
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning