Problem Statement Project Description Plastique Ltd., established in 1970, is a manufacturer of plastic products. Starting from a small, family-run business with a small core team, it has grown into a well-known household name. The companys financial statements showed revenue of 200 million for its three business units. Plastique Ltd. produces 120 product groups, with 600 end products. It offers 3 brands in eight market segments. It acts as a raw input provider for a multitude of industries ranging from retail and healthcare to automotive parts. Because of the scale of the operations, the company has set up three in-house plants,with the total annual production capacity amounting to 150 million kgs per annum. The plants operate for 25 days per month or 300 days per annum. The table below provides the distribution of plant capacities and the number of types of products each plant produces.

Furthermore, each plant has 12 operations associated with the production -process. These can be considered as the 12 work centers. Each plant has a set of 12 operations that relate to the specific products being produced at the plant. For example, if P1 produces mugs, then only P1 can produce mugs. In case P1 not operational, the production of mugs halts. Mr x, the CEO of Plastique Ltd., has asked the operations manager to provide a forecast of the demand for the upcoming fiscal year for the products produced by P2. The forecast is detailed in the file attached to the link provided below. Forecast Data The first tab of the sheet of the file contains details of the companys performance and the accuracy of the forecast for the last 3 months of the financial year 2019-2020. The second part of the table details the plants plan for production, along with the capacity and the demand forecast data generated by the demand planner. The second tab of the sheet of the file provides details on the sales for the previous fiscal year and maps it to the demand forecast.

Questions to be addressed for the solution: 1.Based on the sales data in the second tab of the sheet (Sales data) for the period Apr-19 to Mar-20, you are required to generate the forecast for the next 12 months period (Apr-20 to Mar-21) using suitable techniques and compute the corresponding forecast error metrics.

2.Based on the above, which technique is more reliable and why? How effective are your forecasted figures compared with those of the demand planning team as shown in the first sheet (Production Data)?

3.Is the aggregate production capacity in P2 sufficient to meet the expected future demand? Would there be a need for contract manufacturing (outsourcing) in the future?

4.Calculate the aggregate monthly Closing Inventory (CI) and Production Plan (PP) based on the following inputs? What is the impact on CI and PP if the Safety Stock (SS) level is altered, i.e., increased by 3%?

Safety Stock (SS) = 30% of the Monthly Demand Forecast (DF) Production Plan (PP) = Demand Forecast (DF) + Safety Stock (SS) - Opening Inventory (OI) Closing Inventory (CI) = Opening Inventory (OI) + Production Plan (PP) - Demand Forecast (DF) Consider 'Opening Inventory (OI)' = 3.1 Million Kgs (At the end of Mar-20) Closing Inventory (CI) at the end of month (M) = Opening Inventory at the start of month (M+1) Calculation Period = Apr-20 to Sep-20 (6 Months)

plant	P1	P2	P3	Total
Number of types of products	200	225	175	600
Production Capacity	45	55	50	150

Sales Data
Period	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20
Actual Sales	4.65	4.42	4.45	4.21	4.4	4.67	4.48	4.61	4.58	4.52	4.21	4.1
Demand Forecast	4.6	4.49	4.5	4.25	4.32	4.58	4.52	4.66	4.71	4.58	4.35	4.22

Production Data	Previous Period Review	Planning Horizon - Forward 12 Months
Operations Parameters	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21
Actual Sales	4.52	4.21	4.1
Actual Production	4.6	4.02	4.25
Production Plan	4.37	4.15	3.9	4.5	4.51	4.6	4.25	4.95	4.7	4.45	4.75	4.6	4.48	4.7	4.44
Demand Forecast	4.58	4.35	4.22	4.7	4.3	4.82	4.1	4.8	4.74	4.6	4.79	4.77	4.43	4.79	4.4
Production Capacity	4.4	4.5	4.55	4.6	4.7	4.58	4.65	4.77	4.74	4.52	4.8	4.57	4.67	4.72	4.5
Unit of Measure [UOM] is in Million Kgs