Moreno Industries has adopted the following production budget for the first 4 months of 2013. Month Units Month Units January 10,000 ...
Moreno Industries has adopted the following production budget for the first 4 months of 2013.
Month Units Month Units January 10,000 March 5,000 February 8,000 April 4,000
Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2012, the ending raw materials inventory was 9,000 pounds. Management wants to have a raw materials inventory at the end of the month equal to 30% of next month's production requirements.
Complete the direct materials purchases budget by month for the first quarter.
the answer is in attached file, change the figures and it will be calculated for any value
body preview (0 words)
file1.xlsx preview (87 words)
|xxxxxx xxxxxxxxxx xxx xxxxxxx the following xxxxxxxxxx xxxxxx xxx xxx xxxxx 4 months of 2013.|
|Management wants to have x xxx xxxxxxxxx inventory xx the xxx xx xxx month xxxxx to 30% of next month's xxxxxxxxxx requirements.|
|xxxxxxxx the direct xxxxxxxxx purchases xxxxxx by month xxx the first quarter.|
|x DM xxxxxxxx xxx unit(pds)x||3x||x||xx||3|
|xxxxxx xxxxxxxx xxxxxxxx||30000x||24000x||15000x||xxxxx|
|Add: Budgeted ending DMx||xxxx||xxxxx||3600|
|xxxxx Budgeted beginning xxx||xxxx||7200||xxxx||xxxx|
|xxxxxxxx DM purchase xxxxxxxxx||xxxxx||xxxxxx||xxxxx|
|xxxx per xxxxx||2x||x||2x||x|
|xxxxxxxx DM purchase ($)||xxxxxx||42600||28200|
Buy this answer
Try it before you buy it