Fill in the excel sheet provided with answers. please. xxx=090

Material Requirements Planning Exercise Assignment Learning Objective: The purpose of this exercise is to demonstrate the materials requirement planning (MRP) functionality in SAP system. As a first step, a small test problem with five materials in a BOM is solved manually to determine planned order releases by carrying out MRP calculations. The problem is solved in a traditional way with weekly time buckets. The main steps in this exercise are outlined below. Calculate Planned Order Releases for materials A-XXX (YOUR LEARN \#\#\#), B-XXX (YOUR LEARN \#\#\#), C-XXX (YOUR LEARN \#\#\#), D-XXX (YOUR LEARN \#\#\#), and E-XXX (YOUR LEARN-\#\#\#). Relevant data on independent requirements (forecast), BOM, and material master data are given below. The BOM for product A-XXX is shown below. One piece of D-XXX and two pieces of E-XXX are assembled to make one unit of C-XXX. Two pieces of C-XXX and one piece of D-XXX are needed to make one subassembly of B-XXX. Four units of BXXX are further assembled to make one unit of the product AXXX. NOTE 1: Lot Size - EX (in SAP) Lot-for-lot (LFL) 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. - FX (in SAP) fixed lot size which is always uses the same quantity (or a multiple) for a reorder Note 2: Beginning Inventory - Assume there is no (zero) beginning inventory on any of the items MRP Calculation Grid - submit this page to Asst 7.1 in Blackboard. Important! See the BOM