Before beginning this assignment, please make sure to work through all Template Files and Practice Problems located in the Module/Week 1 Reading/Study folder. Do not submit the practice problems through the homework assignment submission link. They are simply provided for study and preparation purposes and will not be graded. Problem 2.20: Complete sections a, b, and c of Problem 2.20 on page 61 of your Practical Management Science textbook. o You must use the image below as a guide and create your own Excel sheet from scratch. The problems has 3 parts: o (a) self-explanatory o (b) one-way data table o (c) two-way data table. Please create a new tab for each part (a, b, and c) of the homework problem. o Note: You may get a fractional number of cups in your answer(s). o When you have completed all 3 parts of this assignment, you may submit the single Excel file you have created through the provided assignment link. You will be permitted an unlimited number of attempts to submit the Excel file, but your last submission before the respective due date will be the one selected for grading. . Please note that the solution to this homework assignment will not be revealed until after the assignment due date has passed. o 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 500 Part (c): Use a two-way data table (Unit Costs in the first row and Quantity Sold in the first column) S0.10 $0.15 $0.20 $0.25 $0.30 $0.35 $0.40 $0.45 100 150 200 250 300 350 400 450 500 PROBLEMS Level A Bhoone 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. Ise vaal'. D. 22