Excel HW 2_Bruin Ski Magazine Campaign (2).xIsx [Protected View] - Excel File Home Insert Page Layout Formulas Data Review View Tell me what you want to do.. Woods Nathan & Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A21 X fx 1. How many total ads were placed for this promotion? B Belmont Outdoors - Bruin Ski Magazine Ad Campaign D E G H K N - M N Ad Placement Ad Cost per Issues per 3 Media (Number of Total Circulation Issue Year Issues 4 extreme Skis Audience Total Cost 548,945 $ 39,000.00 6.00 5 Ski Quarterly 864,532 $41,000.00 4.00 6 Slopes Monthly 229,491 $26,000.00 12.00 7 Downhill - 4 - Real 398,054 $ 35,000.00 6.00 8 Ski Magazine 257,092 $ 31,000.00 12.00 9 Total 10 11 Objective: Minimize Total Cost Min G9 12 INSTRUCTIONS: 13 Constraints 14 Total audience (F9) 12,000,000 Roberto Lamberto, marketing manager, is heading up a magazine promotion for Belmont Outdoors. Roberto will use 15 Ad placement E4:E8 2 the same ad in each of five magazines that he has selected as representing the primary target audience. Roberto has 16 Ad placement E4:E8 > ") ) DD Ready 32:57 32:47 MacBook Pro -00:11 esc 32:47 $ %