Reference no: EM133243024

You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $4800 per year. You plan to charge a price of $0.10 per copy, and the store will be open 365 days per year. Each copier has a maximum capacity of 100,000 copies per year.

This assignment is a continuation of the Week 2 Data Assignment. You will be adding form controls to the spreadsheet model you created for Week 2 Data Assignment. It is probably easiest to work from the spreadsheet model you created in Part 1 of that assignment.  You should create new sheet within the workbook to produce this new user friendly form.  This sheet should contain all form controls and an output section with several key measures of success for the business.

1. Create form control to allow the user to consider several possible values for the number of copiers rented. The form should allow the user to consider from 1 up to 8 copiers rented.
2. Create form control to allow the user to consider several possible values for the daily demand for copies.  The form should allow the user to consider from 0 up to 2000 copies as values of daily demand, measured in intervals of 250 copies.
3. Create form control to allow the user to consider several possible values for the price of copies. The form should allow the user to consider values from $0.01 to $0.10, measured in $0.01 increments.
4. Important:  At least one of the form controls you design in a), b), or c) should be a Combo Box or a List Box.
5. 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.