Please help with production budget and so on! Thank you! (if you could explain your steps for at least one quarter that'd be great! many thanks!)

Problem 5-31

Swifty 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.

Problem 5-31 Swifty 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 Sales Price $1,260 $2,400 1st Quarter 200 420 2nd Quarter 270 3rd Quarter 300 340 4th Quarter 310 370 Acoustic guitar sales Electric guitar sales Prepare Swifty's sales budget for 2018 Sales Budget 1st Quarter 2nd Quarter 3rd quarter 4th Quarter Annual Acoustic Budgeted units sold 200 270 300 310 1080 Budgeted sales price 1260 1260 s 1260 s 1260 s 1260 252000 378000 340200 390600 1360800 Budgeted revenues Electric Budgeted units sold 200 270 300 310 1080 Budgeted sales price 2400d 2400d 2400d 2400d 2400