Minor Project 1 is a Hands-On Exercise for building a Linear Programming Skill. You can refer to the attached project content requirements.? This

Minor Project 1 is a Hands-On Exercise for building a Linear Programming Skill. You can refer to the attached project content requirements. 

This Minor Project is a hands-on exercise to perform and solve the linear optimization problems using the Analytic Solver Platform. Answer the following Problems found in Evans (2016) Chapter 13. Each problem is 25 points. There is no limit in number of words in this project since you will use the Excel sheet for presentation of answers toeach problem. 

1. See Problems 1 and 5 regarding Valencia Products (pp. 450-51). For Problem 5, perform the linear optimization and present Solver Answer Reports.

2. See Problems 2 and 6 regarding ColPal Products (pp. 450-51). For Problem 6, perform the linear optimization and present Solver Answer Reports.

3. See problems 4 and 8 regarding a business student owning stocks (pp. 450-51). For Problem 8, perform the linear optimization and present Solver Answer Reports.

4. Read the case, “Performance Lawn Equipment” (p.455). 

a. Formulate and present the linear optimization model. b. Solve the linear optimization model and present Solver Answer Report and Sensitivity Report. Present a brief summary of these results. 

Bonus Question: Optional

5. Personal Application Analytics: Discuss how you may use business analytics in your personal life. This is an open-ended question. You may use numerous examples to help appreciate the role of data and analytics in your personal life (eg., budgeting, grocery, car maintenance,sports, etc).  (20 pts)

Steps for Setting up the Optimization Model 

A. Excel Sheet1. Present the Given Data2. Set up the Optimization Model in an Excel Sheet3. Under the Model, put Decision Variables (eg., Quantity Produced and usually is 0)4. Put Constraints: SumProduct of data and quantity produced (see Evans p. 422)5. Set Objective Function (MAX). Usually the Sumproduct of Data Profit and quantity produced.

B. Analytic Solver6. Go to the Solver to start.7. Check under Engine and select the model as Standard LP/Quadratic Engine8. Select Decision Variables in your model and click Decisions-Normal in the Solver menu9. Select Constraints in your model and add each constraint to the Solver10. Select Objective (eg., Total Profit) from your Model sheet. Click Objective-MAX in the Solver menu11. Click Optimize,- Solve Complete Problem12. Select Report-Optimization reports for the detailed results (Answer report, Sensitivity Report, etc).