Production Sequencing using excel

[Prashant.Dedhia]

Hi,

we want to get a script written for breaking up the demands to daily buckets scheduling.
Briefing out the scenario model that is attached along with this.

We have products called A,B,C.
Against which has demands and these are manufactured on a filling line.
Every product is attributed with a Minimum run and a maximum run.
Output capacity per day per hour is also noted
Between every product changeover there is a cleaning portfolio to be carried over which is described with a cleaning matrix.

Required output model is also noted.


Regards,
Prashant

 

[David Evans]

Have a search for "Using Excel for Project scheduling" and start getting your method of operating into one of the formats that you find ...by all means come back here as you run into issues with formulas etc.

Otherwise, get your hands on Microsoft Project which is designed specifically for the challenge you face ...