Question: Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be made are the levels of three activities (A1,

Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be made are the levels of three activities (A1, A2, and A3).
Maximize Profit = 20A1 + 40A2 + 30A3
Subject to
Resource 1: 3 A1 + 5 A2 + 4 A3 ( 400 (amount available)
Resource 2: A1 + A2 + A3 ( 100 (amount available)
Resource 3: A1 + 3A2 + 2A3 ( 200 (amount available)
And
A1 ( 0 A2 ( 0 A3 ( 0
Formulate and solve the spreadsheet model for this problem?

Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 2 3 4 5 6 7 8 9 10 11 A Unit Profit Resource 1 Res... 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(1938).docx

120 KBs Word File

Students Have Also Explored These Related Corporate Finance Questions!

Consider the following algebraic formulation of a cost- benefit-trade-off problem involving three benefits, where the decisions to be made are the levels of four activities (A1, A2, A3, and A4):...

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

Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of its products is a strawberry shake that is designed to be a complete meal. The strawberry shake...

=E*3.7. Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be made are the levels of three activities (A1, A2, and A3). subject...

Consider the following algebraic formulation of a resourceallocation problem with three resources, where the decisions to be made are the levels of three activities (A1 , A2 , and A3 ).

6 . 8 . Consider the following algebraic formulation of a resource - allocation problem with three resources, where the decisions to be made are the levels of three activities , and { : A 3 ) ....

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.8 SPREADSHEET: 3.8. Consider the following algebraic...

6.8. Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be made are the levels of three activities ( A1,A2, and A3 )....

Consider the following algebraic formulation of a resource-allocation problem with three resources, Maximize Profit = 20A1+ 40A2 + 30A3 subject to Resource 1: 3A1+ 5A2 + 4A3 400 (amount available)...

One proposed design for an energy-efficient automobile involves an on-board tank storing hydrogen which would be released to a fuel cell. The tank is to be cylindrical, 0.4 m in diameter, made of...

The basic feasible solution to a transportation problem is said to be optimal if it ______________. maximizes or minimizes the transportation cost. maximizes the transportation cost. minimizes the...

How can managers determine whether a Deloitte employee is working at a decelerated pace in the career customization model or simply isnt working very hard?

50. Hyundai USA has numerous robotic welders as well as robotic checkers with vision. One underbody robotic welder costing $1,200,000 (7-year property class) was installed and is increasing...

Riff CD Company has had 4 years of retained earnings. Due to this success, the market price of its 400,000 shares of $3 par value common stock has increased from $12 per share to $51. During this...

Alpha Centuri Corporation has retained earnings of $3,100,000 on January 1, 2010. During the year, Alpha Centuri earned $1,200,000 of net income. It declared and paid a $150,000 cash dividend. In...

On January 1, 2010, Tuscany Corporation purchased 1,000 shares of treasury stock. Other information regarding Tuscany Corporation is provided below. Compute (a) Return on common stockholders equity...

2.(18 points) Consider a bond B with r = 4% and four risky assets with the price history: year s S2 S3 S4 2016 500 625 625 2500 2017 450 750 375 2250 2018 405 900 225 3150 2019 405 720 270 4410 2020...

1. Empirical evidence about the link between deposit insurance and banking crisis found that: A. Deposit insurance always decrease the chance of a banking crisis B. Deposit insurance always increase...

Assume that the firm invests $75,600 today to get $14,500 at Year 1 (i.e. one year from now), $22,000 at Year 2, $15,700 at Year 3, $30,000 at Year 4, \$19,500 at Year 5, \$19,370 at Year 6. What's...