Question

In: Statistics and Probability

Graph all constraints, using Excel line shapes Determine the feasible region, shade Complete the objective function...

Graph all constraints, using Excel line shapes

Determine the feasible region, shade

Complete the objective function table

Determine the objective function max or min solution

Solve the optimization problem, using the graphical method as demonstrated in class. Graph the following constraints on the digital graph paper worksheet. Show all algebra work, to determine constraint intercepts. Show all algebra work to determine solution, or “intersection” of each constraint pair.

5A + 8B = Max Profit

3A + 5B ≤ 50

2A + 4B ≤ 40

1A + 0B ≤ 8

0A + 1B ≤ 10

Solutions

Expert Solution

This problem is solved by using Excel.

Output is

Therefore maximize profit at point A2 ( 8,5.2 ) is 81.6

Thank You!

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Solve using the graphical method. Choose your variables, identify the objective function and the constraints, graph the constraints, shade the feasibility region, identify all corner points, and determine the solution that optimizes the objective function
Solve using the graphical method. Choose your variables, identify the objective function and the constraints, graph the constraints, shade the feasibility region, identify all corner points, and determine the solution that optimizes the objective function. Use this information to answer the following 8-part question:A city council voted to conduct a study on inner-city community problems using sociologists and research assistants from UMUC. Allocation of time and costs per week are given in the following table:Labor hours - SociologistLabor hours –...
Explain the meaning of the following terms: constraints, decision variables, feasible region and objective function. Explain...
Explain the meaning of the following terms: constraints, decision variables, feasible region and objective function. Explain their relevance to product mix decisions.
Explain the meaning of the following terms: constraints, decision variables, feasible region and objective function. Explain...
Explain the meaning of the following terms: constraints, decision variables, feasible region and objective function. Explain their relevance to product mix decisions.
Solve for the following Linear Programming problems. Your solutions should include: Objective Function Constraints Graph complete...
Solve for the following Linear Programming problems. Your solutions should include: Objective Function Constraints Graph complete with labels of points and lines, and shaded feasible region Corner point approach Optimal solution Maximum profit Problem 1: In 1969, the two leading dietary drinks available in the market are Bandade and Firstade. These drinks supply protein and carbohydrates lost during physical activity. Bandade provides 1 unit of protein and 3 units of carbohydrates in each liter. Firstade supplies 2 units of protein...
Explain the following terms: Decision Variables Objective function Constraint Non-negativity constraints Feasible solution Infeasible solution Feasible...
Explain the following terms: Decision Variables Objective function Constraint Non-negativity constraints Feasible solution Infeasible solution Feasible solution area Optimal Solution Extreme Points Proportionality
Find the objective function and the constraints, and then solve the problem by using the simplex...
Find the objective function and the constraints, and then solve the problem by using the simplex method. A confectioner has 600 pounds of chocolate, 100 pounds of nuts, and 50 pounds of fruits in inventory with which to make three types of candy: Sweet Tooth, Sugar Dandy, and Dandy Delite. A box of Sweet Tooth uses 3 pounds of chocolate, 1 pound of nuts, and 1 pound of fruit and sells for $8. A box of Sugar Dandy requires 4...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using...
For the given transportation problem, formulate a linear program with objective function and constraints. Solve using the excel sleeve, provide the optimal transport cost. Imagine that we have three bakeries and three stores. the three stores require 23 dozen, 17 dozen, and 20 dozen loaves of bread, respectively, while the three bakeries can supply 18 dozen, 15 dozen, and 22 dozen loaves, respectively. The unit transportation costs are provided in the table below: Store 1 Store 2 Store 3 Bakery...
Given the following all-integer linear program: (COMPLETE YOUR SOLUTION IN EXCEL USING SOLVER AND UPLOAD YOUR...
Given the following all-integer linear program: (COMPLETE YOUR SOLUTION IN EXCEL USING SOLVER AND UPLOAD YOUR FILE. BE SURE THAT EACH WORKSHEET IN THE EXCEL FILE CORRESPONDS TO EACH QUESTION BELOW ) Max 15x1 + 2x2 s. t. 7x1 + x2 < 23 3x1 - x2 < 5 x1, x2 > 0 and integer a. Solve the problem (using SOLVER) as an LP, ignoring the integer constraints. b. What solution is obtained by rounding up fractions greater than or equal...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT