Problem 2
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 can 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 I&M 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 I&M 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?
b. What Excel feature did you use to answer this question?