Whittle Simultaneous Op Tim Is at I On Tutorial

Download as pdf or txt
Download as pdf or txt
You are on page 1of 25

Copyright 2012Gemcom Software International Inc.

(Gemcom)
All rights reserved. Gemcom publishes this documentation for the sole use of Gemcom licensees.
Without written permission, you may not sell, reproduce, store in a retrieval system, or transmit
any part of this documentation. For such permission, or to obtain extra copies please contact your
local Gemcom office, or visit www.gemcomsoftware.com.
This software and documentation is proprietary to Gemcom and, except where expressly provided
otherwise, does not form part of any contract. Changes may be made in products or services at
any time without notice.
While every precaution has been taken in the preparation of this manual, neither the authors nor
Gemcom assumes responsibility for errors or omissions. Neither will be held liable for any damages
caused or alleged to be caused from the use of the information contained herein.
Gemcom Software International Inc., Gemcom, the Gemcom logo, combinations thereof, and
GEMS, Surpac, Minex, MineSched, Whittle, PCBC, Gemcom InSite, and Gemcom Hub are
trademarks of Gemcom Software International Inc. or its wholly-owned subsidiaries.
Product
Gemcom Whittle 4.5
Last modified: Wednesday, 24 October 2012

Table of Contents
Introduction

Prerequisites

Projects folder

Processing time

Simultaneous optimisation theory

Net present value and discounting

Costs

How simultaneous optimisation works

When can you benefit from SIMO

Bulk blend

Running the existing bulk blend scenario

Creating and running a simultaneous optimisation node

Examining the schedule results

11

Creating a mining sequence file

13

Extractive blend

14

Running simultaneous optimisation for an extractive blend scenario

14

Viewing the sequence and grades in the 3D viewer

16

Operational scenario

17

Examining a comparative node

17

Setting up simultaneous optimisation for an operational scenario

18

Examining how the NPV result is calculated

20

Examining the average grade input to MILL

22

Introduction

Prerequisites

Introduction
In this tutorial, you will add a simultaneous optimisation (SIMO) node, and a schedule report graph node, to
an operational scenario node, a bulk blend node and an extractive bulk blend node. You will compare the
net present value (NPV) generated by simultaneous optimisation with the NPV generated from the parent
nodes.

Prerequisites
l

You must have a basic understanding of Whittle concepts. If you are new to Whittle, complete
one of the two introductory tutorials before trying this Simultaneous Optimisation tutorial.
Ideally you will have completed an introductory Whittle training course so that you understand the concepts and procedure of pit optimisation and how to determine optimum pushbacks.

Projects folder
For this tutorial you use the bulkBlend, marvin and marvinBlend data sets that are installed with Whittle.
These data sets are in the default locations as in the following table, unless you selected a different folder
when you installed Whittle.
Operating System
Windows 7 or
Windows Vista
Windows XP

Projects Folder
C:\Users\Public\Gemcom\Whittle\<version>\projects
C:\Documents and Settings\All Users\Gemcom\Whittle\<version>\projects

Processing time
Because of the amount of processing required for simultaneous optimisation, it can take several hours to
run. In this tutorial, you will change some optimisation settings to speed up the processing so that the
example data runs in approximately 15 minutes or less. As a result, the NPV returned is reduced compared
to the NPV you can achieve with standard optimisation settings. SIMO runs faster on machines with a faster
CPU and more available RAM.

Gemcom Whittle 4.5

Page 4 of 25

Simultaneous Optimisation tutorial

Simultaneous optimisation theory

Net present value and discounting

Simultaneous optimisation theory


Net present value and discounting
A dollar that you receive today is more valuable to you than a dollar that you expect to receive next year.
You can reinvest money you hold today, and earn benefits from it. This concept is referred to as the time
value of money.
When estimating the value of a project, it is common to reduce the value of expected future cash flows by a
certain percentage per year, to allow for the time value of money and other factors like risk. This process is
called discounting.
The sum of all expected discounted cash flows is called the net present value (NPV).

Costs
When you are thinking about NPV and discounting, it is helpful to remember the following points about
costs:
l

Same currency. In Whittle, you must enter all costs and prices in the same currency.
If your costs are in the local currency and prices in US dollars, convert them to the same
currency before you enter them in Whittle.
Period variation. If you forecast costs or prices to change in different periods, you can use the
Period Variation button in Whittle to specify what cost or price for each period.

The Period Variation button is also useful when you forecast a change in exchange rate, or
monetary devaluation, in a currency that is relevant to the mining project.
For more information see the Period Variation help topic.
l

