Flanagan 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 1,300 units, 1,500 units, and 1,600 units sold. Data Table - Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2025 1,300 Unit sales Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales Sales Revenue ($300 per unit) Cost of Goods Sold (70% of sales) Gross Profit Selling and Administrative Expenses (20% of sales) $ 1,500 450,000 315,000 Operating Income 135,000 90,000 $ 45,000 Operating Income i Requirements 1. Prepare a budgeted income statement with columns for 1,300 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