Chapter 13 – Cost Planning for the Product Life Cycle: Target Costing, Theory of Constraints, and Strategic Pricing
13-40 Target Costing; Health Care (20 min)
1. The average cost is $257.14 = $263,169,095 ÷1,023,437
The current profit per enrollee is $368 – $257.14 = $110.86
Age
Enrollment
in 2016
Projected
Enrollment
in 2017
Average
Monthly Cost
in 2016
Avg Cost in
2016
Avg Cost in
2017 (+7%)
Projected
Cost in 2017
Age % in
2017
Age %
in 2017
1 to 4
45,
688
48,97
7 $ 11,147,872 244.00 261.08 $ 12,786,915 4.5% 4.6%
5 to 14
82,
456
84,66
3 10,059,632 122.00 130.54
11,051,90
8 8.1% 8.0%
15 to 19
95,
873
95,88
7 8,436,824 88.00 94.16
9,028,72
0 9.4% 9.1%
20 to 24
66,
246
67,88
2 9,539,424 144.00 154.08
10,459,25
9 6.5% 6.4%
133,
132,55
28,082,89
45 to 54
496
9 22,741,936 266.00 284.62
7 8.4% 8.6%
55 to 64
99,
624
101,92
3 28,691,712 288.00 308.16
31,408,59
2 9.7% 9.6%
65 to 74
156,
288
161,55
9 49,518,144 316.84 339.02
54,771,37
7 15.3% 15.3%
67,
72,46
38,180,93
TOTAL
1,023,
437 1,059,094 $263,169,095
$295,071,00
9 100.0% 100.0%
1,023,437
1,059,09
4
Average Cost $ 257.14 $ 278.61
Current Price $ 368.00
Current Profit Per Enrollee (Desired
Profit) $ 110.86 = 368 – 257.14 $ 110.86
13-22