Single Level MRP

Please fill the chart according to the reading below. LOT is N/A so its automatically Zero!!!!

Single Level MRP Question (20 points) Suppose a computer manufacture received the following order for their 2 types of computers. 1000 business computer by week 3. 200 gaming computer by week 4. 250 business computer by week 5. A business computer needs the following: 1x Keyboard (1 week of lead time) 1x 4-terabyte hard-drive (1 week of lead time) 4x 8Gigabyte RAM (2 weeks of lead time) (4x means you need 4 of this part for business computer) 1 week to fully assemble A gaming computer needs the following 1x Keyboard (1 week of lead time) 2x 500GB Solid State Drive (2 week of lead time) (again, 2x means you need 2 of this part) 8x 8GB RAM (2 weeks of lead time) (by now, you should know 8x means you need 8 of this part) 2 weeks to fully assemble What are the requirement on a weekly basis Show your work in the worksheet MRPAnswer to answer this question. Computer Manufacturer Material Requirement Planning schedule Single Level Week 0 Week 1 Week 2 Week 4 Week 3 1000 Week 5 250 200 Item: Gross Requirement Business Computer Net requirements Lead Time: 1 Week Planned order release Item: Gross Requirement Gaming Computer Net requirements Lead Time: 2 Week Planned order release Item: Gross Requirement Keyboard Net requirements Lead Time: 1 Week Planned order release Item: Gross Requirement 4 TB Hard Drive Net requirements Lead Time: 1 Week Planned order release Item: Gross Requirement 8 GB RAM Net requirements Lead Time: 2 Week Planned order release Item: Gross Requirement 500 GB Hard Drive Net requirements Lead Time: 1 Week Planned order release