Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started