Exercise 8-3 (Algo) Direct Materials Budget [LO8-4] Two grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk oil is $1.50 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Budgeted production, in bottles Year 2 Year 3 First 74,000 Second Third 104,000 164,000 Fourth 114,000 First 84,000 The inventory of musk oil at the end of a quarter must be equal to 20% of the following quarter's production needs. Some 29,600 grams of musk oil will be on hand to start the first quarter of Year 2. Required: Prepare a direct materials budget for musk oil, by quarter and in total, for Year 2. Answer is not complete. Mink Caress Direct Materials Budget - Year 2 First Quarter Second Quarter Third Quarter Fourth Year Quarter Estimated sales in units of finished goods Units of raw materials needed per unit of finished goods Units of raw materials needed to meet production Add: Desired units of ending raw materials inventory Total units of raw materials needed 74,000 2 104,000 164,000 114,000 456,000 2 2 2 2 148,000 208,000 328,000 228,000 912,000 41,600 65,600 45,600 189,600 273,600 373,600 16,800 224,800 169,600 1,081,600 Less: Units of beginning raw materials inventory (29,600) (41,600) (65,600) (45,600) (16,800) Units of raw materials to be purchased Unit cost of raw materials Cost of raw materials to purchased $ 1.50 1.50 1.50 1.50 1.50