Problem #2: Analysing Cond he show your world by Madden the design The marketing manager of Busch, egonal grocery store in Michigan wants to evaluate the effective owning campaign for a store brand beakfast cereal named Crispy Hexago. The cercalo purchased from Kollege Company Bal Check Michigan packaged with Beschis same and lopo. He has thered data from the Novi store over the last 12 The data is precated box sendes 1 5507 11.210 2 11.30 3 5190 11.10 4 5923 12,00 3 5338 6 5507 11.40 $325 10:20 $1.053 9 10 572 11. 11 5936 11,70 12 51,092 11910 S SI1577 The cord structure for a package of Crispy bagoes without the advertising is presented below selling price purchase price 53.30 52.60 More management alories 30.12 Nore utilities and in me [ en depreciation 50.16 store lease 50.29 operating income How many additional boxes of cereale sold per dollar oladvertising? This is copine to the show your rulle", you will have to bard code the mower into the box at the right points) (2) Whil is the baseline sales volumebores pr cercal) without advertising? This is an exceptie your work rule." you will have to hand code your answer into the box at the right perinta) 3) How much profit does an additional dollar of highet? (3) What is the incremental revenue derived from one additional dollar of advertising? (2 points) (4) How much profit does an additional dollar of advertising generate? (2 points) (5) How many additional boxes of cereal must a dollar of advertising generate in order for the advertising to be profitable? (4 points) The marketing manager of Busch's, a regional grocery store in Michigan, wants to evaluate the effectiveness of a newspaper advertising campaign for a store brand breakfast cereal named Crispy Hexagons. The cercal is purchased from Kellogg Company in Battle CrockMichigan and packaged with Busch's name and logo. He has gathered data from the Nori store over the last 12 weeks. The data is presented below. wack advertising sales in boxes 1 5507 11,210 2 S793 11.880 3 5390 11.160 5923 12,080 5 5338 11,290 6 $507 11.430 7 $325 10,970 8 $1.053 12.030 9 5689 11.420 10 5728 11,760 11 $936 11,780 12 $1,092 11,910 average S690 $11.577 The cost structure for a package of Crispy hexagons without the advertising is presented below selling price $130 purchase price S2.60 store management salaries $0.12 $0.27 $0.36 store utilities and insurance equipment depreciation store lease operating income $0.29 -50.34 (1) How many additional boxes of cereal are sold per dollar of advertising? This is an exception to the show your work rule", you will have to hard code the answer into the box at the right points) Problem #2: Analysing Cond he show your world by Madden the design The marketing manager of Busch, egonal grocery store in Michigan wants to evaluate the effective owning campaign for a store brand beakfast cereal named Crispy Hexago. The cercalo purchased from Kollege Company Bal Check Michigan packaged with Beschis same and lopo. He has thered data from the Novi store over the last 12 The data is precated box sendes 1 5507 11.210 2 11.30 3 5190 11.10 4 5923 12,00 3 5338 6 5507 11.40 $325 10:20 $1.053 9 10 572 11. 11 5936 11,70 12 51,092 11910 S SI1577 The cord structure for a package of Crispy bagoes without the advertising is presented below selling price purchase price 53.30 52.60 More management alories 30.12 Nore utilities and in me [ en depreciation 50.16 store lease 50.29 operating income How many additional boxes of cereale sold per dollar oladvertising? This is copine to the show your rulle", you will have to bard code the mower into the box at the right points) (2) Whil is the baseline sales volumebores pr cercal) without advertising? This is an exceptie your work rule." you will have to hand code your answer into the box at the right perinta) 3) How much profit does an additional dollar of highet? (3) What is the incremental revenue derived from one additional dollar of advertising? (2 points) (4) How much profit does an additional dollar of advertising generate? (2 points) (5) How many additional boxes of cereal must a dollar of advertising generate in order for the advertising to be profitable? (4 points) The marketing manager of Busch's, a regional grocery store in Michigan, wants to evaluate the effectiveness of a newspaper advertising campaign for a store brand breakfast cereal named Crispy Hexagons. The cercal is purchased from Kellogg Company in Battle CrockMichigan and packaged with Busch's name and logo. He has gathered data from the Nori store over the last 12 weeks. The data is presented below. wack advertising sales in boxes 1 5507 11,210 2 S793 11.880 3 5390 11.160 5923 12,080 5 5338 11,290 6 $507 11.430 7 $325 10,970 8 $1.053 12.030 9 5689 11.420 10 5728 11,760 11 $936 11,780 12 $1,092 11,910 average S690 $11.577 The cost structure for a package of Crispy hexagons without the advertising is presented below selling price $130 purchase price S2.60 store management salaries $0.12 $0.27 $0.36 store utilities and insurance equipment depreciation store lease operating income $0.29 -50.34 (1) How many additional boxes of cereal are sold per dollar of advertising? This is an exception to the show your work rule", you will have to hard code the answer into the box at the right points)
