Modelling Asset Utilisation Plans

Asset utilisation plans are a simple way of presenting clearly the use of assets over a projected period. They are particularly important in industries with high variability or flexibility when it comes to renting and using assets.

What we call an "asset utilisation plan" here is basically a table of flags indicating by 1 or 0 when an asset is or is not in use. As you might notice, this bases on the concept of 1/0 flags, as introduced in the article "Working with Flags". Taking this one step further, you can use the same structure to show the number of instances of one kind of asset.

A prime scenario for using asset utilisation plans is the logistics industry. It is very often the case that, for example, locomotives are only leased for limited timeframes, perhaps seasonally, or when delivery contracts are made "on demand" rather than on a long-term basis. The following example shows what this could look like:

Excel: Asset Utilisation Plan (1)
Excel: Asset Utilisation Plan (1)

In lines 4 to 8, the user can define when a locomotive needs to be used in a month. Lines 12 to 16 contain the monthly fee for the usage of those locomotives. As you can see, there is some variation (price peaks in July/August) - seasonalities like this are actually common in the logistics business. Lines 20 to 25 show the summary over the projected period. As explained above, this is really just the flag concept put into operation:

Excel: Asset Utilisation Plan (2)
Excel: Asset Utilisation Plan (2)

The concept is quite flexible and can be adjusted to specific needs. For example, you could organise the assets (in this case the locomotives) by type to project the financials at a more detailed level.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.