please show how to do in excel with formulas

Williston Technologies wishes to use MRP methodology to develop a plan for the next 9 weeks. Williston Technologies has gathered the following information: Bill of materials Current Inventory Records Master Production Schedule a. Using MRP methodology, how much of parts A, B, C, and D should be ordered, and when should they be ordered? b. Based on the material requirements plan developed for Williston Technologies, how much of parts A, B, C, and D will remain in inventory at the end of week 9? c. Williston Technologies has just learned that the order for 200 As appearing in week 4 has been cancelled. How does this change the material requirements plan