RevisedSuperGrain - 0.2 0.2 5.85 >= 5...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Super Grain Corp. Advertising-Mix Problem TV Spots Magazine Ads SS Ads Range Name Cells Exposures per Ad 1,300 600 500 BudgetAvailable H7:H8 (thousands) BudgetSpent F7:F8 Cost per Ad ($thousands) Budget Spent Budget Available CostPerAd C7:E8 Ad Budget 300 150 100 3,775 <= 4,000 CouponRedemptionPerAd C15:E15 Planning Budget 90 30 40 1,000 <= 1,000 ExposuresPerAd C4:E4 MaxTVSpots C21 Number Reached per Ad (millions) Total Reached Minimum Acceptable MinimumAcceptable H11:H12 Young Children 1.2 0.1 0 5 >= 5 NumberOfAds C19:E19 Parents of Young Children 0.5
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.2 0.2 5.85 &gt;= 5 NumberReachedPerAd C11:E12 RequiredAmount H15 TV Spots Magazine Ads SS Ads Total Redeemed Required Amount TotalExposures H19 Coupon Redemption per Ad 40 120 1,490 = 1,490 TotalReached F11:F12 ($thousands) TotalRedeemed F15 Total Exposures TVSpots C19 TV Spots Magazine Ads SS Ads (thousands) Number of Ads 3 14 7.75 16,175 &lt;= Maximum TV Spots 5 A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21...
View Full Document

This note was uploaded on 04/21/2009 for the course BUS 338W-1 taught by Professor White during the Winter '09 term at University of Michigan-Dearborn.

Ask a homework question - tutors are online