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 70 units inweeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below.Data CategoryLot-sizing ruleLead timeScheduled receiptsBeginning inventoryItem: CL4L1 weekNone155Item: DсGross requirementsScheduled receiptsProjected on-hand inventory 155Planned receiptsPlanned order releasesItem: EComplete the material requirements plan. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)Gross requirementsScheduled receiptsProjected on-hand inventoryPlanned receiptsPlanned order releasesL4L2 weeks70 (week 2)230ItemD230Gross requirementsScheduled receiptsProjected on-hand inventory 160Planned receiptsPlanned order releases1П1EFOQ = 2002 weeks1None16020N200702☐☐☐3☐☐☐133404☐☐☐4Lot Size: L4LLead Time: 1 weekWeekWeek5Lot Size: L4LLead Time: 2 weeksWeek56Lot Size: FOQ = 200Lead Time: 2 weeks5667177888DEADEE

Material Requirements Planning (MRP) is a production planning and inventory control system that…

Answered: The bill of materials and the data from…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Item: P24 Forecast Orders On hand Week 12345678 30 30 30 40 40 40 45 45 13 8 4 Projected available balance Available-to-promise MPS 20 a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Order 1234 4 Amount 40 30 30 25 Desired Week 4 6 2 3
Suppose we are formulating a Master Production Schedule (MPS) for an item. The lot-size policy for this item calls for a fixed quantity of 300 units. Lead time for this item is three weeks. Week O inventory for this item is 400 units. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item.... Week 1 2 3 4 5 6 Forecast 120 120 100 100 100 120 Booked 115 121 71 0 0 0 When the master schedule is complete. what will be the Projected On-Hand in Week 4?
Pennington Cabinets is a manufacturer of several different lines of kitchen and bathroom cabinets that are sold through major home improvement retailers. Pennington built material requirement planning as follows: Current Jan Feb Mar 1200 1000 Gross requirements Scheduled receipts 800 Projected available balance Net requirements Planned order receipts 820 Planned order release Compute net requirements in Feb. Your Answer: Answer
A Corporation assembles two products as shown in the product structures below. It has orders for 480 on period 8 and 100 units on period 9 of product X.. Develop the MRP table for each of the items. Item Amount on hand Schedule receipts Lot-sizing rule X 180 0 L4L A 100 0 Periodic order quantity (2 weeks) B 50 0 100 C 50 0 200 D 50 0 400 X LT = 2 A (2) LT = 2 B (1) LT = 2 C (3) LT = 1 D (1) LT = 3 D (2) LT =2
Electro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.
Suppose we are formulating a Master Production Schedule (MPS) for an item. Week O projected on- hand is 83 units. The lot-size policy for this item calls for L4L ordering. Lead time for this item is one week. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item . Week 2 3 4 5 6 Forecast 60 45 45 45 45 60 Booked 59 48 30 10 What will be the order size of the first MPS Start Quantity that is needed?
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is in indented form: ITEM DESCRIPTION Bracket assembly Wall board USAGE 1 A 4 Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap E G 2 Below is a table indicating current inventory levels: Item Inventory A B E G 23 18 55 25 200 170 1,100 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank be certain to enter "0" wherever requirec Item Net Requirements A F Nevt
Pennington Cabinets is a manufacturer of several different lines of kitchen and bathroom cabinets that are sold through major home improvement retailers. Pennington built material requirement planning as follows: Current Jan Feb Mar Gross requirements 1100 1150 Scheduled receipts 810 Projected available balance 750 Net requirements Planned order receipts Planned order release Compute planned order receipts in Mar, assuming that minimum lot size is 1.
2. RoadHog Inc. is a small manufacturer of motorcycle accessories. It makes muffler with fins on a linethat is also used to make a variety of other products. Because it is costly to set up the line to produce themin batches, RoadHog has an incentive them in batches. However, while customer demand is known over a6-planning horizon, it is not necessarily constant from week to week. The unit cost, fixed setup cost andmonthly holding cost are given in the table.Data for the RoadHog Dynamic Lot SizingWeek 1 2 3 4 5 6Demand 30 50 60 25 20 40Setup Cost 150 150 150 150 150 150Holding cost 3 3 3 3 3 3a. Find the production plan and the total cost for lot for lot scheduling.b. Find the production plan and the total cost for lot for the fixed order quantity (FOQ = 100)scheduling.c. Find the production plan and the total cost for the fixed order period scheduling (Use FOP = 3weeks).d. Which strategy is the best?
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
Consider the bill of material for Product J and the data given in the following table. The gross requirements for J are 200 units in week 6 and 270 units in week 8. Use the min 350 lot-sizing rule for M. What are the quantities of the planned orders for the M for the first seven weeks? K(1) L(4) M (2) Item Lead Time Quantity on Hand Scheduled receipts 1 30 20 30 in week 2 K 2. 40 10 in week 1 O a. 0,0,350,540,0,0,0 O b. 0,0,0,350,0,480,0 Oc. 0,0,290,350,0,0,0 O d. 0,0,290,0,540,0,0 210521224709-39153

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS