| strategic plan implementation budget plan | | | | | | Date 10/08/2109 |
| STRATEGIC PLAN IMPLEMENTATION BUDGET SPEADSHEET | | | | | | | | | | | | volume increase strageties |
| | | | purchase and installation | | | employe & Train s | and train staff | | | | | training/hiring of support staff for the operation of new MRI |
| Revanue | | | | First Year | | Second year | | | Third Year | | | Purchasing and installation of new MRI |
| | | | | | | | | | | | | Marketing to physicians to be increased |
| ICT | | | | $3,000,000 | | $3,100,000 | | | $3,200,000 |
| Basic Diagnostics | | | | $5,000,000 | | $5,500,000 | | | $6,000,000 | | | key Assumptions under consideration |
| MRIs | | | | $9,000,000 | | $8,000,000 | | | $8,500,000 | | | Annual increase in revenue | | | | 12.00% |
| interventional capital | | | | $13,000,000 | | $13,900,000 | | | $14,000,000 | | | annual increase in salaries/wages | | | | 4.56% |
| | | | | | | | | | | | | annual increase in expenses (supply) | | | | 4.50% |
| Revenue in Total | in Total | | | $30,000,000 | | $30,500,000 | | | $31,700,000 | | | travel % factor of revenue | | | | 0.67% |
| | | | | | | | | | | | | maintenace % | | | | 1.20% |
| Expenses | | | | | | | | | | | | contracts as % of annual revenue | | | | 1.90% |
| | | | | | | | | | | | | marketing %in relation to revenue | | | | 0.45% |
| supplies | | | | $3,800,000 | | $4,000,000 | | | $4,500,000 | | | misc % in relation to revenue | | | | 2.00% |
| salaries | | | | $17,500,000 | | $18,000,000 | | | $19,000,000 | | | salaries as % fraction of revenue | | | | 50.00% |
| maintenaces | | | | $250,000 | | $300,000 | | | $350,000 |
| contracts | | | | $540,000 | | $600,000 | | | $650,000 |
| Travels | | | | $150,000 | | $200,000 | | | $205,000 |
| marketing | | | | $150,000 | | $190,000 | | | $200,000 |
| Miscellenious | | | | $300,000 | | $300,000 | | | $310,000 |
| Expenses in Total | | | | $22,690,000 | | $23,590,000 | | | $25,215,000 |
| Net Profit | | | | $5,500,000 | | $5,700,000 | | | $5,900,000 |
| Capital Out lay | | | | $1,810,000 | | $1,210,000 | | | $585,000 |
carribgtonsherman
CopyofBUDGETSPREADSHEET.xlsx
