finance excel
lolo1994
CyprienMedicalCenter.xlsx1. st. of ops
| Cyprien Medical Center | |||||
| Statement of operations | |||||
| Fisical Year Ending June 2018 | |||||
| Quarter one | Quarter two | Quarter three | Quarter four | Total | |
| Inpatient Revenue | 11,517,500.00 | 9,767,233.13 | 10,024,220.92 | 10,501,094.94 | 41,810,048.98 |
| Oupatient revenue | 7,452,500.00 | 6,319,974.38 | 6,486,260.59 | 6,794,826.14 | 27,053,561.11 |
| Ancillary Revenue | 1,414,620.00 | 1,199,646.05 | 1,231,210.19 | 1,289,781.54 | 5,135,257.78 |
| Sub total Non DaVinci revenue | 20,384,620.00 | 17,286,853.55 | 17,741,691.70 | 18,585,702.62 | 73,998,867.87 |
| DaVinci SS revenue | 3,315,000.00 | 3,315,000.00 | 3,315,000.00 | 3,315,000.00 | 13,260,000.00 |
| DaVinci DS revenue | 1,560,000.00 | 1,560,000.00 | 1,560,000.00 | 1,560,000.00 | 6,240,000.00 |
| sub total DaVinci revenue | 4,875,000.00 | 4,875,000.00 | 4,875,000.00 | 4,875,000.00 | 19,500,000.00 |
| Total revenue | 25,259,620.00 | 22,161,853.55 | 22,616,691.70 | 23,460,702.62 | 93,498,867.87 |
| Quarter One | Quarter two | Quarter three | Quarter four | total | |
| Non Davinci w/fringe | $ 9,911,825.00 | $ 8,405,565.92 | $ 8,626,726.59 | $ 9,037,118.76 | $ 35,981,236.27 |
| Maintenace | $ 677,500.00 | $ 574,543.13 | $ 589,660.05 | $ 617,711.47 | $ 2,459,414.65 |
| Utilities | $ 135,500.00 | $ 114,908.63 | $ 117,932.01 | $ 123,542.29 | $ 491,882.93 |
| Transportation | $ 203,250.00 | $ 172,362.94 | $ 176,898.02 | $ 185,313.44 | $ 737,824.39 |
| Supplies | $ 556,072.22 | $ 471,568.22 | $ 483,975.75 | $ 506,999.53 | $ 2,018,615.73 |
| sub-total non divinci | $ 11,484,147.22 | $ 9,738,948.83 | $ 9,995,192.43 | $ 10,470,685.50 | $ 41,688,973.97 |
| davinci sal w/fringe | $ 1,531,202.40 | $ 1,531,202.40 | $ 1,531,202.40 | $ 1,531,202.40 | $ 6,124,809.60 |
| Davinci expense without sal | $ 2,035,250.66 | $ 2,035,250.66 | $ 2,035,250.66 | $ 2,035,250.66 | $ 8,141,002.64 |
| sub-total divinci | $ 3,566,453.06 | $ 3,566,453.06 | $ 3,566,453.06 | $ 3,566,453.06 | $ 14,265,812.24 |
| total expense | $ 15,050,600.28 | $ 13,305,401.89 | $ 13,561,645.49 | $ 14,037,138.56 | $ 55,954,786.21 |
| Total Revenue | 25,259,620.00 | 22,161,853.55 | 22,616,691.70 | 23,460,702.62 | 93,498,867.87 |
| Total Expense | 15,050,600.28 | 13,305,401.89 | 13,561,645.49 | 14,037,138.56 | 55,954,786.21 |
| Income Statement | 10,209,019.72 | 8,856,451.66 | 9,055,046.22 | 9,423,564.06 | 37,544,081.66 |
2. Balance
| Cyprien Medical Center | |
| Balance Sheet | |
| Fisical Year Ending June 2018 | |
| Assets | |
| Land | 2,000,000 |
| Amortization | (10,000) |
| Equipment (Non DV) | 5,000,000 |
| Prepaid exp | 25,000 |
| total Asset | 7,015,000 |
| Liabilities | |
| Account Payable | 50,000 |
| Notes Payable | 10,000 |
| Total liabilities and Equity | 60,000 |
| Total Assets | 7,015,000 |
| Total liabilities | 60,000 |
| Net Equity | 6,955,000 |
| Debt ratio | 0.0085531005 |
3. CF
| Cyprien Medical Center | |
| Cash Flow | |
| Fisical Year Ending June 2018 | |
| Cash Flow from Operations | |
| Cash from Patients | 125,000.00 |
| Fundrasing/ Charity Donations | 500,000.00 |
| Cash Flow from investing | |
| Purchase of Equipment | 200,000.00 |
| Cash Flow from financing | |
| Salavage Receipts | 1,500,000.00 |
| Interest | 10,000.00 |
| Taxes Paid | 0 |
4 Pro-forma
| Cyprien Medical Center | |||||
| ProForma Forecast | |||||
| Fisical Year Ending June 2018 | |||||
| total | Year One | Year Two | Year Three | Year Four | |
| Inpatient Revenue | 41,810,048.98 | 43,900,551.43 | 46,095,579.00 | 48,400,357.95 | 50,820,375.85 |
| Oupatient revenue | 27,053,561.11 | 27,324,096.72 | 27,597,337.68 | 27,873,311.06 | 28,152,044.17 |
| Ancillary Revenue | 5,135,257.78 | 5,135,257.78 | 5,135,257.78 | 5,135,257.78 | 5,135,257.78 |
| Sub total Non DaVinci revenue | 73,998,867.87 | 76,359,905.93 | 78,828,174.47 | 81,408,926.79 | 84,107,677.80 |
| DaVinci SS revenue | 13,260,000.00 | 13,657,800.00 | 14,067,534.00 | 14,489,560.02 | 14,924,246.82 |
| DaVinci DS revenue | 6,240,000.00 | 6,427,200.00 | 6,620,016.00 | 6,818,616.48 | 7,023,174.97 |
| sub total DaVinci revenue | 19,500,000.00 | 20,085,000.00 | 20,687,550.00 | 21,308,176.50 | 21,947,421.80 |
| Total revenue | 93,498,867.87 | 96,444,905.93 | 99,515,724.47 | 102,717,103.29 | 106,055,099.60 |
| Non Davinci sal w/fringe | $ 35,981,236.27 | $ 36,700,861.00 | $ 37,434,878.22 | $ 38,183,575.78 | $ 38,947,247.30 |
| Maintenace | $ 2,459,414.65 | 2,459,414.65 | 2,459,414.65 | 2,459,414.65 | 2,459,414.65 |
| Utilities | $ 491,882.93 | 491,882.93 | 491,882.93 | 491,882.93 | 491,882.93 |
| Transportation | $ 737,824.39 | 737,824.39 | 737,824.39 | 737,824.39 | 737,824.39 |
| Supplies | $ 2,018,615.73 | 2,038,801.88 | 2,059,189.90 | 2,079,781.80 | 2,100,579.62 |
| sub-total non divinci | $ 41,688,973.97 | 42,428,784.85 | 43,183,190.09 | 43,952,479.55 | 44,736,948.88 |
| davinci sal w/fringe | $ 6,124,809.60 | 6,247,305.79 | 6,372,251.91 | 6,499,696.95 | 6,629,690.88 |
| Divici without dv sal | $ 8,141,002.64 | 8,385,232.72 | 8,636,789.70 | 8,895,893.40 | 9,162,770.20 |
| total exp | $ 55,954,786.21 | 57,061,323.36 | 58,192,231.70 | 59,348,069.89 | 60,529,409.97 |
| Total Revenue | 93,498,867.87 | 96,444,905.93 | 99,515,724.47 | 102,717,103.29 | 106,055,099.60 |
| Total Expense | 55,954,786.21 | 57,061,323.36 | 58,192,231.70 | 59,348,069.89 | 60,529,409.97 |
| Income Statement | 37,544,081.66 | 39,383,582.56 | 41,323,492.77 | 43,369,033.40 | 45,525,689.63 |
5 consol op data
| Cyprien Medical Center | |||||||||||||
| Consolidated Operating Data | |||||||||||||
| Fiscal Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| Medical Inpatient (inpt) Days | 18,475 | 16,628 | 14,965 | 13,468 | 14,142 | 14,849 | 15,591 | 14,500 | 13,485 | 12,541 | 15,049 | 18,059 | 181,751 |
| Surgical Inpt Days (Non DV) | 600 | 540 | 486 | 437 | 459 | 482 | 506 | 471 | 438 | 407 | 489 | 586 | 5,903 |
| Davinci Inpt days (cases) | 756 | 756 | 945 | 756 | 756 | 945 | 756 | 756 | 945 | 756 | 756 | 945 | 9,828 |
| Outpt visits | 2,690 | 2,421 | 2,179 | 1,961 | 2,059 | 2,162 | 2,270 | 2,111 | 1,963 | 1,826 | 2,191 | 2,629 | 26,463 |
| Total Discharges | 4,500 | 4,050 | 3,645 | 3,281 | 3,445 | 3,617 | 3,798 | 3,532 | 3,285 | 3,055 | 3,666 | 4,399 | 44,269 |
| Inpt Ancillary | 2,170 | 1,953 | 1,758 | 1,582 | 1,661 | 1,744 | 1,831 | 1,703 | 1,584 | 1,473 | 1,768 | 2,121 | 21,348 |
| Outpt ancillary | 3,875 | 3,488 | 3,139 | 2,825 | 2,966 | 3,114 | 3,270 | 3,041 | 2,828 | 2,630 | 3,156 | 3,788 | 38,121 |
| Sum of Inpt days | 19,831 | 17,924 | 16,396 | 14,662 | 15,357 | 16,276 | 16,854 | 15,727 | 14,868 | 13,704 | 16,294 | 19,590 | 197,481 |
| Total of Patient Activities | 33,066 | 29,835 | 27,116 | 24,310 | 25,488 | 26,913 | 28,023 | 26,114 | 24,528 | 22,688 | 27,075 | 32,527 | 327,683 |
| Calculate ALOS (monthly) | 4.41 | 4.43 | 4.50 | 4.47 | 4.46 | 4.50 | 4.44 | 4.45 | 4.53 | 4.49 | 4.45 | 4.45 | 53.56 |
| Occupancy rate | 88% | 80% | 73% | 65% | 68% | 72% | 75% | 70% | 66% | 61% | 72% | 87% | 8.7769483329 |
| Davinci occupancy | 3% | 3% | 4% | 3% | 3% | 4% | 3% | 3% | 4% | 3% | 3% | 4% | 0.4368 |
| Average occup rate | 73% |
6 consol sal and wag
| Cyprien Medical Center | |||||||||||||
| Consolidated Salary and Wage | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| non-Davinci salary | $ 2,750,000.00 | $ 2,475,000.00 | $ 2,227,500.00 | $ 2,004,750.00 | $ 2,104,987.50 | $ 2,210,236.88 | $ 2,320,748.72 | $ 2,158,296.31 | $ 2,007,215.57 | $ 1,866,710.48 | $ 2,240,052.57 | $ 2,688,063.09 | $ 27,053,561.11 |
| Davinci salary | $ 354,240.00 | $ 354,240.00 | $ 442,800.00 | $ 354,240.00 | $ 354,240.00 | $ 442,800.00 | $ 354,240.00 | $ 354,240.00 | $ 442,800.00 | $ 354,240.00 | $ 354,240.00 | $ 442,800.00 | $ 4,605,120.00 |
| subtotal Salary | 3,104,240 | 2,829,240 | 2,670,300 | 2,358,990 | 2,459,228 | 2,653,037 | 2,674,989 | 2,512,536 | 2,450,016 | 2,220,950 | 2,594,293 | 3,130,863 | 31,658,681 |
| fringe | $ 1,024,399.20 | $ 933,649.20 | $ 881,199.00 | $ 778,466.70 | $ 811,545.08 | $ 875,502.17 | $ 882,746.28 | $ 829,136.98 | $ 808,505.14 | $ 732,913.66 | $ 856,116.55 | $ 1,033,184.82 | 10,447,365 |
| Total salary w/ Fringe | 4,128,639.20 | 3,762,889.20 | 3,551,499.00 | 3,137,456.70 | 3,270,772.58 | 3,528,539.04 | 3,557,735.00 | 3,341,673.29 | 3,258,520.70 | 2,953,864.13 | 3,450,409.12 | 4,164,047.91 | 42,106,046 |
7 consol rev cal
| Cyprien Medical Center | |||||||||||||
| Consolidated Revenue | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| Inpatient Revenue | 4,250,000.00 | 3,825,000.00 | 3,442,500.00 | 3,098,250.00 | 3,253,162.50 | 3,415,820.63 | 3,586,611.66 | 3,335,548.84 | 3,102,060.42 | 2,884,916.19 | 3,461,899.43 | 4,154,279.32 | 41,810,048.98 |
| Oupatient revenue | 2,750,000.00 | 2,475,000.00 | 2,227,500.00 | 2,004,750.00 | 2,104,987.50 | 2,210,236.88 | 2,320,748.72 | 2,158,296.31 | 2,007,215.57 | 1,866,710.48 | 2,240,052.57 | 2,688,063.09 | 27,053,561.11 |
| Ancillary Revenue | 522,000.00 | 469,800.00 | 422,820.00 | 380,538.00 | 399,564.90 | 419,543.15 | 440,520.30 | 409,683.88 | 381,006.01 | 354,335.59 | 425,202.71 | 510,243.25 | 5,135,257.78 |
| Sub total Non DaVinci revenue | 7,522,000.00 | 6,769,800.00 | 6,092,820.00 | 5,483,538.00 | 5,757,714.90 | 6,045,600.65 | 6,347,880.68 | 5,903,529.03 | 5,490,282.00 | 5,105,962.26 | 6,127,154.71 | 7,352,585.65 | 73,998,867.87 |
| DaVinci SS revenue | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 13,260,000.00 |
| DaVinci DS revenue | 480000 | 480000 | 600000 | 480000 | 480000 | 600000 | 480000 | 480000 | 600000 | 480000 | 480000 | 600000 | 6240000 |
| sub total DaVinci revenue | 1,500,000.00 | 1,500,000.00 | 1,875,000.00 | 1,500,000.00 | 1,500,000.00 | 1,875,000.00 | 1,500,000.00 | 1,500,000.00 | 1,875,000.00 | 1,500,000.00 | 1,500,000.00 | 1,875,000.00 | 19,500,000.00 |
| Total revenue | 9,022,000.00 | 8,269,800.00 | 7,967,820.00 | 6,983,538.00 | 7,257,714.90 | 7,920,600.65 | 7,847,880.68 | 7,403,529.03 | 7,365,282.00 | 6,605,962.26 | 7,627,154.71 | 9,227,585.65 | 93,498,867.87 |
8 consol exp cal
| Cyprien Medical Center | |||||||||||||
| Consolidated Expense | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| catergory | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| Maintenace | 250000 | 225000 | 202500 | 182250 | 191363 | 200931 | 210977 | 196209 | 182474 | 169701 | 203641 | 244369 | 2,459,414.65 |
| Utilities | 50000 | 45000 | 40500 | 36450 | 38273 | 40186 | 42195 | 39242 | 36495 | 33940 | 40728 | 48874 | 491,882.93 |
| Transportation | 75000 | 67500 | 60750 | 54675 | 57409 | 60279 | 63293 | 58863 | 54742 | 50910 | 61092 | 73311 | 737,824.39 |
| Supplies | $ 205,192.70 | 184673.43 | 166206.087 | 149585.4783 | 157065 | 164918 | 173164 | 161042 | 149769 | 139286 | 167143 | 200571 | 2,018,615.73 |
| sub-total non divinci | 580,192.70 | 522,173.43 | 469,956.09 | 422,960.48 | 444,108.50 | 466,313.93 | 489,629.62 | 455,355.55 | 423,480.66 | 393,837.02 | 472,604.42 | 567,125.30 | 5,707,737.70 |
| sub-total divinci | $ 1,098,556.09 | $ 1,098,556.09 | $ 1,369,340.89 | $ 1,098,556.09 | $ 1,098,556.09 | $ 1,369,340.89 | $ 1,098,556.09 | $ 1,098,556.09 | $ 1,369,340.89 | $ 1,098,556.09 | $ 1,098,556.09 | $ 1,369,340.89 | $ 14,265,812.24 |
| total expense | 1,678,748.79 | 1,620,729.52 | 1,839,296.97 | 1,521,516.57 | 1,542,664.59 | 1,835,654.81 | 1,588,185.71 | 1,553,911.64 | 1,792,821.55 | 1,492,393.10 | 1,571,160.51 | 1,936,466.19 | 19,973,549.94 |
| Davinci expense without sal | $ 627,416.89 | 627,416.89 | 780,416.89 | 627,416.89 | 627,416.89 | 780,416.89 | 627,416.89 | 627,416.89 | 780,416.89 | 627,416.89 | 627,416.89 | 780,416.89 | 8,141,002.64 |
9 daVinci ops data
| Cyprien Medical Center | |||||||||||||
| Cyprien Medical Center | |||||||||||||
| DaVinci Operating Data | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| DaVinci Single Surgery Cases | 120 | 120 | 150 | 120 | 120 | 150 | 120 | 120 | 150 | 120 | 120 | 150 | 1,560 |
| DaVinci Dual Surgery Cases | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 624 |
| DaVinci Surgical Cases | 168 | 168 | 210 | 168 | 168 | 210 | 168 | 168 | 210 | 168 | 168 | 210 | 2,184 |
| DaVinvi Inpatient Days Per Cases | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | |
| Total DaVinci Inpatient Days | 756 | 756 | 945 | 756 | 756 | 945 | 756 | 756 | 945 | 756 | 756 | 945 | 9,828 |
10 daVinci sal and wag cal
| Cyprien Medical Center | |||||||||||||
| DaVinci Salary and Wages | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| DaVinci SS Cases | 120 | 120 | 150 | 120 | 120 | 150 | 120 | 120 | 150 | 120 | 120 | 150 | 1560 |
| SS Labor Per Cases | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | $ 1,640 | |
| SS Labor Expense | $ 196,800 | $ 196,800 | $ 246,000 | $ 196,800 | $ 196,800 | $ 246,000 | $ 196,800 | $ 196,800 | $ 246,000 | $ 196,800 | $ 196,800 | $ 246,000 | $ 2,558,400 |
| DaVinci DS Cases | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 48 | 48 | 60 | 624 |
| DS Labor Per Case | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | $ 3,280 | |
| DS Labor Expense | $ 157,440 | $ 157,440 | $ 196,800 | $ 157,440 | $ 157,440 | $ 196,800 | $ 157,440 | $ 157,440 | $ 196,800 | $ 157,440 | $ 157,440 | $ 196,800 | $ 2,046,720 |
| Total Davinci Cases | 168 | 168 | 210 | 168 | 168 | 210 | 168 | 168 | 210 | 168 | 168 | 210 | 2184 |
| Sub-total Davinci Labor Expense | $ 354,240 | $ 354,240 | $ 442,800 | $ 354,240 | $ 354,240 | $ 442,800 | $ 354,240 | $ 354,240 | $ 442,800 | $ 354,240 | $ 354,240 | $ 442,800 | $ 4,605,120 |
| Fringe Benefits (33%) | $ 116,899.20 | $ 116,899.20 | $ 146,124.00 | $ 116,899.20 | $ 116,899.20 | $ 146,124.00 | $ 116,899.20 | $ 116,899.20 | $ 146,124.00 | $ 116,899.20 | $ 116,899.20 | $ 146,124.00 | $ 1,519,689.60 |
| Total Davinci Labor Expense | $ 471,139.20 | $ 471,139.20 | $ 588,924.00 | $ 471,139.20 | $ 471,139.20 | $ 588,924.00 | $ 471,139.20 | $ 471,139.20 | $ 588,924.00 | $ 471,139.20 | $ 471,139.20 | $ 588,924.00 | $ 6,124,809.60 |
| Background Data | |||||||||||||
| Rate | SS QTY | SS Hours | SS Labor Cost | DS QTY | DS Hours | DS Labor Cost | |||||||
| Surgeon/MD | 275 | 1 | 4 | $ 1,100 | 2 | 8 | $ 2,200 | ||||||
| Nurse/RN | 65 | 1 | 4 | $ 260 | 2 | 8 | $ 520 | ||||||
| Surg Tech | 35 | 2 | 8 | $ 280 | 4 | 16 | $ 560 | ||||||
| $ 1,640 | $ 3,280 | ||||||||||||
| 4 | |||||||||||||
| Hour Per Procedure | |||||||||||||
11 Davinci rev cal
| Cyprien Medical Center | |||||||||||||
| DaVinci Revenue Calculation | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| DaVinci Single Surgery Cases | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 1,560.00 |
| DaVinci Revenue Per Case | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 8,500.00 | 102,000.00 |
| Total DaVinci Single Surgery Revenue | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 1,020,000.00 | 1,020,000.00 | 1,275,000.00 | 13,260,000.00 |
| DaVinci Dual Surgery Cases | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 624.00 |
| DaVinci Revenue Per Case | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 10,000.00 | 120,000.00 |
| Total DaVinci Dual Surgery Revenue | 480,000.00 | 480,000.00 | 600,000.00 | 480,000.00 | 480,000.00 | 600,000.00 | 480,000.00 | 480,000.00 | 600,000.00 | 480,000.00 | 480,000.00 | 600,000.00 | 6,240,000.00 |
| Total Revenue | 1,500,000 | 1,500,000 | 1,875,000 | 1,500,000 | 1,500,000 | 1,875,000 | 1,500,000 | 1,500,000 | 1,875,000 | 1,500,000 | 1,500,000 | 1,875,000 | 19,500,000 |
12 daVinci exp cal
| Cyprien Medical Center | Cyprien Medical Center | |||||||||||||
| DaVinci Expense Calculation | DaVinci Expense Calculation | |||||||||||||
| Fisical Year Ending June 2018 | Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total | |
| DaVinci SS Sal and Wage | 261,744.00 | 261,744.00 | 327,180.00 | 261,744.00 | 261,744.00 | 327,180.00 | 261,744.00 | 261,744.00 | 327,180.00 | 261,744.00 | 261,744.00 | 327,180.00 | 3,402,672.00 | 6,124,809.60 |
| DaVinci Single Surgery Cases | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 120.00 | 120.00 | 150.00 | 1,560.00 | |
| Supply Expense Per Case | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 3,500.00 | 42,000.00 | |
| Sub-total Total SS Exepnse | 420,000.00 | 420,000.00 | 525,000.00 | 420,000.00 | 420,000.00 | 525,000.00 | 420,000.00 | 420,000.00 | 525,000.00 | 420,000.00 | 420,000.00 | 525,000.00 | 5,460,000.00 | |
| Maint Exp (SS Allo) | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 11,012.13 | 132,145.50 | |
| Total SS Expense | 692,756.13 | 692,756.13 | 863,192.13 | 692,756.13 | 692,756.13 | 863,192.13 | 692,756.13 | 692,756.13 | 863,192.13 | 692,756.13 | 692,756.13 | 863,192.13 | 8,994,817.50 | |
| DaVinci DS Sal and Wage | 209,395.20 | 209,395.20 | 261,744.00 | 209,395.20 | 209,395.20 | 261,744.00 | 209,395.20 | 209,395.20 | 261,744.00 | 209,395.20 | 209,395.20 | 261,744.00 | 2,722,137.60 | |
| DaVinci Dual Surgery Cases | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 48.00 | 48.00 | 60.00 | 624.00 | |
| Supply Expense Per Case | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 4,000.00 | 48,000.00 | |
| Sub-total DS Exepnse | 192,000.00 | 192,000.00 | 240,000.00 | 192,000.00 | 192,000.00 | 240,000.00 | 192,000.00 | 192,000.00 | 240,000.00 | 192,000.00 | 192,000.00 | 240,000.00 | 2,496,000.00 | |
| Maint Exp (DS Allo) | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 4,404.76 | 52,857.14 | |
| Total DS Expense | 405,799.96 | 405,799.96 | 506,148.76 | 405,799.96 | 405,799.96 | 506,148.76 | 405,799.96 | 405,799.96 | 506,148.76 | 405,799.96 | 405,799.96 | 506,148.76 | 5,270,994.74 | |
| Annual maintenance costs | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 15,416.67 | 185,000.00 | |
| Total Davinci Expense | 1,098,556.09 | 1,098,556.09 | 1,369,340.89 | 1,098,556.09 | 1,098,556.09 | 1,369,340.89 | 1,098,556.09 | 1,098,556.09 | 1,369,340.89 | 1,098,556.09 | 1,098,556.09 | 1,369,340.89 | 14,265,812.24 | |
| Annual maintenance costs | 185000 | |||||||||||||
| Supply Expense Per Case | 3500 | |||||||||||||
13 daVinci BE analy
| Cyprien Medical Center | |||||||||||||
| DaVinci Break-Even Analysis | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Category | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| Total DS Exepnse | $ 405,799.96 | $ 405,799.96 | $ 506,148.76 | $ 405,799.96 | $ 405,799.96 | $ 506,148.76 | $ 405,799.96 | $ 405,799.96 | $ 506,148.76 | $ 405,799.96 | $ 405,799.96 | $ 506,148.76 | $ 5,270,994.74 |
| revenue | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | |
| Davinci DS BE | $ 41 | $ 41 | $ 51 | $ 41 | $ 41 | $ 51 | $ 41 | $ 41 | $ 51 | $ 41 | $ 41 | $ 51 | |
| Total SS Exepnse | $ 692,756 | $ 692,756 | $ 863,192 | $ 692,756 | $ 692,756 | $ 863,192 | $ 692,756 | $ 692,756 | $ 863,192 | $ 692,756 | $ 692,756 | $ 863,192 | $ 8,994,818 |
| Revenue | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | $ 8,500 | |
| Davinci SS BE | $ 82 | $ 82 | $ 102 | $ 82 | $ 82 | $ 102 | $ 82 | $ 82 | $ 102 | $ 82 | $ 82 | $ 102 | |
| Total BE Cases | 122 | 122 | 152 | 122 | 122 | 152 | 122 | 122 | 152 | 122 | 122 | 152 |
14 Supply List
| Cyprien Medical Center | ||||||||
| DaVinci Supply List | ||||||||
| Fisical Year Ending June 2018 | Vlookup!!! | |||||||
| Category | Description | Quantity | Price Per Unit | Total Price | IF Statements | |||
| 1 | Syringe/Needle | Syringe with needle, sterile, 1 ml or less, | 50 | $ 1.75 | $ 87.50 | 56 | Wound Care Supply | L1 Pay Now |
| 2 | Syringe/Needle | Syringe with needle, sterile 2 ml | 50 | $ 1.75 | $ 87.50 | 76 | Wound Care Supply | L1 Pay Now |
| 3 | Syringe/Needle | Syringe with needle, sterile 3 ml | 50 | $ 1.75 | $ 87.50 | 40 | Tracheostomy Supply | L1 Pay Now |
| 4 | Syringe/Needle | Syringe with needle, sterile 5 ml or greater | 50 | $ 1.75 | $ 87.50 | 121 | Respiratory Supply | L1 Pay Now |
| 5 | Syringe/Needle | Non-coring needle | 50 | $ 1.75 | $ 87.50 | 92 | Wound Care Supply | L1 Pay Now |
| 6 | Miscellaneous | Syringe, bulb type (infant nasal aspiraters, ear and ulcer bulb syringes) | 25 | $ 0.99 | $ 24.75 | 70 | Wound Care Supply | L1 Pay Now |
| 7 | Syringe/Needle | Needle, sterile, any size, each | 50 | $ 1.75 | $ 87.50 | 7 | Syringe/Needle | L1 Pay Now |
| 8 | Infusion Supply | Intravenous administration set (with or without infusion pump), hypodermoclysis administration set, connecting device, heparin lock caps | 250 | $ 5.75 | $ 1,437.50 | 73 | Wound Care Supply | L1 Pay Now |
| 9 | Diabetic Supply | Infusion set for external insulin pump, non needle cannula type | 30 | $ 20.95 | $ 628.50 | 89 | Wound Care Supply | L1 Pay Now |
| 10 | Diabetic Supply | Infusion set for external insulin pump, needle type | 30 | $ 20.95 | $ 628.50 | 128 | Respiratory Supply | L1 Pay Now |
| 11 | Diabetic Supply | Syringe with needle for external insulin pump, sterile, 3cc | 30 | $ 20.95 | $ 628.50 | L1 Pay Now | ||
| 12 | Diabetic Supply | Normal, low and high calibrator solution / chips | 30 | $ 20.95 | $ 628.50 | L1 Pay Now | ||
| 13 | Infusion Supply | Disposable drug delivery system, flow rate of 50 ml or greater per hour | 30 | $ 35.99 | $ 1,079.70 | L1 Pay Now | ||
| 14 | Infusion Supply | Disposable drug delivery system, flow rate of less than 50 ml per hour | 30 | $ 35.99 | $ 1,079.70 | L1 Pay Now | ||
| 15 | Urological Supply | Insertion tray without drainage bag and without catheter (accessories only) | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 16 | Urological Supply | Insertion tray without drainage bag with indwelling catheter, foley type, two-way latex with coating (teflon, silicone, silicone elastomer or hydrophilic, etc.) | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 17 | Urological Supply | Insertion tray without drainage bag with indwelling catheter, foley type, two-way, all silicone | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 18 | Urological Supply | Insertion tray without drainage bag with indwelling catheter, foley type, three-way, for continuous irrigation | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 19 | Urological Supply | Insertion tray with drainage bag with indwelling catheter, foley type, two-way latex with coating (teflon, silicone, silicone elastomer or hydrophilic, etc.) | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 20 | Urological Supply | Insertion tray with drainage bag with indwelling catheter, foley type, two-way, all silicone | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 21 | Urological Supply | Insertion tray with drainage bag with indwelling catheter, foley type, three-way, for continuous irrigation | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 22 | Urological Supply | Irrigation tray with bulb or piston syringe, any purpose | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 23 | Urological Supply | Irrigation syringe, bulb or piston, each | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 24 | Urological Supply | Male external catheter with integral collection chamber, any type, each | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 25 | Urological Supply | Female external urinary collection device; meatal cup, each | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 26 | Urological Supply | Female external urinary collection device; pouch, each | 200 | $ 14.99 | $ 2,998.00 | L2 Pay 30 Days | ||
| 27 | Ostomy Supply | Ostomy faceplate, each | 150 | $ 1.50 | $ 225.00 | L1 Pay Now | ||
| 28 | Ostomy Supply | Skin barrier; solid 4" x 4" or equivalent, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 29 | Ostomy Supply | Ostomy clamp, any type, replacement only, each | 150 | $ 4.99 | $ 748.50 | L1 Pay Now | ||
| 30 | Ostomy Supply | Adhesive, liquid or equal, any type | 20 | $ 3.99 | $ 79.80 | L1 Pay Now | ||
| 31 | Ostomy Supply | Ostomy vent, any type, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 32 | Ostomy Supply | Ostomy belt, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 33 | Ostomy Supply | Ostomy filter, any type, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 34 | Ostomy Supply | Ostomy skin barrier, liquid (spray/brush etc) | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 35 | Ostomy Supply | Ostomy skin barrier, powder | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 36 | Ostomy Supply | Ostomy pouch, drainable with faceplate attached, plastic, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 37 | Ostomy Supply | Ostomy pouch, drainable with faceplate attached, rubber, each | 150 | $ 1.75 | $ 262.50 | L1 Pay Now | ||
| 38 | Tracheostomy Supply | Tracheostoma filter, any type, any size, each | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 39 | Tracheostomy Supply | Moisture exchanger, disposable, for use w/invasive mechanical ventilation | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 40 | Tracheostomy Supply | Tracheal suction catheter, closed system, each | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 41 | Tracheostomy Supply | Tracheostomy, inner cannula | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 42 | Tracheostomy Supply | Tracheal suction catheter, any type other than closed system, each | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 43 | Tracheostomy Supply | Tracheostomy care kit for new tracheostomy | 100 | $ 17.99 | $ 1,799.00 | L1 Pay Now | ||
| 44 | Tracheostomy Supply | Tracheostomy cleaning brush, each | 250 | $ 17.99 | $ 4,497.50 | L2 Pay 30 Days | ||
| 45 | Tracheostomy Supply | Oropharyngeal suction catheter, each | 250 | $ 17.99 | $ 4,497.50 | L2 Pay 30 Days | ||
| 46 | Wound Care Supply | Wound pouch, each | 100 | $ 1.00 | $ 100.00 | L1 Pay Now | ||
| 47 | Wound Care Supply | Alginate or other fiber gelling dressing, wound cover, sterile, pad size 16 sq. in. or less, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 48 | Wound Care Supply | Alginate or other fiber gelling dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 49 | Wound Care Supply | Alginate or other fiber gelling dressing, wound filler, sterile | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 50 | Wound Care Supply | Composite dressing, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 51 | Wound Care Supply | Composite dressing, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 52 | Wound Care Supply | Composite dressing, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 53 | Wound Care Supply | Contact layer, sterile, 16 sq. in. or less, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 54 | Wound Care Supply | Contact layer, sterile, more than 16 sq. in. but less than or equal to 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 55 | Wound Care Supply | Contact layer, sterile, more than 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 56 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 57 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 58 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 59 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 60 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 61 | Wound Care Supply | Foam dressing, wound cover, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 62 | Wound Care Supply | Foam dressing, wound filler, sterile, per gram | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 63 | Wound Care Supply | Gauze, non-impregnated, non-sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 64 | Wound Care Supply | Gauze, non-impregnated, non-sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 65 | Wound Care Supply | Gauze, non-impregnated, non-sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 66 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 67 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 68 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 69 | Wound Care Supply | Gauze, impregnated with other than water, normal saline, or hydrogel, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 70 | Wound Care Supply | Gauze, impregnated with other than water, normal saline, or hydrogel, sterile, pad size more than 16 sq. in., but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 71 | Wound Care Supply | Gauze, impregnated with other than water, normal saline, or hydrogel, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 72 | Wound Care Supply | Gauze, impregnated, water or normal saline, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 73 | Wound Care Supply | Gauze, impregnated, water or normal saline, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 74 | Wound Care Supply | Gauze, impregnated, water or normal saline, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 75 | Wound Care Supply | Gauze, impregnated, hydrogel, for direct wound contact, sterile, pad size 16 sq. in. or less, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 76 | Wound Care Supply | Gauze, impregnated, hydrogel, for direct wound contact, sterile, pad size greater than 16 sq. in., but less than or equal to 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 77 | Wound Care Supply | Gauze, impregnated, hydrogel, for direct wound contact, sterile, pad size more than 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 78 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 79 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 80 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 81 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 82 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 83 | Wound Care Supply | Hydrocolloid dressing, wound cover, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 84 | Wound Care Supply | Hydrocolloid dressing, wound filler, paste, sterile | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 85 | Wound Care Supply | Hydrocolloid dressing, wound filler, dry form, sterile, per gram | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 86 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 87 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 88 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 89 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 90 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 91 | Wound Care Supply | Hydrogel dressing, wound cover, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 92 | Wound Care Supply | Hydrogel dressing, wound filler, gel | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 93 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 94 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 95 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 96 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size 16 sq. in. or less, with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 97 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size more than 16 sq. in. but less than or equal to 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 98 | Wound Care Supply | Specialty absorptive dressing, wound cover, sterile, pad size more than 48 sq. in., with any size adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 99 | Wound Care Supply | Transparent film, sterile, 16 sq. in. or less, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 100 | Wound Care Supply | Transparent film, sterile, more than 16 sq. in. but less than or equal to 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 101 | Wound Care Supply | Transparent film, sterile, more than 48 sq. in., each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 102 | Wound Care Supply | Wound filler, gel/paste, not otherwise specified | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 103 | Wound Care Supply | Wound filler, dry form, per gram, not otherwise specified | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 104 | Wound Care Supply | Gauze, impregnated, other than water, normal saline, or zinc paste, sterile, any width, per linear yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 105 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size 16 sq. in. or less, without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 106 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size more than 16 sq. in. less than or equal to 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 107 | Wound Care Supply | Gauze, non-impregnated, sterile, pad size more than 48 sq. in., without adhesive border, each dressing | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 108 | Wound Care Supply | Packing strips, non-impregnated, sterile, up to 2 inches in width, per linear yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 109 | Wound Care Supply | Eye pad, sterile, each | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 110 | Wound Care Supply | Eye pad, non-sterile, each | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 111 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, non-sterile, width less than three inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 112 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, non-sterile, width greater than or equal to three inches and less than five inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 113 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, non-sterile, width greater than or equal to 5 inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 114 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, sterile, width less than three inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 115 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, sterile, width greater than or equal to three inches and less than five inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 116 | Wound Care Supply | Conforming bandage, non-elastic, knitted/woven, sterile, width greater than or equal to five inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 117 | Wound Care Supply | Self-adherent bandage, elastic, non-knitted/non-woven, width less than three inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 118 | Wound Care Supply | Self-adherent bandage, elastic, non-knitted/non-woven, width greater than or equal to three inches and less than five inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 119 | Wound Care Supply | Self-adherent bandage, elastic, non-knitted/non-woven, width greater than or equal to five inches, per yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 120 | Wound Care Supply | Tubular dressing with or without elastic, any width, per linear yard | 100 | $ 2.99 | $ 299.00 | L1 Pay Now | ||
| 121 | Respiratory Supply | Tubing, used with suction pump, each | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 122 | Respiratory Supply | Administration set, with small volume nonfiltered pneumatic nebulizer, disposable | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 123 | Respiratory Supply | Small volume nonfiltered pneumatic nebulizer, disposable | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 124 | Respiratory Supply | Administration set, with small volume filtered pneumatic nebulizer | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 125 | Respiratory Supply | Large volume nebulizer, disposable, unfilled, used with aerosol compressor | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 126 | Respiratory Supply | Large volume nebulizer, disposable, prefilled, used with aerosol compressor | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 127 | Respiratory Supply | Corrugated tubing, disposable, used with large volume nebulizer, 100 feet | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 128 | Respiratory Supply | Water collection device, used with large volume nebulizer | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 129 | Respiratory Supply | Filter, disposable, used with aerosol compressor or ultrasonic generator | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 130 | Respiratory Supply | Dome and mouthpiece, used with small volume ultrasonic nebulizer | 250 | $ 5.99 | $ 1,497.50 | L1 Pay Now | ||
| 131 | Tracheostomy Supply | Tracheostoma valve, including diaphragm, each | 350 | $ 19.99 | $ 6,996.50 | L3 Pay 60 Days | ||
| 132 | Tracheostomy Supply | Replacement diaphragm/faceplate for tracheostoma valve, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 133 | Tracheostomy Supply | Filter holder or filter cap, reusable, for use in a tracheostoma heat and moisture exchange system, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 134 | Tracheostomy Supply | Filter for use in a tracheostoma heat and moisture exchange system, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 135 | Tracheostomy Supply | Housing, reusable without adhesive, for use in a heat and moisture exchange system and/or with a tracheostoma valve, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 136 | Tracheostomy Supply | Adhesive disc for use in a heat and moisture exchange system and/or with tracheostoma valve, any type each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 137 | Tracheostomy Supply | Filter holder and integrated filter without adhesive, for use in a tracheostoma heat and moisture exchange system, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 138 | Tracheostomy Supply | Housing and integrated adhesive, for use in a tracheostoma heat and moisture exchange system and/or with a tracheostoma valve, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 139 | Tracheostomy Supply | Filter holder and integrated filter housing, and adhesive, for use as a tracheostoma heat and moisture exchange system, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 140 | Tracheostomy Supply | Tracheostomy/laryngectomy tube, non-cuffed, polyvinylchloride (pvc), silicone or equal, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 141 | Tracheostomy Supply | Tracheostomy/laryngectomy tube, cuffed, polyvinylchloride (pvc), silicone or equal, each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 142 | Tracheostomy Supply | Tracheostomy/laryngectomy tube, stainless steel or equal (sterilizable and reusable), each | 350 | $ 14.99 | $ 5,246.50 | L3 Pay 60 Days | ||
| 143 | Tracheostomy Supply | Tracheostomy shower protector, each | 350 | $ 4.99 | $ 1,746.50 | L1 Pay Now | ||
| 144 | Tracheostomy Supply | Tracheostoma stent/stud/button, each | 350 | $ 4.99 | $ 1,746.50 | L1 Pay Now | ||
| 145 | Tracheostomy Supply | Tracheostomy mask, each | 350 | $ 4.99 | $ 1,746.50 | L1 Pay Now | ||
| 146 | Tracheostomy Supply | Tracheostomy tube collar/holder, each | 350 | $ 4.99 | $ 1,746.50 | L1 Pay Now | ||
| 147 | Infusion Supply | Heparin Flush Solution, 10 units/ml | 1000 | $ 7.99 | $ 7,990.00 | L4 Pay 90 Days | ||
| 148 | Infusion Supply | Heparin Flush Solution, 100 units/ml | 1000 | $ 7.99 | $ 7,990.00 | L4 Pay 90 Days | ||
| 149 | Infusion Supply | Syringe, Normal Saline / 0.9% Sodium Chloride Flush | 1000 | $ 7.99 | $ 7,990.00 | L4 Pay 90 Days | ||
| 150 | Orthopaedic Implants | Surgical Supply Sets: Ortho | 50 | $ 49.99 | $ 2,499.50 | L1 Pay Now | ||
| 151 | Neurology Implants | Surgical Supply Sets: Neuro | 50 | $ 49.99 | $ 2,499.50 | L1 Pay Now | ||
| 152 | Cardiology Implants | Surgical Supply Sets: Cardio | 25 | $ 69.99 | $ 1,749.75 | L1 Pay Now | ||
| L1 Pay Now | ||||||||
| Total ------------------> | $ 205,192.70 | Do Not Pay | ||||||
| L1 Pay Now |
mc sup billing
15 ratio cal
| Cyprien Medical Center | |
| Ratio Calculation | |
| Fisical Year Ending June 2018 | |
| Total Asset Turnover | 13.33 |
| Debt to Equity Ratio | 0.01 |
| Revenue per Discharge | 2,112.04 |
| Profit per Discharge | 848.0807893719 |
| Expense per Discharge | 1,263.96 |
16 graph and visual ele
| Cyprien Medical Center | |||||||||||||
| Graph and Visual Elements | |||||||||||||
| Fisical Year Ending June 2018 | |||||||||||||
| Revenue | Total | ||||||||||||
| Med-Surg Revenue (non-div | $ 73,998,867.87 | ||||||||||||
| DaVinci Revenue | $ 19,500,000.00 | ||||||||||||
| Toal Revenue | $ 93,498,867.87 | ||||||||||||
| Expense | Total | ||||||||||||
| Med-surg Salaries (non-div) | $ 35,981,236.27 | ||||||||||||
| Davinci Salaries | $ 6,124,809.60 | ||||||||||||
| Davinci exp without sal | $ 8,141,002.64 | ||||||||||||
| Maintenance | $ 2,459,414.65 | ||||||||||||
| Utilities | $ 491,882.93 | ||||||||||||
| Transportation | $ 737,824.39 | ||||||||||||
| Supplies | $ 2,018,615.73 | ||||||||||||
| Total Expense | $ 55,954,786.21 | ||||||||||||
| Davinci Project | |||||||||||||
| Davinci Revenue | $ 19,500,000.00 | ||||||||||||
| Davinci Salaries | $ 6,124,809.60 | ||||||||||||
| Davinci supply | $ 7,956,000.00 | ||||||||||||
| Davinci mainatance | $ 185,002.64 | ||||||||||||
| Davinci Profit | $ 5,234,187.76 | ||||||||||||
| Total Patient activity | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| 33066 | 29835 | 27116.1 | 24309.99 | 25487.6895 | 26913.273975 | 28022.68767375 | 26114.0195365875 | 24527.9581690264 | 22688.1510971945 | 27074.5813166334 | 32527.2975799601 | 327682.748848152 | |
| Average length of stay (ALOS) | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| 4.41 | 4.43 | 4.50 | 4.47 | 4.46 | 4.50 | 4.44 | 4.45 | 4.53 | 4.49 | 4.45 | 4.45 | 53.56 | |
| Occupancy rate | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Total |
| 88% | 80% | 73% | 65% | 68% | 72% | 75% | 70% | 66% | 61% | 72% | 87% | 8.78 | |
Revenue
TotalMed-Surg Revenue (non-div DaVinci Revenue Toal Revenue 7.39988678686413E7 1.95E7 9.34988678686413E7
Total Patient activity
42933.0 42964.0 42995.0 43025.0 43056.0 43086.0 43118.0 43149.0 43177.0 43208.0 43238.0 43269.0 33066.0 29835.0 27116.1 24309.99 25487.6895 26913.273975 28022.68767375001 26114.0195365875 24527.95816902638 22688.15109719454 27074.58131663344 32527.29757996013
Expense
Med-surg Salaries (non-div) Davinci Salaries Davinci exp without sal Maintenance Utilities Transportation Supplies 3.59812362708795E7 6.1248096E6 8.14100264365E6 2.45941464599313E6 491882.9291986258 737824.3937979387 2.0186157265235E6
Davinci project
Davinci Revenue Davinci Salaries Davinci supply Davinci mainatance Davinci Profit 1.95E7 6.1248096E6 7.956E6 185002.64365
Average Length of Stay (ALOS)
42933.0 42964.0 42995.0 43025.0 43056.0 43086.0 43118.0 43149.0 43177.0 43208.0 43238.0 43269.0 4.40688888888889 4.425555555555555 4.498148148148148 4.469341563786008 4.458367626886145 4.500173100790384 4.43796257414717 4.452946614973063 4.526600886313854 4.48638308022219 4.445134048333308 4.453727596643492
Occupancy rate
42933.0 42964.0 42995.0 43025.0 43056.0 43086.0 43118.0 43149.0 43177.0 43208.0 43238.0 43269.0 0.881377777777778 0.7966 0.7287 0.65163 0.6825315 0.723378075 0.74904697875 0.6989656902375 0.660790091920875 0.609074785486414 0.724169742583697 0.870683691100436
