[go: up one dir, main page]
Scribd
Upload
74 views4 pages

Rosemont - Hill Center

The document shows the cost breakdown of various departments within a healthcare organization. It includes expenses like utilities, rent, salaries, and other costs. It then calculates the total cost for each department by distributing shared costs like utilities, administration, and recordkeeping across departments based on factors like floor space, salaries, patient visits, and lab usage. The total costs per patient are also calculated for each clinical department.

Uploaded by

Hardeep Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
74 views4 pages

Rosemont - Hill Center

The document shows the cost breakdown of various departments within a healthcare organization. It includes expenses like utilities, rent, salaries, and other costs. It then calculates the total cost for each department by distributing shared costs like utilities, administration, and recordkeeping across departments based on factors like floor space, salaries, patient visits, and lab usage. The total costs per patient are also calculated for each clinical department.

Uploaded by

Hardeep Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Cost Heirarchy

Cleaning 6000
Utility 10000
Utilities
Rent 36000 52000 5.2

Admin 40000 2600 42600

Cost Centre
Recordkeeping 10000 1560 1684.75

Lab 25000 6240 3850.85

Nursing 1560 6498.31


Social Services 2600 7701.69
Pediatrics 5200 4813.56
Family Planning 6760 1203.39
Revenue Centre
Adult Medicine 9360 7220.34
Mental Health 5200 3610.17
Community Health 5720 1203.39
Dental 5200 4813.56

Floor Space Salary Others Total


Nursing 300 27000 6000 33000
Social Services 500 32000 8000 40000
Pediatrics 1000 20000 8000 28000
Family Planning 1300 5000 15000 20000
Adult Medicine 1800 30000 16000 46000
Mental Health 1000 15000 8000 23000
Community Health 1100 5000 10000 15000
Dental 1000 20000 10000 30000
Admin 500 38000 2000 40000
Recordkeeping 300 7000 3000 10000
Lab 1200 16000 9000 25000
Multiplying factor as Utlities are distributed
basis floor space

Multiplying factor as admin is distributed basis


0.24
salary

13244.75
0.40

35090.85
8.77

1610.30 877.27
603.86 0.00
2012.88 8772.71
4025.76 1754.54
845.41 21054.51
563.61 0.00
1006.44 877.27
2576.49 1754.54

Patient Visit Lab Usage

4000 100
1500
5000 1000
10000 200
2100 2400
1400
2500 100
6400 200
multiplying factor as recordkeeping is divided
basis patient visit
multiplying factor as lab is divided basis hourly
usage
MSW BSW
33000 43545.88 14515.29 2727.08 1818.06
40000 50905.56 19089.58 1818.06 MSW 38179.17
7257.65 2727.08 1818.06
7257.65 2727.08 1818.06
14515.29 2727.08 1818.06
2727.08 1818.06
2727.08 1818.06
2727.08
Total Cost per patient
19060.43 4.77
BSW 12726.39 20907.64 13.94
60601.94 12.12
45546.48 4.55
103540.7 49.31
36918.91 26.37
28352.24 11.34
47071.67 7.35

You might also like