Spreadsheet: 159183d1338540619-trim-formula-azbud-4
Sheet: Budget With Drivers

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Allocation
 | 2013 Forecasted Estimates
 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Annual Estimate |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
[NAME] | 41073.47067020373 | 75548.31511367828 | 130246.9811090803 | 77652.72243316249 | 88806.18592342972 | 75297.0899535745 | 114854.9105517973 | 78979.04617785598 | 69371.20884581488 | 72414.73620336327 | 131204.3750832431 | 67872.31487007736 | 1023321.356935281 |  | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251 | 0.3277061777831251
[NAME] | 778.7260860142676 | 1432.346543242712 | 2469.397403220352 | 1472.24472687662 | 1683.707085122854 | 1427.583478849961 | 2177.573832795277 | 1497.390955857026 | 1315.232656629837 | 1372.935940724121 | 2487.548965533158 | 1286.814609164392 | 19401.50228403058 |  | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562 | 0.006213094365382562
Medicaid HMO Gross Revenue - OP | 9639.460250654574 | 17730.30057259137 | 30567.43383703225 | 18224.18020770266 | 20841.76684494665 | 17671.34098370663 | 26955.09599727345 | 18535.45278359791 | 16280.60641815182 | 16994.88647547725 | 30792.12293701749 | 15928.83363968173 | 240161.4809478338 |  | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083 | 0.07690878377429083
Workers' Compensation Gross Revenue - OP | 2309.418332985502 | 4247.818874392406 | 7323.334529106023 | 4366.142375289332 | 4993.262816791088 | 4233.69335782456 | 6457.891961249619 | 4440.716944262661 | 3900.501683343534 | 4071.628636137521 | 7377.16546084234 | 3816.224090768896 | 57537.79906299348 |  | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306 | 0.01842577806199306
HMO and PPO Gross Revenue - OP | 51033.47577395033 | 93868.20851040447 | 161830.8861316259 | 96482.91864336943 | 110341.0124333133 | 93556.06315446638 | 142706.3552098727 | 98130.86583625988 | 86193.20082465732 | 89974.76048188582 | 163020.4408828879 | 84330.83642860418 | 1271469.024311298 |  | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698 | 0.4071724403119698
Medicare HMO Gross Revenue - OP | 9496.993573061322 | 17468.25508979213 | 30115.66157716762 | 17954.8354167559 | 20533.73535766797 | 17410.16689583224 | 26556.71238749841 | 18261.5075307414 | 16039.98673143856 | 16743.71006629279 | 30337.02987819379 | 15693.41298877682 | 236612.007493219 |  | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477 | 0.0757721082118477
Commercial/Other Gross Revenue - OP | 10205.72329682739 | 18771.85411923455 | 32363.09539360837 | 19294.74635249436 | 22066.10120333997 | 18709.43099239905 | 28538.55340799936 | 19624.30440832658 | 17236.99874138978 | 17993.23865855841 | 32600.98369052902 | 16864.56132818729 | 254269.5915928941 |  | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493 | 0.08142673405833493
Self Pay/Charity Gross Revenue - OP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gross Patient Revenue | 125336.2721083215 | 230536.743691405 | 397450.4905283702 | 236958.3721566361 | 270993.3225067285 | 229770.1265900635 | 350481.3712355705 | 241005.6676750357 | 211687.2172355705 | 220974.5836750356 | 400371.9916750357 | 207113.3212355705 | 3102772.762627549
DEDUCTIONS FROM REVENUE |  |  |  |  |  |  |  |  |  |  |  |  |  | Alocation | PCR
[PHONE]  Mcare Contr O/P - CY | 19957.5791582153 | 36527.51772091172 | 62974.25565875799 | 37544.99607948015 | 42937.68200076439 | 36406.0506640512 | 55532.20841790716 | 38186.2719837152 | 33540.8944147027 | 35012.43616013601 | 63437.15447131923 | 32816.18101536168 | 494873.2277453227 | 0.2343757781245117
[PHONE]  [NAME] O/P - CY | 457.5419156692828 | 837.4197241146841 | 1443.730291311139 | 860.7461503130138 | 984.3773696842017 | 834.635004112018 | 1273.115983629511 | 875.4478635503868 | 768.9492278649974 | 802.6853851341382 | 1454.34258089703 | 752.334649793328 | 11345.32614607373 | 0.005373233980907205
[PHONE]  Mcare HMO O/P | 4980.475776979896 | 9115.555336646015 | 15715.42081308376 | 9369.470216716292 | 10715.23171368427 | 9085.242855878734 | 13858.23484276329 | 9529.502607523009 | 8370.234227626906 | 8737.462034158163 | 15830.93864743016 | 8189.379751136708 | 123497.1488236272 | 0.0584892023429324
[PHONE]  [NAME] HMO Contrs O/P | 5201.487227508479 | 9520.063298844629 | 16412.8015664689 | 9785.245796401272 | 11190.72622662561 | 9488.405684470943 | 14473.20191047225 | 9952.3797157381 | 8741.668140921345 | 9125.19189061752 | 16533.44557053765 | 8552.7881439842 | 128977.4051725909 | 0.06108469402463473
[PHONE]  Mgd Care Contrs O/P | 44678.00943722007 | 81772.28152349999 | 140977.2380868011 | 84050.05816894921 | 96122.38771218059 | 81500.35944970018 | 124317.1084075909 | 85485.64966399691 | 75086.28102201626 | 78380.54609637873 | 142013.5059303174 | 73463.90228367568 | 1107847.327782327 | 0.5246850403994157
Commercial/Other Gross Revenue - OP | 441.1472141795862 | 807.413191536436 | 1391.998359553465 | 829.9037821943571 | 949.1050316174737 | 804.7282539834484 | 1227.497525956982 | 844.0787017289908 | 741.39613902255 | 773.9234579123085 | 1402.230388197298 | 725.3768966753985 | 10938.7989425583
[PHONE]  Charity Care O/P | 2867.089378239144 | 5247.513099701685 | 9046.829681615915 | 5393.683202363604 | 6168.392018624486 | 5230.063242393344 | 7977.711306714506 | 5485.808370400138 | 4818.457256297524 | 5029.857731000419 | 9113.329343632664 | 4714.345526460645 | 71093.08015744408 | 0.03367023117634539
Self Pay Unins | 33.18545314282605 | 60.7379391128249 | 104.7135623915493 | 62.42980164406847 | 71.3967572320206 | 60.53596374838384 | 92.33892977503317 | 63.4961149129729 | 55.77178329814667 | 58.21866221335257 | 105.483270317162 | 54.56673020201955 | 822.8749679903599
[PHONE]  W/C O/P | 1399.48417046758 | 2561.417015141697 | 4415.940091868905 | 2632.765591305239 | 3010.916594656467 | 2552.899387729977 | 3894.08184308649 | 2677.733744494791 | 2351.986201561857 | 2455.175038373682 | 4448.399918562918 | 2301.167165722733 | 34701.96676297233 | 0.01643511915077418
[PHONE]  BC Contrs O/P | 4945.721619344839 | 9051.946263680504 | 15605.75735186111 | 9304.089305443958 | 10640.45997123452 | 9021.8453058243 | 13761.53097352751 | 9463.004977449931 | 8311.826064869874 | 8676.49132644606 | 15720.46909353599 | 8132.233605356851 | 122635.3758585755 | 0.05808106001894591
[PHONE]  Champ - O/P | 173.492922742597 | 317.5367994130852 | 547.4405279900927 | 326.3818247969736 | 373.260899383098 | 316.4808760195409 | 482.7461822095722 | 331.9564904429491 | 291.5738305370696 | 304.3660673273657 | 551.4645464989843 | 285.273835692723 | 4301.974803054051 | 0.002037448452266503
[PHONE]  [NAME] | 16.84076336371379 | 30.82294086497544 | 53.13943786206159 | 31.68151755549039 | 36.23201673052661 | 30.72044356583619 | 46.85963029967207 | 32.22264409536076 | 28.30274460481356 | 29.54447267805373 | 53.53004482405272 | 27.69121117342588 | 417.5878676179827 | 0.0001977728353870227
[PHONE]  Unins Disc - Contr Self - OP | 16.34468977911226 | 29.91499824784947 | 51.57412452948769 | 30.74828408857808 | 35.164740501494 | 29.81552018254765 | 45.4792994753611 | 31.27347081761214 | 27.46903869333311 | 28.67418953529885 | 51.95322549310924 | 26.87551902859367 | 405.2871003723773 | 0.0001919470971310809
[PHONE]  Out-of-Network Contr OP | 221.0559613526312 | 404.5894284877528 | 697.5212030855345 | 415.8593152273103 | 475.5902756384872 | 403.2440239768092 | 615.0909196219818 | 422.9622739769241 | 371.5087186021331 | 387.8079437049626 | 702.6484051980009 | 363.4815818473971 | 5481.360050719925 | 0.002596014403368051
[PHONE]  [NAME] | 12.68264838883255 | 23.21251791605575 | 40.01889887229677 | 23.85910536850525 | 27.2860510350543 | 23.13532799433349 | 35.28962445977665 | 24.26662357245013 | 21.31457764172395 | 22.24971343143406 | 40.31306194852868 | 20.85403655336583 | 314.4821871823574 | 0.0001489411897729398
[PHONE]  [NAME] | 207.4086044381224 | 379.6112451326275 | 654.4582575956339 | 390.1853615985415 | 446.2287049439323 | 378.3489020123058 | 577.1169818752234 | 396.8498041796166 | 348.5728427786929 | 363.865800775912 | 659.268921050769 | 341.0412782746355 | 5142.956704656012 | 0.002435743968220395
Revenue Deductions | 85152.0550370733 | 155850.2248534682 | 268689.265429566 | 160191.4514371636 | 183200.1683124176 | 155331.9671314779 | 236936.6359539328 | 162927.5528780487 | 143107.341053324 | 149385.8983223758 | 270664.2938060705 | 140015.2408152354 | 2122796.181073085 |  | 0.3158389790442088
[PHONE]  [NAME] | 3889.823965981791 | 7154.731312538303 | 12334.91643992999 | 7354.02720577421 | 8410.305355154404 | 7130.939272745127 | 10877.22504052176 | 7479.635434262732 | 6569.734339818826 | 6857.968702859912 | 12425.5855254691 | 6427.783011768061 | 96912.67560682422 |  | 0.03103510181490019
[PHONE]  Bad Debt Recoveries | -24.71517162671993 | -45.45974673376235 | -78.37361779870992 | -46.72603339580741 | -53.43741570405445 | -45.30857682170962 | -69.11173514534549 | -47.52412321991554 | -41.74279174857084 | -43.57417584553233 | -78.94971122348558 | -40.84086110438295 | -615.7639603679964 |  | -0.0001971908946307253
Bad Debts | 3865.108794355071 | 7109.27156580454 | 12256.54282213128 | 7307.301172378403 | 8356.867939450349 | 7085.630695923417 | 10808.11330537642 | 7432.111311042816 | 6527.991548070255 | 6814.394527014379 | 12346.63581424562 | 6386.942150663678 | 96296.91164645622 |  | 0.03083791092026946
Net Patient Revenue | 36319.10827689309 | 67577.24727213221 | 116504.6822766729 | 69459.61954709406 | 79436.28625486058 | 67352.52876266222 | 102736.6219762613 | 70646.00348594414 | 62051.88463417623 | 64774.29082564546 | 117361.0620547195 | 60711.13826967149 | 883679.6699080078 |  |  | 234995.9362186344
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07573739819078167
PCR
[PHONE]  Supp | 0 | 0 | 0 | 25.91333333333333 | 14.57666666666667 | 6.78 | 3.333333333333333 | 0 | 0 | 0 | 0 | 0 | 50.60333333333333
[PHONE]  Oth Serv Rev | 58.33333333333334 | 25 | 83.33333333333333 | 83.33333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 33.33333333333334 | 58.33333333333334 | 341.6666666666666
[PHONE] Interest Income | 0 | 0 | 0 | 0 | 0 | 0 | 0.13 | 0 | 0 | 0 | 0 | 0 | 0.13
Other Operating Revenue | 58.33333333333334
Net Revenue | 36377.44161022642 | 67577.24727213221 | 116504.6822766729 | 69459.61954709406 | 79436.28625486058 | 67352.52876266222 | 102736.6219762613 | 70646.00348594414 | 62051.88463417623 | 64774.29082564546 | 117361.0620547195 | 60711.13826967149 | 883679.6699080078
 |  |  |  |  |  | 436707.8057236484
