A case study for spreadsheet based production scheduling
Document Type
Conference Proceeding
Date of Original Version
12-1-2008
Abstract
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.
Publication Title, e.g., Journal
IIE Annual Conference and Expo 2008
Citation/Publisher Attribution
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