5-A4 (15-20 minutes)
1. Revenue ($360 x 70,000) $25,200,000
Total cost over product life 16,600,000
Estimated contribution to profit $ 8,600,000
Desired (target) contribution to profit
40% x $25,200,000 $10,080,000
Deficiency in profit $ 1,480,000
The product should not be released to production.
2. Previous total estimated cost $16,600,000
Cost savings from suppliers
.20 x .70 x $8,000,000 1,120,000
Revised total estimated cost $15,480,000
Revised total contribution to profit:
$25,200,000 – $15,480,000 $ 9,720,000
Desired (target) contribution to profit $10,080,000
Deficiency in profit $ 360,000
The product should not be released to production.
3. Previous revised total estimated cost from
requirement 2. $15,480,000
Process improvement savings:
.25 x .30 x $8,000,000 $600,000
Less cost of new technology 220,000 380,000
Revised total estimated cost 15,100,000
Revised total contribution to profit:
$25,200,000 – $15,100,000 $10,100,000
Desired (target) contribution to profit $10,080,000
Excess contribution to profit $ 20,000
The product should be released to production.
253