Show all work from excel please step by step and formulas and answer the following 3 questions based on the information from the charts

1. Complete the master schedule for Product X, including the projected available inven-tory and the ATP numbers.

2. From the master schedule for Product X and using the data given for components A, B, C, and D, create MRP grids for each of the components for the next ten weeks.

3. Suppose that a customer for Product X wants three additional units for their order scheduled for week 4. What would you tell them? Specifically, if you cannot promise them the three units for week 4, what is the best that you can do given the information you have. Assume that adequate capacity exists in all the production equipment.

Benzie Products Company Benzie Products Company produces several lines of products, but one (they call it "product X") uses unique parts to produce it and the demand is very seasonal. There are some possible variations in the design, so the company tends to use available-to-promise (ATP) logic to master schedule the product. Since the components to produce it are quite expensive, the company tries very hard to minimize any inventory of the product or its components during the seasons with very low sales. Product X is just now entering the low season, and the following chart represents the forecast data and actual customer orders for the next ten weeks: Benzie Products Company - pgs. 110-111 Read the case up through the BOM for product X. Then, use the following information (and not the remaining information in the case) to complete the case analysis: The partial MPS given in the case has an error. Correct the error as you solve the MPS. Lead time for product X is 1 week. Relevant data for components A,B,C and D at the start of week 1 : In addition, item D has independent demand of 5 units/week. Also, item A has a scheduled receipt of 60 units for week 1. In the Assignments section, answer items 1, 2 and 3. Omit items 4 and 5