| Copy shop |
| Inputs |
| Yearly rental cost |
| Other monthly fixed costs |
| Cost per copy |
| Charge per copy |
| Days per year |
| Months per year |
| Copies per copier per year |
| Profit model |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
| Part (a): Use a two-way data table (copies rented across the top, daily demand aloing the side) |
| Part (b): Use Goal Seek |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
| Part (c): Use a two-way data table to get data for graph |
| Copiers rented (trial value) |
| Daily demand (trial value) |
| Copies made |
| Annual profit |
Mark3433
Question.xlsx
