Question: Please solve using EXCEL Spreadsheet Showing the formula. Thank you Please solve using EXCEL Spreadsheet Showing the formula. Thank you Rockit Electronics manufactures a line
Please solve using EXCEL Spreadsheet Showing the formula. Thank you


Please solve using EXCEL Spreadsheet Showing the formula. Thank you
Rockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C. B is made of three units of D and two of E. C is made of two units of F and two of E. The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks. As the production manager, you need to figure out the MRP planning schedule. a. What is the bill of materials (product structure tree)? b. If 1,000 units of blue ray players are required in week 10 , what is the MRP schedule? Specifically, when items are to be ordered and received. Assume we have no units of inventory on hand
Step by Step Solution
There are 3 Steps involved in it
To solve this problem we need to determine two things the Bill of Materials BOM and the Material Req... View full answer
Get step-by-step solutions from verified subject matter experts
