Question
2. Consider a resource-allocation problem having the following data. Contribution per unit= profit per unit of the activity Resource Usage per Unit of Each Activity
2. Consider a resource-allocation problem having the following data. Contribution per unit= profit per unit of the activity
Resource Usage per Unit of Each Activity
resource | 1 | 2 | 3 | Amount of resource available |
A | 28 | 14 | 0 | 390 |
B | 0 | 13 | 33 | 640 |
C | 15 | 14 | 25 | 1210 |
Contribution per unit | $33 | $50 | $71 |
(a) Express this model in algebraic form for this problem using equations. In other words, write up objective function, constraints, and decision variables?
(b) Solve a linear programming model for this problem on a spreadsheet, and interpret the results using at least 100 words
For part 2, you must provide two separate tabs within the same attached excel spreadsheet (1) Sheet 2 (Where you set up a linear programming model) and (2) answer report 2. You MUST include written discussions in a word document.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started