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.

Resource Usage per Unit of Each Activity Amount of Resource Available Resource 1 2 з 4 4 400 -2 -1 2 300 2 -1 400 300 -

Contribution per unit = profit per unit of the activity.
a. Formulate a linear programming model for this problem on a spreadsheet.
b. Make five guesses of your own choosing for the optimal solution. Use the spreadsheet to check each one for feasibility and, if feasible, for the value of the objective function. Which feasible guess has the best objective function value?
c. Use Solver to find an optimal solution?

Resource Usage per Unit of Each Activity Amount of Resource Available Resource 1 2 4 4 400 -2 -1 2 300 2 -1 400 300 -2 Contribution $11 $9 $8 $9 per unit

Step by Step Solution

★★★★★

3.28 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a c b Below are five possible guesses many answers ar... 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(1935).docx

120 KBs Word File

Students Have Also Explored These Related Corporate Finance Questions!

Formulate a linear programming model for Problem 34 in Chapter 1 and solve using the computer. How does this solution differ from the solution to Problem 34 in Chapter 1?

Consider a resource= allocation problem having the following data: The objective is to determine the number of units of each activity to undertake so as to maximize the total profit. While doing...

Consider the transportation problem having the following data. Exxo 76 is an oil company that operates the pipeline network shown below, where each pipeline is labeled with its maximum flow rate in...

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

Business Week recently reported that L. G. Philips LCD Co. would complete a new factory in Paju, South Korea. It will be the world's largest maker of liquid-crystal display panels. The arrival of the...

ICPenney operates a chain of retail department stores, selling apparel, shoes, jewelry, and home furnishings. It also offers most of its products through catalog distribution. During fiscal Year 5 it...

A space capsule is traveling at constant speed v from the Earth to the moon. The passengers of the capsule measure the length of the capsule to be l and the distance between Earth and Moon d . What...

53. Video Solution Raytheon wishes to use an automated environmental chamber in the manufacture of electronic components. The chamber is to be used for rigorous reliability testing and burn-in. It is...

The stockholders equity section of OVear Corporation consists of common stock ($10 par) $2,000,000 and retained earnings $500,000. A 10% stock dividend (20,000 shares) is declared when the market...

For the year ending December 31, 2010, Kerns Inc. reports net income $140,000 and dividends $85,000. Prepare the retained earnings statement for the year assuming the balance in retained earnings on...

The balance in retained earnings on January 1, 2010, for Persinger Inc, was $800,000. During the year, the corporation paid cash dividends of $90,000 and distributed a stock dividend of $8,000. In...

You own a portfolio that has $3,400 invested in Stock A and $4,500 invested in Stock B. Assume the expected returns on these stocks are 8 percent and 14 percent, respectively. Required: What is the...

in: 7. Which of the following best describes a firm with low operating leverage? A large change A. earnings before interest and taxes result in a small change in net income B. sales result in a small...

Find the future value of an investment of $3,400 made today for the following rates and periods: (Use 365 days for calculation. If you solve this problem with algebra round intermediate calculations...