Waterway 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,200 210 260 300 305

Electric guitar sales $2,390 420 380 310 340

Prepare Waterways sales budget for 2018.

Sales Budget

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Annual

Acoustic:

$

$

$

$

$

$

$

$

$

$

Electric:

$

$

$

$

$

$

$

$

$

$

Total revenue

$

$

$

$

$

LINK TO TEXT

LINK TO VIDEO

On December 31, 2017, Waterway had 30 acoustic guitars in stockfewer than the desired inventory level of 84 guitars, based on the following quarters 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.

Production Budget

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Annual

LINK TO TEXT

LINK TO VIDEO

Each acoustic guitar requires a maple neck blank, which Waterway purchases for $40. 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 quarters production needs. Since the supplier has assured Waterway that the delivery issues will be resolved by the end of December, Waterway wants only 360 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

$

$

$

$

$

$

$

$

$

$