G H 1 Using sensitivity analysis 2 3 Dickinson Company prepared the following budgeted income statement for 2021: 4 5 DICKINSON COMPANY 6 7 Budgeted Income Statement 8 For the Year Ended December 31, 2021 9 Unit Sales 10 1,000 11 Sales Revenue ($600 per unit) $ 600,000 12 Cost of Goods Sold (60% of sales) 13 360,000 14 Gross Profit 240,000 15 Selling and Administrative Expenses (25% of sales) 16 150,000 Operating Income 17 $ 90,000 18 19 20 Requirements 21 1. Prepare a budgeted income statement with columns for 800 units, 1,000 units, and 1,200 units sold. 22 2. How might managers use this type of budgeted income statement? 23 3. How might spreadsheet software such as Excel assist in this type of analysis? 24