4,Bubbly Waters currently sells 370 Class A spas, 520 Class C spas, and 270 deluxe model spas each year. The firm is considering adding a mid-class spa and expects that if it does, it can sell 445 units per year. However, if the new spa is added, Class A sales are expected to decline to 260 units while the Class C sales are expected to increase to 545. The sales of the deluxe model will not be affected. Class A spas sell for an average of $13,300 each. Class C spas are priced at $6,700 and the deluxe models sell for $17,700 each. The new mid-range spa will sell for $8,700. What annual sales figure should you use in your analysis?

4,Bubbly Waters currently sells 370 Class A spas, 520 Class C spas, and 270 deluxe model...
Bubbly Waters currently sells 320 Class A spas, 470 Class C spas, and 220 deluxe model spas each year. The firm is considering adding a mid-class spa and expects that if it does, it can sell 395 units per year. However, if the new spa is added, Class A sales are expected to decline to 235 units while the Class C sales are expected to increase to 495. The sales of the deluxe model will not be affected. Class A...
Bubbly Waters currently sells 540 Class A spas, 690 Class C spas, and 440 deluxe model spas each year. The firm is considering adding a mid-class spa and expects that if it does, it can sell 615 units per year. However, if the new spa is added, Class A sales are expected to decline to 345 units while the Class C sales are expected to increase to 715. The sales of the deluxe model will not be affected. Class A...
Jamie's Motor Home Sales currently sells 1,000 Class A motor homes, 2,500 Class C motor homes, and 4,000 pop-up trailers each year. Jamie is considering adding a mid- range camper and expects that if she does so she can sell 1,500 of them. However, if the new camper is added, Jamie expects that her Class A sales will decline to 950 units while the Class C campers decline to 2,200. The sales of pop-ups will not be affected. Class A...
Create a capital budgeting analysis in Excel.
Please work on an Excel spreadsheet to conduct a capital budgeting analysis for the following project: Tornado Motors is a major producer of sport and utility trucks. It is a family owned company. started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B) and a larger,...