Manley Company prepared the following budgeted income statement for 2019: D (Click the icon to view the budgeted income statement.) Read the requirements. Data Table Requirement 1. Prepare a budgeted income statement with columns for 1,200 units, 1,400 units, and 1,600 units sold. Manley Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales 1,200 1,400 1,600 Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income Manley Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales 1,400 Sales Revenue ($750 per unit) $ 1,050,000 Cost of Goods Sold (50% of sales) 525,000 Gross Profit 525,000 Selling and Administrative Expenses (15% of sales) 157,500 Operating Income $ 367,500 Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a V budget. It allows Manley's managers to plan for Print Done 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 assumptions turn out to be wrong. Vand prepare a company's If managers have a better understanding of how changes in sales volume and costs are likely to affect and costs are likely to affect V, they can they can Vif key