To address such a shortcoming we introduce the first Markov Decision Process model for scheduling surgical patients on a daily basis, explicitly taking into account patient length‐of‐stay in hospital after surgeries and inpatient census. For example, if you have two project managers, then the usual availability would be 10 days, but if one of them is going on leave, it will reduce to 5 days a week.Despite the fact that hospital care is often delivered in successive stages, current healthcare scheduling and capacity planning methods usually treat different hospital units in isolation.
For example, if you have two project managers who are full time then the total availability will be 10 days if you have a DBA who is part-time, then it 2.5.
Highlights which resource types are in high demand or free resource types.Provides flexibility in setting up working days for resources every week.Based on weekly planning so allows planning up to one year. Allows planning for resources across multiple projects.The capacity planner will highlight resource gaps weekly, which makes the job of the resource manager easy.Using the planning capacity XLS tool, a portfolio manager or a resource manager will be able to pinpoint where there is a shortage of resources and also be able to tell what type of resources.
Check out our Agile Sprint Based Capacity planner.įeatures about our Excel Capacity Planner Human resource is the biggest expense, and knowing what resourcing is required to help the company or business plan for an adequate budget.Ĭapacity planning should be part of any project manager's tasks, whether it is waterfall or agile project management.
One of the major drivers for capacity planning is to get an understanding of the financial budget required. So everyone must know what the assumptions are and how they could affect the plan later. The majority of the time, capacity planning is done on assumptions that may not always be correct. Using dashboards can always help in making the presentation easy. The data must be presented straightforwardly. Often, the company's senior management or business set their expectation based on what is presented to them.
One of the key points which a capacity planner should highlight is the assumptions that have been made when doing the capacity planning.