Can someone please help with the rest?
Sunland 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 antipated increases in an materials prices Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,250 210 270 310 315 Electric guitar sales $2.450 400 380 330 350 Prepare Sunland's sales budget for 2018. Prepare Sunland's sales budget for 2018. Sales Budget 2nd Quarter 3rd Quarter 1st Quarter 4th Quarter Annual Acoustic: Budgeted units sold 210 270 310 315 1105 Budgeted sales price 1250 1250 1250 1250 Budgeted revenue 262500 337500 387500 393750 1381250 Electric: Budgeted units sold 400 380 330 350 1460 Budgeted sales price 2450 2450 2450 2450 Budgeted revenue 980000 931000 808500 857500 $ 3577000 Total revenue 1242500 1268500 1196000 1251250 4958250 $ On December 31, 2017, Sunland had 30 acoustic guitars in stock-fewer than the desired inventory level of 84 guitar guitars in the first quarter of 2019. Prepare the 2018 production budget for acoustic guitars. On December 31, 2017, Sunland 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 11 Quarter De Quarter Quarter 4th Quarter 210 270 310 315 Annual Budgeted unit Sales 1105 Beginning inventory 84 54 34 Total units required 294 354 304 399 1441 Beginning inventory 30 34 54 34 510 Budgeted ending Inventor 264 270 1159 Each acoustic guitar requires a maple neck blank, which Sunland purchases for $40. On December 31, 2017, Sunland had 400 neck anks in inventory Sportage during the production process results in a standard quantity of 1.5 necks per acoustic guit. Because of recent delivery Broblems, Sunland wants to maintain an ending inventory equal to the following quarters production needs. Since the supplier has assured Sunland that the delivery we will be resolved by the end of December Surland wants only 380 neck in inventory on December 31, 2018. Prepare the purchases budget for neck blanks for 2018 (Enterper war walue to I decimal place ... And all others to decimal 153.) Each acoustic guitar requires a maple neck blank, which Sunland purchases for $40. On December 31, 2017, Sunland had 400 neck banks 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 quarter's production needs. Since the supplier has assured Sunland that the delivery issues will be resolved by the end of December, Sunland wants only 380 neck blanks in inventory on December 31, 2018. Prepare the purchases budget for neck blanks for 2018 (Enterperuar" value to decimal places, ... Round all other answers to decimal places, e.g. 153.) Purchases Budget Quarter 2 Quarter 1.5 1.5 and Quarter ith Quarter Annual Standard medes per guitar 1.5 1.5 1.5 Budgeted production 264 220 310 315 1159 Production needs 395 405 465 1739 Buducted ending inventor 203 233 237 300 300 Total DM required (nedas 599 638 702 273 2030 Beginning inventory Budgeted purchases (ned Standard price per neck Budgeted purchases cost
