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

A factory has just received an order for 100 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Item Lead Time (weeks) On Hand Inventory Scheduled receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) A 3 20 54 at week 3 lot for lot D(2) B 2 10 68 at week 4 lot for lot D(5) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Quantity on Hand: 400 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 550 300 350 500 2 250 350 0 0 3 450 250 50 500 4 450 200 100 500 Order Policy: 500 units Lead Time: 1 week Week 5 250 150 350 500 6 400 100 450 500 7 200 50 250 0 8 250 100 To o 9 450 50 50 10 450 150 100 500 500
Complete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 2 weeks Quantity on Hand: 80 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 35 45 25 20 45 55 Customer orders 25 30 7 11 (booked) Projected on-hand inventory MPS quantity
Figure 11.38 shows a partially completed inventory recordfor the real wheel subassembly. Gross requirements, sched-uled receipts, lead time, and current on-hand inventory areshown.a. Complete the last three rows of the record for an FOQ of200 units. b. Complete the last three rows of the record by using anFOQ of 100 units.c. Complete the last three rows of the record by using theL4L rule.
Contrast and compare MRP vs. order-point systems.
Based on the data in Figure 14.13, complete a netmateria l requirements schedule for:a) AJJ items (10 schedules in aU), assuming the requirement foreach BOM item is I.b) All10 items, assuming the requirement for all items is I, exceptB, C, a nd F , which require 2 each.
4. Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 8. Assume lot-for- lot ordering. Below is information about the steppers and the quantity required for each parent. Item Lead Time On Hand Inventory Components Stepper 2 20 A(1), B(3), C(2) A 1 10 D(1), F(2) B 2 30 E(1), F(3) C 3 10 D(2), E(3) D 1 15 E 2 5 F 2 20 Develop a net material requirements plan for ( F )
Operations Manager of PT Radio Gaga is calculating production costsa telecommunication radio taking into account the following needs:i. Week 1 : 20 unitsii. Week 2 : 36 unitsiii. Week 3 : 46 unitsiv. Week 4 : 45 unitsv. Week 5 : 20 unitsvi. Week 6 : 26 unitsIt is known that there is inventory from the previous week as many as 20 units. Assuming 52week per year, lead time booking for 1 week, setup cost of $40 andholding cost of $0.75 per week, you are required to assist the Operations Manager of PTRadio Gaga to calculate the estimated production cost as follows: a. Calculate EoQ b. Create a 6-week MRP Lot Sizing Table with EoQ method c. Calculate Total Production Cost using EoQ method d. Create a 6-week MRP Lot Sizing Table using the Lot methodfor Lot e. Calculate Total Production cost by using Lot for Lot methodF. Which method will PT Radio Gaga's Operations Manager take?
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
A factory has just received an order for 95 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Lead Time On Hand Scheduled Item Order Direct (weeks) Inventory receipts Policy Components End item 15 lot for lot A(3), B(2) A 2 10 33 at week 3 lot for lot C(1), D(4) B. 2 20 15 at week 4 lot for lot D(2) min. of 500 lot for lot 100 20 Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component Care needed in the "planned order release". Input should be an exact number.
Completely fill in the MRP matrices for items J, K, and L. Do not complete the matrix for M and be careful to watch lot size restrictions. Item J LLC 0 Lot Size L4L LT 3 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 100 Net Requirements Planned Order Receipts Planned Order Releases Item K LLC _ Lot Size Mult 200 LT 2 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 110 Net Requirements Planned…

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