Initial CapCosts. Initial capital costs are incurred in period 0. Therefore they are not discounted. Conversely, future cash flows are discounted.

How simultaneous optimisation works


Simultaneous optimisation (SIMO) is designed to maximise the net present value (NPV) of your mine.
Before running SIMO, you must determine:
l
l

the final pit shell


the intermediate pit shells to mine to that is the pushbacks

You can use the existing Whittle features, such as the Lerchs Grossman pit optimisation, the Milawa
algorithm and the NPV practical pushbacks node to determine the final pit and the pushbacks.
SIMO concurrently optimises:
l
l
l
l

schedule
cut-off
stockpiles
blend

Gemcom Whittle 4.5

Page 5 of 25

Simultaneous Optimisation tutorial

Simultaneous optimisation theory

When can you benefit from SIMO

When can you benefit from SIMO


You gain most benefit from SIMO when:
l

it is valuable to your operation to process high-grade material at early stages in the mine life.
However, even if a higher grade (beyond a prescribed cut-off) does not affect your profits, such
as in many iron ore or gypsum operations, SIMO can still improve the NPV because it also
optimises the blend. In a schedule where the blend is optimised, material just below the cutoff is saved (blended with higher grade material and either processed or sent to stockpile)
rather than sent to the waste dump.
your operation is flexible enough to deploy the people and equipment to mine at a higher rate
in specific periods.
One of the reasons that SIMO can return a high NPV is because it uses cut-off optimisation. In
cut-off optimisation, the processing limit stays constant, and the cut-off is raised in specific
periods usually the early periods.
To uncover and mine enough material to meet the processing limit you must increase the
mining rate (and send the material that is below the cut-off either to the waste dump or to a
stockpile). To mine at that rate, you must deploy more people and equipment in the specific
periods when they are needed.

Gemcom Whittle 4.5

Page 6 of 25

Simultaneous Optimisation tutorial

Bulk blend

Running the existing bulk blend scenario

Bulk blend
Running the existing bulk blend scenario
1. Start Whittle.
2. Open bulkBlend1.fxp.
3. Run all the nodes in the project.
You will compare the NPV that the simultaneous optimisation (SIMO) node returns with the NPV
that you know you can already obtain with this data. Specifically you will use the bulk blend
node b) Single blend with blend bins + stockpile as the comparative node.
4. Under b) Single blend with blend bins + stockpile, select Lead 4:phases 3 4 5 6.
5. Select the Summary tab.

This node returns an NPV of approximately $987.6 M.

Creating and running a simultaneous optimisation node


You can create a SIMO node underneath the following types of node:
l
l
l

bulk blend scenario


extractive blend scenario
operational scenario

Before creating the SIMO node under a bulk blend scenario node, you should complete pit optimisation and
determine the optimum pushbacks. The pushbacks have already been determined for the Lead 4:phases 3
4 5 6 node, and for this tutorial, you can use the same settings.
1. On the Lead 4 : phases 3 4 5 6 node, Schedule tab, notice that pit shells 3, 4, 5 and 6 have been
chosen as pushbacks.
2. Right-click on b) Single blend with blend bins + stockpile, and choose Add > Simultaneous
Optimisation.
Blend bins, blend constraints and limits have already been defined on the parent bulk blend
scenario node. These bins, constraints, and limits are inherited by the SIMO node and, to
compare like with like do not change them on the SIMO node.
3. On the Optimisation tab, enter a Period horizon of 15.
At this time, you do not know how many years the mining operation will ideally run. Therefore
you will initially enter a high number of periods, based on the mine life from a comparative, nonSIMO node. After you have run SIMO once, the Report tab will show you the number of periods
that have mining activity according to the SIMO schedule. For optimum performance on reruns,

Gemcom Whittle 4.5

Page 7 of 25

Simultaneous Optimisation tutorial

Bulk blend

Creating and running a simultaneous optimisation node

you want the last period to have no activity at all to show that no more optimisation is possible.
However, to minimise processing time, you want only one empty period.
4. On the Optimisation tab, select Advanced optimisation controls.
The standard settings for simultaneous optimisation return close to the highest possible NPV.
These settings can take several hours to run. For this tutorial, however, you will make it run
faster and possibly accept a small reduction in NPV.
5. Set the Minimum Start Points to 5 and the Number of Best Solutions to 5, and click OK.
Note: More information on Advanced Optimisation Controls is available in the Whittle help.

6. Click Accept and click the Save icon on the toolbar.


