$\backslash$table$[[$Revenue$,$Regular,High Flyer,Tournament,Supreme,Total$],[$Units Sold Based on Word of Mouth,$2100,2050,1750,1000,6900],[$Units Sold Based on Advertising,$205,205,205,205,822],[$Total Units Sold,$2305,2255,1955,1205,7722],[$Price per Unit,$$12\mathrm{.}00,$$$20\mathrm{.}00,$$$24\mathrm{.}00,$$$32\mathrm{.}00,$$$22\mathrm{.}00],[$Total$,$$$27,664\mathrm{.}60,$$$45,107\mathrm{.}67,$$$46,929\mathrm{.}21,$$$38,572\mathrm{.}28,$$$158,273\mathrm{.}76]]$

$\backslash$table$[[$Variable Expenses,Regular,High Flyer,Tournament,Supreme,Total$],[$Units Produced To Cover Demand,$2,535\mathrm{.}92,2,480\mathrm{.}92,2,150\mathrm{.}92,1,325\mathrm{.}92,8,493\mathrm{.}69],[$Cost per Unit,$$5\mathrm{.}00,$$$10\mathrm{.}00,$$$16\mathrm{.}00,$$$20\mathrm{.}00,$$$12\mathrm{.}75],[$Total$,$$$12,679\mathrm{.}61,$$$24,809\mathrm{.}22,$$$34,414\mathrm{.}75,$$$26,518\mathrm{.}44,$$$98,422\mathrm{.}02]]$

$\backslash$table$[[$Fixed Expenses,Regular,High Flyer,Tournament,Supreme,Total$],[$Insurance and maintenance,$$3,000\mathrm{.}00,$$$5,000\mathrm{.}00,$$$6,000\mathrm{.}00,$$$10,000\mathrm{.}00,$$$24,000\mathrm{.}00],[$Other Overhead,$$6,000\mathrm{.}00,$$$8,500\mathrm{.}00,$$$12,000\mathrm{.}00,$$$18,000\mathrm{.}00,$$$44,500\mathrm{.}00],[$Advertising$,$$$1,000\mathrm{.}00,$$$1,000\mathrm{.}00,$$$1,000\mathrm{.}00,$$$1,000\mathrm{.}00,$$$4,000\mathrm{.}00],[$Total$,$$$10,000\mathrm{.}00,$$$14,500\mathrm{.}00,$$$19,000\mathrm{.}00,$$$29,000\mathrm{.}00,$$$72,500\mathrm{.}00]]$

$\backslash$table$[[$Income Summary,Regular,High Flyer,Tournament,Supreme,Total$],[$Total Revenue,$$27,664\mathrm{.}60,$$$45,107\mathrm{.}67,$$$46,929\mathrm{.}21,$$$38,572\mathrm{.}28,$$$158,273\mathrm{.}76],[$Total Expenses,$$22,679\mathrm{.}61,$$$39,309\mathrm{.}22,$$$53,414\mathrm{.}75,$$$55,518\mathrm{.}44,$$$170,922\mathrm{.}02],[$Net Income,$$4,984\mathrm{.}99,$$$5,798\mathrm{.}45,($$$6,485\mathrm{.}54),($$$16,946\mathrm{.}16),($$$12,648\mathrm{.}26)]]$ Solver Results$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 $islimitedto$ $$15000$ and the company wants $to$ spend $at$ least $$2000$ towards promoting each disk type. But, the company can only make a maximum $of5000$ 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?

solver

I keep getting the following error message in excel. Please help!!!To:

Max

By Changing Variable Cells:

$B$$18$:$E$$18$

Subject to the Constraints:

$$$$$5$:$$E$$$52000$

$$E$$$65000$

$$$$1815000$

$F$$24$

Min

Value Of:

Change

Delete

Reset All

Load$/$Save

Make Unconstrained Variables Non$-$Negative

Select a Solving

Method:

GRG Nonlinear

Solving Method

Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex

engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are

non$-$smooth.