Logic for Generating BOM Cost Report

I actually go this from Epicor. I don't think it's anywhere in Vantage.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, December 03, 2008 4:38 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Logic for Generating BOM Cost Report


This is perfect. Where would I have found this had I been intelligent
enough to search?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Wednesday, December 03, 2008 4:10 PM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: RE: [Vantage] Logic for Generating BOM Cost Report

Hope this helps!

How does the Bill of Materials Roll Up Costs procedure work?

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=71578/stime=1228338641/nc1=3848582/nc2=3848641/nc3=5202323>


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
What's the logic and data source for generating the BOM Cost Report?



I naively assumed that the PartCost table was what I wanted. But if I
run a BOM Cost Report even for a single bottom-level part, the costs
shown are not the std/ave/last for the part as it exists in PartCost.



Lvl Typ Seq Part Number Rev Alt Description

---- --- ---- -------------------- ------------ ------------
------------------------------



xxxxx-xx 2 Some Secret
Part Description



Quantity

Material Cost Subcont Cost Labor
Cost Burden Cost Mtl. Bur. Cost Total Cost



1.00000000

15.65002 0.00000
0.00000 0.00000 0.00000 15.65002

Extended: 15.65002 0.00000
0.00000 0.00000 0.00000 15.65002



Current Part Master Costs...

Average Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Standard Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Last Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100



So 16.101.00 is what I see in PartCost. Where does the Material Cost
shown come from?



It looks like it comes from CostPart (which is a brain-twisting way to
name tables), but as I look at that table I would expect the entry with
the most recent effectivedate to be the one that is used, and that
doesn't seem to be the case.



And that leads me to want to understand what the proper logic is to
duplicate the cost rollup. It looks like I need to multiple the parent
quantity to the first-level subcomponents to generate the required
quantity.



The whole point of this is to give my user an exportable BOM Cost
report that he can manipulate in Excel. Having this be a Progress
report is decidedly painful for him.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
I've been giving, and was hoping I might receive a little. Anyone
have any insight on this? Or my question about how folks are doing AR
in MultiCompany environments given Vantage doesn't do Centralized AR
(although rumour has it 9.1 will deliver this capability).



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Monday, December 01, 2008 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Logic for Generating BOM Cost Report



What's the logic and data source for generating the BOM Cost Report?

I naively assumed that the PartCost table was what I wanted. But if I
run a BOM Cost Report even for a single bottom-level part, the costs
shown are not the std/ave/last for the part as it exists in PartCost.

Lvl Typ Seq Part Number Rev Alt Description

---- --- ---- -------------------- ------------ ------------
------------------------------

xxxxx-xx 2 Some Secret
Part Description

Quantity

Material Cost Subcont Cost Labor
Cost Burden Cost Mtl. Bur. Cost Total Cost

1.00000000

15.65002 0.00000
0.00000 0.00000 0.00000 15.65002

Extended: 15.65002 0.00000
0.00000 0.00000 0.00000 15.65002

Current Part Master Costs...

Average Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Standard Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Last Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

So 16.101.00 is what I see in PartCost. Where does the Material Cost
shown come from?

It looks like it comes from CostPart (which is a brain-twisting way to
name tables), but as I look at that table I would expect the entry with
the most recent effectivedate to be the one that is used, and that
doesn't seem to be the case.

And that leads me to want to understand what the proper logic is to
duplicate the cost rollup. It looks like I need to multiple the parent
quantity to the first-level subcomponents to generate the required
quantity.

The whole point of this is to give my user an exportable BOM Cost
report that he can manipulate in Excel. Having this be a Progress
report is decidedly painful for him.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Hope this helps!

How does the Bill of Materials Roll Up Costs procedure work?

This document contains additional programming notes about the specific calculations used to roll up costs in the Advanced Bill of Materials module. Costs are calculated for each part/revision with a Method of Manufacturing.

Labor and burden costs are calculated using the operation setup and run times, work center rates and operation rates.

Subcontract costs are calculated as quantity required times the estimated unit costs entered for subcontract operations.

Material costs are calculated using the Bill of Material qty per assy times the appropriate Unit Cost.
For raw material components -

* Purchased Parts - only the Standard unit costs from the part master are used.
* For Assemblies - the costs found in the PartRev's method file are used. The files are processed in descending order to ensure that the lowest level children assembly costs are calculated first.

