Use the worksheets Disks and Advertising Model for this problem. Disks, Inc, sells several types of professional Frisbee disks. Mike Smith, the general manager of the company has created an Income statement, based on the various data he has, in the worksheet named Disks. The Advertising Model worksheet shows how many units of the disks cap be sold for different levels of advertising. Using Excel DSS capabilities, help Mike answer the following questions. 1. Mike Smith wants to know how the Insurance \& Maintenance (I\&M) expenses for Regular disks impacts the net income for Regular disks. The 18M expenses can vary between $3500 and $5000 (assume step size of $250 ) and the price per unit of Regular disks can vary between $12 and $24 (assume step size of \$2). Show the net income values for Regular disks under the various combinations of 18M expenses and price per unit as above? a. What is the net income for Regular disks when I\&M expense is $4500 and price per unit is $18 ? (6 points) b. What Excel feature did you use to answer this question? (2 points) 2. Mike wants to determine the impact of different advertising approaches and answer the following questions: a. How many units of Tournament disks should be sold by Word of Mouth in order for this disk type to break even? (6 points) b. What should the Price per Unit be set at in order for the Supreme disks to break even? (6 points) c. What Excel feature did you use to answer these questions? ( 2 points) 3. If any of the cell values had changed by working on problem 2 revert to the original values by clicking Undo. Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i.e., for Disks, Inc.)? The constraints are as follows. The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type. But, the company can only make a maximum of 5000 Supreme disks to sell. Mr. Smith also wants none of the individual disk types to make a loss. a. What is the amount spent on advertising for each disk type? (6 points) b. What is the number of units produced to cover demand for High Flyer disks? (6 points) c. What is the net income for Tournament disks? (6 points) d. What is number of units sold based on advertising for Supreme disks? (6 points) e. What Excel feature did you use to answer these questions? (2 points) AS fx Units Sold Based on Advertising