Holdings, MPTC Inc.
Consolidated Management Summary Dec-04 Actual Workdays Month Gross revenue Adjustments Net revenue Cost of revenue Gross profit Gross profit margin Operating expense Selling expense General and administrative expense Bad debt expense EBITDA EBITDA margin Active customers Respiratory Diabetes Ostomy Urological Total Orders shipped Respiratory Diabetes Ostomy Urological Wound Care Total Employees Cash balance Accounts receivable balance (net) Inventory balance Cash collections Collection percentage Net days sales outstanding Inventory days on hand Capital expenditures 22 Dec-03 $13,012,703 (316,266) 12,696,438 5,573,967 7,122,470 56.1% 1,851,387 1,153,728 1,098,141 623,543 $2,395,671 18.9% 25,267 90,052 1,145 9,049 125,513 13,703 29,144 674 6,873 50,394 709 2,771,041 18,565,042 4,336,833 11,026,079 91.3% 47 23 $238,123 21 Jan-04 $11,012,655 (231,530) 10,781,125 4,927,134 5,853,991 54.3% 1,642,807 1,228,880 1,213,856 495,329 $1,273,119 11.8% 25,872 89,865 1,132 8,960 125,829 13,206 22,515 656 6,614 42,991 703 2,339,583 18,798,026 5,055,352 10,029,875 97.5% 49 30 $169,457 20 Feb-04 $10,829,248 (228,575) 10,600,672 4,909,560 5,691,112 53.7% 1,642,316 926,388 1,089,497 478,097 $1,554,815 14.7% 26,355 89,478 1,154 9,038 126,025 12,056 22,885 700 6,484 42,125 699 1,553,284 19,576,822 3,776,308 9,423,330 93.1% 52 22 $248,834 23 Mar-04 $12,406,985 (346,114) 12,060,871 5,589,165 6,471,706 53.7% 1,749,962 1,072,055 1,103,895 558,427 $1,987,367 16.5% 26,597 88,218 1,175 9,077 125,067 13,942 27,366 722 6,837 48,867 700 5,295,108 20,145,610 4,443,163 11,098,812 96.5% 54 26 $153,383 22 Apr-04 $11,642,281 (304,284) 11,337,997 5,429,430 5,908,567 52.1% 1,743,088 1,041,616 980,645 500,811 $1,642,406 14.5% 26,871 87,907 1,169 9,159 125,106 13,034 23,908 710 6,718 44,370 713 2,557,527 19,522,741 5,461,987 11,012,879 101.6% 52 31 $386,179 20 May-04 $11,322,477 (277,704) 11,044,773 5,196,452 5,848,321 53.0% 1,677,639 997,636 1,067,179 479,987 $1,625,880 14.7% 27,069 88,010 1,198 9,148 125,425 12,081 22,722 725 6,555 42,083 710 2,265,591 20,039,574 6,129,318 10,047,353 95.1% 52 34 $94,195 22 Jun-04 $13,117,575 (331,817) 12,785,758 6,017,047 6,768,712 52.9% 1,744,839 1,055,287 1,136,796 571,163 $2,260,627 17.7% 27,104 88,071 1,256 9,127 125,558 13,413 27,489 805 6,837 48,544 710 2,822,083 20,565,482 5,861,238 11,633,553 95.2% 53 32 $364,859 21 Jul-04 $14,202,606 (721,624) 13,480,982 6,179,068 7,301,914 54.2% 1,985,495 1,016,752 1,212,553 505,920 $2,581,194 19.1% 26,954 88,147 727 9,131 124,959 12,180 24,851 402 6,776 3,102 47,311 835 3,320,631 26,541,631 6,838,168 12,623,307 97.3% 57 33 $257,090 22 Aug-04 $14,919,132 (879,203) 14,039,929 6,195,544 7,844,385 55.9% 2,183,612 1,095,781 1,255,330 526,941 $2,782,722 19.8% 26,993 88,137 754 9,116 125,000 13,070 25,999 351 6,708 4,570 50,698 844 4,043,856 25,596,400 7,125,708 14,443,062 106.9% 54 34 $144,247 21 Sep-04 $15,464,536 (912,312) 14,552,224 6,434,401 8,117,823 55.8% 2,194,252 1,024,077 1,273,122 538,256 $3,088,116 21.2% 26,605 88,256 781 9,118 124,760 12,643 27,140 424 6,876 4,440 51,523 835 7,107,893 26,432,051 6,778,131 13,151,658 93.8% 56 32 $108,078 21 Oct-04 $14,543,388 (860,529) 13,682,859 6,219,484 7,463,375 54.5% 2,256,792 1,010,500 1,273,129 496,992 $2,425,963 17.7% 26,847 88,769 799 9,203 125,618 11,741 24,923 426 6,813 4,133 48,036 840 2,994,967 26,551,194 6,026,746 13,280,465 100.7% 57 29 $331,354 21 Nov-04 $14,767,247 (822,521) 13,944,726 6,022,442 7,922,284 56.8% 2,231,661 1,077,459 1,351,432 535,473 $2,726,259 19.6% 27,058 89,346 836 9,231 126,471 13,156 26,173 479 6,731 4,032 50,571 833 5,411,098 25,321,787 5,620,106 14,630,925 109.1% 54 27 $339,046 21 Dec-04 $15,818,948 (1,773,962) 14,044,986 7,578,165 6,466,821 46.0% 2,454,971 1,066,424 2,086,773 1,469,996 $(611,343) (4.4%) 26,711 88,844 871 9,362 125,788 13,858 28,699 462 6,921 4,028 53,968 830 6,611,315 22,803,015 5,528,263 14,202,587 112.9% 49 25 $168,293 YTD Dec-04 $160,047,078 (7,690,175) 152,356,903 70,697,891 81,659,012 53.6% 23,507,434 12,612,855 15,044,207 7,157,392 $23,337,124 15.3% 26,711 88,844 871 9,362 125,788 154,380 304,670 6,862 80,870 24,305 571,087 830 6,611,315 22,803,015 5,528,263 145,577,806 100.3% 49 25 $2,765,015 48 25 $117,170 48 25 $2,500,750 1 0 51,123 1 0 264,265 Budget YTD Current month Dec-04 Dec-04 $17,180,333 (683,521) 16,496,812 7,292,954 9,203,858 55.8% 2,638,627 1,228,989 1,475,721 596,184 $3,264,338 19.8% 28,610 97,332 1,474 10,191 137,607 15,304 29,794 845 7,886 3,741 57,570 941 $3,308,089 $27,380,846 $6,395,373 $165,814,200 (4,704,686) 161,109,514 71,894,618 89,214,896 55.4% 25,228,121 14,368,500 15,067,549 6,442,326 $28,108,400 17.4% 28,610 97,332 1,474 10,191 137,607 170,768 316,948 9,361 86,535 22,620 606,232 941 $3,308,089 $27,380,846 $6,395,373 Actual vs. budget YTD Current month Dec-04 Dec-04 $(1,361,385) (1,090,441) (2,451,826) 285,211 (2,737,037) (9.7%) (183,655) (162,565) 611,052 873,812 $(3,875,681) -24.1% (1,899) (8,488) (603) (829) (11,819) (1,446) (1,095) (383) (965) 287 (3,602) (111) $3,303,226 $(4,577,831) $(867,110) $(5,767,122) (2,985,489) (8,752,611) $(1,196,727) (7,555,884) (1.8%) (1,720,687) (1,755,645) (23,342) 715,066 $(4,771,275) (2.1%) (1,899) (8,488) (603) (829) (11,819) (16,388) (12,278) (2,499) (5,665) 1,685 (35,145) (111) $3,303,226 $(4,577,831) $(867,110)
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 1A
MPTC Holdings, Inc.
Consolidated Operating Margin Analysis Quarter ended December -04
Actual Year Quarter
Net revenue Costs and expenses:
2002 Q1 $8,428,047 Q2 $10,903,820 Q3 $23,238,755 Q4 $24,621,356 Q1 $24,070,398 Q2
2003 Q3 $27,293,615 Q4 $34,613,106 Q1 $33,442,668 Q2
2004 Q3 $42,073,136 Q4 $41,672,571
$25,561,393
$35,168,528
Cost of revenue Gross profit Operating expense Selling expense General and administrative expense Bad debt expense EBITDA Depreciation expense Amortization expense Other charges Operating income Interest expense Interest income Other (income) expense Net income before income taxes Income tax Net income
2,153,468 6,274,579 2,266,639 183,576 904,500 426,469 2,493,395 74,963 481,752 1,936,680 250,391 (31,852) 1,718,141 650,277 $1,067,864
3,107,978 7,795,842 2,855,813 462,952 1,176,789 656,472 2,643,816 118,280 508,437 3,605,113 (1,588,014) 265,380 (35,766) (1,817,628) 726,331 $(2,543,958)
8,321,218 14,917,537 5,260,193 1,816,432 2,036,906 1,581,379 4,222,627 334,626 1,785,673 2,102,328 547,985 (19,733) 1,574,076 929,223 $644,853
9,057,393 15,563,963 4,318,857 2,425,450 2,678,918 1,371,178 4,769,560 206,826 4,489,313 73,421 456,769 (14,907) (368,440) (1,832,490) $1,464,050
9,412,694 14,657,704 3,851,415 2,555,486 2,525,884 1,470,474 4,254,446 281,781 2,190,445 1,782,219 475,331 (12,255) 1,319,143 500,000 $819,143
10,277,329 15,284,064 4,050,184 2,866,293 2,635,619 1,545,728 4,186,240 269,942 2,263,266 1,653,032 459,990 (2,085) 2,013 1,193,116 505,882 $687,234
11,286,444 16,007,171 4,316,770 3,143,631 2,553,122 1,648,192 4,345,456 264,473 2,352,255 1,728,729 419,578 (2,816) 8,896 1,303,071 527,250 $775,822
14,995,277 19,617,829 5,126,464 3,324,210 2,871,036 1,719,611 6,576,508 313,142 1,953,695 4,309,670 1,007,888 (5,769) 872,178 2,435,373 978,157 $1,457,216
15,425,860 18,016,808 5,035,084 3,227,323 3,407,248 1,531,853 4,815,300 316,213 2,123,394 2,375,693 1,178,694 (2,789) 1,199,789 477,691 $722,098
16,642,929 18,525,599 5,165,566 3,094,539 3,184,620 1,551,961 5,528,913 308,934 1,749,404 3,470,575 1,176,920 (3,055) 2,296,709 908,073 $1,388,636
18,809,013 23,264,123 6,363,359 3,136,610 3,741,004 1,571,117 8,452,032 364,335 1,589,075 6,498,622 1,569,479 (6,287) 6,074,363 (1,138,934) (430,549) $(708,385)
19,820,090 21,852,481 6,943,424 3,154,383 4,711,334 2,502,461 4,540,879 337,566 2,773,470 1,429,843 2,090,050 (11,946) 2,466,999 (3,115,260) (955,215) $(2,160,045)
MPTC Holdings, Inc.
Consolidated Operating Margin Analysis Quarter ended December -04
Actual Year Quarter Net revenue Costs and expenses: Cost of revenue Gross profit Operating expense Selling expense General and administrative expense Bad debt expense EBITDA Depreciation expense Amortization expense Other charges Operating income Interest expense Interest income Other (income) expense Net income before income taxes Income tax Net income 2002 Q1 100.0% Q2 100.0% Q3 100.0% Q4 100.0% Q1 100.0% Q2 100.0% 2003 Q3 100.0% Q4 100.0% Q1 100.0% Q2 100.0% 2004 Q3 101.0% Q4 100.0%
25.6% 74.4% 26.9% 2.2% 10.7% 5.1% 29.6% 0.9% 5.7% 0.0% 23.0% 3.0% (0.4%) 0.0% 20.4% 7.7% 12.7%
28.5% 71.5% 26.2% 4.2% 10.8% 6.0% 24.2% 1.1% 4.7% 33.1% (14.6%) 2.4% (0.3%) 0.0% (16.7%) 6.7% (23.3%)
35.8% 64.2% 22.6% 7.8% 8.8% 6.8% 18.2% 1.4% 7.7% 0.0% 9.0% 2.4% (0.1%) 0.0% 6.8% 4.0% 2.8%
36.8% 63.2% 17.5% 9.9% 10.9% 5.6% 19.4% 0.8% 18.2% 0.0% 0.3% 1.9% (0.1%) 0.0% (1.5%) (7.4%) 5.9%
39.1% 60.9% 16.0% 10.6% 10.5% 6.1% 17.7% 1.2% 9.1% 0.0% 7.4% 2.0% (0.1%) 0.0% 5.5% 2.1% 3.4%
40.2% 59.8% 15.8% 11.2% 10.3% 6.0% 16.4% 1.1% 8.9% 0.0% 6.5% 1.8% 0.0% 0.0% 4.7% 2.0% 2.7%
41.4% 58.6% 15.8% 11.5% 9.4% 6.0% 15.9% 1.0% 8.6% 0.0% 6.3% 1.5% 0.0% 0.0% 4.8% 1.9% 2.8%
43.3% 56.7% 14.8% 9.6% 8.3% 5.0% 19.0% 0.9% 5.6% 0.0% 12.5% 2.9% 0.0% 2.5% 7.0% 2.8% 4.2%
46.1% 53.9% 15.1% 9.7% 10.2% 4.6% 14.4% 0.9% 6.3% 0.0% 7.1% 3.5% 0.0% 0.0% 3.6% 1.4% 2.2%
47.3% 52.7% 14.7% 8.8% 9.1% 4.4% 15.7% 0.9% 5.0% 0.0% 9.9% 3.3% 0.0% 0.0% 6.5% 2.6% 3.9%
45.1% 55.8% 15.3% 7.5% 9.0% 3.8% 20.3% 0.9% 3.8% 0.0% 15.6% 3.8% 0.0% 14.6% (2.7%) (1.0%) (1.7%)
47.6% 52.4% 16.7% 7.6% 11.3% 6.0% 10.9% 0.8% 6.7% 0.0% 3.4% 5.0% 0.0% 5.9% (7.5%) (2.3%) (5.2%)
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 1B
MPTC Holdings, Inc.
Consolidated Statement of Operations Dec-04
Actual Workdays Month Gross revenue Adjustments Net revenue Cost of revenue Gross profit Operating expense Selling expense General and administrative expense Bad debt expense EBITDA Depreciation expense Amortization expense Other charges Operating income Interest expense Interest income Other (income) expense Net income before income taxes Income tax Net income 22 Dec-03 $13,012,703 (316,266) 12,696,438 5,573,967 7,122,470 1,851,387 1,153,728 1,098,141 623,543 2,395,671 113,615 708,354 1,573,702 241,423 (3,047) 1,335,326 528,641 $806,685 21 Jan-04 $11,012,655 (231,530) 10,781,125 4,927,134 5,853,991 1,642,807 1,228,879 1,213,856 495,329 1,273,120 105,161 707,798 460,161 401,514 (822) 59,469 27,255 $32,214 20 Feb-04 $10,829,248 (228,575) 10,600,672 4,909,560 5,691,112 1,642,316 926,388 1,089,497 478,097 1,554,815 105,562 707,798 741,454 373,791 (803) 368,467 154,598 $213,869 23 Mar-04 $12,406,985 (346,114) 12,060,871 5,589,165 6,471,706 1,749,962 1,072,055 1,103,895 558,427 1,987,367 105,490 707,798 1,174,080 403,389 (1,164) 771,855 295,838 $476,017 22 Apr-04 $11,642,281 (304,284) 11,337,997 5,429,430 5,908,567 1,743,088 1,041,616 980,645 500,811 1,642,406 104,696 707,798 829,912 383,927 (1,157) 447,143 178,696 $268,447 20 May-04 $11,322,477 (277,704) 11,044,773 5,196,452 5,848,321 1,677,639 997,636 1,067,179 479,987 1,625,880 107,271 520,803 997,807 390,852 (985) 607,940 241,233 $366,707 22 Jun-04 $13,117,575 (331,817) 12,785,758 6,017,047 6,768,712 1,744,839 1,055,287 1,136,796 571,163 2,260,627 96,968 520,803 1,642,856 402,143 (912) 1,241,625 488,144 $753,481 21 Jul-04 $14,202,606 (721,624) 13,480,982 6,179,068 7,301,914 1,985,495 1,016,752 1,212,553 505,920 2,581,194 113,062 520,803 1,947,328 481,726 (1,709) 6,074,363 (4,607,051) (1,793,057) $(2,813,994) 22 Aug-04 $14,919,132 (879,203) 14,039,929 6,195,544 7,844,385 2,183,612 1,095,781 1,255,330 526,941 2,782,722 125,595 534,130 2,122,996 550,625 (2,026) 1,574,398 595,939 $978,459 21 Sep-04 $15,464,536 (912,312) 14,552,224 6,434,401 8,117,823 2,194,252 1,024,077 1,273,121 538,256 3,088,117 125,678 534,142 2,428,297 537,129 (2,551) 1,893,719 766,569 $1,127,150 21 Oct-04 $14,543,388 (860,529) 13,682,859 6,219,484 7,463,375 2,256,792 1,010,500 1,273,129 496,992 2,425,963 126,761 534,147 1,765,055 547,333 (3,248) 1,220,971 481,159 $739,812 21 Nov-04 $14,767,247 (822,521) 13,944,726 6,022,442 7,922,284 2,231,661 1,077,459 1,351,432 535,473 2,726,259 129,916 534,146 2,062,197 575,346 (3,661) 1,490,513 585,116 $905,397 21 Dec-04 $15,818,948 (1,773,962) 14,044,986 7,578,165 6,466,821 2,454,971 1,066,424 2,086,773 1,469,996 (611,343) 80,889 1,705,177 (2,397,409) 967,372 (5,037) 2,466,999 (5,826,743) (2,021,490) $(3,805,253) YTD Dec-04 $160,047,078 $(7,690,175) 152,356,903 70,697,891 81,659,012 23,507,434 12,612,855 15,044,206 7,157,392 23,337,125 1,327,048 8,235,344 13,774,733 6,015,144 (24,077) 8,541,362 (757,696) $(757,696)
Budget Current month Dec-04 $17,180,333 (683,521) 16,496,812 $7,292,954 9,203,858 2,638,627 1,228,989 1,475,721 596,184 3,264,338 128,009 521,355 2,614,974 412,118 2,202,856 535,060 $1,667,796
YTD Dec-04 $165,814,200 (4,704,686) 161,109,514 71,894,618 89,214,896 25,228,121 14,368,500 15,067,549 6,442,326 28,108,400 1,396,436 7,004,240 19,707,724 4,958,507 14,749,217 4,029,861 $10,719,356
Actual vs. budget Current month YTD Dec-04 Dec-04 $(1,361,385) (1,090,441) (2,451,826) 285,211 (2,737,037) (183,655) (162,565) 611,052 873,812 (3,875,681) (47,120) 1,183,822 (5,012,383) 555,254 (5,037) 2,466,999 (8,029,599) (2,556,550) $(5,473,049) $(5,767,122) (2,985,489) (8,752,611) (1,196,727) (7,555,884) (1,720,687) (1,755,645) (23,343) 715,066 (4,771,275) (69,388) 1,231,104 (5,932,990) 1,056,637 (24,077) 8,541,362 (15,506,912) (4,029,861) $(11,477,051)
Actual Workdays Month Gross revenue Adjustments Net revenue Cost of revenue Gross profit Operating expense Selling expense General and administrative expense Bad debt expense EBITDA Depreciation expense Amortization expense Other charges Operating income Interest expense Interest income Other (income) expense Net income before income taxes Income tax Net Income 22 Dec-03 102.5% (2.5%) 100.0% 43.9% 56.1% 14.6% 9.1% 8.6% 4.9% 18.9% 0.9% 5.6% 0.0% 12.4% 1.9% (0.0%) 0.0% 10.5% 4.2% 6.4% 21 Jan-04 102.1% (2.1%) 100.0% 45.7% 54.3% 15.2% 11.4% 11.3% 4.6% 11.8% 1.0% 6.6% 0.0% 4.3% 3.7% (0.0%) 0.0% 0.6% 0.3% 0.3% 20 Feb-04 102.2% (2.2%) 100.0% 46.3% 53.7% 15.5% 8.7% 10.3% 4.5% 14.7% 1.0% 6.7% 0.0% 7.0% 3.5% (0.0%) 0.0% 3.5% 1.5% 2.0% 23 Mar-04 102.9% (2.9%) 100.0% 46.3% 53.7% 14.5% 8.9% 9.2% 4.6% 16.5% 0.9% 5.9% 0.0% 9.7% 3.3% (0.0%) 0.0% 6.4% 2.5% 3.9% 22 Apr-04 102.7% (2.7%) 100.0% 47.9% 52.1% 15.4% 9.2% 8.6% 4.4% 14.5% 0.9% 6.2% 0.0% 7.3% 3.4% (0.0%) 0.0% 3.9% 1.6% 2.4% 20 May-04 102.5% (2.5%) 100.0% 47.0% 53.0% 15.2% 9.0% 9.7% 4.3% 14.7% 1.0% 4.7% 0.0% 9.0% 3.5% (0.0%) 0.0% 5.5% 2.2% 3.3% 22 Jun-04 102.6% (2.6%) 100.0% 47.1% 52.9% 13.6% 8.3% 8.9% 4.5% 17.7% 0.8% 4.1% 0.0% 12.8% 3.1% (0.0%) 0.0% 9.7% 3.8% 5.9% 21 Jul-04 105.4% (5.4%) 100.0% 45.8% 54.2% 14.7% 7.5% 9.0% 3.8% 19.1% 0.8% 3.9% 0.0% 14.4% 3.6% (0.0%) 45.1% (34.2%) (13.3%) (20.9%) 22 Aug-04 106.3% (6.3%) 100.0% 44.1% 55.9% 15.6% 7.8% 8.9% 3.8% 19.8% 0.9% 3.8% 0.0% 15.1% 3.9% (0.0%) 0.0% 11.2% 4.2% 7.0% 21 Sep-04 106.3% (6.3%) 100.0% 44.2% 55.8% 15.1% 7.0% 8.7% 3.7% 21.2% 0.9% 3.7% 0.0% 16.7% 3.7% (0.0%) 0.0% 13.0% 5.3% 7.7% 21 Oct-04 106.3% (6.3%) 100.0% 45.5% 54.5% 16.5% 7.4% 9.3% 3.6% 17.7% 0.9% 3.9% 0.0% 12.9% 4.0% (0.0%) 0.0% 8.9% 3.5% 5.4% 21 Nov-04 105.9% (5.9%) 100.0% 43.2% 56.8% 16.0% 7.7% 9.7% 3.8% 19.6% 0.9% 3.8% 0.0% 14.8% 4.1% (0.0%) 0.0% 10.7% 4.2% 6.5% 21 Dec-04 112.6% (12.6%) 100.0% 54.0% 46.0% 17.5% 7.6% 14.9% 10.5% (4.4%) 0.6% 12.1% 0.0% (17.1%) 6.9% (0.0%) 17.6% (41.5%) (14.4%) (27.1%) YTD Dec-04 105.0% (5.0%) 100.0% 46.4% 53.6% 15.4% 8.3% 9.9% 4.7% 15.3% 0.9% 5.4% 0.0% 9.0% 3.9% (0.0%) 5.6% (0.5%) 0.0% (0.5%)
Budget Current month Dec-04 104.1% (4.1%) 100.0% 44.2% 55.8% 16.0% 7.4% 8.9% 3.6% 19.8% 0.8% 3.2% 0.0% 15.9% 2.5% 0.0% 0.0% 13.4% 3.2% 10.1%
YTD Dec-04 102.9% (2.9%) 100.0% 44.6% 55.4% 15.7% 8.9% 9.4% 4.0% 17.4% 0.9% 4.3% 0.0% 12.2% 3.1% 0.0% 0.0% 9.2% 2.5% 6.7%
Actual vs. budget Current month YTD Dec-04 Dec-04 8.5% (8.5%) 0.0% 9.7% (9.7%) 1.5% 0.1% 6.0% 6.9% (24.2%) (0.2%) 9.0% 0.0% (33.0%) 4.4% (0.0%) 17.6% (54.9%) (17.6%) (37.2%) 2.1% (2.1%) 0.0% 1.8% (1.8%) (0.3%) (0.6%) 0.5% 0.7% (2.1%) 0.0% 1.1% 0.0% (3.2%) 0.9% (0.0%) 5.6% (9.7%) (2.5%) (7.2%)
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 1C
MPTC Holdings, Inc.
Consolidated Revenue Detail Dec-04 Actual Workdays Month Net revenue: Respiratory - direct to customer Pharmacy management American HomePatient Safeway AARP Other 22 Dec-03 21 Jan-04 20 Feb-04 23 Mar-04 22 Apr-04 20 May-04 22 Jun-04 21 Jul-04 22 Aug-04 21 Sep-04 21 Oct-04 21 Nov-04 21 Dec-04 YTD Dec-04 Budget Current month YTD Dec-04 Dec-04 Actual vs. budget Current month YTD Dec-04 Dec-04
$3,058,799 1,437,555 314,953 218,668 1,971,176
$2,501,982 1,305,662 295,626 201,761 1,803,049
$2,319,932 1,369,316 286,149 190,294 1,845,759
$2,694,462 1,424,587 427,592 203,298 2,055,477
$2,502,055 1,386,220 319,666 213,013 213,508 2,132,407
$2,359,744 1,285,073 284,942 457,094 193,959 2,221,068
$2,645,653 1,414,129 451,330 625,397 237,796 2,728,652
$2,366,407 1,386,598 320,632 829,557 216,960 2,753,747
$2,659,952 1,419,162 234,806 496,625 193,921 2,344,514
$2,425,767 1,451,144 451,310 557,552 240,294 2,700,300
$2,369,359 1,430,522 304,970 649,504 199,749 2,584,745
$2,538,139 1,398,934 286,400 526,647 217,077 2,429,058
$2,591,384 1,509,209 327,076 931,117 185,784 2,953,186
$29,974,837 16,780,556 3,990,499 5,286,506 2,494,402 28,551,963
$2,702,455 1,483,040 447,182 1,098,429 196,775 3,225,426
$30,539,836 16,709,827 4,576,067 7,487,227 2,281,109 31,054,230
$(111,071) 26,169 (120,106) (167,312) (10,991) (272,240)
$(564,999) 70,729 (585,568) (2,200,721) 213,293 (2,502,267)
Diabetes Government Commercial Diabetic Shoes MedShip Ostomy Pumps Urological Wheelchair Wound Care Other/Adjustments Total
4,370,494 898,662 29,187 5,298,343 67,198 139,081 2,224,897 62,158 (125,215) $12,696,437
3,470,845 574,438 37,311 4,082,594 193,298 109,837 2,159,878 29,686 (99,199) $10,781,125
3,474,603 560,166 72,803 4,107,572 90,158 126,201 2,120,071 39,007 (48,028) $10,600,672
4,128,007 637,864 24,833 4,790,704 186,574 136,576 2,292,508 34,825 (130,253) $12,060,872
3,639,272 544,190 23,150 4,206,612 243,053 128,156 2,219,871 38,356 (132,514) $11,337,997
3,415,809 622,725 4,343 4,042,877 232,401 134,507 2,152,113 42,907 (140,844) $11,044,773
4,224,467 791,965 5,647 5,022,079 152,312 157,748 2,201,634 26,633 (148,953) $12,785,758
3,783,482 612,038 1,841 4,397,360 284,787 79,023 171,058 2,073,032 58,634 1,460,633 (163,700) $13,480,982
3,895,145 565,245 1,242 4,461,632 115,082 86,170 187,212 2,227,429 52,954 2,041,132 (136,149) $14,039,929
4,165,060 622,784 (1,095) 4,786,749 72,015 77,828 237,376 2,229,612 64,628 2,112,963 (155,015) $14,552,224
3,763,027 647,963 (2,516) 4,408,474 80,957 80,617 205,650 2,136,116 101,234 1,890,782 (175,077) $13,682,858
3,973,906 623,503 (3,292) 4,594,117 79,007 101,950 234,270 2,249,793 35,785 1,805,200 (122,593) $13,944,726
4,455,562 605,426 (1,037) 5,059,951 90,627 92,356 116,919 2,268,164 61,643 1,910,339 (1,099,583) $14,044,986
46,389,184 7,408,307 163,230 53,960,721 1,820,271 1,310,970 1,152,485 26,330,221 586,292 11,221,050 (2,551,907) $152,356,904
4,510,216 776,589 44,520 5,331,325 106,533 145,096 181,750 2,570,052 154,454 2,214,723 (135,002) $16,496,812
48,095,589 7,521,332 628,050 56,244,971 1,022,400 1,621,077 993,547 28,011,276 1,474,218 11,648,294 (1,500,333) $161,109,516
(54,654) (171,163) (45,557) (271,374) (15,906) (52,740) (64,831) (301,888) (92,811) (304,384) (964,581) $(2,451,826)
(1,706,405) (113,025) (464,820) (2,284,250) 797,871 (310,107) 158,938 (1,681,055) (887,926) (427,244) (1,051,574) $(8,752,612)
MPTC Holdings, Inc.
Consolidated Revenue Detail Dec-04 Actual Workdays Month Workdays Month Net revenue: Respiratory - direct to customer Pharmacy management American HomePatient Safeway AARP Other 22 Dec-03 22 Dec-03 21 Jan-04 21 Jan-04 20 Feb-04 20 Feb-04 23 Mar-04 23 Mar-04 22 Apr-04 22 Apr-04 20 May-04 20 May-04 22 Jun-04 22 Jun-04 21 Jul-04 Actual 21 Jul-04 22 Aug-04 22 Aug-04 21 Sep-04 21 Sep-04 21 Oct-04 21 Oct-04 21 Nov-04 21 Nov-04 21 Dec-04 21 Dec-04 YTD Dec-04 YTD Dec-04 Budget Current month YTD Dec-04 Dec-04 Budget Current month YTD Dec-04 Dec-04 Actual vs. budget Current month YTD Dec-04 Dec-04 Actual vs. budget Current month YTD Dec-04 Dec-04
24.1% 11.3% 2.5% 0.0% 1.7% 15.5%
23.2% 12.1% 2.7% 0.0% 1.9% 16.7%
21.9% 12.9% 2.7% 0.0% 1.8% 17.4%
22.3% 11.8% 3.5% 0.0% 1.7% 17.0%
22.1% 12.2% 2.8% 1.9% 1.9% 18.8%
21.4% 11.6% 2.6% 4.1% 1.8% 20.1%
20.7% 11.1% 3.5% 4.9% 1.9% 21.3%
17.6% 10.3% 2.4% 6.2% 1.6% 20.4%
18.9% 10.1% 1.7% 3.5% 1.4% 16.7%
16.7% 10.0% 3.1% 3.8% 1.7% 18.6%
17.3% 10.5% 2.2% 4.7% 1.5% 18.9%
18.2% 10.0% 2.1% 3.8% 1.6% 17.4%
18.5% 10.7% 2.3% 6.6% 1.3% 21.0%
19.7% 11.0% 2.6% 3.5% 1.6% 18.7%
16.4% 9.0% 2.7% 6.7% 1.2% 19.6%
19.0% 10.4% 2.8% 4.6% 1.4% 19.3%
2.1% 1.7% (0.4%) (0.0%) 0.1% 1.4%
0.7% 0.6% (0.2%) (1.1%) 0.2% (0.5%)
Diabetes Government Commercial Diabetic Shoes
34.4% 7.1% 0.2% 41.7% 0.5% 1.1% 0.0% 17.5% 0.5% 0.0% (1.0%) 100.0%
32.2% 5.3% 0.3% 37.9% 1.8% 1.0% 0.0% 20.0% 0.3% 0.0% (0.9%) 100.0%
32.8% 5.3% 0.7% 38.7% 0.9% 1.2% 0.0% 20.0% 0.4% 0.0% (0.5%) 100.0%
34.2% 5.3% 0.2% 39.7% 1.5% 1.1% 0.0% 19.0% 0.3% 0.0% (1.1%) 100.0%
32.1% 4.8% 0.2% 37.1% 2.1% 1.1% 0.0% 19.6% 0.3% 0.0% (1.2%) 100.0%
30.9% 5.6% 0.0% 36.6% 2.1% 1.2% 0.0% 19.5% 0.4% 0.0% (1.3%) 100.0%
33.0% 6.2% 0.0% 39.3% 1.2% 1.2% 0.0% 17.2% 0.2% 0.0% (1.2%) 100.0%
28.1% 4.5% 0.0% 32.6% 2.1% 0.6% 1.3% 15.4% 0.4% 10.8% (1.2%) 100.0%
27.7% 4.0% 0.0% 31.8% 0.8% 0.6% 1.3% 15.9% 0.4% 14.5% (1.0%) 100.0%
28.6% 4.3% (0.0%) 32.9% 0.5% 0.5% 1.6% 15.3% 0.4% 14.5% (1.1%) 100.0%
27.5% 4.7% (0.0%) 32.2% 0.6% 0.6% 1.5% 15.6% 0.7% 13.8% (1.3%) 100.0%
28.5% 4.5% (0.0%) 32.9% 0.6% 0.7% 1.7% 16.1% 0.3% 12.9% (0.9%) 100.0%
31.7% 4.3% (0.0%) 36.0% 0.6% 0.7% 0.8% 16.1% 0.4% 13.6% (7.8%) 100.0%
30.4% 4.9% 0.1% 35.4% 1.2% 0.9% 0.8% 17.3% 0.4% 7.4% (1.7%) 100.0%
27.3% 4.7% 0.3% 32.3% 0.6% 0.9% 1.1% 15.6% 0.9% 13.4% (0.8%) 100.0%
29.9% 4.7% 0.4% 34.9% 0.6% 1.0% 0.6% 17.4% 0.9% 7.2% (0.9%) 100.0%
4.4% (0.4%) (0.3%) 3.7% (0.0%) (0.2%) (0.3%) 0.6% (0.5%) 0.2% (7.0%) 0.0%
0.5% 0.2% (0.3%) 0.5% 0.6% (0.1%) 0.1% (0.1%) (0.5%) 0.1% (0.7%) 0.0%
MedShip Ostomy Pumps Urological Wheelchair Wound Care Other Total
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 2A
MPTC Holdings, Inc.
Consolidated Gross Profit Detail Dec-04
Actual Workdays Month Respiratory - direct to customer Net revenue Cost of revenue Gross profit Pharmacy management American HomePatient Safeway AARP Other Total pharmacy management revenue Cost of revenue Gross profit Diabetes Government revenue Government cost of revenue Government gross profit Commercial revenue Commercial cost of revenue Commercial gross profit Diabetic Shoes Revenue Cost of revenue Gross profit MedShip Revenue Cost of revenue Gross profit Ostomy Revenue Cost of revenue Gross profit Pumps Revenue Cost of revenue Gross profit Urological Revenue Cost of revenue Gross profit Wheelchair Revenue Cost of revenue Gross profit Wound Care Revenue Cost of revenue Gross profit Shipping & Packaging Other Revenue Cost of revenue Gross profit Total Revenue Total Cost of Revenue Total gross profit 22 Dec-03 21 Jan-04 20 Feb-04 23 Mar-04 22 Apr-04 20 May-04 22 Jun-04 21 Jul-04 22 Aug-04 21 Sep-04 21 Oct-04 21 Nov-04 21 Dec-04 YTD Dec-04
Budget Current month Dec-04
YTD Dec-04
Actual vs. budget Current month YTD Dec-04 Dec-04
$3,058,799 425,124 2,633,675
$2,501,982 401,332 2,100,650
$2,319,932 403,400 1,916,532
$2,694,462 460,731 2,233,731
$2,502,055 424,085 2,077,970
$2,359,744 394,966 1,964,779
$2,645,653 443,428 2,202,225
$2,366,407 379,588 1,986,819
$2,659,952 488,473 2,171,479
$2,425,767 427,935 1,997,832
$2,369,359 410,669 1,958,690
$2,538,139 468,275 2,069,864
$2,591,384 535,691 2,055,693
$29,974,837 5,238,574 24,736,263
$2,702,455 309,815 2,392,640
$30,539,836 3,580,753 26,959,083
$(111,071) 225,876 (336,947)
$(564,999) 1,657,821 (2,222,820)
1,437,555 314,953 218,668 1,971,176 980,550 990,626
1,305,662 295,626 201,761 1,803,049 923,878 879,171
1,369,316 286,149 190,294 1,845,759 910,076 935,683
1,424,587 427,592 203,298 2,055,477 1,044,974 1,010,503
1,386,220 319,666 213,013 213,508 2,132,407 1,080,814 1,051,593
1,285,073 284,942 457,094 193,959 2,221,068 1,106,273 1,114,795
1,414,129 451,330 625,397 237,796 2,728,652 1,422,735 1,305,918
1,386,598 320,632 829,557 216,960 2,753,747 1,496,526 1,257,221
1,419,162 234,806 496,625 193,921 2,344,514 1,188,263 1,156,251
1,451,144 451,310 557,552 240,294 2,700,300 1,447,171 1,253,129
1,430,522 304,970 649,504 199,749 2,584,745 1,483,220 1,101,525
1,398,934 286,400 526,647 217,077 2,429,058 1,114,091 1,314,967
1,509,209 327,076 931,117 185,784 2,953,186 1,636,723 1,316,463
16,780,556 3,990,499 5,286,506 2,494,401 28,551,962 14,854,744 13,697,218
1,483,040 447,182 1,098,429 196,775 3,225,426 1,802,633 1,422,793
16,709,827 4,576,067 7,487,227 2,281,109 31,054,230 16,577,853 14,476,377
26,169 (120,106) (167,312) (10,991) (272,240) (165,910) (106,330)
70,729 (585,568) (2,200,721) 213,292 (2,502,268) (1,723,109) (779,159)
4,370,494 2,012,568 2,357,926 898,662 438,208 460,454 29,187 7,240 21,947
3,470,845 1,558,314 1,912,531 574,438 298,495 275,943 37,311 9,077 28,234
3,474,603 1,549,367 1,925,235 560,166 302,997 257,169 72,803 15,959 56,845
4,128,007 1,971,189 2,156,817 637,864 357,418 280,446 24,833 5,565 19,268
3,639,272 1,738,854 1,900,419 544,190 288,476 255,714 23,150 5,128 18,022
3,415,809 1,607,379 1,808,430 622,725 351,250 271,475 4,343 3,693 650
4,224,467 2,007,970 2,216,497 791,965 367,653 424,312 5,647 1,304 4,343
3,783,482 1,751,717 2,031,765 612,038 342,650 269,387 1,841 601 1,240
3,895,145 1,876,808 2,018,337 565,245 343,922 221,322 1,242 460 782
4,165,060 1,967,527 2,197,533 622,784 380,249 242,535 (1,095) (7) (1,088)
3,763,027 1,774,309 1,988,718 647,963 380,503 267,460 (2,516) (330) (2,186)
3,973,906 1,901,167 2,072,739 623,503 337,521 285,982 (3,292) (375) (2,917)
4,455,562 2,277,211 2,178,351 605,426 372,593 232,833 (1,037) 11,776 (12,813)
46,389,184 21,981,812 24,407,372 7,408,307 4,123,726 3,284,580 163,230 52,851 110,379
4,510,216 2,023,674 2,486,542 776,589 413,671 362,918 44,520 44,520
48,095,589 21,640,726 26,454,863 7,521,332 4,104,890 3,416,442 628,050 628,050
(54,654) 253,537 (308,191) (171,163) (41,078) (130,085) (45,557) 11,776 (57,333)
(1,706,405) 341,086 (2,047,491) (113,025) 18,836 (131,862) (464,820) 52,851 (517,671)
67,198 38,429 28,769
193,298 147,912 45,386
90,158 60,228 29,930
186,574 142,335 44,239
243,053 196,925 46,128
232,401 187,899 44,502
152,312 118,171 34,141
284,787 228,715 56,072
115,082 84,578 30,504
72,015 44,719 27,296
80,957 49,791 31,166
79,007 47,797 31,210
90,627 64,805 25,822
1,820,271 1,373,875 446,396
106,533 74,830 31,703
1,022,400 694,315 328,085
(15,906) (10,025) (5,881)
797,871 679,560 118,311
139,081 84,807 54,274
109,837 67,836 42,001
126,201 76,536 49,665
136,576 77,084 59,492
128,156 70,399 57,757
134,507 70,629 63,878
157,748 81,224 76,524
79,023 55,113 23,911
86,170 60,778 25,393
77,828 55,096 22,732
80,617 54,728 25,889
101,950 69,675 32,275
92,356 64,397 27,959
1,310,970 803,495 507,476
145,096 59,547 85,549
1,621,077 666,096 954,981
(52,740) 4,850 (57,590)
(310,107) 137,399 (447,505)
-
-
-
-
-
-
-
171,058 36,582 134,476
187,212 41,452 145,760
237,376 47,942 189,434
205,650 41,860 163,790
234,270 44,770 189,500
116,919 23,862 93,057
1,152,485 236,468 916,017
181,750 34,405 147,345
993,547 188,076 805,471
(64,831) (10,543) (54,288)
158,938 48,392 110,546
2,224,897 952,251 1,272,646
2,159,878 905,856 1,254,022
2,120,071 994,977 1,125,093
2,292,508 887,587 1,404,921
2,219,871 939,838 1,280,033
2,152,113 858,209 1,293,904
2,201,634 838,716 1,362,918
2,073,032 852,979 1,220,053
2,227,429 916,491 1,310,938
2,229,612 904,005 1,325,607
2,136,116 892,588 1,243,528
2,249,793 940,398 1,309,395
2,268,164 1,078,355 1,189,809
26,330,221 11,010,000 15,320,221
2,570,052 1,092,308 1,477,744
28,011,276 12,236,902 15,774,374
(301,888) (13,953) (287,935)
(1,681,055) (1,226,902) (454,153)
62,158 27,384 34,774
29,686 21,102 8,584
39,007 27,290 11,717
34,825 13,754 21,071
38,356 14,997 23,359
42,907 27,266 15,641
26,633 15,140 11,493
58,634 (487) 59,121
52,954 2,212 50,743
64,628 1,882 62,746
101,234 24,588 76,646
35,785 (5,832) 41,617
61,643 131,447 (69,804)
586,292 273,359 312,933
154,454 41,600 112,854
1,474,218 409,000 1,065,218
(92,811) 89,847 (182,658)
(887,926) (135,641) (752,285)
(607,407)
(593,332)
(568,729)
(628,527)
(669,915)
(588,888)
(720,706)
1,460,633 369,719 1,090,914 (664,850)
2,041,132 496,054 1,545,078 (696,002)
2,112,963 537,158 1,575,805 (620,474)
1,890,782 458,329 1,432,453 (648,231)
1,805,200 450,580 1,354,620 (654,375)
1,910,339 445,306 1,465,033 (779,999)
11,221,050 2,757,146 8,463,904 (7,834,029)
2,214,723 586,468 1,628,255 (858,900)
11,648,294 3,084,781 8,563,513 (8,771,325)
(304,384) (141,162) (163,222) 78,901
(427,244) (327,635) (99,609) 937,296
(125,215) (125,215) 12,696,437 5,573,967 $7,122,470
(99,199) (99,199) 10,781,125 4,927,134 $5,853,991
(48,028) (48,028) 10,600,672 4,909,560 $5,691,112
(130,253) (130,253) 12,060,872 5,589,165 $6,471,707
(132,514) (132,514) 11,337,997 5,429,430 $5,908,567
(140,844) (140,844) 11,044,773 5,196,452 $5,848,321
(148,953) (148,953) 12,785,758 6,017,047 $6,768,712
(163,700) 514 (164,214) 13,480,982 6,179,068 $7,301,914
(136,149) 50 (136,199) 14,039,929 6,195,544 $7,844,385
(155,015) 250 (155,265) 14,552,224 6,434,401 $8,117,823
(175,077) 998 (176,075) 13,682,858 6,219,484 $7,463,374
(122,593) (122,593) 13,944,726 6,022,442 $7,922,284
(1,099,583) 156,000 (1,255,583) 14,044,986 7,578,165 $6,466,821
(2,551,907) 157,812 (2,709,719) 152,356,903 70,697,890 $81,659,013
(135,002) (4,897) (130,105) 16,496,812 7,292,954 $9,203,858
(1,500,335) (60,099) (1,440,236) 161,109,514 71,894,618 $89,214,896
(964,581) 160,897 (1,125,478) (2,451,826) 285,211 $(2,737,037)
(1,051,572) 217,911 (1,269,483) (8,752,611) (1,196,728) $(7,555,883)
MPTC Holdings, Inc.
Consolidated Gross Profit Detail Dec-04
Actual Workdays Month Respiratory - direct to customer Pharmacy management Diabetes government Diabetes commercial Diabetic shoes MedShip Ostomy Pumps Urological Wheelchair Wound Care Shipping & Packaging Other Total gross profit 22 Dec-03 86.1% 50.3% 54.0% 51.2% 75.2% 42.8% 39.0% 0.0% 57.2% 55.9% 0.0% na na 56.1% 21 Jan-04 84.0% 48.8% 55.1% 48.0% 75.7% 23.5% 38.2% 0.0% 58.1% 28.9% 0.0% na na 54.3% 20 Feb-04 82.6% 50.7% 55.4% 45.9% 78.1% 33.2% 39.4% 0.0% 53.1% 30.0% 0.0% na na 53.7% 23 Mar-04 82.9% 49.2% 52.2% 44.0% 77.6% 23.7% 43.6% 0.0% 61.3% 60.5% 0.0% na na 53.7% 22 Apr-04 83.1% 49.3% 52.2% 47.0% 77.8% 19.0% 45.1% 0.0% 57.7% 60.9% 0.0% na na 52.1% 20 May-04 83.3% 50.2% 52.9% 43.6% 15.0% 19.1% 47.5% 0.0% 60.1% 36.5% 0.0% na na 53.0% 22 Jun-04 83.2% 47.9% 52.5% 53.6% 76.9% 22.4% 48.5% 0.0% 61.9% 43.2% 0.0% na na 52.9% 21 Jul-04 84.0% 45.7% 53.7% 44.0% 67.4% 19.7% 30.3% 78.6% 58.9% 100.8% 74.7% na na 54.2% 22 Aug-04 81.6% 49.3% 51.8% 39.2% 62.9% 26.5% 29.5% 77.9% 58.9% 95.8% 75.7% na na 55.9% 21 Sep-04 82.4% 46.4% 52.8% 38.9% 99.4% 37.9% 29.2% 79.8% 59.5% 97.1% 74.6% na na 55.8% 21 Oct-04 82.7% 42.6% 52.8% 41.3% 86.9% 38.5% 32.1% 79.6% 58.2% 75.7% 75.8% na na 54.5% 21 Nov-04 81.6% 54.1% 52.2% 45.9% 88.6% 39.5% 31.7% 80.9% 58.2% na 75.0% na na 56.8% 21 Dec-04 79.3% 44.6% 48.9% 38.5% 1235.6% 28.5% 30.3% 79.6% 52.5% na 76.7% na na 46.0% YTD Dec-04 82.5% 48.0% 52.6% 44.3% 67.6% 24.5% 38.7% 79.5% 58.2% 53.4% 75.4% na na 53.6%
Budget Current month Dec-04 88.5% 44.1% 55.1% 46.7% 100.0% 29.8% 59.0% 81.1% 57.5% 73.1% 73.5% na na 55.8%
YTD Dec-04 88.3% 46.6% 55.0% 45.4% 100.0% 32.1% 58.9% 81.1% 56.3% 72.3% 73.5% na na 55.4%
Actual vs. budget Current month YTD Dec-04 Dec-04 (9.2%) 0.5% (6.2%) (8.3%) 1135.6% (1.3%) (28.7%) (1.5%) (5.0%) na 3.2% na na (9.7%) (5.8%) 1.4% (2.4%) (1.1%) (32.4%) (7.6%) (20.2%) (1.6%) 1.9% (18.9%) 1.9% na na (1.8%)
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 2B
MPTC Holdings, Inc.
Consolidated Payor Mix Detail Dec-04
Actual Workdays Month Net revenue: Respiratory - direct to customer Medicare Respiratory - direct to customer Medicaid Respiratory - direct to customer commercial Total respiratory net revenue Pharmacy management American HomePatient Safeway AARP Other Total pharmacy management revenue Diabetes Government Medicare Government Medicaid Commercial Self Pay Total diabetic revenue Medship Ostomy Government Medicare Government Medicaid Commercial Self Pay Total ostomy revenue Urological Government Medicare Government Medicaid Commercial Self Pay Total Urological revenue Wheelchair Government Medicare Government Medicaid Commercial Self Pay Total wheelchair revenue Wound Care & Pumps Government Medicare Government Medicaid Commercial Self Pay Total wound care revenue Other Total 22 Dec-03 21 Jan-04 20 Feb-04 23 Mar-04 22 Apr-04 20 May-04 22 Jun-04 21 Jul-04 22 Aug-04 21 Sep-04 21 Oct-04 21 Nov-04 21 Dec-04 YTD Dec-04
$2,929,095 25,129 104,575 3,058,799
$2,362,358 23,941 115,683 2,501,982
$2,208,831 38,219 72,882 2,319,932
$2,571,372 44,737 78,353 2,694,462
$2,396,534 38,604 66,917 2,502,055
$2,254,948 38,699 66,097 2,359,744
$2,551,642 37,373 56,638 2,645,653
$2,278,473 33,014 54,920 2,366,407
$2,572,245 33,106 54,601 2,659,952
$2,332,744 31,319 61,704 2,425,767
$2,274,117 32,775 62,467 2,369,359
$2,439,811 35,824 62,504 2,538,139
$2,478,615 40,485 72,284 2,591,384
$28,721,689 428,096 825,050 29,974,836
1,437,555 314,953 218,668 1,971,176
1,305,662 295,626 201,761 1,803,049
1,369,316 286,149 190,294 1,845,759
1,424,587 427,592 203,298 2,055,477
1,386,220 319,666 213,013 213,508 2,132,407
1,285,073 284,942 457,094 193,959 2,221,068
1,414,129 451,330 625,397 237,796 2,728,652
1,386,598 320,632 829,557 216,960 2,753,747
1,419,162 234,806 496,625 193,921 2,344,514
1,451,144 451,310 557,552 240,294 2,700,300
1,430,522 304,970 649,504 199,749 2,584,745
1,398,934 286,400 526,647 217,077 2,429,058
1,509,209 327,076 931,117 185,784 2,953,186
16,780,556 3,990,499 5,286,506 2,494,401 28,551,962
4,290,733 107,141 900,469 5,298,343 67,198
3,417,793 90,363 574,437 4,082,593 193,298
3,456,034 89,913 561,625 4,107,572 90,158
4,049,824 101,947 638,933 4,790,704 186,574
3,570,571 91,850 544,190 4,206,612 243,053
3,328,691 91,077 623,109 4,042,877 232,401
4,124,371 104,980 792,728 5,022,079 152,312
3,686,394 98,435 612,532 4,397,361 284,787
3,794,658 101,729 565,245 4,461,632 115,082
4,058,349 105,616 622,784 4,786,749 72,015
3,661,909 98,602 647,963 4,408,474 80,957
3,867,272 103,342 623,503 4,594,117 79,007
4,344,578 109,947 605,426 5,059,951 90,627
45,360,444 1,187,803 7,412,475 53,960,721 1,820,271
27,704 53,673 57,704 139,081
35,355 52,923 21,560 109,838
39,752 51,664 34,786 126,201
40,960 67,483 28,134 136,576
41,447 56,810 29,900 128,156
51,822 51,193 31,492 134,507
60,432 58,247 39,069 157,748
35,307 19,468 24,249 79,023
44,791 18,541 22,838 86,170
45,056 14,227 18,545 77,828
39,801 14,761 26,055 80,617
53,537 18,026 30,388 101,951
44,944 21,246 26,166 92,356
533,203 444,588 333,181 1,310,972
626,106 942,888 655,904 2,224,898
615,407 962,779 581,692 2,159,878
608,379 910,350 601,342 2,120,071
632,698 1,065,907 593,902 2,292,507
645,117 952,490 622,264 2,219,871
643,195 921,038 587,880 2,152,113
734,479 885,654 581,500 2,201,633
527,821 919,832 625,379 2,073,032
715,218 900,495 611,717 2,227,430
641,819 924,845 662,948 2,229,612
625,071 885,220 625,825 2,136,116
707,651 885,679 656,463 2,249,793
653,110 919,408 695,646 2,268,164
7,749,964 11,133,697 7,446,558 26,330,219
34,790 17,248 10,120 62,158
27,411 575 1,700 29,686
37,974 605 428 39,007
24,260 515 10,049 34,825
31,562 661 6,132 38,355
35,244 323 7,340 42,907
16,390 284 9,961 26,635
55,441 435 2,758 58,634
50,592 314 2,048 52,954
63,626 439 564 64,629
84,424 1,662 15,148 101,234
33,363 1,091 1,331 35,785
52,363 746 8,535 61,644
512,650 7,650 65,996 586,296
(125,215) $12,696,438
(99,199) $10,781,125
(48,028) $10,600,672
(130,253) $12,060,872
(132,514) $11,337,996
(140,844) $11,044,773
(148,954) $12,785,758
783,227 188,109 592,625 77,871 1,641,831 (173,840) $13,480,982
1,078,413 237,225 816,562 107,648 2,239,849 (147,655) $14,039,929
1,143,762 252,500 855,374 113,519 2,365,155 (169,832) $14,552,224
1,022,903 219,299 764,912 99,922 2,107,035 (185,680) $13,682,858
971,250 203,191 797,930 77,732 2,050,103 (133,226) $13,944,726
1,029,882 196,348 720,680 87,780 2,034,690 (1,107,016) $14,044,986
6,029,437 1,296,671 4,548,083 564,472 12,438,664 (2,617,040) $152,356,902
Actual Workdays Month Medicare Medicaid Commercial Self Pay Other Pharmacy Management American HomePatient Safeway AARP Other 22 Dec-03 62.3% 9.0% 13.6% 0.0% (0.5%) 21 Jan-04 59.9% 10.5% 12.0% 0.0% 0.9% 20 Feb-04 59.9% 10.3% 12.0% 0.0% 0.4% 23 Mar-04 60.7% 10.6% 11.2% 0.0% 0.5% 22 Apr-04 59.0% 10.1% 11.2% 0.0% 1.0% 20 May-04 57.2% 10.0% 11.9% 0.0% 0.8% 22 Jun-04 58.6% 8.5% 11.6% 0.0% 0.0% 21 Jul-04 54.6% 9.3% 14.2% 0.6% 0.8% 22 Aug-04 58.8% 9.2% 14.8% 0.8% (0.2%) 21 Sep-04 56.9% 9.1% 15.3% 0.8% (0.7%) 21 Oct-04 56.3% 9.2% 15.7% 0.7% (0.8%) 21 Nov-04 57.9% 8.9% 15.6% 0.6% (0.4%) 21 Dec-04 61.3% 9.2% 15.2% 0.6% (7.2%) YTD Dec-04 58.4% 9.5% 13.5% 0.4% -0.5%
11.3% 2.5% 0.0% 1.7% 15.5% 100.0%
12.1% 2.7% 0.0% 1.9% 16.7% 100.0%
12.9% 2.7% 0.0% 1.8% 17.4% 100.0%
11.8% 3.5% 0.0% 1.7% 17.0% 100.0%
12.2% 2.8% 1.9% 1.9% 18.8% 100.0%
11.6% 2.6% 4.1% 1.8% 20.1% 100.0%
11.1% 3.5% 4.9% 1.9% 21.3% 100.0%
10.3% 2.4% 6.2% 1.6% 20.4% 100.0%
10.1% 1.7% 3.5% 1.4% 16.7% 100.0%
10.0% 3.1% 3.8% 1.7% 18.6% 100.0%
10.5% 2.2% 4.7% 1.5% 18.9% 100.0%
10.0% 2.1% 3.8% 1.6% 17.4% 100.0%
10.7% 2.3% 6.6% 1.3% 21.0% 100.0%
11.0% 2.6% 3.5% 1.6% 18.7% 100.0%
Total
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 2C
MPTC Holdings, Inc.
Consolidated Customer Trend Dec-04 Actual 22 Jun-04 177,340 4,953 na 27,104 35 4,187 83,047 (4) 8,969 5,024 65 (1,184) 88,071 61 7,785 1,256 58 na 9,127 (21) na 28,906 8,156 9,962 4,758 51,782 4,820 14,081
Workdays Month All customers Month to month growth Year to year growth Respiratory - direct to customer Month to month growth Year to year growth Diabetes Government Month to month growth Year to year growth Commercial Month to month growth Year to year growth Total Month to month growth Year to year growth Ostomy Month to month growth Year to year growth Urological Month to month growth Year to year growth Pharmacy management American Home Patient Safeway AARP Other Total Month to month growth Year to year growth
22 Dec-03 165,180 4,129 na 25,267 589 4,545 84,739 2,124 16,911 5,313 (1,066) (1,098) 90,052 1,058 15,813 1,145 53 na 9,049 1,120 na 28,726 6,486 4,455 39,667 1,309 8,785
21 Jan-04 166,391 1,211 na 25,872 605 4,631 84,939 200 16,460 4,926 (387) (1,329) 89,865 (187) 15,131 1,132 (13) na 8,960 (89) na 29,108 6,833 4,621 40,562 895 9,145
20 Feb-04 166,729 338 na 26,355 483 4,695 84,622 (317) 15,945 4,856 (70) (1,317) 89,478 (387) 14,628 1,154 22 na 9,038 78 na 28,974 7,170 4,560 40,704 142 7,815
23 Mar-04 166,624 (105) na 26,597 242 22,603 83,381 (1,241) 12,281 4,837 (19) (1,229) 88,218 (1,260) 11,052 1,175 21 na 9,077 39 na 29,384 7,515 4,658 41,557 853 8,286
22 Apr-04 167,388 764 na 26,871 274 3,975 83,038 (343) 10,530 4,869 32 (1,226) 87,907 (311) 9,304 1,169 (6) na 9,159 82 na 29,543 7,763 232 4,744 42,282 725 8,078
20 May-04 172,387 4,999 na 27,069 198 4,096 83,051 13 10,055 4,959 90 (1,189) 88,010 103 8,866 1,198 29 na 9,148 (11) na 29,684 7,969 4,471 4,838 46,962 4,680 11,108
21 Jul-04 180,097 2,757 na 26,954 (150) 4,316 83,046 (1) 6,653 5,101 77 (1,120) 88,147 76 5,533 727 (529) na 9,131 4 na 28,417 8,308 13,661 4,752 55,138 3,356 16,492
22 Aug-04 182,162 2,065 na 26,993 39 3,632 82,992 (54) 4,675 5,145 44 (1,139) 88,137 (10) 3,536 754 27 na 9,116 (15) na 28,018 8,415 15,972 4,757 57,162 2,024 18,430
21 Sep-04 183,241 1,079 na 26,605 (388) 3,049 83,027 35 3,683 5,229 84 (1,015) 88,256 119 2,668 781 27 na 9,118 2 na 28,029 8,509 17,190 4,753 58,481 1,319 18,347
21 Oct-04 186,450 3,209 na 26,847 242 2,717 83,420 393 585 5,349 120 (932) 88,769 513 (347) 799 18 (254) 9,203 85 1,430 28,066 8,567 19,411 4,788 60,832 2,351 19,730
21 Nov-04 189,776 3,326 na 27,058 211 2,380 83,869 449 1,254 5,477 128 (902) 89,346 577 352 836 37 (256) 9,231 28 1,302 28,581 8,614 21,346 4,764 63,305 2,473 21,076
21 Dec-04 191,188 1,412 na 26,711 (347) 1,444 83,306 (563) (1,433) 5,538 61 225 88,844 (502) (1,208) 871 35 (274) 9,362 131 313 28,735 8,610 23,353 4,702 65,400 2,095 32,671
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 3A
MPTC Holdings, Inc.
Consolidated Customer Activity Dec-04
Actual Workdays Month All customers Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate Respiratory - direct to customer Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate 22 Dec-03 21 Jan-04 20 Feb-04 23 Mar-04 22 Apr-04 20 May-04 22 Jun-04 21 Jul-04 22 Aug-04 21 Sep-04 21 Oct-04 21 Nov-04 21 Dec-04 YTD Dec-04
Budget Current YTD month Dec-04 Dec-04
Actual vs. budget Current YTD month Dec-04 Dec-04
122,693 3,368 215 636 3,492 (4,891) 125,513 72,422 3,368 215 46,183 636 50,402 (586) 4.0% 63.8%
125,513 3,448 99 405 (3,636) 125,829 73,884 3,448 99 39,039 405 42,991 (384) 2.9% 52.8%
125,829 3,095 44 462 (3,405) 126,025 76,303 3,095 44 38,527 459 42,125 (558) 2.7% 50.5%
126,025 3,429 69 427 (4,883) 125,067 82,081 3,429 69 44,942 427 48,867 (679) 3.9% 54.8%
125,067 3,248 51 403 (3,663) 125,106 76,396 3,248 51 40,668 403 44,370 (627) 2.9% 53.2%
125,106 2,982 37 377 (3,077) 125,425 75,674 2,982 37 38,687 377 42,083 (422) 2.5% 51.1%
125,425 3,177 33 411 (3,488) 125,558 80,262 3,177 33 44,923 411 48,544 (485) 2.8% 56.0%
125,558 2,937 422 (3,958) 124,959 76,962 2,937 40,850 422 44,209 (441) 3.2% 53.1%
124,959 3,186 321 (3,466) 125,000 74,361 3,186 42,622 320 46,128 (569) 2.8% 57.3%
125,000 3,380 382 (4,002) 124,760 75,876 3,380 43,321 382 47,083 (423) 3.2% 57.1%
124,760 3,551 614 (3,307) 125,618 73,562 3,551 39,738 614 43,903 (433) 2.7% 54.0%
125,618 3,368 473 (2,988) 126,471 75,368 3,368 42,698 473 46,539 (523) 2.4% 56.7%
126,471 3,522 393 (4,598) 125,788 77,128 3,522 46,025 393 49,940 (522) 3.6% 59.7%
125,513 39,323 333 5,090 (44,471) 125,788 77,128 39,323 333 502,040 5,086 546,782 (6,066) 3.2% 54.2%
135,816 5,048 352 (3,610) 137,606 81,189 5,048 48,429 352 53,829 (685) 2.7% 59.6%
125,513 50,126 4,151 (42,184) 137,606 81,189 50,126 529,334 4,151 583,612 (7,241) 2.7% 57.2%
(9,345) (1,526) 41 (988) (11,818) (4,061) (1,526) (2,404) 41 (3,889) 163 1.0% 0.0%
(10,803) 333 939 (2,287) (11,818) (4,061) (10,803) 333 (27,294) 935 (36,830) 1,175 0.5% (3.0%)
24,678 1,684 9 9 (1,113) 25,267 24,678 1,684 9 12,001 9 13,703 4.5% 48.6%
25,267 1,673 1 11 (1,080) 25,872 25,267 1,673 1 11,521 11 13,206 4.3% 45.6%
25,872 1,535 2 14 (1,068) 26,355 25,872 1,535 2 10,505 14 12,056 4.1% 40.6%
26,355 1,630 37 (1,425) 26,597 26,355 1,630 12,275 37 13,942 5.4% 46.6%
26,597 1,508 5 18 (1,257) 26,871 26,597 1,508 5 11,503 18 13,034 4.7% 43.2%
26,871 1,298 6 7 (1,113) 27,069 26,871 1,298 6 10,770 7 12,081 4.1% 40.1%
27,069 1,273 2 11 (1,251) 27,104 27,069 1,273 2 12,127 11 13,413 4.6% 44.8%
27,104 991 14 (1,155) 26,954 27,104 991 11,175 14 12,180 4.3% 41.2%
26,954 1,004 4 (969) 26,993 26,954 1,004 12,062 4 13,070 3.6% 44.8%
26,993 1,127 7 (1,522) 26,605 26,993 1,127 11,509 7 12,643 5.6% 42.6%
26,605 1,172 11 (941) 26,847 26,605 1,172 10,558 11 11,741 3.5% 39.7%
26,847 1,251 3 (1,043) 27,058 26,847 1,251 11,902 3 13,156 3.9% 44.3%
27,058 1,396 5 (1,748) 26,711 27,058 1,396 12,457 5 13,858 4.4% 43.0%
25,267 15,858 16 142 (14,572) 26,711 27,058 15,858 16 138,364 142 154,380 4.4% 43.0%
28,313 1,430 (1,133) 28,610 28,313 1,430 13,874 15,304 4.0% 49.0%
25,267 16,324 (12,981) 28,610 28,313 16,324 154,444 170,768 4.0% 47.6%
(1,255) (34) 5 (615) (1,899) (1,255) (34) (1,417) 5 (1,446) 0% (6.0%)
(466) 16 142 (1,591) (1,899) (1,255) (466) 16 (16,080) 142 (16,388) 0% (4.6%)
MPTC Holdings, Inc.
Consolidated Customer Activity Dec-04
Actual Workdays Month Diabetes government Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate Diabetes commercial Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate 22 Dec-03 82,615 1,302 185 431 2,710 (2,504) 84,739 35,891 1,302 185 25,093 431 27,011 (509) 3.0% 69.9% 21 Jan-04 84,739 1,468 84 281 (1,633) 84,939 35,243 1,468 84 19,226 281 21,059 (303) 1.9% 54.6% 20 Feb-04 84,939 1,289 35 298 (1,939) 84,622 36,869 1,289 35 19,686 295 21,305 (432) 2.3% 53.4% 23 Mar-04 84,622 1,361 67 259 (2,928) 83,381 42,258 1,361 67 23,934 259 25,621 (570) 3.5% 56.6% 22 Apr-04 83,381 1,333 42 254 (1,972) 83,038 36,455 1,333 42 20,812 254 22,441 (527) 2.4% 57.1% 20 May-04 83,038 1,277 27 282 (1,573) 83,051 35,070 1,277 27 19,521 282 21,107 (361) 1.9% 55.7% 22 Jun-04 83,051 1,452 28 261 (1,745) 83,047 39,503 1,452 28 24,006 261 25,747 (418) 2.1% 60.8% 21 Jul-04 83,047 1,526 309 (1,836) 83,046 36,193 1,526 21,290 309 23,125 (349) 2.2% 58.8% 22 Aug-04 83,046 1,671 205 (1,930) 82,992 34,174 1,671 22,272 204 24,147 (480) 2.3% 65.2% 21 Sep-04 82,992 1,751 242 (1,958) 83,027 35,720 1,751 23,195 242 25,188 (351) 2.4% 64.9% 21 Oct-04 83,027 1,930 487 (2,024) 83,420 33,781 1,930 20,735 487 23,152 (361) 2.4% 61.4% 21 Nov-04 83,420 1,679 364 (1,594) 83,869 34,941 1,679 22,121 364 24,164 (455) 1.9% 63.3% 21 Dec-04 83,869 1,646 295 (2,504) 83,306 36,535 1,646 24,509 295 26,450 (403) 3.0% 67.1% YTD Dec-04 84,739 18,383 283 3,537 (23,636) 83,306 36,535 18,383 283 261,307 3,533 283,506 (5,010) 2.5% 59.2%
Budget Current YTD month Dec-04 Dec-04 90,697 3,064 247 (1,996) 92,012 39,287 3,064 24,541 247 27,852 (583) 2.2% 62.5% 84,983 27,304 2,970 (23,245) 92,012 39,287 27,304 267,425 2,969 297,698 (6,237) 2.2% 59.3%
Actual vs. budget Current YTD month Dec-04 Dec-04 (6,828) (1,418) 48 (508) (8,706) (2,752) (1,418) (32) 48 (1,402) 180 0.8% 4.6% (244) (8,921) 283 567 (391) (8,706) (2,752) (8,921) 283 (6,118) 564 (14,192) 1,227 0.3% (0.1%)
6,379 119 5 23 (1,213) 5,313 2,832 119 5 1,986 23 2,133 (66) 19.0% 70.1%
5,313 115 3 36 (541) 4,926 3,180 115 3 1,302 36 1,456 (55) 10.2% 40.9%
4,926 67 3 27 (167) 4,856 3,470 67 3 1,483 27 1,580 (103) 3.4% 42.7%
4,856 151 18 (188) 4,837 3,276 151 1,576 18 1,745 (84) 3.9% 48.1%
4,837 134 3 36 (141) 4,869 3,092 134 3 1,294 36 1,467 (86) 2.9% 41.8%
4,869 166 1 19 (96) 4,959 3,405 166 1 1,429 19 1,615 (41) 2.0% 42.0%
4,959 167 3 28 (133) 5,024 3,344 167 3 1,544 28 1,742 (59) 2.7% 46.2%
5,024 161 13 (97) 5,101 3,282 161 1,552 13 1,726 (53) 1.9% 47.3%
5,101 240 38 (234) 5,145 3,375 240 1,574 38 1,852 (70) 4.6% 46.6%
5,145 213 26 (155) 5,229 3,293 213 1,713 26 1,952 (40) 3.0% 52.0%
5,229 201 22 (103) 5,349 3,277 201 1,548 22 1,771 (55) 2.0% 47.2%
5,349 200 22 (94) 5,477 3,578 200 1,787 22 2,009 (34) 1.8% 49.9%
5,477 163 14 (116) 5,538 3,468 163 2,072 14 2,249 (78) 2.1% 59.7%
5,313 1,978 13 299 (2,065) 5,538 3,468 1,978 13 18,874 299 21,164 (758) 3.5% 45.9%
5,267 238 25 (210) 5,320 2,048 238 1,679 25 1,942 (96) 4.0% 82.0%
5,069 2,501 276 (2,526) 5,320 2,048 2,501 16,473 276 19,250 (930) 4.2% 79.1%
210 (75) (11) 94 218 1,420 (75) 393 (11) 307 18 (1.9%) (22.2%)
244 (523) 13 23 461 218 1,420 (523) 13 2,401 23 1,914 172 (0.7%) (33.2%)
MPTC Holdings, Inc.
Consolidated Customer Activity Dec-04
Actual Workdays Month Ostomy Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate Urological Beginning active customers New customers Acquired customers Reactivations Transfers Attrition Ending active customers Eligible customers New customer orders Acquired new customer orders Reorders Reactivations Orders shipped Returns Attrition rate Reorder rate 22 Dec-03 1,092 37 16 1,145 1,092 37 629 16 682 0.0% 57.6% 21 Jan-04 1,145 33 12 (58) 1,132 1,145 33 611 12 656 5.1% 53.4% 20 Feb-04 1,132 30 28 (36) 1,154 1,132 30 642 28 700 3.2% 56.7% 23 Mar-04 1,154 61 20 (60) 1,175 1,154 61 641 20 722 5.2% 55.5% 22 Apr-04 1,175 50 13 (69) 1,169 1,175 50 647 13 710 5.9% 55.1% 20 May-04 1,169 54 13 (38) 1,198 1,169 54 658 13 725 3.3% 56.3% 22 Jun-04 1,198 83 31 (56) 1,256 1,198 83 691 31 805 4.7% 57.7% 21 Jul-04 1,256 32 7 (568) 727 1,256 32 363 7 402 45.2% 28.9% 22 Aug-04 727 42 6 (21) 754 727 42 303 6 351 2.9% 41.7% 21 Sep-04 754 30 12 (15) 781 754 30 382 12 424 2.0% 50.7% 21 Oct-04 781 23 9 (14) 799 781 23 394 9 426 1.8% 50.4% 21 Nov-04 799 44 11 (18) 836 799 44 424 11 479 2.3% 53.1% 21 Dec-04 836 41 9 (15) 871 836 41 412 9 462 1.8% 49.3% YTD Dec-04 1,145 523 171 (968) 871 836 523 6,168 171 6,862 7.7% 50.9%
Budget Current YTD month Dec-04 Dec-04 1,450 34 14 (24) 1,474 1,450 34 797 14 845 (8) 1.7% 55.0% 1,145 560 148 (379) 1,474 1,450 560 8,653 148 9,361 (88) 2.4% 55.8%
Actual vs. budget Current YTD month Dec-04 Dec-04 (614) 7 (5) 9 (603) (614) 7 (385) (5) (383) 8 0.1% (5.7%) (37) 23 (589) (603) (614) (37) (2,485) 23 (2,499) 88 5.3% (4.9%)
7,929 16 226 157 782 (61) 9,049 7,929 226 16 6,474 157 6,873 (11) 0.8% 81.6%
9,049 159 11 65 (324) 8,960 9,049 159 11 6,379 65 6,614 (26) 3.6% 70.5%
8,960 174 4 95 (195) 9,038 8,960 174 4 6,211 95 6,484 (23) 2.2% 69.3%
9,038 226 2 93 (282) 9,077 9,038 226 2 6,516 93 6,837 (25) 3.1% 72.1%
9,077 223 1 82 (224) 9,159 9,077 223 1 6,412 82 6,718 (14) 2.5% 70.6%
9,159 187 3 56 (257) 9,148 9,159 187 3 6,309 56 6,555 (20) 2.8% 68.9%
9,148 202 80 (303) 9,127 9,148 202 6,555 80 6,837 (8) 3.3% 71.7%
9,127 227 79 (302) 9,131 9,127 227 6,470 79 6,776 (39) 3.3% 70.9%
9,131 229 68 (312) 9,116 9,131 229 6,411 68 6,708 (19) 3.4% 70.2%
9,116 259 95 (352) 9,118 9,116 259 6,522 95 6,876 (32) 3.9% 71.5%
9,118 225 85 (225) 9,203 9,118 225 6,503 85 6,813 (17) 2.5% 71.3%
9,203 194 73 (239) 9,231 9,203 194 6,464 73 6,731 (34) 2.6% 70.2%
9,231 276 70 (215) 9,362 9,231 276 6,575 70 6,921 (41) 2.3% 71.2%
9,049 2,581 21 941 (3,230) 9,362 9,231 2,581 21 77,327 941 80,870 (298) 3.2% 70.7%
10,090 282 66 (247) 10,191 10,090 282 7,538 66 7,886 (73) 2.4% 74.7%
9,049 3,438 758 (3,054) 10,191 10,090 3,438 82,339 758 86,535 (819) 2.7% 72.1%
(859) (6) 4 32 (829) (859) (6) (963) 4 (965) 32 (0.1%) (3.5%)
(857) 21 183 (176) (829) (859) (857) 21 (5,012) 183 (5,665) 521 0.6% (1.4%)
Note: Ostomy numbers prior to July 2004 included wound care. Post July 2004, only Ostomy customers are counted. Therefore, prior months are not comparable.
Prepared By: HP 03/01/05 Reviewed By: 3B
MPTC Holdings, Inc.
Consolidated Pharmacy Management Customer Activity Dec-04 Actual 22 21 Jun-04 Jul-04
Workdays Month All customers Beginning active customers New customers Attrition Ending active customers New orders Reorders Orders Attrition rate American Home Patient Beginning active customers New customers Attrition Ending active customers New orders Reorders Orders shipped Attrition rate AARP Beginning active customers New customers Attrition Ending active customers New orders Reorders Orders shipped Attrition rate Safeway Beginning active customers New customers Attrition Ending active customers New orders Reorders Orders shipped Attrition rate
22 Dec-03
21 Jan-04
20 Feb-04
23 Mar-04
22 Apr-04
20 May-04
22 Aug-04
21 Sep-04
21 Oct-04
21 Nov-04
21 Dec-04
YTD Dec-04
38,358 2,384 (1,075) 39,667 2,384 22,087 24,471 2.8% 27,900 1,642 (816) 28,726 1,642 18,516 20,158 2.9% 0.0%
39,667 2,346 (1,451) 40,562 2,346 19,128 21,474 3.7% 28,726 1,579 (1,197) 29,108 1,579 15,868 17,447 4.2% 0.0%
40,562 2,005 (1,863) 40,704 2,005 20,569 22,574 4.6% 29,108 1,318 (1,452) 28,974 1,318 17,135 18,453 5.0% 0.0%
40,704 2,238 (1,385) 41,557 2,238 22,552 24,790 3.4% 28,974 1,483 (1,073) 29,384 1,483 18,280 19,763 3.7% 0.0%
41,557 2,221 (1,496) 42,282 2,221 21,108 23,329 3.6% 29,384 1,319 (1,160) 29,543 1,319 17,357 18,676 3.9% 232 232 232 68 300 0.0%
42,282 6,160 (1,480) 46,962 6,160 18,221 24,381 3.5% 29,543 1,050 (909) 29,684 1,050 15,573 16,623 3.1% 232 4,546 (307) 4,471 4,546 (729) 3,817 0.0%
46,962 7,236 (2,416) 51,782 7,236 22,114 29,350 5.1% 29,684 1,074 (1,852) 28,906 1,074 17,809 18,883 6.2% 4,471 5,602 (111) 9,962 5,602 16 5,618 2.5%
51,782 5,179 (1,823) 55,138 5,179 22,768 27,947 3.5% 28,906 871 (1,360) 28,417 871 17,603 18,474 4.7% 9,962 3,793 (94) 13,661 3,793 937 4,730 0.9%
55,138 3,600 (1,576) 57,162 3,600 24,188 27,788 2.9% 28,417 848 (1,247) 28,018 848 17,918 18,766 4.4% 13,661 2,328 (17) 15,972 2,328 2,464 4,792 0.1%
57,162 3,287 (1,968) 58,481 3,287 25,604 28,891 3.4% 28,018 957 (946) 28,029 957 17,926 18,883 3.4% 15,972 1,884 (666) 17,190 1,884 3,218 5,102 4.2%
58,481 3,673 (1,322) 60,832 3,673 23,846 27,519 2.3% 28,029 1,045 (1,008) 28,066 1,045 17,658 18,703 3.6% 17,190 2,221 19,411 2,221 2,491 4,712 0.0%
60,832 3,656 (1,183) 63,305 3,656 23,011 26,667 1.9% 28,066 1,025 (510) 28,581 1,025 16,645 17,670 1.8% 19,411 2,208 (273) 21,346 2,208 2,715 4,923 1.4%
63,305 3,452 (1,357) 65,400 3,452 26,710 30,162 2.1% 28,581 1,078 (924) 28,735 1,078 18,645 19,723 3.2% 21,346 2,007 23,353 2,007 4,317 6,324 0.0%
39,667 45,053 (19,320) 65,400 45,053 269,818 314,871 3.2% 28,726 13,647 (13,638) 28,735 13,647 208,416 222,063 3.9% 24,821 (1,468) 23,353 24,821 15,497 40,318 5.9%
6,088 486 (88) 6,486 486 1,515 2,001 1.4%
6,486 470 (123) 6,833 470 1,585 2,055 1.9%
6,833 426 (89) 7,170 426 1,695 2,121 1.3%
7,170 462 (117) 7,515 462 2,344 2,806 1.6%
7,515 400 (152) 7,763 400 1,593 1,993 2.0%
7,763 335 (129) 7,969 335 1,617 1,952 1.7%
7,969 356 (169) 8,156 356 2,083 2,439 2.1%
8,156 310 (158) 8,308 310 2,224 2,534 1.9%
8,308 248 (141) 8,415 248 1,870 2,118 1.7%
8,415 272 (178) 8,509 272 2,414 2,686 2.1%
8,509 208 (150) 8,567 208 1,877 2,085 1.8%
8,567 230 (183) 8,614 230 1,689 1,919 2.1%
8,614 171 (175) 8,610 171 1,792 1,963 2.0%
6,486 3,888 (1,764) 8,610 3,888 22,783 26,671 1.9%
Other Beginning active customers New customer Attrition Ending active customers New orders Reorders Orders shipped Attrition rate
4,370 256 (171) 4,455 256 2,056 2,312 3.9%
4,455 297 (131) 4,621 297 1,676 1,973 2.9%
4,621 261 (322) 4,560 261 1,738 1,999 7.0%
4,560 293 (195) 4,658 293 1,929 2,222 4.3%
4,658 270 (184) 4,744 270 2,090 2,360 4.0%
4,744 229 (135) 4,838 229 1,759 1,988 2.8%
4,838 204 (284) 4,758 204 2,206 2,410 5.9%
4,758 205 (211) 4,752 205 2,004 2,209 4.4%
4,752 176 (171) 4,757 176 1,936 2,112 3.6%
4,757 174 (178) 4,753 174 2,047 2,221 3.7%
4,753 199 (164) 4,788 199 1,819 2,018 3.5%
4,788 193 (217) 4,764 193 1,962 2,155 4.5%
4,764 196 (258) 4,702 196 1,957 2,153 5.4%
4,455 2,697 (2,450) 4,702 2,697 23,122 25,819 4.3%
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 3C
MPTC Holdings, Inc
Consolidated New Customers by Sales Channel Dec-04 Actual Workdays Month Respiratory: HME New customers Costs Cost per customer Physician New customers Costs Cost per customer Inside sales New customers Costs Cost per customer Puerto Rico New customers Costs Cost per customer CSG & PSG New customers Costs Cost per customer Acquisitions New customers Costs Cost per customer Reactivations New customers Costs Cost per customer Other New customers Costs Cost per customer Total New customers Costs Cost per customer 930 173,974 187 492 217,265 442 50 13,835 277 159 35,628 224 48 9 9 5 1,702 440,702 259 909 199,757 220 495 216,228 437 49 14,381 293 179 32,499 182 38 1 11 3 1,685 462,865 275 815 183,454 225 448 191,517 427 66 10,438 158 168 32,597 194 38 2 14 1,551 418,006 270 927 190,498 205 414 164,579 398 64 9,991 156 190 30,684 161 35 37 1,667 395,752 237 840 177,773 212 373 181,841 488 65 14,104 217 139 28,319 204 42 5 18 49 1,531 402,037 263 773 144,649 187 306 126,003 412 37 9,602 260 126 28,947 230 33 6 7 23 1,311 309,201 236 737 161,774 220 287 123,494 430 51 5,447 107 160 25,913 162 28 2 11 10 1,286 316,628 246 568 140,161 247 243 101,616 418 43 3,430 80 92 19,337 210 42 14 3 1,005 264,544 263 544 140,788 259 228 89,535 393 40 4,672 117 149 23,535 158 42 4 1 1,008 258,530 256 577 147,464 256 308 113,910 370 49 2,883 59 155 24,407 157 38 7 1,134 288,664 255 578 158,535 274 324 113,071 349 74 5,449 74 156 24,709 158 40 11 1,183 301,764 255 628 145,621 232 365 96,103 263 58 2,927 50 154 24,169 157 46 3 1,254 268,820 214 700 139,903 200 325 84,955 261 80 2,901 36 218 30,843 141 73 5 1,401 258,602 185 8,596 1,930,377 225 4,116 1,602,852 389 676 86,225 128 1,886 325,959 173 495 16 142 89 16,016 3,945,413 246 887 9,785 (187) (1,189) 22
Dec-03
21
Jan-04
20
Feb-04
23
Mar-04
22
Apr-04
20
May-04
22
Jun-04
21
Jul-04
88
Aug-04
21
Sep-04
21
Oct-04
21
Nov-04
21
Dec-04
YTD Dec-04
Budget Current YTD month Dec-04 Dec-04
Actual vs. budget Current YTD month Dec-04 Dec-04
349
4,277
(24)
(161)
56
616
24
60
118
1,406
100
480
20
240
53
255
-
-
-
16
-
-
5
142
-
-
-
89
1,430
16,324
(29)
(308)
Note: Respiratory costs include sales representatives salaries, commissions, and benefits and expense reports.
MPTC Holdings, Inc
Consolidated New Customers by Sales Channel Dec-04 Actual Workdays Month Diabetes: Television New customers Costs Cost per customer Print New customers Costs Cost per customer Direct mail New customers Costs Cost per customer Internet/Catalog/Retail/Other New customers Costs Cost per customer Profession field sales New customers Costs Cost per customer Profession inside sales New customers Costs Cost per customer Tampa Sales Team New customers Costs Cost per customer Major accounts New customers Costs Cost per customer Acquisitions New customers Costs Cost per customer Reactivations New customers Costs Cost per customer Other New customers Costs Cost per customer Total Diabetic New customers Costs Cost per customer 22
Dec-03
21
Jan-04
20
Feb-04
23
Mar-04
22
Apr-04
20
May-04
22
Jun-04
21
Jul-04
88
Aug-04
21
Sep-04
21
Oct-04
21
Nov-04
21
Dec-04
YTD Dec-04
Budget Current YTD month Dec-04 Dec-04
Actual vs. budget Current YTD month Dec-04 Dec-04
106 104,273 984 3 12,352 4,117 125 38,843 311 134 23,717 177 187 96,150 514 350 76,124 217 117 6,011 51 325 5,298 16 190 na na 454 74 42,219 571 2,065 404,988 196
155 152,528 984 8 11,766 1,471 126 45,097 358 86 27,847 324 232 61,579 265 435 87,764 202 138 8,420 61 336 370 1 87 na na 317 67 41,165 614 1,987 436,536 220
41 (40,038) (977) 14 10,531 752 109 64,040 588 71 28,245 398 183 61,215 335 433 88,676 205 145 6,434 44 283 38 na na 325 77 40,699 529 1,719 259,801 151
7 28 9,719 347 184 64,374 350 69 26,647 386 194 85,354 440 491 102,964 210 162 35,003 216 289 67 na na 277 88 53,927 613 1,856 377,987 204
3 4,216 1,405 17 4,422 260 164 62,844 383 60 23,489 391 269 87,577 326 405 88,020 217 202 60,805 301 258 45 na na 290 89 39,016 438 1,802 370,389 206
2 14 3,885 278 175 56,590 323 68 22,604 332 346 84,275 244 356 84,702 238 243 75,745 312 187 28 na na 301 52 41,623 800 1,772 369,423 208
12 179 70,215 392 99 28,046 283 378 104,567 277 386 105,096 272 300 71,261 238 210 31 na na 289 55 51,932 944 1,939 431,118 222
3 3 7,770 2,590 143 53,814 376 101 24,599 244 411 91,713 223 402 92,177 229 356 93,227 262 194 na na 345 51 12,257 240 2,009 375,558 187
4 2 3,885 1,943 172 50,571 294 138 24,892 180 415 92,807 224 419 93,276 223 396 98,275 248 276 na na 268 64 14,213 222 2,154 377,918 175
3,885 159 54,788 345 164 26,820 164 468 99,994 214 405 100,500 248 431 88,709 206 273 na na 268 64 13,141 205 2,232 387,836 174
2 3 3,885 1,295 239 46,205 193 180 24,655 137 483 91,924 190 428 92,389 216 432 93,138 216 282 na na 509 82 10,042 122 2,640 362,238 137
3 3,885 1,295 205 44,548 217 124 25,844 208 446 88,581 199 381 96,845 254 440 85,602 195 222 na na 386 58 11,063 191 2,265 356,369 157
1 1 3,885 3,885 219 44,970 205 126 28,343 225 416 97,144 234 419 106,207 253 388 69,886 180 175 na na 309 65 13,538 208 2,118 363,973 172
217 116,706 538 105 67,517 643 2,074 658,056 317 1,286 312,031 243 4,241 1,046,730 247 4,960 1,138,616 230 3,633 786,505 216 2,985 370 0 296 na na 3,884 812 342,615 422 24,493 4,469,146 182
-
196
-
21
52
522
(51)
(417)
305
3,535
(86)
(1,461)
50
555
76
731
897
6,900
(481)
(2,659)
902
7,856
(483)
(2,896)
350
3,161
38
472
650
6,381
(475)
(3,396)
-
-
-
296
272
3,244
37
640
96
700
(31)
112
3,574
33,050
(1,456)
(8,557)
Note: Diabetic costs include advertising, printing and postage, mailing lists, marketing materials and sales and marketing labor.
MPTC Holdings, Inc
Consolidated New Customers by Sales Channel Dec-04 Actual Workdays Month Ostomy: Inside sales New customers Costs Cost per customer Outside sales New customers Costs Cost per customer Acquisitions New customers Costs Cost per customer Reactivations New customers Costs Cost per customer Other New customers Costs Cost per customer Total New customers Costs Cost per customer Urological: Inside sales New customers Costs Cost per customer Outside sales New customers Costs Cost per customer Acquisitions New customers Costs Cost per customer Reactivations New customers Costs Cost per customer Other New customers Costs Cost per customer Total New customers Costs Cost per customer 15 10 16 157 201 84,439 420 399 84,439 212 11 8 11 65 140 82,329 588 235 82,329 350 13 8 4 95 153 81,397 532 273 81,397 298 20 13 2 93 193 107,855 559 321 107,855 336 11 10 1 82 202 78,031 386 306 78,031 255 8 15 3 56 164 83,246 508 246 83,246 338 17 13 80 172 103,864 604 282 103,864 368 8 17 81 200 73,544 368 306 73,544 240 9 11 68 209 85,279 408 297 85,279 287 4 27 95 228 78,843 346 354 78,843 223 2 20 85 203 60,253 297 310 60,253 194 2 15 73 177 66,377 375 267 66,377 249 4 27 70 245 81,229 332 346 81,229 235 109 184 21 943 2,286 982,247 430 3,543 982,247 277 15 175 (11) (66) 16 37 14,073 380 53 14,073 266 12 33 13,722 416 45 13,722 305 28 30 13,566 452 58 13,566 234 20 61 17,976 295 81 17,976 222 13 50 13,005 260 63 13,005 206 13 54 13,874 257 67 13,874 207 31 83 17,311 209 114 17,311 152 7 32 18,386 575 39 18,386 471 6 42 21,320 508 48 21,320 444 12 30 19,711 657 42 19,711 469 9 23 15,063 655 32 15,063 471 11 44 16,594 377 55 16,594 302 9 41 20,307 495 50 20,307 406 171 523 200,835 384 694 200,835 289 22
Dec-03
21
Jan-04
20
Feb-04
23
Mar-04
22
Apr-04
20
May-04
22
Jun-04
21
Jul-04
88
Aug-04
21
Sep-04
21
Oct-04
21
Nov-04
21
Dec-04
YTD Dec-04
Budget Current YTD month Dec-04 Dec-04
Actual vs. budget Current YTD month Dec-04 Dec-04
-
-
-
-
-
-
-
-
14
148
(5)
23
34
560
7
(37)
48
708
2
(14)
10
120
17
64
-
-
-
21
66
758
4
185
257
3,143
(12)
(857)
348
4,196
(2)
(653)
MPTC Holdings, Inc
Consolidated New Customers by Sales Channel Dec-04 Actual Workdays Month Wound Care: Mail Order New customers Costs Cost per customer Wound Care Centers New customers Costs Cost per customer Acquisitions New customers Costs Cost per customer Reactivations New customers Costs Cost per customer Other New customers Costs Cost per customer Total New customers Costs Cost per customer 4 699 49,217 382 703 49,217 70 3 1,120 74,687 485 1,123 74,687 67 6 1,349 69,087 432 1,355 69,087 51 3 1,147 79,468 310 1,150 79,468 69 4 1,239 68,590 335 1,243 68,590 55 926 66,762 322 926 66,762 72 20 6,480 407,812 383 6,500 407,812 63 22
Dec-03
21
Jan-04
20
Feb-04
23
Mar-04
22
Apr-04
20
May-04
22
Jun-04
21
Jul-04
88
Aug-04
21
Sep-04
21
Oct-04
21
Nov-04
21
Dec-04
YTD Dec-04
Budget Current YTD month Dec-04 Dec-04
Actual vs. budget Current YTD month Dec-04 Dec-04
-
-
-
-
-
-
-
-
-
-
-
20
850
6,133
76
347
850
6,133
76
367
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 3D
MPTC Holdings, Inc.
Consolidated Balance Sheet Data Dec-04 Actual Month Cash balance Working capital DSO Inventory days on hand Total assets Debt, including current portion: Revolving bank debt GMAC term loan A GMAC term loan B American Capital term loan C Mortgage Capital leases Subtotal Dec-03 $2,771,041 $12,536,959 47 23 $136,391,309 9,376,737 35,000,000 15,000,000 15,000,000 1,089,292 1,587,522 77,053,551 Jan-04 $2,339,583 $11,555,133 49 30 $135,836,008 9,376,737 34,000,000 14,962,500 15,000,000 1,080,205 1,522,779 75,942,221 100,000 212,484 126,100 438,584 $76,380,805 $48,206,640 Feb-04 $1,553,284 $11,200,838 52 22 $133,868,043 9,376,737 34,000,000 14,962,500 15,000,000 1,071,044 1,458,801 75,869,081 100,000 202,366 302,366 $76,171,447 $48,420,509 Mar-04 $5,295,108 $15,010,374 54 26 $138,173,486 12,376,737 34,000,000 14,962,500 15,000,000 1,061,423 1,394,367 78,795,027 100,000 192,247 292,247 $79,087,274 $48,896,528 Apr-04 $2,557,527 $12,750,402 52 31 $135,689,748 11,376,737 32,210,526 14,925,000 15,000,000 1,052,168 1,364,478 75,928,910 100,000 182,129 282,129 $76,211,039 $49,164,977 May-04 $2,265,591 $12,163,841 52 34 $135,615,019 10,000,000 32,210,526 14,925,000 15,000,000 1,042,650 1,297,706 74,475,882 172,011 172,011 $74,647,893 $49,531,683 Jun-04 $2,822,083 $13,190,120 53 32 $136,207,227 10,000,000 32,210,526 14,925,000 15,000,000 1,033,276 1,347,521 74,516,323 161,892 161,892 $74,678,215 $50,285,161 Jul-04 $3,320,631 $18,109,629 57 33 $189,454,232 6,000,000 48,000,000 32,000,000 15,000,000 1,023,640 1,400,944 103,424,584 151,774 151,774 $103,576,358 $72,471,166 Aug-04 $4,043,856 $17,548,029 54 34 $188,650,790 4,000,000 48,000,000 32,000,000 15,000,000 1,014,141 1,327,910 101,342,051 141,656 141,656 $101,483,707 $73,449,631 Sep-04 $7,107,893 $21,124,451 56 32 $188,650,790 5,999,763 48,000,000 32,000,000 15,000,000 1,004,593 1,254,364 103,258,720 131,537 131,537 $103,390,257 $73,449,631 Oct-04 $2,994,967 $17,822,011 57 29 $185,619,418 4,000,020 45,920,000 31,920,000 15,000,000 994,790 1,423,084 99,257,894 121,419 121,419 $99,379,313 $75,316,582 Nov-04 $5,411,098 $17,246,271 54 27 $186,334,295 2,500,000 45,920,000 31,920,000 15,000,000 985,130 1,342,746 97,667,876 111,301 111,301 $97,779,177 $76,221,980 Dec-04 $6,611,315 $15,908,249 49 25 $183,348,035 45,920,000 31,920,000 15,000,000 975,218 1,261,855 95,077,073 $95,077,073 $72,416,727 $190,081,089 $7,033,846 28,631,579 14,850,000 15,000,000 975,163 1,474,783 67,965,371 188,156 188,156 $68,153,527 $107,447,351 $(6,733,054) $(7,033,846) 17,288,421 17,070,000 55 (212,928) 27,111,702 (188,156) (188,156) $26,923,546 $(35,030,624) Budget Dec-04 $3,308,089 $25,059,251 Actual to budget Dec-04 $3,303,226 $(9,151,002)
Deferred acquisition obligations: HoMed Pharmacy, Inc. 100,000 Express-Med, Inc. Medical Supply Foundation, Inc. (Diabetic.com) Genicare Medical Products, Inc. American Asthma & Diabetes Pharmacy, LLC 846,154 American Health Supply 8,500 Med Emporium LLC DiaMed Medical Supplies 126,100 Subtotal 1,080,754 Total Stockholders' equity $78,134,305 $48,174,431
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 4A
MPTC Holdings, Inc.
Consolidated Balance Sheet Dec-04
Actual Month Assets Cash Accounts receivable Allowance for doubtful accounts Inventories Prepaid expenses and other current assets Intercompany (net) Deferred tax assets Total current assets Property and equipment, net Goodwill, net Customer lists, net Other amortized assets, net Other assets Deferred tax assets Total Assets Liabilities and Equity Revolving bank debt Current portion of long term debt Current portion of capital leases Deferred Acquisition Obligations Accounts payable Taxes payable Accrued compensation & benefits Accrued liabilities Deferred tax liabilities Total current liabilities Revolving bank debt Long term debt Capital leases Deferred acquisition obligations Deferred tax liabilities Deferred rent & other liabilities Total other liabilities Equity Common stock Preferred stock Additional paid in capital Retained earnings Total equity Total Liabilities and Equity Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04
Budget Dec-04
Actual to budget Dec-04
$2,771,041 23,983,149 (5,418,107) 4,336,833 1,884,112 2,368,239 29,925,267 11,476,831 82,922,158 9,588,124 1,773,007 85,359 620,561 $136,391,309
$2,339,583 24,384,537 (5,586,511) 5,055,352 1,975,900 2,387,060 30,555,922 11,541,128 82,298,608 8,910,412 1,742,920 51,325 735,692 $135,836,008
$1,553,284 24,820,629 (5,243,806) 3,776,308 1,836,439 1,384,197 28,127,051 11,684,399 82,298,607 8,232,702 1,712,833 50,900 1,761,550 $133,868,043
$5,295,108 25,443,218 (5,297,608) 4,443,163 1,592,822 1,387,582 32,864,285 11,732,293 82,298,607 7,554,990 1,682,747 165,555 1,875,009 $138,173,486
$2,557,527 24,727,799 (5,205,058) 5,461,987 1,850,132 1,341,883 30,734,270 12,013,776 82,298,607 6,877,278 1,652,659 143,532 1,969,625 $135,689,748
$2,265,591 25,262,309 (5,222,734) 6,129,318 1,415,357 1,314,045 31,163,885 12,000,699 82,298,607 6,386,561 1,622,573 143,532 1,999,161 $135,615,019
$2,822,083 26,064,463 (5,498,981) 5,861,238 1,343,374 1,424,653 32,016,830 12,268,591 82,298,607 5,895,845 1,592,486 144,081 1,990,788 $136,207,227
$3,320,631 33,960,551 (7,418,920) 6,838,168 2,944,886 1,403,667 41,048,983 13,054,937 124,666,769 5,405,129 2,337,400 331,342 2,609,672 $189,454,232
$4,043,856 32,841,460 (7,245,060) 7,125,708 2,740,710 1,286,650 40,793,325 13,073,589 124,666,769 4,914,414 2,318,599 250,549 2,633,546 $188,650,790
$7,107,893 33,510,381 (7,078,330) 6,778,131 2,069,585 1,250,371 43,638,031 13,055,988 124,666,769 4,423,697 2,276,247 235,533 2,661,816 $190,958,081
$2,994,967 33,612,516 (7,061,322) 6,026,746 1,788,591 1,291,892 38,653,389 13,260,581 124,666,769 3,932,983 2,232,816 237,125 2,635,754 $185,619,418
$5,411,098 32,398,806 (7,077,018) 5,620,106 1,787,719 (0) 1,331,000 39,471,709 13,469,712 124,666,769 3,442,264 2,189,386 255,471 2,838,983 $186,334,295
$6,611,315 31,522,834 (8,719,819) 5,528,263 3,899,580 0 2,702,836 41,545,009 11,434,242 125,169,602 2,951,538 874,937 209,469 1,163,237 $183,348,035
$3,308,089 33,908,990 (6,528,144) 6,395,373 6,408,546 3,401,765 46,894,619 13,290,284 124,653,130 2,951,551 1,405,338 265,606 620,561 $190,081,089
$3,303,226 (2,386,156) (2,191,675) (867,110) (2,508,966) 0 (698,929) (5,349,610) (1,856,042) 516,472 (13) (530,401) (56,137) 542,676 $(6,733,054)
$6,632,556 794,028 696,138 4,521,793 9,561 1,494,443 3,239,789 17,388,308 9,376,737 59,456,736 793,494 384,615 816,990 70,828,571
$7,422,690 794,512 347,519 5,636,103 13,925 1,614,071 3,171,969 19,000,789 9,376,737 57,620,015 728,267 91,064 812,496 68,628,579
$7,423,357 795,486 221,419 4,384,417 11,603 1,600,006 2,489,924 16,926,213 9,376,737 57,610,187 663,314 80,946 790,137 68,521,321
$7,424,056 795,279 221,419 5,835,719 69,490 1,434,421 2,073,528 17,853,912 12,376,737 57,599,867 599,088 70,828 776,528 71,423,048
$7,424,729 795,655 221,419 5,117,475 13,489 1,110,882 3,300,219 17,983,868 11,376,737 55,762,966 568,823 60,710 771,669 68,540,904
$7,425,421 775,820 121,419 6,151,235 189,890 1,210,372 3,125,887 19,000,044 10,000,000 55,752,755 521,886 50,591 758,060 67,083,292
$7,426,103 779,789 121,419 5,783,982 329,977 1,456,277 2,929,164 18,826,710 10,000,000 55,742,700 567,732 40,473 744,450 67,095,356
$9,718,909 794,940 121,419 6,964,857 948,445 1,702,237 2,688,547 22,939,354 6,000,000 86,304,731 606,004 30,355 1,102,622 94,043,712
$9,719,599 772,004 121,419 5,693,526 973,526 1,936,709 4,028,513 23,245,297 4,000,000 86,294,542 555,907 20,236 1,085,177 91,955,862
$9,720,294 748,844 121,419 5,985,573 977,815 1,281,057 3,678,578 22,513,580 5,999,763 86,284,299 505,520 10,118 1,068,025 93,867,725
$10,041,007 796,300 121,419 4,787,459 (23,321) 1,263,658 3,844,856 20,831,378 4,000,020 83,793,783 626,784 1,050,871 89,471,458
$10,041,709 773,011 111,301 4,155,236 819,420 1,673,605 4,651,156 22,225,438 2,500,000 83,783,421 569,734 1,033,721 87,886,877
$10,042,430 749,494 8,265,556 362,621 1,858,808 4,357,851 25,636,760 83,772,788 512,361 1,009,399 85,294,548
$7,430,322 746,078 188,156 7,164,168 805,001 2,949,573 2,552,070 21,835,368 7,033,846 52,026,420 728,705 1,009,399 60,798,370
$2,612,108 3,416 (188,156) 1,101,388 (442,380) (1,090,765) 1,805,781 3,801,392 (7,033,846) 31,746,368 (216,344) 24,496,178
138,785 22,000,000 18,242,530 7,793,116 48,174,431 $136,391,309
138,785 22,000,000 18,242,530 7,825,325 48,206,640 $135,836,008
138,785 22,000,000 18,242,529 8,039,195 48,420,509 $133,868,043
138,785 22,000,000 18,242,530 8,515,213 48,896,528 $138,173,486
138,785 22,000,000 18,242,530 8,783,662 49,164,977 $135,689,748
138,785 22,000,000 18,242,530 9,150,368 49,531,683 $135,615,019
138,785 22,000,000 18,242,530 9,903,846 50,285,161 $136,207,227
138,785 47,000,000 18,242,530 7,089,851 72,471,166 $189,454,232
138,785 47,000,000 18,242,531 8,068,316 73,449,631 $188,650,790
138,785 47,000,000 18,242,530 9,195,461 74,576,776 $190,958,081
138,785 47,000,000 18,242,530 9,935,267 75,316,582 $185,619,418
138,785 47,000,000 18,242,530 10,840,665 76,221,980 $186,334,295
138,785 47,000,000 18,242,530 7,035,411 72,416,727 $183,348,035
144,785 22,000,000 72,561,530 12,741,036 107,447,351 $190,081,089
(6,000) 25,000,000 (54,319,000) (5,705,625) (35,030,624) $(6,733,054)
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 4B
MPTC Holdings, Inc.
Consolidated Statement of Cash Flow Dec-04 Eliminate for the BOD Actual Month Cash flows from operating activities: Net income (loss) Adjustments to reconcile net income (loss) to net cash provided by (used by) operating activities: Depreciation of property and equipment Amortization of intangible assets Gain/(loss) on disposal of assets Increase (decrease) in assets and liabilities: Accounts receivable, net Inventories Prepaid expenses and other assets Intercompany (net) Deferred Taxes Accounts payable Accrued expenses and other liabilities Taxes Payable Net cash provided by (used by) operating activities Cash flows from investing activities: Capital expenditures Business acquisitions, net of cash acquired Payment of acquisition costs Net cash provided by (used by) investing activities Cash flows from financing activities: Proceeds from long term debt Proceeds from capital leases Proceeds from mortgages Proceeds from revolving bank debt Proceeds from deferred acquisition obligations Repayment of long term debt Repayment of capital leases Repayment of mortgages Repayment of revolving bank debt Repayment of deferred acquisition obligations Proceeds from issuance of common stock Proceeds from issuance of preferred stock Debt issue costs Net cash provided by (used by) financing activities Net increase (decrease) in cash Cash, beginning of period Cash, end of period Dec-03 Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 YTD Dec-04 Budget Dec-04 Actual to budget Dec-04
$806,685
$32,213
$213,869
$476,016
$268,448
$366,707
$753,481
$(2,813,994)
$978,459
$1,127,151
$739,810
$905,395
$(3,805,253)
$(757,699)
$1,591,226
$(5,396,479)
113,614 708,353 (753,717) 253,031 (1,555,035) 1,260,468 (500,069) (194,810) (513,138) (374,617)
105,161 707,798 (232,985) (718,519) (57,754) (133,952) 1,114,310 47,312 4,364 867,948
105,562 707,798 (778,795) 1,279,043 139,884 (22,995) (1,251,687) (724,129) (2,322) (333,771)
105,490 707,798 (568,788) (666,854) 128,812 (116,844) 1,451,301 (595,441) 57,887 979,377
104,696 707,798 622,870 (1,018,823) (257,310) (48,917) (718,244) 920,320 (56,001) 524,836
107,271 520,803 (516,834) (667,331) 434,776 (1,698) 1,033,760 (88,450) 176,401 1,365,405
96,968 520,803 (525,908) 268,079 71,436 (102,235) (367,254) 35,572 140,084 891,026
113,062 520,803 (299,106) (92,979) 3,751,302 15,102 683,437 (1,605,925) (288,131) (16,429)
125,595 534,130 945,230 (287,540) 290,019 93,143 (1,271,331) 496,796 25,081 1,929,583
125,678 534,142 (835,650) 347,578 686,141 8,009 292,045 (1,022,739) 4,288 1,266,642
126,761 534,147 (119,144) 751,385 279,401 (15,459) (1,198,112) 131,725 (1,001,141) 229,372
129,916 534,146 1,229,407 406,641 (17,461) (242,337) (632,221) 1,199,094 842,736 4,355,315
80,889 1,705,177 1,751,399 1,709,771 91,843 (3,114,064) (0) 303,910 4,110,323 1,509,740 (457,634) 3,886,101
1,327,048 8,235,344 1,751,399 630,067 (307,477) 2,335,181 (264,273) 3,246,327 303,874 (554,388) 15,945,402
67,978 521,355 (324,568) (109,759) (1,280,331) (58,562) 331,535 160,523 (872,801) 26,596
12,911 1,183,822 1,751,399 2,034,339 201,602 (1,833,733) 362,472 3,778,788 1,349,217 415,167 3,859,505
(238,123) (32,374) (270,497)
(169,457) (169,457)
(248,834) (248,834)
(153,383) (153,383)
(386,179) (386,179)
(94,194) (94,194)
(364,859) (257,089) - (50,471,092) (1,675,000) (364,859) (52,403,181)
(144,247) 1,205,155 (150,000) 910,908
(108,078) (108,078)
(331,353) (331,353)
(339,047) (339,047)
(84,964) 101,183 16,219
(2,681,685) (49,164,754) (1,825,000) (53,671,439)
(117,169) (117,169)
32,205 101,183 133,388
(64,280) (9,237) (83,258) (33,159) (189,934) (835,048) 3,606,088 $2,771,040
(1,037,500) (64,743) (9,087) (18,617) (1,129,947) (431,456) 2,771,040 $2,339,585
(63,979) (9,161) (130,555) (203,695) (786,301) 2,339,585 $1,553,284
3,000,000 (64,433) (9,621) (10,118) 2,915,828 3,741,822 1,553,284 $5,295,106
36,414 (1,826,974) (66,303) (9,255) (1,000,000) (10,118) (2,876,236) (2,737,579) 5,295,106 $2,557,527
(66,773) (9,518) (1,376,737) (110,118) (1,563,146) (291,936) 2,557,527 $2,265,591
80,000,000 118,981 125,949 8,700,000 - (47,340,511) (69,165) (72,527) (9,374) (9,636) - (12,700,000) (10,118) (10,118) 25,000,000 (775,000) 30,324 52,918,157 556,491 2,265,591 $2,822,082 498,547 2,822,082 $3,320,629
(73,034) (9,499) (2,000,000) (10,118) (24,613) (2,117,264) 723,227 3,320,629 $4,043,856
1,999,763 (73,546) (9,548) (10,118) (1,076) 1,905,475 3,064,038 4,043,856 $7,107,894
248,513 (2,160,000) (79,793) (9,803) (1,999,743) (10,118) (4,010,944) (4,112,925) 7,107,894 $2,994,969
(80,340) (9,659) (1,500,020) (10,118) (1,600,137) 2,416,131 2,994,969 $5,411,099
(80,890) (9,912) (2,500,000) (111,301) (2,702,103) 1,200,217 5,411,099 $6,611,315
80,000,000 529,857 13,699,763 (52,364,985) (855,525) (114,073) (23,076,500) (451,535) 25,000,000 (800,689) 41,566,312 3,840,275 2,771,040 $6,611,315
135,735 (293,959) (80,467) (9,820) (18,815) (267,326) (357,899) 3,665,988 $3,308,089
(135,735) 293,959 (423) (92) (2,500,000) (92,486) (2,434,777) 1,558,116 1,745,111 $3,303,226
Supplemental disclosure of cash flow information: Cash paid for taxes Cash paid for interest
$1,273,500 $435,139
$12,217 $424,660
$$400,919
$282,600 $427,487
$347,960 $407,408
$$414,646
$434,102 $426,178
$40,000 $505,910
$$204,859
$59,075 $192,470
$1,000,000 $1,146,782
$300 $201,462
$254,029 $967,372
$2,430,283 $5,720,154
$1,492,383 $438,163
$(1,238,354) $529,209
Prepared By: YWD 01/25/05 Reviewed By: CT 01/25/05 4C
MPTC Holdings, Inc.
Consolidated Capital Expenditures Dec-04
Actual Workdays Month Computer software & hardware: TNS TRC development TNS internal costs (SOP-98) TNS hardware Capitalized interest Subtotal TNS Other computer software Other computer hardware Total computer software & hardware Telephone equipment Furniture & fixtures/office equipment Building & leasehold improvements PP&E in process adjustments Total Capital Expenditures 22 Dec-03 21 Jan-04 20 Feb-04 23 Mar-04 22 Apr-04 20 May-04 22 Jun-04 21 Jul-04 22 Aug-04 21 Sep-04 21 Oct-04 21 Nov-04 21 Dec-04 YTD Dec-04
Budget
Actual vs. budget
Current month Dec-04
YTD Dec-04
Current month Dec-04
YTD Dec-04
$19,314 188,616 207,930 (1,108) 206,822 31,301 238,123
$19,314 23,147 42,461 1,000 20,740 64,201 12,320 92,936 169,457
$9,415 23,224 32,639 2,685 12,077 47,401 5,578 195,855 248,834
$148,280 9,415 24,098 181,793 1,000 11,368 194,161 20,636 (61,414) 153,383
$14,122 23,483 37,605 28,787 11,874 78,265 37,971 269,942 386,178
$11,092 23,795 34,886 16,410 15,819 67,115 25,482 1,598 94,195
$11,092 24,432 35,524 40,453 33,004 108,980 152,439 103,441 364,861
$11,092 24,184 35,276 23,404 14,584 73,264 137,306 46,520 257,090
$11,092 24,679 35,770 6,371 30,224 72,365 1,395 39,922 30,565 144,247
$11,092 24,229 35,321 9,225 19,054 63,600 44,478 108,078
$11,092 24,260 35,352 17,865 53,217 273,787 4,350 331,354
$11,092 24,291 35,383 112,907 159,215 307,505 22,717 8,824 339,046
$11,092 24,322 35,414 8,712 53,107 97,233 9,479 61,581 168,293
$148,280 141,000 288,144 577,425 250,954 398,931 1,227,309 1,395 782,115 754,198 2,765,017
$24,040 26,044 50,084 2,586 61,000 113,670 3,500 117,170
$148,280 280,684 284,523 713,487 107,506 648,257 1,469,250 107,100 191,725 732,674 2,500,749
$(12,948) (26,044) 24,322 (14,670) 6,126 (7,893) (16,437) (3,500) 9,479 61,581 51,123
$(139,684) (284,523) 288,144 (136,062) 143,448 (249,326) (241,941) (105,705) 590,390 21,524 264,268
Financed through capital leases(1) Capital expenditures less amounts financed through capital leases
(1)
$238,123
$169,457
$248,834
$153,383
(36,414) $349,764
$94,195
(118,981) $245,880
(125,949) $131,141
$144,247
$108,078
(248,513) $82,841
$339,046
$168,293
(529,857) $2,235,160
Note: For October 14, 2003 forward, capital expenditures financed through capital leases are excluded from the loan covenant calculations.
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 4D
MPTC Holdings, Inc. Consolidated Acquisition Summary Dec-04
Year
1999
2001
2002 American Asthma & Diabetes Pharmacy, LLC 03/28/03
2003
2004
Acquisition
MP TotalCare, Inc. 11/30/99 Cash for Stock
HealthScript Respiratory HoMed Express Pharmacy Pharmacy, Inc. Medical, Inc. 04/27/01 Cash for Assets 05/06/02 06/17/02
Medical Foundation, Inc. 07/26/02
Total(1) na
Genicare Medical Products, Inc. 02/28/03
Med Emporium 06/06/03
Diamed LP 06/13/03
American Health Supply, Medical LLC Holdings, Inc. 09/17/03 10/14/03
YTD na
Gericare 07/14/04
Closing date Consideration
Cash for Assets Cash for Stock Cash for Assets
na
Cash for Assets Cash for Assets Cash for Assets Cash for Assets Cash for Assets Cash for Stock
na
Cash for Stock
Purchase price Cash at closing Cash acquired Cash at closing refunded Direct acquisition costs Deferred acquisition obligations Deferred Taxes (2) Assumption of liabilities Total
$9,517,434
$5,969,457
$400,000
$31,342,110
$4,136,968
$35,879,078
$885,000
$1,500,000
$165,910
$4,050,000
$5,000
2,515,842 9,736,045 $21,769,321
241,032 $6,210,489
5,360 200,000 $605,360
1,202,414 3,778,000 6,867,897 $43,190,421
33,267 500,000 109,630 $4,779,865
1,241,041 4,478,000 6,977,527 $48,575,646
13,368 101,307 $999,675
2,340 376,448 $1,878,788
5,419 43,452 $214,781
29,834 126,100 $4,205,934
1,836 8,500 $15,336
$47,015,698 965,780 (91,894) 585,451 3,124,036 $51,599,071
$53,621,608 965,780 (91,894) 638,248 655,807 3,124,036 $58,913,585
$45,289,065 3,234,063 1,825,000 613,000 3,363,872 $54,325,000
Purchase price allocation Cash Gross accounts receivable Allowance for doubtful accounts Inventory Inventory reserve Other assets and liabilities Property and equipment Customer lists (3) Goodwill Total
$1,220,789 2,686,130 (369,345) 172,234 288,103 3,337,957 2,659,669 11,773,784 $21,769,321
$149,100 20,000 6,041,389 $6,210,489
$20,095 371,350 213,915 $605,360
$12,102,509 (5,085,245) 1,161,792 (95,614) 315,579 2,132,509 16,290,625 16,338,266 $43,160,421
$109,432 109,630 30,500 1,003,800 3,526,503 $4,779,865
$12,102,509 (5,085,245) 1,291,319 (95,614) 425,209 2,163,009 17,665,775 20,078,684 $48,545,646
$25,000 974,675 $999,675
$2,655 75,000 1,801,133 $1,878,788
$5,000 50,000 159,781 $214,781
$10,000 100,000 10,000 4,085,934 $4,205,934
$1,550 3,910 1,250 8,626 $15,336
$965,781 5,513,429 (1,631,426) 1,618,637 (100,000) 386,146 393,372 44,453,132 $51,599,071
$965,781 5,513,429 (1,631,426) 1,637,842 (100,000) 640,056 404,622 51,483,281 $58,913,585
$3,234,063 7,647,645 (1,970,603) 922,574 (38,624) 1,586,892 779,875 42,163,178 $54,325,000
(1) (2) (3)
Includes EMI 2003 adjustments of $176,436. The total direct acquisition costs of $1,241,041 less the $176,436 added in 2003 plus the $109,630 in Medical Foundation, Inc. assumed liabilities = acquisition costs per the 12/31/2002 audit report cash flow stmt Deferred taxes applies only to purchases of stock. Customer count used above includes customers who placed an order within 120 days of the acquisition close date.
Prepared By: CT 01/25/05 Reviewed By: KGA 02/07/05 5A
MPTC Holdings, Inc.
Consolidated Financial Covenants* Dec-04 Dec-04 Capital Expenditures - Section 10.1 Monthly Capital Expenditures per loan agreement Cumulative Capital Expenditures per loan agreement Maximum Capital Expenditures Remaining available capital expenditure amount (a) Covenant met if (a) > 0 Minimum EBITDA - Section 10.2 6-month rolling EBITDA Gericare 7/1 to 7/14/04 Proforma MHI historical 6-month EBITDA not in actual amounts Pro forma 6-month rolling EBITDA (b) Note: Pre 7/14/04 12 months used per previous agreement. Minimum EBITDA requirement (c) Excess EBITDA (d) Covenant met if (d) > 0 Total Debt to EBITDA Ratio - Section 10.3 Total Debt (e) - less cash up to $2 million Total Debt to EBITDA Ratio (f) = (e) divided by 2 x 3rd & 4th qtr EBITDA Note: Pre 7/14/04 12 month rolling EBITDA used in calculation. Required ratio (g) Covenant met if (f) < (g) Fixed Charge Coverage Ratio - Section 10.4 EBITDA- Quarter #3 & #4 Capital Expenditures EBITDA minus Capital Expenditures (h) Cash interest payments Scheduled principal payments Cash paid for income taxes Total fixed charges (i) Fixed Charge Ratio (j) = (h) divided by (i) Required ratio (k) Covenant met if (j) > (k) Revolving Credit EBITDA Test Pro forma EBITDA (b) Multiply by 4 (multiplied by 3.5 prior to 7/14/04) (l) Total Indebtedness minus LOC balance (m) Prior to 7/14/04 LOC included in debt & adjusted below Maximum allowable revolver (l)-(m); max=$20 million Revolver balance (n) Revolver availability As of the date hereof, the Borrower certifies that the financial information used in the above covenant computations are true and correct. MPTC Holdings, Inc. By: _________________________________________________________ (Signature of Authorized Officer) Printed Name & Title: Ronald C. Drabik, Chief Financial Officer Date: 26,435,376 105,741,506 95,077,073 10,664,433 10,664,433 yes 13,217,688 973,647 12,244,042 3,218,855 2,678,187 1,353,404 7,250,446 1.69 1.00 93,077,073 3.52 4.00 yes 12,992,910 224,778 13,217,688 12,800,000 417,688 yes 168,293 951,577 2,000,000 1,048,423 yes
* EBITDA includes: (1) approximately $1.1 million in one-time accounts receivable adjustments related to estimated contractual allowances and fee schedule changes. (2) $600 thousand in restructuring expenses related to reimbursement changes in the respiratory and power wheelchair businesses . An additional $600 thousand has been classifed as other expense and relates to (a) the disposal of leasehold improvements as a result of the restructuring, and (b) severance pay for employees and other related expenses expected to be paid in 2005. Note: All capitalized terms are defined terms as set forth in the Fourth Amended And Restated Loan and Security Agreement. Note: Fixed charge coverage ratio applies to quarterly numbers. Monthly numbers shown for informational purposes only.
MPTC All Locations / Companies
Dec 04 Headcount * Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 *** Aug-04 Sep-04 **** Oct-04 **** Nov-04 9 236 25 34 35 34 230 603 72% 15 18 7 43 25 22 6 136 16% 10 7 22 19 22 15 95 11% 834 Dec-04 10 232 28 37 30 39 229 605 73% 15 18 7 44 22 22 6 134 16% 8 6 24 19 22 11 90 11% 830
116 20 33 34 37 190 430 61% 15 30 9 51 47 35 187 26% 7 9 1 24 10 27 14 92 13% 709
119 18 35 34 35 192 433 62% 15 27 8 48 46 35 179 25% 7 8 1 23 11 27 14 91 13% 703
117 22 32 34 35 194 434 62% 15 27 8 49 48 33 180 26% 7 8 1 22 12 21 14 85 12% 699
120 21 31 36 36 192 436 62% 15 25 8 46 51 36 181 26% 6 8 1 22 12 20 14 83 12% 700
124 25 34 36 37 200 456 64% 15 25 8 53 36 37 174 24% 6 9 1 21 13 20 14 84 12% 714
132 24 34 34 41 197 462 65% 15 24 8 47 31 36 161 23% 6 9 1 22 16 19 11 84 12% 707
131 26 34 34 36 200 461 65% 15 23 7 49 29 38 161 23% 5 9 1 23 15 19 12 84 12% 706
129 25 37 34 35 200 460 65% 15 23 7 47 29 39 160 23% 5 9 1 24 15 20 12 86 12% 706
220 23 36 33 38 230 580 69% 15 23 7 49 31 39 164 19% 9 9 1 25 19 23 14 100 12% 844
222 25 37 33 35 227 579 69% 16 19 7 50 27 38 157 19% 9 8 1 26 19 22 14 99 12% 835
234 27 38 34 35 231 599 71% 15 18 7 49 22 26 6 143 17% 10 8 1 22 20 23 15 99 12% 841
Prepared by: TS 1/22/05 * Active employees (regular full-time and part-time) Reviewed by: CT 02/04/05 *** Increase due to Gericare acquisition 7/14/04 Schedule HR - 1 **** Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support and Customer Service)
MPTC Tampa - MP TotalCare, Inc. (Tampa, Rainesville, Houston)
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total Location Recap: Tampa ** Rainesville Houston Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 * Oct-04 * Nov-04 3 42 25 32 35 6 58 201 67% 15 18 7 1 8 3 52 17% 3 6 7 9 9 11 45 15% 298 283 14 1 ** Dec-04 3 42 28 35 30 9 56 203 68% 15 18 7 1 8 3 52 17% 3 5 8 9 9 9 43 14% 298 283 14 1
37 20 32 34 8 53 184 63% 15 30 9 3 12 69 23% 3 6 1 8 6 10 7 41 14% 294 277 16 1
40 18 34 34 8 51 185 64% 15 27 8 3 11 64 22% 3 5 1 8 6 10 7 40 14% 289 272 16 1
36 22 32 34 8 53 185 65% 15 27 8 3 11 64 22% 3 5 1 7 6 8 7 37 13% 286 269 16 1
37 21 31 36 8 56 189 66% 15 25 8 3 11 62 22% 2 5 1 7 6 8 7 36 13% 287 271 15 1
40 25 33 36 8 63 205 67% 15 25 8 3 11 62 20% 2 6 1 7 6 8 7 37 12% 304 288 15 1
44 24 32 34 11 63 208 68% 15 24 8 1 11 59 19% 2 6 1 7 7 8 8 39 13% 306 290 15 1
47 26 32 34 11 63 213 69% 15 23 7 1 10 56 18% 2 6 1 7 7 8 9 40 13% 309 293 15 1
41 25 36 34 11 60 207 69% 15 23 7 1 10 56 19% 2 6 1 7 7 7 9 39 13% 302 286 15 1
42 23 35 33 9 63 205 67% 15 23 7 1 10 56 18% 2 6 1 7 9 9 9 43 14% 304 288 15 1
44 25 36 33 7 60 205 68% 16 19 7 1 10 53 18% 2 6 1 8 9 8 9 43 14% 301 286 14 1
43 27 36 34 7 62 209 68% 15 18 7 1 7 3 51 17% 3 6 1 7 9 9 11 46 15% 306 291 14 1
* Rainesville location closing effective 12/31/04 ** Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support)
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 Schedule HR - 2
MPTC Tampa - Tampa Only
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 * Oct-04 * Nov-04 3 42 25 24 28 6 58 186 66% 15 18 7 1 8 3 52 18% 3 6 7 9 9 11 45 16% 283 Dec-04 3 42 28 27 23 9 56 188 66% 15 18 7 1 8 3 52 18% 3 5 8 9 9 9 43 15% 283
37 20 23 27 8 52 167 60% 15 30 9 3 12 69 25% 3 6 1 8 6 10 7 41 15% 277
40 18 25 27 8 50 168 62% 15 27 8 3 11 64 24% 3 5 1 8 6 10 7 40 15% 272
36 22 23 27 8 52 168 62% 15 27 8 3 11 64 24% 3 5 1 7 6 8 7 37 14% 269
37 21 23 29 8 55 173 64% 15 25 8 3 11 62 23% 2 5 1 7 6 8 7 36 13% 271
40 25 25 29 8 62 189 66% 15 25 8 3 11 62 22% 2 6 1 7 6 8 7 37 13% 288
44 24 24 27 11 62 192 66% 15 24 8 1 11 59 20% 2 6 1 7 7 8 8 39 13% 290
47 26 24 27 11 62 197 67% 15 23 7 1 10 56 19% 2 6 1 7 7 8 9 40 14% 293
41 25 28 27 11 59 191 67% 15 23 7 1 10 56 20% 2 6 1 7 7 7 9 39 14% 286
42 23 27 26 9 62 189 66% 15 23 7 1 10 56 19% 2 6 1 7 9 9 9 43 15% 288
44 25 28 26 7 60 190 66% 16 19 7 1 10 53 19% 2 6 1 8 9 8 9 43 15% 286
43 27 28 27 7 62 194 67% 15 18 7 1 7 3 51 18% 3 6 1 7 9 9 11 46 16% 291
* Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support )
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 Schedule HR - 2a
MPTC New Albany - MP TotalCare Supply, Inc.
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 * Oct-04 * Nov-04 6 79 2 11 91 189 72% 22 16 13 1 52 20% 1 6 7 9 23 9% 264 Dec-04 6 76 2 12 92 188 71% 23 15 13 1 52 20% 1 6 7 9 23 9% 263
59 1 14 90 164 64% 28 12 19 59 23% 1 11 1 15 4 32 13% 255
60 1 12 91 164 65% 25 12 20 57 23% 1 10 2 15 4 32 13% 253
62 12 92 166 66% 27 13 18 58 23% 1 10 3 11 4 29 11% 253
63 13 87 163 64% 27 17 21 65 25% 1 10 3 10 4 28 11% 256
61 1 13 87 162 62% 30 19 22 71 27% 1 9 4 10 4 28 11% 261
64 2 13 89 168 64% 29 18 21 68 26% 1 10 6 9 26 10% 262
56 2 12 91 161 62% 32 17 24 73 28% 1 11 5 10 27 10% 261
58 1 11 90 160 61% 31 17 25 73 28% 1 12 5 11 29 11% 262
60 1 12 91 164 62% 31 18 23 72 27% 1 1 10 6 10 28 11% 264
61 1 11 88 161 62% 30 18 22 70 27% 1 1 9 6 10 27 10% 258
74 2 11 91 178 68% 28 12 18 1 59 23% 1 1 5 7 10 24 9% 261
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 * Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support and Customer Service) Schedule HR - 3
MPTC Atlanta - DS Medical Supply, Inc. (Atlanta, Los Angeles)
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total
* Acquired 10/14/03
Jan-04
Feb-04
Mar-04
Apr-04
May-04
Jun-04
Jul-04
Aug-04
Sep-04
** Oct-04
Nov-04
Dec-04 1 27 14 53 95 71% 16 7 1 24 18% 3 1 7 2 2 15 11% 134 120 14
20 15 47 82 51% 20 35 4 59 37% 4 2 5 3 2 3 19 12% 160
19 15 50 84 52% 20 34 4 58 36% 4 2 5 3 2 3 19 12% 161 146 15
19 15 49 83 52% 19 35 4 58 36% 4 2 5 3 2 3 19 12% 160 145 15
20 15 49 84 54% 16 34 4 54 34% 4 2 5 3 2 3 19 12% 157 142 15
23 16 50 89 60% 20 17 4 41 28% 4 2 5 3 2 3 19 13% 149 133 16
24 17 45 86 62% 17 13 4 34 24% 4 2 5 3 2 3 19 14% 139 123 16
28 13 46 87 64% 16 12 4 32 24% 3 2 5 3 1 3 17 13% 136 123 13
30 13 50 93 65% 15 12 4 31 22% 3 2 5 3 2 3 18 13% 142 129 13
32 12 49 93 66% 13 13 4 30 21% 3 2 5 3 2 3 18 13% 141 127 14
26 13 52 91 66% 15 9 4 28 20% 3 1 6 3 2 3 18 13% 137 124 13
27 13 51 91 67% 16 10 1 27 20% 3 1 7 3 2 2 18 13% 136 122 14
27 13 52 92 69% 16 9 1 26 19% 3 1 6 2 2 2 16 12% 134 120 14
Location Recap:
Atlanta Los Angeles
145 15
** Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support) and reduction in Marketing due to consolidation to Tampa
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 Schedule HR - 4
MPTC Atlanta - Atlanta Location Only
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Sales Support Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 ** Oct-04 Nov-04 Dec-04 1 23 11 53 88 73% 12 5 1 18 15% 3 1 6 2 2 14 12% 120
16 12 47 75 52% 14 34 4 52 36% 4 2 4 3 2 3 18 12% 145
15 12 50 77 53% 14 33 4 51 35% 4 2 4 3 2 3 18 12% 146
15 12 49 76 52% 14 33 4 51 35% 4 2 4 3 2 3 18 12% 145
15 12 49 76 54% 12 32 4 48 34% 4 2 4 3 2 3 18 13% 142
18 13 50 81 61% 14 16 4 34 26% 4 2 4 3 2 3 18 14% 133
19 14 45 78 63% 11 12 4 27 22% 4 2 4 3 2 3 18 15% 123
23 10 46 79 64% 12 12 4 28 23% 3 2 4 3 1 3 16 13% 123
25 10 50 85 66% 11 12 4 27 21% 3 2 4 3 2 3 17 13% 129
27 9 49 85 67% 9 12 4 25 20% 3 2 4 3 2 3 17 13% 127
22 10 52 84 68% 11 8 4 23 19% 3 1 5 3 2 3 17 14% 124
23 10 51 84 69% 12 8 1 21 17% 3 1 6 3 2 2 17 14% 122
23 10 52 85 71% 12 7 1 20 17% 3 1 5 2 2 2 15 13% 120
* Acquired 10/14/03 ** Includes reclassification for consistency between the divisions and between HR, Payroll and Accounting (e.g. from Marketing to Sales Support) and reduction in Marketing due to consolidation to Tampa
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 Schedule HR - 4a
MPTC Denver - Gericare Providers, Inc.
Dec 04 Headcount Actual Month Dec-03 Operations General Operations Customer Service ** CAP Pharmacists & Support Pharmacy Technicians Shipping/Warehouse Reimbursement Subtotal % of Total Selling HME Sales Reps Physician Sales Reps Puerto Rico Sales Reps Inside Sales Reps Outside Sales Reps Major Account Sales Reps Marketing Subtotal % of Total General & Administrative Executives Compliance Corporate Development Human Resources & Administrative Purchasing Information Technology Accounting & Finance Subtotal % of Total Total
* Acquired 7/14/04 ** Includes Patient Educators *** Mitch K. & Mitch W. no longer on payroll
Jan-04
Feb-04
Mar-04
Apr-04
May-04
Jun-04
Jul-04
* Aug-04
Sep-04
Oct-04
Nov-04
*** Dec-04
86 5 27 118 87% 4 2 6 4% 3 3 1 2 2 11 8% 135
91 4 27 122 88% 4 2 6 4% 3 3 1 2 2 11 8% 139
90 4 27 121 88% 4 2 6 4% 3 3 1 2 2 11 8% 138
88 4 29 121 88% 4 2 6 4% 3 3 1 2 2 11 8% 138
87 4 28 119 89% 4 2 6 4% 1 3 1 2 2 9 7% 134
Prepared by: TS 1/22/05 Reviewed by: CT 02/04/05 Schedule HR - 5