Material Cost and Price Manager

Keep your material costs and prices updated with our Material Cost and Price Manager utility!

For shops that have a lot of materials or see continuous cost fluctuation, this utility will allow for quick and accurate changes in material costs and prices in a matter of minutes instead of hours, eliminating individual calculations and reducing the risk of data entry errors.

Time Per Material (Seconds)	Number of Cost Changes	Total Time to Complete Changes (Minutes)	Total Cost ($20/hr employee)
10	100	17	$5.67
	500	85	$28.33
	1,000	170	$56.67
	5,000	850	$283.33
	10,000	1700	$566.67
	50,000	8,500	$2,833.33

How it works:
Instead of looking up each individual record through the materials tab, changing its cost or price and then looking for another, simply take the following steps:

• Populate the utility – This can be done by copying and pasting or by clicking the “Retrieve All" button.
• Adjust costs or prices – Adjust one by one, in groups, or apply a blanket change across all materials.
• Hit “Update All.”

Features:

• Update job template price
• Spreadsheet export and import to update costs and prices (spreadsheets do not create or delete records)
• User interface to update and delete material costs and prices
• Creates an audit trail of updates – tracks machine, date and windows username of who made the update
• Material Historical Cost report informs you of when the cost or price last changed, and who made the update

You are able to edit the following fields either one at a time or en masse with an Excel spreadsheet export/import:

• Sell Price
• Standard Cost
• Last Cost
• Average Cost
• Reorder Point
• Reorder Quantity
• Notes
• Quantity Price Breaks
• Customer Prices
• Customer Prices
• Vendor pricing
• Template Price Update (sets last cost to PO price on direct job buys)