Dickinson Company Budgeted Income Statemernt For the Year Ended December 31, 2019 Unit sales Sales Revenue ($600 per unit) Cost of Goods Sold (40% of sales) Gross Proft Selling and Administrative Expenses (25% of sales) Operating Income 600 $ 360,000 144,000 216,000 90,000 126,000 Dickinson Company prepared the following budgeted income statement for 2019: Click the icon to view the budgeted income statement.) Read the requirements. Requirement 1. Prepare a budgeted income statement with columns for 400 units, 600 units, and 1,900 units sold. Dickinson Company Budgeted Income Statement For the Year Ended December 31, 2019 600 Unit sales Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income 400 1,900 Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadhseet software, makes it more managers have a better understanding of how changes in sales volume and costs are likely to affect V budget. It allows Dickinson's managers to plan for sales level(s) | to conduct and prepare a company's they can if key assumptions turn out to be wrong