LAB practice - blending problem

LAB practice - blending problem - NOTE: separate the DATA...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUS 220 - Introduction to Decision Science: Lab practice sheet 1. Enter the following formulation into EXCEL, and solve it using the SOLVER option. Minimize z = 0.75x1 + 0.90x2 + 0.80x3 + 0.70x4 s.t. x1 + x2 + x3 + x4 = 0.5 9x1 + 16x2 + 8x3 + 10x4 >= 6 12x1 + 10x2 + 10x3 + 8x4 >= 5 14x2 + 15x3 + 7x4 >= 5 x1, x2, x3, x4 >= 0
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: NOTE: separate the DATA portion from the MODEL portion, as we did in class. The following solution should be obtained : Z = 0.406 (optimal objective value target cell) x1=0.099; x2=0.213; x3=0.088, x4=0.099 (optimal values of the variables) Get the answer report, and the sensitivity report....
View Full Document

This note was uploaded on 11/18/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Ask a homework question - tutors are online