19. Figure 11.38 shows a partially completed inventoryrecord for the rear wheel subassembly. Gross require-ments, scheduled receipts, lead time, and current on-hand inventory are shown.a. Complete the last three rows of the record for anFOQ of 200 units.b. Complete the last three rows of the record by usingan FOQ of 100 units.c. Complete the last three rows of the record by usingthe L4L rule.Item: MQ-09Description: Rear wheel subassemblyGrossrequirementsScheduledreceiptsProjected on-handinventoryPlannedreceiptsPlanned orderreleases50Lot Size:Lead Time: 1 weekWeek12345678 910252510511090451101060FIGURE 11.38Inventory Record for the RearWheel Subassembly

a. Complete the last three rows of the record for an FOQ of 200 units. Week Gross requirements…

Answered: 19. Figure 11.38 shows a partially…

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

Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 1 week February Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 60 35 20 0 January 2 70 15 3 18 8 60 90 BID 4 40 0 LE Week 5 45 30 6 45 70 7 55 0 8 50 0
The three tables above show the master production schedule and the bill of materials of part A, and the inventory records of all the parts. There are no scheduled receipts. Given this information, what is the net requirement of part A in Week 4?
Product A is made from components B, C, and E. Item C is a subassembly that requires 2 units of D and 1 unit of E. Item B also is an intermediate item, made from D. All other usage quantities are 2. Choose the correct BOM for product A. O A. O C. C (2) D (2) E (1) D (2) C (2) A E (2) E (1) A B (2) B (2) D (1) E (2) D (2) Q Q B. O D. (D (1) D (2) C (2) C (2) E (2) E (1) A (E (2) A E (2) B (2)) D (2) B (2) D (2) Q
h ow is master production schedule created and how it is used ?
What modules of the ERP system would you recommend. To maintain inventory what would be the solution that an EPR system could provide to a business.
snip
What information is not found in the Quantity Schedule section of the cost of production report? Units started into production Total units to account for Cost of units started this period Units transferred to the next department
Please do fast
• What is the Reorder Point (ROP)? • What is the fill rate? What is the average inventory? • What is the average flow time? Given Data: Coefficient of variation (CV) = 0.24 Average weekly demand = 540 units Standard deviation = 130 units Lead time=2 Lot size = 1641 Safety inventory: NORMSINV(0.95) = 1.64 Standard deviation * sqrt(2) * 1.64 130*√√2*1.64 301.51 301 = 301 units
1.
Product Z is made from three units of A, two of B, and four of C. A, in turn, is made of one unit of C and five of D. A customer order was received for 200 units of Z in Week 8. (Hint: You will need to use "low-level coding", i.e., pull each item to the lowest level it appears on the BOM.) Item Lot Size On Hand Lead Time Z LFL 30 3 A LFL 40 1 B LFL 100 4 C 1000 50 3 D 500 2000 3 a. Show the Bill of Materials b. Develop MRP schedules showing gross/net requirements and planned order releases/receipts for each item.
8. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 20 product As and 8 product Bs. a. Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks. X A Part G Gross requirements Y Scheduled receipts Projected available balance Planned order release Q = lot for lot; LT = 1; SS=0. 0 Y (2 required) G 10 B Z F Week 1 2 3 4 5 6 7 Part Y Gross requirements Scheduled receipts Projected available balance 67 Planned order release 1 10 Week 23 4 5 6 7 Q=lot-for-lot; LT=2; SS=0. b. Suppose 10 units of safety stock are required for part Y. What changes would result in the records? Would the MRP system produce any exception messages?

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