GMS

From UG

Contents 1 Info 1.1 Mantis 1.2 Scope 2 Glossary 3 RFC 1 4 BR 1 4.1 General Requirements 4.2 Systems Requirements 4.2.1 Admin Section 4.2.2 Accounting Section 4.2.3 Automated Invoices 4.2.4 Ops 4.2.5 KPI type reporting 4.2.6 Calculation Models: Definitions 4.2.7 Calculation Models: RULES 5 SOW 1

Info

Mantis

• 0003321 [Profit Sharing Module]

Scope

Covers this one module - Profit Sharing Module.

Glossary

RFC 1

BR 1

General Requirements

A “Gross Margin split” is to be implemented between all offices in 2012.

For 2012, the Gross Margin split will follow the suggested rules listed below.

Please keep in mind, every client will be assigned an single “Owner Office”. This office is responsible for selling to and maintaining the relationship with the client and will receive benefits from the related sales through the Gross Margin split.

It is expected that CyberTrax will automatically generate the needed internal invoices which will distribute the Gross Margin to the correct office.

Files will automatically be closed down daily with set dates, after the actual date of departure, according to the mode of shipment as outlined in the table below:

However, functionality will also be provided so CT records can be closed down manually ahead of the ‘automated closing date’ and this is strongly encouraged.

Files can be opened after their system close date for changes by and approved group of users (management or super users), but it is expected this will be the exception.

If a file is “re-opened” after “closing”, it will need to be “closed” again – at which point a recalculation of the GM Margin Split will need to be processed again.

Ability to report on II’s issued automatically will be required, average time it takes for files to be closed, how many files are “re-opened” after closing etc.

Systems Requirements

Admin Section

1. Client Company to JFS Office link “Owner Office”

2. GM Split Models and Percentages table

3. Automated File Closing table (mode, days)

4. Manual file “lock” and “unlock” subject to user type access rights

Accounting Section

1. Ability to view / search automated invoices (report to see II’s only? Multiple lines on reports to see CT level details?

2. Scope requirements for a Gross Margin Split report (I believe we ALREADY HAVE a Gross Margin Split Report)

Automated Invoices

1. Generate automated “detail sheet” showing CT/Record transactional info

Ideally One Invoice between two offices, per day. Attached to that invoice is a ‘detailed report’ for what CT’s are included in the report.

Ops

1. Manual “lock file” feature, “unlock file” feature for selected users

2. Show II in P&L

KPI type reporting

Could we include a KPI type reporting in the Admin Tables?

For example:

• Average time to lock files (per mode, office, team, client) with trending information
• Average files ‘unlocked’ after ‘locked’ – weekly (per mode, office, team, client) w/trending

The idea is to keep KPI’s where they belong rather than clustering them (where they are not “critical”)

Calculation Models: Definitions

OO = Owner Office (Link/Table to be created)

EO = Export Office (identified by “export reference number”)

IO = Import Office (identified by “import reference number”

TO = Third party office (identified by “third party reference number”)

There is a Minimum of 1 “reference number” in a record, with a Maximum of 3 “reference numbers” in Cybertrax.

Reference Numbers: Found on General Tab of CT record (A, B, C)

The OO almost always plays one of the other roles (EO, IO, TO).\

Reference numbers are being automated (Tira is the SA for this task)

Calculation Models: RULES

“Handled by OO” means the OO is either the EO or IO If the “OO” is the “Third Party Reference” the OO did not “handle” the shipment.

60/40 rule – If the shipment is handled between two offices and one is the OO;

60% going to the OO (IO, or EO) and

40% going to the other (non OO) office (IO, or EO)

No TO office under this rule

SOW 1