Given the Bill of Materials (BOM) and Master Production Schedule (MPS) for end items A and B, complete the Materials Req

[answerhappygod]

Given the Bill of Materials (BOM) and Master Production Schedule (MPS) for end items A and B, complete the Materials Requirements Planning (MRP) record for items A, B, C, and F for the next 8 weeks. Note that for every unit of Item A that we produce, we require 4 units of Item C. For every unit of Item C, we require 4 units of Item F. The lead time for each item is included in the BOM.
Note that you should use formulas in some capacity to complete this record (in other words, if I click into a cell, I should be able to see how you got the values in cells that require calculations). This is the equivalent of "showing your work."

Given The Bill Of Materials Bom And Master Production Schedule Mps For End Items A And B Complete The Materials Req 1 (42.35 KiB) Viewed 34 times

Given The Bill Of Materials Bom And Master Production Schedule Mps For End Items A And B Complete The Materials Req 2 (47.78 KiB) Viewed 34 times

Given The Bill Of Materials Bom And Master Production Schedule Mps For End Items A And B Complete The Materials Req 3 (44.02 KiB) Viewed 34 times

D Question 15 15 pts Given the Bill of Materials (BOM) and Master Production Schedule (MPS) for end items A and B, complete the Materials Requirements Planning (MRP) record for items A, B, C, and F for the next 8 weeks. Note that for every unit of Item A that we produce, we require 4 units of Item C. For every unit of Item C, we require 4 units of Item F. The lead time for each item is included in the BOM. B A 1 week 1 week C (4) 2 weeks E (1) 2 weeks G (2) 1 week MPS/Related Info: F (4) 1 week D (2) 2 weeks H (1) 1 week G (4) 1 week 1(2) 2 weeks J (4) 1 week
/2031234/quizzes/3594757/take MPS/Related Info: Week Item A Completed End Items Item B Completed End Items Item A Lot size ordering L4L rule Safety stock 0 Beginning 0 inventory Scheduled None Receipts 1 0 O 2 3 4 5 200 250 100 100 100 B C L4L Multiples of 500 100 400 500 units in Week 2 O O 0 None сл 6 7 300 0 0 100 100 8 0 100 0 LL Multiples of 1,000 500 500 4000 units in Week 1
G13 2 3 7 K . 38 12 14 23 16 37 14 19 20 31 22 22 24 25 27 21 23 3 31 22 31 34 35 36 Ready : x fr ItemA Gross requirements Scheduled receipts Available ventory Net requirements Panned order receipts Planned order releases Work Gross requirements Scheduled receipts Available inventory Net requirements Rannad order receipts Planned order releases + Item C C Week 1 Rem 1 B 2 2 T MPR Record 3 MPR Record 3 4 4 5 55 M 6 6 I 7 7 8 8 . Rom 8 Week 1 Gross requirements Scheduled receipts Available tory Net requirements Planned order receipts Planed order releases M 2 0 Record 3 F 4 G 5 E " 6 = S 7 T 28 100% W