Skip to main content

Min and Max price on Weighbridge jobs

This article details how the Min and Max prices functions interact with obs over the Weighbridge

Written by Noel Collings
Updated over a month ago

Overview

When creating a price for a product in Weighsoft it is possible to set a Min or Max Qty that will be factored in when its price is calculated.

Important: Using a Min or Max price will often result in the PPU looking incorrect as the system has to make the Qty x PPU = Total calculation add up correctly in the background.


Min Price

If a Min Price is set on a product then the system will never charge less than that amount on a job, regardless of the Qty on the job.

In the below example we have set a price for the "MIXMUNI" waste type. It has a standard price of £50.00 per tonne, but a Min Price of £25.00.

Normally a job that came in 0.1T would be calculated at the "per tonne" and worked out using Price x Qty = Total, or £50 x 0.1T = £5.

But the Min price tells the system to never charge less than £25. So in this case the system will see that start with the overall total of £25 and work out the rest using Total ÷ Qty = Price, or £25 ÷ 0.1T = £250

However, once the Qty x Price calculation exceeds the pre-set Min Price, the "standard" tonnage price will take over. So in this example the system would charge £25 until the Qty reached 0.5T, at which point it will start to charge £50 per tonne.

Qty

PPU

Total

Adjusted PPU

Adjusted Total

0.1

£50.00

£5.00

£250.00

£25.00

0.2

£50.00

£10.00

£125.00

£25.00

0.3

£50.00

£15.00

£83.33

£25.00

0.4

£50.00

£20.00

£62.50

£25.00

0.5

£50.00

£25.00

£50.00

£25.00

0.6

£50.00

£30.00

-

-

0.7

£50.00

£35.00

-

-

0.8

£50.00

£40.00

-

-

0.9

£50.00

£45.00

-

-

1.0

£50.00

£50.00

-

-

1.1

£50.00

£55.00

-

-

1.2

£50.00

£60.00

-

-


Max Price

Essentially the Max price works the opposite to the Min Price.

If you set a Max price on an item the system will never charge more than that value, regardless of what the actual Qty is.

In the below example the "per tonne" price is set to £50, but it has a Max price of £60.

As an example we have a job that comes in with a Qty of 4. Normally the price would be £200 (£50 x 4). But because there is a Max price of £60 in place, the system will adjust the PPU to £15 per tonne in order to make Qty x PPU = Total add up correctly.

Unlike the Min Price, the system will charge the normal "per tonne" price until the Max Price is reached, at which point it will not charge anything higher.

Qty

PPU

Total

Adjusted PPU

Adjusted Total

0.5

£50.00

£25.00

-

-

0.6

£50.00

£30.00

-

-

0.7

£50.00

£35.00

-

-

0.8

£50.00

£40.00

-

-

0.9

£50.00

£45.00

-

-

1.0

£50.00

£50.00

-

-

1.1

£50.00

£55.00

-

-

1.2

£50.00

£60.00

-

-

1.3

£50.00

£65.00

£46.15

£60.00

1.4

£50.00

£70.00

£42.86

£60.00

1.5

£50.00

£75.00

£40.00

£60.00

2.0

£50.00

£100.00

£30.00

£60.00

2.5

£50.00

£125.00

£24.00

£60.00

3.0

£50.00

£150.00

£20.00

£60.00

3.5

£50.00

£175.00

£17.14

£60.00

4.0

£50.00

£200.00

£15.00

£60.00

Did this answer your question?