A case study for spreadsheet based production scheduling
Date of Original Version
A Microsoft Excel spreadsheet model for scheduling and tracking multi-machine manufacturing operations with up to twelve different labor steps and six separate production runs per job was developed and implemented. The model provides the ability to compare work in process (WIP) inventory levels at each labor step against target levels to help meet customer delivery dates. Users can schedule, track and monitor production run status using on-screen graphical tools and printout reports. We evaluated the spreadsheet engineering methodology implemented to create a multi-machine production scheduling tool. Benefits and disadvantages that spreadsheet applications can provide over commercial software packages are presented.
IIE Annual Conference and Expo 2008
Perrin, Bradley S., and Valerie Maier-Speredelozzi. "A case study for spreadsheet based production scheduling." IIE Annual Conference and Expo 2008 , (2008): 1742-1747. https://digitalcommons.uri.edu/mcise_facpubs/581