Sunland Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Vanessa Aaron, the companys 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,270			190			250			310			310
Electric guitar sales		$2,400			420			360			320			360

Each acoustic guitar requires a maple neck blank, which Sunland purchases for $45. On December 31, 2017, Sunland had 380 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, Sunland wants to maintain an ending inventory equal to 50% of the following quarters production needs. Since the supplier has assured Sunland that the delivery issues will be resolved by the end of December, Sunland wants only 300 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.)

Purchases Budget
		1st Quarter		2nd Quarter		3rd Quarter		4th Quarter		Annual
Budgeted purchases (necks)Budgeted ending inventoryStandard necks per guitarTotal DM required (necks)Beginning inventoryStandard price per neckProduction needsBudgeted productionBudgeted purchases cost
Production needsStandard price per neckTotal DM required (necks)Budgeted purchases (necks)Budgeted ending inventoryBudgeted productionBeginning inventoryStandard necks per guitarBudgeted purchases cost
Budgeted purchases (necks)Beginning inventoryBudgeted purchases costBudgeted productionProduction needsTotal DM required (necks)Budgeted ending inventoryStandard price per neckStandard necks per guitar
Standard price per neckBudgeted purchases costStandard necks per guitarTotal DM required (necks)Beginning inventoryBudgeted productionBudgeted ending inventoryBudgeted purchases (necks)Production needs
Production needsBudgeted productionBeginning inventoryBudgeted purchases (necks)Budgeted ending inventoryBudgeted purchases costTotal DM required (necks)Standard necks per guitarStandard price per neck
Budgeted purchases (necks)Budgeted productionBeginning inventoryBudgeted purchases costProduction needsTotal DM required (necks)Standard necks per guitarBudgeted ending inventoryStandard price per neck
Budgeted purchases (necks)Budgeted purchases costTotal DM required (necks)Production needsBudgeted productionBudgeted ending inventoryStandard necks per guitarBeginning inventoryStandard price per neck
Budgeted purchases (necks)Beginning inventoryStandard price per neckBudgeted productionStandard necks per guitarBudgeted purchases costBudgeted ending inventoryProduction needsTotal DM required (necks)		$		$		$		$		$
Budgeted productionStandard necks per guitarBudgeted purchases costStandard price per neckTotal DM required (necks)Budgeted ending inventoryBudgeted purchases (necks)Production needsBeginning inventory		$		$		$		$		$

eTextbook and Media