Can someone please help me fill in this table? I would greatly appreciate it! Sp

Question

Can someone please help me fill in this table? I would greatly appreciate it!

Spts) Direct Materials Budget For the Quarter Ended March 31 Month January February March 9.000 9.500 9.800 1st Quarter Units to be produced Multiply by Quantity of DM needed per und Quantity needed for production Plus Desired and inventory of DM Total quantity needed Less: Beginning inventory of DM Quantity to purchase Multiply by: Cost per yard Total cost of DM purchases Note: January 1 inventory balance (1,100) is the same as the December 31 balance which is calculated as 10% of the quantity needed for production in January. The expected output for April is 10,000 units. Opis

Explanation / Answer

Direct Materials Budget

For Quarter ended 31 March

Months January February March 1st Quarter Units to be produced 9,000 9,500 9,800 28,300 * Quantity of DM needed per unit 1.5 1.5 1.5 1.5 Quantity needed for production 13,500 14,250 14,700 42,450 + desired end inentory of DM (14,250 * 10 %) = 1,425 (14,700* 10 %) = 1,470 (10,000* 1.5 *10 %) = 1,500 4,395 Total quantity needed 14,925 15,720 16,200 46,845 - Beginning inventory of DM (1,100) (1,425) (1,470) (3,995) Quantity to be purchase 13,825 14,295 14,730 42,850 * Cost per yard $2.50 $2.50 $2.50 $2.50 Total cost of DM purchases $34,562.50 $35,737.50 $36,825 $107,125

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---