Rucker 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 700 units, 1,300 units, and 1,700 units sold. Unit sales Sales Revenue Cost of Goods Soid Gross Profit Rucker Company Budgeted Income Statement For the Year Ended December 31, 2025 Selling and Administrative Expenses Operating Income 700 OBV Rucker Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales Sales Revenue ($400 per unit) Cost of Goods Sold (45% of sales) 1,300 $ 520,000 234,000 Gross Profit 286,000 52,000 Selling and Administrative Expenses (10% of sales) $ 234,000 Operating Income Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a budget it allows Flanagan's managers to plan for sales level(s) Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadhseet software, makes it more to conduct understanding of how changes in sales volume and costs are likely to affect they can and prepare a company's f managers have a better Mikey assumptions turn out to be wrong Show transcribed image text Expert