Lead time for a certain part is 2 weeks, and the order quantity is 50. By completing this MRP recordbelow, answer the following question: What are the Net requirements of the part in Week 3?What action should be taken?OWeekGross RequirementsProjected AvailableNet RequirementsPlanned Order ReceiptPlanned Order Release5030O 25O None of the above40120215325425

MRP or material requirement planning is a technique for managing and controlling the input material…

Answered: Lead time for a certain part is 2…

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

Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
Complete the master production schedule based on the following information On-hand Inventory - 160 schedule production whenever projected on-hand inventory drops below - 30 MPS lot size - 300 Week 1 2 3 4 5 6 7 8Forecast 120 100 130 110 140 140 170 180 Customer Orders 110 100 75 50 32 11 5 0Projected On-Hand Inventory 160MPSAvailable-to-Promise
Should an MRP be used with dependent or independent demand items?
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
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
Figure shows a partially completed MPS record for 2 inch pneumatic control valves. Suppose that you receive the following orders at right for the valves (shown in the order of their arrival). As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment?Order Amount (Units) Week Requested1 15 22 30 53 25 34 75 7
Newpaper sales data suggest that 20% of the days, 80 papers are sold; 40% of the days, 90 papers are sold; and the remaining days, 100 papers are sold. Given the vendor plans to stock 90 each day, what approx. expected CSL is the vendor targeting? 60% 36% 57% 65%
If the the Net Requirement for a product for a particular time period in a MRP problem is 78 and the organization uses a policy of ordering in multiples of 100, what would be the Planned Order Receipt?
Q1) Bullwhip effect can lead to stock shortages due to lack of proper information. Select one: a. True b. False Q2) The ability to track the location of the order is known as supplier visibility. Select one: a. False b. True
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 130 Q-60, LT-3 weeks, Safety Stock - 20 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 130 Planned Order Releases 1 50 50 1 50 130 0 2 0 WEEK 3 70 99 2 0 130 120 ®® 4 0 WEEK 3 70 30 0 5 130 x 4 0 30 5 130 20 0

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