3. Use the worksheet Bali Swimsuits in your Excel File. a. A chain of Bathing Stores is introducing the "New Bali Girl Bathing Suit". It is introduced for $70.00. A complex model has been built for you that takes into account many variables that influence the overall revenue. Retail Markdown Pricing Decisions model calculates the overall revenue for this suit. Use this Model to predict the revenue that could be achieved for different markdown decisions. The two variables are Days at full Retail (B7) and Intermediate Markdowns (B8). Use the Tab named: Bali Swimsuits and rename the scenario manager summary tab to Bali Sales. Scenario Name Short Average Longer Clearance Sale Sale Sale Sale Days at Full Retail 12 22 33 60 Intermediate Markdown .15 .25 .45 .60