Accounting Gurus - MFG-VAR cont

Well, duh! Of course, that makes sense, and that is what was happening,
plus not having it related to the operation.



We have some complicated BOMs which makes it hard to make sure every
single material is accounted for when making these changes. Research
can be a horrible nightmare, but we are cleaning this up slowly.



Writing that report should not be too hard.



Thanks, I think have been experiencing some major brain farts!







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of saab_barracuda
Sent: Tuesday, September 11, 2007 8:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accounting Gurus - MFG-VAR cont



Standard cost is whatever you have setup in the system, either
manually through Cost Adjustment or through a cost roll in Costing
Workbench (for parts with BOM). This is the "best guess" at what the
cost should be.

The PDR shows variance from the BOM estimates FROM THE JOB ENGINEERING
(not the Method). So if you change the method but not the job
engineering, you won't see the changes in the job estimates. These
material variances could come from issue variance (difference in
issued qty vs. required qty) or from costing variance (difference in
transaction cost at the time the part was issued vs. the current
standard cost). Unless you've updated your standard costs in the
middle of the job, you should only be seeing issue varinace on the
PDR. The material summary for jobs can be found in the JobMtl table
or the PartTran if you want to break down to individual transactions.

Note this is completely separate from the purchase price variance.
The PPV is the difference between your invoice cost vs. standard cost.
I don't know any stock report that gives PPV so you have to build it
yourself.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Which standard would that be? I have been making changes since we went
> live!
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> P: 630-806-2000
>
> F: 630-806-2001
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of shockeydc
> Sent: Monday, September 10, 2007 2:13 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Accounting Gurus - MFG-VAR cont
>
>
>
> Has there been a change to the BOM since the standard was
> established. The variance is calculated from Standard but I think
> the Production Detail Report use the current BOM and router for the
> estimate.
>
> David Shockey
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Ok so relating the material to the operation helped a lot! So what
> is
> > left over are top level parts with variances.
> >
> > My labor and burden are always the same, good there. My materials
> are
> > the ones that are off. I understand why, but what is puzzeling is
> that
> > my INV/WIP report shows a credit of $739.78, but the production
> detail
> > report shows a difference of $499.13. Where would I track down the
> > difference between the two?
> >
> > TIA
> >
> > M. Manasa Reddy
> > ERP / Inventory & Procurement Manager
> > Welding Company of America
> > manasa@
> > P: 630-806-2000
> > F: 630-806-2001
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Ok so relating the material to the operation helped a lot! So what is
left over are top level parts with variances.

My labor and burden are always the same, good there. My materials are
the ones that are off. I understand why, but what is puzzeling is that
my INV/WIP report shows a credit of $739.78, but the production detail
report shows a difference of $499.13. Where would I track down the
difference between the two?

TIA

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@...
P: 630-806-2000
F: 630-806-2001



[Non-text portions of this message have been removed]
Do an INV/WIP report of just that work order and you can see exactly
what it took and when - Shouldn't ever have taken more than what was on
the job to begin with...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 12:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Accounting Gurus - MFG-VAR cont



Ok so relating the material to the operation helped a lot! So what is
left over are top level parts with variances.

My labor and burden are always the same, good there. My materials are
the ones that are off. I understand why, but what is puzzeling is that
my INV/WIP report shows a credit of $739.78, but the production detail
report shows a difference of $499.13. Where would I track down the
difference between the two?

TIA

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
It was actually less, but I ran the report and I have $739.78 credit to
my Work In Process, and then $739.78 debit to my Purchase Price
Variance.



So I looked at my production detail report for this job, and my material
difference is only $499.13.



So my question is where else should I be looking to track this down? I
did notice that a couple of parts were marked for Purchase Direct on the
job so therefore those did not get backflushed. Bet that is where it
comes from.







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Geary, Stephanie
Sent: Monday, September 10, 2007 11:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont



Do an INV/WIP report of just that work order and you can see exactly
what it took and when - Shouldn't ever have taken more than what was on
the job to begin with...

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 12:41 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Accounting Gurus - MFG-VAR cont

Ok so relating the material to the operation helped a lot! So what is
left over are top level parts with variances.

My labor and burden are always the same, good there. My materials are
the ones that are off. I understand why, but what is puzzeling is that
my INV/WIP report shows a credit of $739.78, but the production detail
report shows a difference of $499.13. Where would I track down the
difference between the two?

TIA

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]

This message has been processed via your triumphgroup.com e-mail
address.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Well if it went to purchase price variance it shouldn't have gone to the
job as well. Any way you could fax me the INV/WIP and I could look at
it and see if I could tell. 317/392-5006 - But I will be gone after
today and won't be back until Friday but I am more than willing to look
and see if I can tell what is going on.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 2:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont



It was actually less, but I ran the report and I have $739.78 credit to
my Work In Process, and then $739.78 debit to my Purchase Price
Variance.

So I looked at my production detail report for this job, and my material
difference is only $499.13.

So my question is where else should I be looking to track this down? I
did notice that a couple of parts were marked for Purchase Direct on the
job so therefore those did not get backflushed. Bet that is where it
comes from.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Geary, Stephanie
Sent: Monday, September 10, 2007 11:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont

Do an INV/WIP report of just that work order and you can see exactly
what it took and when - Shouldn't ever have taken more than what was on
the job to begin with...

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 12:41 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Accounting Gurus - MFG-VAR cont

