Answer everything excel formulas, please!!!! Midwest Parts Supply (MPS) is a fab
ID: 359508 • Letter: A
Question
Answer everything excel formulas, please!!!!
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 suflicient to specify a single job sequence in order to describea 8schedule. No machine can process more than one job at a time. This morning, 4 jobs have been released to the shop 10by 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. 13 Cutting Cuttin Polishing Polishing Cutting Polishing Cutting starting completion Polishing starting completion Job Order Job Index time time time time time 16 18 19 20 21 Makesparn 24 25Explanation / Answer
There are two processes and once a process is completed for the job, 2nd Job can be started. for example, if cutting is completed for 1st Job, then same can be transferred to polishing process and Job 2 can start simultaneously for Cutting Job. Following same logic, below is the timing and table that we derive:
Job Job Index Cutting Time Cutting Start Time Cutting End Time Polishing Time Polishing Start Time Polishing End Time 1 5 0 5 4 6 9 2 9 6 14 5 10 14 3 3 15 17 9 15 23 4 9 18 26 3 24 26