Which types of wine were the best and worst sellers?
DATESHET 1
QSO 320 Milestone One Guidelines and Rubric Overview: It is essential for a business professional to develop spreadsheet software skills for analyzing a variety of business situations using quantitative means. This project takes a hands?on approach by placing you in a real?world context. You will utilize technical concepts to interpret a business framework and apply selected quantitative techniques to arrive at accurate information that can be used for sound decision?making. Specifically, you will assume the role of a business analyst working for a winery in northern California. In this milestone, you are provided a set of raw data, and, from that data set, you must respond to questions from management. You will calculate and present your answers in a consumable way using spreadsheet software. Prompt: Review the critical elements below and then examine the Excel 2013 Bible chapters assigned for Module One as well as the Final Project Excel Functions document. Select a function that you believe will help you answer the following questions based on an analysis of the final project raw data set provided. Specifically, the following critical elements must be addressed:
1. What were total sales by salesperson? 2. What were the total sales of red wine in California over the last six months? Draft this answer graphically and in a way that shows each different
salespersons sales. 3. Which types of wine were the best and worst sellers? Again, draft this answer graphically showing all wine sales by type of wine.
Note: Be sure to properly label each of your graphs for clear interpretation purposes. Guidelines for Submission: Submit a document that communicates your answers, using a graph where indicated.
Critical Elements Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value Data Analysis: Sales by
Salesperson Correctly determines the total sales by salesperson
Determines the total sales by salesperson, but answer is incomplete or has inaccuracies
Does not determine the total sales by salesperson
20
Data Analysis: Total Sales of Red Wine
Accurately and comprehensively presents the total sales of red wine in California over the last six months
Presents the total sales of red wine in California over the last six months, but answer is incomplete or has inaccuracies
Does not present the total sales of red wine in California over the last six months
40
Data Analysis: Best and Worst Sellers
Accurately and comprehensively presents the best and worst sellers by types of wine
Presents the best and worst sellers by types of wine, but answer is incomplete or has inaccuracies
Does not present the best and worst sellers by types of wine
40
Total 100%
The post Which types of wine were the best and worst sellers? appeared first on Class Assignments Help.
Which types of wine were the best and worst sellers? was first posted on September 12, 2022 at 12:54 am.©2019 “Class Assignments Help”. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at admin@cipdpro.co.uk
“0.
Discount Code: 0
: +1 0 0-0
0..
