Estimated P and L based on history

From UG

Revision as of 22:38, 15 February 2012 (edit) Alex (Talk | contribs) (→SOW 1) ← Older edit		Revision as of 19:10, 16 February 2012 (edit) (undo) Alex (Talk | contribs) (→SOW 1) Newer edit →
Line 34:		Line 34:
-	== SOW 1 ==	+	== Proposal ==
-		+
-	Please note that SOW 1 covers "Air" only.	+
	=== Concept ===		=== Concept ===
		+
		+	=== Phases ===
		+	I suggest to create solution for MOT Air first.
		+
		+	Also before incorporating functionality into the system do [[#Feasibility study]] that assumes generating "ad hoc" reports.
	=== Feasibility study ===		=== Feasibility study ===
Line 55:		Line 58:
	Report it as a DB/KPI report.		Report it as a DB/KPI report.
		+
		+	== SOW 1 ==
		+	TBD

---

Revision as of 19:10, 16 February 2012

Contents 1 Info 2 Requirements 2.1 Requirements Submitted by MO 2.2 Requirements Analysis 3 Proposal 3.1 Concept 3.2 Phases 3.3 Feasibility study 3.4 Add option to P n L report 3.5 Add option to P n L tab 3.6 Dashboard report 4 SOW 1

Info

• parent: 0002515 [Estim P&L / Accruals] .......<parent>

Requirements

Requirements Submitted by MO

Objective: Gain some visibility into the organization’s financial result, while we wait for an automated, exact and integrated solution (feed from cost and vendor rate database)

The proposal is to estimate costs and revenues on a per shipment basis, utilizing historical information from Cybertrax.

The requirement would be for Cybertrax to generate daily “statistics” compiling a total cost and revenue figure, per container (FCL), cubic meter (LCL), or chargeable KG (air).

The above for shipments ‘closed’ in Cybertrax according to the new 2012 GM Split and related file closing guidelines.

New shipments, upon confirmation of an actual departure date, would populate an estimated P&L based on historical information, based on the following:

1.	Client
2.	Mode
3.	Origin
4.	Destination

In the absence of a previous record for this client, the shipment would look for an identical country to country pairing in Cybertrax. This estimate would get a 80% rating.

In the absence of historical data for the specific country to country pairing the estimated P&L would not populate.

A dashboard report showing records with an actual departure date, and no estimated P&L, can also be implemented.

Requirements Analysis

Proposal

Concept

Phases

I suggest to create solution for MOT Air first.

Also before incorporating functionality into the system do #Feasibility study that assumes generating "ad hoc" reports.

Feasibility study

Add option to P n L report

See Table A on Figure under #Concept.

Add option to P n L tab

Dashboard report

Report CTs that have no estimation due to absence of appropriate (MOT, Client, Country From, Country To) combination in the system.

Report it as a DB/KPI report.

SOW 1

TBD