Manley Company prepared the following budgeted income statement for 2019
1 Data Table Manley Company prepared the following budgeted income statement for 2019 10Cack the icon to view the budgeted income statement) Read the requirements Requirement 1. Prepare a budgeted income statement with columns for 1,300 units, 1.500 units, and 1.500 units sold 1,500 Manley Company Budgeted Income Statement For the Year Ended December 31, 2019 Manley Company Budgeted Income Statement For the Year Ended December 31, 2019 Unises Sales Revenue (5350 per unit) Cost of Goods Sold (55% of sales) Gross Profit Selling and Administrative Expenses (25% of sales) Operating Income $25.000 Unit sales 236.250 131 250 Print Done Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement is a budget It allows Manley's managers to plan for Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? Technology, such as Excel spreadset software, makes it more to conduct key assumptions turn out to be wrong sales love and prepare a company's managers have a better understanding of how change Enter any number in the ed elds and then continue to the next question WH-LB300-26 Manley Company Budgeted Income Statement For the Year Ended December 31, 2019 is 1500 units, and 1500 units sold Unit sales $ 525,000 Sales Revenue (5350 per unit) Cost of Goods Sold (55% of sales) Gross Prot 236 250 131.250 Selling and Administrative Expenses (25% of sales) $ 105,000 Operating Income sales level(s) t. It allows Manley's managers to plan for of analysis? to conduct managers have a better understanding of how changes in sales volume and costs are likely to affect they can and prepare a company's Uperating Income 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 Manley's managers to plan for Requirement 3. How might spreadsheet software such as Excel of analysis? flexible Technology, such as Excel spreadhseet software, makes it more static to conduct if key assumptions turn out sales level(s). and prepare a company's Enter any number in the edit fields and then continue to the next question -LB300-26 per income sales level(s). Requirement 2. How might managers use this type of budgeted income statement? The budgeted income statement prepared in Requirement 1 is a v budgetIt allows Manley'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 W key assumptions turn out to be wrong. only a single various mpany's If managers Enter any number in the edit fields and then continue to the next question -LB300-26 muirement 2. How might managers use this type of budgeted income statement? budgeted income statement prepared in Requirement 1 is a budget. It allows Manley's managers to plan for sales level(s). quirement 3. How might spreadsheet software such as Excel assist in this type of analysis? to conduct Vand prepare a company's chnology, such as Excel spreadhseet software, makes it more key assumptions turn out cost-effective time-consuming Enter any number in the edit fields and then continue to the next question -LB300-26 quirement 2. How might managers use this type of budgeted income statement? me budgeted Income statement prepared in Requirement 1 is a budget. It allows Manley's managers to plan for sales level(s) equirement 3. How might spreadsheet software such as Excel assist in this type of analysis? echnology, such as Excel spreadhseet software, makes it more to conduct and prepare a company's key assumptions tum out to be wrong financial statement analysis sensitivity or 'what-ir analysis If managers have a Enter any number in the edit fields and then continue to the next question LB300-26 come statement? Requirement is a budget. It allows Manley's managers to plan for ware such as Excel assist in this type of analysis? sales teves) ware, makes it more assumptions turn out to be wrong to conduct and prepare a company's vif managers have a better understanding of how changes in sales vol annual report master budget continue to the next question FSO sales levels) are a company's managers have a better understanding of how changes in sales volume and costs are likely to affect they can net income the annual report Apd 15 PM 8/9/2019 2163 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 Requirement 3. How might spreadsheet software such as Excel assist in this type of analysis? sales level(s) Technology, such as Excel spreadhseet software, makes it more if key assumptions turn out to be wrong to conduct and prepare a company's maintain the same course of action react quickly and make changes Enter any number in the edit fields and then continue to the next question -LB300-26