Apr-15 2015 2015 2016
DEPT CPSI # DESCRIPTION YTD-ACTUAL ANNUALIZED BUDGET BUDGET
086 33220086 CLINIC REVENUE - DR CARPENTER     439,892.66      754,101.70    558,255.00     1,029,000.00
086 33221086 HOSPITAL REVENUES -DR      20,564.00        35,252.57     62,001.00         35,250.00
086 43000086 REGULAR - SALARIES - DR     115,632.33      198,226.85    200,000.00        180,770.00 Per contract
086 43004086 REGULAR - PTO - DR CARP                  -                     -       25,384.00         19,230.00  Per contract - 25 days 
086 43006086 REG - EMP INS - DR CARP      16,224.37        27,813.21     27,643.00         27,643.00
086 43008086 REG - OTHER BEN TAX - DR CARP        5,576.48          9,559.68     11,175.00         11,175.00
086 43010086 REG - EMP SHARE - DR CARP                  -                     -                   -                       -  
086 43012086 CLER - SALARIES - DR CARP      51,961.49        89,076.84     88,657.00        249,131.14 Calculated using the allocation for all staff (see spreadsheet 501a Clerical Salary Allocations - FY 2016) + 2%, and then split with PTO
086 43014086 CLER - OT/CALLBACK - DR CARP                  -                     -                   -                       -  
086 43016086 CLER - PTO - DR CARP        5,840.66        10,012.56     13,405.00         30,187.73 Calculated using the allocation for all staff (see spreadsheet 501a Clerical Salary Allocations - FY 2016) + 2%, and then split with Clerical Salaries
086 43018086 CLER - HEALTH INS - DR CARP      24,351.02        41,744.61     34,174.00         51,226.56 Used jun health exp spreadsheet 
086 43020086 CLER - PAYROLL TAX - DR CARP        5,909.78        10,131.05       9,702.00         16,328.52 Used jun payroll tax exp spreadsheet 
086 43022086 CLER - EMPLR SHARE - DR CARP        2,190.79          3,755.64       5,601.00           6,627.36 Used GL account detail for June x 12
086 43190086 NATURAL GAS - DR CARP                  -                     -                   -    
086 43200086 ELECTRICITY - DR CARPENTER        1,969.76          3,376.73       1,800.00           3,375.00
086 43220086 WATER - DR CARP                  -                     -                   -    
086 43290086 PATIENT NON CHARGE - DR CARP                  -                     -            500.00                     -  
086 43300086 PT CHARGEABLES - DR CARPENTER                  -                     -            200.00                     -  
086 43330086 DRUGS - DR CARPENTER      26,909.53        46,130.62     40,422.00         46,150.00
086 43480086 GENERAL SUPPLIES - DR CARP           325.85             558.60          900.00              575.00
086 43500086 COLLECTION FEES - DR CARP                  -                     -            500.00                     -  
086 43510086 DUES & SUBSCRIPT - DR CARP        1,453.50          2,491.71       2,000.00           2,500.00 Per contract
086 43520086 LICENSES FEES - DR CARPENTER                  -                     -         5,000.00                     -  
086 43530086 EDUCATIONAL FEES - DR CARP        1,255.00          2,151.43       2,500.00           2,500.00 Per contract (includes tuition, lodging, meals & travel expenses) the CME amount is $5,000, split between education and travel
086 43540086 TRAVEL EXPENSE - DR CARP        2,059.80          3,531.09       2,500.00           2,500.00
086 43550086 TELEPHONE - DR CARPENTER           922.90          1,582.11       2,952.00           1,600.00
086 43560086 POSTAGE - DR CARPENTER             22.25              38.14            90.00                50.00
086 43570086 AUDIT - DR CARPENTER                  -                     -                   -    
086 43580086 LEGAL - DR CARPENTER                  -                     -                   -    
086 43610086 CABLE TV/INTERNET - DR CARPENTER           164.70             282.34                 -                300.00
086 43620086 ADVERTISING (HELP) - DR CARPENTER                  -                     -                   -    
086 43640086 PUBLIC RELATIONS - DR CARP           873.57          1,497.55       2,500.00           1,500.00
086 43650086 INSURANCE - DR CARPENTER        4,647.23          7,966.68       6,850.00           8,000.00
086 43680086 RENT - BUILDING - DR CARP        8,803.69        15,092.04     17,074.00         20,000.00 Updated to reflect Pecan addition
086 43690086 RENT - EQUIPMENT - DR CARP           592.55          1,015.80       1,000.00           1,000.00
086 43720086 EQUIPMENT REPAIRS - DR CARP                  -                     -            250.00              250.00
086 43730086 MINOR EQUIP PURCH - DR CARP           182.98             313.68       1,000.00              500.00
086 43790086 PURCH SERVICES - DR CARP      26,426.49        45,302.55     51,485.00         45,500.00
086 53112086 DISC & ALLOW- MANAGE- DR CARP     246,832.91      423,142.13    282,268.00        490,945.00
086 53156086 LUMINANT REVENUE        8,843.00        15,159.43     58,380.00         25,500.00 Annualized through June
    (81,829.97)     (140,279.95)   (158,896.00)       (129,814.31)
tied to financials       235,317.00 INCREASE IN NET REVENUE
Blue font requires NO input of data       146,604.31 INCREASE IN EXPENSE
       (32,880.00) DECREASE IN OTH REVENUE