|
|
| Massachusetts General Hospital Projected Budget | | | | | | | | | | Strategies to Increase Volume |
| Research and Development Productivity | | | | | | | | | | Purchase and install new Research Freezer Dryers. |
| | | | | Purchase & Install | | Hire & Train | | Increase | | Hire and Train additional staff to operate Freeze Dryers |
| | | | | Research Freeze Dryer | | Employee | | Marketing to Doctors & Nurses | | Increase marketing to doctors and nurses |
| Revenue | | | | Year 1 | | Year 2 |
| | | | | | | | | | | | Assumptions |
| In patients | | | | $3,500,000 | | $3,885,000 | | $4,312,350 | | | Increase in revenue/year | | | | 11.00% |
| Nursing home | | | | $9,000,000 | | $9,990,000 | | $11,088,900 | | | Increase in salaries/year | | | | 5.00% |
| Freeze Dryers | | | | $10,000,000 | | $11,100,000 | | $12,321,000 | | | Increase in supplies expense/year | | | | 4.00% |
| Outpatient | | | | $8,000,000 | | $8,880,000 | | $9,856,800 | | | Travel as a % of revenue | | | | 0.60% |
| | | | | | | | | | | | Maintenace as a % of revenue | | | | 2.00% |
| Total Revenue | | | | $30,500,000 | | $33,855,000 | | $37,579,050 | | | Contracts as a % of revenue | | | | 1.00% |
| | | | | | | | | | | | Marketing as a % of revenue | | | | 0.60% |
| | | | | | | | | | | | Miscellaneous as a % of revenue | | | | 1.50% |
| Expenses | | | | | | | | | | | Salaries as a % of revenue | | | | 70.00% |
| Salaries | | | | $21,350,000.00 | | $23,698,500.00 | | $26,305,335.00 |
| Supplies | | | | $1,220,000.00 | | $1,354,200.00 | | $1,503,162.00 |
| Travel | | | | $183,000.00 | | $203,130.00 | | $225,474.30 |
| Maintenance | | | | $610,000.00 | | $677,100.00 | | $751,581.00 |
| Contract | | | | $305,000.00 | | $338,550.00 | | $375,790.50 |
| Marketing | | | | $183,000.00 | | $203,130.00 | | $225,474.30 |
| Miscellaneous | | | | $457,500.00 | | $507,825.00 | | $563,685.75 |
| Total Expenses | | | | $24,308,500.00 | | $26,982,435.00 | | $29,950,502.85 |
| Net Profit | | | | $6,191,500.00 | | $6,872,565.00 | | $7,628,547.15 |
| Capital Outlay | | | | $4,000,000 | | $0 | | $0 |
preiou5
projected_budget_4.xls
