Hatcher Company prepared the following budgeted income statement for 2025: (Click the icon to view the budgeted income statement.) - X Data Table Read the requirements. - Requirement 1. Prepare a budgeted income statement with columns for 1,300 units, 1,400 units, and 1,600 units sold. Hatcher Company Budgeted Income Statement For the Year Ended December 31, 2025 1.300 1,400 S Hatcher Company Budgeted Income Statement For the Year Ended December 31, 2025 Unit sales Sales Revenue ($550 per unit) ) Cost of Goods Sold (70% of sales) Gross Profit Selling and Administrative Expenses (15% of sales) Operating Income 1,400 770,000 539,000 Unit sales 1.600 Sales Revenue 231,000 115,500 Cost of Goods Sold Gross Profit Selling and Administrative Expenses 115,500 Operating Income Print Done Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a budget. It allows Hatcher's managers to plan for sales level(s). Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadihseet software, makes it more to conduct and prepare a company's a costs are likely to affect V. they can if key assumptions turn out to be wrong. If managers have a better understanding of how changes in sales volume and