Question: Case Study: Read the scenario and answer the given question Altens Ltd. is a company making auto parts in the USA. The factory has a

Case Study: Read the scenario and answer the given question Altens Ltd. is a company making auto parts in the USA. The factory has a central supply of auto parts in Houston, attached to the two distribution centres in Los Angles and New York. Altens Ltd has integrated its supply chain information and inventory statistics with material planning and control through the distribution requirement planning to bridge the intra-firm system with the interfirm resources. The distribution centres located in Los Angles has forecast demand for auto parts for five weeks consisting of 30, 35, 60, 50, and 35 units. Also, 120 units are in transit due in week 2. For the Los Angles Centre, the transit time of auto parts is two weeks, and the quantity ordered is 120 units. Moreover, 60 units of auto parts are in hand. New York distribution centre has forecast demand for next five weeks is 90, 80, 110, 70, and 60 units. One week is the transit time of auto parts; 210 units are the order quantity where110 auto units are on hand. Moreover, a central warehouse in Houston has 600 units of order quantity and 500 auto units on hand with a lead time of 1 week. Questions: 1. Based on the above information, you are required to calculate the projected available balance of auto units, gross requirement, and planned order release for Los Angles and New York distribution Centre of Altens Ltd. (marks 4) 2. You are also required to calculate the gross requirement of units, planned order release, and projected available balance of the Houston central warehouse. (marks 2) 3. Since DRP allows the extension of MPC into the distribution system, MRP and DRP records formats also look similar. The DRP second row shows shipment in transit, whereas it is "schedule receipt" in the MRP record. Do you think that only the names of in transit row are different for DRP and MRP, or are their functions different? Explain your answer. (marks 4)