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