I have a very specific need and I’m looking for a program (commercial off the shelf or something I can customize) to track this. I’ll tell you a bit about what I need. Anyone with any good ideas, please share. I’m frustrated as all get out with this. I’m currently using excel and it doesn’t work well. It’s a messy spreadsheet with multiple sheets and complicated formulas that are easy to break. I also needs some sections locked (so those inputting data don’t break it). Other sections stay open so locking and unlocking it when I want to make changes is a pain. Here is what I need. I’m willing to learn any program that will help me. It needs to be centrally stored in the cloud so multiple people can access and update it in real time. I need to protect certain parts so that only I can update them.I need to track supply and demand for a deployed workforce. The workforce spans multiple locations so I need to view supply and demand locally for each office, but also globally in aggregate.

Advertisement

Demand:Employees are deployed out to different types of projects. These projects live in different departments (that span the regions). There is a model that says how much resource each project demands based on what type of project it is. There are 5-6 different types of projects with demand that varies from 20% of an FTE (full time employee) to several FTEs. The number and type of active project changes over time, but it adds up to our total demand. We need to view the demand by location and in aggregate globally.

Supply:Supply is the real life allocation of staff which may or may not match the demand. We need to compare supply to demand. Sometimes we don’t have the employees available for the supply so it’s a gap. Sometimes we supply less (that’s great because we use those people on something else). Sometimes we supply more than the model dictates because a project requires more supply than the model dictates. Our supply is always less than our demand once all added up.Our supply is FTEs. If the demand is .5 FTE, then one person meets that demand, but they spend the rest of their time on other work (obviously). If the demand is for multiple FTEs it is spread across people. This can be done in many ways. Demand of 2 FTEs might be met by 4 people allocated at 50%. Occasionally, demand is met by staff in a different location providing remote support (rare, but happens). Also, people are not tied to a department and may support projects in different departments.

Advertisement

So there are multiple project with supply that may or may not match the demand generated by the model. There are tons of people, most of whom support more than one project. There are multiple regions and we need to view supply and demand by region and globally (all staff come from one global budget). There is occasional cross regional support. We need to view by person (what are they supporting); by project (who supports a project); by region (supply and demand for a region) and globally (totally supply vs demand). We also need to view by department (how many projects are in that department and who supports that department on a global level).