Job Efficiency % on Production Detail Report

Yahoo Archive
1
Sure. Send it to ross(dot)hughes(at)comcast.net

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marty
Sent: Thursday, April 23, 2009 9:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Efficiency % on Production Detail Report

Ross
Can I e-mail you the Production Detail Report I am looking at if you have
time to review it to see what I might be doing wrong to verify the vantage
Eff #.

If yes what e-mail address should I send it to

Marty


--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> I can believe that.
>
> I am only trying to point to where the calculation is coming from in the
> Production Detail report that he is wrestling with.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> Todd Caughey
> Sent: Thursday, April 23, 2009 8:33 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report
>
> Earned Hours can be off too (in 6.10 anyway). Many times when I manually
> calculate it using the exact formulas given it will not match the value on
> the Labor Detail. Working with Support our best guess was something in
> Labor Edit was depositing incorrect info. But I had many cases where the
> Earned Hours manually calculated should have been 8 hours and the value in
> the system was randomly wrong...like 14.3 hrs, even when the quantity
> produced was almost exactly as estimated. Since it was easy enough to
> calculate it myself (and 6.10 will never be patched again) I just stopped
> using the value in the system. I hope this has been fixed in later
versions
> but since it was never acknowledged as a bug it probably wasn't..
> -Todd C.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> Ross Hughes
> Sent: Thursday, April 23, 2009 8:16 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report
>
>
>
>
> You may want to look in to earned hours. Although the report may not
> display this in the detail the formula at the bottom is calculating from
> this and this is a hidden field in the report.
>
> Here are the earned hour calcs:
> -------------------------------------
> For Production:
>
> If the Run quantity > 0: EarnedHrs = EstProdHours / RunQty x LaborQty
>
> If the Production Standard is fixed hours: EarnedHrs <= EstSetHours -
> ActSetHours + SetReworkHours - Burden Hours for this labor detail record
>
> If the operation quantity = 1: EarnedHrs = Operation Hrs Remaining
> (EstProdHours - ActProdHours) or Hours Worked (BurdenHrs), whichever is
less
>
> For Setup:
>
> Setup Not Complete: EarnedHrs = EstSetHours x SetupPctComplete or
> ActSetupHours, whichever is less
>
> Setup Complete: EarnedHrs = EstSetHours - ActSetHours + SetReworkHours -
> Burden Hours for this labor detail record
> ------------------------------------
> Do this math on the detail and then see if the numbers make more sense.
>
> Or provide more detail and I can try to help with the calculations. Your
> labor detail records should have the earned hours in them as they are
> calculated through the business logic.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf
> Of
> Marty
> Sent: Thursday, April 23, 2009 7:32 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Job Efficiency % on Production Detail Report
>
> Let me line up the hours better..when I used preview it looked ok the
first
> time I posted it
>
> Estimated Hours
>
> Setup __ 1.80
> Prod __ 0.49
>
> Actual Hours
> Setup __ 0.42
> Prod __ 0.93
>
> Eff. Pct: 54.15
>
> I can't figure out where the 54.15 is coming from..
>
> This is at the end of the report just about the Profitability Area of the
> report
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Marty"
> <marty1325@> wrote:
> >
> > I also thought it might NOT be using Setup to calculate the percentage
but
> that didn't work either..
> >
> > Here are the #'s I am seeing on my Report (at end of report where I
assume
> its recaping the detail hours)
> >
> > Est Hours Actual Hours
> > Setup 1.80 .42
> > Prod .49 .93 Eff Pct: 54.15
> >
> > I am Sooo Confused...
> >
> > thanks.
> >
> > Marty
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Robert
> Brown <robertb_versa@> wrote:
> > >
> > >
> > > Look at LaborDetail to see if there is an estimate cost versus actual
> cost bucket (not hours). It could be doing dollar math (and actual dollars
> aren't always one to one with hours if you split burden, etc,).
> > >
> > > Another crazy possibility: Set up is non-value added cost. See if the
> %'s add up with set up left out.
> > >
> > > ???
> > >
> > > Rob
> > >
> > > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> > >
> > > From: Marty <marty1325@>
> > > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Date: Wednesday, April 22, 2009, 4:11 PM
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > I am trying to figure out how vantage Calculates this # at the end of
> the Production Detail Report.
> > >
> > > The Heading is ASM Totals (job # after it)
> > >
> > > I am not talking for each of the operations. But at the end of the
> report where it says Estimated Setup and Production Hours and next to it
> Actual Setup and Production hours are listed
> > >
> > > One would think all you would do is to add the Estimated Setup and
> Production Hours and divide by the Actuals.
> > >
> > > But NO...I can't get it to even come close doing it that way.
> > >
> > > What Vantage logic am I missing here.
> > >
> > > Thanks....
> > >
> >
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I am trying to figure out how vantage Calculates this # at the end of the Production Detail Report.

The Heading is ASM Totals (job # after it)

I am not talking for each of the operations. But at the end of the report where it says Estimated Setup and Production Hours and next to it Actual Setup and Production hours are listed

One would think all you would do is to add the Estimated Setup and Production Hours and divide by the Actuals.

But NO...I can't get it to even come close doing it that way.

What Vantage logic am I missing here.

Thanks....
3
It uses Earned Hours. If I am in the place you are referring to then the
crystal formula is:

if Sum ({JobOper.ActProdHours})= 0 then 0 else
(Sum ({@EarnedHours})) / (Sum ({JobOper.ActProdHours}))* 100

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marty
Sent: Wednesday, April 22, 2009 3:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Efficiency % on Production Detail Report

I am trying to figure out how vantage Calculates this # at the end of the
Production Detail Report.

The Heading is ASM Totals (job # after it)

I am not talking for each of the operations. But at the end of the report
where it says Estimated Setup and Production Hours and next to it Actual
Setup and Production hours are listed

One would think all you would do is to add the Estimated Setup and
Production Hours and divide by the Actuals.

But NO...I can't get it to even come close doing it that way.

What Vantage logic am I missing here.

Thanks....




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Look at LaborDetail to see if there is an estimate cost versus actual cost bucket (not hours). It could be doing dollar math (and actual dollars aren't always one to one with hours if you split burden, etc,).

Another crazy possibility: Set up is non-value added cost. See if the %'s add up with set up left out.

???

Rob

--- On Wed, 4/22/09, Marty <marty1325@...> wrote:

From: Marty <marty1325@...>
Subject: [Vantage] Job Efficiency % on Production Detail Report
To: vantage@yahoogroups.com
Date: Wednesday, April 22, 2009, 4:11 PM








I am trying to figure out how vantage Calculates this # at the end of the Production Detail Report.

The Heading is ASM Totals (job # after it)

I am not talking for each of the operations. But at the end of the report where it says Estimated Setup and Production Hours and next to it Actual Setup and Production hours are listed

One would think all you would do is to add the Estimated Setup and Production Hours and divide by the Actuals.

But NO...I can't get it to even come close doing it that way.

What Vantage logic am I missing here.

Thanks....
5
Thanks Ross. My hunch that set up might be ignored seems to have been correct (bravo to Epicor for a change!)

Ron
--- On Wed, 4/22/09, Ross Hughes <ross.hughes@...> wrote:

From: Ross Hughes <ross.hughes@...>
Subject: RE: [Vantage] Job Efficiency % on Production Detail Report
To: vantage@yahoogroups.com
Date: Wednesday, April 22, 2009, 4:57 PM








It uses Earned Hours. If I am in the place you are referring to then the
crystal formula is:

if Sum ({JobOper.ActProdHo urs})= 0 then 0 else
(Sum ({@EarnedHours} )) / (Sum ({JobOper.ActProdHo urs}))* 100

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Marty
Sent: Wednesday, April 22, 2009 3:11 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Job Efficiency % on Production Detail Report

I am trying to figure out how vantage Calculates this # at the end of the
Production Detail Report.

The Heading is ASM Totals (job # after it)

I am not talking for each of the operations. But at the end of the report
where it says Estimated Setup and Production Hours and next to it Actual
Setup and Production hours are listed

One would think all you would do is to add the Estimated Setup and
Production Hours and divide by the Actuals.

But NO...I can't get it to even come close doing it that way.

What Vantage logic am I missing here.

Thanks....


------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
6
I also thought it might NOT be using Setup to calculate the percentage but that didn't work either..

Here are the #'s I am seeing on my Report (at end of report where I assume its recaping the detail hours)

Est Hours Actual Hours
Setup 1.80 .42
Prod .49 .93 Eff Pct: 54.15

I am Sooo Confused...

thanks.

Marty




--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...> wrote:
>
>
> Look at LaborDetail to see if there is an estimate cost versus actual cost bucket (not hours). It could be doing dollar math (and actual dollars aren't always one to one with hours if you split burden, etc,).
>
> Another crazy possibility: Set up is non-value added cost. See if the %'s add up with set up left out.
>
> ???
>
> Rob
>
> --- On Wed, 4/22/09, Marty <marty1325@...> wrote:
>
> From: Marty <marty1325@...>
> Subject: [Vantage] Job Efficiency % on Production Detail Report
> To: vantage@yahoogroups.com
> Date: Wednesday, April 22, 2009, 4:11 PM
>
>
>
>
>
>
>
>
> I am trying to figure out how vantage Calculates this # at the end of the Production Detail Report.
>
> The Heading is ASM Totals (job # after it)
>
> I am not talking for each of the operations. But at the end of the report where it says Estimated Setup and Production Hours and next to it Actual Setup and Production hours are listed
>
> One would think all you would do is to add the Estimated Setup and Production Hours and divide by the Actuals.
>
> But NO...I can't get it to even come close doing it that way.
>
> What Vantage logic am I missing here.
>
> Thanks....
>
7
Let me line up the hours better..when I used preview it looked ok the first time I posted it

Estimated Hours

Setup __ 1.80
Prod __ 0.49

Actual Hours
Setup __ 0.42
Prod __ 0.93

Eff. Pct: 54.15

I can't figure out where the 54.15 is coming from..

This is at the end of the report just about the Profitability Area of the report



--- In vantage@yahoogroups.com, "Marty" <marty1325@...> wrote:
>
> I also thought it might NOT be using Setup to calculate the percentage but that didn't work either..
>
> Here are the #'s I am seeing on my Report (at end of report where I assume its recaping the detail hours)
>
> Est Hours Actual Hours
> Setup 1.80 .42
> Prod .49 .93 Eff Pct: 54.15
>
> I am Sooo Confused...
>
> thanks.
>
> Marty
>
>
>
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@> wrote:
> >
> >
> > Look at LaborDetail to see if there is an estimate cost versus actual cost bucket (not hours). It could be doing dollar math (and actual dollars aren't always one to one with hours if you split burden, etc,).
> >
> > Another crazy possibility: Set up is non-value added cost. See if the %'s add up with set up left out.
> >
> > ???
> >
> > Rob
> >
> > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> >
> > From: Marty <marty1325@>
> > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > To: vantage@yahoogroups.com
> > Date: Wednesday, April 22, 2009, 4:11 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > I am trying to figure out how vantage Calculates this # at the end of the Production Detail Report.
> >
> > The Heading is ASM Totals (job # after it)
> >
> > I am not talking for each of the operations. But at the end of the report where it says Estimated Setup and Production Hours and next to it Actual Setup and Production hours are listed
> >
> > One would think all you would do is to add the Estimated Setup and Production Hours and divide by the Actuals.
> >
> > But NO...I can't get it to even come close doing it that way.
> >
> > What Vantage logic am I missing here.
> >
> > Thanks....
> >
>
8
I think these might be rounding vs. truncating issues in display and calculation also. I think I played around with this some years ago and satisfied myself that's what was happening but I don't remember exactly. As I recall, estimated and/or actual hours were the total of truncated and/or rounded values but the eff. pct calculation was totaling each instance of these hours out to 15 or so decimal places and calculating from there (or vise versa).

Greg


----- Original Message -----
From: Marty
To: vantage@yahoogroups.com
Sent: Thursday, April 23, 2009 7:31 AM
Subject: [Vantage] Re: Job Efficiency % on Production Detail Report





Let me line up the hours better..when I used preview it looked ok the first time I posted it

Estimated Hours

Setup __ 1.80
Prod __ 0.49

Actual Hours
Setup __ 0.42
Prod __ 0.93

Eff. Pct: 54.15

I can't figure out where the 54.15 is coming from..

This is at the end of the report just about the Profitability Area of the report

--- In vantage@yahoogroups.com, "Marty" <marty1325@...> wrote:
>
> I also thought it might NOT be using Setup to calculate the percentage but that didn't work either..
>
> Here are the #'s I am seeing on my Report (at end of report where I assume its recaping the detail hours)
>
> Est Hours Actual Hours
> Setup 1.80 .42
> Prod .49 .93 Eff Pct: 54.15
>
> I am Sooo Confused...
>
> thanks.
>
> Marty
>
>
>
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@> wrote:
> >
> >
> > Look at LaborDetail to see if there is an estimate cost versus actual cost bucket (not hours). It could be doing dollar math (and actual dollars aren't always one to one with hours if you split burden, etc,).
> >
> > Another crazy possibility: Set up is non-value added cost. See if the %'s add up with set up left out.
> >
> > ???
> >
> > Rob
> >
> > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> >
> > From: Marty <marty1325@>
> > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > To: vantage@yahoogroups.com
> > Date: Wednesday, April 22, 2009, 4:11 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > I am trying to figure out how vantage Calculates this # at the end of the Production Detail Report.
> >
> > The Heading is ASM Totals (job # after it)
> >
> > I am not talking for each of the operations. But at the end of the report where it says Estimated Setup and Production Hours and next to it Actual Setup and Production hours are listed
> >
> > One would think all you would do is to add the Estimated Setup and Production Hours and divide by the Actuals.
> >
> > But NO...I can't get it to even come close doing it that way.
> >
> > What Vantage logic am I missing here.
> >
> > Thanks....
> >
>





[Non-text portions of this message have been removed]
9
You may want to look in to earned hours. Although the report may not
display this in the detail the formula at the bottom is calculating from
this and this is a hidden field in the report.

Here are the earned hour calcs:
-------------------------------------
For Production:

If the Run quantity > 0: EarnedHrs = EstProdHours / RunQty x LaborQty

If the Production Standard is fixed hours: EarnedHrs <= EstSetHours -
ActSetHours + SetReworkHours - Burden Hours for this labor detail record

If the operation quantity = 1: EarnedHrs = Operation Hrs Remaining
(EstProdHours - ActProdHours) or Hours Worked (BurdenHrs), whichever is less

For Setup:

Setup Not Complete: EarnedHrs = EstSetHours x SetupPctComplete or
ActSetupHours, whichever is less

Setup Complete: EarnedHrs = EstSetHours - ActSetHours + SetReworkHours -
Burden Hours for this labor detail record
------------------------------------
Do this math on the detail and then see if the numbers make more sense.

Or provide more detail and I can try to help with the calculations. Your
labor detail records should have the earned hours in them as they are
calculated through the business logic.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marty
Sent: Thursday, April 23, 2009 7:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Efficiency % on Production Detail Report

Let me line up the hours better..when I used preview it looked ok the first
time I posted it

Estimated Hours

Setup __ 1.80
Prod __ 0.49

Actual Hours
Setup __ 0.42
Prod __ 0.93

Eff. Pct: 54.15

I can't figure out where the 54.15 is coming from..

This is at the end of the report just about the Profitability Area of the
report



--- In vantage@yahoogroups.com, "Marty" <marty1325@...> wrote:
>
> I also thought it might NOT be using Setup to calculate the percentage but
that didn't work either..
>
> Here are the #'s I am seeing on my Report (at end of report where I assume
its recaping the detail hours)
>
> Est Hours Actual Hours
> Setup 1.80 .42
> Prod .49 .93 Eff Pct: 54.15
>
> I am Sooo Confused...
>
> thanks.
>
> Marty
>
>
>
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@> wrote:
> >
> >
> > Look at LaborDetail to see if there is an estimate cost versus actual
cost bucket (not hours). It could be doing dollar math (and actual dollars
aren't always one to one with hours if you split burden, etc,).
> >
> > Another crazy possibility: Set up is non-value added cost. See if the
%'s add up with set up left out.
> >
> > ???
> >
> > Rob
> >
> > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> >
> > From: Marty <marty1325@>
> > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > To: vantage@yahoogroups.com
> > Date: Wednesday, April 22, 2009, 4:11 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > I am trying to figure out how vantage Calculates this # at the end of
the Production Detail Report.
> >
> > The Heading is ASM Totals (job # after it)
> >
> > I am not talking for each of the operations. But at the end of the
report where it says Estimated Setup and Production Hours and next to it
Actual Setup and Production hours are listed
> >
> > One would think all you would do is to add the Estimated Setup and
Production Hours and divide by the Actuals.
> >
> > But NO...I can't get it to even come close doing it that way.
> >
> > What Vantage logic am I missing here.
> >
> > Thanks....
> >
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
10
Earned Hours can be off too (in 6.10 anyway). Many times when I manually calculate it using the exact formulas given it will not match the value on the Labor Detail. Working with Support our best guess was something in Labor Edit was depositing incorrect info. But I had many cases where the Earned Hours manually calculated should have been 8 hours and the value in the system was randomly wrong...like 14.3 hrs, even when the quantity produced was almost exactly as estimated. Since it was easy enough to calculate it myself (and 6.10 will never be patched again) I just stopped using the value in the system. I hope this has been fixed in later versions but since it was never acknowledged as a bug it probably wasn't..
-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Hughes
Sent: Thursday, April 23, 2009 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report




You may want to look in to earned hours. Although the report may not
display this in the detail the formula at the bottom is calculating from
this and this is a hidden field in the report.

Here are the earned hour calcs:
-------------------------------------
For Production:

If the Run quantity > 0: EarnedHrs = EstProdHours / RunQty x LaborQty

If the Production Standard is fixed hours: EarnedHrs <= EstSetHours -
ActSetHours + SetReworkHours - Burden Hours for this labor detail record

If the operation quantity = 1: EarnedHrs = Operation Hrs Remaining
(EstProdHours - ActProdHours) or Hours Worked (BurdenHrs), whichever is less

For Setup:

Setup Not Complete: EarnedHrs = EstSetHours x SetupPctComplete or
ActSetupHours, whichever is less

Setup Complete: EarnedHrs = EstSetHours - ActSetHours + SetReworkHours -
Burden Hours for this labor detail record
------------------------------------
Do this math on the detail and then see if the numbers make more sense.

Or provide more detail and I can try to help with the calculations. Your
labor detail records should have the earned hours in them as they are
calculated through the business logic.

Ross

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Marty
Sent: Thursday, April 23, 2009 7:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Job Efficiency % on Production Detail Report

Let me line up the hours better..when I used preview it looked ok the first
time I posted it

Estimated Hours

Setup __ 1.80
Prod __ 0.49

Actual Hours
Setup __ 0.42
Prod __ 0.93

Eff. Pct: 54.15

I can't figure out where the 54.15 is coming from..

This is at the end of the report just about the Profitability Area of the
report

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Marty" <marty1325@...> wrote:
>
> I also thought it might NOT be using Setup to calculate the percentage but
that didn't work either..
>
> Here are the #'s I am seeing on my Report (at end of report where I assume
its recaping the detail hours)
>
> Est Hours Actual Hours
> Setup 1.80 .42
> Prod .49 .93 Eff Pct: 54.15
>
> I am Sooo Confused...
>
> thanks.
>
> Marty
>
>
>
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Robert Brown <robertb_versa@> wrote:
> >
> >
> > Look at LaborDetail to see if there is an estimate cost versus actual
cost bucket (not hours). It could be doing dollar math (and actual dollars
aren't always one to one with hours if you split burden, etc,).
> >
> > Another crazy possibility: Set up is non-value added cost. See if the
%'s add up with set up left out.
> >
> > ???
> >
> > Rob
> >
> > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> >
> > From: Marty <marty1325@>
> > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Date: Wednesday, April 22, 2009, 4:11 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > I am trying to figure out how vantage Calculates this # at the end of
the Production Detail Report.
> >
> > The Heading is ASM Totals (job # after it)
> >
> > I am not talking for each of the operations. But at the end of the
report where it says Estimated Setup and Production Hours and next to it
Actual Setup and Production hours are listed
> >
> > One would think all you would do is to add the Estimated Setup and
Production Hours and divide by the Actuals.
> >
> > But NO...I can't get it to even come close doing it that way.
> >
> > What Vantage logic am I missing here.
> >
> > Thanks....
> >
>

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
11
I can believe that.

I am only trying to point to where the calculation is coming from in the
Production Detail report that he is wrestling with.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Thursday, April 23, 2009 8:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report

Earned Hours can be off too (in 6.10 anyway). Many times when I manually
calculate it using the exact formulas given it will not match the value on
the Labor Detail. Working with Support our best guess was something in
Labor Edit was depositing incorrect info. But I had many cases where the
Earned Hours manually calculated should have been 8 hours and the value in
the system was randomly wrong...like 14.3 hrs, even when the quantity
produced was almost exactly as estimated. Since it was easy enough to
calculate it myself (and 6.10 will never be patched again) I just stopped
using the value in the system. I hope this has been fixed in later versions
but since it was never acknowledged as a bug it probably wasn't..
-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Thursday, April 23, 2009 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report




You may want to look in to earned hours. Although the report may not
display this in the detail the formula at the bottom is calculating from
this and this is a hidden field in the report.

Here are the earned hour calcs:
-------------------------------------
For Production:

If the Run quantity > 0: EarnedHrs = EstProdHours / RunQty x LaborQty

If the Production Standard is fixed hours: EarnedHrs <= EstSetHours -
ActSetHours + SetReworkHours - Burden Hours for this labor detail record

If the operation quantity = 1: EarnedHrs = Operation Hrs Remaining
(EstProdHours - ActProdHours) or Hours Worked (BurdenHrs), whichever is less

For Setup:

Setup Not Complete: EarnedHrs = EstSetHours x SetupPctComplete or
ActSetupHours, whichever is less

Setup Complete: EarnedHrs = EstSetHours - ActSetHours + SetReworkHours -
Burden Hours for this labor detail record
------------------------------------
Do this math on the detail and then see if the numbers make more sense.

Or provide more detail and I can try to help with the calculations. Your
labor detail records should have the earned hours in them as they are
calculated through the business logic.

Ross

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of
Marty
Sent: Thursday, April 23, 2009 7:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Job Efficiency % on Production Detail Report

Let me line up the hours better..when I used preview it looked ok the first
time I posted it

Estimated Hours

Setup __ 1.80
Prod __ 0.49

Actual Hours
Setup __ 0.42
Prod __ 0.93

Eff. Pct: 54.15

I can't figure out where the 54.15 is coming from..

This is at the end of the report just about the Profitability Area of the
report

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Marty"
<marty1325@...> wrote:
>
> I also thought it might NOT be using Setup to calculate the percentage but
that didn't work either..
>
> Here are the #'s I am seeing on my Report (at end of report where I assume
its recaping the detail hours)
>
> Est Hours Actual Hours
> Setup 1.80 .42
> Prod .49 .93 Eff Pct: 54.15
>
> I am Sooo Confused...
>
> thanks.
>
> Marty
>
>
>
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Robert
Brown <robertb_versa@> wrote:
> >
> >
> > Look at LaborDetail to see if there is an estimate cost versus actual
cost bucket (not hours). It could be doing dollar math (and actual dollars
aren't always one to one with hours if you split burden, etc,).
> >
> > Another crazy possibility: Set up is non-value added cost. See if the
%'s add up with set up left out.
> >
> > ???
> >
> > Rob
> >
> > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> >
> > From: Marty <marty1325@>
> > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Date: Wednesday, April 22, 2009, 4:11 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > I am trying to figure out how vantage Calculates this # at the end of
the Production Detail Report.
> >
> > The Heading is ASM Totals (job # after it)
> >
> > I am not talking for each of the operations. But at the end of the
report where it says Estimated Setup and Production Hours and next to it
Actual Setup and Production hours are listed
> >
> > One would think all you would do is to add the Estimated Setup and
Production Hours and divide by the Actuals.
> >
> > But NO...I can't get it to even come close doing it that way.
> >
> > What Vantage logic am I missing here.
> >
> > Thanks....
> >
>

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
12
Ross
Can I e-mail you the Production Detail Report I am looking at if you have time to review it to see what I might be doing wrong to verify the vantage Eff #.

If yes what e-mail address should I send it to

Marty


--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> I can believe that.
>
> I am only trying to point to where the calculation is coming from in the
> Production Detail report that he is wrestling with.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Todd Caughey
> Sent: Thursday, April 23, 2009 8:33 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report
>
> Earned Hours can be off too (in 6.10 anyway). Many times when I manually
> calculate it using the exact formulas given it will not match the value on
> the Labor Detail. Working with Support our best guess was something in
> Labor Edit was depositing incorrect info. But I had many cases where the
> Earned Hours manually calculated should have been 8 hours and the value in
> the system was randomly wrong...like 14.3 hrs, even when the quantity
> produced was almost exactly as estimated. Since it was easy enough to
> calculate it myself (and 6.10 will never be patched again) I just stopped
> using the value in the system. I hope this has been fixed in later versions
> but since it was never acknowledged as a bug it probably wasn't..
> -Todd C.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Ross Hughes
> Sent: Thursday, April 23, 2009 8:16 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Job Efficiency % on Production Detail Report
>
>
>
>
> You may want to look in to earned hours. Although the report may not
> display this in the detail the formula at the bottom is calculating from
> this and this is a hidden field in the report.
>
> Here are the earned hour calcs:
> -------------------------------------
> For Production:
>
> If the Run quantity > 0: EarnedHrs = EstProdHours / RunQty x LaborQty
>
> If the Production Standard is fixed hours: EarnedHrs <= EstSetHours -
> ActSetHours + SetReworkHours - Burden Hours for this labor detail record
>
> If the operation quantity = 1: EarnedHrs = Operation Hrs Remaining
> (EstProdHours - ActProdHours) or Hours Worked (BurdenHrs), whichever is less
>
> For Setup:
>
> Setup Not Complete: EarnedHrs = EstSetHours x SetupPctComplete or
> ActSetupHours, whichever is less
>
> Setup Complete: EarnedHrs = EstSetHours - ActSetHours + SetReworkHours -
> Burden Hours for this labor detail record
> ------------------------------------
> Do this math on the detail and then see if the numbers make more sense.
>
> Or provide more detail and I can try to help with the calculations. Your
> labor detail records should have the earned hours in them as they are
> calculated through the business logic.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of
> Marty
> Sent: Thursday, April 23, 2009 7:32 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Job Efficiency % on Production Detail Report
>
> Let me line up the hours better..when I used preview it looked ok the first
> time I posted it
>
> Estimated Hours
>
> Setup __ 1.80
> Prod __ 0.49
>
> Actual Hours
> Setup __ 0.42
> Prod __ 0.93
>
> Eff. Pct: 54.15
>
> I can't figure out where the 54.15 is coming from..
>
> This is at the end of the report just about the Profitability Area of the
> report
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Marty"
> <marty1325@> wrote:
> >
> > I also thought it might NOT be using Setup to calculate the percentage but
> that didn't work either..
> >
> > Here are the #'s I am seeing on my Report (at end of report where I assume
> its recaping the detail hours)
> >
> > Est Hours Actual Hours
> > Setup 1.80 .42
> > Prod .49 .93 Eff Pct: 54.15
> >
> > I am Sooo Confused...
> >
> > thanks.
> >
> > Marty
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Robert
> Brown <robertb_versa@> wrote:
> > >
> > >
> > > Look at LaborDetail to see if there is an estimate cost versus actual
> cost bucket (not hours). It could be doing dollar math (and actual dollars
> aren't always one to one with hours if you split burden, etc,).
> > >
> > > Another crazy possibility: Set up is non-value added cost. See if the
> %'s add up with set up left out.
> > >
> > > ???
> > >
> > > Rob
> > >
> > > --- On Wed, 4/22/09, Marty <marty1325@> wrote:
> > >
> > > From: Marty <marty1325@>
> > > Subject: [Vantage] Job Efficiency % on Production Detail Report
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Date: Wednesday, April 22, 2009, 4:11 PM
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > I am trying to figure out how vantage Calculates this # at the end of
> the Production Detail Report.
> > >
> > > The Heading is ASM Totals (job # after it)
> > >
> > > I am not talking for each of the operations. But at the end of the
> report where it says Estimated Setup and Production Hours and next to it
> Actual Setup and Production hours are listed
> > >
> > > One would think all you would do is to add the Estimated Setup and
> Production Hours and divide by the Actuals.
> > >
> > > But NO...I can't get it to even come close doing it that way.
> > >
> > > What Vantage logic am I missing here.
> > >
> > > Thanks....
> > >
> >
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>