PLEASE HELP ME OUT! I'm pretty sure Weeks 1 and 2 are correct as they are right now, but I'm not sure. Please calculate all the values for the System Unit, Speakers, and CD-ROM Drivers, and do it as a chart so that way it is easy for me to see the values as well.

These are some screenshots of an example problem and how they solved it, but I don't understand it. But some formulas are on there, so hopefully that is some help.

Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: - Production plans for complete kits are as follows: Start assembling 17,500 kits in week 2 Start assembling 18,500 kits in weeks 3,4 , and 5 Start assembling 19,500 kits in week 6 - The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. - All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time =1 week; Minimum order quantity =10,000 First, construct the material requirements plan for item System unit. Material requirements planning (MRP) is a planning process that translates the master production schedule into planned orders for the actual parts and components needed to produce the master schedule items. To determine whether any new orders need to be placed, first calculate net requirements. The net requirement in time period t is calculated as follows: NRt=maximum(0;GRtElt1SRt), where GRt= gross requirement in time period t; Elt1SRt=endinginventoryfromtimeperiodt1;=scheduledreceiptsintimeperiodt. Calculate the net requirement in the 1 st week. NR1=max(0;GR1El0SR1) Planned order receipts (PR) is the amount that is planned to be ordered to be received at the beginning of the period. If the lead time is greater than t1, planned order receipts in time period t equal to zero. If the net requirement equals zero, managers don't need to order any more items. Otherwise, current planned order receipt can be found as the maximum of the net requirement and the minimum order size. Projected ending inventory is the best estimate of what inventory levels will look like at the end of each week, based on current information. The ending inventory from time period t is calculated using the following equation: Elt=EIt1+SRt+PRtGRt where PRt= planned receipts in time period t; Find the ending inventory in the 1 st week. El1=El0+SR1+PR1GR1