a) Apply the following three forecasting models to predict April's demand for each customer. 1 > i) 4-month moving average ii) Exponential Smoothing with a = 0.4|| iii) Trend Line (regression) 1 b) Use Mean Squared Error (MSE) evaluation method to select the best forecasting model for each customer. Report-MSE of each forecasting model for each customer. 1 c) For each customer, put April's prediction of the best model in the table below: 1 g Customers g 1 2 38 g g 8 April-Demand og 1 d)- Use Excel to solve a transportation problem for the month of April.based on cost, supply and demand-information of yellow tables. (If you could not-solve parts a, b, c, use demands of:55, 65, and 70 for customers 1, 2, and 3 respectively). You should make sure that demand of the customers is satisfied, and supply capacity of the suppliers is not violated. Can you solve this problem? What is the minimum transportation cost for this problem?- 1 Question 3) (35 points) Consider a transportation problem. There are a set of suppliers and a set of customers in a region. The customers have their known-demand of a specific product. Suppliers have supply capacities for the product. An operations manager wants to make shipment decisions, i.e., how many items to ship from each supplier to each customer, subject to the demand requirements and supply capacities. The cost and supply.information are presented below. 1 og 8 Supplier A Customers Supply 1 2 3 Capacity $7 $ 10 $10 50 $9 $5 $9 50 $10 $10 $7 50 $10 $8 $5 50 BR C8 D: 1 We want to determine a shipment plan to satisfy customer's demand in the month of April. We do not have demand-information for April. But we have historical-demand-data for the previous 11 months for each of the customers. Demands Customer 18 Customer 2 Customer 3818 48 55 308 46 47 458 53| 43| 33 58 60 608 g Periods Month 1 May 2 June 3 July 4 August 5 September 6 October 7 November 8 Decemberg 9 January 10 February 11 March 52 54 62 67 54 65 46 45 69 44 69 71 55 998 1028 107 74 44 75 33 103 1