G24 - Number Retail Gross i Totoost Unit 4 5 6 7 Power Blocks Urban Adventure Set Turbo Action kot Power Blocks Outdoor Kit Camping Kit Purchas Retail ed Price 5000 $ 19.95 1000 $14.95 2500 $ 16.95 1200 $11.95 9700 Gross Revenue $ 99.750.00 $ 14,950.00 $ 42.375.00 $ 14,340.00 Unit Cost $ 15.36 $ 14.21 $ 13.77 $ 10.03 Total Unit Cost $ 76,800.00 $ 14,210.00 $ 34,425.00 $ 12,036.00 Storage Total Cost per Storage Unit Cost Total Cost Profit $ 0.15 S 750.00 $ 77,550.00 $ 22,200.00 S 0.10 S 100.00 $ 14,310.00 S 640,00 $ 0.25 $ 625.00 $ 35,050.00 $ 7.325.00 S 0.15 $ 180.00 $ 12,216.00 $ 2,124.00 Total $ 139,126.00 S 32,289.00 10 11 Q1: Brightstar Toy company is promoting its product: Power Blocks toy series. As a marketing director, you are to compare scenarios of different marketing 12 strategies 19 (1) Apply appropriate names to cells B4:07 (2 points) (2) Using the Scenario Table below, create scenarios for promoting Adventure Set," "Turbo Kit," or "Camping Kit." (5 points) (3) Generate Senario Summary Report on a separate worksheet), (2 points) (4) Which scenario is most profitable? Write answer in the cell F20 as either "Set," "Turbo," or "Camping" (in F20 of this sheet: 3 points) Fish SS OU 21 22 Num. Set 23 Num Turbo Kit 24 Num Outdoor Kit 25 Num Camping Kit 26 Price Set 27 Price Turbo 28 Price Outdoor 29 Pricec Camping 30 Set 5000 1000 2500 1200 19.95 14.95 16.95 11.95 Scenario Turbo Camping 4000 4000 30000 10001 2500 2500 1200 2000 $ 24.95 $ 24.95 $ 12.95 $ 14.95 $ 16.95 $ 14.95 $11.95 $ 9.95 EESTI . $ I $ $ $ Les as Instructions ANSANSA wers ANSI AN A N