Question: Output: On the same sheet as the form controls that you have created, you should use the spreadsheet model to calculate the following annual values:
Output: On the same sheet as the form controls that you have created, you should use the spreadsheet model to calculate the following annual values: Total Copies Sold, Total Revenue, Cost of Copier Rental, Cost of Store, Cost of Copies, Total Profit.
| Given Information: | ||||||
| Copier Rental | 5000 | per year | ||||
| Store Cost | 4800 | per year | ||||
| Price | 0.02 | per copy | ||||
| Variable Cost | 0.03 | per copy | ||||
| Max Production per Copier | 100000 | copies | ||||
| Days Business is Open | 365 | days | ||||
| Decision Variable: | ||||||
| # of Copiers to Rent | 5 | copiers | ||||
| Uncertain Variable: | ||||||
| Daily Demand | 1500 | copies per day | ||||
| Workspace: Calculate Annual Copies Sold | ||||||
| Maximum Annual Production | 500000 | |||||
| Estimated Annual Demand | 547500 | |||||
| Actual Amount of Copies Sold | 500000 | |||||
| Objective: Calculate Annual Profits | ||||||
| Revenue | 10000 | |||||
| Store Costs | 44800 | |||||
| Total Copier Rental Cost | 5000 | |||||
| Total Variable Cost | 9000 | |||||
| Profit | -34800 | |||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
