Question

Learning Objective: Estimate materials requirements for production Madison Plastics makes specialized water lines for custom pools. They expect to sell 32,000 units in the next quarter. The beginning finished goods inventory balance is 8,000 units and the target ending finished goods inventory balance should be 3,500 for the quarter. There is 20,000 feet of water line in the warehouse. The target amount of water line materials on hand should equal one month of production. Production and sales are the same throughout the year. (Each unit takes 5 feet of water line.) Complete the Production Budget and Direct Materials Requirement Schedule. Production Budget For Quarter Ended March 31, 2010 Expected sales Add: Desired ending finished goods Total production need Less: Beginning finished goods Units to be produced Units 32,000 3,500 35,500 8,000 27,500 Direct Materials Requirements For Quarter Ended March 31, 2010 Feet Units to be produced Direct materials needed per unit Total production needs in feet Add: Desired ending inventory Total direct materials needs Less: Beginning inventory of materials Direct materials to be purchased

I filled in the Production Budget from the information given at the beginning and I think I did it correctly, but I'm confused by the Direct Materials information to input.  

Answer 1

Prostuction Bulg - manch 31 20ld For Quaster ended Units 32000 Expectzd sales Ae Aeained enlimg Lientieheal geads 3500 35500 productionmeealed Total Beginaing iniched geads Vni ks Less 21500,. atuias Regxements Manc 31201D Ilrcot Fo emded Quautess Feeb Untt hanelused. mededl pen unit. Units 23500 fo be matentads Dizec 1375 00 preduchenmeeds (25 00 x5) esinedemaliag Totas Nore iaveutomy Addd materials tr31500 t yoovd aivet Totol meeded _tes: Gegincing desecdony matainlelentr) materials te Direst কতলল শ Desired SndingInventry Nohe Gven Tangat aasut ahaials dn bond ahould enth equal halu shom. troughout tee ga Ome Produchionand Sales ane sam e 3200 ben quantey Sades be month १००० Puodutiom month peu Direat moteuols faen urir Rauo moterigds Kequised duiest mataeials - .. 8000 8 5 40000 Reel

Prostuction Bulg - manch 31 20ld For Quaster ended Units 32000 Expectzd sales Ae Aeained enlimg Lientieheal geads 3500 35500 productionmeealed Total Beginaing iniched geads Vni ks Less 21500,. atuias Regxements Manc 31201D Ilrcot Fo emded Quautess Feeb Untt hanelused. mededl pen unit. Units 23500 fo be matentads Dizec 1375 00 preduchenmeeds (25 00 x5) esinedemaliag Totas Nore iaveutomy Addd materials tr31500 t yoovd aivet Totol meeded _tes: Gegincing desecdony matainlelentr) materials te Direst কতলল শ Desired SndingInventry Nohe Gven Tangat aasut ahaials dn bond ahould enth equal halu shom. troughout tee ga Ome Produchionand Sales ane sam e 3200 ben quantey Sades be month १००० Puodutiom month peu Direat moteuols faen urir Rauo moterigds Kequised duiest mataeials - .. 8000 8 5 40000 Reel