Read and complete the first case study from our Business Analytics eText. Your case study will...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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. 1. Note that any worksheets you will be working with are shaded in dark green. Survey Scale: North America South America 2. 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: Europe Pacific Rim Dealer Satisfaction End-User Satisfaction Mower Test Mower Unit Sales Tractor Unit Sales China 2014 2015 2016 2017 2018 0 2 0 2014 2015 0 2016 0 2017 0 2018 2014 0 2015 0 2016 0 2017 0 2018 0 oooo 0 1 2 3 4 5 Sample Size Area for your answers Ooo 3 0 1 1 1 2 4000 00000 J 13 00000 1100 22434 1 3 1 2 1 1 1 ANNNW 2014 2015 0 2016 2017 0 2018 0 0 1 2 2 66122 22438 76717 2 21 1 1 0 2 8 15 30 3 5 1 2 2 0 1 1 7 14 10 10 30 33 50 90 60 447600 3 0 8 50 50 Lea 1 3 2 100 125 15 15 25 30 30 55602 10 12 Region North America South America Europe Pacific Rim North America South America Europe Pacific Rim North America South America Europe Pacific Rim China North America South America Europe Pacific Rim China North America South America Europe Pacific Rim China Year Totals Totals Totals Totals Totals Gross Revenues 0 Industry N 5 1 H 3. 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.) 4. 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. 5. 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. 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. 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. 1. Note that any worksheets you will be working with are shaded in dark green. Survey Scale: North America South America 2. 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: Europe Pacific Rim Dealer Satisfaction End-User Satisfaction Mower Test Mower Unit Sales Tractor Unit Sales China 2014 2015 2016 2017 2018 0 2 0 2014 2015 0 2016 0 2017 0 2018 2014 0 2015 0 2016 0 2017 0 2018 0 oooo 0 1 2 3 4 5 Sample Size Area for your answers Ooo 3 0 1 1 1 2 4000 00000 J 13 00000 1100 22434 1 3 1 2 1 1 1 ANNNW 2014 2015 0 2016 2017 0 2018 0 0 1 2 2 66122 22438 76717 2 21 1 1 0 2 8 15 30 3 5 1 2 2 0 1 1 7 14 10 10 30 33 50 90 60 447600 3 0 8 50 50 Lea 1 3 2 100 125 15 15 25 30 30 55602 10 12 Region North America South America Europe Pacific Rim North America South America Europe Pacific Rim North America South America Europe Pacific Rim China North America South America Europe Pacific Rim China North America South America Europe Pacific Rim China Year Totals Totals Totals Totals Totals Gross Revenues 0 Industry N 5 1 H 3. 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.) 4. 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. 5. 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.
Expert Answer:
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these accounting questions
-
The single order, 2.4 million parts, will require you to borrow the entire purchase price. You will need to pay your lender 6.125% annual interest. Assume a one-time payment of principle and interest...
-
This assignment requires YOU to demonstrate your UNDERSTANDING about FINANCIAL PRINCIPLES* for businesses. Select any ONE LISTED company/corporation Find out INFORMATION about Financial Activities of...
-
This minor project asks you to demonstrate your understanding of the service-profit chain as applied to a specific company. Marshall introduces this in chapter 9 by claiming the New Dominant Logic in...
-
The electron affinity of oxygen is -141kJ/mol, corresponding to the reaction O (g) + e- O- (g) The lattice energy of K2O(s) is 2238kJ/mol. Use these data along with data in Appendix C and Figure 7.9...
-
Income statement relationships. Fill in the appropriate blanks for each of the independent situationsbelow Particulars Company A Company B Company C 540,000 90,000 343,400 S Sales Beginning Inventory...
-
In Problems 57, compute the value of the given expression. C(11, 5)
-
What is the role of the Federal Sentencing Guidelines in encouraging corporate ethical conduct?
-
Company uses a standard cost system and sets predetermined overhead rates on the basis of direct labor-hours. The following data are taken from the companys budget for the current year: The standard...
-
7. The full symbol of an ion of an element is 39X+? Which one of the following is the number of electrons in the ion? A. 18 B. 19 C. 20 D. 39 8. The atomic numbers of elements W, X, Y and Z are 9,...
-
Cherry Cotta makes custom ordered clay pots for residential gardens. Below is cost information regarding its latest job. a. Materials were purchased on account. $18,996 purchased b. A materials...
-
These two FEDERAL laws form the basis for legally required benefits. Social Security Act and Civil Rights Act Internal Revenue Code and Social Security Act Social Security Act and Family and Medical...
-
South African Airways (SAA) and Qantas Airlines held a duopoly on direct flights from Australia to South Africa. In 2014, Australias International Air Services Commission (IASC) indicated that the...
-
What are the steps in testing the quality of a strategy?
-
What are the three primary roles played by boards? How do boards carry out these roles?
-
What is the relationship between strategy formulation and strategy implementation?
-
Do you agree or disagree with the following statements? Explain in a sentence or two. a. A firm will never sell its product for less than it costs to produce it. b. If the short-run marginal cost...
-
A partner owns a 25-percent interest in a partnership. For the partnership tax year ended December 31, the partnership reports the following items of partnership income, gain, loss, deduction, and...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19 year-old nanny $125 per week for 48 weeks during the current year. a. What is the employers portion of...
-
What is the difference between periodic and perpetual inventory?
-
Using Exhibit 14-1, prepare common size ratios for Smith City for its governmentalactivities. Smith City Statement of Net Position As of June 30, 2014 Primary Govemment Governm Business-type...
-
Section C The programs at Denison consume the services of departments as follows: That is, oncology patients consume 80 percent of the services of the radiology department but only 50 percent of the...
-
Once the Consumer Product Safety Commission prohibits the sale of a particular product in the United States, a manufacturer can no longer sell the product to U.S. wholesalers or retailers. However,...
-
Penalties for individuals who have violated the FCPA can run up to \(\$ 250,000\) per violation and five years' imprisonment. Corporate fines can be up to \(\$ 2\) million per violation. Also, under...
-
Although the merits and problems of breast-feeding versus using infant formula are debated in the United States and other developed countries, the issue is not so balanced in third-world nations....
Study smarter with the SolutionInn App