(NOTE: for Material components that are Manufactured, their cost is always rolled up from the PartRev's methods and BOM. The part master unit cost is never used for these parts in the same manner as Purchased parts are)

1. The program ROLLCOST is run as part of the BOM Cost Report, the view costs program, and in the Standard Cost Replace process.

2. Costs are calculated and stored in the PartRev cost fields. Cost categories calculated are Labor, Burden, Material, Setup Labor, Setup Burden and Subcontract. Two sets of totals are maintained in each record; LLR (Lower Level Rolled) and TLR (This Level Rolled). Lower Level is the sum of all lower levels of assembly, and is always zero for any raw material. This Level is the cost at this level only. The total cost for any assembly is the sum of LLR and TLR.

3. Primary files are PartRev, PartMtl and PartOpr.

4. Use Effectivity Date to determine the "current" revision when necessary.

5. To roll up material costs:

* Read related PartMtl records
* Find Part Master record for the PartMtl.MtlPartNum to determine if raw material or assembly
* If Part.Method = No (Raw Material) add part master costs to This Level Rolled Costs
* Part Master unit cost is Average, Standard or Last Labor+Burden+Matl Unit Cost
* Total material cost is Part master unit cost x PartMtl.QtyPer

* If Part.Method = Yes (Assembly),
* add "current" PartRev costs to Lower Level Rolled Costs if PartMtl.PullAsAsm = No, or
* add to This Level Rolled Costs if PartMtl.PullAsAsm = Yes
* This Level setup cost is total setup/MfgLotSize


6. To roll up labor/burden costs: (NOTE: It first calculates each Operation independent
of the others, then adds up the calc of each operation
to determine a final total)

* Read related PartOpr records
* For inside operations, get burden rate from the work center file, and labor rate from the operation file.
* Labor Cost is Production Labor Cost (PLC) + Setup Labor Cost (SLC)
* PLC = (EstProdHours x ProdCrewSize) x Opmaster.ProdLRate
* SLC = (EstSetHrs x SetupCrewSize) x OpMaster.SetupLRate/Part.MfgLotSize


* Burden Cost is Production Burden Cost (PBC) + Setup Burden Cost (SBC).
* Calculations are same as labor, except use WrkCenter rates and exclude the ProdCrewSize and SetupCrewSize when doing the final calculation.


* For subcontract operations, subcontract cost is PartOpr.EstUnitCost x QtyPer


* EstSetHrs are the set-up hours * number of machines from the job operations --->(Machines defaults from the machines/operation in the scheduling section of Work Center maintenance).


* EstProdHrs are calculated using several factors in each job operation:
* ((Qty/Parent + (Qty/Parent X Scrap%) X (Operations Per Part) = a result that is either multiplied or divided by the production standard, then is multiplied by the Job's Run Qty to equal the Estimated Production Hours.
* Multiplication or Division is determined by the type of Production Std Chosen.

Operations Per Part is only available if either Operations/Hour or Operations/Minute is
chosen as the standard. When the field is not available, assume it is 1.


7. When all costs have been accumulated, divide by MfgLotSize to convert to Unit Cost.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, December 03, 2008 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Logic for Generating BOM Cost Report


I've been giving, and was hoping I might receive a little. Anyone
have any insight on this? Or my question about how folks are doing AR
in MultiCompany environments given Vantage doesn't do Centralized AR
(although rumour has it 9.1 will deliver this capability).

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Brian W. Spolarich
Sent: Monday, December 01, 2008 4:04 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Logic for Generating BOM Cost Report

What's the logic and data source for generating the BOM Cost Report?

I naively assumed that the PartCost table was what I wanted. But if I
run a BOM Cost Report even for a single bottom-level part, the costs
shown are not the std/ave/last for the part as it exists in PartCost.

Lvl Typ Seq Part Number Rev Alt Description

---- --- ---- -------------------- ------------ ------------
------------------------------

xxxxx-xx 2 Some Secret
Part Description

Quantity

Material Cost Subcont Cost Labor
Cost Burden Cost Mtl. Bur. Cost Total Cost

1.00000000

15.65002 0.00000
0.00000 0.00000 0.00000 15.65002

Extended: 15.65002 0.00000
0.00000 0.00000 0.00000 15.65002

Current Part Master Costs...

Average Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Standard Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

Last Unit Cost: 16.10100 0.00000
0.00000 0.00000 0.00000

16.10100

So 16.101.00 is what I see in PartCost. Where does the Material Cost
shown come from?

It looks like it comes from CostPart (which is a brain-twisting way to
name tables), but as I look at that table I would expect the entry with
the most recent effectivedate to be the one that is used, and that
doesn't seem to be the case.

And that leads me to want to understand what the proper logic is to
duplicate the cost rollup. It looks like I need to multiple the parent
quantity to the first-level subcomponents to generate the required
quantity.

The whole point of this is to give my user an exportable BOM Cost
report that he can manipulate in Excel. Having this be a Progress
report is decidedly painful for him.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[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]
This is perfect. Where would I have found this had I been intelligent
enough to search?



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Wednesday, December 03, 2008 4:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: RE: [Vantage] Logic for Generating BOM Cost Report



Hope this helps!

How does the Bill of Materials Roll Up Costs procedure work?




.


<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=71578/stime=1228338641/nc1=3848582/nc2=3848641/nc3=5202323>




[Non-text portions of this message have been removed]