Question

Waterway Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Vanessa Aaron, the company’s sales manager, prepared the following sales forecast for 2018. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices.

		Sales Price			1st Quarter			2nd Quarter			3rd Quarter			4th Quarter
Acoustic guitar sales		$1,250			210			300			300			305
Electric guitar sales		$2,380			420			340			300			360

b) On December 31, 2017, Waterway had 30 acoustic guitars in stock—fewer than the desired inventory level of 84 guitars, based on the following quarter’s sales. The company has budgeted for sales of 240 acoustic guitars in the first quarter of 2019. Prepare the 2018 production budget for acoustic guitars.

c) Each acoustic guitar requires a maple neck blank, which Waterway purchases for $50. On December 31, 2017, Waterway had 390 neck blanks in inventory. Spoilage during the production process results in a standard quantity of 1.5 necks per acoustic guitar. Because of recent delivery problems, Waterway wants to maintain an ending inventory equal to 50% of the following quarter’s production needs. Since the supplier has assured Waterway that the delivery issues will be resolved by the end of December, Waterway wants only 340 neck blanks in inventory on December 31, 2018. Prepare the purchases budget for neck blanks for 2018. (Enter "per guitar" value to 1 decimal place, e.g. 3.1. Round all other answers to 0 decimal places, e.g. 153.)

Answer 1

Production Budget
	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Annual
Budgeted Sales units	210	300	300	305	1115
Add : Desired Ending Inventory	120	120	122	96	96
Units Required	330	420	422	401	1211
Less : Beginning Inventory	30	120	120	122	30
Production Required	300	300	302	279	1181

Desired Ending Inventory = 40% of next quarter sales i.e. 84/210 = 40%

Purchase Budget
	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Annual
Production Required	300	300	302	279	1181
Standard Necks per guitar	1.5	1.5	1.5	1.5	1.5
Production Needs	450	450	453	419	1772
Budgeted Ending inventory	225	227	210	340	340
Total DM Required	675	677	663	759	2112
Beginning Inventory	390	225	227	210	390
Budgeted Purchases	285	452	436	549	1722
Standard Price per neck	$                  50	$                  50	$                         50	$                 50	$                45
Budgeted Purchases Cost	$          14,250	$          22,600	$                21,800	$         27,450	$        77,490