Booking Cost Screens

Overview and Basic Rules

Public Purchase Orders Manual here.

Definition of Cost Lines

Cost lines for bookings are defined in the Admin screen. They allow the following:

  • Cost Category (selected from a hard-coded list)

  • Cost Type (Free text)

  • Whether more than one of the same lines can be added (eg. 1 meeting room at the premium rate shouldn’t be able to be added more than once)

  • Whether a quantity of more than 1 can be added (eg. parking would always be quantity = 1 per line)

Adding Cost Lines

Costs are never added. It is only rates which are added. The rate * quantity gives the total cost.

Before the work is completed, the rate can be added and this calculates the “initial” or “expected” cost.

After the work is completed, the date can be added and this is stored as the “final” or “actual” cost.

Adding Cost Lines after Work Completed

After work is completed, the quantity cannot be amended. This means that any unexpected work has to be added on a separate line, even if it is the same cost type. In this case the line will be marked as “New”. Any change in rate will be stored as the “expected rate”.

Filling in Booking Costs

Purchase Order prior to work being completed. This is the expected cost based on the rates.

Summary of Costs Before Work Complete

Fill-in Details Before Work Complete

Quantity field is only enabled if the line being added has “Can have multiple units” checked in the admin section.

The rate is the expected rate at this point (because the work has not been completed)

Summary of Costs After Work Complete

Fill-in Details After Work Complete

Delete a cost line

Header

A header can be added and amended by clicking in the header. This will allow update of data in the header including

Cost Lines

Cost lines can be added according to the following rules:

  • The cost category defaults to the cost category in the header

  • If a cost type has “can duplicate” = no then only one line can be added for that cost type in that cost category

  • If a cost type has “can have more than one unit” = no then the quantity is 1 without an ability to edit

  • If the “additional information required” field = yes then the label for the additional information field will be shown and the additional information will be required to be added before the cost line can be saved

  • For the Fuel Surcharge https://bigdigit.atlassian.net/browse/WG-778 :

    • If a cost line is subject to a Fuel Surcharge the cost line details should be appended with “(Fuel Surcharge)”.

    • Given the following two conditions:

      • When any cost line being amended which has the flag “Cost subject to fuel surcharge” and

      • A cost line exists with the flag “Cost represents fuel surcharge”, the following should happen:

    • For all cost lines which have the flag “Cost subject to fuel surcharge”:

      • The total should be calculated for fuel surcharge by adding up the total of all costs for lines which have the flag “Cost subject to fuel surcharge” set.

      • A percentage should be applied to the total based on the “surcharge” and stored as the rate for the cost line “Cost represents fuel surcharge”. The total for that line should also be calculated.

        • The “surcharge” is derived from the additional text entered on the cost line with the flag “Cost represents fuel surcharge”. The additional text should contain a real number, eg. “13.5” which should be evaluated as a real number and used as the “surcharge”.

Example of Cost Surcharge

Cost Line

Surcharge Type

Additional Text

Rate

Qty

Total

Cost Line

Surcharge Type

Additional Text

Rate

Qty

Total

1

Cost represents fuel surcharge

13.5

94.5

1

94.5

2

None

 

50

4

200

3

Cost subject to fuel surcharge

 

200

2

400

4

Cost subject to fuel surcharge

 

100

3

300

5

None

 

1000

1

 

  • Surcharge = 13.5 (evaluation of additional text for line 1 (flagged with “Cost represents fuel surcharge”)

  • Lines 3, 4 combined total = 700

  • Lines 2,5 are not subject to fuel surcharge so their total is not in the calculation

  • Line 1 rate = 13.5% x 700 = 94.5 which is shown above.

Cost Lines Ordering

Cost lines are ordered by cost category alphabetically and by order sequence within the cost category.

Costs and Rates Assignment

Costs are added to cost lines by means of a rate and quantity. Once a quantity has been added onto a cost line it can only be changed until the work has been marked as completed.

Here is a table of the fields and how the values can be changed:

Cost Line Field

Add Cost Line

Update Before Work Complete

Update After Work Complete

Notes after Work Complete

Cost Line Field

Add Cost Line

Update Before Work Complete

Update After Work Complete

Notes after Work Complete

Cost Category

Yes

No

No

 

Cost Type

Yes

No

No

 

Additional Info

Yes

Yes

No

 

Quantity

Yes

Yes

No

New cost line must be added if quantity changed

Rate

Yes

Yes

Yes

On update show "Initial rate" - rate prior to being marked as work complete

Notes

Yes

Yes

Yes

Notes can be updated at any time

Create and Send Purchase Order

At the point of dispatch of goods from the warehouse a purchase order is sent to the Final Mile Facility as part of the Pre-Alert to Final Mile Facility documentation. At any point in time after that a purchase order can be issued separately with revised costs. Up until the point of work being completed these are expected costs. After work has been completed the costs should reflect that actual costs of the work being done.

After the booking has been marked with status “work complete” any changes to costs are deemed “actual” costs. Each line which had been added prior to the work being completed has, as a default, the expected (initial) cost the same as the actual cost; however if the cost on that line is subsequently changed there will be a different actual cost.

Status

Expected Cost

Actual Cost

Status

Expected Cost

Actual Cost

< “Work Complete”

Cost (can be updated)

 

>= “Work Complete”

Initial Cost (set to “Cost” before work complete)

Cost (can be updated)

Domain Model

https://bigdigit.atlassian.net/wiki/spaces/TD/pages/3519676497

Validation

Rates can be saved with zero value. https://bigdigit.atlassian.net/browse/WG-869

If additional information is required for a cost (as defined in the Cost Type Definitions in the Adminsitration menu option) the additional information must be entered.

If multiple units can be added (as defined in the Cost Type Definitions in the Adminsitration menu option) then the quantity may be edited to any value otherwise the quantity is 1 without being editable

If duplicates are allowed the same cost type can be entered more than once within a cost category.