Please post formula / walk through so I can understand how the answer was arrive
ID: 429521 • Letter: P
Question
Please post formula / walk through so I can understand how the answer was arrived
The partially completed MRP record in Table 7.16 provides gross requirements, scheduled receipts, lead time, and beginning on-hand inventory.
a. Complete the record for a lot size of FOQ = 1,500 units.
b. Complete the record for a lot size of P = 3.
c. Complete the record for an L4L lot size.
d. Which lot size rule results in the lowest aver- age inventory?
e. Which lot size rule results in the fewest/most orders?".
Explanation / Answer
Assumptions:
For 1 st case
1.For 1st week : we are considering the planned order inventory is =1000 { 790 ordered before 2 weeks of 1 st week + 200 beginning inventory + 10 safety stock }
2.For 2nd week : we are considering the planned order inventory is =1100 { Which is ordered 2 weeks before of 2nd week }
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
a. Complete the record for a lot size of FOQ = 1,500 units.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
b. Complete the record for a lot size of P = 3.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
c. Complete the record for an L4L lot size.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
d. Which lot size rule results in the lowest aver- age inventory?
As lot with 2 week lead times they have maximum orders that is 5.So that lot size has less avg.inventory.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
e. Which lot size rule results in the fewest/most orders?".
Lot for Lot size = Only 2 orders (Fewer orders)
Lead time with 2 weeks & 1500 FOQ have = 5 (Most orders )
Item F200 Lot size Ipod earbuds Lead time: 2 weeks Beginning inventory 200 Safety Stock: 10 Week 1 2 3 4 5 6 7 8 9 Gross Requirements 1000 1100 750 900 1200 0 400 0 1300 Scheduled Reciepts 1300 350 1200 0 400 0 1300 0 0 Planned OH Inventory 1000 (790 ordered in 2 weeks before + 200 beginning inv. + 10 safety stock) 1100 (Ordereed in 2nd week) 1300 (Ordereed in 1 st week) 900(350 Ordereed in 2nd week)+550 Inventory in hand) 1200(Ordereed in 3rd week) 0 400(Ordereed in 5th week) 0 1300(Ordereed in 7th week) Planned Reciepts 1300 350 1200 0 400 0 1300 0 0 Planned Order Release 1300 350 1200 0 400 0 1300 0 0Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.