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