Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Day Trading Strategies And Risk Management

Authors: Richard N. Williams

1st Edition

979-8863610528

More Books

Students also viewed these Finance questions