Christopher HealySR IT Program Manager| General MotorsBerkley, Mi, United States
Looking for help and wanted to see if anyone is able and interested. Long story short, here is what I am trying to build.
Here is the riddle I am trying to solve:
Bob supports 10 different stores. Each store makes widgets, depending on the store, they can make 250-2000 widgets. In order for the store to sell the widgets, they have to be activated. Bob has 50 machines that can do activations (These machines are the constraint). Each machine can do 35 activations a day. Bob knows when each store would like to start their activations, but he can't meet their date, so he needs to forecast to them when he can start.
Bob wants to build a schedule to be able to tell each store when he thinks he will be ready to start their activations and when he thinks they will be done. Bob also wants the flexibility to move the machines around, if asked.
Assumptions:
- Bob’s boss can give him new stores at any time, so he needs a way to be able to add them at any time.
- Bob determines where the activation machines go and when
- Bob wants to track forecasted versus actual to make sure each machine is doing 35 activations a day, so if they fall behind it automatically pushes the rest of the schedule
- Bob knows when each store would like to start their activations
- Bob’s boss could get a request at any day to change the order of the stores
Saving Changes...
While you could use MSP for this purpose by treating each store as a task (or potentially a series of tasks) and each machine as a work-type resource, an operations scheduling tool might be a better fit, especially if the native reporting in MSP is insufficient for your needs.
