You are given the following data for a linear programming problem where the objective is to maximize the profit from allocating three resources to two nonnegative activities Contribution per unit profit per unit of the activity (a) Formulate a linear programming model for this problem (b) Use the graphical method to solve this model (c) Display the model on an Excel spreadsheet (d) Use the spreadsheet to check the following solutions (x 1 , x 2 ) (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 (e) Use Solver to solve the model by the simplex method (f) Use ASPE and its Solver to solve the model by the simplex method Resource Usage per Unit of Each Activity Amount of Resource Available Resource Activity 1 Activity 2 10 20 20 4 Contribution $20 per unit $30

Question: You are given the following data for a linear programming problem where the objective is to maximize the profit from allocating three resources to two

You are given the following data for a linear programming problem where the objective is to maximize the profit from allocating three resources to two nonnegative activities.

Contribution per unit = profit per unit of the activity.
(a) Formulate a linear programming model for this problem.
(b) Use the graphical method to solve this model.
(c) Display the model on an Excel spreadsheet.

(d) Use the spreadsheet to check the following solutions: (x₁, x₂) = (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?

(e) Use Solver to solve the model by the simplex method.

(f) Use ASPE and its Solver to solve the model by the simplex method.

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

Step by Step Solution

★★★★★

3.42 Rating (180 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Maximize P 20x 1 30x 2 Subject to ... 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)

545-M-S-L-P (302).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

You are given the following data for a company: Cost of debt = 8%, cost of retained earnings = 12%, cost of new common equity = 14%, tax rate = 35% and retained earnings = $1000. The firms target...

You are given the following data for Kim Zerussen: Assuming that inflation was 10 percent during 2008, evaluate Kims financial performance for the year. 2008 Income during the year $60,000 $64,000...

You are given the following data for BSK Company Inc. for 2004, 2005, and 2006 (amounts in thousands). a. Calculate ROCE for the three years. b. Calculate basic EPS for the three years. c. Interpret...

You are given the following data for a linear programming problem where the objective is to maximize the profit from allocating three resources to two nonnegative activities. (a) Formulate a linear...

3.5-3. You are given the following data for a linear programming problem where the objective is to minimize the cost of conducting two nonnegative activities so as to achieve three benefits that do...

You are given the following data for a linear programming problem where the objective is to minimize the cost of conducting two nonnegative activities so as to achieve three benefits that do not fall...

pleaseee solve question (d) and (e) with Clear and understandable steps 3.5-3. You are given the following data for a linear programming problem where the objective is to minimize the cost of...

Explain the difference between the installment sales method and cost recovery.

Three identical coils, each of resistance 10ohm and inductance 42mH are connected (a) in star and (b) in delta to a 415V, 50 Hz, 3-phase supply. Determine the total power dissipated in each case.

The goal of passive investing is to possibly match a benchmark / index by purchasing assets that mirror the benchmark / index . True False

There is a book called How to Pad Your Expense Report and Get Away with It! by Employee X. Employee X says that he offers these suggestions because of the obscene salaries of executives. Employee X...

Consider the transportation problem formulation of Option 1 for the Better Products Co. problem presented in Table 8.28. Verify that the optimal solution given in Sec. 8.3 actually is optimal by...

Consider the transportation problem having the following parameter table: After several iterations of the transportation simplex method, a BF solution is obtained that has the following basic...

Consider the transportation problem having the following parameter table: Use each of the following criteria to obtain an initial BF solution. In each case, interactively apply the transportation...

Please help me: A report included the following information on the heights (in.) for non-Hispanic white females. Sample Sample Std. Error Age Size Mean Mean 20-39 865 63.7 0.09 60 and older 934 62.1...

Investment Portfolio Sid, a widower of 45, has two adult children who both have good full-time jobs. He owns a prosperous hardware store and recently paid off the mortgage on his house. He earns a...

2. [15] This question is regarding the 5-stage MIPS pipeline with data forwarding and hazard detection. [5] Consider the following MIPS code. Mark "X" on instruction(s) for which the ALU uses a...