Question.2584 - Case Study Assignment 1 Instructions Read and complete the first case study from our Business Analytics eText. Your case study will require you to demonstrate your understanding and application of business analytics concepts. You will be asked to complete Excel functions and tasks and answer questions from the text. Your case study will be found in Chapter 1. Some of the numbers listed in your text will be different from the file provided to you. Use the file provided in the Content area of our course, week 3, Case Study Assignment 1 Excel File. Worth 50 points, your case study will explore concepts covered in Weeks 1, 2 and 3 and encourage critical analysis. Your case study will ask for opinions and recommendations. Your claims should be supported by evidence including references from the text, valid outside resources, or rational arguments. Your case study should exhibit strong structure and organization. A concise introduction with a clear preview, a well-written body using complete sentences, in-text citations when necessary and a clear summary in the conclusion are expected. Excel functions you will use include SUM, division, multiplication, COUNTIF, copy and pasting, Gross Sales are overall sales unadjusted for costs, and Market Share (corporation total sales/ industry total sales). You will also need to use filtering and sorting. Aside from just describing the analysis, discuss your interpretation of the data. You may include images from your analysis in the report, but images should not constitute the majority of the report. If you use a table or image, you must spend some time discussing it within the body of the text. A good rule of thumb is at least a paragraph of text to describe each image. College-level writing is expected, points will be deducted for grammar and spelling errors. Include and upload your accompanying Excel file. Your submission must be in APA format. Include a title page with your name, case study title, and date. Your report should be at least 2 full pages, 1-inch margins 12-point Times New Roman font, double-spaced. References and citations must be provided. Your Reference List should be provided at the end of your paper. Your report should be submitted in Word (.docx) format. Information for downloading MS Office 2016 for free is provided in the "Start Here" module. Please refer to the Case Study Assignment tab in the Assignment Overview module for a copy of the rubric for evaluation of your Case Study. Your submitted Excel file will be evaluated under the Content section of the rubric. Make sure you complete each of the tasks listed in your eText for PLE Case Study 1. Here are some details you need to complete the file. Note that any worksheets you will be working with are shaded in dark green. Check your text to understand what you are being asked to do. For Dealer Satisfaction and End-User Satistaction, start with year 2014 for first set of data you copy. The next set will be for 2015, then 2016, 2017 and 2018. This exercise will give you practice copying, pasting, and manipulating data in spreadsheets. The areas shaded in green in the worksheet are the areas where you will input the appropriate data, formulas, functions, etc. For example, on the “Dealer Satisfaction” worksheet, the answer area is shaded: The new worksheets referenced in numbers 3 and 4 have already been created. They are labeled “Gross Revenues” and “Market Share”, respectively. You will need to use an absolute cell reference when creating formulas for Gross Revenues. (Note the additional worksheets are provided for reference.) Place your name in each worksheet in cell A201 and your student number in A202 to receive credit for your Excel worksheets for this assignment. Summarize your findings and observations in your Word document report. Provide recommendations for future decisions, supported by data from your Excel worksheets. Think about any potential areas for growth and ways to increase profits. Reread the case study in your text for context and ideas for areas you could address in your report. You must submit both your Excel file and Word document to the Dropbox. Your Case Study Assignment is to be submitted to the appropriate Dropbox by 11:59 pm CT Sunday of Week 3.
Answer Below:
The assessment of the data shows the manner in which there has been review of the dealer satisfaction and other details. Dealer satisfaction has been increasing consistently in all regions except China where top ratings of 5 have not been rising in relation to the sample size. End-user satisfaction has remained consistent in all regions within the period of 2014 to 2018. Highest level of satisfaction within the consumer base has been received in the year 2018. Such kind of assessment explains the quality of services and management of the work needs in the region. The use of COUNTIF function has been necessary to calculate Mower Test Function. It explains the manner in which tests have been marked as failed for a number of 61 times. It explains the manner in which the tests have failed on 61 occasions. The review of the gross revenue figures shows two trends. First, there has been rise in gross revenues in the period Jan, 2014 to Mid-2016. Thereafter there has been a slump in the overall engagement of the revenues. Second, post the slump in revenues in the period of mid-2016, there has been revival of the growth of the gross revenues. The assessment of the data of market share is managed using discussion function. North America has consistently increased overall market share which reflects the importance of the region in overall business growth. South American market has also risen in market share but at a lower rate. Europe and Pacific region has experienced consistent decline in the overall market share.More Articles From Accounting
.ico)
.ico)
.ico)
.ico)
