A spread-sheet model for efficient production and scheduling of a manufacturing line/cell

In this paper we develop an efficient spread-sheet production planning/scheduling model for a resource-constraint production line or a manufacturing cell that produces several products but one at a time with significant changeover time and changeover cost. There are also management and physical constraints related to the operating hours, production capacity and amount of inventory allowed. The production line/cell supplies several products to customers who pull the products according to their own operating policy (working hours) that may be different from manufacture's operating hours. We also show several real-world applications and highlight the benefits and merits of the model.

[1]  Brian G. Kingsman,et al.  The economic lot scheduling problem: theory and practice , 1991 .

[2]  Elisabeth Brandl.  The multi-item, single-machine scheduling problem with stochastic demands , 2010 .

[3]  Edward A. Silver,et al.  Operations Research in Inventory Management: A Review and Critique , 1981, Oper. Res..

[4]  Anders Segerstedt,et al.  Restricted work-in-process: A study of differences between Kanban and CONWIP , 2009 .

[5]  Anders Segerstedt,et al.  Lot sizes in a capacity constrained facility--a simulation study of stationary stochastic demand , 2005 .

[6]  Manjusri Basu,et al.  Determination of EOQ of Multi-Item inventory Problems through nonlinear Goal Programming with penalty Function , 2005, Asia Pac. J. Oper. Res..

[7]  Robert C. Leachman,et al.  A Heuristic scheduling policy for multi-item, single-machine production systems with time-varying, stochastic demands , 1988 .

[8]  Anders Segerstedt.  Escape from the unnecessary : some guidelines for production management , 1999 .

[9]  J. Grznar,et al.  An optimal algorithm for the basic period approach to the economic lot scheduling problem , 1997 .

[10]  Robert C. Leachman,et al.  Multi-item, single-machine scheduling problem with stochastic demands: a comparison of heuristics , 1994 .

[11]  David L. Woodruff,et al.  CONWIP: a pull alternative to kanban , 1990 .

[12]  C L Doll,et al.  AN ITERATIVE PROCEDURE FOR THE SINGLE-MACHINE, MULTI-PRODUCT LOT SCHEDULING PROBLEM : A WORKING PAPER , 1973 .

[13]  Jeffrey K. Liker,et al.  The Toyota way : 14 management principles from the world's greatest manufacturer , 2004 .

[14]  Paul H. Zipkin.  Computing Optimal Lot Sizes in the Economic Lot Scheduling Problem , 1991, Oper. Res..

[15]  Anders Segerstedt.  Lot sizes in a capacity constrained facility with available initial inventories , 1999 .

[16]  S. Graves.  The Multi-Product Production Cycling Problem , 1980 .

[17]  Jeffrey K. Liker,et al.  Becoming lean : inside stories of U.S. manufacturers , 1997 .

[18]  James P. Womack,et al.  Lean Thinking: Banish Waste and Create Wealth in Your Corporation , 1996 .

[19]  Anders Segerstedt.  Frequency approach for treating capacity-constrained multilevel production , 2004 .

[20]  P. C. Jones,et al.  When Is The Economic Lot Scheduling Problem Easy , 1989 .

[21]  Anders Segerstedt,et al.  A scheduling policy for adjusting economic lot quantities to a feasible solution , 2007, Eur. J. Oper. Res..

[22]  Paul H. Zipkin,et al.  Foundations of Inventory Management , 2000 .

[23]  Earl E. Bomberger,et al.  A Dynamic Programming Approach to a Lot Size Scheduling Problem , 1966 .

[24]  David F. Pyke,et al.  Inventory management and production planning and scheduling , 1998 .

[25]  Jorge Francisco Arinez,et al.  An equipment design approach for achieving manufacturing system design requirements , 2000 .

[26]  Robert C. Leachman,et al.  Note: An Improvement to the Dynamic Cycle Lengths Heuristic for Scheduling the Multi-Item, Single-Machine , 1991 .

[27]  Chu‐Hua Kuei,et al.  Designing and Managing the Supply Chain Concepts, Strategies, and Case Studies , 2000 .

[28]  Kristina Nilsson,et al.  Corrections of costs to feasible solutions of economic lot scheduling problems , 2008, Comput. Ind. Eng..

[29]  S. Elmaghraby.  The Economic Lot Scheduling Problem (ELSP): Review and Extensions , 1978 .

[30]  David F. Pyke,et al.  Push and pull in manufacturing and distribution systems , 1990 .

[31]  A. Federgruen,et al.  The stochastic Economic Lot Scheduling Problem: cyclical base-stock policies with idle times , 1996 .

[32]  Pär Brander,et al.  Inventory Control and Scheduling Problems in a Single-Machine Multi-Item System , 2005 .

[33]  F. Robert Jacobs,et al.  Operations and Supply Management , 2006 .

[34]  Albert Battersby,et al.  Operations Research in Production and Inventory Control , 1965 .

[35]  Edward A. Silver,et al.  Finding effective schedules for the economic lot scheduling problem: A simple mixed integer programming approach , 2004 .

[36]  Anders Segerstedt,et al.  Economic lot scheduling problems incorporating a cost of using the production facility , 2009 .

[37]  Maurice Bonney,et al.  Are push and pull systems really so different , 1999 .

[38]  David Et.All. Simchi-Levi.  Designing and managing the supply chain: consepts, strategies and case , 2014 .