Product Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Chair 150 100 50 120 200 250 180 80

Scheduled receipts for Item legs are 100 units in week 3. Prepare the MRP for Chair Independent demand for Seat is 2200 in the 4th week

Part - Lead time in week - Initial Inventory - Safety Stock - Lot size

CHAIR 1 120 75 LFL

LEG ASSEMBLY 2 200 0 200

SEAT 1 0 70 LFL

BACK ASSEMBLY 2 50 25 100

LEGS 1 70 30 LFL

CROSS BAR 1 70 30 LFL

formula for reference OH of peri-1 =(OH+SR+PR-GR)Peri-0 Net req Peri-1=Max(GR+$SS-SR-OH,0)Peri-1 PR peri-1=If(Net Req-1>0, (Roundup(Net req-1/$Lot size,0))*$Lot size,0) PO=Index(PR array(D17:K17)),row1,$Lead time+2)

SUBJECT NAME: OPERATION MANAGEMENT

TOPIC: MRP

KINDLY USE EXCEL TO SOLVE THE GIVEN QUESTION BY USING THE FOLLOWING DATA GIVEN, AFTER POSTING THE ANSWER LET ME KNOW THE STEPS OF IT.

Nole Faler ce dik in het Files without ar Prepare the MRP for air TAL Clar 1 Wok 2 W3 Weckt Wesks WX7 VAS 9000 950 180 DO Part chair les assembly seat torch seirbh (4) [ [ Crowbar | Lead time in week 1 2 1 2 1 1 Scheduled receipts for kam lex : 100 units in week 3 Incepercent demand or stotis 2200 in the oth wees Initial Safety Latine Inventory Stock 120 75 LFI 200 0 200 0 10 UL SO 25 100 710 90 IFI 70 30 LFL form for furence OH of purl.1 OH+SR+PR-ORPO Netreq Perl-MaxiGROSSS SR-OHO Pert-1 PR peri-1-HINet Reg-1-0. (Roundup Net reg-1% Lof size 1 Lot see DO-Index/PR array(017:K171) row 1$Lead time+21 Chair IVINE Indented Bill of Materials Item name Level Number per parent Leg Assembly Back Assembly Seat Legs Cross bar FOR LOT FOR LOT (LFL) -Put 1 Distinct items 0 0 Lead time Lot size Safety Stock Period 3 Minimum quantity Period 7 Period 8 Period 0 Period 1 Period 2 Period 4 Period 5 Period 6 Gross requirements Scheduled receipts On Hand Inventory NET POQ Req Planned receipts Planned orders