Steward 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 1,000 units, 1,500 units, and 1,600 units sold. Steward Company Budgeted Income Statement For the Year Ended December 31, 2019 1,000 Unit sales - X Sales Revenue Data Table Cost of Goods Sold Gross Profit Steward Company Selling and Administrative Expenses Operating Income Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales 1,500 $ Sales Revenue ($300 per unit) Cost of Goods Sold (50% of sales) Gross Profit 450,000 225,000 225,000 157,500 Selling and Administrative Expenses (35% of sales) $ 67,500 Operating Income Steward Company prepared the following budgeted income statement for 2019: E (Click the icon to view the budgeted income statement.) Read the requirements Requirement 1. Prepare a budgeted income statement with columns for 1,000 units, 1,500 units, and 1,600 units sold. Steward Company Budgeted Income Statement For the Year Ended December 31, 2019 1,000 Unit sales - X Sales Revenue Data Table Cost of Goods Sold Gross Profit - X Requirements Selling and Administrative Expenses Operating Income 1. Prepare a budgeted income statement with columns for 1,000 units, 1,500 units, and 1,600 units sold. 2. How might managers use this type of budgeted income statement? 3. How might spreadsheet software such as Excel assist in this type of analysis? Print Done