As a production planner in the FCC Company, you were asked to provide a feasible capacity plan for the production of the three parts A, B and Cover the planning horizon of 4 weeks. The planned order releases and scheduled receipts are as follows: Week 1 2 300 575 Planned Order 500 200 Releases 2000 Scheduled Receipts Part routing and work center capacity information is given as follows: Routing file Setup Time per Run Time per Part Work Center Batch (min.) Unit (min.) 3.0 5.0 30 2.0 100 120 90 A 1 2 4 3 4 2 4 B 120 30 120 30 3.0 1.0 1.8 0.2 с Work Center Capacities (hrs.) 2 3 Mill Drill 40 40 Turn lathe 40 4 Inspect 40 1/3 (a) Assuming one-week lead time for each operation, make a detailed capacity check to determine the the planned order releases and scheduled receipts are feasible. If not, revise the planned order releases and/or scheduled receipts. (b) Using the Microsoft Excel, draw the load profiles of the work centers in all weeks where a production takes place
