The Win Big Gambling Club promotes gambling junkets from a large Midwestern city to casinos in the Bahamas. The club has budgeted up to $$8,000$ per week for local advertising. The money is to be allocated among four promotional media: TV spots, newspaper ads, and two types of radio advertisements. Win Big$$s goal is to reach the largest possible high$-$potential audience through the various media. The following table presents the number of potential gamblers reached by making use of an advertisement in each of the four media. It also provides the cost per advertisement placed and the maximum number of ads that can be purchased per week.

Medium Audience Cost Per Ad Maximum Ads

Reached Per AD per Week

Tv spot $(1$ minute$)5,00080012$

Daily newspaper $($fullpage

ad$)8,5009255$

Radio spot $(30$ seconds,

primetime$)2,40029025$

Radio spot $(1$minute

afternoon$)2,80038020$

Win Big$$s Contractual arrangements require that at least $5$ radio spots be placed each week. To

ensure a broad scoped promotional campaign, management also insists that no more than $$1,800$ be spent on radio advertising every week.

Microsoft Excel $12\mathrm{.}0$ Answer Report

Target Cell $($Max$)$

Cell Name Original Value Final Value

$F$$6$ Audience $067240\mathrm{.}30$

Adjustable Cells

Cell Name Original Value Final Value

$B$$5$ number of units TV spots $01\mathrm{.}968$

$C$$5$ number of units news paper ads $05$

$D$$5$ number of units prime time ads $06\mathrm{.}206$

$E$$5$ number of units afternoon spots $00$

Constraints

Cell Name Cell Value Formula Status Slack

$F$$14$ min radio spots $6\mathrm{.}207$ $F$$14>=$$H$$14$ Not Binding $1\mathrm{.}207$

$F$$8$ max tv $1\mathrm{.}969$ $F$$8<=$$H$$8$ Not Binding $10\mathrm{.}031$

$F$$9$ max news paper $5$ $F$$9<=$$H$$9$ Binding $0$

$F$$10$ max prime time radio $6\mathrm{.}207$ $F$$10<=$$H$$10$ Not Binding $????$

$F$$11$ max afternoon radio $0$ $F$$11<=$$H$$11$ Not Binding $20$

$F$$12$ budget $8000$ $F$$12<=$$H$$12$ Binding $0$

$F$$13$ max radio$ $1800$ $F$$13<=$$H$$13$ Binding $0$

Microsoft Excel $12\mathrm{.}0$ Sensitivity Report

Adjustable Cells

Final Reduced Objective Allowable Allowable

Cell Name Value Cost Coefficient Increase Decrease

$B$$5$ number of units Tv spots $1\mathrm{.}96875050001620\mathrm{.}685000$

$C$$5$ number of units news paper ads $5085001$E$+302718\mathrm{.}75$

$D$$5$ number of units prime time ads $6\mathrm{.}206896552024001$E$+30263\mathrm{.}157$

$E$$5$ number of units afternoon spots $0-344\mathrm{.}82758622800344\mathrm{.}821$E$+30$

Constraints

Final Shadow Constraint Allowable Allowable

Cell Name Value Price R$.$H$.$ Side Increase Decrease

$F$$14$ min radio spots $6\mathrm{.}206896552051\mathrm{.}2061$E$+30$

$F$$8$ max tv $1\mathrm{.}968750121$E$+3010\mathrm{.}031$

$F$$9$ max news paper $52718\mathrm{.}7551\mathrm{.}7025$

$F$$10$ max prime time radio $6\mathrm{.}2068965520251$E$+3018\mathrm{.}79$

$F$$11$ max afternoon radio $00201$E$+3020$

$F$$12$ budget $80006\mathrm{.}25800080251575$

$F$$13$ max radio$ $18002\mathrm{.}02518001575350$

Answer the following questions $($a$-$i$)$ using the output please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown Question f$)$ What is the situation maximum radio budget is now $1500$ instead of $1800?$