i need this done in 8 hours. please dont accept if you can do

QSO 320 Milestone Four Guidelines and Rubric Overview: You will now use the provided final project raw data set and Milestone Four Business Scenario, 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. Prompt: To complete this assignment, review the questions below and examine the Final Project Excel Functions document. Then, select a function that you believe will help you to answer the following questions:

1. What are the relevant decision variables? What are the constraints? Graph the constraints involved in this problem using spreadsheet software. 2. 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. 3. 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.

Guidelines for Submission: Submit a document that communicates your answers, using a graph where indicated. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions.

Critical Elements Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value

Optimization and Decision Making:

Variables and Constraints

Accurately and comprehensively identifies and graphs the variables and constraints

Identifies and graphs the variables and constraints, but graph is incomplete or has inaccuracies

Does not identify and graph the variables and constraints

25

Optimization and Decision Making:

Optimized Solution

Proposes a sound optimized solution based on correctly applied linear programming features

Proposes a solution, but it is not optimal, not sound, or not based on correctly applied linear programming features

Does not propose a solution 25

Optimization and Decision Making:

Decision Tree or Table

Creates a decision tree or table for management that comprehensively and appropriately supports your recommendations

Creates a decision tree or table, but there are either gaps in detail or the recommendations are not well- supported

Does not create a decision tree or table

25

Optimization and Decision Making:

Presentation of Answers

All answers to the questions are presented logically and properly formatted for effective communication with relevant stakeholders

There are issues in the logic or formatting of the answers to the questions that would impede communication with relevant stakeholders

There are significant issues in the logic or formatting of the answers to the questions that would make effective communication with the relevant stakeholders impossible

25

Total 100%