LAB practice - blending problem

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

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

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
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