Hi,
The last two, (Earned standard hours & actual production hours)can
be easily done. There are two issues however, your reporting tool
and the details. I use corvu to do this sort of thing but it can be
done within crystal and report builder. I user corvu, because I find
it easier and quicker to user and you can publish graphs etc to your
intranet. I have done this work before, where the graphs were
publish on the intranet to the shop floor so they could see how many
standard hours they were producing on a 10 weeks rollng . This was
split by department / workcentre.
The first item , it quite hard to do. Using corvu , i was working on
such graphs but could never quite get there. If you want to get to
value only then this is possible. Through take a snapshot of the
sales order, jobs etc. This data is then your planned period. At the
end of the period take another snapshot and compare the two.
As an aside , there is a product that would do it for you, probably.
That is cormanufacturing and it isn't cheap but in BPM it is one of
the best out there.
Hope this helps.
The last two, (Earned standard hours & actual production hours)can
be easily done. There are two issues however, your reporting tool
and the details. I use corvu to do this sort of thing but it can be
done within crystal and report builder. I user corvu, because I find
it easier and quicker to user and you can publish graphs etc to your
intranet. I have done this work before, where the graphs were
publish on the intranet to the shop floor so they could see how many
standard hours they were producing on a 10 weeks rollng . This was
split by department / workcentre.
The first item , it quite hard to do. Using corvu , i was working on
such graphs but could never quite get there. If you want to get to
value only then this is possible. Through take a snapshot of the
sales order, jobs etc. This data is then your planned period. At the
end of the period take another snapshot and compare the two.
As an aside , there is a product that would do it for you, probably.
That is cormanufacturing and it isn't cheap but in BPM it is one of
the best out there.
Hope this helps.
--- In vantage@yahoogroups.com, "johnhuang" <jhuang@...> wrote:
>
> I am basically trying to report frequently on:
>
> - Planned/booked standard hours
>
> - Earned standard hours (cumulative standard hours for equipment
> produced in the period
>
> - Performance of actual production hours against earned standard
hours
> (efficiency)
>
> I think that the graphic is showing planned standard value which
> should be some fixed dollar amount for each unit of standard hour
> (sometimes different for each product group).
>
> It is still closer to what I am looking for -- which seems to be a
> pretty typical way to manage production measures -- than anything I
> can find in Vantage.
>
>
> --- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@>
wrote:
> >
> > Hi,
> >
> > This is a very interesting topic, but I think I need some more
> > information. The below link seems to refer to sales value rather
than
> > production hours, this is simpler to achieve.
> >
> > Are you looking to compare load against standard hours booked or
> > capacity against standard hours booked or something else?
> >
> > I have in the past tried to create production hours related
reports.
> > This has proved troublesome, to me at least. In 6.1 , when you
delve
> > deeper, the data structure is difficult to report on. I can
> > understand why the data structure is why it is from a system
point of
> > view but for 'users' to extract the data it is difficult.
Personally,
> > I think that this type of reporting/function is weak in 6.1. I
don't
> > know whether it has been improved in v8 or APS helps in this
matter.
> >
> > If I can be of help , let me know.
> >
>