Page tree
Skip to end of metadata
Go to start of metadata

Introduction

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.

 

Description

When the application is launched it checks if a CPA template is present in the receiving agents master data.

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.

The scope profit share application includes a default CPA Template for most Agents in order for most fields to be filled in general usage. However the information below discusses each field as if it is empty.

General

This area contains the general information about the calculation.

Invoice to

The destination agent who will receive the profits. The search function of the field can be used to locate the desired agent.

Share Type

This field will display one of three possible share types used for this business partner:

Type

Description

Profit

Participation in profits

Turnover

Participation in sales

Fixed amount

Agreed fixed amount

Share

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).

Master Costs

This table shows the total costs on the master shipment. For each cost the charge type and actual cost figure are shown.

New

Opens a pop-up window in which new charges may be entered.

Charge type

Enter the kind of charge, using the field search function to find the desired charge type.

Cost

the actual cost of the charge should be entered. A calculator is available from the drop down menu.

OK

Closes the pop-up menu and transfers the data to the master shipment cost table.

Cancel

Closes the pop-up menu without further action

Edit

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.

Delete

Deletes the charge highlighted in the master cost table.

House Shipments

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.

Properties

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.

HAWB

The house air waybill number. (this field cannot be edited)

Share Type

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.

Share Percentage

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.

Share Amount

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).

New

Opens a pop-up window in which new costs and income can be added to the current house shipment.

Charge Type

The new charge for which costs and revenue are going to be recorded. Use the field search function to locate the desired charge type.

Revenue

The income for the charge that is being applied to the current house shipment. The field offers a calculator function.

Cost

The cost of the charge being applied to the current house shipment. The field offers a calculator function.

Profit

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.

Edit

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.

Delete

deletes the charge from the table showing the summary of house charges.

Recalculate Profitshare

This action link will restore the profit share tab to it's original condition, removing any changes made to it.

OK

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).

OK

Save the profitshare spreadsheet and prepare the selected documents. Closes the pop-up window and the profit share application.

Cancel

Closes the pop-up window without further action.

Cancel

Closes the pop-up window without further action.

Subsequent changes

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.

Calculator

 

 

 

 

 

 

 

 

 

 

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

Rate per unit.

Basis

Number / amount of units.

Base Unit

The basic units can be selected from the following drop-down list:

  • No. of items
  • Chargeable weight
  • Gross weight
  • Volume
  • Manual entry
Result

Calculated result

OK

Commits the calculated figure to the field where the calculator was called-up and closes the calculator.

Cancel

Closes the calculator without further action.