If everything could be chekced that would be great, but mainly parts c, d, e, & f. Thank you!!

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.Modifications to problem #22 #1. Use problem description of #22 from the textbook (70 points) Assume that the variable cost to make copies stars at 5 cents if the daily volume is on average below 200. Then, assume that the variable dost for the following questions (al to ifl, Ignore the questions from the text Set up a model for annual profit. (40 points] making copies goes down by 0.5 cents per copy for every additional 200 Do not after the structure of this Excel Mile like adding/ deleting columns/rows, moving contents from their Yearly rental cost per copier variable cost for making cost is $0 05 if the average number of copjes made cells, or renaming sheet names. Use the specified output cell range. You may change the column widths $5,000.00 Variable cost ney now for copies made per day de per day on average, up to 1000 copies. In other words, the slightly to accommodate proper formatting, but changing the widths in a significant manner is prohibited. Other monthly fixed costs $400.00 No. of coples Cost/ copy per day is 0 to 199, $0 045 if it is 200 to 399 coples, etc. Cost per kopy Price per copy SO.10 $0.050 $0.045 remains a flat $0.025 for quantities 1000 and more. Setup the costyable in Not following these Instructions can result in serious loss of points. Days per year 365 200, 400 $0.040 the range E10:F15 and use VLOOKUP in cell C28 to find the cost per copy. All cells In all sheets must be property formatted. These Include allaning conten's, using appropriate Months peryear 12 600 $0.035 number format and decimal places for numerical contents, use of bolding, Italics/ borders, etc. In an Copies per copier per year 140000 SO.030 appropriate fashion so that the readability of the content is enhanced. 1003 Model for profit 50.025 Decision warlab Coplets rented Hints: Cell C18: Enter the number 4 in cell C18 as the initial trial value. 10 ncerain variable Delly demand Cell C21: Enter the number 1000 in cell C21 as the initial trial value Actual copies made Annual capacity 409000 Annual demand 365000 Cell C24: Annual capacity is the number of copies that can be mady given the number of copiers we renting and the number of copies one copler can make per year Actual copies made per year 365000 Cell C25: Annual demand can be determined given the dally demand we have assumed and 365 is the number of days per year stated in the problem. Cell C26: The actual number of copies that are actually made is smaller of the annual demand and annual capacity. Variable cost of making copies person Actual coples made per day 1000 Variable cost of making coples per copy 0.025 Cell C29: The variable cost of making copies is dependent on the al.dual number of copies made per day on average. So, we need to set up the average number of copies made per day. which must be desermined using actual copies made per year and the number of days in a year. cell C30: Use VLOOKUP with " Actual copies made/ day as the look up value and E10:15 as lookup table. Annual Revenue Annual revenue $35,500.00 Cell C33: Annual revenue can be determined using the actual number of copies made per year and the price charged per copy. Annual Cost Mental cost of coples Cell C36: Rental cost of copless tented can be determined using the number of copless vented and the mental cost per coplet. ther monthly fixed costs peryear $4,800.00 37: Other monthly fixed costs peryear can be determined using the given other monthly fixed cost and number of months per year. Variable cost of actual copies made peryear Total cost 39,125.00 cell Cas: Variable cost of actual copies made per year can be determined using the actual copies made peryear and the variable cost per copy. $33,925.00 Annual profit $2,575.00 Answer key: Annual profit = 2575 with 4 for copies meyted and 1000 for daly demand. Annual profit = 1200 with 3 for copies melted and 1500 for daly demand. b. Using Data/ Table determine the annual profit for the number of copless and daly demand given below. (10 points] Number of actual copies along the fist column and daly demand along the top tow 4300 4300 -2800 -2800 4300 4300 1200 2575 1200 Locez 1200 -2425 $200 $200 1200 $200 c. Use Goal Seek to find the break even demand with 3 copless. (5 points) Coplets rented For (c) enter the number 3 for coplets rented in cell CiS and then our Goal seek. Typ Breakeven demand = 84000 and into cell CSS. After running open manfod In cell (13 back in 4 and taly da d. Prepare a line graph profit in Yaxis and number of copies in x-axis. Plot one line for each demand. (5 points) Suppose that the demand follows the probability distribution given below. Determine the expected profits if number of coplets rented is 1, 2, 3, 4, or s. (5 points) Demand 1000 Probability 02 1500 030 0.21 Sum of probabilities -> For the expected profit you must use SUMPRODUCT of probabilities and the profits from (b) (5 points) Prepare a bar chart for the expected profit with the number of coples rented in the x-axis