please fill in the answer sheets. please

This is a Group Mini Case Study (15\%) for your existing teams and each team will receive a team specific data sheet on their MS Teams chat box. This Group Mini Case Study is easier than it looks and is due in 2 weeks. INSTRUCTIONS - All 3 of the following must be done for each part in the Lawnmower Model A 1. For the product demonstrated in the BOM below and using the information for the BOM items in table 1 below, calculate the Gross Requirements, Ending Inventory, Net Requirements, Planned Receipts and Planned Order Releases for all items in the BOM. Notice that the production plan for part 1000 Lawn Mower Model A is already entered in the planning grid. 2. Write any MRP Exception Messages that you believe would be created under the related planning table and explain why the message would be created and how the MRP Controller should react. 3. Looking at each part being planned and situation the plan creates, document any changes your team would make to the planning strategy for the part to make the planning of that part go more smoothly. For example, changing the suppliers to a company with a shorter delivery lead time or changing the lot sizing strategy of the part. Type your response data in the appropriate space in the planning grids below and attach the document to the Group Mini Case Study in BlackBoard. Please - only submit 1 for team and ensure it contains Team Member names who contributed to the Group Mini Case Study. 1 The Lawnmower and some of it's parts. Mower Engine Assembly Crankshaft, Piston and Connecting Rod Spark Plug SIB540 MRP Lawn Mower Group Mini Case Study Table 1 Item Planning Information - see individual Team Data Sheet on your MS Team chat box for remaining data. MRP calculations. Note 2: Remember to calculate planned order releases for all parts in BOM level 0 posting dependent requirements to components gross requirement line before proceeding to calculate planned order releases for parts in BOM level 1. Have a different Team Member verify your calculations before proceeding to the next part. Note 3: Ensure all relevant Exception messages are entered clearly below the part number they pertain to. Note 4: Lot Size - LFL lot for lot - EX (in SAP) is a lot sizing technique, where orders produced are the exact amount needed. In a materials requirement planning (MRP) environment, lot size is equal to the net requirements for that period. Mult (Multiples lot size) which is always uses a multiple of the base quantity for a reorder POQ (Period Order Quantity) lot size is which reorders a quantity sufficient to cover the number of periods specified, so you only get one planned order for the number of periods in the POQ. For example, a POQ = 3 means you will create a planned order to cover the requirement of 3 periods when the planned order required. Note 5: S/L - Stock/ Requirements List SIB540 MRP Lawn Mower Group Mini Case Study 1000 Lawn Mower (Production Plan shown in Gross Requirements line) 1001 Wheels 1002 Blade 1002 Blade rust iu. ivuthills 1016 Wrist Pin rusi in. inulilils 1017 Crankshaft 1018 Connecting Rod rost IO: INOtnng 1019 Steel, Cold Rolled, 0.125" rusl IU. IVULIIII 1020 Steel Tube, 3/4" OD x 24' LG rust iu. ivulillili This is a Group Mini Case Study (15\%) for your existing teams and each team will receive a team specific data sheet on their MS Teams chat box. This Group Mini Case Study is easier than it looks and is due in 2 weeks. INSTRUCTIONS - All 3 of the following must be done for each part in the Lawnmower Model A 1. For the product demonstrated in the BOM below and using the information for the BOM items in table 1 below, calculate the Gross Requirements, Ending Inventory, Net Requirements, Planned Receipts and Planned Order Releases for all items in the BOM. Notice that the production plan for part 1000 Lawn Mower Model A is already entered in the planning grid. 2. Write any MRP Exception Messages that you believe would be created under the related planning table and explain why the message would be created and how the MRP Controller should react. 3. Looking at each part being planned and situation the plan creates, document any changes your team would make to the planning strategy for the part to make the planning of that part go more smoothly. For example, changing the suppliers to a company with a shorter delivery lead time or changing the lot sizing strategy of the part. Type your response data in the appropriate space in the planning grids below and attach the document to the Group Mini Case Study in BlackBoard. Please - only submit 1 for team and ensure it contains Team Member names who contributed to the Group Mini Case Study. 1 The Lawnmower and some of it's parts. Mower Engine Assembly Crankshaft, Piston and Connecting Rod Spark Plug SIB540 MRP Lawn Mower Group Mini Case Study Table 1 Item Planning Information - see individual Team Data Sheet on your MS Team chat box for remaining data. MRP calculations. Note 2: Remember to calculate planned order releases for all parts in BOM level 0 posting dependent requirements to components gross requirement line before proceeding to calculate planned order releases for parts in BOM level 1. Have a different Team Member verify your calculations before proceeding to the next part. Note 3: Ensure all relevant Exception messages are entered clearly below the part number they pertain to. Note 4: Lot Size - LFL lot for lot - EX (in SAP) is a lot sizing technique, where orders produced are the exact amount needed. In a materials requirement planning (MRP) environment, lot size is equal to the net requirements for that period. Mult (Multiples lot size) which is always uses a multiple of the base quantity for a reorder POQ (Period Order Quantity) lot size is which reorders a quantity sufficient to cover the number of periods specified, so you only get one planned order for the number of periods in the POQ. For example, a POQ = 3 means you will create a planned order to cover the requirement of 3 periods when the planned order required. Note 5: S/L - Stock/ Requirements List SIB540 MRP Lawn Mower Group Mini Case Study 1000 Lawn Mower (Production Plan shown in Gross Requirements line) 1001 Wheels 1002 Blade 1002 Blade rust iu. ivuthills 1016 Wrist Pin rusi in. inulilils 1017 Crankshaft 1018 Connecting Rod rost IO: INOtnng 1019 Steel, Cold Rolled, 0.125" rusl IU. IVULIIII 1020 Steel Tube, 3/4" OD x 24' LG rust iu. ivulillili