please help with #22 which is the highlighted question using the excel template below

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 $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 pat. Due to electric rights, third party con may bed from the Book andor Che R 61 / fix A 8 Copy shop Inputs $5,000 Yearly rental cost Other monthly fixed costs $400 Cost per copy $0.03 Charge per copy $0.10 Days per year 365 9 Months per year 12 100000 10 Copies per copier per year 11 12 Profit model 13 Copiers rented (trial value) 14 Daily demand 3 1000 (trial value) 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 24 25 Part (b): Use Goal Seek clu 26 Copiers rented (trial value) 27 Daily demand (trial value) 28 Coples made Sub 29 Annual profit 30 Acc 31 MAT 32 Part (c) Use a two-way data table to get data for graph 33 Copiers rented (trial value) MG 34 Dally demand (trial value) MKT 35 Copies made 36 Annual profit 37 gradu P2-20 P2-22 + Ready Attempted Eamed GPA Hours Quality Points GPA 22 F1 900 21 22 23 80 C D DHI E all Mac