As a project manager, you have been asked to develop a ‘business plan’ for a newly built project for older people in a local authority of your choice

Portfolio of Task:

This assignment has two parts:

Part 1: Financial Data Development using excel

Part 2: The report Background:

As a project manager, you have been asked to develop a ‘business plan’ for a newly built project for older people in a local authority of your choice. Your project brief provides you with some financial data shown below:

a. You have an annual capital funds provided by your sponsors of £1.5 million.

b. Your project has a capacity for 50 residents of which a third of these are for high support needs whilst the 2/3rd are for low/medium support needs.

c. The weekly revenue for the higher support needs is twice the low / medium support residents.

d. You have been asked to make appropriate financial assumptions, such as weekly charges, occupancy rates of between 75 – 85% and any other investment that needed to be made.

e. The project will be for an initial three years; hence you will provide a cash-flow, and projected income and expenditure as part of the business plan.

Task

Your business plan will show a degree of research and your findings has to reflect on the strategic commissioning work of the social services of the Local Authority. Some of your report must present your findings about the viability, demand and opportunity for collaboration to make your new service a quality public sector engagement with the sponsors and stakeholders. You are to use a simple data management tool (an Excel application) to accomplish your tasks and your report must show the financials and the explanation of your calculations