In: Accounting
Marst Corporation's budgeted
production in units and budgeted raw materials purchases over the
next three months are given below:
January | February | March | |
Budgeted production (in units) | 118,000 | ? | 80,000 |
Budgeted raw materials purchases (in pounds) | 272,600 | 298,600 | 354,600 |
|
Two pounds of raw materials are required to produce one unit of
product. The company wants raw materials on hand at the end of each
month equal to 30% of the following month's production needs. The
company is expected to have 23,000 pounds of raw materials on hand
on January 1. Budgeted production for February should be:
rev: 10_27_2016_QC_CS-67319
250,600 units
96,000 units
48,000 units
179,000 units
Solution: | ||||
Answer is 4th option 179,000 units | ||||
Working Notes: | ||||
Let X be the Budgeted production units. | ||||
So, Beginning raw material Inventory = February budgeted production units x 2 x 30% | ||||
= X x 2 x 30% | ||||
=0.6 X | ||||
Ending Raw material inventory = March budgeted production units x 2 x 30% | ||||
=80,000 x 2 x 30% | ||||
=48,000 | ||||
February production required raw material = Budgeted production units. x 2 | ||||
= 2X | ||||
Budgeted raw materials purchases for February = Ending Raw material inventory + February production required raw material - Beginning raw material Inventory | ||||
298,600 = 48,000 + 2X - 0.6 X | ||||
298,600 = 48,000 + 1.4X | ||||
X=(298,600 - 48,000)/1.4 | ||||
X=250,600/1.4 | ||||
X=179,000 units | ||||
Please feel free to ask if anything about above solution in comment section of the question. |