27 Sep 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).
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.