2. Frank would like to create 3 scenarios that would result in breaking even six months

after opening the store. Make sure to save each scenario and to restore the original

values. After you run the 3 scenarios, he wants you to create a new worksheet with

a summary showing the Profit/Loss by month for the 3 scenarios. The following are

the 3 scenarios that need to be created:

a. Profit $0 by changing the percent growth and cost related to sales.

b. Same as 1 with a constraint that requires the percent growth to be less than

or equal to 10%.

c. Same as 1 with a constraint for the costs related to sales to equal 85%.

Style your worksheet by adjusting column widths and row heights, aligning row and

column headings, formatting values, applying cell shading, and adding borders. Create

appropriate headings and titles. Check that the worksheets will print professionally.

Sales July August September October November December January February March April May June $125,000.00 $137,500.00 $ 151,250.00 $ 166,375.00 $183,012.50 $ 201,313.75 $221,445.13 $243,589.64 $ 267,948.60 $ 294,743.46 $324,217.81 $356,639.59 Expenses: Cost Related To Sales Costs Unreleated to Sales Total Expenses $ 108,750.00 $119,625.00 $131,587.50 $144,746.25 $ 159,220.88 $175,142.96 $ 192,657.26 $ 211,922.98 $233,115.28 $256,426.81 $282,069.49 $310,276.44 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 148,750.00 $ 159,625.00 $171,587.50 $184,746.25 $ 199,220.88 $215,142.96 $ 232,657.26 $251,922.98 $273,115.28 $296,426.81 $322,069.49 $350,276.44 Gross Profit/Loss $ (23,750.00) $ (22,125.00) $ (20,337.50) $ (18,371.25) $ (16,208.38) $ (13,829.21) $ (11,212.13) $ (8,333.35) $ (5,166.68) $ (1,683.35) $ 2,148.31 $ 6,363.15 Required Sales Growth Costs Related to Sales As % of Sales 10% 87% Sales July August September October November December January February March April May June $125,000.00 $137,500.00 $ 151,250.00 $ 166,375.00 $183,012.50 $ 201,313.75 $221,445.13 $243,589.64 $ 267,948.60 $ 294,743.46 $324,217.81 $356,639.59 Expenses: Cost Related To Sales Costs Unreleated to Sales Total Expenses $ 108,750.00 $119,625.00 $131,587.50 $144,746.25 $ 159,220.88 $175,142.96 $ 192,657.26 $ 211,922.98 $233,115.28 $256,426.81 $282,069.49 $310,276.44 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 40,000.00 $ 148,750.00 $ 159,625.00 $171,587.50 $184,746.25 $ 199,220.88 $215,142.96 $ 232,657.26 $251,922.98 $273,115.28 $296,426.81 $322,069.49 $350,276.44 Gross Profit/Loss $ (23,750.00) $ (22,125.00) $ (20,337.50) $ (18,371.25) $ (16,208.38) $ (13,829.21) $ (11,212.13) $ (8,333.35) $ (5,166.68) $ (1,683.35) $ 2,148.31 $ 6,363.15 Required Sales Growth Costs Related to Sales As % of Sales 10% 87%