I need help with #22 using the template below. Please show the steps.

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 cells in the spreadsheet are directly affected by the percentage of seats full. 22. You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.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 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. 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. 23. Georgia McBeal is trying to save for her retirement. She believes she can earn 10% on average each year on her retirement fund. Assume that at the beginning of each of the next 40 years, Georgia will allocate x dollars to her retirement fund. If at the beginning of 2.8 Conclusion 61 part. Due to electrode rights, one did party may ve additional costat 61 Set Data 22 Data from Picture RE Hannin Refresh All x fx A B E Copy shop Inputs Yearly rental cost $5,000 $400 Other monthly fixed costs Cost per copy $0.03 Charge per copy $0.10 Days per year 365 Months per year 12 Copies per copier per year 100000 2 Profit model 3 Copiers rented (trial value) 4 Daily demand (trial value) 3 1000 15 Copies made 300000 16 Annual profit $1,200 17 18 Part (a): Use a two-way data table (copies rented across the top, daily demand aloing the side) 19 Copiers rented 20 21 22 23 24 25 Part (b): Use Goal Seek 26 Copiers rented (trial value) 27 Daily demand (trial value) 28 Coples made 29 Annual proft 30 31 32 Part () Use a two-way data table to get data for graph 33 Copiers rented (trial value) 34 Daily demand (trial value) 36 Copies made Annual prof P2-22 Ready 915 Properties Edit Links C 22 D