A 1 Revenue 2 3 4 5 Total Revenue B C Actual D E F Budgeted...

Transcribed Image Text:

A 1 Revenue 2 3 4 5 Total Revenue B C Actual D E F Budgeted Variance insurance revenue $411,905 $465,222 supplemental income $26,502 $25,589 other operating income $5,682 $5,485 $444,089 $496,296 6 7 Operating Expenses 8 Staffing RN salary $148,999 $140,852 9 RT salary $37,459 $36,582 10 PT/OT/ST salary $26,212 $27,414 11 administrative salary $55,219 $56,211 12 management salary $25,145 $24,318 13 housekeeping salary $10,555 $10,555 14 dietary salary $5,500 $5,469 15 Benefits health insurance $6,182 $6,028 16 17 18 life insurance $464 $452 dental insurance $309 $301 403b contributions $12,364 $12,056 19 20 Taxes 21 education $93 $90 payroll $9,273 $9,042 workers comp $77 $75 22 FICA $7,727 $7,535 23 Medicare $6,800 $6,631 24 Social Security $3,709 $3,617 25 Administrative office supplies $510 $500 26 postage $148 $150 27 telephone $355 $350 28 marketing $1,700 $1,500 29 legal fees $600 $100 30 accounting $207 $200 31 travel $56 $50 32 liability insurance $215 $215 33 malpractice insurance $2,658 $1,540 34 mortgage $3,500 $3,500 35 property taxes $105 $105 36 Medical Supplies general medical $1,450 $1,400 37 38 39 40 41 Dietary 42 pharmacy $7,500 $4,800 Oxygen & RT $1,190 $1,200 X-ray $575 $600 lab $480 $500 food $1,545 $1,500 enteral feedings $4,700 $3,600 43 Maintenance housekeeping supplies $145 $150 44 laundry $95 $100 45 groundskeeping $0 $0 46 snow removal $380 $320 47 Utilities electric $362 $368 48 water $590 $588 49 sewer $240 $231 50 garbage disposal $152 $152 51 shredding $46 $47 52 fuel $199 $56 53 cable TV $189 $189 54 internet service $205 $205 55 Total Operating Expenses $386,183 $371,445 56 Bad Debt Expense $26,210 $26,523 57 Total Expenses $412,393 $397,968 58 59 Net Income $31,696 $98,328 60 A 1 Revenue 2 3 4 5 Total Revenue B C Actual D E F Budgeted Variance insurance revenue $411,905 $465,222 supplemental income $26,502 $25,589 other operating income $5,682 $5,485 $444,089 $496,296 6 7 Operating Expenses 8 Staffing RN salary $148,999 $140,852 9 RT salary $37,459 $36,582 10 PT/OT/ST salary $26,212 $27,414 11 administrative salary $55,219 $56,211 12 management salary $25,145 $24,318 13 housekeeping salary $10,555 $10,555 14 dietary salary $5,500 $5,469 15 Benefits health insurance $6,182 $6,028 16 17 18 life insurance $464 $452 dental insurance $309 $301 403b contributions $12,364 $12,056 19 20 Taxes 21 education $93 $90 payroll $9,273 $9,042 workers comp $77 $75 22 FICA $7,727 $7,535 23 Medicare $6,800 $6,631 24 Social Security $3,709 $3,617 25 Administrative office supplies $510 $500 26 postage $148 $150 27 telephone $355 $350 28 marketing $1,700 $1,500 29 legal fees $600 $100 30 accounting $207 $200 31 travel $56 $50 32 liability insurance $215 $215 33 malpractice insurance $2,658 $1,540 34 mortgage $3,500 $3,500 35 property taxes $105 $105 36 Medical Supplies general medical $1,450 $1,400 37 38 39 40 41 Dietary 42 pharmacy $7,500 $4,800 Oxygen & RT $1,190 $1,200 X-ray $575 $600 lab $480 $500 food $1,545 $1,500 enteral feedings $4,700 $3,600 43 Maintenance housekeeping supplies $145 $150 44 laundry $95 $100 45 groundskeeping $0 $0 46 snow removal $380 $320 47 Utilities electric $362 $368 48 water $590 $588 49 sewer $240 $231 50 garbage disposal $152 $152 51 shredding $46 $47 52 fuel $199 $56 53 cable TV $189 $189 54 internet service $205 $205 55 Total Operating Expenses $386,183 $371,445 56 Bad Debt Expense $26,210 $26,523 57 Total Expenses $412,393 $397,968 58 59 Net Income $31,696 $98,328 60