Week 3 Data Assignment: Using Form Controls Objective: In this exercise you will modify an existing spreadsheet model by adding form controls. This will allow the end user to consider a variety of scenarios for decision variables, uncertain variables, and given inputs. What you need: 1. You should have a computer with a working version of Microsoft Excel. 2. Your file for the Week 2 Data Assignment with a completed spreadsheet model Assignment/Activity: 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 a 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. a) Create a 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. b) Create a 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. c) Create a 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 S0.01 increments. d) Important: At least one of the form controls you design in a), b), or c) should be a Combo Box or a List Box. e) 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. a) Create a 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. b) Create a 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. c) Create a 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. d) Important: At least one of the form controls you design in a), b), or c) should be a Combo Box or a List Box. e) 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. Optional: If you want more practice you can create form controls to allow the user to change the rental cost per copier, monthly store cost, cost per copy, maximum copies per copier, and number of days per year the store is open. You could also use a button and record a macro to clear the sheet for the user. This part will not be graded, but as I said, you can use it for more practice. Your submission: You should submit an Excel file with your spreadsheet model and the new form you created for the user to calculate profit. All parts (a-e) should be on the same sheet. Make sure the new form for the user is clearly organized and looks professional. Your grade will be calculated by 8 points per form control (a-c), 8 points for correct output (e), and 8 points for the form having a professional appearance and user-friendly. Professional appearance means that any extra calculations or lists that you