Concord 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. Acoustic guitar sales Electric guitar sales Sales Price $1,220 $2,390 1st Quarter 210 390 2 Quarter 270 360 3 Quarter 290 330 4th Quarter 320 340 Your answer is correct. Prepare Concord's sales budget for 2018 1M Quarter Sales Budget 3rd Quarter 2nd Quarter 4th Quarter Acoustic Budgeted units sold: 210 270 320 Budgeted sales price: 1.220 1.220 1.220 256,200 $ 329 400 390,400 Budgeted revenue : Electric Budgeted units sold: 360 Budsted sales prices - Your answer is partially correct. On December 31, 2017, Concord 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 1 Quarter 4th Quarter Annual Budgeted unit sales Budgeted ending inventory Total units required Beginning inventory Budgeted production - Your answer is partially correct. Each acoustic guitar requires a maple neck blank, which Concord purchases for $50. On December 31, 2017, Concord 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, Concord wants to maintain an ending inventory equal to 50% of the following quarter's production needs. Since the supplier has assured Concord that the delivery issues will be resolved by the end of December, Concord 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, 28. 3.1. Round all other answers to decimal places, es 153.) Purchases Budget 2nd Quarter 3rd Quarter 1st Quarter 4th Quarter Budgeted production Standard necks per guitar Production needs Budgeted ending inventory Total DM required (necks) Beginning inventory Budgeted purchases (necks) Standard price per neck - Budgeted purchases cost $