Question

Consider the end item whose bill of material file is as given in Figure 8-7 of your textbook. Suppose that the planning horizon is 8 weeks.Week Forecas 145 Order 168 13 325 279 4 196 213 127 312 273 167 123 b) Suppose that the initial inventory level of B is 1200 and the safety stock level is 20 and a lot-for-lot (LFL) policy is appropriate. There are scheduled receipts of 279, 486 and 523 in weeks 2, 5 and 6, respectively. Construct the MRP record for B. (20 points)are there to a forecasung y forecasts that are relatively constant) versus one that achievl but gives spiky forecasts that change significantly from one period to the next? An end item has the product structure diagram given in Figure 8-7. greatet accuracy FIGURE 8-7 Product structure diagram (for Problem 9) End item A(3) 1 week B(2) 2 weeks 2 weeks 3 weeks 2 weeks 1 week G(2) week H(3) 4 weeks 1 week

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Consider the end item whose bill of material file is as given in Figure 8-7 of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 5. (10 points) An end item has the product structure diagram given in the following figure. Suppose that the MPS for the end item is End then A43) Fit) 3 weeks 4 weeks a. Find the planned order r...

    5. (10 points) An end item has the product structure diagram given in the following figure. Suppose that the MPS for the end item is End then A43) Fit) 3 weeks 4 weeks a. Find the planned order release for component F b. Find the planned order release for component I. c. Find the planned order release for component H. 5. (10 points) An end item has the product structure diagram given in the following figure. Suppose that the MPS...

  • Show work on excel QM to do this thanks Consider the bill of material for Product...

    Show work on excel QM to do this thanks Consider the bill of material for Product "T'h: To make one unit of"T, it needs one unit of"x" and two units of"M. To make one unit of K, it requires 4 units (Corrected) of ". The gross requirements for J are 200 units in week 6 and 250 units in week 8. Use the data given in the following table, develop the MRP tables for each item for an 8-week planning...

  • The bill of materials and the data from the inventory records for product A are shown in the figu...

    The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 100 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below Item Data Category L4L 2 weeks 100 (week 2) 350 L4L 1 week None 215 Lot-sizing rule Lead time Scheduled receipts Beginning inventory...

  • PLEASE PROVIDE STEP BY STEP CALCULATION PERFORMED IN EXCEL.

    Product XYZ is described as follows: Quantity of each assembly/component is in (brackets) XYZ are made up of assemblies A(3), B, & C(2) Assembly A contains D(2), E(2), & F(3) Assembly B contains part H(2) Assembly C contains parts G(2) & E(2) Inventory Lead- time and Lot Size Information: XYZABCDEFGHLead Time121112222Projected On Hand93125329252039160012568Lot SizeLFLLFL2010LFL10020010050Scheduled Receipts500000001000Safety Stock 105025 **Note** all scheduled receipts are in week 1 Create a product structure tree (Multilevel BOM):       (5 marks) Using Blank MRP sheets, Create a level loaded (discreet, with no remnants) plan    ...

  • Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for...

    Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for item D. A 400 unit-delivery of product P is due at the beginning of week 7. Use the worksheet Product Structure Tree Inventory Information P Order Currently Scheduled Lead Item On-Hand Recpt (wk) Time Qty LAL P 100 L4L A A FIxed Q 450 Fixed Q = 600 L4L 0 C 90 100 (wk 2) 80 (wk 2) 2 50 2 C D(2 Beg...

  • supply chain question, please solve it anyone.

    There are two (2) Parts to this case.  The First part (Part 1) requires you to use the information to:1.    Build a Bill of Material (BOM) form the given information2.    Determine the Master Production Schedule (MPS) and3.    Complete the MRP for all parts including the product.   The Second Part (Part 2) will require you to use an indexed BOM to 1.    Create the correct MPS from the provided information2.    create the MRP for the unit and all of its assemblies/components Part 1:...

  • The following table lists the components needed to assemble an end item, lead times (in weeks),...

    The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand L12), c(1),x(3) B(2), 33) G(2), 8(2) H(4), B(2) 13 16 21 29 a. f 43 unts of the end item are to be assembled, how many additional units of B are needed? (Hint You don't need to develop an MRP plan) Additional units b. An order for the end item is scheduled to be shipped at the start of week...

  • The following table lists the components needed to assemble an end item, lead times (in weeks),...

    The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount on Hand Direct Components End 2 0 L(2), C(1), K(3) L 2 8 B(2), J(3) C 3 12 G(2), B(2) K 3 17 H(4), B(2) B 2 32 J 3 27 G 3 5 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are...

  • Consider the following information about an end-product item: Ordering cost =$45/order Average usage =12 units/week Inventory...

    Consider the following information about an end-product item: Ordering cost =$45/order Average usage =12 units/week Inventory carrying cost =$1/unit/week (a) How many orders should we place per year (52 weeks) to replenish inventory of the item based on average weekly demand? (b) Given the following time-phased net requirements from an MRP record for this item, determine the sequence of planned orders using economic order quantity (EOQ) and periodic order quantity (POQ) procedures. Assume lead time equals zero and current on-hand...

  • The following table lists the components needed to assemble an end item, lead times, and quantities...

    The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 2 2 1 1 1 2 1 2 Amount on hand 0 11 8 26 12 30 7 0 A. If 21 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don't need to develop an MRP plan to determine this.)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT