Problem #2 Create a scenario summary for Sean's Swim Shack using the season sales forecasts. Use scenario manager to create a summary page for the Spring Break, Summer Vacations, and Winter Holiday Scenarios. The changing cells will be the quantity for Swimsuits, Swim Trunks, and Life Vests. Your results should be Revenue and Total Profit. The scenario summary should look professional. Information Spring Break Summer Vacations Winter Holiday Swimsuits 250 500 300 Swim Trunks 100 350 200 Life Vests 20 300 150 B D E Revenue Quantity 1000 78 46 79 1 Sean's Swim Shack 2 Assignment 3 Swimsuits 4 Floaties 5 Cooler 6 Water Skis 7 Boogie Board 8 Swim Trunks 9 Swim Shoes 10 Life Vest 11 Waterproof Speaker 12 Bucket Hats 13 Total Profit 120 Profit Margin Profit 12% $12,000 4% $265 10% $690 13% $963 3% $72 11% $22,000 23% $1,553 6% $6,825 5% $100 13% $1,300 $45,768 $100,000 $6,630 $6,900 $7,410 $2,400 $200,000 $6,750 $113,750 $2,000 $10,000 $455,840 400 90 325 100 50 Problem #2 Create a scenario summary for Sean's Swim Shack using the season sales forecasts. Use scenario manager to create a summary page for the Spring Break, Summer Vacations, and Winter Holiday Scenarios. The changing cells will be the quantity for Swimsuits, Swim Trunks, and Life Vests. Your results should be Revenue and Total Profit. The scenario summary should look professional. Information Spring Break Summer Vacations Winter Holiday Swimsuits 250 500 300 Swim Trunks 100 350 200 Life Vests 20 300 150 B D E Revenue Quantity 1000 78 46 79 1 Sean's Swim Shack 2 Assignment 3 Swimsuits 4 Floaties 5 Cooler 6 Water Skis 7 Boogie Board 8 Swim Trunks 9 Swim Shoes 10 Life Vest 11 Waterproof Speaker 12 Bucket Hats 13 Total Profit 120 Profit Margin Profit 12% $12,000 4% $265 10% $690 13% $963 3% $72 11% $22,000 23% $1,553 6% $6,825 5% $100 13% $1,300 $45,768 $100,000 $6,630 $6,900 $7,410 $2,400 $200,000 $6,750 $113,750 $2,000 $10,000 $455,840 400 90 325 100 50