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
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..
|