Question

Week 1 2 3 4 5 6 7 8 9 10 Demand 41 44 84 42...

Week 1 2 3 4 5 6 7 8 9 10
Demand 41 44 84 42 84 86 7 18 49 30

End item A has a planned lead time of two weeks. There are currently 120 units on hand and no scheduled receipts.
a. Compute the planned order releases using lot-for-lot
b. Compute the planned order releases using part-period balancing where the ratio of the setup cost to the holding cost is 200
c. Compute the planned order releases with Wagner Whitin, where the ratio of setup cost to holding cost is 200. How much lower is the cost of the plan than in part (a,b)?
d. Rework part (a) with 50 units of safety stock and identify differences with part (a).

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Week 1 2 3 4 5 6 7 8 9 10 Demand 41 44 84 42...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • sement 5. [Lot Sizing in Material Requirement System (MRP) (10 pts) Type: C Michael Jordan, senior...

    sement 5. [Lot Sizing in Material Requirement System (MRP) (10 pts) Type: C Michael Jordan, senior in the department of management at ISU, recently got a job as a production planner at Honda Automotive Assembly Plant in Lincoln. Alabama. His first task on the job training is to review the master production plan shown below. (Initial inventory = 160 units, Ordering cost = $200 per order Lead time = 1 week, Holding cost = $1 per unit per week. No...

  • The following is a partial MRP table. Based on the information provided, an inventory holding cost...

    The following is a partial MRP table. Based on the information provided, an inventory holding cost of $0.39 per unit per week and a setup cost of $139 per order, what would be the planned order release for week 2 using a part period balancing lot sizing approach? Week Gross Requirements Scheduled Receipts On-Hand Inventory Net Requirements Time Phased Net Requirements Planned Order Releases 0 1 2 3 4 5 10 30 20 15 20 40 L | 10 40...

  • - Data Table for Problems 14.17 through 14.19* Period 1 2 3 4 5 6 7 8 9 10 11 12 requirements 30 ...

    please answer 14.17 - Data Table for Problems 14.17 through 14.19* Period 1 2 3 4 5 6 7 8 9 10 11 12 requirements 30 40 30 70 20 10 80 50 8 "Holding cost $2.50/unit/week; setup cost $150; lead time 1 week; beginning n Gross inventory 40 m14.17 Develop a lot-for-lot solution and calculate total rel- s evant costs for the data in the table for Problems 14.17 through d 14.19. Px 14.18 Develop an EOQ solution and...

  • provide step by step explanation of calculation. thanks

    Case #2 MGT2315  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...

  • 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:...

  • manufacturing plng/ control 1. Suppose that your company sells a product for which the annual demand...

    manufacturing plng/ control 1. Suppose that your company sells a product for which the annual demand is 10,000 units. Holding costs are $1.00 per unit per year, and setup costs are $200 per order (a) What is the economic order quantity for your product? (b) What will be the annual total cost holding and ordering? 2. A company has currently 100 workers. A worker works 40 hours a week, and can at most work 20 hours of overtime per week....

  • 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    ...

  • Refer to the Excel speadsheet, "Inventory Management," to complete the "Analytics Exercise: An MRP Explosion -...

    Refer to the Excel speadsheet, "Inventory Management," to complete the "Analytics Exercise: An MRP Explosion - Brunswick Motors," at the end of Chapter 21 in the textbook. Answer Questions 1-3. Given Spread Sheet: A-Topic 3 Part 1&2 AND  A-Topic 3 Part 3 Please use given information, show formulas/ calculations, and give reasons behind answer. Part 2 Gear Box Given Information Setu Invento Number of orders (count cells with values for planned order release Set-up Costs=# of Orders X Setup Costs 8...

  • Hosted by ALEKS Corp. Homework 9 1 2 3 4 5 6 7 8 9 10...

    Hosted by ALEKS Corp. Homework 9 1 2 3 4 5 6 7 8 9 10 > Question 10 of 10 (1 point) | Attempt 1 of Unlimited | View question in a popup 11.3 Section Exercise 9 (p-value, calc) Crossover trial: A crossover trial is a type of experiment used to compare two drugs. Subjects take one drug for a period of time, then switch to the other. The responses of the subjects are then compared using matched-pair methods....

  • Problem 1 Week 1 2 3 4 5 6 7 8 9 10 Forecast 65 70...

    Problem 1 Week 1 2 3 4 5 6 7 8 9 10 Forecast 65 70 60 65 70 65 65 60 55 40 Customer Orders 20 25 10 40 10 30 5 10 0 5 Available 100 Average PAB (w/out starting) ATP Total ATP MPS Total MPS On hand = 100 Lot size = 100 multiples Safety Stock = 25 1. Complete the MPS time-phased record above with the information as given

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