Answered step by step
Verified Expert Solution
Question
1 Approved Answer
solve this attached question in an excel sheet with all formula shown for calculations Question # 1 Given the follow bill of materials tree and
solve this attached question in an excel sheet with all formula shown for calculations
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 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started