Flanagan Company prepared the following budgeted income staten (Click the icon to view the budgeted income statement.) Read the requirements. 1. Prepare a budgeted income statement with columns for 800 units, 1,200 units, and 1,400 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? Requirement 1. Prepare a budgeted income statement with colum Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income 800 Print Done Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales 1,200 Sales Revenue ($350 per unit) $ 420,000 273,000 Cost of Goods Sold (65% of sales) Gross Profit 147,000 105,000 Selling and Administrative Expenses (25% of sales) $ 42,000 Operating Income