Bill of Material for Office TableTableFinal AssemblyTop Assembly(1 required)Support Assembly(1 required)Center Support(1 required)Side Support(2 required)BracketWood Screw(6 required)(48 required)MS.53 An office furniture manufacturer needs to calculate material requirements for one of its most popular tables. The graphic above shows the bill ofmaterial for this item. Below are the MRP tables for the top-level assembly (the Office Table Final Assembly) and one of its sub-assemblies (the Table-TopAssembly):Office Table Final Assembly8/18/88/158/228/299/59/129/199/26Gross RequirementsScheduled Receipts300200300800700100Projected On-Hand Inv.220Net RequirementsPlanned Order ReceiptsPlanned Order ReleasesLead Time (in weeks)1Lot Size150Table-Top AssemblyGross RequirementsScheduled Receipts8/18/88/158/228/299/59/129/199/26100Projected On-Hand Inv.Net Requirements100Planned Order ReceiptsPlanned Order ReleasesLead Time (in weeks)2Lot Size40 For the Office Table above (the first MRP table), what is the Projected On-Hand Inventory in the week of 9/19?NumberFor the Office Table above, what are the Planned Order Receipts in the week of 8/8?NumberFor the Table-Top Assembly above, what are the Net Requirements in the week of 9/19?NumberFor the Table-Top Assembly above, what are the Planned Order Releases in the week of 9/5?Number

Here as per the data available, we can have the MRP plan for office table Final assembly and…

Answered: For the Office Table above (the first…

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

The table given below shows a partially completed MPS record for product A. What is the remaining ATP inventory (discrete) for week 7 after the company receives a 20 units of customer order for week 6? Order policy: 60 units Lead time: 1 week Item: A Quantity on hand: 30 Week 3 30 7. 34 11 4. Forecast requirements Customer orders (booked) Projected on-hand inventory MPS quantity MPS start ATP inventory 22 24 18 27 36 28 26 12 24 O a 59 Ob. 29 OcO Od. 49 Oe. 39
It is Friday afternoon and the following production information is available for the following week: EOQ Lead time b) c) d) 100 units 2 days Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 Monday Tuesday Wednesday Thursday Friday 40 70 80 50 40 100 Complete the MRP matrix for the following week with this information. At the production meeting on Monday morning the following information is shared: a) The planned order for 100 units on Monday is released. Thirty of the scheduled receipts for Monday are scrapped. An order for 20 units is received for delivery on Wednesday. An order for 40 units is received for delivery on Monday of the following week. EOQ Lead time 50 100 units 2 days Use this information to update the MRP matrix for the week.
In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank-be certain to enter "0" wherever required.) ITEM 3 Gross requirements On-hand Net requirements Planned order receipt Planned order release Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases WEEK NUMBER 2 3 76 4 48 76 5 72 48 72
Lead time for a certain part is 2 weeks, and the order quantity is 50. By completing this MRP record below, answer the following question: What are the Net requirements of the part in Week 3? What action should be taken? O Week Gross Requirements Projected Available Net Requirements Planned Order Receipt Planned Order Release 50 30 O 25 O None of the above 40 1 20 2 15 3 25 4 25
As an approach to inventory management, how does MRP differ from the approach taken, dealing witheconomic order quantities (EOQs)?
In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "0" wherever required.) WEEK NUMBER ITEM J 2 65 4 40 5 65 Gross requirements On hand Net requirements Planned order receipt Planned order release 42 Period Gross requirements Scheduled receipts 65 40 65 Item J LT = 1 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases
Which of the following is the planned-order release using an MRP program if the gross requirement is 5,000, inventory on hand is 1,200, and planned receipts are 800?
Jenny Malone works for the Columbus based Cummins Diesel Engine company. Jenny works in the production scheduling department and she is developing an MRP planning schedule for Item J. Please assist Jenny by developing the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. The lead time is one week. (Leave no cells blank - be certain to enter "0" in all open cells as required.) ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release Item J LT=1 Q = L4L 0 32 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 1 WEEK NUMBER 2 3 76 4 48 5 72 2 76 3 48 72
Use the following MRP record to answer the question. Item: LMN Description: Gross requirements. Scheduled receipts Projected on hand Date Planned receipts 30 Planned order releases Which one of the statements concerning item LMN is TRUE? O A. The projected on - hand inventory in week 8 is 70 units. B. The scheduled receipt of 80 units in week 3 should be expedited so that it is finished in week 2. OC. The planned order release quantity in week 3 is 80 units. O D. The planned receipt quantity in week 6 is 30 units. 1 2 3 60 80 4 Lot Size 80 units Lead Time: 3 weeks 5 30 30 80
The gross requirements for item A are specified for the beginning of weeks 1 through 12 in the table that follows. Item A, Level 0 01 02 03 04 05 06 07 08 09 10 11 12 0 60 0 50 0 70 0 40 0 60 0 50 60 ? ? ? ? ? ? ? ? ? ? ? ???????????? Gross requirements. Projected on hand Planned order release The lead time is 2 weeks. The current on hand inventory, at the beginning of week 1 is 60 units. If the order cost is $80 per order and the inventory cost is $1 per unit per period, and the order quantity is the computed part period (or a multiple of the computed part period) when it is necessary to place an order, what is the total cost for the 12 week period? Answer:
Use the following partially completed MRP record to answer the question. Item: XYZ Lot Size: L4L; ;EAD Time: 1 week Date 1 2 3 4 5 6 7 8 20 30 50 40 20 Scheduled Receipts Projected on Hand (80) Planned Receipts Planned Order Release What are the quantities of planned order releases for item XYZ for the first six weeks (weeks 1, 2, 3, 4, 5, and 6)?
In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "o" wherever required.) WEEK NUMBER ITEM J Gross requirenents On-hand Net requirements Planned order receipt Planned order release 70 45 65 30 Perlod 2. Gross requirements 70 45 65 Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases

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