I would like to get the attached problems solved in the screenshot of the spreadsheets provided below. Relevant problems 20 and 22 are attached as well. Thank you so much!

PROBLEMS Level A 20. Julie James is opening a lemonade stand. She believes c. Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influence profit. d. Use Excel's Formula Auditing tools to show which the fixed cost per week of running the stand is $50.00 Her best guess is that she can sell 300 cups per week t $0.50 per cup. The variable cost of producing a cup of lemonade is $0.20 cells in the spreadsheet are directly affected by the percentage of seats full You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs S0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year a. For one to five copiers rented and daily demands 22. 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 of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand. cells in your spreadsheet affect profit directly 21. You are thinking of opening a Broadway play, I Love You, You're Mediocre, Now Get Better! It will cost $5 million to develop the show. There are 8 shows per week, and you project the show will run for 100 weeks. It costs $1000 to open the theater each night. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater b. If you rent three copiers, what daily demand for copies will allow you to break even? c. Graph profit as a function of the number of copiers for a daily demand of 500 copies: for a daily demand of 2000 copies. Interpret your graphs