WeChemical Industries is a leading Indian manufacturer of Speciality Chemicals and Pharmaceuticals with a global footprint. Chemicals manufactured by WeChemical are used in the downstream manufacture of pharmaceuticals, agrochemicals, polymers, additives, surfactants, pigments, dyes, etc. The Chemicals Division remains the cornerstone of WeChemical Industries. Using feed-stock materials, primarily of Benzene and Toluene, WeChemical has created highly integrated value chains. WeChemical Industries has 17 manufacturing units, at Vapi, Tarapur, Jhagadia, Dahej, Bhachau, Pithampur, Silvasa, Dombivali, Sarigam, 2 USFDA units and its HO is at Mumbai. Most of its factories are zero waste. It has over 4600 employees, 200+ products, 400+ global customers and 600+ domestic customers. 45% of revenue comes from global markets, of which US accounts for 26% and EU 25%. China and Japan, account for 10% each. It is the only domestic player to have products until the sixth level derivative of benzene chemistry. It also expects to leverage its existing clientele to promote its toluene and other derivatives. Most contracts are long term cost contracts that offer better control on the overall cost structure. WeChemical Industries Limited reported a 15.1% y-o-y (up 25.1% q-o-q) increase in its consolidated revenue to Rs. 1,173 crore. Revenues from speciality chemicals segment grew by 32.5% y-o-y to Rs. 1,109 crore and that from Pharmaceuticals segment increased by 21.8% y-o-y to 222 crores. The company has recognized $5 million in its revenues as compensation of cancellation of a long-term contract. Gross margin improved by 181 bps y-o-y to 50.7%, However, OPM at 21.7% (down 185 bps y-o-y) due to higher than expected operating cost (up 32% y-o-y). EBIT margin for speciality chemicals segment declined by 678 bps y-o-y to 17.1% EBIT margin for pharma segment remained strong rising by 702 bps y-o-y to 25.5% led by higher contribution from regulated markets and value-added products. The company expects an improvement in speciality chemical margin as domestic demand in respect of discretionary end-use sectors is likely to reach to pre-COVID-19 level in Q1FY2022 and exports markets are expected to progressively improve over next 2-3 quarters. WeChemical Industries would be a key beneficiary of the Chinese substitution factor along with rising domestic demand for speciality chemicals. Owing to strong order book visibility, WeChemical is in an aggressive expansion mode. Going ahead, WeChemical is likely to spend at least 1000-1200 crore per annum in the next three to four years to complete existing pipeline, expansion in value-added, pharma segments in the backdrop of strong demand visibility to drive long-term growth

You are working as a management advisor to improve performance. You have to prepare a high-level data strategy addressing the following key areas: a) What are the key questions Board will ask its executives for its monthly and quarterly review?

b) The data warehouse can be implemented to answer Board questions and operational level questions (i.e., strategic as well as tactical queries). Draw an appropriate and clear data warehouse schema to address these questions for the above scenario.

Particulars FY19 Net Sales (Rs. 4168 Crs) OPM (%) 23.2 Adjusted PAT 492 y-o-y growth 47.7 (%) Adjusted EPS 28.4 (Rs.) EV/EBITDA (x) 20.2 17.8 23.4 ROCE (%) ROE (%) FY20 4186 23.3 536 9.1 30.8 20.3 14.7 19.1 FY21E 4506 23.2 525 (2.2) 30.1 19.4 13.3 16.3 FY22E 5528 24.0 703 34.0 40.3 15.3 15.1 18.6 FY23E 6932 24.1 958 36.3 55.0 12.0 18.1 21.0