LP_ModelsExplained2

LP_ModelsExplained2 - 13.011152 10.223048 10.037175 Used...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Mixture of Coal Type of Coal A B C Totals Specification A B C 0.4 0.4 0.2 1 = 1 Phosphorus (%) 0.02 0.04 0.03 0.008 0.016 0.006 0.03 <= 0.03 Ash (%) 3 2 5 1.2 0.8 1 3 <= 3 Profit (£/tonne) £60.00 £75.00 £70.00 £24.00 £30.00 £14.00 £68.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Weight (tons) Volume (cu ft) Volume Profit Commodity Available Commodity Forward Center Aft TotalWeight Profit Commodity Forward Center Aft per ton per ton 6000 A 305.55556 0 0 305.555556 £1,833.33 A 18333.33 0 0 60 £6.00 4000 B 1576.9231 2423.077 0 4000 £32,000.00 B 78846.15 121153.8 0 50 £8.00 2000 C 117.52137 576.9231 1250 1944.44445 £9,722.22 C 2820.513 13846.15 30000 24 £5.00 Weight per Section Volume per section 2000 3000 1250 £43,555.56 100000 135000 30000 Weight Allowable Volume allowable 2000 3000 1500 100000 135000 30000 Named Ranges CommodityAvailable ='Cargo(TestPr2)'!$A$4:$A$6 TotalWeight ='Cargo(TestPr2)'!$F$4:$F$6 VolumeAllowable ='Cargo(TestPr2)'!$I$10:$K$10 VolumePerSection ='Cargo(TestPr2)'!$I$8:$K$8 WeightAllowable ='Cargo(TestPr2)'!$C$10:$E$10 WeightPerSection ='Cargo(TestPr2)'!$C$8:$E$8 List of used named ranges can help in understanding the model (Insert, Name, Paste List)
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 13.011152 10.223048 10.037175 Used Product 1 Product 2 Product 3 Labour Produced Product 1 Product 2 Product 3 Labour 0.4 0.3 3 13.011152 5.204461 3.9033457 39.033457 0.2 0.6 4 10.223048 2.0446097 6.133829 40.892193 0.7 0.5 2 10.037175 7.0260223 5.0185874 0 20.074349 Prices 80.00 70.00 60.00 1.00 totals used 9.070632 10.223048 10.037175 100 &lt;= 100 ObjectiveFunction Left to be sold 215.24 3.9405204 &gt;= &gt;= &gt;= LabourAvailable =ChemicalProblem!$M$8 ProductPrices =ChemicalProblem!$B$7:$D$7 ProductsLeft =ChemicalProblem!$H$10:$J$10 ProductsProduce=ChemicalProblem!$G$4:$G$6 ProductsUsed =ChemicalProblem!$H$8:$J$8 Product1 uses Product2 uses Product3 uses Please notice that the model here is different from the mathematical formulation in the tutorial hand-outs: I have only 3 decision variables now (not 6). VD....
View Full Document

Page1 / 3

LP_ModelsExplained2 - 13.011152 10.223048 10.037175 Used...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online