You are a supply chain analyst employed by an electronic company to analyze data and find outproblems and suggest solutions. The data in the spreadsheet is pulled out from ERP system of thecompany which is active in the electronic industry. They got 20,000 Square meter distributioncenter (DC) with local and international customers. The company’s suppliers send products fromoverseas and domestic locations. They have different ranges of customers from whole sales,retailers and end-users. The DC / warehouse have 30,000 stock keeping units (SKU), materialand lifts machines and other equipment. The warehouse staffs are including DC Manager, supplychain analyst, inbound and outbound supervisors and 50 employees.Recently they have received numerous customer complaints which make sales and customerservice representative (CSR) department sick of hearing angry customers’ voice. Your mangerhas asked you to analyze the customer complaints data to find out problems and come up withsolutions.RequirementsTask 1- AnalysisYou need to analyze the data with Microsoft excel software in terms of- Total complaint by customer- Total complaint types- Total Customer Complaints Raised by Product Family- Total Complaints Raised by CSR staffsNote: use formulas, pivot table, linking graphs to pivot table, etc.Task 2- Problem definitionAfter data analysis, find out top 3 problems in terms of complaint types, product family, andcustomer and CSR staff.Task 3- Suggestion and SolutionAfter finding the problems, provide your solution and methodology to your manger. Yoursolutions should be extracted from recent scholarly books/articles/reports and cause root analysisand might address following DC processes including;Page 3 of 5- Inbound or receiving (DC/warehouse inbound)- Put away and operations- Warehouse Layout- Outbound or dispatch (DC/warehouse outbound)- Warehouse Staffs- Machines (Forklifts, pallet Jack, etc.)- Equipment, etc.DeliverablesAfter completing the assignment, submit the following:1- Spreadsheets Analysis (Excel file) – Softcopy must be submitted through Turnitin(UTSOnline). For the Excel file no need to submit hardcopy.It should show your excellent analysis skills with excel including formulas, pivot table,linking pivot table to graphs, etc.2- Report – Please see what should be in your report (Report writing) in assessmentresources in UTSOnline.Your hard copy is to be submitted to your lecturer at the beginning of the week 5 lecture andyour soft copies will be submitted electronically through UTSOnline