|
| HIM445 |
Project Management |
|
| Resource information and format |
|
| Patient visits |
| Year 1 |
Year 2 |
Year 3 |
|
| Option 1 |
Primary Care Clinic |
7500 |
Assume 10% increase over Year 1 |
Assume 10% increase over Year 2 |
|
| Option 2 |
Surgical Care clinic |
8000 |
Assume 10% increase over Year 1 |
Assume 10% increase over Year 2 |
|
| Option 3 |
Dermatology Clinic |
7000 |
Assume 10% increase over Year 1 |
Assume 10% increase over Year 2 |
|
| Staffing |
| Year 1 |
Year 2 |
Year 3 |
|
| Option 1 |
Physician |
2 |
2 |
3 |
|
|
| ARNP or Physician assistant |
0 |
0 |
0 |
|
|
| Office Manager |
1 |
1 |
1 |
|
|
| Sr. LPN |
2 |
2 |
3 |
|
|
| Receptionist |
1 |
2 |
2 |
|
|
| Medical Assistant |
1 |
2 |
2 |
|
|
|
| Year 1 |
Year 2 |
Year 3 |
|
| Option 2 |
Physician |
1 |
1 |
2 |
|
|
| ARNP or Physician assistant |
1 |
1 |
2 |
|
|
| Office Manager |
1 |
1 |
1 |
|
|
| Sr. LPN |
2 |
2 |
3 |
|
|
| Receptionist |
2 |
2 |
3 |
|
|
| Medical Assistant |
2 |
2 |
2 |
|
|
|
| Year 1 |
Year 2 |
Year 3 |
|
| Option 3 |
Physician |
1 |
1 |
2 |
|
|
| ARNP or Physician assistant |
1 |
1 |
1 |
|
|
| Office Manager |
1 |
1 |
1 |
|
|
| Sr. LPN |
2 |
2 |
2 |
|
|
| Receptionist |
1 |
2 |
2 |
|
|
| Medical Assistant |
2 |
2 |
2 |
|
| Average expense per category in Year 1 |
|
|
| § Central Sterile Supply |
$20 per month |
|
|
| § Dietary |
$50 per month |
|
|
| § Depreciation |
$540 per month |
|
|
| § Hazardous waste disposal |
$150 per month |
|
|
| § Insurance |
$400 per month |
|
|
| § Maint/Housekeeping |
$600 per month |
|
|
| § Laundry/Linen |
$100 per month |
|
|
| § Miscellaneous (Define what is included in this category) |
$600 per month |
|
|
| § Office supplies |
$120 per month |
|
|
| § Rent |
Students should identify a property in their local area that is approximately 3,000 sq feet for a medical office |
|
|
| § Repair of Equipment |
$30 per month |
|
|
| § Staff Development |
$200 per month |
|
|
| § Telephone/Internet |
$120 per month |
|
|
| § Utilities |
$200 per month |
|
| Assumptions: |
Average charge is $120 |
|
|
| Contractual adjustment is 30% |
|
|
| Expenses increase by 5% in year |
|
|
| Initial capital costs for furniture, equipment, supplies and contingency is : |
|
|
| Option 1 Primary Care Clinic |
$310,245 |
|
|
| Option 2 Surgical Care Clinic |
$345,345 |
|
|
| Option 3 Dermatology Clinic |
$275,000 |
|
| Proforma Format |
|
| Revenue |
| Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
| Gross Revenue |
[# of visits X average charge] |
|
| Contractual Adjustment |
[.30 X average charge] |
|
| Net Revenue |
[Gross revenue - Contractual adjustment] |
0 |
0 |
0 |
0 |
0 |
|
| Operating Expenses |
|
| Salaries |
|
| Physician |
Students should use nationally available average salaries for each position. Remember to multiply the average salary by the number of ftes. |
|
| ARNP or Physician assistant |
|
| Office Manager |
|
| Sr. LPN |
|
| Receptionist |
|
| Medical Assistant |
|
| Total Salaries |
| 0 |
0 |
0 |
0 |
0 |
|
| Benefits |
[Calculated at 30% of salary] |
|
| Total Salary & Benefits |
[Add Salary & Benefits] |
0 |
0 |
0 |
0 |
0 |
|
| Other expenses |
|
|
| § Central Sterile Supply |
|
|
| § Dietary |
|
|
| § Depreciation |
|
|
| § Hazardous waste disposal |
|
|
| § Insurance |
|
|
| § Maint/Housekeeping |
|
|
| § Laundry/Linen |
|
|
| § Miscellaneous (Define what is included in this category) |
|
|
| § Office supplies |
|
|
| § Rent |
|
|
| § Repair of Equipment |
|
|
| § Staff Development |
|
|
| § Telephone/Internet |
|
|
| § Utilities |
|
| Total Other Expenses |
| 0 |
0 |
0 |
0 |
0 |
|
| Total Expenses |
| 0 |
0 |
0 |
0 |
0 |
|
| Net Income |
Revenue minus expenses |
0 |
0 |
0 |
0 |
0 |
|
| Note: Some formulas were pre-populated to assist you in preparing the proforma |
taylorc1993
HIM445-FinalProjectAssumptionsTemplate1.xlsx
