Direct Labor Cost Budget Direct labor needs from the direct labor cost budget should be coordinated between the production and personnel departments so that there will be enough labor available for production Before you make any changes to the budget, you review the information in the following Direct Labor Data Table and enter the units to be produced from the Production Budget panel. After scanning the Direct Labor Cost Budget (which follows the Direct Labor Data Table), you observe that LearnCo has omitted quite a few numbers from the budget. Fw in the missing amounts. You may need to use numbers from the Direct Labor Data Table, or from the sales budget, production budget, and direct materials purchases budget you prepared. When required, round your answers to the nearest dollar, > Direct Labor Data Table Gluing Assembly 0.10 0.10 0.10 Hours required per unit Basic abacus Deluxe abacus Labor hourly rate Gluing Assembly Units to be produced (from Production Budget): 0.20 $11.00 $19.00 $11.00 Direct Labor Cost Budget Labor hourly rate: Gluing Assembly Units to be produced (from Production Budget): Basic abacus Deluxe abacus $19.00 LearnCo Direct Labor Cost Budget > For the Year Ending December 31, 20Y2 Gluing Assembly Total Hours required for production: Basic abacus Deluxe abacus Total Hourly rate XS x Total direct labor cost $288,660 Sales Budget Shaded cells have feedback. After reviewing LearnCo's sales budget, you note that three numbers have been omitted. The company's controller has told you that the units sold for the Basic and Deluxe models are expected to be the same. Fill in the missing amounts. LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36,000 $6.00 $216,000 Deluxe Abacus 36,000 14.00 504,000 Totals 72,000 $720,000 Points 3/3 Production Budget Shaded cells have feedback. The production budget should be integrated with the sales budget to ensure that production and sales are kept in balance during the year. The production budget estimates the number of units to be manufactured to meet budgeted sales and desired inventory levels You note that LearnCo has omitted six numbers from the following production budget and fill in the missing amounts. You may need to use numbers from the sales budget you prepared. > LearnCo Production Budget For the Year Ending December 31, 2012 Units Basic Units Deluxe 36,000 36,000 1,000 3,000 Expected units to be sold (from Sales Budget) Desired ending inventory, December 31, 2012 Total units available Estimated beginning inventory, January 1, 20Y2 37,000 39,000 (1.050) (2.100) Total units to be produced 35,950 36,900
