valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 10976
Questions & Answers
Q: I downloaded a demo copy of your shift scheduler & have a few questions on how my situation will fit into your model. Your routine seems to allocate hours randomly. I have a staff of 18 24x7. Some full time, some part time, some with fixed schedules per their hire agreement. Our company policy actually dictates a mix of 40/60 FT/PT although that is seldom achievable. How can I fix or does it consider rotating weekends off or 2 days off during the week after 5 days work on a rotating shift? Which of these constraints can I input into your model & let excel figure out the rest?
A: The shift allocation is random so it does not consider different staff with different constraints or the allocation x days off ofter working y days. To address the Full time part time requirement you could run 2 separate rosters, 1 for full time and 1 for part time work with roster hours set accordingly. You can set a manual Yes or No work requirement by inputting a "Y" or "N" to mark a matrix cell before you Build Roster to allocate set days off but this would be required for all staff to ensure 2 days off. This cannot be incorporated automatically.
Question and Answer Item 10976 - Browse All Question and Answer Items