7. Restart Whittle for these settings to take effect.
8. On the New Simultaneous Optimisation node, click the Blend Bins tab.
For this project, the blend bins are copied automatically from the parent node. Examine the
bins. You can see that blend bins have been created for the L1, L2, and L3 rock types (because
these rock types are the only ones included in the product blend). You can also see that the Ash
% is used to define the different bins, because Ash% is the most significant element in the
blending process for this project.
9. Click the Blend tab.

Gemcom Whittle 4.5

Page 8 of 25

Simultaneous Optimisation tutorial

Bulk blend

Creating and running a simultaneous optimisation node

You can specify blend constraints on this tab. For this tutorial, there is no need to change the
blend settings they are the same as the blend settings specified on the comparative node.
However, you will need to add the stockpiles into the blend.
10. At the Stockpiles field, click Edit.
The Sources dialog box is displayed.
11. Click All and click OK to add all the stockpiles.

12. On the Schedule tab, enter the same details as you used on the Lead 4:phases 3 4 5 6 node.
That is, use the largest pit as the final pit and add pushback for pits 3, 4, 5, and 6.

13. Click Accept in the lower right corner.


14. Run the simultaneous optimisation node.
When SIMO is processing, the status bar shows you the number of the solution that SIMO is
processing and the NPV of the best solution processed so far.
For more information about solutions, see the Whittle help.

The previous image shows SIMO processing solution 23 which has an NPV of approximately
$1.04 billion.
When processing is complete, a green check mark appears beside the SIMO node.

Gemcom Whittle 4.5

Page 9 of 25

Simultaneous Optimisation tutorial

Bulk blend

Creating and running a simultaneous optimisation node

15. Select the Report tab, and scroll near the end to the list of grand totals.

Underneath Grand.Total.DiscountedCashflow, you can see the total run time that is, the
amount of time the SIMO node took to run.

This SIMO node in the sample bulk blend data, took 5 minutes to run on one computer. In some
situations, SIMO can take much longer to process, and if there is the potential to increase the
NPV of a mine by millions of dollars, the time is well spent.
Higher up on the Report tab, the report shows you the periods in which there was mining
activity. For example, period 15 had no mining activity.

Gemcom Whittle 4.5

Page 10 of 25

Simultaneous Optimisation tutorial

Bulk blend

Examining the schedule results

If you scroll up, you see more periods where there was no mining activity.
Which was the last period that does have mining activity?
Tip: If you are going to run this SIMO node again, you can make SIMO run slightly faster by
adjusting the Period Horizon. On the Optimisation tab in the Period Horizon box, enter one
more than the number of the last period with mining activity.

Examining the schedule results


There are two types of report you can use to examine the schedule.
Report

Description

Schedule Report

Shows details of material mined in each period.

Bench Report

Shows details of material mined in each bench in each period.

To examine the results of the SIMO schedule in a schedule report node, do the following.
1. Right-click the New Simultaneous Optimisation node and choose Add > Schedule Report.
2. Click the Definition tab of the Schedule Graph node.
The Definition tab lists a default set of variables that you can display using the Graph tab. You
can use the Add button to display the Data Selector to add a different variable, but there is no
need to do so at this time in this tutorial.
3. Run the Schedule Report Graph.
4. Click the Output tab.
The Output tab reports the values per period for each of the variables on the Definition tab.

Gemcom Whittle 4.5

Page 11 of 25

Simultaneous Optimisation tutorial

Bulk blend

Examining the schedule results

Tip: To output this data to a spreadsheet, click the Open in Spreadsheet button
toolbar.

on the

5. Click the Summary tab.


A formatted summary of the output is displayed.

In this case, the SIMO NPV is $1041 M which compares with $987 M on the lead 4 node.
To see more information about which benches are being mined, add a bench report.
1. Right-click the New Simultaneous Optimisation node, and choose Add > Bench Report.
2. Select the New Bench Report node and run it.

Gemcom Whittle 4.5

Page 12 of 25

Simultaneous Optimisation tutorial

Bulk blend

Creating a mining sequence file

3. Click the Output tab to view the results.

Creating a mining sequence file


By adding a schedule report graph node you create a long-term schedule that you can export as a mining
sequence (.msq) file for use in a detailed scheduling program.
1. Right-click the Schedule Report graph node, and choose Other > Bulk Export.
2. Select the checkbox for an msq file, and click Run.
3. When you see the prompt that the export has completed successfully, click OK.
The .msq file is created in your project folder.

Gemcom Whittle 4.5

Page 13 of 25

Simultaneous Optimisation tutorial

Extractive blend

Running simultaneous optimisation for an extractive blend scenario

