Three 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:
Year 2 | Year 3 | ||||
First | Second | Third | Fourth | First | |
Budgeted production, in bottles | 60,000 | 90,000 | 150,000 | 100,000 | 70,000 |
Musk oil has become so popular as a perfume ingredient that it has become necessary to carry large inventories as a precaution against stock-outs. For this reason, the inventory of musk oil at the end of a quarter must be equal to 20% of the following quarter's production needs. Some 36,000 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. (Round "Unit cost of raw materials" answers to 2 decimal places.
Solution
Mink Caress | |||||
Direct Materials Budget | |||||
Quarter | |||||
First | Second | Third | Forth | Year | |
Required Production in Units of Finished Goods | 60000 | 90000 | 150000 | 100000 | 400000 |
Units of Raw material needed per Unit of Fished Goods | 3 | 3 | 3 | 3 | 3 |
Units of Raw material needed to meet Production | 180000 | 270000 | 450000 | 300000 | 1200000 |
Desired Ending Inventory of Raw Material | 54000 | 90000 | 60000 | 42000* | 42000 |
Total Units of Raw material Needed | 234000 | 360000 | 510000 | 342000 | 1242000 |
Beginning Inventory of Raw Material Available | 36000 | 54000 | 90000 | 60000 | 36000 |
Units of Raw material to be Purchased | 198000 | 306000 | 420000 | 282000 | 1206000 |
Unit cost of Raw Material | $ 1.50 | $ 1.50 | $ 1.50 | $ 1.50 | $ 1.50 |
Cost of Raw Material to be Purchased | $ 297,000 | $ 459,000 | $ 630,000 | $ 423,000 | $ 1,809,000 |
*70000 x 3 x 20%
Three grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia.
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.70 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 Second Third 108,000 168,000 First 78,000 Budgeted production in bottles Year 3 First 88,000 Fourth 118,000 Musk oil has become so popular...
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: Year 2 Year 3 First Second Third Fourth First Budgeted production, in bottles 74,000 104,000 164,000 114,000 84,000 Musk oil has become so popular...
Four 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 $2.10 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: 2 Year 2 Year 3 First First 98,000 128,000 188,000 138,000 Second Third Fourth Budgeted production, in bottles 108,000 Musk oil has become so...
Four 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: Year 2 First Second Third Fourth 88,000 118,000 178,000 128,000 Year 3 First 98,000 DOR Budgeted production, in bottles Musk oil has become so...
Four 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 $2.10 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Musk oil has become so popular as a perfume ingredient that it has become necessary to carry large inventories as a precaution against stock-outs....
Three 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: Year 2 Budgeted production, i First 60,000 Second 90,000 Third Fourth 150.000 100.000 First 70,000 Musk oil has become so popular as a perfume...
Three 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 $2.20 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 Second Third 102,000 162,000 First 72,000 Budgeted production, in bottles Year 3 First 82,000 Fourth 112,000 Musk oil has become so popular...
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 $170 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Yean2 second third 188,eee 168,800 First 78,880 Budgeted production, in bottles Fourth 118,eee Musk oil has become so popular as a perfume ingredient that...
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.90 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 Year 3 First Second Third Fourth First Budgeted production, in bottles 82,000 112,000 172,000 122,000 92,000 Musk oil has become so popular...
Three 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 $2.20 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 Year 3 First Second Third Fourth First Budgeted production, in bottles 72,000 102,000 162,000 112,000 82,000 Musk oil has become so popular...