Aggregate Production PlanningPeter L. JacksonProfessorSchool of O.R. and I.E.3/7/2011Industrial Data and Systems Analysis1Goal•Learn a nice technique for production planning•See it four ways:•Bar chart •Cumulative flow chart•Excel spreadsheet•Mathematical notation•Interact with SQL query results using proceduralInteract with SQL query results using procedural code•Program the technique using Visual Basic for Applications•Use industrial data set (sales of turkey stuffing)3/7/2011Industrial Data and Systems Analysis2Forecasting, Planning, and S h d liSchedulingRead Chapter 9 of3/7/2011Industrial Data and Systems Analysis4
has intentionally blurred sections.
Sign up to view the full version.
Sales of Turkey Stuffing is Hi hlSlHighly SeasonalLine Monthly Sales and Capacity for Line 101300 000350,000400,000Cases)150,000200,000250,000300,000d Capacity (C050,000100,000123456789101112Sales andMonth NumberLine Monthly SalesMaximum Cases Per Month3/7/2011Industrial Data and Systems Analysis5http://ecx.images-amazon.com/images/I/51P15JEPTDL.jpgThe Bulldozer Method of PdtiPliMonthly Production and Capacity for Line 101Production Planning350,000400,000acity 150 000200,000250,000300,000on and Capa(Cases)050,000100,000150,000Productio(123456789101112Month NumberRequired ProductionMaximum Cases Per Month3/7/2011Industrial Data and Systems Analysis6Why is the Direction of B lldItt?Bulldozer Important?Monthly Sales and Capacity for Line 101350,000400,000Cases)150,000200,000250,000300,000d Capacity (C050,000100,000Sales and910111212345678Month NumberLine Monthly SalesMaximum Cases Per Month3/7/2011Industrial Data and Systems Analysis7Safety Stock is Required Bf S lUt i tBecause of Sales UncertaintyLine Safety Stock At Month End for Line 101140,000160,000es)60,00080,000100,000120,000Stock (Case020,00040,000123456789101112Safety Month NumberSafety stock at end of month 3 is driven by variability of sales in month 4.3/7/2011Industrial Data and Systems Analysis8