Question: how to find the optimal solution in excel solver decisions variables. (3 marks) Type A is x Type B is y Function is to minimize

how to find the optimal solution in excel solver decisions variables. (3 marks) Type A is x Type B is y Function is to minimize the cost of the blend while meeting the constraints of performance C = 1x +2y b. Formulate the constraints in terms of the decision variables. (6 marks) Constraints are: Shade tolerance 1x+1y 300 Traffic Resistance 2x+1y 400 Drought Resistance 2x+5y 750 Also, x and y should not be negative so the following constraints X, y0 c. Draw the graph with 3 constraint lines and the object line and annotate the graph to identify the optimum. (4marks) 400 -2x = 300 -x 400 -300 =2x -x 100=x Y=300-100= 200 Shade tolerance and traffic resistance (100,200) 1500-5x =750-2x 1500-750=5x-2x 750=3x 750/3=x X=250 Y=300-250=50 Shade tolerance and drought resistance (250,50) 2000-10x =750-2x 2000-750=10x-2x 1250=8x X=1250/8 156.25 y=400-2(156.25) =400-312.5 = 87.5 Traffic resistance and drought resistance (156.25,87.5) d. How many pounds of each seed should be in the blend? (2 marks)

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 Mathematics Questions!

What if Analysis/Sensitivity Analysis The Mom and Pop Ice Cream Company makes three kinds of chocolate ice cream: regular, premium and super premium. The properties of 1 gallon (gal) of each type are...

Remember for your answer each of the assertions fundamental for your code to incorporate under a standard compiler and inside the sdds namespace. VehicleBasic Class Plan and code a class named...

Question 5. (22 points) OPTIMAL PRODUCT MIX AND WHAT-IF QUESTIONS AU Electronics manufactures is the supplier of components C1, C2 and C3 for the production of screens and components D1 and D2 for...

Question 6 . ( 2 8 points ) EcoFurn's Sustainable Furniture Journey In the serene countryside of GreenValley, there is an environmentally conscious furniture company called "EcoFurn." EcoFurn is...

Put all of your work in a single Excel file. Use a separate worksheet for each problem. Label the worksheet tabs. (Sensitivity reports will automatically be generated and labelled on their own...

I need help with these questions. Thank you Question 4. (20 points) You would like to minimize your cost of food intake during a given day. The table in Excel for this question shows the food items...

please answer all of question 4 thank you The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize...

Zilholm is a global consulting company, specializing in accounting services. It provides a range of services, ranging from tax consulting to auditing. The company offers 5 types of services called...

We know the clustering structure for the data in Example 10.7. Use results from Chapter 5 (assume one-stage cluster sampling) to estimate the proportion for each cell and margin in the 2Ã2...

Determine by direct integration the moment of inertia with respect to the z axis of the right circular cylinder shown assuming that it has a uniform density and a mass m.

12111. Determine the maximum constant speed a race car can have if the acceleration of the car cannot exceed 7.5 m>s2 while rounding a track having a radius of curvature of 200 m.

The efficiency of labor is a term that does not reflect the: A) education of the labor force. B) skills of the labor force acquired through on-the-job training. C) health of the labor force. D) high...