Requirement 1. Prepare a budgeted income statement with columns far 400 units, 1.200 units, and 1,800 units sold. i Data Table Stoward Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales 1.200 Sales Revenue Cost of Goods Sold Grass Profit Selling and Administrative Expenses - Steward Company Budgeted Income Statement For the Year Ended December 31, 2019 1.800 Unit sales $ 1.200 720,000 396,000 Sales Revenue ($600 per unit) Cost of Goods Sold (55% of sales) Gross Profit Selling and Administrative Expenses (35% of sales) Operating Income 324,000 252,000 Operating Income Requirement 2. How might managers use this type of budgeted income statement? 72,000 sales level(s). The budgeled income staternent prepared in Requirement 1 is a budget. Il alows Steward's managers to plan for Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Print Dons and prepare a company's managers have a better understanding of how changes in sales volume and costs are likely to affect Technology such as Excel spreadhseet software, makes it more they can V to conduct key assumptions tum out to be wrong