MRP Grid Exercise

Try an Answer:

$\backslash$table$[[\backslash$table$[[$Product$],[$Lead Time$/$weeks$]],$KL$-2000-10,,,,,,,,,],[\backslash$table$[[2]],,,,,,,,,],[$Order Quantity,$200,$WEEKLYPERIODS$],[$On Hand Inventory$/$units$,125,1,2,3,4,5,6,7,8,9,10],[$Gross Requirements,$115,115,125,130,120,110,125,135,130,145],[$Scheduled Receipts,,$200,,,,,,,,],[$Projected Available Balance$],[$Net Requirements$],[$Planned Order Receipt$],[$Planned Order Release,,,,,,,,,,,$]]$

MRP Inputs: Bill$-$of$-$Materials, Example

MRP Inputs: Billof$-$Materials, Example

COMPONENT

ON HAND

Determine the quantities of these components that will be required to assemble $10xs,$ taking into account the quantities on hand $($i$.$e$.,$ in inventory$)$ of various components.

B

$4$

C

$10$

D

$8$

E

$60$