Engineer To Order Material Costs

Now that we have been investigating many of the details of material costs in quotations, we will now take a look at the mathematical calculations required.

Engineer To Order Material Costs

Step 1)  Determine the quantity of parts required.   This is the number of parts required to make the end product.  In many situations if you are building a large assembly there may be situations where parts required would be greater than 1.

partsRequired = 1   // Usually 1

Step 2) Determine the total quantity required to manufacture the quantity that is being requested on the quotation

totalQuantity   = quotationQuantity*partsRequired

Step 3)  Calculate the number of parts or pieces that can be made out of a single purchased stock.

stockPieces = xxx

Step 4)  Stock Required is the number of purchased units that are required to manufacture the quoted quantity

stockRequired = Ceiling(totalQuantity / stockPieces)

Step 5) Determine the unit cost of the stock item.  With quantity breakouts the cost may vary depending on the quantity.  Also, the breakouts may be in different units, i.e. LBS versus EACH.  So we find the matching price based on the totalQuantity multiplied by the Unit Of Measure conversion.

price = FindMatchingPrice(stockRequired*unitOfMeasureConversion)

The goal now is to come up with a Unit Cost of material based on the values above and the type of material calculation which was described earlier.

MIE Solutions provides software resources to help you manage your direct and indirect labor throughout the product life cycle from quoting and estimating, job costing to invoicing.

Assuming sheets or plates of material which have both width and length.

Single Part Price

return price

Lot Price

return price/totalQuantity

Amortize

return (unitOfMeasureConversion*stockRequired*price)/ totalQuantity

Calculate Include Scrap

return price *unitOfMeasureConversion/stockPieces

Calculate Without Scrap

return price *(unitOfMeasureConversion / ((stockWidth*stockLength)*(blankWidth*blankLength))/partsPerBlank

MIE Solutions provides software resources to help you manage your direct and indirect labor throughout the product life cycle from quoting and estimating, job costing to invoicing.

http://www.mie-solutions.com/mie/index.php/MIE-QuoteIt-Quoting-and-Estimating-Software/mie-quoteit.html

Advertisement