Back to Menu No.05-03-03

Sales Actual (KE30)

Menu: Accounting > Controlling > Profitability Analysis > Information System > Execute Report

Process Overview: Display plan/actual/variance of profitability analysis.

Screen 1:

Operation Process:

Double-click on Report. (Ex. 'YRCOPA0002' Plan/Actual/Variance)

Screen 2:

Operation Process:

Report selections
1.	{{Company Code /$1}}	Enter the starting Company code.
2.	{{Company Code /$2}}	Enter the ending Company code.
3.	{{Fiscal Year /$1}}	Enter the Fiscal year.
4.	{{Fiscal Year /$2}}	Enter the Fiscal year.
5.	{{Period /$1}}	Enter the starting Fiscal period.
6.	{{Period /$2}}	Enter the ending Fiscal period.
7.	{{Sales Org. /$1}}	Enter the starting Sales organization.
8.	{{Sales Org. /$2}}	Enter the ending Sales organization.
9.	{{Plant /$1}}	Enter the starting Plant.
10.	{{Plant /$2}}	Enter the ending Plant.
11.	{{Output type}}	When 'Classic drilldown report' is selected, the report is displayed in the conventional report format. When 'Graphical report-output' is selected, the report is displayed in the format that is shown from Screen 3.
12.		Click [Execute].

Screen 3:

Operation Process:

	1.	{Navigation}	Double-click on the field to be selected further in 'Navigation' on the left side.
			Check that the selected fields are displayed in the window on the right side.

By double-clicking on the field that is displayed in the window on the right side, further drilling-down is possible.

	3.	When there are multiple fields, control can be moved among the fields with .
		To reset, double-click on the field that is currently selected in 'Navigation' on the left side.

Operation Process:

	1.	Planned cost that is based on cost in sales order and estimated cost will be displayed.
	2.	Actual cost that is based on cost in billing order and estimated cost will be displayed. After periodic assessment, this amount will be changed by the value that is based on cost in billing document and actual.

Plan
	Quantity:	The order quantity in sales order item will be displayed.
	Sales:	The net value in sales order item will be displayed.
	Cost:	The estimated cost in sales order item will be displayed. When it does not exists, the estimated cost of material will be displayed.
	Material cost:	The cost of item in sales order or cost that calculated with summation cost of raw material and indirect material cost cost (It is both estimated cost of material).
	Labor cost:	The cost of item in sales order or cost that calculated with summation labor cost and labor associate cost (It is both estimated cost of material).
	Expense:	The cost of item in sales order or cost that calculated with summation fuel and light cost and depreciation cost and repairs expense and etc (These are both estimated cost of material).
	Subcontract cost:	The cost of item in sales order or cost that calculated with subcontracting cost (It is estimated cost of material).
	Gross margin:	The amount calculated by subtracting cost from sales will be displayed.
Actual
	Quantity:	The billed quantity in billing document item will be displayed.
	Sales:	The net value in billing document item will be displayed.
	Cost:	The cost in billing document item will be displayed. After periodic assessment, the amount that multiply actual periodic unit price and number.
	Material cost:	The cost of item in sales order or cost that calculated with summation cost of raw material and indirect material cost (It is both estimated cost of material). After periodic assessment, the amount that add cost of raw material and indirect material cost.
	Labor cost:	The cost of item in sales order or cost that calculated with summation labor cost and labor associate cost (It is both estimated cost of material). After periodic assessment, the amount that add labor cost and labor associate cost.
	Expense:	The cost of item in sales order or cost that calculated with summation fuel and light cost and depreciation cost and repairs expense and etc (These are estimated cost of material). After periodic assessment, the amount that add fuel and light cost and depreciation cost and repairs expense and etc.
	Subcontract cost:	The cost of item in sales order or cost that calculated with subcontracting cost (It is estimated cost of material). After periodic assessment, the amount of subcontracting cost.
	Gross margin:	The amount calculated by subtracting cost from sales will be displayed.