MILESTONE 3: For white and organic wine, what were the measures of central tendency based on the sales figures?

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: To complete this assignment, review the questions below and examine the Final Project Excel Functions spreadsheet. Then, select a function that you believe will help you to answer the following questions.Specifically, the following critical elements must be addressed:1. For white and organic wine, what were the measures of central tendency based on the sales figures?2. 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%?3. Deduct the sales commission. Draft and present the answers graphically.SALES COMMISSION: $ 6,125.4. How would you summarize the provided data? Develop pivot tables using the cleansed data to illustrate.5. What are the relevant decision variables? What are the constraints? Explain.6. What is the right mix of sales for the optimized solution? Be sure to use the linear programming features in spreadsheet software and include a sensitivity analysis.7. Create a decision tree or table for management to support your recommendation that takes into account your estimation of the probabilities and likely outcomes for alternative states of nature.Guidelines for Submission: Submit a document that communicates your answers, using a graph where indicated