Operating Expense
[PHONE] Prod Sal & Wag - Overtime | -46.75 | 0 | 0 | 40.36 | -40.36 | 0 | 0 | 0 | 0 | 0 | 0 | 46.75 | 0
[PHONE]  Aides & orderlies - Overtime | 205.5766666666667 | 161.25 | 159.1 | 62.35 | 92.45 | 143.6 | 74.62 | 0 | 0 | 0 | 0 | 108.38 | 1007.326666666667
[PHONE]  Cler & oth admin - Overtime | 0 | 63.7 | 50.96 | 63.7 | 54.6 | 34.58 | 0 | 0 | 0 | 0 | 0 | 0 | 267.54
[PHONE]  Prod Sal & wages | -403.1666666666667 | 227.62 | -5.733333333333333 | 368.66 | 234.1633333333333 | -414.46 | -420.3766666666667 | 55.25 | 147.3333333333333 | 46.75 | 154.4166666666667 | 49.58333333333334 | 40.03999999999993
[PHONE]  [NAME] Accrual | -10961.76 | 2435.946666666667 | 3044.933333333333 | 1826.96 | 608.9866666666667 | -3044.933333333333 | -4871.893333333333 | 1217.973333333333 | 1217.973333333333 | 608.9866666666667 | 1826.96 | 1217.973333333333 | -4871.893333333333
[PHONE]  Aides & orderlies - Reg pay | 1370.666666666667 | 837.0666666666666 | 917.3333333333334 | 809.8333333333334 | 914.4666666666667 | 1340.273333333333 | 776.5333333333333 | 0 | 0 | 0 | 0 | 888.25 | 7854.423333333334
[PHONE]  Cler & Admin | 970.8495143200004 | 1017.080443573334 | 1017.080443573334 | 1017.080443573334 | 970.8495143200004 | 2034.160887146667 | 970.8495143200004 | 1063.311372826667 | 970.8495143200004 | 1017.080443573334 | 1063.311372826667 | 924.618585066667 | 13037.12204944
[PHONE]  Cler & oth admin - Reg pay | 0 | 492.6133333333333 | 721.9333333333334 | 596.96 | 774.1066666666667 | 387.0533333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 2972.666666666667 |  |  | HR Rate
[PHONE]  [NAME] pay | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 49000 | 588000 |  | Pay increase | 282.6923076923077
Productive Labor | 40135.41618098666 | 54235.27711024 | 54905.60711024 | 53785.90377690666 | 52609.26284765334 | 49480.27422048 | 45529.73284765334 | 51336.53470616 | 51336.15618098667 | 50672.81711024 | 52044.68803949333 | 52235.55525173333 | 608307.2253827733
[PHONE]  Sick pay | 0 | 0 | 0 | 35.18666666666667 | 0 | 550.4 | 81.18333333333334 | 0 | 0 | 0 | 4.25 | 0 | 671.02
[PHONE]  PTO - Accrual Replen | 94.85000000000001 | -20.29333333333333 | 141.4066666666667 | -78.20333333333333 | 110.7366666666667 | -34.05333333333334 | -224.05 | 59.27333333333333 | -207.4566666666667 | 316.0866666666666 | 59.27333333333333 | 40.85666666666666 | 258.4266666666667
[PHONE]  PTO - PTO Taken | 0 | 157.92 | 9.706666666666667 | 188.94 | 0 | 259.4333333333333 | 423.6933333333333 | 0 | 7.083333333333333 | 2.833333333333333 | 0 | 18.41666666666667 | 1068.026666666667
Non-productive Labor | 94.85000000000001 | 137.6266666666667 | 186.3 | 110.7366666666667 | 110.7366666666667 | 775.7800000000001 | 280.8266666666667 | 59.27333333333333 | 59.27333333333335 | 59.27333333333331 | 63.52333333333333 | 59.27333333333333 | 1997.473333333333
Salaries & Wages | 40230.26618098666 | 54372.90377690666 | 55091.90711024 | 53896.64044357333 | 52719.99951432 | 50256.05422048 | 45810.55951432 | 51395.80803949333 | 51395.42951432 | 50732.09044357333 | 52108.21137282666 | 52294.82858506667 | 610304.6987161067
[PHONE]  Emp'ee Med Insur | 386.4419810172951 | 522.2926578383193 | 529.1992259241823 | 517.7177901207843 | 506.4152685416061 | 482.7472198096845 | 440.0448978036154 | 493.6954129364728 | 493.6917769173326 | 487.3199059624577 | 500.5385830556595 | 502.3311818136572 | 5862.435901741066 |  | 0.009605752526686799
[PHONE]  Health Benefits Allocation | 701.2318271913788 | 947.7444293719605 | 960.2769843126065 | 939.4429429747506 | 918.9335567067963 | 875.9858701882417 | 798.4988766509367 | 895.8522973567699 | 895.8456994909308 | 884.2833979507297 | 908.2698112972234 | 911.5226341380096 | 10637.88832763033 |  | 0.01743045457459066
[PHONE]  Oth Emp'ee Benefits | 34.98598048875031 | 47.28503018343442 | 47.91030659791748 | 46.87085097784461 | 45.84759310507972 | 43.7048396470781 | 39.83884506596191 | 44.69601889244002 | 44.69568971056811 | 44.11882134777471 | 45.31555566129938 | 45.47784606516898 | 530.7473777433177 |  | 0.0008696432763173001
[PHONE]  Payroll Tax - FICA | 1343.748526197071 | 1816.132883301782 | 1840.148624712762 | 1800.225005651427 | 1760.923512903796 | 1678.624210126811 | 1530.138318118406 | 1716.693620546235 | 1716.680977263153 | 1694.524501969782 | 1740.488912501747 | 1746.722194747069 | 20385.05128804004 |  | 0.03340143264655166
[PHONE]  Payroll Tax - fed unemploy | 13.02215542422294 | 17.59999301679569 | 17.83272757328804 | 17.4458310949823 | 17.06496359114061 | 16.26740787950748 | 14.82844342571186 | 16.63633537578037 | 16.63621285077352 | 16.42149628789119 | 16.86693357489906 | 16.92733979572026 | 197.5498398907133 |  | 0.0003236905111599131
[PHONE]  Payroll Tax - state unemploy | 49.50266583268274 | 66.90494350477128 | 67.78966501226672 | 66.31890948420838 | 64.87107261273839 | 61.83922937406207 | 56.36912291466202 | 63.2416772768504 | 63.24121150799169 | 62.42498393929482 | 64.11827759536274 | 64.34790693598364 | 750.969665990875 |  | 0.00123048317925568
[PHONE]  Pen, Retire,  ESOP (401k) | 540.8605744479007 | 730.9959083759888 | 740.6622763325702 | 724.5929663995104 | 708.7740631376763 | 675.6484839769713 | 615.8827143531267 | 690.971472458019 | 690.9663835197115 | 682.0483726558574 | 700.5491092146798 | 703.0580136340519 | 8205.010338506065 |  | 0.01344412120006102
[PHONE]  Workers' Excess Indemnity | 58.13250697310424 | 78.56853826765885 | 79.60749401556886 | 77.88034044611128 | 76.1801009618151 | 72.61971395539763 | 66.19599926153661 | 74.2666517741369 | 74.26610480740347 | 73.30758360393358 | 75.29607055939553 | 75.56573137503713 | 881.8868360010993 |  | 0.001444994341115705
Benefits | 3127.926217572407 | 4227.524383860712 | 4283.427304481162 | 4190.494637149618 | 4099.010131560648 | 3907.436974957755 | 3561.797217593958 | 3996.053486616704 | 3996.024056067864 | 3944.44906371772 | 4051.443253460267 | 4065.952848504697 | 47451.53957554351 |  | 0.07775057225573873
[PHONE]  [NAME] | 350.4050139836684 | 304.7812197207518 | 717.0049943781875 | 297.7125306778536 | 428.1757786092394 | 526.4616858705896 | 542.5048007445358 | 725.5314581753674 | 542.5048007445358 | 725.5314581753674 | 725.5314581753674 | 542.5048007445358 | 6428.65
[PHONE]  Drugs & pharm | 0 | 0 | 145.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 145.6
[PHONE]  Forms & Comp paper | 62.98899088666124 | 10.52366562311447 | 24.75717112049262 | 10.27959376084752 | 14.78430569353588 | 18.17797943901983 | 18.73192556680721 | 25.05157788883394 | 18.73192556680721 | 25.05157788883394 | 25.05157788883394 | 18.73192556680721 | 272.8622168905951
[PHONE]  Office & Dept. [NAME] | 83.65250063987686 | 91.02004754001582 | 29.84579383458876 | 12.39247548099814 | 17.82309204752262 | 21.91430612269339 | 22.58211109301674 | 66.85071337158503 | 22.58211109301674 | 30.20071337158503 | 30.20071337158503 | 22.58211109301674 | 451.6466890595009
Supplies W/O Implants | 497.0465055102064 | 406.3249328838821 | 917.207959333269 | 320.3845999196993 | 460.7831763502979 | 566.5539714323028 | 583.8188374043598 | 817.4337494357864 | 583.8188374043598 | 780.7837494357864 | 780.7837494357864 | 583.8188374043598 | 7298.758905950096
Supplies | 994.0930110204129 | 812.6498657677643 | 1834.415918666538 | 640.7691998393987 | 921.5663527005958 | 1133.107942864606 | 1167.63767480872 | 1634.867498871573 | 1167.63767480872 | 1561.567498871573 | 1561.567498871573 | 1167.63767480872 | 14597.51781190019
[PHONE]  Collect - Collect agency | 2628.270281195079 | 2421.227220807479 | 2919.390650144065 | 1719.430757983334 | 2372.612858577526 | 3139.333385100965 | 4257.568822495607 | 3249.828348457134 | 1152.568822495606 | 2538.401681790467 | 3237.405015123801 | 2952.398822495607 | 32588.43666666667
[PHONE]  [NAME] | 110.6666666666667 | 110.6666666666667 | 138.6666666666667 | 138.6666666666667 | 194 | 194 | 194 | 110.6666666666667 | 110.6666666666667 | 110.6666666666667 | 110.6666666666667 | 110.6666666666667 | 1634
[PHONE]  Outside Consultant Serv | 114.7222222222222 | 161.3888888888889 | 159.7222222222222 | 119.7222222222222 | 158.0555555555555 | 149.7222222222222 | 139.7222222222222 | 131.3888888888889 | 88.05555555555554 | 151.3888888888889 | 231.3888888888889 | 184.7222222222222 | 1790
[PHONE]  Transcription Serv | 304.9542606207211 | 846.8369031332724 | 1230.629548620495 | 846.3809382216153 | 602.2657843480089 | 926.33797816978 | 960.5432418915829 | 879.4195113084197 | 737.8232418915827 | 790.4561779750862 | 734.4261779750863 | 678.226575224916 | 9538.300339380567
Purchased Services | 3158.613430704689 | 3540.119679496307 | 4448.409087653449 | 2824.200585093838 | 3326.93419848109 | 4409.393585492967 | 5551.834286609412 | 4371.303415321109 | 2089.114286609411 | 3590.913415321108 | 4313.886748654442 | 3926.014286609411 | 45550.73700604723
[PHONE]  Repairs - Inhouse | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 33.33333333333332 | 399.9999999999998
[PHONE]  Cellular Phones & Pagers | 72.79333333333334 | 66.66666666666667 | 54.14000000000001 | 157.4566666666667 | 213.9633333333333 | 200.5433333333333 | 124.6033333333333 | 87.01666666666667 | 86.90666666666668 | 86.21999999999998 | 76.35000000000001 | 76.26 | 1302.92
[PHONE]  Oth Mkting Exp. | 138.8888888888889 | 242.7088888888889 | 138.8888888888889 | 340.9955555555555 | 243.7955555555555 | 436.9622222222222 | -10.14777777777781 | 138.8888888888889 | 138.8888888888889 | 138.8888888888889 | 234.1255555555555 | 138.8888888888889 | 2321.773333333333
[PHONE]  Malprac - Corporate Plan | 4222 | 4222 | 4222 | 4222 | 4222 | 4222 | 4222 | 2904.333333333333 | 2636 | 2635.666666666667 | 2635.666666666667 | 2635.666666666667 | 43001.33333333332
[PHONE]  Subscriptions | 52.77777777777776 | 52.77777777777776 | 152.7777777777777 | 702.7777777777778 | 52.77777777777776 | 669.4444444444445 | 236.1111111111111 | 52.77777777777776 | 52.77777777777776 | 52.77777777777776 | 52.77777777777776 | 52.77777777777776 | 2183.333333333333
[PHONE]  Oth Dues | 4.166666666666667 | 87.5 | 54.16666666666666 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 4.166666666666667 | 183.3333333333333
Tot Dues & Subscriptions | 4278.944444444444 | 4362.277777777777 | 4428.944444444444 | 4928.944444444444 | 4278.944444444444 | 4895.611111111111 | 4462.277777777778 | 2961.277777777778 | 2692.944444444444 | 2692.611111111111 | 2692.611111111111 | 2692.611111111111 | 45367.99999999999
[PHONE]  Licenses & Permits | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 180.5555555555555 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 333.3333333333334
[PHONE]  Outside Sem, Training | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 155.5555555555555 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 97.22222222222219 | 1225
Tot Oth Operating Exp | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 169.4444444444444 | 277.7777777777777 | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 111.1111111111111 | 1558.333333333333
[PHONE]  Business Meals & Entertain
[PHONE]  Travel & Lodging
[PHONE]  Airfare
Operating Expenses | 52145.96995139528 | 67769.29548380923 | 70424.57719881894 | 67123.9459767673 | 66006.99130817344 | 65550.2205015731 | 60813.00647110987 | 64729.6602180805 | 61711.38997625044 | 62891.18486592817 | 65182.63998492406 | 64506.63783943394 | 768855.5197762643
EBITDA - Direct Costs | -15768.52834116886 | -192.0482116770145 | 46080.10507785401 | 2335.673570326762 | 13429.29494668714 | 1802.308261089114 | 41923.61550515144 | 5916.343267863638 | 340.4946579257958 | 1883.105959717286 | 52178.42206979549 | -3795.499569762447 | 114824.1501317435
[PHONE] Prod. Clinical (Contra) | 360.5866666666666 | 190.6033333333333 | 563.1999999999999 | 528.2933333333334 | 390.96 | 784.7733333333334 | 0 | 0 | 128.47 | 156.5266666666667 | 125.9366666666667 | 92.55333333333334 | 3321.903333333333
[PHONE] Prod. Other [NAME] (Contra) | 2241.611998141112 | 1964.521131358965 | 2312.468300596588 | 2208.689847743704 | 1798.012972380327 | 1967.08498495389 | 1064.635414549859 | 1619.627746728377 | 1301.371894442695 | 1329.472963865382 | 1529.067789691886 | 1398.588913531184 | 20735.15395798397
[PHONE] Non-Prod. Clinical/Other Admin (Contra) | 1189.613107064072 | 993.4467506480468 | 2028.35235313106 | 862.2261284927644 | 1215.178800507079 | 1478.24237218709 | 1094.617919135862 | 1706.945435555635 | 1143.709257968422 | 1766.000032640722 | 1963.662124366831 | 1075.475006683212 | 16517.46928838079
[PHONE] Allocated Benefits (Contra) | 706.0746808569778 | 587.3074693747322 | 665.3016865650222 | 477.4738615118873 | 616.7852863629395 | 715.9712331285546 | 383.0943965673235 | 559.6970828251565 | 397.0742021674508 | 506.2043633163254 | 563.921221096403 | 394.7923768366313 | 6573.697860609405
[PHONE] Office Admin Supplies (Contra) | 3140.267287431945 | 1221.353411588687 | 2653.965035985848 | 1285.298698891018 | 1323.118605853338 | 1424.553878657657 | 1947.110596804752 | 2156.253313019364 | 1416.024732670837 | 1441.506858936607 | 507.2887233987064 | 1633.880276759169 | 20150.62141999793
[PHONE] Rent Expense (Contra) | 8183.255555555555 | 8626.025555555556 | 9104.445555555554 | 8057.672222222221 | 8500.16888888889 | 7807.045555555555 | 6041.302222222222 | 5387.702222222222 | 6080.018888888888 | 5686.385555555556 | 5900.798888888889 | 5948.174444444445 | 85322.99555555555
[PHONE] Other Purchased Services (Contra) | 349.3527777777778 | 293.4327777777777 | 894.6794444444445 | 299.2861111111111 | 451.8761111111111 | 307.8061111111111 | 128.8461111111111 | 174.0427777777778 | 171.7361111111111 | 135.8661111111111 | 559.3294444444444 | 119.4922222222222 | 3885.746111111111
[PHONE] Transcription Services (Contra) | 0 | 0 | 0 | 31.09 | -14.86 | 0 | 0 | 0 | 0 | 0 | 0.4966666666666666 | 0.4966666666666666 | 17.22333333333333
[PHONE] Maintenance Contracts (Contra) | 394.6811111111111 | 140.9411111111111 | -58.73222222222223 | 174.3544444444444 | 116.8744444444444 | 147.2277777777778 | 121.5211111111111 | 62.9311111111111 | 66.9611111111111 | 191.4811111111111 | 64.6011111111111 | 79.0688888888889 | 1501.911111111111
[PHONE] Utilities (Contra) | 196.3936111111111 | 125.8102777777778 | 113.7736111111111 | 287.5236111111111 | 83.45694444444443 | 254.0836111111111 | 119.2302777777778 | 118.9136111111111 | 119.0336111111111 | 102.1169444444444 | 151.9869444444444 | 115.7855555555556 | 1788.108611111111
[PHONE] Other Marketing Exp. (Contra) | 315.1588888888888 | 95.36555555555556 | 41.05888888888889 | 225.9322222222222 | 75.64555555555556 | 228.8688888888889 | 14.91888888888889 | 83.19222222222221 | 235.3288888888889 | 150.3255555555556 | 117.1688888888889 | 39.68777777777778 | 1622.652222222222
[PHONE] Malpractice - Corp/Oth (Contra) | 27.16666666666667 | -9.123333333333335 | 24.46666666666667 | 24.46666666666667 | 24.46666666666667 | 24.46666666666667 | -97.86666666666667 | 0 | 0 | 0 | 0 | 0 | 18.04333333333334
[PHONE] Insurance - Other (Contra) | 74.76555555555557 | 74.73555555555556 | 74.76555555555557 | 44.57222222222224 | 45.13888888888891 | 45.13888888888891 | 167.4722222222223 | 69.60555555555557 | 69.60555555555557 | 69.60555555555557 | 75.72222222222224 | 66.69444444444444 | 877.8222222222226
[PHONE] Other Misc. Operating (Contra) | 191.5372222222222 | 252.3372222222223 | 187.1738888888889 | 155.9205555555556 | 353.2105555555556 | 167.7172222222223 | 134.6605555555556 | 130.7738888888889 | 139.2905555555556 | 101.9038888888889 | 154.8972222222222 | 202.7044444444444 | 2172.127222222222
Practice Allocations | 17370.46512904966 | 14556.75681852599 | 18604.91876516741 | 14662.79992552826 | 14980.03372065924 | 15352.98052448275 | 11119.54304928002 | 12069.68496701742 | 11268.62480947163 | 11637.39560764792 | 11714.87791410938 | 11167.39435158797 | 164505.4755825276
EBITDA - Direct Costs incl. Practice Overhead | -33138.99347021851 | -14748.805030203 | 27475.1863126866 | -12327.1263552015 | -1550.738773972102 | -13550.67226339363 | 30804.07245587141 | -6153.341699153783 | -10928.13015154583 | -9754.289647930636 | 40463.5441556861 | -14962.89392135042 | -49681.32545078412
[PHONE] Other Misc. Oper. (Contra OH) | 6872.253401066962 | 6890.466867527909 | 8345.354887076606 | 6724.272302810253 | 6120.519184241271 | 5649.615545559437 | 2946.811034117867 | 3444.386030458304 | 3136.976895443284 | 3606.560361195156 | 4243.934077220943 | 4035.878480288517 | 62017.0290670065
EBITDA - Fully Allocated | -40011.24687128548 | -21639.27189773091 | 19129.83142560999 | -19051.39865801175 | -7671.257958213372 | -19200.28780895307 | 27857.26142175354 | -9597.727729612086 | -14065.10704698911 | -13360.85000912579 | 36219.61007846516 | -18998.77240163894 | -111698.3545177906
Total Physician FTEs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 10.33333333333333
Total Staff FTEs - Staff | 2.029059163278889 | 2.131640698967919 | 2.649152406917796 | 2.267800897063752 | 2.186036210079496 | 3.02455438092349 | 2.009998191729515 | 1.786933014051854 | 1.815739452803336 | 1.745197137942936 | 1.953266688863892 | 1.651458251710364 | 25.25083649433324
Total FTEs | 3.029059163278889 | 3.131640698967919 | 3.649152406917796 | 3.267800897063752 | 3.186036210079496 | 4.02455438092349 | 3.009998191729515 | 2.453599680718521 | 2.482406119470002 | 2.411863804609603 | 2.619933355530559 | 2.318124918377031 | 35.58416982766657
Key Statistics/Indicators
999580 Total Visits | 103 | 189.4526157574954 | 326.6205371821025 | 194.7298409437301 | 222.6993969795903 | 188.8226180711917 | 288.0218202601783 | 198.0558648582988 | 173.9622777069667 | 181.5945355296517 | 329.0213953937341 | 170.2034991820012 | 2566.184401864941
PCR (Includes Bad Debts) | 0.3206112356407017 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 | 0.3239679612110409 |  | Deductions/ Net Revenue Driver
Gross Revenue per Phys Visits | 1216.857010760403 | 1216.857010760403 | 1216.857010760403 | 1216.857010760403 | 1216.857010760403 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 | 1343.782236662836 |  | Fixed Calculation on Historical Averages
[NAME] | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272
Net Rev/WRVU | 83.54516520146261 | 77.70642622691693 | 71.47798690739934 | 73.9104093722754 | 55.67660467568477 | 39.28223120999168 | 85.36581013533673 | 102.6586482266013 | 30.50767163109865 | 64.66648328512207 | 92.11215601556538 | 79.50166912553803 | 73.0787250857255
SNIFF TEST Calculated Net Rev/WRVU | 63.83479449476209 | 64.57425485456106 | 64.57425485456108 | 64.57425485456106 | 64.57425485456108 | 64.57425485456105 | 64.57425485456105 | 64.57425485456103 | 64.57425485456105 | 64.57425485456103 | 64.57425485456106 | 64.57425485456105 | 62.33995939940064
[PHONE] Worked RVUs | 568.9547301648041 | 1046.504484245846 | 1804.197083482782 | 1075.654991351215 | 1230.154129285315 | 1043.024482657347 | 1590.984242987432 | 1094.027389786508 | 960.9384540934172 | 1003.097766618213 | 1817.459021696013 | 940.1755917495238 | 14175.17236811842 |  | Gross Revenue [NAME] on LTM Actual
VISIT Ratio | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677689 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677689
WRVU/Visit | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127 | 5.523832331697127
 | 63.93732169111115 | 64.57425485456106 | 64.57425485456108 | 64.57425485456106 | 64.57425485456108 | 64.57425485456105 | 64.57425485456105 | 64.57425485456103 | 64.57425485456105 | 64.57425485456103 | 64.57425485456106 | 64.57425485456105
 | 568.9547301648041 | 581.3913801365809 | 1002.33171304599 | 597.5861063062307 | 683.4189607140637 | 579.4580459207484 | 883.8801349930177 | 607.7929943258375 | 533.8546967185652 | 557.2765370101182 | 1009.699456497785 | 522.3197731941799 | 7559.009798863117 |  | Average Year over Year considering Budget
 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272 | 220.2921699447272
Growth Driver | 1.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3122679.480313343