logo

Analysing Consumer Complaints from Product Family PF 10 (SUMPRODUCT)

   

Added on  2020-06-04

10 Pages1735 Words203 Views
SUPPLY CHAINANALYTICS

TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................11.1 Product family PF 10 (SUMPRODUCT).........................................................................11.2 Using the VLOOKUP formula in context with analysing the wrong product.................11.3 Analysing the monthly average complaints from product family....................................11.4 preparing the pivot tables in order to analyse the consumer complaints from the given dataset............................................................................................................................................11.4.1 Total complaints raised by customers:.....................................................................11.4.2. Total complaints raised by Complaint types:..........................................................21.4.3. Total complaints raised by Product family:.............................................................31.4.4. Total complaints raised by CSR staff:.....................................................................41.5 Bar chart of the given data set..........................................................................................5TASK 2 Problem definition:............................................................................................................5TASK 3 Solution and Suggestion:...................................................................................................5CONCLUSION................................................................................................................................6REFERENCES................................................................................................................................7

EXECUTIVE SUMMARYIn order to analyse the supply chain managements of the corporatisation there has been variouscategories and variables which has been making the adequate analysis through the consumerbehaviour and preferences. This, report is being helpful in providing the accurate solution anddetermination to the problems over the electronic company. It helps in analysing the utilisationof the various techniques to identify the supply chain mechanism in this corporations. There willbe examination over the data set such as CSR staff, product families, Consumer complaints etc.variable which were being analysed and determined as to have appropriate suggestion andsolution to the company.

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
(SCM)Supply Chain Management Assignment
|9
|1262
|134

Value Chain Analysis
|4
|1136
|78

Supply Chain Analytics Report 2022
|11
|2612
|21

Supply Chain Analytics
|9
|1569
|1

Value Chain Engineering: Analysis of Complaints and Recommendations
|10
|1415
|88

Value Chain Engineering Systems | Assignment
|8
|1341
|32