Hatcher Company prepared the following budgeted income statement for 2019: E(Click the icon to view the budgeted income statement.) X Read the requirements Data Table Requirement 1. Prepare a budgeled income statement with columns for 1,300 units, 1,500 units, and 1,800 units sold. Hatcher Company Hatcher Company Budgeted Income Statement Budgeted Income Statement For the Year Ended December 31, 2019 For the Year Ended December 31, 2019 Unit sales 1.300 1.500 1.800 Unit sales 1.500 Sales Revenue (S750 per unit) Sales Revenue 1,125,000 675,000 Cost of Goods Sold (60 % of sales) Cost of Goods Sold Gross Profit Grass Profit 450,000 225,000 Selling and Administrative Expenses Selling and Administrative Expenses (20 % of sales) 225,000 Operating Income Operating Income Requirement 2. How might managers use this type of budgeted income statement? Print Done budget. It allows Hatcher's managers to plan for sales levelfa) 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? to conduct and prepare a company's If managers have a better understanding of how changes in sales volume and costs Technology, such as Excel spreadhseet software, makes it more they can if key assumptions turn out to be wrong. are likely to affect X Requirements 1. Prepare a budgeted income statement with columns for 1,300 units, 1,500 2. How might managers use this type of budgeted income statement? 3. How might spreadsheet soltware such as Excel assist in this type of analysis? Enter any number in the edit fields and then continue to the next question. Print Dene