×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Product data management tips please

Product data management tips please

Product data management tips please

(OP)
Hello,
3 yrs of work have resulted in a device with 200 unique parts, 800 in total per assembly.
Each of these parts has had up to five people quote for it.
Some parts have tooling quotes associated with them.
I am now trying to organise my data so I can give accurate pricing information to the marketing department, I would like to easily see what difference different tooling verses fabrication scenarios would have on the cost in the future.
I currently use Solidworks and Excel Spread sheets with limited success,
Any suggestions?

RE: Product data management tips please

Making the assumption that you do not have a formal MRP system available to help with your bill of materials (BOM), you can do a significant portion if not all using EXCEL or a similar spreadsheet program.

You have some 800 parts in the assembly, try to break this down into a logical sub-assembly structure that will allow you to work pieces of data rather than the whole.  Apply costing data to the various subs and then sum them up for your total.  Components from various suppliers may be designated with a supplier unique code which would allow you to do "side by side" sub-assembly combinations of components.  Take the non-recurring engineering, tooling, and quoted parts cost and amortize them over a set number of assemblies or forcast product volume to provide cost comparisons.  You can do this as well if you are considering doing the part internally provided you know your Material, Tooling, Labor, Overhead (MTLO) values.

Good Luck!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources