Hi Experts,
My Client has a different requirement for variance calculation.
Client want the Production order variance to be calculated based on their budgeted cost and not with reference to Target cost which is again based on Standard cost. Client requires to valuate the cost of Fert and Halb items based on their budgeted cost for the variance calculation ONLY.They want a seperate report for Management information and mainly concerned with Material related variance.
Now to start with, I entered prices of Raw material (as said to be the budgeted price) in planned price 1 in Costing Tab 2 of material master for all items defined in BOM. Made a seperate Costing variant and valuation variant to consider the Planned price 1 for valuation.
With CK40N, calculated the cost of Fert and HALB items in Planned price1. Now I want to use this new cost i.e. Planned price 1 to calculate Target cost in production order calculation of variances i.e. price, Quantity, Mix,Usage etc.
My queries are as follows...
1) Am I moving in a right direction and whether the approach is correct? If No, then request you to guide me any other method to calculate the cost as per client's requirement.
2) If the answer to obove is yes, then requesting you to guide what should be the next step?
3) I want to know the table names where the values of this new cost is stored so that I can capture the values as per cost component structure and can be used for variance calculation. I have already checked the Tables KEEO and KEPH but the figures are not matching.
4) Also let me know the Table names for actual cost of production order.
Regards,
makrand