Question: 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

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 450 5001 BUSA 3315 | Spreadsheet Modeling with Business Applications Page 1 of Part ): Use a two-way data table (Unit Costs in the first row and Quantity Sold in the first column) $0.10 $0.15 $0.20 $0.25 $0,30 $0.45 $0.35 $0.40 100 150 200 250 300 350 4001 450 500 Level A 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. d. Use Excel's Formula Auditing tools to show which cells in your spreadsheet affect profit directly. 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. d. Use Excel's Formula Auditing tools to show which cells in your spreadsheet affect profit directly. Problem 2.20 a, b, c (p. 61) Inputs Fixed cost Quantity sold Unit price Unit cost Total Cost Total Revenge Profit Part(a): Part (b): Use a one-way data table Quantity sold Profit 100 150 200 250 300 350 400 450 5001 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) $0.101 S0.15 $0.20 S0.25 $0.30 $0.35 $0.40 S0.45 100 150 200 250 200 350 400 4501 5001

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!

1 Break-Even Analysis 2 Enter data only in yellow cells. 3 4 Profitability Analysis 5 6 7 Cost 8 2 10 HEREHERE 12 Revenue 13 14 15 16 17 18 Quantity Fixed cost Unit cost Unit revenue Total Cost Total...

Week Three Exercise Assignment Inventory1. Specific identification method. Boston Galleries uses the specific identification method for inventory valuation. Inventory information for several oil...

e e RO W N R WM O A Break-Even Analysis f 10000 Enter data only in yellow cells. Profitability Analysis Cost Revenue Quantity Fixed cost Unit cost Unit revenue Total Cost Total Revenue Net Profit...

MGT 476 Business Data Analytics II Chapter 10 Homework Reading Assignment: Read chapter 10 pages 465480. Shell Workbook A workbook shell is a workbook with the problem data already entered in s...

:Help me answer please. 15-3 Compatibility Microsoft and a smaller rival often have to select from one of two competing technologies. The rival always prefers to the same technology as Microsoft ,...

A small company manufactures a certain product. Variable costs are $20 per unit and fixed costs are $10,875. The price-demand relationship for this product is P = -0.25D + 250, where P is the unit...

Question 3 Belknap Manufacturing has approached you, a CGA, with a problem. The company makes two products: A12 and B15. Demand for BiS has been overwhelming; there is virtually no competition for...

According to the U.S. Census Bureau, approximately 45% of the 29 million 18- to 24-year-olds in the United States are enrolled in college. To more accurately gauge these young voters, an Edgewood...

Explain the six different ways in which nonverbal signals influence supervisory communication.

It is required that the loss in available energy be positive. True fise

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...