Question: Giacomi & Jackowitz estimates that the cost of developing each new radio commercial would be $ 5 0 , 0 0 0 , and that
Giacomi & Jackowitz estimates that the cost of developing each new radio commercial would be $ and that the expected number of exposures per commercial would be The firm has determined that spots are available for different radio commercials, and each one would cost $ for a normal run.
a Formulate and solve a spreadsheet model for the revised advertisingmix problem that includes this fourth advertising medium. Identify the data cells, the changing cells, and the objective cell. Also show the Ex'cel equation for each output cell expressed as a SUMPRODUCT function.
b Indicate why this spreadsheet model is a linear programming model.
c Express this model in algebraic form.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
