Question: Consider a resource-allocation problem having the following data. Contribution per unit = profit per unit of the activity. a. Formulate a linear programming model for

Consider a resource-allocation problem having the following data.

Contribution per unit = profit per unit of the activity.
a. Formulate a linear programming model for this problem on a spreadsheet.
b. Use the spreadsheet to check the following solutions:
(x1, x2) = (2, 2), (3, 3), (2, 4), (4, 2), (3, 4), (4, 3). Which of these solutions are feasible? Which of these feasible solutions has the best value of the objective function?
c. Use Solver to find an optimal solution.
d. Express this model in algebraic form.
e. Use the graphical method to solve this model?

Resource Usage per Unit of Each Activity Amount of Resource Available Resource 2 10 20 2 4 20 Contribution $20 $30 per unit

Step by Step Solution

★★★★★

3.47 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a c b x 1 x 2 Feasible Total Contribution 22 Yes 100 33 Yes ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1310-B-C-F-F-P-M(1932).docx

120 KBs Word File

Students Have Also Explored These Related Corporate Finance Questions!

Formulate the general linear programming model for Problem 4, and solve it.

Formulate the general linear programming model for the project network for installing an order processing system shown in Figure 8.14 and solve it.

Consider the linear programming model for player 1 given near the end of Sec. 15.5 for variation 3 of the political campaign problem (see Table 15.6). Verify the optimal mixed strategies for both...

PLEASE SHOW ME WHAT FORMULAS TO USE IN EACH CELL ON EXCEL! ALSO PLEASE SHOW ME HOW TO ENTER IT INTO SOLVER BECAUSE I AM DOING IT INCORRECTLY. 3.3A SPREADSHEET: 3.3.* Consider a resource-allocation...

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...

PLEASE SHOW ME WHAT FORMULAS TO USE IN EACH CELL ON EXCEL! ALSO PLEASE SHOW ME HOW TO ENTER IT INTO SOLVER BECAUSE I AM DOING IT INCORRECTLY. 3.5A SPREADSHEET: 3.5. Consider a resource-allocation...

PLEASE SHOW ME WHAT FORMULAS TO USE IN EACH CELL ON EXCEL! ALSO PLEASE SHOW ME HOW TO ENTER IT INTO SOLVER BECAUSE I AM DOING IT INCORRECTLY. 3.4A SPREADSHEET: 3.4. Consider a resource-allocation...

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 3 Amount of Resource...

all i need is D,E and F 5.2. 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...

exclude a, b and c 5.2. 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...

The commercial steel (seamless) pipeline depicted in Figure P3.5.5 is 100 m long and has a diameter of 0.4 m. Determine the height of the water tower (h) if the velocity of flow is 7.95 m/sec. Assume...

Argue for or against the practice of electronic employee surveillance at work. Provide specific examples to support your argument. What laws, if any, may be violated by such practices? Argue for or...

5 Use the internet to search for the latest reports of interstellar objects. Check more than one report about the same object. Look for different ideas about the object. Some reports may be biased...

56. An asset is purchased for $90,000 with the intention of keeping it for 10 years, but is sold at the end of year 3. A total of $30,000 was borrowed money that was to be repaid over three years in...

Todd Huebner asks, Since stock dividends dont change anything, why declare them?What is your answer to Todd?

Meenen Corporation has 30,000 shares of $10 par value common stock outstanding when it announces a 2-for-1 stock split. Before the split, the stock had a market price of $120 per share. After the...

The board of directors is considering either a stock split or a stock dividend.They understand that total stockholders equity will remain the same under either action. However, they are not sure of...

Shannon Industries is considering a project that has the following cash flows : Year CF 0 -6240 1 1980 2 3750 3 ? 4 1000 The project has a payback of 2.25 years. The firms cost of capital is 9.3...

Consider the following information about three stocks: a-1. If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio expected return? (Do not round...

7 The announcement of a stock offering (ralse capital through issuing more shares of stock) by a mature firm that seems to have multiple financing alternatives is taken as a signal that a. the firm...