ANSWER ONLY EXERCISE 2

1.- Using the following BOM (in its tree form), complete the following MRP analysis, knowing that the lead time is one week for each of the components (including the final product). You have an MPS of 100 units of A in week 5 and at the beginning there are already 20 units of B. The order quantity is batch-to-batch.

2.- For the previous case of point 1: if you have the option of receiving a "scheduled receipt" for 75 units for component B or C, in any of the 5 weeks, to which component would you assign it and in which week? Justify your answer with the corresponding analysis.

Answer of excersice 1:

ANSWER ONLY EXERCISE 2

B(2) D(1) Week Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Receipt Planned Order Release E(1) A D(2) 1 C(1) F(1) 2 3 4 5 1 2 3 4 A mano 5 Lead Time 6 7 Lot Size: 8 Objeto: A 9 10 11 12 A mano 13 Lead Time 14 15 Lot Size: 16 17 18 19 20 A mano 21 Lead Time 22 23 Lot Size: 24 25 26 27 28 A mano 29 Lead Time 30 31 Lot Size: 32 33 34 35 36 A mano 37 Lead Time 38 39 Lot Size: 40 41 42 43 44 A mano 45 Lead Time 46 47 Lot Size: 48 Objeto: B Objeto: C Objeto: D Objeto: E Objeto: F Semana Gross requirements Scheduled Receipts 1 semand Projected Available Balance Net requirements L4L(B2E Planned order receipts Planned order release Semana Gross requirements 0 Scheduled Receipts 1 semana Projected Available Balance Net requirements L4L(B2E Planned order receipts Planned order release Semana Gross requirements 0|Scheduled Receipts. 1 semand Projected Available Balance. Net requirements L4L(B2E Planned order receipts Planned order release Semana Gross requirements 0 Scheduled Receipts 1 semand Projected Available Balance Net requirements L4L(B2E Planned order receipts Planned order release Semana Gross requirements 0 Scheduled Receipts 1 semana Projected Available Balance Net requirements L4L(B2E Planned order receipts Planned order release Semana Gross requirements 0|Scheduled Receipts. 1 semand Projected Available Balance Net requirements L4L(B2E Planned order receipts Planned order release 0 20 ol 0 0 0 0 1| 0 0 0 0 0 0 1 0 0 20 0 0 0 0 11 0 0 0 0 0 0 11 0 0 0 0 0 0 11 0 0 0 0 0 0 11 0 0 0 0 0 0 2 0 0 nl 0 ol 0 0 21 0 0 20 0 0 0 2 0 0 0 0 0 0 21 a 0 or 0 0 0 0 380 2 0 0 0 0 0 180 2 0 0 0 0 0 100 3 0 0 0 ol 0 0 3 0 20 0 0 180 3 0 0 0 0 0 100 3 380 0 0 380 380 0 3 180 0 0 180 180 0 3 100 0 0 100 100 0 4 0 0 nl 0 0 0 100 4 200 0 0 180 180 0 4 100 0 0 100 100 0 4 0 0 0 0 0 0 4 0 0 0 0 0 0 41 0 0 0 0 0 0 5 100 0 0 Lead Time 100 100 5 0 0 0 Lead Time 0 0 5 0 0 0 Lead Time 0 0 5 0 0 0 Lead Time 0 0 5 0 0 0 Lead Time 0 0 5 0 0 Lead Time 0 0 100 180 100 380 180 100 1 Parte A Parte B Parte C Parte D Parte E Parte F BOM 0|A 1B 1C 2 D 2 E 2 D 2 F 100 200 100 400 200 100 2 1 1 11 2 1 100 200 100 200 200 200 100 1 2 3 4 A mano 5 Lead Time 6 7 Lot Size: 8 9 10 11 12 A mano 13 Lead Time 14 15 Lot Size: 16 17 18 19 20 A mano 21 Lead Time 22 23 Lot Size: 24 25 26 27 28 A mano 29 Lead Time 30 31 Lot Size: 32 33 34 35 36 A mano 37 Lead Time 38 39 Lot Size: 40 41 42 43 44 A mano 45 Lead Time 46 47 Lot Size: 48 49 A Objeto: A Objeto: B Objeto: C Objeto: D Objeto: E Objeto: F B 0 1 semana L4L(B2B) 10 1 semana L4L(B2B) 0 1 semana L4L(B2B) 0 1 semana L4L(B2B) 10 1 semana L4L(B2B) 0 1 semana L4L(B2B) Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release Semana Gross requirements Scheduled Receipts Projected Available Balance Net requirements Planned order receipts Planned order release C 10 20 10 0 10 0 D E F G H 1 2 3 |4 5 0 0 0 10 100 0 0 0 0 0 10 |=IF(D5