Question: In VBA Use solver to find the optimal value for: Maximize: 0.2*X +0.8*Y Subject to: X>=0 Y>=0 X+Y =Y

In VBA

Use solver to find the optimal value for:

Maximize:

0.2*X +0.8*Y

Subject to:

X>=0

Y>=0

X+Y<=100

X>=Y

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Use Solver to find the optimal value of the objective function of the following linear programming problem Minimize Z = 27x + 12y Subject to: 8x+5y_> 100 12x+25y _> 360 x_>0; y_>0 Answer Options: A...

Q:

PRINTABLE VERSION Quiz 1 You scored 28.57 out of 100 Question 1 Your answer is CORRECT. Suppose you buy a piece of office equipment for $19,000. After 7 years you sell it for a scrap value of $4,000....

Q:

ADM 2302 -Assignment #1 Problem 1 (15 points) The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund...

Q:

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

Q:

Larry J. Goldstein David I. Schneider Martha J. Siegei i-' r A 1 son Finite Mathematics & Its Applications, Tenth Edition Chapter 3: Linear Programming, A Geometric Approach: 3.1 A Linear... Linear...

Q:

BUSINESS 275, WINTER 2016 ASSIGNMENT #2: LINEAR PROGRAMMING Administrative Matters 1.1 Deadline This assignment is due by 11 AM on Wednesday, March 23, 2016 in the correct labeled drop box outside...

Q:

pls answer all the questions Problem $2 : Consider the following problem: Maximize 36X1+9X126X13+36X23X23 Subject to: X1+X23;X10;X20 Part a: Write out the Lagrangian function for this problem. (4...

Q:

BoWw N e A B Cc D E F G H 1 1 K Afarmer owns 500 hectares of land in an arid region. The government gives him up to 1,000,000 cubic metres of water for irrigation each year. In addition, he may...

Q:

Q2 The Total Lawncare Company has to make x, pounds of fertilizer A, X; pounds of fertilizer B, and x, pounds of fertilizer C. The following Linear Programming model has been developed to help Total...

Q:

All of the above pictures are Question 1, please do all of the four options for uplike. Consider the following Linear Programming model and its corresponding graph. Maximize 400x+200y Subject to...

Q:

Write a speech using the case below: You are the Head of Marketing and Sales for Ava Motors, a start-up in the auto sector. You are all set to roll out your first product in the market, EcoDrive, an...

Q:

Metre Blae Chiently Chp 7 HW-Cost Allocation 1 10 points Priv References Mc Graw Hill Prom 81 82 BI 82 P1 72 #1 82 #225,000 75.000 62,000 180,000 Required 1 Check my work Robinson Products Company...

Q:

Using the single index model paradigm with the market portfolio being the single factor, calculate the expected retrun for a security with a beta of 0 . 5 2 and an alpha of - . 0 2 % . Assume that...

Q:

One of the problems with ROMI is that it often focuses on _ _ _ _ _ _ _ _ Blank rather than looking at the effects or changes in brand equity. Multiple Choice short - term target marketing goals long...

Q:

List the four parts of the self-motivation model.

Q:

Define the following 16 key terms throughout the chapter identified in bold with their definition in italic.

Q:

Identify the four parts of the model for writing objectives.