Please show how to solve this using the Solver tool in Excel.

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? b. What is the number of units produced to cover demand for High Flyer disks? C. What is the net income for Tournament disks? d. What is number of units sold based on advertising for Supreme disks? e. What Excel feature did you use to answer these questions? B D E F Regular 2100 689 2789 $12.00 $33,470.73 High Flyer 2050 689 2739 $20.00 $54,784.55 Tournament Supreme Total 1750 1000 6900 689 689 2757 2439 1689 9657 $24.00 $32.00 $22.00 $58,541.46 $54,055.28 $200,852.03 2 3 Revenue 4 Units Sold Based on Word of Mouth 5 Units Sold Based on Advertising 6 Total Units Sold 7 Price per Unit 8 Total 9 10 Variable Expenses 11 Units Produced To Cover Demand 12 Cost per Unit 13 Total 14 15 Fixed Expenses 16 Insurance and maintenance 17 Other Overhead 18 Advertising 19 Total 20 21 Income Summary 22 Total Revenue 23 Total Expenses 24 Net Income 25 Regular 3,068.15 $5.00 $15,340.75 High Flyer 3,013.15 $10.00 $30, 131.50 Tournament Supreme Total 2,683.15 1,858.15 10,622.60 $16.00 $20.00 $12.75 $42,930.41 $37,163.01 $125,565.67 Regular $3,000.00 $6,000.00 $2,000.00 $11,000.00 High Flyer $5,000.00 $8,500.00 $2,000.00 $15,500.00 Tournament Supreme $6,000.00 $10,000.00 $12,000.00 $18,000.00 $2,000.00 $2,000.00 $20,000.00 $30,000.00 Total $24,000.00 $44,500.00 $8,000.00 $76,500.00 Regular $33,470.73 $26,340.75 $7,129.98 High Flyer $54,784.55 $45,631.50 $9.153.05 Tournament Supreme Total $58,541.46 $54,055.28 $200,852.03 $62,930.41 $67,163.01 $202,065.67 ($4,388.94) ($13,107.72) ($1,213.64) 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? b. What is the number of units produced to cover demand for High Flyer disks? C. What is the net income for Tournament disks? d. What is number of units sold based on advertising for Supreme disks? e. What Excel feature did you use to answer these questions? B D E F Regular 2100 689 2789 $12.00 $33,470.73 High Flyer 2050 689 2739 $20.00 $54,784.55 Tournament Supreme Total 1750 1000 6900 689 689 2757 2439 1689 9657 $24.00 $32.00 $22.00 $58,541.46 $54,055.28 $200,852.03 2 3 Revenue 4 Units Sold Based on Word of Mouth 5 Units Sold Based on Advertising 6 Total Units Sold 7 Price per Unit 8 Total 9 10 Variable Expenses 11 Units Produced To Cover Demand 12 Cost per Unit 13 Total 14 15 Fixed Expenses 16 Insurance and maintenance 17 Other Overhead 18 Advertising 19 Total 20 21 Income Summary 22 Total Revenue 23 Total Expenses 24 Net Income 25 Regular 3,068.15 $5.00 $15,340.75 High Flyer 3,013.15 $10.00 $30, 131.50 Tournament Supreme Total 2,683.15 1,858.15 10,622.60 $16.00 $20.00 $12.75 $42,930.41 $37,163.01 $125,565.67 Regular $3,000.00 $6,000.00 $2,000.00 $11,000.00 High Flyer $5,000.00 $8,500.00 $2,000.00 $15,500.00 Tournament Supreme $6,000.00 $10,000.00 $12,000.00 $18,000.00 $2,000.00 $2,000.00 $20,000.00 $30,000.00 Total $24,000.00 $44,500.00 $8,000.00 $76,500.00 Regular $33,470.73 $26,340.75 $7,129.98 High Flyer $54,784.55 $45,631.50 $9.153.05 Tournament Supreme Total $58,541.46 $54,055.28 $200,852.03 $62,930.41 $67,163.01 $202,065.67 ($4,388.94) ($13,107.72) ($1,213.64)