Godfrey Company prepared the following budgeted income statement for 2019:

Question Help Data Table Requirements Godfrey Company Budgeted Income Statement 1. Prepare a budgeted income statement with columns for 500 units, 1,200 units, and 1,600 units sold. For the Year Ended December 31, 2019 Unit sales 1.200 2. How might managers use this type of budgeted income statement? Sales Revenue ($550 per unit) 660,000 3. How might spreadsheet software such as Excel assist in this type of analysis? 330,000 Cost of Goods Sold (50 % of sales) Gross Profit 330,000 Print Done 132,000 Selling and Administrative Expenses (20 % of sales ) $ 198,000 Operating Income Print Done Read the requirements. Godfrey Company Budgeted Income Statement For the Year Ended December 31, 2019 Unit sales 500 1,200 1,600 Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income Enter any number in the edit fields and then continue to the next question. Godfrey Company prepared the following budgeted income statement for 2019: (Click the icon to view the budgeted income statement.) Read the requirements oeny anu ummusuauve CApenses Operating Income Requirement 2. How might managers use this type of budgeted income statement? sales level(s). The budgeted income statement prepared in Requirement 1 is a budget. It allows Godfrey's managers to plan for 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 and prepare a company's If managers have a better understanding of how changes in sales volume and costs are likely to affect they can if key assumptions turn out to be wrong. Enter any number in the edit fields and then continue to the next