Question
As mentioned in the lecture, Mark Hamel published a very clear mixed model level scheduling example in his book on lean math; for years he
As mentioned in the lecture, Mark Hamel published a very clear mixed model level scheduling example in his book on lean math; for years he operated a lean math blog that addressed the example attached. Your job is to extend that model for a larger number of products. Build your own mixed model level scheduling tool in Excel, leveraging the description from his example. Test your tool on a four-product example using your own data. Your tool must accommodate a minimum of 4-products using some nominal demand data that you create. Your Heijunka (scheduling) box design is based on the 4-product (often referred to as stock keeping units, SKUs) so, for example suppose your 4-products (from the same production family) are 4-different soft drink varieties. Normally, one would start by developing a Profile (pareto) of the demand data. Produce your own data. Identify a shipping schedule to assist in identifying a target EPEi and devise a trial Scheduling box for a typical week of production Fully document your rationale for each decision/choice you make in designing the scheduling box! This will mean that you are assuming a set of C/O targets. Think carefully about the FGI supermarket and its role. One aspect that makes Hamel's description so clear is the plots that he provides of the demand data. The plots make obvious what is meant by the term "leveling".
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started