Use excel formulas to solve the problem!! Midwest Parts Supply (MPS) is a fabric
ID: 360233 • Letter: U
Question
Use excel formulas to solve the problem!!
Midwest Parts Supply (MPS) is a fabricator of small steel parts that are sold as components to manufacturers of electronic appliances and medical equipment. In the MPS fabrication department, steel sheets are subjected to a series of two main operations—cutting and polishing. Each job must have the operations completed in this order, and each machine sees the same job order, so it is sufficient to specify a single job sequence in order to describe a schedule. No machine can process more than one job at a time. This morning, 4 jobs have been released to the shop by the ERP system, and the production manager is interested in minimizing the time it takes to complete the entire schedule, usually referred to as the schedule makespan. Build a model to help the production manager find the appropriate schedule. The following table gives the number of hours required for each operation.
Midwest Parts Supply (MPS) is a fabricator of small steel parts that are sold as components to manufacturers of electronic appliances and medical equipment. In the MPS fabrication department, steel sheets are subjected to a series of two main operations—cutting and polishing. Each job must have the operations completed in this order, and each machine sees the same job order, so it is sufficient to specify a single job sequence in order to describe a schedule. No machine can process more than one job at a time. This morning, 4 jobs have been released to the shop by the ERP system, and the production manager is interested in minimizing the time it takes to complete the entire schedule, usually referred to as the schedule makespan. Build a model to help the production manager find the appropriate schedule. The following table gives the number of hours required for each operation.
Job Cutting time Polishing time Job Order Job Index Cutting time Cutting starting time Cutting completion time Polishing time Polishing starting time Polishing completion time 1 5 4 1 2 9 5 2 3 3 9 3 4 9 3 4 MakespanExplanation / Answer
The Main catch to note here is that Polishing can start only after cutting and one job is only processed at time.Now if we start with Job 1 , the start time and end times of polishing items and cutting times are shown below .
Thus the minmum span in which they can complete all the 4 jobs is 26.
Job Cutting time Polishing time Job Order Job Index Cutting time Cutting starting time Cutting completion time Polishing time Polishing starting time Polishing completion time 1 5 4 1 1 5 0 5 4 5 9 2 9 5 2 3 9 8 17 5 18 23 3 3 9 3 2 3 5 8 9 9 18 4 9 3 4 4 9 17 26 3 23 26Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.