Order from us for quality, customized work in due time of your choice.
2 Questions : *Attached screenshots of question*
QUESTION 1:
Keywords: Descriptive Analytics, KPIs, Excel Analysis ToolPak, Supply Chain
Decision-Making Context: Understanding what happened in the past is an important first step in harnessing the power of business analytics. Descriptive analytics answers the questions “What happened?” and “What is happening?” Exhibit 10.8 presented supply chain key performance indicators (KPIs) for the entire retail and wholesale trade industry. In this lab, you will calculate KPIs and then use the built-in functionality of Excel’s Analysis ToolPak to generate descriptive analytics for supply chain data for two specific retail companies, Amazon (ticker: AMZN) and Walmart (ticker: WMT), for the period 1999–2021.
Required:
Calculate the following supply chain KPIs: cash-to-cash cycle, asset turnover, inventory-to-sales ratio, and inventory turnover.
Calculate descriptive analytics for the KPIs.
Create a box-and-whisker plot for inventory turnover.
Data: Lab 10-1 Data.xlsx
Specify the Question: What are selected supply chain KPIs for Amazon and Walmart?
-Upload the Word or PDF document containing your Lab screenshots using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
*****Take a screenshot of the completed descriptive statistics tables for Walmart and Amazon, copy it into a Word document named “Lab 10.1 Excel Submission.docx”, and label the screenshot Submission 1. Take a screenshot of the box-and-whisker plot, copy it into the same Word document, and label the screenshot Submission 2.
QUESTION 2:
Keywords: Diagnostic Analytics, KPIs, Hypothesis Test, Supply Chain
Decision-Making Context: Understanding what happened in the past is an important first step in harnessing the power of business analytics. Diagnostic analytics attempt to find the root cause by answering the questions “Why did it happen?” and “What are the causes of past results?” Hypothesis testing is a diagnostic analytics technique used to test whether variables are significantly different. In this lab, you will test whether selected supply chain KPIs are different for Amazon and Walmart during the period 1999–2021. Managers may perform this type of analysis to see how their company’s operations compare to other companies in the industry and to identify areas for improvement.
Required:
Perform hypothesis tests to determine if selected supply chain KPIs (asset turnover, inventory-to-sales ratio, inventory turnover) are different between Amazon and Walmart.
Create a scatterplot for asset turnover values from 1999 to 2021 for both Amazon and Walmart.
Data: Lab 10-3 Data.xlsx
Specify the Question: Are selected supply chain KPIs (asset turnover, inventory-to-sales ratio, inventory turnover) for Amazon and Walmart different?
-Upload the Word or PDF document containing your Lab screenshots using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
******Take a screenshot of the t-test for asset turnover, copy it into a Word document named “Lab 10.3 Excel Submission.docx”, and label the screenshot Submission 1. Take a screenshot of the t-test for inventory-to-sales, paste it into the same Word document, and label the screenshot Submission 2. Take a screenshot of the t-test for inventory turnover, paste it into the same Word document, and label the screenshot Submission 3. Take a screenshot of the asset turnover scatterplot, paste it into the same Word document, and label the screenshot Submission 4.
Order from us for quality, customized work in due time of your choice.