CK model for Rates DB Air (requirements)

From UG

Contents 1 Info 2 Glossary 3 Summary 3.1 Core need 3.2 Core functionality 4 Some Details

Info

0002690: [Rates DB] ..... <project>

Rates_DB

Glossary

Actual Gross Weight (GW) is the actual weight of the shipment

Volume Weight (VW) is calculated based on a cargo's size, measurement or dimensions

formula for calculating
Using the English System: L x W x H in inches (in.) / 165 = vw (in lbs.)
Using the Metric System: L x W x H in centimeters (cm.) / 6,000 = vw (in kgs.)

Chargeable Weight of cargo intended for air shipment is the actual gross weight (gw) or the volume weight (vw), whichever is greater.

Weight Break is the point at which the weight or chargeable weight of a shipment is large enough to be assessed the lower freight rates which are applicable to larger shipments, this is as per the carrier's tariff.

Volume Cut is discount offered for voluminous cargo. It is the same concept as weight break, but has its own formula to calculate.

If you have freight that is 100 Kilos and the chargeable weight is 200 Kilos, the co-loader or
airline will offer 10.00 per Kilo with a 50/50 volume cut
This means that you will subtract the actual weight from the chargeable weight and divide the sum by 2.  
Add this total to the actual weight and this is the amount you will be paying for.
(200-100)/2 = 50 + 100 = 150 Kilo's 
Next you will need to break this down into an actual per kilo cost.
You will do this by multiplying the 150 Kilos by the rate offered of 10.00.
150 X 10.00 = 1,500.00
Then dividing the sum of this by the chargeable Kilo's to get the actual per Kilo cost.
1,500.00 / 200 = 7.50 per Kilo
*This volume cut can vary and may not always be 50/50, it could be 25/75, 40/60, etc...

Minimum (Min) is the lowest amount that can be charged for the service.

Maximum (Max) is the highest amount that can be charged for the service.

For additional definitions please see Rates_DB#Glossary

Summary

We are rewriting the rate db air - Phase one according to new simplified requirements, provided by Chikei Ho (Module Owner)

Core need

Overall Core need will remain the same:

Jaguar Global needs Tariff and Contract Management System with additional functionality that will improve/affect other areas such as CT creation, invoices, reports, etc.

Core functionality

Creating such "database" should allow operators throughout the organization (including overseas offices) to share and compare this information.

Main Features:

• management of tariffs and contracts (purchase and sales sides)
  • adding, editing, deleting, listing, searching, sorting, querying
    • management of the tariffs should allow operators the ability to update individual tariffs or multiple tariffs at one time. Updating specific charge codes, origin/destination pairings, country to country pairings, E0. clients, bill to, shippers, consignees, etc...
    • management of tariffs should allow operators to schedule increases/decreases in advance.
    • Possibly notify operators of expiration of rates.

NOTE: Purchase side - phase 1 and sales sides - phase 2

Some Details