I had this very same request from my VPO two days ago. I created a
report in CorVu using the Jobhead, Joboper, and Jobmtl tables. It is by
work center, start date, and includes the material for that job. It is
for jobs released, not closed, and operation is not complete. It
includes est. setup hrs, act. set hrs, est. prod hrs, act prod hrs, run
qty, and qty completed. I hope this helps.
Tom Ford
Cost Accountant
Mid-West Spring & Stamping
Phone (574) 353-1673
Fax (574) 353-7359
Visit us at www.mwspring.com
_____
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf
Of Kathy Schaich
Sent: Friday, June 30, 2006 7:49 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] 6.1 Report to show WIP activity on several jobs
The only problem with that report is that it gives you the total run
quantity for the job, the supervisor needs to know what is left in WIP
at each operation as we tend to batch quantities as the parts move
through the jobs.
Kathy Schaich
Vantage Info Coordinator
Ultra Tool & Manufacturing, Inc.
-----Original Message-----
From:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Alexander Gamble
Sent: Friday, June 30, 2006 7:27 AM
To:
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 6.1 Report to show WIP activity on several jobs
Kathy,
If your spot welders, drill presses etc are identified as work centers,
you
might be able to get information needed to schedule them on a short term
detail level from the Priority Dispatch report.
We have queue time ahead of some of our CNC centers so that prior ops
are
scheduled by the system to give three days between when parts are due in
CNC,
and when they are due out, so that we can take the three day WIP buffer
and
schedule it by hand using a magnet board.
That way MRP and prior / subsequent work centers are scheduled at a
macro
level by Vantage, but we have flexibility as to what happens within the
queue
time window to specifically and discretely keep the CNC machines
optimized,
without having to worry about the complexity and rigidity of finite
scheduling within Vantage down to the hour / day.
- Alexander
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Kathy Schaich
Sent: Friday, June 30, 2006 7:21 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] 6.1 Report to show WIP activity on several jobs
Before I re-invent the wheel, I was wondering if anyone had a report
already created either in Crystal or Report Builder which shows the
activity on jobs (similar to how job tracker shows it).
We have different families of parts that get stamped and then have
several different secondary operations that need to be done. I have been
asked to develop a report which shows all the open jobs for these
different families of parts and the quantities completed on each of the
operations for each part number so that we can better schedule our spot
welders, drill presses, machining centers, outside vendors, etc.
Any help you can give me would be greatly appreciated.
Kathy Schaich
Vantage Info Coordinator
Ultra Tool & Manufacturing, Inc.
W169 N5954 Ridgewood Drive
Menomonee Falls, WI 53051
Phone: 262-703-0455
Fax: 262-703-0468
Toll Free: 800-779-3566
kathy.schaich@ <mailto:kathy.schaich%40ultratoolmfg.com>
ultratoolmfg.com <mailto:kathy.schaich%40ultratoolmfg.com>
www.ultratoolmfg.com
The information contained in this electronic message (email) and any
attachment(s) to it is/are intended for the exclusive use of the
intended addressee(s) and may contain information that is confidential
and/or privileged and exempt from disclosure under applicable law. If
you are not the intended recipient(s) and have received this
communication in error, please do not distribute it. Instead, please
notify Ultra Tool & Manufacturing, Inc. at 1-800-779-3566 or by email at
general@ultratoolmf <mailto:general%40ultratoolmfg.com> g.com
<mailto:general%40ultratoolmfg.com> and destroy all
copies of this message and any
attachments. Thank you.
[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]
[Non-text portions of this message have been removed]