$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

49680 Value Chain Engineering Systems

tag 0 Download5 Pages / 1,239 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Overview

You are a supply chain analyst employed by an electronic company to analyze data and find out problems and suggest solutions. The data in the spreadsheet is pulled out from ERP system of the company which is active in the electronic industry. They got 20,000 Square meter distribution center (DC) with local and international customers. The company’s suppliers send products from overseas 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), material and lifts machines and other equipment. The warehouse staffs are including DC Manager, supply chain analyst, inbound and outbound supervisors and 50 employees.

Recently they have received numerous customer complaints which make sales and customer service representative (CSR) department sick of hearing angry customers’ voice. Your manger has asked you to analyze the customer complaints data to find out problems and come up with solutions.

Requirements

You need to analyze the data with Microsoft Excel software for several sub tasks below:

1. Count the number of Product Family for PF12 (using COUNTIF formula).
2. Display the name of the customer who most frequently complained (using INDEX formula with other possible formulas).
3. List all complaint types raised by the customer identified in the task 1.2 (using VLOOKUP formula with other possible formulas).
4. Establish four pivot tables in a new sheet called “Executive Summary” for the Customer Complaints Database in terms of:
- Total complaints by customer
- Total complaint types
- Total Customer Complaints Raised by Product Family
- Total Complaints Raised by CSR Staffs
- Create a bar chart for each pivot table, providing the count of the data in a descending order.

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.

After defining the problems, provide your solutions and methodologies to your manger. 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:

  • 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.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2021) Value Chain Engineering Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/49680-value-chain-engineering-systems/the-customers-of-an-electronic-company.html
[Accessed 15 April 2021].

My Assignment Help. 'Value Chain Engineering Systems' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/49680-value-chain-engineering-systems/the-customers-of-an-electronic-company.html> accessed 15 April 2021.

My Assignment Help. Value Chain Engineering Systems [Internet]. My Assignment Help. 2021 [cited 15 April 2021]. Available from: https://myassignmenthelp.com/free-samples/49680-value-chain-engineering-systems/the-customers-of-an-electronic-company.html.


Getting nightmare regarding pending chemistry assignment? Then it is high time you consider hiring chemistry assignment help service of MyAssigemnthelp.com. We at MyAssignmenthelp.com deliver quality subject specific assistance on more than 100+ subjects. For us, students' need is foremost, and we work round the clock to offer science, humanities and commerce assignment help. Among Commerce wing, our one of the most popular services is capital budgeting assignment help. In science segment, we have gained popularity with biology assignment help.

Latest Management Samples

MGT602 Business Decision Analytics

Download : 0 | Pages : 10

Answer: Introduction Innovative or creative techniques were adopt continuously by the working environments to bring groups people to work within a firm. The establishment of virtual team has resulted significantly in overcoming globalization. The concept of communication with the team members adopted by the virtual groups on the base of companies activities. This paper is about two scenarios- Scenario A and Scenario B. Scenario A will clearly...

Read More arrow

MNG93003 Industry Research Project

Download : 0 | Pages : 3

Answer: Template Report title The effect of employee performance appraisal on organisational productivity: A case study of Dominos Pizza Industry partner The business partners of Dominos include Kagome, Ingham, Visy, JBS and Primo. Dominos Pizza is one of the leading restaurants that serve pizza. It was founded in 1960 and since then has developed into a strong brand in the world. The number of employees working in ...

Read More arrow

MKT01907 Tourism And Hospitality Management

Download : 0 | Pages : 5

Answer:  Introduction:  The report is based on reviews of “Hospitality workforce in Thailand and ASEAN” article that was written by (Plangpramool et al., 2015). First of all, the article summary will be providing with the help of Critical Thinking framework. Afterwards, the article flaws will be critically identified as well as analysed thoroughly followed by a conclusion containing the key findings.    Articl...

Read More arrow

BUSN20017 Effective Business Communication

Download : 0 | Pages : 6

Answer: Opening a) To: The members of the Turkey Farmers Association of Australia b) From: ABC, the President of the Turkey Farmers Association of Australia c) Date: 01/Jan/2019 d) Subject: Launching an Australia-wide media campaign Objectives and background a) Communication audit process- The communication audit process that is used for the campaign is that of comparing the CPM cross the television, radio, magazines and newspapers...

Read More arrow

RELIG 1100 Religious Studies

Download : 0 | Pages : 8

Answer Introduction Theologians, historians, philosophers along with common men have long been pondering on the identity of Jesus along with his attributes and purpose. According to Bockmuehl, Jesus posed questions to his disciples who people of His day perceived he was and further offered explanations ranging from John, the Baptist to one of the prophets of historic times. Several common men perceived Jesus as the son of living God which exh...

Read More arrow Tags: United States Florida Management University of Florida 
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,647,755

Orders

4.9/5

Overall Rating

5,121

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2830 Order Completed

97% Response Time

Leroy Bicknell

MBA in Marketing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Thank you so much for your support and quick turn around. I really appreciate it.

flag

User Id: 667737 - 14 Apr 2021

Australia

student rating student rating student rating student rating student rating

Excellent service. First I had an inconvenience with my assignment but it was quickly sorted out within 24 hours of me reporting it and was giving an excellent paper. Perfect wording and citation. Just remember that these are human being that are wor...

flag

User Id: 659071 - 14 Apr 2021

Australia

student rating student rating student rating student rating student rating

I have been using myassignment help for over 2 years now and I continue to be impressed with their quality of work, on point turn around time for assignments and professionalism with customer service. No dissapointments so far. Keep up the good work...

flag

User Id: 225971 - 14 Apr 2021

Australia

student rating student rating student rating student rating student rating

i ask to redo the work and the exert did a great job correcting and redoing it. Thank you sooooo much

flag

User Id: 544546 - 14 Apr 2021

Australia

student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?