Current Attempt in Progress Bramble 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 2 Quarter Acoustic guitar sales Electric guitar sales Sales Price $1.270 $2,360 1st Quarter 210 390 280 3rd Quarter 290 300 4th Quarter 305 370 370 Prepare Bramble's sales budget for 2018 Sales Budget 3rd Quarter 1st Quarter 2nd Quarter Que Acoustic Electric Prepare Bramble's sales budget for 2018. Sales Budget 3rd Quarter Juarter 2nd Quarter 4th Quarter Annual e Textbook and Media On December 31, 2017, Bramble 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. Production Budget 2nd Quarter 3rd Quarter 1st Quarter 4th Quarter e Textbook and Media December 31, 2017, Bramble had 30 acoustic guitars in stock-fewer than the desirea inventory REVETUIT sed on the following quarter's sales. The company has budgeted for sales of 240 acoustic guitars in the first quarte 019. Prepare the 2018 production budget for acoustic guitars. Production Budget 2nd Quarter 3rd Quarter st Quarter 4th Quarter Annual e Textbook and Media Each acoustic guitar requires a maple neck blank, which Bramble purchases for $45. On December 31, 2017, Bramble had 400 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, Bramble wants to maintain an ending inventory equal to 50% of the following quarter's production needs. Since the supplier has assured Bramble that the delivery issues will be resolved by the end of December, Bramble wants only 330 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, eg. 3.1. Round all other answers to decimal places, eg. 153.) Purchases Budget 2nd Quarter 3rd Quarter 1st Quarter Show All X CTW 3 Assignm.pdf STUUUCTION TEcos. Once the SUPPORTOS SUTEISMIC that the DOTIVETY SUS VIITOUTUSUIVEU Dy the enero hber, Bramble wants only 330 neck blanks in inventory on December 31, 2018. Prepare the purchases budget for blanks for 2018. (Enter "per guitar" value to 1 decimal place, eg. 3.1. Round all other answers to O decimal places, eg. 153.) Purchases Budget 2nd Quarter 3rd Quarter 4th Quarter Annual e Textbook and Media