Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rough Cut Capacity
- Thread starter DANAHER
- Start date
maccrystal
Technical User
Roughcut only looks at specific type of orders which include (pop orders, SFC ORders released and unreleased, Firm planned and computer planned). Make sure you are merging the correct types of orders into the MPS. To test, enter a MPS firm for a part that you established a load profile, use a large quantity so it stands out. Remerge the schedule and see if it does not show in the RCP report.
I only setup my bottle neck workcenters or resources to monitor. (Drum - Rope - Buffer) or Opt theory of contrains.
I only setup my bottle neck workcenters or resources to monitor. (Drum - Rope - Buffer) or Opt theory of contrains.
SusanD5320
Technical User
DANAHER & I are at the same company.
We're on 7.6.300 sbB SQL. We had our BP WebEx in yesterday and it appears everything is set up properly. We have Dept, Work Center, Work Center Capacity, Shop Calendar, and Product Load Profile updated. MRP planned a CP order due 1/30/06 for 30,000 units plus there is an open PP order for 6,500. We have merged both CP and PP orders into the MS. Our reporting calendar goes out to 3/3/06.
The Rough Cut Capacity view and report both take over 30 minutes to run. We only have 2 items with load profiles in the dept/wc that we're testing.
Our BP sent us the HZPLP dll's but the dates match the ones in our BIN file so I'm not very confident that's our issue..
Any additional suggestions would be greatly appreciated.
Sue
We're on 7.6.300 sbB SQL. We had our BP WebEx in yesterday and it appears everything is set up properly. We have Dept, Work Center, Work Center Capacity, Shop Calendar, and Product Load Profile updated. MRP planned a CP order due 1/30/06 for 30,000 units plus there is an open PP order for 6,500. We have merged both CP and PP orders into the MS. Our reporting calendar goes out to 3/3/06.
The Rough Cut Capacity view and report both take over 30 minutes to run. We only have 2 items with load profiles in the dept/wc that we're testing.
Our BP sent us the HZPLP dll's but the dates match the ones in our BIN file so I'm not very confident that's our issue..
Any additional suggestions would be greatly appreciated.
Sue
In reference to
/qThe Rough Cut Capacity view and report both take over 30 minutes to run. We only have 2 items with load profiles in the dept/wc that we're testing./q
If they thought it was the dll's were the problem then I would do the following
You stated that the dates matched the ones in your bin directory but I would further look at
1. The dates AND times
2. The sizes
3. I would even look at the properties and check for version numbers etc.
Macola is notorious for putting out DLL's on the same date and having to fix them on the same day they released them.
Andy Baldwin
"Testing is the most overlooked programming language on the books!
/qThe Rough Cut Capacity view and report both take over 30 minutes to run. We only have 2 items with load profiles in the dept/wc that we're testing./q
If they thought it was the dll's were the problem then I would do the following
You stated that the dates matched the ones in your bin directory but I would further look at
1. The dates AND times
2. The sizes
3. I would even look at the properties and check for version numbers etc.
Macola is notorious for putting out DLL's on the same date and having to fix them on the same day they released them.
Andy Baldwin
"Testing is the most overlooked programming language on the books!
Please check your file validation reports on the IMITMIDX, IMINVLOC and BMPRDSTR files. What kinds of things are there?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
maccrystal
Technical User
If you go to "MPS and enter a Firm planned order using a large quantity", using an item that you setup a load profile for, does it show up on the RCP report after you do a merge?
- Thread starter
- #7
At this time we are not converting CP to FP then to a POP order. I feel confident that we are doing the merge into the MS correctly. We also the updated the dll's as suggested in earlier e-mails. Nothing changed.
What is the relationship of the Work Center Capacity to the Reporting Calendar?
Where does rought cut look for the labor hours? Does it come from the Cost Master File and/or from the Product Structure Cost File?
What is the relationship of the Work Center Capacity to the Reporting Calendar?
Where does rought cut look for the labor hours? Does it come from the Cost Master File and/or from the Product Structure Cost File?
It looks at the product load profiles and the work center capacity files, thats it.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
SusanD5320
Technical User
I ran the system validation reports as suggested by dgillz. The parents/components that are in the product load profile do not appear on any of the reports.
It appears that we have issues with MANY other items. (The report for the IMITIDX is 1,823 pages. Most are KitPriceRollup, KitCost Rollup, FeaturePriceOption and ProdCat for a product line we sold off over 5 years ago.)
Could these be causing the problem even though they don't have a product load profile?
Sue
It appears that we have issues with MANY other items. (The report for the IMITIDX is 1,823 pages. Most are KitPriceRollup, KitCost Rollup, FeaturePriceOption and ProdCat for a product line we sold off over 5 years ago.)
Could these be causing the problem even though they don't have a product load profile?
Sue
I will be honest and say I don't know much about the the rough cut capacity report, but I was able to run a SQL trace and capture the selection criteria used to generate the source table. (MacolaES)
So you need data in your master schedule file. The report ignores Customer Orders, Purchase Orders, and Forecast order types (in above file). Pulls data from the product load profile, and finally from the Mfg Setup file.
Hope this may help, although it seem everyone else was pointing at the same things.
SELECT msschfil_sql.start_dt, hzplpfil_sql.load_meth, msschfil_sql.ms_qty, hzplpfil_sql.lbr_hr_per, hzplpfil_sql.per_lbr_hr, hzplpfil_sql.mch_hr_per, hzplpfil_sql.per_mch_hr, hzplpfil_sql.setup_tm, hzplpfil_sql.dept, hzplpfil_sql.wc, msschfil_sql.item_no, hzctrfil_sql.wc_desc FROM hzplpfil_sql LEFT OUTER JOIN msschfil_sql ON hzplpfil_sql.item_no = msschfil_sql.item_no LEFT OUTER JOIN hzctrfil_sql ON hzplpfil_sql.wc = hzctrfil_sql.wc AND hzplpfil_sql.dept = hzctrfil_sql.dept WHERE MSSCHFIL_SQL.gen_file = '0' AND MSSCHFIL_SQL.start_dt <= '2005-12-31' AND Not(msschfil_sql.Ord_Type IN ('CO', 'PO', 'FO'))
So you need data in your master schedule file. The report ignores Customer Orders, Purchase Orders, and Forecast order types (in above file). Pulls data from the product load profile, and finally from the Mfg Setup file.
Hope this may help, although it seem everyone else was pointing at the same things.
SELECT msschfil_sql.start_dt, hzplpfil_sql.load_meth, msschfil_sql.ms_qty, hzplpfil_sql.lbr_hr_per, hzplpfil_sql.per_lbr_hr, hzplpfil_sql.mch_hr_per, hzplpfil_sql.per_mch_hr, hzplpfil_sql.setup_tm, hzplpfil_sql.dept, hzplpfil_sql.wc, msschfil_sql.item_no, hzctrfil_sql.wc_desc FROM hzplpfil_sql LEFT OUTER JOIN msschfil_sql ON hzplpfil_sql.item_no = msschfil_sql.item_no LEFT OUTER JOIN hzctrfil_sql ON hzplpfil_sql.wc = hzctrfil_sql.wc AND hzplpfil_sql.dept = hzctrfil_sql.dept WHERE MSSCHFIL_SQL.gen_file = '0' AND MSSCHFIL_SQL.start_dt <= '2005-12-31' AND Not(msschfil_sql.Ord_Type IN ('CO', 'PO', 'FO'))
Susan,
I don't believe the errors you mentioned would affect rough cut capacity.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
I don't believe the errors you mentioned would affect rough cut capacity.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
SusanD5320
Technical User
We deleted all old profile info from MS. We now have only two items set up with profiles, same dept, same WC. There are weekly CP orders merged into the MS for these same two items.
Rough Cut report now takes 12 minutes to run. It shows WC capacity by period but the scheduled labor and machine hours both show zero. I'm assuming that RC takes the info from the item's product load profile and multiplies by the CP and/or PP quantities to show scheduled hours. Then displays this compared to capacity.
What are we missing here?
Sue
Rough Cut report now takes 12 minutes to run. It shows WC capacity by period but the scheduled labor and machine hours both show zero. I'm assuming that RC takes the info from the item's product load profile and multiplies by the CP and/or PP quantities to show scheduled hours. Then displays this compared to capacity.
What are we missing here?
Sue
- Status