Find the cost of production order

[Former Member]

Note - The qns below may not be in readable format. So I am attaching a text file.

I am creating a crystal report for finding the cost of production order.In this report,I have considered that the total sum of receipt from production gives the net cost of raw material of the production order.i.e.

strQuery = "SELECT SUM(LineTotal) As 'Actual_Cost' FROM IGN1 WHERE BaseType=202 AND BaseEntry=" &

objDTHeader.Rows(intI).Item("DocEntry") & " AND TranType ='C'"
dblActualRMCost = GetDataByScaler(strQuery)

Here DocEntry is the docentry of production order.

Then I have considered issue for production.I have created a query which gives the net cost of issued material i.e.

strQuery = "SELECT (SELECT SUM(LineTotal) As 'Issue'  FROM IGE1 WHERE BaseType=202 AND BaseEntry=" &

objDTHeader.Rows(intI).Item("DocEntry") & ")" _
& "- (SELECT SUM(LineTotal) As 'Return' FROM IGN1 WHERE BaseType=202 AND BaseEntry=" &

objDTHeader.Rows(intI).Item("DocEntry") & " AND TranType IS NULL)"
dblComponentCost = GetDataByScaler(strQuery)

Then I have evaluated the variance as ,
dblVariance = dblActualRMCost - dblComponentCost

So the net cost of production order is as,
dblCost= dblActualRMCost - dblVariance

If the variance is positive then I deduct it else I add it.

The variable dblCost gives the net cost of production order.Is the correct formula for evaluating the cost of production

order.

I have created heirarchical structure of production orders as follows -
A
A->B
B->C
B->D
D->E

A is parent PO.B is included in A.B is having two children C and D.And D is having one child E.For evaluating the cost of PO,

I have used the formula as described at the begining. Now assume that the cost of all these PO's is as follws -
A = 1000
B=80
C=35
D=20
E=5

In the report I want to display the cost of all the PO's.I am displaying it as ,
E=5
D= 20-5=15
C=35
B = 80 - 35 -(20-5) -5 =15
A = 1000 - (80 - 35 -(20-5) -5) - 35 -(20-5) - 5 =930

This formula does not work for all the PO's. How do I evaluate the cost of PO.

New Text Document.txt.zip

[Former Member]

Hi,

I am afraid your formula has problem. If the cost of D is 20, you do not need to include E in calculating B.

To me, it should be:

D without E = 15

B Without C&D = 25

A without B = 920

It that the result you need? If not, please show you complete production order.

Thanks,

Gordon

[Former Member]

I have devloped a formula for calculating the cost. It works for one production order.If I apply the same formula to another production order it is giving wrong results. For some production order, I subtract the cost of child production order upto n level. But for some PO's I need to subtract upto n-1 levels. Also, variance is creating problem. For some PO's , variance is so large that it gives wrong results.

Should I subtract the cost of child PO's to n level ? Or should I evaluate upto n-1 level ?  

[Former Member]

If your formula can't produce the same result, it has to be changed. The result has to be consisted from your formula.

[Former Member]

I have created heirarchical structure of production orders as follows -
A
A->B
B->C
B->D
D->E

A is parent PO.B is included in A.B is having two children C and D.And D is having one child E.For evaluating the cost of PO, I have used the formula as described at the begining. Now assume that the cost of all these PO's is as follws -
A = 1000
B=80
C=35
D=20
E=5

In the report I want to display the cost of all the PO's.I am displaying it as ,
E=5
D= 20-5=15
C=35
B = 80 - 35 -(20-5) -5 =15
A = 1000 - (80 - 35 -(20-5) -5) - 35 -(20-5) - 5 =930

This formula does not work for all the PO's. How do I evaluate the cost of PO.

[Former Member]

Can anybody resolve my problem ?