Module 8 Homework

Answer ALL the following questions and upload your answers to Question 1 in Blackboard. Show all your work. Remember that you may only submit one document that includes all of your answers. Complete all the YELLOW CELLS to develop an MRP record for items B, C, and D. If the answer is 0, you can either put 0 or leave the cell blank.

Bill of Materials (BOM):

Master Production Schedule (MPS) for Item A:

Week	1	2	3	4	5	6	7	8	9	10
Qty Needed (FAS)	0	100	0	200	0	120	180	60	0	0

Item Master File (IMF):

Item	B	C	D
Lot Sizing Rule	POQ (P=3 weeks)	L4L (lot for lot)	FOQ (Q* = 500)
Lead Time (LT)	1 week	2 weeks	3 weeks
Scheduled Receipts (SR)	None	200 in week 1	None
Beginning On-Hand (OH) Inventory	20	0	425

5 6 7 8 9 10 ITEM B (POQ, where P = 3 weeks) and LT = 1 week Week 1 2 3 4 Gross Requirements (GR) Schedule Receipts (SR) Projected 20 On Hand units (POH) Planned Receipts (PR) Planned Order Releases (POR) 1 2 3 4 5 6 7 8 9 10 ITEM C (L4L) and LT = 2 weeks: Week Gross Requirements (GR) Schedule Receipts (SR) Projected units On Hand (POH) Planned Receipts (PR) Planned Order Releases (POR) 3 4 5 6 7 8 9 10 ITEM D (FOQ = 500) and LT = 3 weeks: Week 1 2 Gross Requirements (GR) Schedule Receipts (SR) Projected 425 On Hand units (POH) Planned Receipts (PR) Planned Order Releases (POR)