please help with Q6 & if you wouldn't mind showing formulas! thank you!
6. A furniture manufacturer makes a bookcase from two end panels, four shelves, fasteners, and $ MAE apter 7 Capacity Planning and Management hangers. The end panels and shelves have the following data: End Panel Run Time Machine Operation Setup Time 0.6 hour 0.3 hour 0.8 hour 5 minutes 3 minutes 4 minutes Saw Planer Router 2 3 Shelf Run Time Operation Machine Saw Molder Router Sander 2 3 4 Setup Time 0.5 hour 1.3 hours 0.7 hour 0.1 hour 4 minutes 5 minutes 5 minutes 1 minute The master schedule for the next three weeks is 35, 50, and 40 bookcases, respectively. Each MPS quantity requires a setup. a. What is the total number of hours required on each of the five machine centers for each week? b. If each of the two parts is started into production one week (five days) before needed in assembly, and it takes one day per operation, generate the week-by-week load on the routing machine. c. If, in part b, the two parts arrive at the router on the same day, which would you process first? Why? 7. An office supply company makes notebooks with the following product structure: Notebook Pad Cover The company uses an MRP system, and has the following records for these three items. Week 2 3 4 5 6 Notebook Gross requirements Scheduled receipts Projected available balance Planned order releases 25 25 25 25 25 25 30 5 0 n G H M N o Show your work in the yellow cells when calculating capacity requirements in hours for question a. Skip questions bande Bookcase - Master Production Schedule Capacity Requirements in hours Machine Week 1 Week 1 35 Week 3 Week 2 50 Week 3 40 Week 2 MPS Data Saw Planer Router Molder Sander End Panel Operation Machine Run Time Setup Time 1 2 3 Saw Planer Router 5 minutes 3 minutes 4 minutes 0.6 hour 0.3 hour 0.8 hour Shelf Run Time Operation Machine Setup Time 1 2 Saw Molder Router Sander 4 minutes 5 minutes 5 minutes 1 minute 0.5 hour 1.3 hours 0.7 hour 0.1 hour 3 4 7 B Automatic Workbook Statistics 6. A furniture manufacturer makes a bookcase from two end panels, four shelves, fasteners, and $ MAE apter 7 Capacity Planning and Management hangers. The end panels and shelves have the following data: End Panel Run Time Machine Operation Setup Time 0.6 hour 0.3 hour 0.8 hour 5 minutes 3 minutes 4 minutes Saw Planer Router 2 3 Shelf Run Time Operation Machine Saw Molder Router Sander 2 3 4 Setup Time 0.5 hour 1.3 hours 0.7 hour 0.1 hour 4 minutes 5 minutes 5 minutes 1 minute The master schedule for the next three weeks is 35, 50, and 40 bookcases, respectively. Each MPS quantity requires a setup. a. What is the total number of hours required on each of the five machine centers for each week? b. If each of the two parts is started into production one week (five days) before needed in assembly, and it takes one day per operation, generate the week-by-week load on the routing machine. c. If, in part b, the two parts arrive at the router on the same day, which would you process first? Why? 7. An office supply company makes notebooks with the following product structure: Notebook Pad Cover The company uses an MRP system, and has the following records for these three items. Week 2 3 4 5 6 Notebook Gross requirements Scheduled receipts Projected available balance Planned order releases 25 25 25 25 25 25 30 5 0 n G H M N o Show your work in the yellow cells when calculating capacity requirements in hours for question a. Skip questions bande Bookcase - Master Production Schedule Capacity Requirements in hours Machine Week 1 Week 1 35 Week 3 Week 2 50 Week 3 40 Week 2 MPS Data Saw Planer Router Molder Sander End Panel Operation Machine Run Time Setup Time 1 2 3 Saw Planer Router 5 minutes 3 minutes 4 minutes 0.6 hour 0.3 hour 0.8 hour Shelf Run Time Operation Machine Setup Time 1 2 Saw Molder Router Sander 4 minutes 5 minutes 5 minutes 1 minute 0.5 hour 1.3 hours 0.7 hour 0.1 hour 3 4 7 B Automatic Workbook Statistics
