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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The Childfair Company has three plants producing child pushchairs that are to be shipped to four distribution centers. Plants 1,2 and 3 produce 12, 17, and 11 shipments per month, respectively. Each...

1. The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1,2 and 3 produce 12, 17, and 11 shipments per month, respectively....

Consider a resource - allocation problem having the following data: Resource Usage per Unit of Each Activity Activity 1 Activity 2 Amount of Resource Available Resource 1 1 2 1 0 Resource 2 1 3 1 2...

=3.2.* Consider a resource-allocation problem having the following data: Resource Usage per Unit of Each Activity Amount of Resource 1 2 Resource Available 1 2 1 10 2 3 3 20 3 2 4 20 Contribution $20...

=E*3.4. Consider a resource-allocation problem having the following data: Resource Usage per Unit of Each Activity Amount of Resource Resource 1 2 3 4 Available P 3 5 2 4 400 Q 4 1 3 2 300 R 6 3 2 1...

=3.3. Consider a resource-allocation problem having the following data. Resource Usage per Unit of Each Activity Amount of Resource Resource 1 2 3 Available A 30 20 0 500 B 0 10 40 600 C 20 20 30...

Consider a resource-allocation problem having the following data: Resource Usage per Unit of Each Activity Resource 1 2 Amount of Resource Available 1 1 2 10 2 1 3 12 Unit profit $2 $5 The objective...

=5.13. Consider a resource-allocation problem having the following data: Resource Usage per Unit of Each Activity Amount of Resource Resource 1 2 Available 1 1 3 8 2 1 1 4 Unit profit $1 $2 The...

=5.2. Consider a resource-allocation problem having the following data: Resource Usage per Unit of Each Activity Amount of Resource Resource 1 2 Available 1 1 2 10 2 1 3 12

3.4. Consider a resource-allocation problem having the following data. Resource A B C Contribution per unit Resource Usage per Unit of Each Activity 1 2 3 Amount of Resource Available 30 0 20 20 222...

3. Write a procedure that is passed offset of an array of 10 strings of characters and prints all the strings. Hint: Print PROC mov ch, rows inc esi dec cl JNZ L1

Why is the least importance placed on organizations in the organizational model? a. Because organizational culture is a function of teamwork and individual output b. Because the individuals and teams...

One of the most important components of stock evaluation is a firm's estimated growth rate

What is the correct common name for the compound shown here