Question: The data from the inventory records are shown below: Data Category Lot-sizing Rule Lead Time Scheduled Receipts Beginning Inventory Item A POQ (P = 3

The data from the inventory records are shown

The data from the inventory records are shown below: Data Category Lot-sizing Rule Lead Time Scheduled Receipts Beginning Inventory Item A POQ (P = 3 weeks) 1 week None 150 Item B POQ (P = 2 weeks) 1 week None 100 + Complete the following MRP table: Item: A Lot Size: POQ (3 wks) Lead Time: 1 wk 2 3 4 5 7 8 9 10 1 15 6 55 Gross requirements 80 50 35 20 15 30 25 10 Scheduled receipts Projected on-hand inventory 150 Planned receipts Planned order releases Complete the following MRP table: Item: B Lot Size: POQ (2 wks) Lead Time: 1 wk 2 3 4 5 6 7 8 9 1 10 10 10 Gross requirements 80 50 35 20 55 15 30 25 Scheduled receipts Projected on-hand inventory 100 Planned receipts Planned order releases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

answer in excel with detail please LT = 2 Problem 4: 10 pts The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100...

They COM Palma O Points of 10 am Lot 4 Laadim Week 5 8 2 Grossman Sched Predobandito Planer DES- 2 DO elp me solve this View an example Get more help There to show the whites. And the wystartowy...

topic: production & inv. system please use excel, and provide clear steps Problem 3: 10 pts Companys pays regular-time wages of $5,000 per employee per period for any time worked up to 500 hours...

solve in excel and show the equations and steps you used LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following...

solve in excel WITH THE EQUATIONS USED LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100...

solve on excel and show the equations used!! LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule:...

solve in excel.I NEED THE EQUATIONS YOU USED LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule:...

David Christopher is an orthopedic surgeon who specializes in three types of surgeryhip, knee, and ankle replacements. The surgery mix is 40 percent hip replacement, 50 percent knee replacement, and...

Given the following information and the bill of material, develop a material requirements plan so that we can successfully meet the production plan for product A. The production schedule for product...

22 and 23 please 22. 23. 24. + 0/0.16 points | Previous Answers RogaCalcET2 5.1.044. Evaluate the limit. 3 lim N 00 i = 1 X ;3 NA 26) Submit Answer Save Progress Practice Another Version + 0/0.16...

Identify the items A-F in the process of cellular respiration below. D A E C (Organelle) F A v [ Choose ] Chloroplast Mitochondria Water B Carbon dioxide ATP energy Oxygen Glucose sugar Light energy...

When an mlo licensee pays a penalty to the Department 4 0 % of that money is used for: consumer education continuing education courses for licensees Payment for examinations the Commissioner's salary

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...