ERP Assignment answers

Exercise 1 :
Given the following information about Xyz Company that produce children cereal A and B complete the tables below:
Safety stock =200
The company will produce 50 packs per minute.
The total of working hours in a day is 8 hours.
Each box contains 100 packs.

1- Xyz sale and operation plan from Jan to April :

Inventory:
1- 4752-4752=0+200=200
2-4788-4788=0+200=200
3-5086-5086=0+200=200
4-5420-5409=11+200=211
Capacity: (50x60x8)/100=240
1-240x22=5280
2- 240x21=5040
3-240x22=5280
4-240x23=5520

Utilization:
1- (4752/5280)x100=90%
2- (4788/5040)x100= 95%
3- (5060/5280)x100=96.32%
4- (5420/5520)x100=98.18%
Cereal A Boxes :
1- (4752x40)/100=1901
2- (4788x40)/100=1915
3- (5086x40)/100=2034
4- (5420x40)/100=2168
Cereal B Boxes :
1- (4752x60)/100=2851
2- (4788x60)/100=2873
3- (5086x60)/100=3052
4- (5420x60)/100=3252

2- Xyz Production plan for the month of March:
Demand Management
Week 1
3/ 2-3/5
Week 2
3/8-3/12
Week 3
3/15-3/19
Week 4
3/22 - 3/26
Week 5

3/29-3/31
4/1-4/2
Monthly Demand
Cereal A
2034
2034
2034
2034
2034
2168

Cereal B
3052
3052
3052
3052
3052
3252
Working days in a week
4
5
4
5
3
2
Working days in a month
22
22
22
22
22
23
MPS Weekly Demand
Cereal A
Boxes
370
462
370
462
466

Cereal B
Boxes
555
694
555
694
699

MPS: Cereal A Boxes :
1- (2034X4)/22=370
2- (2034X5)/22=462
3- (2034X4)/22=370
4-(2034X5)/22=462
5-(2034X3)/22+(2168X2)/23=465
Cereal B Boxes :
1-(3052X4)/22=555
2-(3052X5)/22=694
3-(3052X4)/22=555
4-(3052X5)/22=694
5-(3052X3)/22 +(3252X2)/23=699

Exercise 2 :
Given:
• Cereal A will need 200 lb. of wheat, and Cereal B will need 300 lb. of wheat.
• Each box weighs 60 lbs.
• The batches should weigh 400 lb. each.
Complete the following table of MRP record for wheat in xyz cereals A and B:
Wheat lead time = 2 weeks
Week 1
Week 2
Week 3
Week 4
Week5
MPS
Boxes
Cereal A
370
462
370
462
466

Cereal B
555
694
555
694
699
MPS
Batches 400 lb.
Cereal A
56
69
56
69
70

Cereal B
83
104
83
104
105
Gross Requirement lb.