Pareto analysis to the chart of top ten commodities

Assignment Help Supply Chain Management
Reference no: EM131358141

1. You have been given spend data sorted by descending dollar. Sort by Commodity.

2. From the commodity sort, find the total spend by Commodity (hint: the subtotal or pivot table functions in Excel can help). Calculate the total spend by Commodity.

3. Make a chart of the top ten commodities by descending $ Spend. Print the chart and include with your case write-up.

4. From the commodity sort, find the number of suppliers by Commodity (hint: the pivot table function in Excel can help). Perform a descending sort of number of suppliers by commodity.

5. Make a chart of the top ten commodities by descending number of suppliers.  Print the chart and include with your case write-up.

6. From the commodity sort, find the average spend per supplier by Commodity. Perform an ascending sort of average spend per supplier. Print the chart and include with your case write-up.

Spend Analysis Questions

1. Applying the concept of Pareto analysis to the chart of top ten commodities by descending $ spend, write a ½ - 1 page executive summary of your recommendation for cost savings opportunities.

2. Applying the concept of Pareto analysis, write a ½ - 1 page executive summary of your recommendation for supplier consolidation.  Also discuss which chart(s) you used to make the recommendation and why.

Attachment:- Assignment Data.rar

Reference no: EM131358141

Questions Cloud

Exploring website coding practices : From the e-Activity, describe what you learned about the Website that you selected by looking at the source code. Analyze the different components of the Website such as the version of HTML that was used, comment tags, and if the head elements wer..
Write a definition essay post on the term motivation : Identify future writing skill needs and your motivation to improve deficiencies - Discuss importance of completing all assignments on time and incorporating instructor feedback.
Analyze psychological profiling in law enforcement : There is a documented psychology to criminal investigators and investigations. It is important to analyze how our biases and assumptions influence our assessment of individuals and to analyze and understand psychological profiling in law enforceme..
Experience installing the microsoft office suite software : Describe your experience installing the Microsoft Office Suite software. Indicate the version of the software that you installed, and the name and version of the operating system that you used.
Pareto analysis to the chart of top ten commodities : Applying the concept of Pareto analysis to the chart of top ten commodities by descending $ spend, write a ½ - 1 page executive summary of your recommendation for cost savings opportunities
Discuss companys likely future purchases for cybersecurity : CSIA 350 6381 (2172)- A separate "Buying Forecast" section in which you discuss the company's likely future purchases for cybersecurity products and services.
Discuss the advantages to using hierarchical addressing : Discuss the advantages to using hierarchical addressing and its relevance to this week's VLSM topic. How does hierarchical addressing help with routing efficiency?
Compute the transformation matrix for a lamina : Compute the reduced stiffness [Q] and compliance [S] matrices, and the intralaminar shear stiffness [Q∗ ] and compliance [S ∗ ] matrices for a lamina with E1 = 35 GP a, E2 = 3.5 GP a, ν12 = 0.3, G12 = 1.75 GP a, G23 = 0.35 GP a
Explain the major ethical implications of the selected study : Briefly summarize the main details of your chosen social psychology research study. Identify the main research method(s) used in the study (e.g., case study, experiment, observation, etc.) - Discuss whether or not you believe the research methodolo..

Reviews

Write a Review

 

Supply Chain Management Questions & Answers

  What is the economic justification for the rapid growth

Compare and contrast the transportation principles of economy of scale and economy of distance. Illustrate how they combine to create efficient transportation - What is the economic justification for the rapid growth of premium package services?

  Practice of supply chain management

What roles do collaboration" and "trust" play in the practice of supply chain management?

  Explain the supply of nitrogen cannot be interrupted

Fiberglass components are being sanded smooth prior to painting by assembly line workers. A leak in a nitrogen supply line within a service closet requires repair but the supply of nitrogen cannot be interrupted.

  International company operates four factories

The Thor International Company operates four factories that ship products to five warehouses.

  Critical reflection on your experience

What major learning on managing the value chain can apply in practice as a manager in your organisation - view of managing the value chain before entering this subject and how this has, or hasn't changed.

  Why is a state-of-the-art wms critical to the operation

Why is a state-of-the-art WMS critical to the operation of a modern warehouse -  WMS drives efficient parts distribution. Modern Materials Handling

  Key qualities and technical elements

The North Bristol NHS specification which is rather ambiguous and does not give a clear directive on the key quality and technical elements that their ideal solution would offer them".

  Purchasing strategy and strategic purchasing

purchasing strategy and strategic purchasing, corporate and competitive strategie

  Product for ebbd from kentucky hooch and beer company

Ordering product for EBBD from the Kentucky Hooch and Beer Company - During the simulation (the one that you are going to use in your report), you should keep track of the highest levels of Customer Backlogs, EBBD Order Backlog, and levels of EBBD ..

  Supply chain description working in the same group you will

description working in the same group. you will prepare a report analysing a selected value chain same as your group

  How global sourcing and procurement impact effectiveness

How does global sourcing and procurement impact the overall effectiveness of the supply chain? What are the benefits and challenges that have occurred when outsourcing logistic and other functions?

  Calculate the change in the weighted distance

1.Baker Machine Company Is a Job shop that specializes in precision parts for firms in the aerospace industry.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd