A case study for spreadsheet based production scheduling

Document Type

Conference Proceeding

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.

Publication Title, e.g., Journal

IIE Annual Conference and Expo 2008

This document is currently not available here.