Rates DB Air (Requirements)
From UG
Info
- mantis# 0002894: [Rates DB] Implement phase1 for MOT Air
http://ct.jaguarfreight.com/wiki/Rates_DB
Business Analysis and Requirements
To be written by BA. This section should cover Needs, Requirements, Background and Design Ideas. Also could include Glossary, existing business workflow, cases, etc
Glossary
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.
Chargeable Weight of cargo intended for air shipment is the actual gross weight (gw) or the volume weight (vw), whichever is greater.
Actual Gross Weight or GW is the actual weight of the shipment
Volume Weight or VW is calculated based on a cargo's size, measurement or dimensions
Minimum or Min is the lowest amount that can be charged for the service.
Maximum or Max is the highest amount that can be charged for the service.
Flat Fee is a single fixed fee for a service
Unit load device or ULD is a pallet or container used to load freight on an aircraft. It allows a large quantity of cargo to be bundled into a single unit.
- ULD pallets are rugged sheets of aluminum with rims designed to lock onto cargo net lugs
- ULD containers, also known as cans and pods, are closed containers, which, depending on the nature of the goods to be transported, may have built-in refrigeration units
Drum is a cylindrical container used for shipping bulk cargo (a liquid or as a mass of relatively small solids like grains). Drums can be made of steel, dense paperboard (commonly called a fiber drum), or plastics, and are generally used for the transportation of certain dangerous materials or modest quantities of bulk goods.
Known Shipper A shipper that is qualified by specific regulations as a known shipper. A known shipper has less restrictions for shipping and as a result will usually have lower rates.
Unknown Shipper A shipper that has not yet been qualified according to the Transportation Security Administrations regulations as a known shipper. An Unknown shipper's cargo has more restrictions when shipping and therefore may have to pay higher rates to ship cargo.
Hazardous Freight is freight that is capable of posing risk to people, health, property, or environment when transported in quantity. AKA dangerous goods
Business Need
what are we trying to achieve? What are the main goals of this module?
Jaguar Global needs "Air Rates DB module". It is a Tariff and contract management system with additional functionality.
Main Features:
- management of tariffs and contracts (client and vendor sides)
- adding, editing, deleting, listing, searching, sorting, querying
- "Quotations" web portal and internal (for Jag Sales, Ops, Clients, etc)
- searching, sorting, querying and producing an official Jag doc (with number, etc)
Additional Acc features:
- Automated population of charge table in "sales invoices"
- Automated calculation of "estimated P&L"
- Auto approval of PI charges
- Etc
Business Background
Terminology =
Types and Examples of Air contracts
Examples attached to Mantis http://ct.jaguarfreight.com/mantis/view.php?id=2894 .
Sample XLS Quote form. This is what the ISales department uses to create quotes.
Sample PDF Quote form. This is a copy of the quote generated from the above.
Sample XLS Quote Report. Steven Inside Sales Manager has been assigning a quote number to each quote he creates and logging these into an excel sheet to keep track.
Sample of Co-loaders tariff - This is an example of one of the tariffs inside sales uses to search rates offered by one of our co-loaders.
Singapore Rates - This is an example of one of the airlines rate tariffs used by inside sales to search rates offered by an airline.
"FAQ"
How Jaguar deals with Air rates (in all offices) now ?
A Day in the life of NY Inside Sales NOW
A Day in the life of NY Inside Sales ONCE SYSTEM IS IN PLACE
In what form existing Air contracts received and maintained ?
How requests for rates handled (receive, search, answer) ?
Classify all types of existing Air tariffs, provide examples, etc
What is Request format?
What is Output format?
What systems we use for these?
Pre Implementation Architect Notes
Written by Architect after previous section is completed.
Implementation Notes
To be written by Developer or BA by the time UAT is completed. Briefly defines what was implemented and how.
Post Implementation Architect Notes
Written by Architect after previous section is completed.
