275183 - Revision history

DuttonT at 13:26, 11 May 2011

2011-05-11T13:26:02Z

← Older revision		Revision as of 15:26, 11 May 2011
Line 85:		Line 85:
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| > PROFIT_MARGIN % for GROUP		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| > PROFIT_MARGIN % for GROUP
	\|}		\|}



	'''TABLE UPDATES REQUIRED'''		'''TABLE UPDATES REQUIRED'''

DuttonT at 13:25, 11 May 2011

2011-05-11T13:25:28Z

DuttonT at 13:22, 11 May 2011

2011-05-11T13:22:48Z

← Older revision		Revision as of 15:22, 11 May 2011
Line 95:		Line 95:
	\| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| GREEN		\| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| GREEN
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| > PROFIT_MARGIN % for GROUP		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| > PROFIT_MARGIN % for GROUP
			\|}

	'''table updates REQUIRED'''		'''table updates REQUIRED'''

DuttonT at 13:21, 11 May 2011

2011-05-11T13:21:58Z

Show changes

DuttonT at 13:16, 11 May 2011

2011-05-11T13:16:31Z

Show changes

DuttonT at 13:13, 11 May 2011

2011-05-11T13:13:22Z

← Older revision		Revision as of 15:13, 11 May 2011
Line 1:		Line 1:
	{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title=Profit Colours on Trip Finance Tab\|Reference=FS 275183 PA-83EFTE\|Version=1.0\|Date=\|Sysver=10.5\|Client=DHL MTS}}		{{Doc_Title\|System=FUNCTIONAL SPECIFICATION\|Title=Profit Colours on Trip Finance Tab\|Reference=FS 275183 PA-83EFTE\|Version=1.0\|Date=10/09/2010\|Sysver=10.5\|Client=DHL MTS}}

DuttonT: New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Profit Colours on Trip Finance Tab|Reference=FS 275183 PA-83EFTE|Version=1.0|Date=|Sysver=10.5|Client=DHL MTS}}

2011-05-11T13:12:55Z

New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Profit Colours on Trip Finance Tab|Reference=FS 275183 PA-83EFTE|Version=1.0|Date=|Sysver=10.5|Client=DHL MTS}}

New page

{{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Profit Colours on Trip Finance Tab|Reference=FS 275183 PA-83EFTE|Version=1.0|Date=|Sysver=10.5|Client=DHL MTS}}

← Older revision		Revision as of 15:25, 11 May 2011
Line 26:		Line 26:
	== Solution ==		== Solution ==
	A new field will be added to the table OMS_SCHED_GROUP called PROFIT_MARGIN. The field will be maintainable from the BUSINESS DATA MAINTENANCE screen, allowing users to assign a profit margin % to each GROUP_NAME.		A new field will be added to the table OMS_SCHED_GROUP called PROFIT_MARGIN. The field will be maintainable from the BUSINESS DATA MAINTENANCE screen, allowing users to assign a profit margin % to each GROUP_NAME.


	In the Trip screens, the profit_loss field is currently displayed with a red or green background to indicate profit or loss. This value will be investigated further to identify the profit margin. To calculate PROFIT_MARGIN we will divide PROFIT_LOSS by REVENUE and times by 100 to return a percentage.		In the Trip screens, the profit_loss field is currently displayed with a red or green background to indicate profit or loss. This value will be investigated further to identify the profit margin. To calculate PROFIT_MARGIN we will divide PROFIT_LOSS by REVENUE and times by 100 to return a percentage.


	The owning depot of the trip will be assigned a GROUP_NAME and this will be used to determine the PROFIT_MARGIN for the trip.		The owning depot of the trip will be assigned a GROUP_NAME and this will be used to determine the PROFIT_MARGIN for the trip.


	PROFIT_MARGIN will only be calculated for trips which have made a profit.		PROFIT_MARGIN will only be calculated for trips which have made a profit.


	If the PROFIT_MARGIN for the GROUP is 3% and the value of ( profit_loss/revenue *100) is between 0 and 3, the profit_loss field will be displayed with an amber background.		If the PROFIT_MARGIN for the GROUP is 3% and the value of ( profit_loss/revenue *100) is between 0 and 3, the profit_loss field will be displayed with an amber background.

	If the value of ( PROFIT/REVENUE *100) > 3 then PROFIT_LOSS field will be displayed with a green Background.		If the value of ( PROFIT/REVENUE *100) > 3 then PROFIT_LOSS field will be displayed with a green Background.


	== Scope ==		== Scope ==
Line 61:		Line 56:

	On the finance tab of the trip screens, the cost and revenue of the trip are displayed. A new field has been added recently, which displays the profit/ loss of the trip. This calculated by the difference between the carrier-cost and trip-cost and trip-revenue.		On the finance tab of the trip screens, the cost and revenue of the trip are displayed. A new field has been added recently, which displays the profit/ loss of the trip. This calculated by the difference between the carrier-cost and trip-cost and trip-revenue.


	A profit is indicated with a green background a loss with a red background. This formatting will be changed to indicate how the GROUP is performing. The group is identified as the GROUP which the OWNING_DEPOT is assigned to. Each GROUP will be assigned a PROFT_MARGIN value which indicates the percentage above which a profit is being made.		A profit is indicated with a green background a loss with a red background. This formatting will be changed to indicate how the GROUP is performing. The group is identified as the GROUP which the OWNING_DEPOT is assigned to. Each GROUP will be assigned a PROFT_MARGIN value which indicates the percentage above which a profit is being made.


	To find the % of profit, the profit/loss value is divided by the Trip revenue. In the above screen shot , we will say the GROUP is EXELBAWT which has a PROFT_MARGIN of 5%. To calculate the profit_margin of the trip :		To find the % of profit, the profit/loss value is divided by the Trip revenue. In the above screen shot , we will say the GROUP is EXELBAWT which has a PROFT_MARGIN of 5%. To calculate the profit_margin of the trip :


	872.89 / 948.88 = 91% profit. This trip has clearly exceeded the GROUPS profit margin, so the profit/loss field will remain with a green background.		872.89 / 948.88 = 91% profit. This trip has clearly exceeded the GROUPS profit margin, so the profit/loss field will remain with a green background.


	If the profit/loss value had been between 0 and 47.44 (5%), the field would be displayed with an amber background as the proft/loss is within the Profit margin for the group.		If the profit/loss value had been between 0 and 47.44 (5%), the field would be displayed with an amber background as the proft/loss is within the Profit margin for the group.


	Any loss will be displayed with a red background regardless of the percentage of loss.		Any loss will be displayed with a red background regardless of the percentage of loss.


	The colour will be set in the forms, using the post_query trigger of the SCH_TRIP_FINANCE data block.		The colour will be set in the forms, using the post_query trigger of the SCH_TRIP_FINANCE data block.
Line 97:		Line 86:
	\|}		\|}

	'''~~table updates~~ REQUIRED'''		'''TABLE UPDATES REQUIRED'''

	Alter table OMS_SCHED_GROUP		Alter table OMS_SCHED_GROUP