Docstoc

Mining A

Document Sample
Mining A Powered By Docstoc
					                     Mining Spreadsheet A                Minimize:   D8 (wages)
                      Setting TARGETS                    Minimize:   D9 (toxic water)
                      Mine 1   Mine 2
                                                         By changing: B5:C5
Months to operate:     2.50     4.50
                                                         Subject to: D13:D15 >= E13:E15
                                                                 D17:D18 <= E17:E18
Objectives:                              Totals                  B5:C5 >= 0
 Cost per month        £40      £20       £190
 Toxins per month      600     1,800    9,600.0

Constraints:                            Available Required
 HG coal produced      12        4         48        48
 MG coal produced       4        4         28        28
 LG coal produced      10       20        115       100

                                        Required Available
 Time bounds            1        0         3       12
 Time bounds            0        1         5       12

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:32
posted:9/25/2012
language:Unknown
pages:1