Steward Company prepared the following budgeted income statement for 2025: (Click the icon to view the budgeted income statement.) Read the requirements. Requirement 1. Prepare a budgeted income statement with columns for 900 units, 1,000 units, and 1,500 units sold. Steward Company Budgeted Income Statement For the Year Ended December 31, 2025 900 Unit sales Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a for sales level(s). 1,000 1,500 budget. It allows Steward's managers to plan Data table Steward Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales Sales Revenue ($500 per unit) Cost of Goods Sold (40% of sales) Gross Profit Selling and Administrative Expenses (35% of sales) Operating Income Print Done $ 1,000 500,000 200,000 300,000 175,000 125,000 - X - ,000 units, and 1 Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a sales level(s). for Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadhseet software, makes it more and prepare a company's how changes in sales volume and costs are likely to affect budget. It allows Steward's managers to plan to conduct If managers have a better understanding of they can if key assumptions turn out to be wrong. 1 of 3 1 of 3 complete 0 of 1