Excel Exercise Task:
12 fr A B D E F G H J K L M N o 1 Power Blocks Purchasing Plan $ 2 Number Storage Total Purchas Retail Gross Total Unit Cost per Storage 3 ed Price Revenue Unit Cost Cost Unit Cost Total Cost Profit 4 Power Blocks Urban Adventure Set 5000 $19.95 $ 99,750.00 $ 15.36 $ 76,800.00 $ 0.15 $ 750.00 $ 77,550.00 $ 22,200.00 5 Turbo Action Kit 1000 $14.95 $ 14,950.00 $ 14.21 $ 14,210.00 0.10 $ 100.00 $ 14,310.00 $ 640.00 6 Power Blocks Camping Kit 2500 $16.95 $ 42,375.00 $ 13.77 $ 34,425.00 $ 0.25 $ 625.00 $ 35,050.00 $ 7,325.00 7 Outdoor Kit 1200 $11.95 $ 14,340.00 $ 10.03 $ 12,036.00 $ 0.15 $ 180.00 $ 12,216.00 $ 2,124.00 8 Total 9700 63.8 $ 171,415.00 $137,471.00 $1,655.00 $ 139,126.00 $ 32,289.00 9 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 12 marketing strategies. 13 (1) Define appropriate names to cells B4:07 and J8 (2 points) 14 (2) Using the data in Scenario Table below, create 4 scenarios for promoting "Set," "Turbo," "Camping," and "Outdoor." (5 points) 15 (3) Generate Senario Summary Report (on a separate worksheet with J8 as output). (2 points) 16 17 (4) Which scenario is most profitable? Write answer in the cell G20 as either "Set," "Turbo," "Camping," or "Outdoor" (3 points) 18 19 12 K L M N O A B C D E F G H 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 12 marketing strategies. 13 (1) Define appropriate names to cells B4:07 and 18 (2 points) 14 (2) Using the data in Scenario Table below, create 4 scenarios for promoting "Set," "Turbo," "Camping," and "Outdoor." (5 points) 15 16 (3) Generate Senario Summary Report (on a separate worksheet with J8 as output). (2 points) 17 (4) Which scenario is most profitable? Write answer in the cell G20 as either "Set," "Turbo," "Camping," or "Outdoor" (3 points) 18 19 20 Scenario Table Scenario Ans: 21 Changing Cells Set Turbo Camping Outdoor 22 5000 4000 4000 4000 23 1000 3000 1000 1000 24 2500 2500 3000 2500 25 1200 1200 1200 2000 26 Total Sales Units $ 19.95 $24.95 $ 24.95 $ 24.95 27 $ 14.95 $12.95 $ 14.95 $ 14.95 28 $ 16.95 $16.95 $ 14.95 $ 16.95 29 $ 11.95 $11.95 $ 11.95 $ 9.95 30 31 32 12 fr A B D E F G H J K L M N o 1 Power Blocks Purchasing Plan $ 2 Number Storage Total Purchas Retail Gross Total Unit Cost per Storage 3 ed Price Revenue Unit Cost Cost Unit Cost Total Cost Profit 4 Power Blocks Urban Adventure Set 5000 $19.95 $ 99,750.00 $ 15.36 $ 76,800.00 $ 0.15 $ 750.00 $ 77,550.00 $ 22,200.00 5 Turbo Action Kit 1000 $14.95 $ 14,950.00 $ 14.21 $ 14,210.00 0.10 $ 100.00 $ 14,310.00 $ 640.00 6 Power Blocks Camping Kit 2500 $16.95 $ 42,375.00 $ 13.77 $ 34,425.00 $ 0.25 $ 625.00 $ 35,050.00 $ 7,325.00 7 Outdoor Kit 1200 $11.95 $ 14,340.00 $ 10.03 $ 12,036.00 $ 0.15 $ 180.00 $ 12,216.00 $ 2,124.00 8 Total 9700 63.8 $ 171,415.00 $137,471.00 $1,655.00 $ 139,126.00 $ 32,289.00 9 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 12 marketing strategies. 13 (1) Define appropriate names to cells B4:07 and J8 (2 points) 14 (2) Using the data in Scenario Table below, create 4 scenarios for promoting "Set," "Turbo," "Camping," and "Outdoor." (5 points) 15 (3) Generate Senario Summary Report (on a separate worksheet with J8 as output). (2 points) 16 17 (4) Which scenario is most profitable? Write answer in the cell G20 as either "Set," "Turbo," "Camping," or "Outdoor" (3 points) 18 19 12 K L M N O A B C D E F G H 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 12 marketing strategies. 13 (1) Define appropriate names to cells B4:07 and 18 (2 points) 14 (2) Using the data in Scenario Table below, create 4 scenarios for promoting "Set," "Turbo," "Camping," and "Outdoor." (5 points) 15 16 (3) Generate Senario Summary Report (on a separate worksheet with J8 as output). (2 points) 17 (4) Which scenario is most profitable? Write answer in the cell G20 as either "Set," "Turbo," "Camping," or "Outdoor" (3 points) 18 19 20 Scenario Table Scenario Ans: 21 Changing Cells Set Turbo Camping Outdoor 22 5000 4000 4000 4000 23 1000 3000 1000 1000 24 2500 2500 3000 2500 25 1200 1200 1200 2000 26 Total Sales Units $ 19.95 $24.95 $ 24.95 $ 24.95 27 $ 14.95 $12.95 $ 14.95 $ 14.95 28 $ 16.95 $16.95 $ 14.95 $ 16.95 29 $ 11.95 $11.95 $ 11.95 $ 9.95 30 31 32
