a) MPS Requirements by week and component Problem 6: A furniture manufacturer makes a bookcase from two end panels, four shelves, fasteners, and hangers. The end Week 1 2 3 panels and shelves have the following data. Bookcases 30 45 35 End Panel End Panels Assume no lead time back off Operation Machine Run Time Setup Time Shelves Saw 5 minutes 0.6 hour W N - End Panel - setup and run time in minutes Planer 3 minutes 0.3 hour Router 4 minutes 0.8 hour Machine Setup time Run time per Center (minutes) Shelf unit Operation 1 Saw Operation Machine Run Time Setup Time Operation 2 Planer Saw 4 minutes 0.5 hour Operation 3 Router Molder 5 minutes 1.3 hours AWN - Router 5 minutes 0.7 hour Sander 1 minute 0.1 hour Shelf - setup and run time in minutes Machine Setup time Run time per Center (minutes) unit The master schedule for the next three weeks is 30, 45, and 35 bookcases, respectively. Each MPS quantity requires a setup. Operation 1 Saw Operation 2 Molder a. What is the total number of hours required on each of the five machine centers for each week? Operation 3 Router b. Do not complete part b. Operation 4 Sander c. Would you process the end panel or shelf first and why? MINUTES required (by week) at each machine center Week 1 Week 2 Week 3 Saw Planer Router Molder Sander b) Do not complete c) Would you process the end panel or shelf first and why