You are thinking of opening a copy shop. It costs $10,000 to rent a copier for a year. It costs $0.025 per copy to operate the copier. Other fixed costs of running the store amount to $600 per month. You charge an average of $0.15 per copy. You are open 365 days per year. Each copier can make up to 150,000 copies per year. Demand could range between 500 to 2000 copies per day.

a. What are the input variables?
b. What are the output variables?
c. What variables are most subject to uncertainty?
d. For this question, your breakeven number will not be a whole number; please round your breakeven number up to the next whole number. What is the number of copiers required to breakeven for a demand of 500 copies per day? What is the number of copiers required to breakeven for a demand of 2000 copies per day?

e. Setup a spreadsheet to compute ANNUAL profit.
1. In Excel, use the "Define Name" or "Create from Selection" to label cells.
2. Spreadsheet creation/design. Hint: you should have an "=IF" statement that considers the relation between ANNUAL DEMAND and ANNUAL CAPACITY.
3. You should create a two-way data table to compute the profit for 1, 2, 3, 4, or 5 copiers and demands of 500, 1000, 1500, or 2000 copies per day.
f. Write a brief report using the following sections:
1. Describe the purpose of the analysis.
2. Describe the analysis and the key variables.
3. Summarize your findings.
4. If this decision were yours, would you start this business? Why or why not? Be practical, use your analysis, be creative, be greedy.
g. 10 Bonus points for creativity.