Fill out the direct material, direct labor, and applied manufacturing overhead with the excel file provided.

An example sheet is provided. Solve for sculpted candles. 4 inch each and 48 quantity.

DM Finishing Department Per Inch of Candle HeightPer Candle $0.50 Per Per Batch Candle (12) Input Wax Wick Coloring Scent Clip (1 per candle) Input Cellophane S 0.01 Information Sticl 0.03 Packing Box 0.05 $ 0.02 $ 0.08 S 0.15 0.01 Additional Costs for Specialty Candles 0 Additional WaxS 0.17 sculpted candles only 1 Additional Coloring 2 Sand 0.01 sculpted candles only imprint candles only $0.06 4 DL Finishing Department Hours per Batch (12) Hours per Batch Wage per (12) NA Wage per hour Labor Type 6 Labor Type 7 Apprentice 18 Candlemaker 9 Candle Master 20 Additional Candle Master time for Specialty Candles 21 Sculpted candles hour NA 0.06 12.25 0.03 18.00 0.12 $ 0.06 0.02 7.00 Apprentice 12.25 Candlemaker 18.00 Candle Master 0.26 S 18.00 23