Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 2: You are given the following linear programming model (see below) in algebraic form, where x1 and x2 are the decision variables and Z

Problem 2: You are given the following linear programming model (see below) in algebraic form, where x1 and x2 are the decision variables and Z is the value of the overall measure of performance. The goal is to maximize the objective function Z = 3X1 + 2X2 subject to: Constraint on resource 1: 3x1 + x2 9 Constraint on resource 2: x1 + 2x2 8 And x1 and x2 are not negative, i.e., x1 > 0 and x2 > 0. (a) Identify the objective function (Z = ??), the functional constraints, and the nonnegativity constraints in this model (see Hillier text pages 33-34 for a review). (b) Incorporate this model into a spreadsheet using the picture below as a guide for the Excel spreadsheet you develop: (the unit profit cells have been filled in for you to give you a start). Hint: There are SUMPRODUCT functions in the two Resource Used cells, and another SUMPRODUCT function in the Total Profit cell. Hint: to answer questions parts c, d, and e, substitute each X1 and X2 values in parts c, d, and e below into the constraints on resources 1 and 2 given above. (c ) Is (X1, X2) = (2,1) a feasible solution? (d) Is (X1, X2) = (2,3) a feasible solution? (e) Is (X1,X2) = (0, 5) a feasible solution? (f) Use Solver to solve this model (to get the yellow decision cells and the orange total profit cell) by creating your Excel linear programming model with the information above and running Excels Solver (Data tab > Solve

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Business Of Personal Finance

Authors: Joseph Calandro Jr, John Hoffmire

1st Edition

1032104562, 978-1032104560

More Books

Students also viewed these Finance questions