CopyofBUDGETSPREADSHEET.xlsx

Sheet1

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