Model the problem using linear programming formulation

Reference no: EM132075152

We have so far seen many applications of linear programming in our course discussions.(This is the book we work from " Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics,8th ed, South-Western CENGAGE Learning, 2017.") This assignment aims to give you an opportunity to use your learnings so far in a practical context. You are expected to identify and solve a practical linear programming problem. This might be related to your work, personal life, or something that you are passionate about. There clearly are no boundaries to where you can make use of these tools so there are no rules about the choice of your problem. If you have issues accessing/collecting/using real data, you can use randomised real data, or generate your own problem instances to solve. We will assess you on the choice of problem to make sure that you put good effort into identifying an interesting problem rather than using a textbook example.

As a part of this assignment you are expected to

i) Describe your problem in detail, and explain your motivation in choosing this particular problem

ii) Model the problem using linear programming formulation; define your decision variables, and explain your objective function and constraints,

iii) Solve the problem using Analytic Solver Platform or Open Solver in Excel, generate answer and sensitivity reports,

iv) Discuss the reports in terms of their meanings, i.e., used resources, binding constraints, allowable increase/decrease, shadow prices etc.

Reference no: EM132075152

Questions Cloud

Service person experience in preventive maintenance : The number of copy machines to be serviced, x1, and the service person's experience in preventive maintenance, x2.

Calculate the sues holding period yield rate : Today is 1 January 2018. Sue just purchased a 10-year 4.5% p.a. Treasury bond with a face value of $100 at the yield rate of j2 = 4.3% p.a.

What is bayesian analysis and stochastic modelling : What is Bayesian Analysis and Stochastic Modelling? Explain in 50 words. Please provide explanation.

Calculate the closing stock as at june : Jones's mark-up is 50% on cost of goods sold. His average stock during the year was £12,000. Calculate the closing stock as at 30 June 19X7

Model the problem using linear programming formulation : Model the problem using linear programming formulation; define your decision variables, and explain your objective function and constraints,

Evaluate the effect of the herbal remedy echinacea : A study designed to evaluate the effect of the herbal remedy Echinacea purpurearandomly assigned healthy children 2 to 11 years old to receive either Echinaceao

What is overriding a member function : What is overriding a member function in c++? How do you do it? Why do you it?

Calculate the amount of his capital : He still owes £800 in respect of them. He had borrowed £4,000 from D Evans. Calculate the amount of his capital

What benefits do programmers get from doing this extra work : Discuss some reasons most programmers declare class data to be private and provide access to that data only through

User Account

All Pages