Operation management Case: The 2L company, producer of Bottled Wines, presents the following data: Diagram of the Filtration line: Activities Time Predecessor (Secuancial) (MIN) TO 20 2 B. 50 TO C. 110 D. 140 B.C JaUAW 60 A F 20 B, C G. 80 E,D In addition, the following data is available Line Amount of operator by Maximum Line Production (720 hours Teams Team (per turn) per month) Filtered out 2 36000 Lts Bottling 2 3 48000 bottles Note; Each bottle is 750 cc. Consider that a month has 30 days (since it is 24/7 production) The availability of the equipment for April is 80%. While the monthly demand (in bottles) for previous periods has been 85% of production.The quantity demanded in the last months has been: Month Real Demand Bottles October 35000 November 32000 December 27000 January 35000 February 32000 March 36000 April XXXXXXX Consider that the current costs (March) of the company are, which are readjusted in a 12% for April: Productive Costs monthly Direct Labor $27000000 Variable costs $18000000 Maintenance $12000000 Direct Energy $19000000 With the background information delivered, the following is requested: 1.-(10 pts) Diagram the process of Filtering Line 1, point out its main characteristics. 2.-(20 pts) Total and partial productivity per line for the month of March, considering the 4 key factors, and compare it with the month of April (after determining the demand forecast, using this option as data associated with the production, according to the rule indicated on sheet 1) You must explain your results and calculation values. 3.-(40 pts) Estimation of the demand (April) based on the following table, indicating which option is the best, its reasons and arguments, as well as explaining the best calculated error (MAD), Finally determine the monitoring signal (TE) of the SES and RSL methods comparing and explaining their results:Month Actual PMS (2 PMP (60 y SES (alpha of Error Reg Error months) 40) t-1/t-2 0.6) Lineal October 35000 31000 November 32000 December 27000 January 35000 February 32000 March 36000 April XXXXXXX 4.-(20 pts) Determine the Utilization rate for each month (including April according to your dda projection analysis) according to the following table, explaining the result for each month. Month Production (Actual) Actual Demand UI October 35000 November 32000 December 27000 January 35000 February 32000 March 36000 April 5.-(10 pts) If the company intends to satisfy, from May (after the requested period) onwards, a demand of 40% more than the average of the last 7 months of registration indicates. 5.1.- Necessary production per month. 0 5.2.- Increasing number of collaborators and their justification. The delivery must be made: a.- Excel, complete b.- Explanatory Word of each question. (names of members at the bottom of the page)