Data Table Flanagan Company prepared the following budgeted income statement for 2019 EEB Click the icon to view the budgeted income statement.) Read the requirements Requirement 1. Prepare a budgeted income statement with columns for 1,100 units, 1,500 units, and 1,800 units sold. Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2019 Flanagan Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales Sales Revenue ($600 per unit) Cost of Goods Sold (55% of sales) Gross Profit Selling and Administrative Expenses (20% of sales) Operating Income 1,500 S 900,000 495,000 405,000 180,000 225,000 1,100 1,500 1,800 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 Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadhseet software, makes it more understanding of how changes in sales volume and costs are likely to affect Print Done V budget. It allows Flanagan's managers to plan for V sales level(s). V to conduct Vand prepare a company's VIf managers have a better they can V if key assumptions turn out to be wrong