Shop Load Report Help or Enhancement

Yahoo Archive
1
For the Shop Load Report to reflect what you have in inventory, you
must have production jobs setup (engineered and scheduled) with
quanity links to your order releases and/or stock requirements
with "Pull from Stock" quanities entered for each link and for sub-
assemblies. The from stock quanities will be allocated against stock
(if item is a "stocked" item)and the production quanity will equal
your requirements quanity minus any pull from stock quanity. Then
your Load Report will be based on the actual production quanity.

Hope this helps.

Dan Gillespie

--- In vantage@yahoogroups.com, "lheisey3 <lheisey@m...>"
<lheisey@m...> wrote:
> I will try to make this question as concise as possible. We are
> looking to use the Shop Load report. However, it does not take
into
> account current stock in inventory and therefore reducing the
> quantity required to be produced. That in turn does not accurately
> reflect the proper planning for the upcoming day or week. We
believe
> this report would be run daily based on the fact that the
> requirements vary as well as the inventory in stock (already
> produced). Has anyone modified this report in such a way or does
> anyone have any suggestions how we can get this to suit our
planning
> needs? Does anyone currently plan labor, etc. based on current
> releases from their customers based on any report? Any help would
be
> fantastic. Thanks.
2
I will try to make this question as concise as possible. We are
looking to use the Shop Load report. However, it does not take into
account current stock in inventory and therefore reducing the
quantity required to be produced. That in turn does not accurately
reflect the proper planning for the upcoming day or week. We believe
this report would be run daily based on the fact that the
requirements vary as well as the inventory in stock (already
produced). Has anyone modified this report in such a way or does
anyone have any suggestions how we can get this to suit our planning
needs? Does anyone currently plan labor, etc. based on current
releases from their customers based on any report? Any help would be
fantastic. Thanks.
3
The shop load has no direct relationship to Inventory or Customer Orders. Load is calculated from outstanding Job Orders only. The basic logic from APICS fundamentals is:

1. You have Inventory in units of product.
2. You have independent demand in units of product, i.e. Customer Orders/Releases, with due dates.
3. MRP matches Inventory to Demand, and calculates net requirements per due dates.
4. Net requirements are translated into Job Orders and/Or Purchase order suggestions.
5. You create Job Orders in units of product/parts. This could be based on suggestions by MRP or your own judgement.
6. In CRP, load is increased when new Job Orders are marked as Firm/Released. Load is calculated in terms of std hours on work centers. Scheduling modules distribute/schedule Job Operations based on how you define the workcenters: finite/infinite loading, how many hours available, etc. Schedules may not meet the due dates.
7. Load is relieved in terms of std manhours as operation qty/hours are reported against the Job Order.

You can run load reports as often as you need if the information the CRP/Scheduling module needs is updated. If you don't enter Job Order information in a timely fashion, then it wouldn't make sense to run the report. However, you need to ask yourself on where to draw the line between planning and just reacting.

Hope this helps,

Gil Amilbangsa


-----Original Message-----
From: lheisey3 <lheisey@...> [mailto:lheisey@...]
Sent: Tuesday, 7 January 2003 8:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Shop Load Report Help or Enhancement


I will try to make this question as concise as possible. We are
looking to use the Shop Load report. However, it does not take into
account current stock in inventory and therefore reducing the
quantity required to be produced. That in turn does not accurately
reflect the proper planning for the upcoming day or week. We believe
this report would be run daily based on the fact that the
requirements vary as well as the inventory in stock (already
produced). Has anyone modified this report in such a way or does
anyone have any suggestions how we can get this to suit our planning
needs? Does anyone currently plan labor, etc. based on current
releases from their customers based on any report? Any help would be
fantastic. Thanks.



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=234081.2821106.4184440.1925585/D=egroupweb/S=1705007183:HM/A=1327986/R=0/*http://ad.doubleclick.net/clk;4870027;7586687;a?http://www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>
<http://us.adserver.yahoo.com/l?M=234081.2821106.4184440.1925585/D=egroupmail/S=:HM/A=1327986/rand=816338700>

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
Hi,
I'm not sure what you are looking for, but we have a report by
department that lists each workcenter, and then lists the jobs scheduled in
that workcenter. We run the report based on start date. It lists the job#,
part# and desc., Run qty, qty complete, start and due dates, and then the
est. and actual setup, production, and total hours. Our supervisors use
this report instead of the dispatch report to determine which jobs to run
for each workcenter. Let me know if you are interested and I can send you
the report.
Thanks,
Judy Stauduhar
Production Control Manager
Synovis Interventional Solutions
651-792-2874
jstauduhar@...


Message: 22
Date: Mon, 06 Jan 2003 22:31:43 -0000
From: "lheisey3 <lheisey@...>"
<lheisey@...>
Subject: Shop Load Report Help or Enhancement

I will try to make this question as concise as possible. We are
looking to use the Shop Load report. However, it does not take into
account current stock in inventory and therefore reducing the
quantity required to be produced. That in turn does not accurately
reflect the proper planning for the upcoming day or week. We believe
this report would be run daily based on the fact that the
requirements vary as well as the inventory in stock (already
produced). Has anyone modified this report in such a way or does
anyone have any suggestions how we can get this to suit our planning
needs? Does anyone currently plan labor, etc. based on current
releases from their customers based on any report? Any help would be
fantastic. Thanks.