Extractive blend
To run simultaneous optimisation (SIMO) on an extractive blend scenario, the procedure is the same as for a
bulk blend scenario, and the same procedure as for a standard operational scenario.

Running simultaneous optimisation for an extractive blend scenario


1. Open marvinBlend1.fxp.
2. Run all the nodes in the project.
3. Under the Add Stockpiles node, which is an extractive blend scenario node, select the Maintain
soluble copper < 25% + stockpile node and select the Summary tab.

This node returns an NPV of $384M.


4. Add a simultaneous optimisation node under Add Stockpiles.
5. Set it to have the following settings:
l In the Optimisation tab;
l Period horizon: 13
l Advanced Optimisation Settings, Minimum Start points: 5, Maximum Start Points: 10, Number of Best Solutions: 5 (to make it run
faster at the possible expense of NPV).
l In the Blend tab; add all the stockpiles to the blend.
l In the Schedule tab;
l Final Pit: 35

Gemcom Whittle 4.5

Page 14 of 25

Simultaneous Optimisation tutorial

Extractive blend

Running simultaneous optimisation for an extractive blend scenario

Pushbacks: 1, 6, 14, 19, 28, 31, 35

6. Click Accept to save the changes.


Before you run this node, be aware that it can take approximately 11 minutes to run.
7. Add a Schedule Report node under the New Simultaneous Optimisation node.
8. Run to the Schedule Report graph node.
The node returns an NPV of $460M compared to the $384M of the Maintain soluble copper <
25% + stockpile node.

Gemcom Whittle 4.5

Page 15 of 25

Simultaneous Optimisation tutorial

Extractive blend

Viewing the sequence and grades in the 3D viewer

Much of this additional value comes from mining higher grade material in the early periods. You will examine
this in more detail when you add a SIMO node under an operational scenario node.

Viewing the sequence and grades in the 3D viewer


1. Select the Schedule Report graph node beneath the SIMO node.
2. Click
on the toolbar to start the Three-D Viewer.
The Select data to display form is displayed.
3. Click OK.
4. To see which areas are mined in each period, select Show Period, and change the period
number to cycle through the periods.
5. Select Au in the box under Show Data, and fill in the form as shown in the following image.
You can use the Three-D Viewer to see when and where the higher-grade blocks are mined.
Note: Click Invert if you want to give the background a white background. A white
background is useful when you want to paste an image of the Three-D Viewer into a document
and produce a better image when it is printed.

Gemcom Whittle 4.5

Page 16 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining a comparative node

Operational scenario
You can use a simultaneous optimisation (SIMO) node beneath an operational scenario node. First, you will
examine the net present value (NPV) you can achieve using only three stockpiles, one for each rock type:
OX, MX and PM. Then this tutorial will show how you can improve NPV using simultaneous optimisation.

Examining a comparative node


Suppose that you have completed pit optimisation and decided that the best pushbacks to use are 11 12 14
16 20 25 and 31.
1. Open marvin1.fxp.
2. Run all nodes.
3. Under the Buffer stockpile example node, examine the P/B 11 12 14 16 20 25 31 Lead 4 node,
Schedule tab, and Summary tab.

The NPV returned using a Fixed Lead 4 algorithm is approximately $440M.

Gemcom Whittle 4.5

Page 17 of 25

Simultaneous Optimisation tutorial

Operational scenario

Setting up simultaneous optimisation for an operational scenario

Before you try simultaneous optimisation, you might wonder whether you can achieve a higher
NPV just by using a different algorithm. The Milawa algorithm typically returns a result with a
high NPV, so try that.
4. Select the P/B 11 12 14 16 20 25 31 Milawa node, and view the Summary tab.

The Milawa algorithm returns $445M.

Setting up simultaneous optimisation for an operational scenario


Because you do not know how many years of mining activity there will be, you will set the period value to 15
years, which is the mine life in the comparative nodes.
In the following procedure, the nodes you do not need have been deleted to make it easier to see the data
of interest.
1. Add a SIMO node beneath the Buffer Stockpile Example node.

Gemcom Whittle 4.5

Page 18 of 25

Simultaneous Optimisation tutorial

Operational scenario

Setting up simultaneous optimisation for an operational scenario

2. Set Period Horizon to 15.


3. Set the following advanced optimisation settings: Minimum Start Points: 5, Maximum Start
Points: 5, Number of Best Solutions: 5 (to make it run faster at the possible expense of NPV).
4. Generate a suitable number of blend bins.
a. On the Blend Bins tab, select Use equiv. metal grade, and click Generate.
b. Set the number of blend bins for each element to 10.

