Inventor General Discussion

Inventor General Discussion

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

Estimates COST from BOM / Parts List?

376 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: 3,002
Registered: ‎03-08-2006
Message 2 of 5 (369 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: 526
Registered: ‎09-12-2007
Message 3 of 5 (364 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: 3,002
Registered: ‎03-08-2006
Message 4 of 5 (351 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: 526
Registered: ‎09-12-2007
Message 5 of 5 (345 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.