I know this has been posted before...but, I am having a hard time with the formulas for the excel spreadsheet for (a). The one previous post, had wrong formula.

You are thinking of opening a copy shop. It costs $8000 to rent a copier for a year. It costs 0.023 per copy to operate the copier. Other fixed costs of running the store amount to $600 per month. You charge an average of 0.12 per copy. You are open 365 days per year. Each copier can make up to 150,000 copies per year.

a. Using Excel, construct a two way profit table (number of copies on the left running top to bottom and daily demand on the top running from left to right) for 1 to 5 copiers rented and daily demands of 1000, 1500,2000,2500 copies per day. That is Compute annual profit for each of these combinations of copiers rented and daily demand.

b. Given that you rent three copiers, what daily demand for copies will allow you to break even? Draw a break even graph to show this break even relationship.