Skip to Content
author's profile photo Former Member
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=" &

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.