A work center processes models A, B, and C and has three workers working for the next 7 weeks. There are three workers that each work 40 hours per week. 1. a. Complete the MRP records for all models 1. b. Complete work center loading calculations for all models based on Planned Order Release. 1. c. Complete the capacity Loading Table for the entire Work Center and determine which weeks are under or over capacity based on 120 hours/week available for the three workers. 2. Would you decrease or increase the hours worked? What is the theoretical required hours of work? 3. Which week(s) are over capacity and which are under capacity? Std Hours Setup Time 1.5 Model Run Time A 0.90 | 0.6 C 0.08 *1 Setup Time is Required Per Lot Lot Size 100 50 Lead Time 1 On-hand 15 20 125 0.67 0.67 1 1 500 2 3 4 7 1 56 5 20 6 23 20 51 61 30 Model: A Work Center MRP Record Week Gross Requirements Schedueled Receipt Projected Available Net Requirements Planned Order Receipt Planned Order Release 100 15 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 80 100 2 150 3 200 4 60 5 175 6 180 Model: B Work Center MRP Record Week Gross Requirements Schedueled Receipt Projected Available Net Requirements Planned Order Receipt Planned Order Release 7 100 20 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 z 5 3 125 4 100 6 300 7 500 100 180 200 Model: C Work Center MRP Record Week Net Requirements Schedueled Release Projected Available Net Requirements Planned Order Receipt Planned Order Release 500 105 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 2 3 4 5 6 7 Total Work Center Capacity Loading Week Capacity (Hrs) Planned (Hrs) A work center processes models A, B, and C and has three workers working for the next 7 weeks. There are three workers that each work 40 hours per week. 1. a. Complete the MRP records for all models 1. b. Complete work center loading calculations for all models based on Planned Order Release. 1. c. Complete the capacity Loading Table for the entire Work Center and determine which weeks are under or over capacity based on 120 hours/week available for the three workers. 2. Would you decrease or increase the hours worked? What is the theoretical required hours of work? 3. Which week(s) are over capacity and which are under capacity? Std Hours Setup Time 1.5 Model Run Time A 0.90 | 0.6 C 0.08 *1 Setup Time is Required Per Lot Lot Size 100 50 Lead Time 1 On-hand 15 20 125 0.67 0.67 1 1 500 2 3 4 7 1 56 5 20 6 23 20 51 61 30 Model: A Work Center MRP Record Week Gross Requirements Schedueled Receipt Projected Available Net Requirements Planned Order Receipt Planned Order Release 100 15 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 80 100 2 150 3 200 4 60 5 175 6 180 Model: B Work Center MRP Record Week Gross Requirements Schedueled Receipt Projected Available Net Requirements Planned Order Receipt Planned Order Release 7 100 20 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 z 5 3 125 4 100 6 300 7 500 100 180 200 Model: C Work Center MRP Record Week Net Requirements Schedueled Release Projected Available Net Requirements Planned Order Receipt Planned Order Release 500 105 Work Center Loading Setup (hrs) Run (hrs) Total (hrs) 1 2 3 4 5 6 7 Total Work Center Capacity Loading Week Capacity (Hrs) Planned (Hrs)