GMS

From UG

Revision as of 03:01, 27 December 2011 (edit) Alex (Talk | contribs) (→20/40/40 rule) ← Older edit		Revision as of 03:20, 27 December 2011 (edit) (undo) Alex (Talk | contribs) (→20/80 rule) Newer edit →
Line 141:		Line 141:
	Only 1 office on the record (cannot be the OO)\		Only 1 office on the record (cannot be the OO)\
		+
		+	100% rule
		+
		+	– If a shipment is handled and owned by only one office, the only office listed in the ‘ref’ numbers is also the OO
		+
		+	100% GM goes to the OO
		+
		+	Only 1 office on the record (must be the OO)
		+
		+	==== From Alex: table of cases ====
		+
		+	{| {{table}}
		+	| align="center" style="background:#f0f0f0;"|'''Case'''
		+	| align="center" style="background:#f0f0f0;"|'''Profit distribution'''
		+	| align="center" style="background:#f0f0f0;"|'''OO handling'''
		+	|-
		+	| this CT||Additional office A handling this CT||Additional office B
		+	|-
		+	| handling this CT
		+	|-
		+	| 60/40||*60% to OO
		+	|-
		+	| *40% to office A||EI or IO ||EI or IO||none
		+	|-
		+	| 45/45/10||45% to OO
		+	|-
		+	| 45% to office A
		+	|-
		+	| 10% to office B||EI or IO||EI or IO||TO
		+	|-
		+	| 20/40/40||20% to OO
		+	|-
		+	| 40% to office A
		+	|-
		+	| 40% to office B||TO||EI or IO||EI or IO
		+	|-
		+	| 20/80||20% to OO
		+	|-
		+	| 80% to office A||none||EI or IO||none
		+	|-
		+	| 100||100% to OO||EI and IO||none||none
		+	|-
		+	|
		+	|}
	== SOW 1 ==		== SOW 1 ==

---

Revision as of 03:20, 27 December 2011

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 4.2.7.1 60/40 rule 4.2.7.2 45/45/10 rule 4.2.7.3 20/40/40 rule 4.2.7.4 20/80 rule 4.2.8 From Alex: table of cases 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

45/45/10 rule

If a shipment is handled by an OO and a sister office is noted as the import or export office on the record with a third office handling other details,

45% of GM to the OO (IO, or EO);

45% to the handling office listed on the record and (IO, or EO – non OO)

10% to the 3rd office involved (TO, non OO)

TO cannot be = to OO under this rule

20/40/40 rule

If a shipment is not handled by an OO and two other office are listed as the export and import offices,

20% of GM to the OO (TO)

40% to each handling office (IO and EO)

TO must be = to OO under this rule

20/80 rule

If a shipment is handled by only one office but is not owned by that office,

20% of GM is attributed to the OO

80% to the handling office (IO, EO)

No TO Office under this rule

Only 1 office on the record (cannot be the OO)\

100% rule

– If a shipment is handled and owned by only one office, the only office listed in the ‘ref’ numbers is also the OO

100% GM goes to the OO

Only 1 office on the record (must be the OO)

From Alex: table of cases

Case	Profit distribution	OO handling
this CT	Additional office A handling this CT	Additional office B
handling this CT
60/40	*60% to OO
*40% to office A	EI or IO	EI or IO	none
45/45/10	45% to OO
45% to office A
10% to office B	EI or IO	EI or IO	TO
20/40/40	20% to OO
40% to office A
40% to office B	TO	EI or IO	EI or IO
20/80	20% to OO
80% to office A	none	EI or IO	none
100	100% to OO	EI and IO	none	none

SOW 1