A Data Table Data Table - X Direct materials Metal Fabric Direct manufacturing labor $ $ $ 2 per pound (same as in 2016) 3 per yard (same as in 2016) 14 per hour Schedule 2: Production Budget (in Units) for the Year Ending December 31, 2017 Knox Budgeted units sales 18,400 Add target ending finished goods inventory 1,600 Total required units 20,000 Deduct beginning finished goods inventory 3,000 17,000 Units of finished goods to be produced Ayer 16,000 600 Content of Each Product Unit 16,600 Product 600 16,000 Metal Knox 2 pounds 1 yard 0.05 hours Ayer 3 pounds 3 yards 0.15 hours Fabric Direct manufacturing labor Print Done Physical Units Budget To be used in production 82,000 lbs. 7.000 65,000 yards 10,000 yards Add target ending inventory Total requirements 89,000 lbs. 75,000 yards Deduct beginning inventory 9,000 lbs. 12,000 yards 80,000 63.000 = yards Purchases to be made Cost Budget Cost Budget Metal $ 160,000 Fabric $ 189,000 $ 189,000 $ 160,000 $ 349,000 Direct materials to be purchased this period (c). Calculate the direct manufacturing labor costs budget (label it Schedule 4) for the year ending December 31, 2017. (Enter the DMLH per unit to two decimal places. Ab DMLH = Direct manufacturing labor-hours.) Schedule 4: Direct Manufacturing Labor Costs Budget for the Year Ending December 31, 2017 Output units DMLH Total Hourly produced per unit hours wage rate Total Knox Ayer Total Enter any number in the edit fields and then click Check Answer. Sparkle Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. It expects to manufacture 17,000 Knox lamps and 16,000 Ayer lamps in 2017. The following data are 2017. (Click the icon to view the information.) (Click the icon to view the December 31, 2017 production budget in units.) Calculate (a) the direct materials usage budget in quantity and dollars (label it Schedule 3A); (b) the direct materials purchase budget in quantity and dollars (label it Schedule 3B); and (c) the di costs budget (label it Schedule 4) for the year ending December 31, 2017 (c). Calculate the direct manufacturing labor costs budget (label it Schedule 4) for the year ending December 31, 2017. (Enter the DMLH per unit to two decimal places, Abbreviations used: DM manufacturing labor-hours.)