Question

I have most of this correct just confused on plan D net requirements and projected on hand. So I only need plan D, please show work

Oh No!, Inc, sells three models of radar detector units. It buys the three basic models (E, F, and G) from a Japanese manufacturer and adds one, two, or four lights (component D) to further differentiate the models. D is bought from a domestic producer .59/10 D(2) D(4) Lead times are one week for all items except C, which is two weeks. There are ample supplies of the basic units (E. F, and G) on hand. There are also 10 units of B, 10 units of C, and 25 units of D on hand. Lot-sizing rules are lot-for-lot ordering for all items except D which must be ordered in multiples of 100 units. There is a scheduled receipt of 100 units of D in week 1 The master schedule calls for 40 units of A to be produced at the beginning of week 4, 60 units of B at the beginning of week 5, and 30 units of C at the beginning of week 6 Prepare a material requirements plan for D and its parents.(Leave no cells blank-be certain to enter "o" wherever required.)

Answer 1

For A,B,C

Net requirements for the week, (ie the number of units to be produced for the week)= Gross requirements for the week – projected on hand at the beginning of the week

For D

Gross requirements of D required= 1* net requirements of A +2* net requirements of B +4* net requirements of C

MRP

Consider everything is for the beginning of the week except for projected on hand e.g. we need 360 units at the beginning of week 2

Projected on hand at the end of week(Inventory on hand /projected available) = Max(    0,      projected on hand at the end of previous period (t-1) +      Scheduled receipt for current period, t    +   Planned receipt for current period, t    - Gross requirements for current period, t )

*Sometimes scheduled receipt and planned receipts- both are included under the term ‘scheduled receipts"

                                               

Net requirements = Max ( 0,    Gross requirements for current period, t - Projected on hand at the end of previous period, t-1   - scheduled receipt for current period, t )                   

                       

Planned order receipt –

1. If there is no net requirement (net requirement ≤ 0), Planned order receipt = 0

2.If there is net requirement,( net requirement > 0)

1. For LFL, planned order receipt = net requirement for current period
2. If lot size is mentioned, , planned order receipt = Multiple of lot size
3. If fixed quantity minimum order quantity mentioned, then planned order receipt = Max (minimum order quantity , net requirements for current period)

Planned order release =planned order receipt.

Planned order release amount is same as planned order receipt

Planned order release period = planed receipt period - lead time

Security Warning Automatic update of links has been disabled Options... Safety Stock nil leed time-1 Period Gross requiremants at the beginning of the weak projected on hand lat the beginning of week)0 40 0 net requirements let the beginning of week) lead time- 1 PERIOD projected on hand (at the beginning of week) 10 10 nat requiraments (at the beginning of waak 14 -H11-H12 Item-C Quantity Lf leed time-2 Period 17 Gross requirements at the beginning of the week projected on hand (at the beginning ot weck 10 10 net requirements (at the beginning of week) 20 118119 24 25 Item -D 26 Safety Stock-nil:Order Quentity-multiples of 100 27 28 Gross requirements at the beginning of the week ofthe weekD62 D1 3 D20 a1 E6 2 E13 3 E20 1 F6+2 F13+3 F20 Scheduled receipts at the beginning ofthe weelk 13612 1*16+2"113 3 120

K27 C D EF GH1J Item -A Safety Stock-nil:Order Quantity-LFL lead time-1 Period 0 1 2 3 4 5 6 40 4 Gross requirements at the beginning of the week projected on hand (at the beginning of week) 0 0 0 0 0O net requirements (at the beginning of week) 40 6 Item -B Safety Stock-nil:Order Quantity-LFL 10 lead time- 1PERIOD 0 1 23 4 5 6 Gross requirements 60 projected on hand (at the beginning of week) 10 10 10 10 10 10 net requirements (at the beginning of week) 13 50 14 15 Item-C 16 Safety Stock-nil:Order Quantity-LFL 17 lead time-2 Period 0 1 2 3 4 5 6 30 18 Gross requirements at the beginning of the week projected on hand (at the beginning of week 10 10 10 10 10 10 10 19 net requirements (at the beginning of week) 20 20 21 23 24 25 Item -D Safety Stock-nil:Order Quantity-multiples of 100 26 27 lead time-1 Period 0 1 2 3 4 5 6 28 Gross requirements at the beginning of the weelk 0 0 0 40 100 60 29 Scheduled receipts at the beginning of the week 100

Security Warning Automatic update of links has been disabled Options... 23 24 25 Item-D 26 Safety Stock-nil:Order Quantity-multiples ot 100 lead time-1 Periad 28 Gross requirements at the beginning of the week -1 H6+2 H13+3*H20 -116+2*113+3*120 Scheduled receiptsat the beginning of the week projected on hand (at the end of week) 30 31 net requiramants at the beginning of the weelk MAXIO,D28-C30-029) MAXIO,E28-D30-E29) -MAXIO,F28-E30-F29 MAXI0, G28-F30-G29) -MAX(O,H28-G30-H29) -MAX/0,128 H30-129) 32 planned order receipt -D31 -E31 -631 -131 :F31 100 planned order release 132 35 36 37

L36 8 23 24 25 Item -D 26 Safety Stock-nil:Order Quantity-multiples of 100 27 lead time-1 Period 0 1 2 3 456 28 Gross requirements at the beginning of the week 0 0 40 100 60 29 Scheduled receipts at the beginning of the week 100 projected on hand (at the end of week) 30 25 125 125 125 85 85 25 31 net requirements at the beginning of the week 0 0 0 0 150 32 planned order receipt 0 0 0 0 100 0 planned order release 0 0 0 100 00 34 35 36 37 38 39 40 41 43

a

Answer 2

GHHGFCGGHJKKLLLHHVCVHHHHBBBCCC