Question: *** PLEASE ANSWER IN EXCEL FORMAT THANK YOU! T22 * x fox B D E F G H 1 J L 3 4 5 s

*** PLEASE ANSWER IN EXCEL FORMAT THANK YOU!
T22 * x fox B D E F G H 1 J L 3 4 5 s 7 [Relevant Cash Flows] Winnerbagel Corp.currently sells 20,000 motor homes per year at $97,000 each and 14,000 luxury motor coaches per year at $145,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 30,000 of these campers per year at $21,000 each. An independent consultant has determined that if the company 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 of use as the annual sales figure when evaluating this project? 3 Input area: Motor home price Motor coach price Camper quantity Camper price Increased motor home quantity Lost motor coach quantity 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 Output area: $ Camper sales Increased motor home sales Lost motor coach sales Total sales
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
