1. (a) Fill out the following MRP record for Part C. Part C
Week
1 2 3 4 5 6
Gross requirements 35 40 40 40 40 45
Scheduled receipts 30
Projected available balance 40 35 25 15 5 25 10
Planned receipts 0 30 30 30 60 30
Planned order releases 30 30 30 60 30 0
Lot size=30, LT=1, SS=0
1 (b) Given the above MRP record and the following routing data for Part C, determine the capacity requirements for work center 100 from Part A using CRP. For the scheduled receipt of 30 units in week 1, assume that the setup and half of the quantity have been completed.
Routing Data for Part C
Operation Work Center Setup Time Run Time
Operation 1 100 2 hours 0.2 hour
Capacity requirements for work center 100 from Part C
Week
1 2 3 4 5 6
Hours of Capacity
2. The following input/output data were gathered at the end of week 4 for a work center.
Week
1 2 3 4
Planned Input 60 60 60 60
Actual Input 68 70 75 70
Cumulative Deviation 8 18 33 43
Planned Output 65 65 65 65
Actual Output 60 62 63 65
Cumulative Deviation -5 -8 -10 -12
Planned Backlog 30
Actual Backlog 30
(a) Complete the input/output document.
(b) What recommendations would you make?