✨ VIPSolutions

Dashboard Ask AI

Question:

Give step-by-step solution with explanation and final answer:Uploaded ImageUploaded ImageUploaded ImageDevelop MRP records for all items needed for item F in the following product structure for product H, using the information provided in the following tables. The lead time to complete product H is one week. Master production schedule (MPS) calls for 190, 140, and 100 units of demand for period 4, 5, and 6. Planning Data Data Category ~~ D 3 F G | Lot size rule Q=15* Law Law Q=300* Lav Lead time 2 weeks 1 week 1 week 2 weeks 2 weeks Safety stock 15% 25 20 35 4 Scheduled None none 1300 (wk 1) 700 (wk 1) 900 (wk 1) receipts Beginning 30 20 20 50 4 inventory *Planned order schedules must be the same or multiples of Q amount **minimum on hand (ending inventory) quantity to be observed FORMAT FOR ENTRIES: All quantities are INTEGER (120, for example). Enter 01f you do not have quantity for any period PROVIDE THE FOLLOWING SELECTED VALUES: Planned Order Release Quantities for Product H Period 1 Period 2 Period 3 Period 4 Period 5 Blank 1 Blank 2 Blank 3 Blank 4 Blank 5 Gross Requirements Quantities for Item F Period 1 Period 2 Period 3 Period 4 Period 5 Blank 6 Blank 7 Blank 8 Blank 9 Blank 10

This is AI generated Response.
Asked by: Test User 100170
Created at: 2025-05-10 08:15:55

Answer:

Rendered Raw Text
Let's break down the problem step by step: ### 1. **Understand the Bill of Materials (BOM) Structure** - **Product H**: Top level - Needs: 2 x D, 1 x F, 1 x E - **D**: Lower level - Needs: 2 x F, 1 x E, 1 x G - **G**: Needs 3 x I ### 2. **Master Production Schedule (MPS) for H** - Period 4: 190 units - Period 5: 140 units - Period 6: 100 units ### 3. **Planned Order Release Quantities for Product H (Blanks 1-5)** Since lead time for H = 1 week, planned order releases must be scheduled 1 period before the demand. | Period | Gross Requirements (MPS) | Planned Order Release | |--------|-------------------------|----------------------| | 1 | 0 | 0 | | 2 | 0 | 0 | | 3 | 0 | 190 | | 4 | 190 | 140 | | 5 | 140 | 100 | So: - **Blank 1 (Period 1)**: 0 - **Blank 2 (Period 2)**: 0 - **Blank 3 (Period 3)**: 190 - **Blank 4 (Period 4)**: 140 - **Blank 5 (Period 5)**: 100 ### 4. **Gross Requirements for Item F (Blanks 6-10)** #### Item F appears at two places: - Needed **once** for each H directly (right branch) - Needed **twice** for each D (left branch), and each H needs 2 D So, for each H, gross requirement for F = 1 (direct) + [2 (per D) × 2 (D per H)] = 1 + 4 = **5 F per H** #### Planned Order Releases for H (from above) = Gross requirements for F (shifted by F's lead time = 1 week) | Period | Planned Order Releases for H | Gross Req. for F (period +1) | |--------|------------------------------|------------------------------| | 1 | 0 | 0 | | 2 | 0 | 0 | | 3 | 190 | 0 | | 4 | 140 | 950 (190 × 5) | | 5 | 100 | 700 (140 × 5) | So, shift by 1 period (as F lead time = 1): - **Blank 6 (Period 1)**: 0 - **Blank 7 (Period 2)**: 0 - **Blank 8 (Period 3)**: 0 - **Blank 9 (Period 4)**: 950 - **Blank 10 (Period 5)**: 700 --- ## **Final Answers:** #### **Planned Order Release Quantities for Product H** - **Blank 1 (Period 1):** 0 - **Blank 2 (Period 2):** 0 - **Blank 3 (Period 3):** 190 - **Blank 4 (Period 4):** 140 - **Blank 5 (Period 5):** 100 #### **Gross Requirements Quantities for Item F** - **Blank 6 (Period 1):** 0 - **Blank 7 (Period 2):** 0 - **Blank 8 (Period 3):** 0 - **Blank 9 (Period 4):** 950 - **Blank 10 (Period 5):** 700 --- ### **Explanation** - Planned Order Releases for H are scheduled one period before its MPS demand due to 1-week lead time. - Gross Requirements for F = 5 × Planned Order Releases for H, shifted by the lead time for F. If you need the full MRP table for F or other components, let me know!

📢 Instructions:

  • Ask anything relatd to above question only.
  • For new Question goto :
    Ask AI