Task #18576
Updated by Redmine Admin 3 months ago
**What is the Air Shipment cost?** Air shipment cost is the total expense incurred to transport goods by air from the origin (exporter’s location/airport) to the destination (importer’s location/airport). It is not just the airline freight charge, but for a combination of: **1. Air Freight Charges** forwarder?** * The main air shipment cost paid refers to the Airline/Freight Forwarder for carrying the goods. * Calculated on the chargeable weight, whichever highest between purchased / gross weight all cost which is associated to a shipment and Total volumetric weight: (a) Purchased / Gross weight = actual weight of cargo. (b) Volumetric weight = space cargo occupies, based on following formula: _(L × W × H) ÷ 6000_. _To to be calculated in cm._ **2. Origin Charges** * Handling fees (airline handling, terminal charges). * Documentation fees (Air Waybill preparation, customs export declaration). * Pick-up or trucking charges. **3. Local Charges** * Delivery order fee (charged borne by airline/forwarder). * Handling and storage fees at the airport terminal. **Why a freight forwarder uses forwarder, for instance, (a) Air shipment cost??** A freight forwarder uses ‘**Air shipment cost’** because it is the basis for pricing, planning, Freight Charges (b) Security charges (c) Handing charges and managing the movement of goods by air on behalf of their clients. others For example: **Pre-Conditions** **Quoting to Customers** * The forwarder must prepare quotations for shippers (exporters/importers). * The air shipment cost allows them to calculate the total landed cost (freight + origin charges + local charges). **Profit Margin Calculation** * Forwarders usually add a service fee or margin on top of the base air shipment cost. * Without knowing the cost structure, they cannot price competitively or profitably. **What are the Pre-conditions?** The Supplier / Airline basic information 'Flight' should be present in the system already available to proceed with create the ‘Air Shipment cost’. **What are the Acceptance criteria?** The user should be able to: I. Create the Air Shipment shipment cost. II. Modify / Edit the Air Shipment cost. III. Saving **Contents of the Air Shipment cost. IV. Having an activity log indicating every change and by whom. V. Generation of a unique identifier for each Air shipment cost. VI. Having different filtering option. VII. Automatic calculation of the Air Freight charges VIII. Cloning of the Air shipment cost **Contents of the ‘Air Shipment cost’ 'Shipment cost' Screen:** 1. Display a list of Air Shipment cost. Columns to be displayed are: <table> | Master File Ref | Shipment Ref | Shipment type | Airline | Volume | | <tr> |-----------------|--------------|---------------|---------|-------:|--| <td>Shipment Ref</td> <td>Create date</td> <td>Supplier</td> <td>MAWB Ref</td> <td>Shipment Channel</td> <td>Status</td> </tr> <tr> <td>MACCS25SCAI090001</td> <td>09/09/2025 11:00</td> <td>Air Mauritius</td> <td>239-24521070</td> <td>Import</td> <td>Final</td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> | MACCS25MAFE07117 | MACCS300725SHC07049 | IMPORT | AIR MAURITIUS | 10 | Edit / Delete / Clone | Option to filter by: I. Shipment Reference II. Date Range III. Supplier IV. MAWB number V. Shipment channel VI. Status 2\. 2. Display an ‘ADD Air 'Add Shipment cost’ button. 3\. cost' button 3. Fields to be displayed when clicking on the ‘Add Portfolio’ 'Add Shipment cost' button are as follows: Main Header: AIR SHIPMENT COST a. Shipment Reference – Auto generated b. Shipment channel – (a) Cargo Type - Import / or Export (Dropdown) \[Toggle\] c. Freight Type: Collect / Prepaid (Dropdown) – See related conditions (1) (b) Flight \[To be retrieved from Flight List\] d. * Upon selection of the Flight, information like 'ATP' and 'Arrival Date and time' should be populated in the respective field namely ATP Number and Expected Arrival date and time. (c) Status – - Provisional / Final (Dropdown) Purchased \[Dropdown list\] e. Agent – Dropdown of all Suppliers of type Freight forwarders (Dropdown) – See related conditions (2) f. Airline – Display (d) Airline/Agent - Provide List of Airlines (Dropdown) – Relates to condition (2) suppliers from maintenance \[Dropdown list\] g. Origin – Display list of Airport (Dropdown) h. Destination – Display list of Airport (Dropdown) i. Chargeable weight (Kgs) – Non editable field j. Purchased weight (Kgs) – (e) Volume - Numeric value including 3 decimal places Value and should accept 3dp k. Airway Bill (f) MAWB Reference Dimension (Volumetric Weight) – Display below column (g) Commodity Type \[Optional Field\] a. Length (cm) **Insert an 'ADD CHARGES' button -** Charges which are associated to the shipment. b. Width (cm) c. Height (cm) d. Volumetric weight (Kgs) – To be calculated automatically based Upon clicking on the formula: (LxWxH) _÷_ 6000 e. Display an ADD button f. Display an Edit button for each row g. Display 'Add charges button', give a Total of pop-up so that the Volumetric weight user can insert below information. **HEADER 1: Air Freight Charges** (a) Charges \[Dropdown - From Maintenance charges\] Display below columns: (b) Type \[Dropdown - Collect / Prepaid\] a. Charge type – List of charges (Dropdown) b. Unit of measure – (Dropdown (c) Currency \[Dropdown list – Per MBL, Per HBL etc.) - From maintenance currency\] c. Chargeable weight – (pick the highest value – Between Purchased weight (d) Amount \[Numeric Value and Volumetric weight) – Read only field d. Price / kgs – Numeric value including 2 decimal places (Value should accept to be picked from the supplier portfolio. 3dp\] e. Currency – List of currency from Maintenance (Dropdown) f. VAT Type – List of (e) Vat type \[Dropdown - Picked from maintenance (Dropdown) VAT\] g. VAT (f) Vat Amount – Calculate the VAT amount \[To be calculated automatically based on the vat type – Non editable field. Amount and Vat type\] h. Display an ADD button (g) Total Amount Inclusive vat. i. Display an Edit button for each row. (h) Exchange Rate \[Dropdown - Pick from Exchange Rate maintenance screen\] (i) Additional Information **HEADER 2: Origin Charges** (j) Supplier - \[Dropdown - Picked from supplier maintenance\] Display below columns: (k) Supplier Invoice date - \[Calendar\] a. Charge type – List of charges (Dropdown) (l) Supplier Invoice Reference \[Free text\] b. Unit of measure – (Dropdown list– Per MBL, Per HBL etc.) (m) Payment Request column \[Indicate if payment request has been made towards the Accounting Department\] c. Quantity – (Numeric Value) d. Price / kgs – Numeric value including 2 decimal places e. Currency – List of currency from Maintenance (Dropdown) f. VAT Type – List of Vat from maintenance (Dropdown) g. VAT Amount – Calculate After All the VAT amount based on the vat type – Non editable field. information has been inserted, system should provide: h. Display an ADD (a) Add button i. Display an Edit (b) Cancel button for each row. **HEADER 3: Local Charges** Display below columns: a. Charge type – List of Once all data has been inserted, at charges (Dropdown) b. Unit of measure – (Dropdown list– Per MBL, Per HBL etc.) c. Quantity – (Numeric Value) d. Price / kgs – Numeric value including 2 decimal places e. Currency – List of currency from Maintenance (Dropdown) f. VAT Type – List of Vat from maintenance (Dropdown) g. VAT Amount – Calculate level, the VAT amount based on user should be able to 'EDIT' or 'DELETE' the vat type – Non editable field. h. Display an ADD button i. Display an Edit button for each row. **Special conditions:** **HEADER 4: Summary** Display below columns: a. Category – List of (i) Air Freight charges (ii) Origin charges (iii) Local charges b. Amount – Numeric Value including 2 decimal places c. Currency – Display list of currency from maintenance. **Conditions:** 1\. (a) If ‘Prepaid’ 'STATE is selected, 'Provisional' the Air Freight section needs to shipment charges row shall not be disabled. mandatory. 2\. If an ‘Agent’ (b) In the event, a File reference is selected, take ‘rate’ from associated to the portfolio for 'Shipment Cost' system shall not allow 'Deletion' of the selected agent **NOT** for the Airline shipment cost. **Else** If no Agent is present, then take the ‘rate’ (c) Allow cloning of the selected Airline from 'Shipment Cost' with all available information \[This option will be used in case the portfolio. Aircraft has 'Skipped' Plaisance Airport Terminal due to cyclonic condition\] **Proposed Template:** (d) Display 'Skipped' if flight is marked as same. {width=646 height=546} Do you require any additional information with regards to this User Story please let us know.