Giacomi & Jackowitz suggests giving consideration to running commercials for Crunchy Start on nationally syndicated radio programs. Giacomi & Jackowitz estimates that cost of development each radio commercial would be $50,000. And exposures per commercial would be $90,000. The firm has determine that 10 spots are available or different radio commercials, and each one would cost $200,000 for normal run.
A. formulates and solve spreadsheet model for revised advertising mix-problem that includes this fourth advertising medium. Identify data cells, changing cells, and objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function.
B. indicates why spreadsheet model is a linear programming model.
Express this model in algebraic form.