Air freight consolidations often involve a profit share arrangement that is agreed between the sending agent and the receiving agent in order to distribute any profits made on the consolidation. The sum agreed can be part of the profit, part of the turnover or a fixed amount and is paid by the sending agent to the receiving agent. In some cases the entire consolidation or some shipments on the consolidation may represent a loss and in these cases these losses also must be distributed between the agents. The usual arrangement is to share 50% of the profits or losses. The Profitshare application calculates these figures using all the figures from the house and the master to arrive at the correct amounts. On completion of the calculation it is possible within the Profitshare application to issue the appropriate invoice or credit note. These vouchers will be created according to the setup of the receiving agent in the partner maintenance and may include a consol profit analysis sheet. To further automate the process of setting up profit share arrangements between agents, a CPA template can be created and applied to receiving agents as necessary. The calculation of profitshare can then take place automatically based on the settings in this template.
- If a CPA template is present in the receiving agents master data, then this will be used.
- If a CPA template is *not+ present in the receiving agents master data, but a default CPA template CPA Templates is present, then this default will be used
- If no CPA template of any kind is present, then no data will appear in the profitshare tab.
The data that appears can be overridden if required, it may be edited, removed or new data added.
- The Jobcosting of the house shipments must be complete before automatic profit share can be calculated on the consolidation.
- Due to the extensive calculations that may have to take place, depending on the number of house shipments on the consolidation, the transfer of data to the profit share screen may take some time.
This area contains the general information about the calculation.
This field will display one of three possible share types used for this business partner:
Participation in profits
Participation in sales
Agreed fixed amount
The amount of share between the parties is displayed. For profit or turnover this will appear as a set percentage. For a fixed share, the actual fixed amount will appear in the local currency. Normally profit share is a 50% profit split between the agents.
Total Share Amount
The calculated profit share of the master shipment will appear (This figure cannot be edited).
This table shows the total costs on the master shipment. For each cost the charge type and actual cost figure are shown.
Opens a pop-up window in which new charges may be entered.
Enter the kind of charge, using the field search function to find the desired charge type.
the actual cost of the charge should be entered. A calculator is available from the drop down menu.
Closes the pop-up menu and transfers the data to the master shipment cost table.
Closes the pop-up menu without further action
Opens in a pop-up window the master cost highlighted in the table. (The charge type cannot be changed, to do this the charge should be deleted and then re-entered in the master shipment.) The charge can also be edited by double clicking it.
Deletes the charge highlighted in the master cost table.
this summary table will show all the house shipments consolidated on this master. The table will show the air waybill number, the number of packages, gross weight, volume, share type, % share and the share amount.
This button will open in a pop-up window, the house shipment highlighted in the house summary table. The house can also be opened by double clicking it.
The house air waybill number. (this field cannot be edited)
The type of profit share applied to this house. The share type used at the master level is used but this can be changed as desired.
The share percentage used for the calculation. The share percentage used at the master level is shown but this can be changed as desired for each house.
The calculated amount of the profit share on the house shipment. These amounts are shown on the profit share statement (This field cannot be edited)
House Shipment - Revenues and Costs
This summary table shows the revenues and costs of the house shipment highlighted in the house shipment's summary table. (The columns are described by the following pop-up window that appears if a charge is to be added or edited).
Opens a pop-up window in which new costs and income can be added to the current house shipment.
The new charge for which costs and revenue are going to be recorded. Use the field search function to locate the desired charge type.
The income for the charge that is being applied to the current house shipment. The field offers a calculator function.
The cost of the charge being applied to the current house shipment. The field offers a calculator function.
The calculated profit based on the income minus the cost. (This field cannot be edited).
Include in Profit Share.
This check-box indicates if the charge should be included in the calculated profit share.
Opens the charge highlighted in the table showing the summary of house charges. This charge can then be edited. (It is not possible to edit the costs on a charge. To do this the charge should be deleted and re-entered). The charge can also be opened by double clicking it.
deletes the charge from the table showing the summary of house charges.
This action link will restore the profit share tab to it's original condition, removing any changes made to it.
Opens a pop-up window to generate the required documents for the profit share.
Generate Profitshare Voucher
Check this box to generate the profit share voucher. Generation only occurs when the OK button is used (see below).
Profit Share Statement
Check this box to prepare a profit share statement. Generation only occurs when the OK button is used (see below).
Save the profitshare spreadsheet and prepare the selected documents. Closes the pop-up window and the profit share application.
Closes the pop-up window without further action.
Closes the pop-up window without further action.
On completion including generation of all profit share documents, if a profit share calculation is re-opened and reissued, on pressing OK a pop-up window will appears asking if the previous profit share is to be cancelled and replaced by this new profit share.
In most fields within the spreadsheet Consol Profit Analysis application a calculator can be opened with the F3 function key or by using the drop-down menu. This calculator is used for quick and easy recalculation of tariffs.
Rate per unit.
Number / amount of units.
The basic units can be selected from the following drop-down list:
- No. of items
- Chargeable weight
- Gross weight
- Manual entry
Commits the calculated figure to the field where the calculator was called-up and closes the calculator.
Closes the calculator without further action.