Question

Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter...

Solve the following problem with Excel Solver: (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.)

Maximize Z = 2X + 4Y.
6X + 17Y ? 76          Resource A
2X + 3Y ? 20          Resource B
Y ? 18          Resource C
  Decision for X   
  Decision for Y   
  Total profit $   
              Resources Used
  Resource A     
  Resource B     
  Resource C     

Homework Answers

Answer #1

Below is the LP Formulation -

Objective Function - Maximize Z = 2X+4Y

s.t. constraints -

6X+17Y <=76 --> Resource A

2X+3Y <=20 --> Resource B

Y<=18 --> Resource C

X,Y >=0

The maximum value is 22.

Below is the solver solution -

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
a. Fill in the missing values in the table. (Leave no cells blank - be certain...
a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .102 .39 .77 Firm B .148 .58 1.32 Firm C .168 .57 .43 The market portfolio .12 .20 The risk-free asset .05
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0"...
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) Picture Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (xi−x¯)2 (yi−y¯)2 (xi−x¯)(yi−y¯) 10 93 100 7056 840 15 171 25 36 30 20 204 0 729 0 20 156 0 441 0 35 261 225 7056 1260 20 177 350 15318 2130 x¯ y¯ SSXX SSyy SSxy (b)...
Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize profit...
Solve the following LP problem graphically; confirm your results using Solver in MS Excel. Maximize profit = 20x1 + 10x2 Subject to: 5x1 + 4x2 ≤ 250 2x1 + 5x2 ≤ 150 x1, x2 ≥ 0
C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $15 per...
C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $15 per barrel while Burning River sells for $5 per barrel. Producing a barrel of Expansion Draft takes 6 pounds of corn and 2 pounds of hops. Producing a barrel of Burning River requires 6 pounds of corn, 6 pounds of rice, and 2 pounds of hops. The brewery has 720 pounds of corn, 500 pounds of rice, and 530 pounds of hops. Assuming a linear...
C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $24 per...
C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $24 per barrel while Burning River sells for $11 per barrel. Producing a barrel of Expansion Draft takes 14 pounds of corn and 7 pounds of hops. Producing a barrel of Burning River requires 2 pounds of corn, 9 pounds of rice, and 4 pounds of hops. The brewery has 770 pounds of corn, 450 pounds of rice, and 700 pounds of hops. Assuming a linear...
Let Y = ex where X is normally distributed with μ = 3.4 and σ =...
Let Y = ex where X is normally distributed with μ = 3.4 and σ = 0.7. Compute the following values. [You may find it useful to reference the z table.] a. Compute P(Y ≤ 10.4). (Round your intermediate calculations to at least 4 decimal places, “z” value to 2 decimal places, and final answer to 4 decimal places.) b. Compute P(9.1 < Y < 10.3). (Leave no cells blank - be certain to enter "0" wherever required. Round your...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset:...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio RP σP βP X 16.0 % 32 % 1.90 Y 15.0 27 1.25 Z 7.3 17 0.75 Market 11.3 22 1.00 Risk-free 5.8 0 0 What are the Sharpe ratio, Treynor ratio, and Jensen’s alpha for each portfolio? (A negative value should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset:...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio RP σP βP X 14.0 % 39 % 1.50 Y 13.0 34 1.15 Z 8.5 24 0.90 Market 12.0 29 1.00 Risk-free 7.2 0 0 What are the Sharpe ratio, Treynor ratio, and Jensen’s alpha for each portfolio? (A negative value should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset:...
You are given the following information concerning three portfolios, the market portfolio, and the risk-free asset: Portfolio RP σP βP X 12.5 % 38 % 1.45 Y 11.5 33 1.15 Z 9.4 23 0.80 Market 11.9 28 1.00 Risk-free 6.2 0 0 What are the Sharpe ratio, Treynor ratio, and Jensen’s alpha for each portfolio? (A negative value should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round...
(b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal...
(b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.)   b1 6.02   b0 55.178    (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calculations, but final answers should be rounded to 3 decimal places.)    Hours Worked (xi) Weekly...