Ok so relating the material to the operation helped a lot! So what is
left over are top level parts with variances.

My labor and burden are always the same, good there. My materials are
the ones that are off. I understand why, but what is puzzeling is that
my INV/WIP report shows a credit of $739.78, but the production detail
report shows a difference of $499.13. Where would I track down the
difference between the two?

TIA

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]

This message has been processed via your triumphgroup.com e-mail
address.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
Has there been a change to the BOM since the standard was
established. The variance is calculated from Standard but I think
the Production Detail Report use the current BOM and router for the
estimate.

David Shockey


--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Ok so relating the material to the operation helped a lot! So what
is
> left over are top level parts with variances.
>
> My labor and burden are always the same, good there. My materials
are
> the ones that are off. I understand why, but what is puzzeling is
that
> my INV/WIP report shows a credit of $739.78, but the production
detail
> report shows a difference of $499.13. Where would I track down the
> difference between the two?
>
> TIA
>
> M. Manasa Reddy
> ERP / Inventory & Procurement Manager
> Welding Company of America
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks, but I will fax to you next week...I will have more time then to
devote to this project!







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Geary, Stephanie
Sent: Monday, September 10, 2007 2:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont



Well if it went to purchase price variance it shouldn't have gone to the
job as well. Any way you could fax me the INV/WIP and I could look at
it and see if I could tell. 317/392-5006 - But I will be gone after
today and won't be back until Friday but I am more than willing to look
and see if I can tell what is going on.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 2:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont

It was actually less, but I ran the report and I have $739.78 credit to
my Work In Process, and then $739.78 debit to my Purchase Price
Variance.

So I looked at my production detail report for this job, and my material
difference is only $499.13.

So my question is where else should I be looking to track this down? I
did notice that a couple of parts were marked for Purchase Direct on the
job so therefore those did not get backflushed. Bet that is where it
comes from.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Geary, Stephanie
Sent: Monday, September 10, 2007 11:56 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Accounting Gurus - MFG-VAR cont

Do an INV/WIP report of just that work order and you can see exactly
what it took and when - Shouldn't ever have taken more than what was on
the job to begin with...

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Monday, September 10, 2007 12:41 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Accounting Gurus - MFG-VAR cont

Ok so relating the material to the operation helped a lot! So what is
left over are top level parts with variances.

My labor and burden are always the same, good there. My materials are
the ones that are off. I understand why, but what is puzzeling is that
my INV/WIP report shows a credit of $739.78, but the production detail
report shows a difference of $499.13. Where would I track down the
difference between the two?

TIA

M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

[Non-text portions of this message have been removed]

This message has been processed via your triumphgroup.com e-mail
address.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

This message has been processed via your triumphgroup.com e-mail
address.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Which standard would that be? I have been making changes since we went
live!







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of shockeydc
Sent: Monday, September 10, 2007 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accounting Gurus - MFG-VAR cont



Has there been a change to the BOM since the standard was
established. The variance is calculated from Standard but I think
the Production Detail Report use the current BOM and router for the
estimate.

David Shockey

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Ok so relating the material to the operation helped a lot! So what
is
> left over are top level parts with variances.
>
> My labor and burden are always the same, good there. My materials
are
> the ones that are off. I understand why, but what is puzzeling is
that
> my INV/WIP report shows a credit of $739.78, but the production
detail
> report shows a difference of $499.13. Where would I track down the
> difference between the two?
>
> TIA
>
> M. Manasa Reddy
> ERP / Inventory & Procurement Manager
> Welding Company of America
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Standard cost is whatever you have setup in the system, either
manually through Cost Adjustment or through a cost roll in Costing
Workbench (for parts with BOM). This is the "best guess" at what the
cost should be.

The PDR shows variance from the BOM estimates FROM THE JOB ENGINEERING
(not the Method). So if you change the method but not the job
engineering, you won't see the changes in the job estimates. These
material variances could come from issue variance (difference in
issued qty vs. required qty) or from costing variance (difference in
transaction cost at the time the part was issued vs. the current
standard cost). Unless you've updated your standard costs in the
middle of the job, you should only be seeing issue varinace on the
PDR. The material summary for jobs can be found in the JobMtl table
or the PartTran if you want to break down to individual transactions.

Note this is completely separate from the purchase price variance.
The PPV is the difference between your invoice cost vs. standard cost.
I don't know any stock report that gives PPV so you have to build it
yourself.


--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Which standard would that be? I have been making changes since we went
> live!
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> manasa@...
>
> P: 630-806-2000
>
> F: 630-806-2001
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of shockeydc
> Sent: Monday, September 10, 2007 2:13 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Accounting Gurus - MFG-VAR cont
>
>
>
> Has there been a change to the BOM since the standard was
> established. The variance is calculated from Standard but I think
> the Production Detail Report use the current BOM and router for the
> estimate.
>
> David Shockey
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Ok so relating the material to the operation helped a lot! So what
> is
> > left over are top level parts with variances.
> >
> > My labor and burden are always the same, good there. My materials
> are
> > the ones that are off. I understand why, but what is puzzeling is
> that
> > my INV/WIP report shows a credit of $739.78, but the production
> detail
> > report shows a difference of $499.13. Where would I track down the
> > difference between the two?
> >
> > TIA
> >
> > M. Manasa Reddy
> > ERP / Inventory & Procurement Manager
> > Welding Company of America
> > manasa@
> > P: 630-806-2000
> > F: 630-806-2001
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>