 Former Member

# Find the cost of production order

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=" &

& "- (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.

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Dec 29, 2013 at 06:41 AM

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.

10|10000 characters needed characters exceeded
• Former Member
Posted on Dec 31, 2013 at 07:38 PM

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