Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this question needs to be solved in excel sheet with all formulas mentioned. Question # 1 Given the follow bill of materials tree and other

this question needs to be solved in excel sheet with all formulas mentioned.

image text in transcribed Question # 1 Given the follow bill of materials tree and other data, construct the MRP records for parts A, B and C given the master production schedule below. In considering safety stocks, we require that on hand inventory never drop below the specified safety stock level. The demand provided in the table below is for Part A. Week Deman d 1 5 2 15 3 18 4 8 5 12 6 22 This table contains some extra information that needs to be factored into your MRP schedule!!!!!! Part A B C Lead time Safety Stock 1 2 1 Order On hand Quantity Inventory Expected Receipts 0 20 21 0 0 40 20 32 units, period 1 10 Lot for Lot 50 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forecasting Methods And Applications

Authors: Spyros G. Makridakis, Steven C. Wheelwright, Rob J Hyndman

3rd Edition

0471532339, 9780471532330

More Books

Students also viewed these Finance questions