| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating staff levels
Thanks everyone for the help, much appreciated.
"Martin Brown" wrote: William wrote: Peter, I noticed you said unlimited number of people can work 8 hours. What if the maximum number of people I have is 10 (which can be a max of 4 on the 11 hour shift, so 6 would be available for the 8 hour. If I go 3 on 11, 7 available for 8 hour shift, etc.) How would I change your formulas to reflect this?? My main goal is to tell me what my staffing level should be based on the hours of work needed and the two shifts. However, it would benefit me to know with the staff I have (10) what can be done and what is left over for them to do other things. In some ways having a fixed number of staff to employ makes it easier. It is obvious that with them all on shift 1 you get 10x8 = 80 (and can close shift 2 - saving heat/light costs) It is also obvious that for each one you move to the 11 hour shift #2 you get an extra 3 hours work from the poor devil. So for N people on shift #2 you get total man hours 80+3N. So the maximum range of outputs is 80, 83, 86, 89, 92 with 10 employed and a maximum of 4 allowed to move shifts. Algebraically it is easier. N employees N-M on shift 1 working P hours = (N-M)*P M on shift 2 working Q hours = M*Q TOTAL = (N-M)*P+M*Q = N*P + M*(Q-P) Regards, Martin Brown |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS | Excel Worksheet Functions | |||
| Calculating what staff worked on which product | Excel Worksheet Functions | |||
| Staff Levels | Excel Discussion (Misc queries) | |||
| new staff | Excel Worksheet Functions | |||
| how many staff have 1 skill, how many staff have 2 skills, etc. | Excel Discussion (Misc queries) | |||
Hybrid Mode
