Wednesday, July 30, 2014

Compare with cost run CK40N ( Standard price or Product cost ) and Plan price/ Ensuring accurate Standard pricing compare with Plan price





Menu Path
Accounting ® Controlling® Product Cost Controlling® Product Cost Planning ® Information system ®Summarized Analysis ®Analyze Costing Run ® S_ALR_87099930
Transaction Code
S_ALR_87099930

Before cost release or after cost run  we may verify with Materials predefined plan cost for get accurate price through Transaction code S_ALR_87099930




































Update the following required and optional fields:


Field Name
Description
Values
Plant
Plant Code
2500
Costing Date
Select Costing Date, Valid from

No material Component.
Select “No material component” option

Comparison Value
Select “Comparison Value”  code
1
Threshold Red (Amount)
Threshold Red Value (%)
30
Threshold Yellow (Amount)
Threshold Yellow Value (%)
20
Display Positive and Negative variance
Click “Display Positive and Negative variance “ option

Material Master Price
Future Plan price
10
Layout
Select Layout
1SAP02
Cost Component View
Select “Cost of Goods Manufactured” option
1
Price unit in Material Master
Select “Price unit in Material Master “ option



Click the Execute  button.


The bellow mention Report will be appearing.


































Transaction Code: MM03



Standard Price
Planned price 1
Planed Date
235.52
400
01.11.2011



Transaction Code: CK13N







After Cost run we may confirm that our estimate cost run/ Standard price is right or wrong compare with Plan price which is our targeted cost has been mentioned in material master. 































Variance:


Material Planned price
Cost Run Price/ Std. Price
Variance
Percentage
400
235.52
164.48
41.12 %

Saturday, July 26, 2014

Foreign Exchange loss gain impact for MIGO (GR) and MIRO (IR) dollar (Foreign curr.) rate variance.


Rate = 1 Dollar
Quantity = 1000.

MIGO - Dollar Rate – 81.85 BDT.

MIGO





Stock value


















MIRO - Dollar Rate - 82.00 BDT.
MIGO – Dollar Rate – 81.85 BDT.
Diff – 0.15 BDT.
Inventory update =1000 x 0.15 BDT=150 BDT.


MIRO





























Inventory has been updated successfully.







For Partial issue (Raw material)

MIGO – Dollar Rate – 81.85 BDT



MIGO





Stock Value







Raw material issue - 250 PCs

FI entry 






After issue, Stock value





MIRO – Dollar Rate – 82.00 BDT
MIGO – Dollar Rate – 81.85 BDT
Diff – 0.15



MIRO











Stock value has been updated successfully. 






















Inventory update (Residual quantity) =750 x 0.15 BDT              =   112.50 BDT.
GL 800200- F.E Gain (loss) – Realized                                     =     37.5   BDT.
                                                                                     Total : =   150      BDT.