Supply Chain Analytics - Ecnomics Assignment Help

Assignment Task:

Task 1- Analysis 
You need to analyze the data with Microsoft Excel software for several sub-tasks below: 
1.1 Count the number of complaints about PF12 (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 task 1.2 (using VLOOKUP formula with other possible formulas). 
1.4 Establish pivot tables in a new sheet called “Executive Summary” for the Customer Complaints Database in terms of: 
1.4.1 Customer complaint type by customer name 1.4.2 Complaints closed 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 topmost product family associated with errors (quantity, and invoice) 
Task 2: One of the main reasons for complaint type “Delivery” was found to be with the insufficient inventory on hand to fulfill customer requests on time. To solve this issue, the DC manager tried to improve warehouse inventory policies for the product with the highest demand. The forecast for this product is 500 units for the first half-year and then 1000 units for the next half year. The holding cost was estimated to be $2.5 per unit per month and the ordering cost was $65 per order. By taking appropriate assumptions, determine an order size that will minimize the inventory costs for each of the six-month period. Which models will be appropriate if demand varies substantially for each 6-month period. 
 
Task 3- Problem definition 
After data analysis, find out the top 3: complaint types, product family, and customer and CSR staff respectively. Provide your cause root analysis for top complaint types based on your understanding of the subject thus far. 
Task 4- Suggestion and Solution 
After identifying complaints in Task 2, provide your solutions and methodologies to your manger. Your solutions should be extracted from recent scholarly books/articles/reports (in the past 3 to 5 years) and root cause analysis and might address the following DC processes: 
- 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. 
 

This Economics Assignment has been solved by our Economics 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.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.