Imagine that you are a business analyst working for a winery in northern California. In two different tasks, management will be asking you specific questions to which you must respond using spreadsheet software. The answers to each can be submitted in separate files or compiled into a single file, as you deem appropriate for clearly communicating with your key stakeholders.

Data Analysis: Use the provided raw data set and select from the provided formulas, to answer the following questions from management:
A. What were total sales by salesperson?
B. What were the total sales of red wine in California over the last six months? Present this answer graphically and in a way that shows each different salesperson’s sales.
C. Which types of wine were the best and worst sellers? Present this answer graphically showing all wine sales by type of wine.
D. For white and organic wine, what were the measures of central tendency based on the sales figures? Be sure to include all relevant statistics.
E. How did each salesperson perform in terms of the person’s respective sales figure? Present this answer using a table.
F. What would the sales commission be for each month if each salesperson earned 5% of the sales? Present this information graphically.
G. What would the total profit for each type of wine be given the following production costs for the wine: white wine is 17% of total sales, red wine is 12%, and organic wine is 21%? Now, deduct the sales commission discussed in question F and recalculate. Present the answers graphically.
H. How would you summarize the provided data? Develop pivot tables using the cleansed data to illustrate.
When presenting your answers to the questions above, did you:
i. Present the information logically?
ii. Choose tables and graphics that will best communicate the information to the relevant stakeholders?
iii. Properly color, label, and proportion the graphics?

Optimization and Decision Making: For the second task, you will now use the provided final project raw data set and help management decide on the right mix of wines to sell based on newly derived profit information while considering the limitations of the particular types of grapes available for production.
A. What are the relevant decision variables? What are the constraints? Graph the constraints involved in this problem using spreadsheet software.
B. What is the right mix of sales for the optimized solution? Be sure to use the linear programming features in the spreadsheet software and include a sensitivity analysis.
C. Create a decision tree or table for management, to support your recommendation, taking into account your estimation of the probabilities and likely outcomes for alternative states of nature.
D. When presenting your answers to the questions above, did you:
i. Present the information accurately and logically?
ii. Choose tables and graphics that will best communicate the information to the relevant stakeholders?
iii. Properly color, label, and proportion the graphics?

Imagine that you are a business analyst working for a winery in nor...