do all requirements

Hatcher Company prepared the following budgeted income statement for 2015: (click the icon to view the budgeted income statement.) Requirements 1. Prepare a budgeted income statement with columns for 500 units, 600 units, and 1,000 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? Requirement 1. Prepare a budgeted income statement with columns for 500 units, 600 units, and 1,000 units sold. Hatcher Company Budgeted Income Statement For the Year Ended December 31, 2015 Data Tab Unit sales Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income 500 Hatcher Company Budgeted Income Statement For the Year Ended December 31, 2015 Unit sales Sales Revenue ($300 per unit) Cost of Goods Sold (70% of sales) Gross Profit Selling and Administrative Expenses (25% of sales) Operating Income 600 $ 180,000 26,000 54,000 45,000 9,000 Print Done Enter any number in the edit fields and then click Check