wbest03_Save_it

wbest03_Save_it - C 0.7 1 1 1 Min allowed fraction...

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

View Full Document Right Arrow Icon
Material Amount to Use of Grade in Material Total grade Cost Selling Net profit Total Grade 1 2 3 4 produced per unit Price per unit Profit A 644.7368 859.6491 214.9123 429.8246 2149.1228 3 8.5 5.5 35109.65 B 2355.263 517.5439 1785.088 517.5439 5175.4386 2.5 7 4.5 C 0 0 0 0 0 2 5.5 3.5 Treatment cost: 3 6 4 5 Total Treatment Min must be used: 1500 1000 2000 500 treatment cost #NAME? #NAME? #NAME? #NAME? cost target Total material used: 3000 1377.193 2000 947.3684 30000 #NAME? 30000 #NAME? #NAME? #NAME? #NAME? Amount available: 3000 2000 4000 1000 Minimum fraction that must be in a grade Grade 1 2 3 4 A 0 0.4 0 0.2 B 0 0.1 0 0.1 C 0 0 0 0 Maximum fraction allowed in a grade Grade 1 2 3 4 A 0.3 1 0.5 0.2 B 0.5 1 1 0.1
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C 0.7 1 1 1 Min allowed fraction constraints Color conventions: #NAME? #NAME? #NAME? #NAME? Data Decision Formula Constraint Objective Labels #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? This sheet is setup to be compatible with the What'sBest solver, see: http://www.lindo.com to download the software. Max allowed fraction constraints #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Save-It Company. What'sBest model...
View Full Document

This note was uploaded on 10/07/2011 for the course 101 101 taught by Professor Xyz during the Fall '97 term at Ringling.

Ask a homework question - tutors are online