Question

Given the information shown, if there are currently 200 units available, the batch size is 500, and lead time is two weeks, planned order releases will be needed in weeks ____.

Week	1	2	3	4
Gross Requirements	320	360	300	380
Scheduled Receipts	500

A. 1 and 2

B. 1 and 3

C. 2 and 3

D. None of the above

Answer 1

Below is the screenshot of the formula applied -

XUS ? mos - Excel Dynamics AX FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Abhis fx Σ Calculate Now Insert Function ? A e Define Name FX Use in Formula AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Used Time Reference Trigº Functions Manager Create from Selection Function Library Defined Names Trace Precedents 5 Show Formulas Trace Dependents Error Checking Remove Arrows fx Evaluate Formula Formula Auditing Gó Watch Window Calculation Calculate Sheet Options Calculation F15 : X ✓ f B G с On Hand 1 4 380 2 3 LT 2 Q = 500 200 4 5 D E F 1 2 3 320 360 300 500 0 =C4+06+D3-D2 =D4+E6+E3-E2 =E4+F6+F3-F2 =IF((C4+D3-D2)>0,0,(C4+D3-D2)*(-1) =IF((D4+E3-E2]>0,0,(04+E3-E21*(-1)) =IF((E4+F3-F2]>0,0,(E4+F3-F21*(-1) 0 10 500 500 500 0 Gross Requirement Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases |=F4+G6+G3-G2 = IF((F4+G3-G2)>0,0,(F4+G3-G2)*(-1)) 500 10 6 7 8

Below is the screenshot of the MRP schedule -

X] H5 = m FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Dynamics AX Calibri T 11 AR A Wrap Text Gene * Cut Еe Copy Format Painter Paste Β Ι Ο 三三 Merge & Center $ Clipboard Font Alignment F22 : х ✓ fx A B C On Hand 1 2 3 8--8-. D 1 320 500 380 0 0 500 Gross Requirement Scheduled Receipts LT 2 Projected on Hand Q = 500 Net Requirements Planned Order Receipts Planned Order Releases E 2 360 0 20 0 0 500 F 3 300 0 220 280 500 0 G 4 380 0 340 160 500 0 200 4 5 6 7 8

From above,

Planned Order release will be in Week 1 & 2.

Hence, correct option will be Option A.