Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
SteveFrey
Posts: 517
Registered: ‎09-12-2007
Message 1 of 5 (324 Views)

Estimates COST from BOM / Parts List?

324 Views, 4 Replies
07-16-2013 12:16 PM

I would like to get an estimated cost of an assembly.  The assembly is made up of different extrusions that we make.  I know the price per foot of the extrusion.  I am assuming between the iProperties and the BOM this can be calculated but I can't figure out how.  I would like to calculate the extrusion per foot to get the cost.  So if I use 3 feet of extrusion at $4.00 per foot the total estimated cost would be $12.00. 

 

We chrome plated some of our extrusion by an outside vendor. The second part of this is can I figure out how much the material cost + plating cost is per foot?  So the extrusion that costs $4.00 per foot costs an additional $5.00 per foot to be plated so $9.00 per foot plated. 

 

How would I go about this?  Thanks!

 

 

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
*Expert Elite*
Curtis_Waguespack
Posts: 2,882
Registered: ‎03-08-2006
Message 2 of 5 (317 Views)

Re: Estimates COST from BOM / Parts List?

07-16-2013 12:23 PM in reply to: SteveFrey

Hi  SteveFrey,

 

It's generally poor practice to load your CAD data with costing information, as it presents a challenge when prices go up (or down?). I might recomend exporting the BOM to a spread sheet that is pre-loaded with the current pricing, as demonstrated at this link:

http://inventortrenches.blogspot.com/2011/06/ilogic-export-parts-list-with-options.html

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





Distinguished Contributor
SteveFrey
Posts: 517
Registered: ‎09-12-2007
Message 3 of 5 (312 Views)

Re: Estimates COST from BOM / Parts List?

07-16-2013 12:25 PM in reply to: Curtis_Waguespack

I was trying to stay away from exporting it to excel but I can if need be.

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
*Expert Elite*
Curtis_Waguespack
Posts: 2,882
Registered: ‎03-08-2006
Message 4 of 5 (299 Views)

Re: Estimates COST from BOM / Parts List?

07-16-2013 01:05 PM in reply to: SteveFrey

Hi  SteveFrey,

 

I suppose you could also read in the current costing information from excel and do the calculations via iLogic code and then write it to the assembly iProperties. Or do it all in the models (if you must) and use iLogic to calculate, but I don't know of built in solution for doing the costing calcs without using some code.

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





Distinguished Contributor
SteveFrey
Posts: 517
Registered: ‎09-12-2007
Message 5 of 5 (293 Views)

Re: Estimates COST from BOM / Parts List?

07-16-2013 01:10 PM in reply to: Curtis_Waguespack

Sounds complicated.  I guess the way to do it would be to send the BOM from Vault (which I'm not currently running) to our ERP system.  I imagine this is even more complicated.  The excel route is sounding better every minute.......

 

Thanks!

Steve Frey
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.