Introduction This case study is designed to evaluate your ability to analyze financial data, draw meaningful insights, and present findings effectively. As a Financial Reporting Unit Head in Department of Culture and Tourism, your role is instrumental in creating perceptive reports that guide the management team in making informed financial decisions. Your primary responsibility involves developing the monthly management report, offering a comprehensive overview of the financial performance of various sectors and departments within DCT. Your insights and analyses are crucial in aiding the management team in formulating corrective action plans as needed. Dataset Overview The dataset comprises dummy variables representing different aspects of the organization's operations. You will analyze these variables, identify trends, and present key insights to the executive team. Your task is to develop an annual management report, showing the expenditure and revenue performance. You will focus on OpEx and CapEx while excluding payroll and CWIP. Examine the dataset to understand variables and distributions, identify trends in revenue and expenses, assess financial performance across sectors/departments, and conduct variation analysis between planned and actual (expenditure and revenue).Utilize visualizations like charts and graphs to effectively communicate key findings, draw insightful conclusions, and propose recommendations for improving financial performance./nNeed summary for the files as the question posted above for all the 4 files (Expenditure, budget, revenue and cashflow) The data sample is for DCT: Department of Culture & Tourism Need to submit a word document (no word limits, depeds on the data and the summary you will do )and you can make the analysis in Excel

Fig: 1

Fig: 2