A B C E G H Target Pricing - (5 pts Each / 20 Points Total) 2 3 Cougar Fabricators still has the same costs outlined in "1-Life Cycle Pricing"but now wants to the determine the selling price using Target pricing. Th 5 have set the price at $100,000 per unit and require a minimum 50% return. 6 1a. Will the product meet their expectations for a 50% return? 1b. what is the exact return at a selling price of $100,000 per unit? 3 10 2. Cougar Fabricators wants to plan to give their employees a big bonus at the end of the 2 year cycle but need to hit a 30% return in order to 11 12 accomplish that goal; (2a) will the $100K target price allow them to hit this goal? Why/Why Not? 13 14 (2b) what would be the target price with a 30% return? 15 16 17 Show your work and calculate everything within excel to see the formulas you use to come up with your answers 18 13 20 Note that "Return" refers to the percentage a company wants left over from the selling price after the company has factored in what it costs to make it in other words 21 22 Return % = (Selling price - Cost)/Cost 23 24 25 26 27