Value Chain Engineering Systems - Supply Chain Analytics - Management Assessment Answer

Management Assessment Answer

Task 1- Analysis You need to analyze the data with Microsoft Excel software for several subtasks below: 1.1 Count the number of complaints for PF13 (using COUNTIF formula). 1.2 Display the name of the customer who most frequently complained (using INDEX formula with other possible formulas). 1.3 List all complaint types raised by the customer identified in the task 1.2 (using VLOOKUP formula with other possible formulas). 1.4 Establish four pivot tables in a new sheet called “Executive Summary” for the Customer Complaints Database in terms of: 1.4.1 Customer complaint type by product family 1.4.2 Complaints raised by CSR Staffs 1.5 Create a bar chart for each pivot table, providing the count of the data in descending order. 1.6 Identify top most product family associated with errors (product, quantity, and invoice) Task 2- Problem definition After data analysis, find out top 3 problems in terms of complaint types, product family, and customer and CSR staff respectively. Provide your cause root analysis for these problems to find out what are the reasons causing these problems. Task 3- Suggestion and Solution After defining the problems, provide your solutions and methodologies to your manager. Your solutions should be extracted from recent scholarly books/articles/reports (in the past three to five years) and cause root analysis and might address the following DC processes including:

1. Inbound or receiving (DC/warehouse inbound)
2. Put away and operations
3. Warehouse Layout
4. Outbound or dispatch (DC/warehouse outbound)
5. Warehouse Staffs
6. Machines (Forklifts, pallet Jack, etc.)
7. Equipment, etc.

This Management Assessment has been solved by our Management experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.