1) create sales budget

2) operating budget

3) production budget

4) material req budget

5) direct labor budget

6) manuf overhead budget

7) production per unit

8) projected income statement

A B ales Projections In Units January February March April May 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: Desired Ending Inventory Beginning Inventory (new business) 22.4% Materials 12.2% 14.0 Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) $16.00 26 Direct Labor Time per Unit (in hours) Cost per Hour 2.00 $11.00 30 Manufacturing Overhead Variable Cost/Unit Fixed Costs $5.00 $5,386 Master Budget Project ABC tanamamatan eaming Objectives: 1) Provide a comprehensive budgeting experience. 2) Exhibit the use of Excel in creating a master budget. 3) Utilize the project to perform sensitivity analysis. Learning Outcomes: 1) Understanding of the inter-relatedness of budgets. 2) Ability to utilize basic formula, cell references, and formatting 3) Ability to perform sensitivity analysis and make decisions from that analysis. Requirements: Done (x) 1 The numbers will automatically fill in the Data Sheet. 12) PRINT the Data Sheet. 3) TYPE the numbers from the Data Sheet that you printed into your project's Data Sheet. Save your Excel file (Format: Lastname Firstname) 4) TURN IN your printed Data Sheet in class on 11-01-2019 (or before). 5) Utilize your textbook, lecture notes, etc. to complete the budgets. a) You may not type any numbers on the budget worksheets. b) Utilize cell references to transfer numbers from the data sheet to the worksheets. Use formula to perform calculations. 6) Ensure that the Income Statement shows a profit for each month. If not, change the selling price on the Data Sheet until a profit results for each month. Once you have completed up through the projecte come statement, save your budget (as an xls or xlsx file) and submit it under the Assignments link for "Master Budget" ATTER you have suomeo your completed me Project, you must use your budgeting worksheets to perform the three situational analyses listed on the "Sensitivity Analysis worksheet (last page of the workbook). Once you have completed all three situations and entered your answers into the worksheet, save the file and upload it on Canvas under ASSIGNMENTS - Budget Sensitivity Analysis. Excel Help: Excel 2010 Help A B ales Projections In Units January February March April May 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: Desired Ending Inventory Beginning Inventory (new business) 22.4% Materials 12.2% 14.0 Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) $16.00 26 Direct Labor Time per Unit (in hours) Cost per Hour 2.00 $11.00 30 Manufacturing Overhead Variable Cost/Unit Fixed Costs $5.00 $5,386 Master Budget Project ABC tanamamatan eaming Objectives: 1) Provide a comprehensive budgeting experience. 2) Exhibit the use of Excel in creating a master budget. 3) Utilize the project to perform sensitivity analysis. Learning Outcomes: 1) Understanding of the inter-relatedness of budgets. 2) Ability to utilize basic formula, cell references, and formatting 3) Ability to perform sensitivity analysis and make decisions from that analysis. Requirements: Done (x) 1 The numbers will automatically fill in the Data Sheet. 12) PRINT the Data Sheet. 3) TYPE the numbers from the Data Sheet that you printed into your project's Data Sheet. Save your Excel file (Format: Lastname Firstname) 4) TURN IN your printed Data Sheet in class on 11-01-2019 (or before). 5) Utilize your textbook, lecture notes, etc. to complete the budgets. a) You may not type any numbers on the budget worksheets. b) Utilize cell references to transfer numbers from the data sheet to the worksheets. Use formula to perform calculations. 6) Ensure that the Income Statement shows a profit for each month. If not, change the selling price on the Data Sheet until a profit results for each month. Once you have completed up through the projecte come statement, save your budget (as an xls or xlsx file) and submit it under the Assignments link for "Master Budget" ATTER you have suomeo your completed me Project, you must use your budgeting worksheets to perform the three situational analyses listed on the "Sensitivity Analysis worksheet (last page of the workbook). Once you have completed all three situations and entered your answers into the worksheet, save the file and upload it on Canvas under ASSIGNMENTS - Budget Sensitivity Analysis. Excel Help: Excel 2010 Help