Excel Spreadsheet

Business Plan

You must be logged in to download this document
Reviews
Shared by: user002
Stats
views:
1899
rating:
4(2)
reviews:
0
posted:
2/5/2008
language:
English
pages:
0
INSTRUCTIONS ON HOW TO COMPLETE THE BUSINESS AND OPERATIONAL PLAN FUNDING APPLICATION TEMPLATE Schedule 1 - Business Plan: 5 Year Financial Forecast The costs in this Schedule are derived from the individual Fiscal Year Summaries (Schedule 2's). Schedule 2 - Operational Plan: Summary Amounts in this Schedule are a roll-up of information from the other 3 Schedules (i.e., Schedules 3 to 5) If Excel is used the embedded formulas will automatically populate the columns in this worksheet. Schedule 3 - Operational Plan: Human Resources This Schedule captures information and related costs for interdisciplinary professionals who will be providing direct services to patients and for any administrative positions required to support them. The salary scales for the interdisciplinary positions represent the maximum amount of funding the ministry is prepared to provide. Staff should be remunerated at a level below the maximum so that the Family Health Team can retain flexibility in later periods to adjust for merit increases, raises, etc. Schedule 4 - Operational Plan: Other Overhead Costs These costs represent the annual, on-going costs associated with operations and will likely need to be pro-rated for the first fiscal year. Items listed in the attached template are samples of potential costs but the list is not inclusive nor is it meant to indicate that funding must be requested for each item listed. Schedule 5 - Operational Plan: Start Up/One-Time Costs This worksheet captures information on those one-time costs associated with getting your FHT up and running. Requirements will vary from FHT to FHT depending on individual circumstances. General The Operational Plan template (i.e., Schedules 2 to 5) can be used for separate fiscal periods by simply inserting the relevant time period in each worksheet heading. Then the total for each fiscal period can be used to enter into the Business Plan 5 Year Financial Forecast template. NOTE: Only the annual totals of the Ministry Funding Request column should be included in this worksheet, e.g. the Total Cost less Community Partner Contributions and Other Sources of Funding. 1 of 6 Ministry of Health and Long-Term Care Funding Application Template: Business Plan 5 Year Financial Forecast Schedule 1: Business Plan Year 1 Year 2 Year 3 1-Apr-07 to 31-Mar-08 Year 4 1-Apr-08 to 31-Mar-09 Year 5 1-Apr-09 to 31-Mar-10 [Insert start date] 1-Apr-06 to to 31-Mar-06 31-Mar-07 Human Resources Other Overhead Costs Sub Total Operating Start Up/One-Time Costs Total Costs $ $ $ $ $ $ $ $ $ $ Year 1 - Human Resources and Other Overhead Costs should be pro-rated to reflect actual time period of funding. 2 of 6 Ministry of Health and Long-Term Care Family Health Team Funding Application Template: Operational Plan For the Period [Insert start date to March 31, 2006 (1) (2) (3) (4) Schedule 2 - Operational Plan (Summary) Total Costs (2+3+4) Ministry Funding Request "M" Community Partner Contributions "C" Other Sources of Funding "O" Human Resources Other Overhead Costs Sub Total Operating One-Time Start Up Costs Total Costs Funding Component Legend: "M" = Funding components requested from Ministry "C" = Funding components provided by community partner contributions "O" = Funding components provided by other sources Column 1 - Total Financial requirements for the fiscal period Column 2 - Net request from Ministry (Col. 1 - (Col. 3 + Col. 4) Column 3 - Municipality, Hospital, CCAC, Private, etc. Column 4 - current MOHLTC, other provincial or federal funding [Schedule 2] [Schedule 3] $ [Schedule 4] $ $ $ $ $ $ $ dd184091-babe-4853-a7ce-f0e7cc020c6c.xls Sch 2 - OpPlan Summary 3 of 6 Ministry of Health and Long-Term Care Family Health Team Funding Application Template: Operational Plan For the Period [Insert start date] to March 31, 2006 Maximum Annual Method Salary of Per FTE 2 Remuneration 3 (1) (2) (3) (4) Schedule 3 - Operational Plan (Human Resources) Professional and Other Staff 4 (a) Non-Physician Personnel: 1) 2) 3) 4) 5) 6) 7) 8) Sub Total Non-Physician Personnel 5 (b) Physician Personnel: 1) 2) 3) 4) 5) 6) 7) 8) Sub Total Physician Personnel (c) Total Non-Physician & Physician Salaries (d) Benefits @ 20% (e) Total 1 2 3 4 5 Position Complement (FTE) 1 Total Costs (2+3+4) Ministry Funding Request "M" Community Partner Contributions "C" Other Sources of Funding "O" $ $ $ $ [to Schedule 1] $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Position Complement determined on basis of 40 hours per week Maximum Annual Salary per FTE - refer to Appendix A, "Salary Benchmarks for Interdisciplinary Health Care Providers" in the Guide to Interdisciplinary Provider Compensation regarding Ministry funding compensation levels per interdisciplinary position Non-Physician Personnel - health care providers other than Physicians and management and administrative staff Physician Personnel - complete this section only if physician providers are to be remunerated on a salaried basis Method of Remuneration - indentify basis of remuneration (salary, sessional or other) for each position Funding Component Legend: "M" = Funding components requested from Ministry "C" = Funding components provided by community partner contributions "O" = Funding components provided by other sources dd184091-babe-4853-a7ce-f0e7cc020c6c.xls Sched 3 - OpPlan HR Page 4 of 6 Ministry of Health and Long-Term Care Family Health Team Funding Application Template: Operational Plan For the Period [Insert start date] to March 31, 2006 (1) (2) (3) (4) Schedule 4 - Operational Plan (Other Overhead Costs) Total Costs (2+3+4) Ministry Funding Request "M" Community Partner Contributions "C" Other Sources of Funding "O" Equipment Lease(s) 1 Equipment Service Contract(s) 1 Legal Fees Audit Fees Liability Insurance 2 Maintenance of Premises Medical Supplies Office Supplies Staff Training and Development Rent Telephone Travel Other (please describe) Total Other Overhead Costs 1 2 [to Schedule 1] $ $ $ $ Equipment Lease and Service Contracts - please submit separate detailed listing in support of total annual cost. Insurance - do not include professional liability insurance premiums Funding Component Legend: "M" = Funding components requested from Ministry "C" = Funding components provided by community partner contributions "O" = Funding components provided by other sources dd184091-babe-4853-a7ce-f0e7cc020c6c.xls Sch 4 OpPlan Other Overhead Page 5 of 6 Ministry of Health and Long-Term Care Family Health Team Funding Application Template: Operational Plan Start-up/One-Time Costs For the Period [Insert start date] to March 31, 2006 (1) (2) (3) (4) Schedule 5 - Operational Plan (Start Up/One-Time Costs) Total Price 3 1 (a) Clinical Equipment: Ministry Funding Request "M" Community Partner Contributions "C" Other Sources of Funding "O" Qty/Area (sq. ft.) Costs (2+3+4) (b) Administrative Equipment/Furnishings (c) Leasehold Improvements/Renovations 2 (d) Other (please decribe) 4 Total Start Up/One-Time Costs 1 [to Schedule 1] $ $ $ $ Clinical equipment - provide a separate listing of requirements by provider type, e.g. Nurse Practitioner 2 Renovations/Leasehold Improvements - provide the renovated area in square feet in the Quantity column. 3 Shipping and applicable taxes should be included in the estimate 4 Practice Moving Costs - provide your transportation costs, and the address of the old and new practices. Funding Component Legend: "M" = Funding components requested from Ministry "C" = Funding components provided by community partner contributions "O" = Funding components provided by other sources dd184091-babe-4853-a7ce-f0e7cc020c6c.xls Sched 5 One-Time Start Up Page 6 of 6

Related docs
BUSINESS PLAN
Views: 87  |  Downloads: 8
BUSINESS PLAN
Views: 188  |  Downloads: 24
The Business Plan -
Views: 4  |  Downloads: 0
Business Plan
Views: 139  |  Downloads: 9
The Business Plan
Views: 45  |  Downloads: 4
Business Plan
Views: 49  |  Downloads: 7
Business Plan
Views: 53  |  Downloads: 3
Business Plan for an Established Business
Views: 2  |  Downloads: 1
Business Plan for Startup Business
Views: 17  |  Downloads: 1
Business Plan for a Startup Business
Views: 843  |  Downloads: 203
Writing a Business Plan
Views: 230  |  Downloads: 69
Business Plan for a Startup Business
Views: 1355  |  Downloads: 107
premium docs
Other docs by user002
meeting the digital challenge
Views: 930  |  Downloads: 79
Introduction to Data Mining
Views: 1861  |  Downloads: 309
Information Management Framework
Views: 1465  |  Downloads: 278
Information Management Framework metadata
Views: 819  |  Downloads: 99
Information Management Framework Data Quality
Views: 1044  |  Downloads: 183
Information Management Classification Guideline
Views: 897  |  Downloads: 110
Information Architecture
Views: 713  |  Downloads: 57
How to measure success
Views: 809  |  Downloads: 29
HelloPartner Data Model
Views: 587  |  Downloads: 19
Emotional Intelligence
Views: 630  |  Downloads: 29
Developing Strategies for Managing Your Files
Views: 377  |  Downloads: 16
Data Quality Framework
Views: 499  |  Downloads: 69
Data quality assessment guidelines
Views: 666  |  Downloads: 103
Categorization of Software for mobile work
Views: 694  |  Downloads: 45