2565 dev

From UG

(Difference between revisions)
Jump to: navigation, search
 
(16 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:RFD]]
+
[[Category:Estimated P and L]]
== Info ==
== Info ==
Mantis: 0002565: [Estim P&L] Implement phase 1
Mantis: 0002565: [Estim P&L] Implement phase 1
-
== Requirements and Solutions ==
+
== Glossary ==
-
 
+
-
 
+
-
=== Glossary ===
+
'''Gross Margin report''' - same as "P/L report".
'''Gross Margin report''' - same as "P/L report".
Line 15: Line 12:
'''Actual Gross Margin''' = actual sale minus actual cost.
'''Actual Gross Margin''' = actual sale minus actual cost.
-
'''Point Of Revenue Recognition''' - Point in time (date) when "Sale" for shipment order (CT) is considered complete. It is MOT specific:
+
'''Point Of Revenue Recognition''' - Point in time (date) as defined below:
* For Ocean LCL and FCL Shipments this date is [[#Port Of Loading Actual Date]]  
* For Ocean LCL and FCL Shipments this date is [[#Port Of Loading Actual Date]]  
Line 21: Line 18:
* For Truck shipments this date is [[#Actual Export Pick Up Date]]
* For Truck shipments this date is [[#Actual Export Pick Up Date]]
-
'''Month-end closing''' - an accounting procedure undertaken at the end of the month to close out that month. In the context of this project and our business it means '''to compile a "P/L" report that have all CTs with Point Of Revenue Recognition date falling within that month'''. To make this report meaningful estimated cost and sales numbers for every CT should be present. In this case we will see Estimated total cost, sale and Gross Margin for entire business. Margin will indicate how much money business made (or lost) that month.
+
'''Month-end closing''' - an accounting procedure undertaken at the end of the month to close out that month. In the context of this project and our business it means ''to compile a "P/L" report that have all CTs with Point Of Revenue Recognition date falling within that month''. To make this report meaningful estimated cost and sales numbers for every CT should be present and matched. In this case we will see Estimated total cost, sale and Gross Margin for entire business. Margin will indicate how much money business made (or lost) that month.
== Requirements ==
== Requirements ==
In a nutshell we need:
In a nutshell we need:
-
* 1) Mechanism to enter estimated cost and sale figures for every CT. Allow for 2 options:
+
* 1) '''Mechanism to enter estimated cost and sale''' figures for every CT. Allow for 2 options (to be selected by operator):
-
** a) operators enters both cost and sale figures manually
+
** a) operator enters both cost and sale figures manually
-
** b) operator enters cost manually and system automatically calculates sales as:
+
** b) operator enters cost manually (per selected charge code) and system automatically calculates sales, use formula below:
-
  sales = (cost * m%)+ cost  
+
  If charge code starts with 12 then:
-
*** NOTE: value m should be managed through Admin
+
    sales = cost
-
NOTE: this will be entered per charge code as usually on TOC
+
Else
-
* 2) Mechanism to remind operators about CTs in the system that do not yet have cost estimated (use [[Dashboard]] approach)
+
    sales = (cost * margin/100)+ cost  
-
* 3) Add sub-report to [[Profit Loss for Multiple CTs]] for '''Month-end closing''' (see [[#Glossary]])
+
-
Please also note that in the future new "Rates and Costs Tables" will be added that would allow to manage rates in the system. This means that operators would not need to enter costs manually - they could be pulled from the system.  
+
NOTE: Allow for default margin to be stored in Admin (per charge code)and edited by operator as they enter TOC lines.
-
== Solution ==
+
* 2) '''Mechanism to remind operators''' about CTs in the system that do not yet have cost or sale estimated (use [[Dashboard]] approach)
 +
** Different groups of operators are to be responsible for entering estimated cost/sale for particular CT. See [[#Estimated GM Dashboard]]
-
Estimation for freight charges:
+
* 3) Add '''Month-end closing''' report (see [[#Glossary]])  
-
*Pull the estimated sell rate from a database to be entered under the client profile (to be handled on phase 2)
+
-
**If nothing is in the database that matches the required information(TBA defined in Phase 2)the system should automatically calculate the estimated sell by:
+
-
***Pull cost from a database (to also be handled in phase 2) and add 15% to it.  The estimated sell should equal the total of the (cost x 15%)+ cost
+
-
**Work around for Phase one - Operators should manually enter cost.  The sell should calculate automatically be based on the above calculation.
+
-
*Operators will need to be able to edit the costs and sell and cost or sell estimations manually.
+
-
*They should also be able to add and remove lines from the estimation.
+
-
Exception:
+
-
*Customs Cost's
+
-
**Charge Codes beginning with 12 should have no calculation.  The sell should match the cost entered.  (System should copy same number from cost to sales field).
+
-
**The operators should still be able to manually update the cost and sell and the cost or sell.
+
 +
Please also note that in the future new "Rates and Costs Tables" will be added that would allow to manage rates in the system. This means that operators would not need to enter costs and sales manually (in most cases) - they could be pulled from the system.
-
====Estimated Cost====
+
=== Estimated GM Dashboard ===
-
should reflect:
+
New type of dashboard panel required.
-
* Dollar Amount
+
-
* Vendor
+
-
* Currency
+
-
* Charge Code
+
-
* Charge Code Description
+
-
*      Total of all estimated Cost entered should be shown
+
-
*      Currency of the total estimated Cost should be shown
+
-
====Estimated Sell====
+
It should show how many CT records passed Point Of revenue recognition AND are '''not estimated'''.
-
should reflect:
+
-
* Dollar amount
+
-
* Currency
+
-
*      Charge Code
+
-
*      Charge Code Description
+
-
*      Total of all estimated sell entered should be shown
+
-
*      Currency of the total estimated sell should be shown
+
 +
'''CT is not estimated''' if total estimated cost or total estimated sales is 0.
-
====Reports====
+
Operator should have CT posted to this dashboard if the following criteria is met:
-
*Should be able to generate a report showing both estimated cost/sell and actual cost/sell
+
-
*The report should be per CT record
+
-
*should be within a selected time frame
+
-
*should able to download to excel
+
-
[[File:Estimation Report.JPG]]
+
* CT records passed Point Of revenue recognition AND
-
[[File:Report terms.JPG]]
+
* ''CT is not estimated'' AND
 +
* this CT is coming into the region handled by this operator's office:
 +
** AIR: country's region for [[Ct#Airport_Of_Destination]] is the same as operator's office region defined in ''Admin>Geography>Regions'' mapping
 +
** OCEAN: country's region for [[Ct#Destination_Terminal]] is the same as operator's office region defined in ''Admin>Geography>Regions'' mapping
 +
** TRUCK: country's region for [[Ct#Export_Delivery_To_Address]] is the same as operator's office region defined in ''Admin>Geography>Regions'' mapping
-
==== Dashboard ====
+
== Solutions ==
-
New type of dashboard panel required.
+
-
It should show how many CT records passed Point Of revenue recognition AND are '''CT is not estimated'''.
+
We need to address 3 things:
-
'''CT is not estimated''' - grand total is 0 on EstTab.
+
=== Mechanism to enter estimated cost and sale ===
-
===== Dashboard visibility =====
+
Access to Panel similar to below could be added to the system.
 +
Ideally we should have a link to the panel from CT profile.
-
To identify which operator should have CT posted to this dashboard the following criteria must be met:
+
[[File:Est pnl.JPG]]
-
* CT records passed Point Of revenue recognition AND
+
=== Mechanism to remind operators ===
-
* ''CT is not estimated'' AND
+
-
* operator belongs to the office that handles the specified region:
+
-
** [[Ct#Airport_Of_Destination]]/[[Ct#Destination_Terminal]]/[[Ct#Export_Delivery_To_Address]] belongs to the region defined in ''Geography>Regions>Office field'' for this given operator
+
 +
Solution fully defined in [[#Requirements]] section
 +
=== Add Month End Closing report ===
 +
They suggested adding "sub-report" to [[Profit Loss for Multiple CTs]]
 +
To do that we could add "Point of revenue recognition" date type on filters page. And if that is selected on output add columns:
 +
* estimated sales
 +
* estimated cost(purchase)
 +
* estimated margin (P/L)
 +
 +
Also they asked to add estimated cost and sales figures to CT's P/L Tab.
== Architect Review ==
== Architect Review ==
Line 104: Line 85:
== QA Plan ==
== QA Plan ==
== History ==
== History ==
 +
 +
1) Kostya suggested re-using TOC panel on Import tab for entering estimation. Tracie does not want to re-use. Should be a separate space.
 +
 +
2) I re-wrote item "1b" in http://mantis.jaguarfreight.com/wiki/2565_dev#Requirements to allow for default margin to be stored in Admin (per charge code)and edited by operator as they enter TOC lines
 +
 +
3) I updated http://mantis.jaguarfreight.com/wiki/File:Est_pnl.JPG to accommodate #2 above.
 +
 +
--[[User:Alex|Alex]] 12:57, 3 January 2011 (EST)Alex

Current revision as of 18:16, 13 February 2012


Contents

[edit] Info

Mantis: 0002565: [Estim P&L] Implement phase 1

[edit] Glossary

Gross Margin report - same as "P/L report".

Estimated Gross Margin = estimated sale minus estimated cost.

Actual Gross Margin = actual sale minus actual cost.

Point Of Revenue Recognition - Point in time (date) as defined below:

Month-end closing - an accounting procedure undertaken at the end of the month to close out that month. In the context of this project and our business it means to compile a "P/L" report that have all CTs with Point Of Revenue Recognition date falling within that month. To make this report meaningful estimated cost and sales numbers for every CT should be present and matched. In this case we will see Estimated total cost, sale and Gross Margin for entire business. Margin will indicate how much money business made (or lost) that month.

[edit] Requirements

In a nutshell we need:

  • 1) Mechanism to enter estimated cost and sale figures for every CT. Allow for 2 options (to be selected by operator):
    • a) operator enters both cost and sale figures manually
    • b) operator enters cost manually (per selected charge code) and system automatically calculates sales, use formula below: 
If charge code starts with 12 then:
   sales = cost
Else 
   sales = (cost * margin/100)+ cost

NOTE: Allow for default margin to be stored in Admin (per charge code)and edited by operator as they enter TOC lines.

  • 2) Mechanism to remind operators about CTs in the system that do not yet have cost or sale estimated (use Dashboard approach)
    • Different groups of operators are to be responsible for entering estimated cost/sale for particular CT. See #Estimated GM Dashboard
  • 3) Add Month-end closing report (see #Glossary)

Please also note that in the future new "Rates and Costs Tables" will be added that would allow to manage rates in the system. This means that operators would not need to enter costs and sales manually (in most cases) - they could be pulled from the system.

[edit] Estimated GM Dashboard

New type of dashboard panel required.

It should show how many CT records passed Point Of revenue recognition AND are not estimated.

CT is not estimated if total estimated cost or total estimated sales is 0.

Operator should have CT posted to this dashboard if the following criteria is met:

  • CT records passed Point Of revenue recognition AND
  • CT is not estimated AND
  • this CT is coming into the region handled by this operator's office:
    • AIR: country's region for Ct#Airport_Of_Destination is the same as operator's office region defined in Admin>Geography>Regions mapping
    • OCEAN: country's region for Ct#Destination_Terminal is the same as operator's office region defined in Admin>Geography>Regions mapping
    • TRUCK: country's region for Ct#Export_Delivery_To_Address is the same as operator's office region defined in Admin>Geography>Regions mapping

[edit] Solutions

We need to address 3 things:

[edit] Mechanism to enter estimated cost and sale

Access to Panel similar to below could be added to the system. Ideally we should have a link to the panel from CT profile.

File:Est pnl.JPG

[edit] Mechanism to remind operators

Solution fully defined in #Requirements section

[edit] Add Month End Closing report

They suggested adding "sub-report" to Profit Loss for Multiple CTs

To do that we could add "Point of revenue recognition" date type on filters page. And if that is selected on output add columns:

  • estimated sales
  • estimated cost(purchase)
  • estimated margin (P/L)

Also they asked to add estimated cost and sales figures to CT's P/L Tab.

[edit] Architect Review

[edit] Implementation Notes

[edit] QA Plan

[edit] History

1) Kostya suggested re-using TOC panel on Import tab for entering estimation. Tracie does not want to re-use. Should be a separate space.

2) I re-wrote item "1b" in http://mantis.jaguarfreight.com/wiki/2565_dev#Requirements to allow for default margin to be stored in Admin (per charge code)and edited by operator as they enter TOC lines

3) I updated http://mantis.jaguarfreight.com/wiki/File:Est_pnl.JPG to accommodate #2 above.

--Alex 12:57, 3 January 2011 (EST)Alex

Retrieved from "https://wiki.jaguarfreight.com/2565_dev"
Personal tools