Garver Industries has budgeted the following unit sales: 2017 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December...

Free

90.2K

Verified Solution

Question

Accounting

Garver Industries has budgeted the following unit sales:

2017Units
January10,000
February8,000
March9,000
April11,000
May15,000


The finished goods units on hand on December 31, 2016, was 2,000units. Each unit requires 3 pounds of raw materials that areestimated to cost an average of $4 per pound. It is the company'spolicy to maintain a finished goods inventory at the end of eachmonth equal to 20% of next month's anticipated sales. They alsohave a policy of maintaining a raw materials inventory at the endof each month equal to 30% of the pounds needed for the followingmonth's production. There were 8,640 pounds of raw materials onhand at December 31, 2016.
For the first quarter of 2017, prepare a production budget.

GARVER INDUSTRIES
Production Budget
For the Quarter Ended March 31, 2017
JanuaryFebruaryMarchTotal
                                                                 Desired ending finishedgoods unitsExpected unit salesRequired production unitsTotalrequired unitsBeginning finished goods unitsCost per poundDirectmaterials purchases
                                                                 Direct materialspurchasesCost per poundDesired ending finished goods unitsExpectedunit salesRequired production unitsTotal required unitsBeginningfinished goods units
                                                                 Cost per poundDirectmaterials purchasesExpected unit salesTotal required unitsRequiredproduction unitsBeginning finished goods unitsDesired endingfinished goods units
                                                                 AddLess:                                                                 Direct materials purchasesExpected unitsalesRequired production unitsCost per poundBeginning finishedgoods unitsTotal required unitsDesired ending finished goodsunits
                                                                 Cost per poundTotal requiredunitsExpected unit salesBeginning finished goods unitsDirectmaterials purchasesDesired ending finished goods unitsRequiredproduction units

For the first quarter of 2017, prepare a direct materialsbudget.

GARVER INDUSTRIES
Direct Materials Budget
For the Quarter Ended March 31, 2017
JanuaryFebruaryMarchTotal
                                                                 Direct materialspurchasesTotal cost of direct materials purchasesTotal poundsneeded for productionDirect materials per unitBeginning directmaterialsDesired ending direct materialsCost per poundTotalmaterials requiredUnits to be produced$$$
                                                                 Total pounds needed forproductionDirect materials purchasesDirect materials per unitUnitsto be producedTotal cost of direct materials purchasesTotalmaterials requiredDesired ending direct materialsBeginning directmaterialsCost per pound
                                                                 Cost per poundUnits to beproducedDesired ending direct materialsDirect materialspurchasesTotal pounds needed for productionBeginning directmaterialsDirect materials per unitTotal materials requiredTotalcost of direct materials purchases
                                                                 Total materials requiredCostper poundUnits to be producedDirect materials purchasesTotal costof direct materials purchasesTotal pounds needed forproductionDesired ending direct materialsDirect materials perunitBeginning direct materials
                                                                 Direct materialspurchasesCost per poundTotal materials requiredDirect materials perunitDesired ending direct materialsBeginning direct materialsTotalpounds needed for productionTotal cost of direct materialspurchasesUnits to be produced
                                                                 AddLess:                                                                 Direct materials per unitTotal poundsneeded for productionTotal cost of direct materialspurchasesBeginning direct materialsTotal materials requiredUnits tobe producedCost per poundDirect materials purchasesDesired endingdirect materials
                                                                 Units to be producedDirectmaterials purchasesDirect materials per unitTotal pounds needed forproductionTotal materials requiredDesired ending directmaterialsTotal cost of direct materials purchasesCost perpoundBeginning direct materials
                                                                 Desired ending directmaterialsDirect materials per unitDirect materials purchasesCostper poundTotal materials requiredUnits to be producedTotal cost ofdirect materials purchasesBeginning direct materialsTotal poundsneeded for production
                                                                 Total cost of directmaterials purchasesDirect materials per unitUnits to beproducedTotal pounds needed for productionDesired ending directmaterialsBeginning direct materialsDirect materials purchasesCostper poundTotal materials required$$$$

Attempts: 0 of 1 used

Save for LaterCheck Answer

Send to Gradebook

Prev

Answer & Explanation Solved by verified expert
4.4 Ratings (929 Votes)

SOLUTION

(A) Production Budget-

January February March Total
Expected unit sales 10,000 8,000 9,000
Add: Desired ending finished goods units 1,600 1,800 2,200
Total required units 11,600 9,800 11,200
Less: Beginning finished goods units 2,000 1,600 1,800
Required production units 9,600 8,200 9,400 27,200

*April units: 11,000 * 20% = 2,200

Desired ending finished goods units = 20% * Next months sales

January = 8,000*20% = 1,600

February = 9,000*20%= 1,800

March = 11,000*20% =2,200

(B) Direct Materials Budget-

January February March Total
Units to be produced 9,600 8,200 9,400
Direct materials per unit 3 3 3
Total pounds needed for production 28,800 24,600 28,200
Desired ending direct materials (pounds) 7,380 8,460 10,620
Total materials required 36,180 33,060 38,820
Less: Beginning direct materials (pounds) 8,640 7,380 8,460
Direct materials purchases 27,540 25,680 30,360
Cost per pound $4 $4 $4
Total cost of direct materials purchases 110,160 102,720 121,440 334,320

**April units: 11,800 * 3 = 35,400 * 30% = 10,620


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students