Question: please answer in an excel spreadsheet (with explained functions). thank you! 20. Julie James is opening a lemonade stand. She believes the fixed cost per

please answer in an excel spreadsheet (with
please answer in an excel spreadsheet (with
please answer in an excel spreadsheet (with explained functions). thank you!
20. Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup of lemonade is $0.20. a. Given her other assumptions, what level of sales volume will enable Julie to break even? b. Given her other assumptions, discuss how a change in sales volume affects profit. c. Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit. Problem 2.20 a, b, c (p. 61) Inputs Fixed cost Quantity sold Unit price Unit cost Total Cost Total Revenue Profit Part(a): Part (b): Use a one-way data table Quantity sold Profit 100 150 200 250 300 350 400 4501 500 BUSA 3315 | Spreadsheet Modeling with Business Applications Page 1 of 2 Part(): Use a two-way data table (Unit Costs in the first row and Quantity Sold in the first column) S0.101 S0.15 $0.20 S0.25 S0.30 S0.35 S0.40 S0.45 100 150 200 2501 1001 350 4001 4501 500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!