Using Excel's What-if Scenario Tool, provide the outcome for the following budget: Current Scenario - provided (Scenario 1) You have a business that makes widgets Assumptions: ? You sell each widget for $55.00 (selling price) ? You sell 100 widgets each month (# of units) ? Calculate your total revenue ? Expenses include transportation costs for shipping ? Calculate for 10% of revenue for transportation costs ? Costs for manufacturing each widget = $10.50 ? Calculate for profit Then using the What-if-Tool in Excel, provide 2 other scenarios: Scenario 2 - Downturn Sales have dropped dramatically, and the company had to reduce its price. ? Change the selling price of the widget from $55.00 to $45.00 ? Change the # of units from 100 to 45 ? Change the transportation costs to 5% Scenario 3 - Moving Up Things are going very well for the company. They raised prices and have sold more! ? Change the selling price of the widget from $55.00 to $65.00 ? Change the # of units from 100 to 150 ? Change the transportation costs to 12.5% After you have created the three scenarios (current, Scenario 2, Scenario 3, summarize of all three scenarios. Note: Once you put in the changes for each scenario, you will have to calculate the cells for Profit, Transportation Costs, and Profit & Loss (since these are calculations). Please provide a screenshot of your analysis or attach the Excel spreadsheet showing your work.

Current Downturn Moving Up Selling Price 55 # of Units 100 Revenue 5,500 Transportation Costs 10% Transportation Costs 550 Manufacturing Costs/Unit 10.5 Manufacturing Costs $1,050 Expenses $1,600 Profit $3,900