Paste Conditional Format Formatting as Table Crosby Inc. has just developed a new product called The Cruiser, with a variable manufacturing cost of $32 per unit The marketing vice president has developed three marketing approaches to selling The Cruiser Rank the three approaches, highest to lowest, in order of net contribution 6 Alternative Set a selling price of $38 and have the organization's sales persons advertising program. Estimated sales would be 12,000 units under this plan Set a selling price of $40 and have the organization's sales persons sell The Estimated sales under plan 2 would be 14,000 units Rely on wholesalers to sell The Cuiser.Crosby would sll The Cruiser to the wholesaler at $34 per unit. There would be no advertising program. Estimted sales would be 16,000 units under this plan. sell The Cruiser at a 12% commission. There would be no Cruiser at a 10% commission. Develop a S35,000 multi-media advertising program. 10 14 Rank the three approaches, highest to lowest, in ordei of net contribution margin (show all of your work and use formulas where appropriate in the cells! 15 16 17 18 19 20 Selling Price 1 Variable cost 22 Commissions 23 Contribution Margin 24 Unit sales 25 Total CM 26 Advertising costs 27 Net CM 28 29 if alternative 3 is chosen based on net CM and the actual sales do not meet expectations b 20% how much should Crosby increase the seling price to the wholesaler to make S 32,00 i 30 Prove your answer by showing all of your work Crosby Inc. CM Income Statement The Cruiser Alternative 1 Alternative2 Aternative 3 in 31 32 34 35 Module 02hoot Sheet2 Sheet3+