![]() ![]() With the data from Steps 2 and 3, nice visualizations can be created to let you quickly determine where you are over or under staffed. Here is where Excel does a really great job. Step 4: Comparing Allocated vs Needed Staff That limit will be part of the logic that you will need to provide us, if we automate this process. At some point there is a limit to how much a single person can work before you will have to assign another resource to fill the need. Unless, of course, you like to work your people at, say, 120% FTE. Either way, a single person can only work up to one FTE per day. Alternatively, you can provide us with logic so we can have fun developing an algorithm for use in assigning people automatically. For each project, location or business unit, you get to pick who you want on the job and when. Step 3: Allocating Human Resources to various Projects, Locations and Business Units If your firm is small, an interface can be provided to enter this information directly into Excel. ![]() If your firm is large and this information is stored in a separate database, it can be pulled into Excel with a data connection or an export/import procedure. ![]() With PTO, holidays, conferences, training and other demands that pull people off the job, it’s important to have the availability of your resources at your disposal. Step 2: Forecasting Human Resource Availability Aggregate data is then fed into the subsequent steps. Then, these separate models can be aggregated using native Excel functionality or VBA code, depending on the complexity. Models can be developed for individual projects, locations or business units. Our team can help get the customized Excel solutions for forecasting, scheduling, and analyzing your staffing needs.Įxcel is great for developing forecasts, whether they are based on simple counts and ratios or more complex models.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |