Question

Fill in the blanks

In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "0" wherever required.) WEEK NUMBER 0 4 50 5 70 75 40 ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release 75 50 70 Period Gross requirements Item J Scheduled receipts OH = 40 Projected available balance LT = 1 Net requirements SS = 0 Q = L4L Planned order receipts Planned order releases

Answer 1

Below is the screenshot of the MRP schedule -

X] mos - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW - Trace Pr fx VIEW Dynamics AX Define Name Ft Use in Formula Name Manager Create from Selection Defined Names Σ ? A e AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trigº Functions Function Library Insert Function Trace De Remove A1 : J A B C On Hand 1 J 2 3 4 5 6 LT1 Q = L4L SS = 0 D 1 0 0 40 0 0 35 Gross Requirement Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases E 2 75 0 0 35 35 0 F 3 0 0 0 0 0 50 40 H 5 70 0 0 70 70 0 4 50 0 0 50 50 70

Below is the screenshot of the formula applied -

XUS ? mos - Excel Dynamics AX FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Abhish fx Σ Calculate Now Insert Function ? A e Define Name Trace Precedents 5 Show Formulas FX Use in Formula Trace Dependents Error Checking AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Used - Time Reference Trig Functions Manager Create from Selection Remove Arrows Fx Evaluate Formula Function Library Defined Names Formula Auditing Gó Watch Window Calculation Calculate Sheet Options Calculation A1 : X fe J A B G 4 50 1 2 3 4 5 Gross Requirement J Scheduled Receipts LT1 Projected on Hand Q = L4L SS = 0 Net Requirements Planned Order Receipts I Planned Order Releases C D On Hand 1 0 0 40 =C4+06+D3-D2 = IF((C4+D3-D2)>0,0,(C4+D3-D2)*(-11) 0 35 E F 2 3 75 0 0 0 =D4+E6+E3-E2 =E4+F6+F3-F2 =IF((D4+E3-E2)>0,0,(D4+E3-E2)*(-1)) =IF((E4+F3-F2)>0,0,(E4+F3-F21*(-1)) 35 0 0 50 =F4+G6+G3-G2 = IF((F4+G3-G2)>0,0,(F4+G3-G2)*(-1)) 50 70 H 5 70 0 =G4+H6+H3-H2 = IF((G4+H3-H2)>0,0,(G4+H3-H2)*(-1)) 70 0 6 7 9