Using excel fomrula to get answer

Winnebagel Corp. currently sells 30,000 motor homes per year at $73,000 each and 12,000 luxury motor coaches per year at $120,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 25,000 of these campers per year at $19,000 each. An independent consultant has determined that if Winnebagel introduces the new campers, it should boost the sales of its existing motor homes by 2,700 units per year and reduce the sales of its motor coaches by 1,300 units per year. What is the amount to use as the annual sales figure when evaluating this project? Motor home price Motor coach price Camper quantity Camper price Change in motor home quantity Change in motor coach quantity 73,000 120,000 25,000 19,000 2,700 (1,300) Complete the following analysis. Do not hard code values in your calculations. 13 Complete the following analysis. Do not hard code values in your calculations. 16 Camper sales Change in motor home sales Change in motor coach sales Total sales