Manuflacturing produces seit watering planoars for use in upecale setail estabil
ID: 2521996 • Letter: M
Question
Manuflacturing produces seit watering planoars for use in upecale setail estabilishments, Salies prcjectons for the frst fve morths of the upcoming year show the estimabed unit sales of the planters each month to be as f ows (Clkick the icon to view additional information) Inventory at he start of the year ws 775 planters. The desired inventory of pianters at the end of each month shoukd bo equal to The company warts to huive 20% of the polypropylene required for nexi mont's production on hand at the end of each mont The polypropylene cots 0.20 per Read the reauirements 20% of the tollowing morth's botgeted saies. Each planter requires thre pounds of po?yaropyliene (a type of plesc) Dea Table Requirement 1.Prepare a production budget for each month in the Sst quster of the year, inouding production in units for each month and for the quarler Juda Manufacturing Produetion Budget For the Months of January through March 3,100 ,200 3,000 4200 January February March Quarter March, Apri Plus Desied ending invennory Total needed Less: Begiening inventory Units to produce Requirement 2. Prepare a dvect materials budget for the pelypropylene for each month in the frst quarter of the year, including the pounds of polypropylene r Star by preparing the direct materia's buiget trough the tctal quantity neoded, then complete the budget Pint Done required and the total cost of the polypropylene to be purchased. Requiremeants 1. Prepare a production budget for esch month in the fest quater ef the year, 2. Prepare a direct materials budget for the polypropylene for each month in the Units to be preduced ndluding production in unis for esch month and for the ouarter frit quarter of the year inoluding te pounds of polypropylene required and the lotal cost of the polypropylare to be purchaset Enter any number in the edit feleExplanation / Answer
Juda Manufacturing
Direct materials budget
For the month of January through March
January
February
March
Quarter
Units to be produced
3100
3200
3000
9300
Multiplied by: Quantity of direct materials needed per unit (3 pounds)
9300
9600
9000
27900
Quantity needed for production
9300
9600
9000
27900
Add: Desired ending inventory
1920
1800
2520
6240
Total quantity needed
11220
11400
11520
34140
Less: Opening inventory
1860
1920
1800
5580
(3100x20%) x3
Quantity to purchase
9360
9480
9720
28560
Cost per pound
0.2
0.2
0.2
0.2
Total cost of direct material purchases
1872
1896
1944
5712
(Quantity to purchase x 0.20)
Ending inventory:
January: (3200 x 20%) x 3= 1920
February: (3000 x 20%) x 3= 1800
March: (4200 x 20%) x 3= 2520
Juda Manufacturing
Direct materials budget
For the month of January through March
January
February
March
Quarter
Units to be produced
3100
3200
3000
9300
Multiplied by: Quantity of direct materials needed per unit (3 pounds)
9300
9600
9000
27900
Quantity needed for production
9300
9600
9000
27900
Add: Desired ending inventory
1920
1800
2520
6240
Total quantity needed
11220
11400
11520
34140
Less: Opening inventory
1860
1920
1800
5580
(3100x20%) x3
Quantity to purchase
9360
9480
9720
28560
Cost per pound
0.2
0.2
0.2
0.2
Total cost of direct material purchases
1872
1896
1944
5712
(Quantity to purchase x 0.20)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.