I have developed stuff on our 405 CD to meet similar needs.
Many BPCS reports are not Excel-friendly. I have cloned many into what I
call Excel-friendly, using a /COPY check list in the comment section
reminding me all what needed. Another /COPY in front of the output
specifications reminding me which edit codes put the minus sign in front of
the digits, so that Microsoft Wizard can recognize that as a negative #.
When importing item# column to Excel, I ask for TEXT because some start with
string of zeros. Column headers include how wide the field, # decimal
places, whether to left justify, because Excel wizard often scrambles what
was good 400-I output.
We made modified versions of INV260. Only list items that when you multiply
on-hand by cost variance the result is non-zero (reduced from being a door
stop report, to an exception report), and/or also restrict to raw materials.
Copy Standard to Simulation, then run standard cost rollup, then run
query/400 which only lists those where standard not same as simulation, and
we have on-hand ... multiplies variance extended value impact.
Before doing shop order purge, similar copy actual costs, and limited FSO
copy (what items coded completed), then after purge run similar report
summarizing changes, showing end items whose profit margins threatened.
ECIF file updated nitely to add to index ... end item by customer &
facility, that have ever been on order or shipped. We use this in
combination with all sorts of other reports.
HCIF file regularly rebuilt from latest engineering data ... it is a
relational data base compliant format file that links all end items to all
components, with how much of the components go into which end items (various
BOM layers multiplied)
Other work files & hijacked IIM fields to track commodity content (copper in
our case) so we can get at how much of it we received each month, and its
content by customer items sold.
By combining ECIF & HCIF & other resources, we can get at
* list inventory on-hand that has not been used (in production or shipments)
in some time period,
* valuation list of raw materials on-hand used exclusively by certain
customers vs. shared ... this was invaluable when a customer went bankrupt,
and suddenly we needed to divorce all material used exclusively on them
* slow moving raw materials (On-hand excessive when compared to YTD usage)
is used on what customers
* when price increase on some raw materials, what end items profit margins
I also have a report that uses embedded SQL against ITH archives to chart
usage of raw materials in each of several years ... one column each for 2005
2006 2007 2008 2009 ... this helps us adjust economic reorder quantities,
safety stock, tooling (we can have multiple copies same tooling, which is
very expensive, so this helps us see which we can part company with).
Happy I remain this functional: Wake up each morning; roll out of bed; feet
touch floor; I can stand up (sometimes need to push with arms); walk; get to
toilet; all familiar systems do their thing.
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of
Sent: Friday, October 09, 2009 12:33 PM
Subject: [BPCS-L] Costed Bill of Material
I'm trying to find a Fully Indented Costed bill of material report that
I can run. (really would like to get it to excel)
Like CST280 -- only lets me choose the Method code for the
Bom...currently CST280 does not give you a choice - it pulls the first
method code out there.... This causes problems when adding the costs
What I really want is a tool to compare my Frozen Standard Costed Bom
(FS method code Bom and FS method code Router with Cost set 03 Frz Std
Cost, with a cost roll I did for 2010 plan - (PS method code Bom, PS
Router, cost set 86) I'd also like to see what unit of 1 cost for the
raws then the extended cost... (currently shows only extended cost)
One step further - I then want to take forecast of Sales by Part number
and pull it down to raw materials for volumes.... Finding which raw
material costs are driving the most variance from Frz Std to New Plan
Also, why -- why do you get method codes for boms and router but not for
Workcenter rates? - you have to keep everyone out of transaction
processing - change the rates - roll "Plan" costs -- change the rates
back and let everyone back in....
Somebody has to already have a tool or program written that is similar
or know of an inexpensive product?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.