With ten blend bins for each element, you get a good balance between speed of
processing and NPV returned for the Marvin data set.
In a final optimisation, you could see whether a larger number of blend bins returns a
higher NPV.
5.
6.
7.
8.
9.

c. Click OK.
On the Schedule tab, set the Final Pit to 31 (the same pit number as used in the comparative
pushbacks node).
Add pushbacks 11 12 14 16 20 25 and 31.
On the Description tab, change the description of the node to SIMO 11 12 14 16 20 25 31 so you
can easily see which pushbacks it uses.
Add a Schedule Report node beneath the SIMO node.
Click Accept.
It might take approximately 9 minutes to run this node.

10. Run all nodes.

Gemcom Whittle 4.5

Page 19 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining how the NPV result is calculated

The Schedule Report graph node reports an NPV of $469M, as compared to $440M from the
Lead 4 comparative node and $445M from the Milawa comparative node.

Examining how the NPV result is calculated


You can validate and examine the results that simultaneous optimisation returns using the Definition tab of
the Schedule Report graph node, and the Data Selector. For example, here is how you can find out which
components make up the final NPV amount.
1. On the Schedule Report graph node, select the Definition tab.
Some variables are already listed on this tab. If you wish, you can leave them there.
2. Click Add and use the Data Selector to add the following variables:
l User Specified > Open Pit > Capital > Initial capital expenditure
l Calculated > Open Pit > Output > Discounted revenue and cash flow > Discounted revenue from MILL
l Calculated > Open Pit > Output > Discounted costs > Discounted selling cost of
product from MILL
l Calculated > Open Pit > Output > Discounted costs > Discounted replacement
capital expenditure
l Calculated > Open Pit > Material Mined > Discounted costs > Discounted cost of
mining all rock

Gemcom Whittle 4.5

Page 20 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining how the NPV result is calculated

Calculated > Open Pit > Material processed > Discounted costs > Discounted
cost of processing for MILL
Alternatively, you could add variables based on element, such as Discounted Revenue from Au
and Discounted Revenue from Cu. However, because there is only one processing method
(MILL) and two elements, the set of variables listed in the previous step is easier to work with.
l

3. Run the node.


4. Select the Output tab.
5. Click Open in Spreadsheet
on the toolbar to send the output data to Microsoft Excel.
6. To remove the columns you are not using, delete columns B to M from the spreadsheet.
7. Use Autosum in Excel to calculate the total for each column.
8. In the spreadsheet, calculate the total cost and subtract it from the revenue.

Gemcom Whittle 4.5

Page 21 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining the average grade input to MILL

Look back at the NPV reported on the Schedule Report graph node, Summary tab, which is also
approximately $469.7M.
The currency settings on the Formats tab of the block model node determine the format in
which currency values are reported. In this tutorial, currency values are displayed in thousands
of dollars. Therefore, currency values can be slightly higher or lower than you expect because of
rounding variations.

Examining the average grade input to MILL


Simultaneous optimisation can deliver a higher NPV than other solutions, partly because it allows the
economic cut-off to change in each period rather than to have the same cut-off for all periods. With this
flexibility, SIMO schedules the mining of more of the higher grade material early in the mine life.
You can see this effect by comparing the grades input to the MILL.
1. Add a Schedule Graph node underneath Buffer stockpile example.
2. On the Schedule tab, specify the same final pit and pushback details that you have used in the
other nodes.

Gemcom Whittle 4.5

Page 22 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining the average grade input to MILL

3. In Specified Case Scheduling Algorithm select Milawa NPV , and click Accept.
4. Run the node.
5. Select the Output tab, and click Open in Spreadsheet
on the toolbar.
The grade information is displayed in a spreadsheet. The other columns are of no interest for this
exercise.
6. Now select the Simultaneous Optimisation > Schedule Report graph node, and output the Output tab to a spreadsheet similarly.
Note: Alternatively, you can get the grade data by adding and running a Bench Report node
under the SIMO node.
7. Now copy the Grade input to MILL columns from one spreadsheet to another to compare the
grades.

Gemcom Whittle 4.5

Page 23 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining the average grade input to MILL

8. To see this data in a chart, use the charting tools in Excel to make a line chart that shows both
sets of grades.

Gemcom Whittle 4.5

Page 24 of 25

Simultaneous Optimisation tutorial

Operational scenario

Examining the average grade input to MILL

The charts show that, when you use the SIMO solution rather than the Buffer Stockpile > New
Schedule Graph solution, higher grades of gold and copper are processed through the mill in the
first nine periods.

Gemcom Whittle 4.5

Page 25 of 25

Simultaneous Optimisation tutorial

You might also like