Market Factoring Worksheet
Quoted pricing on precious metal parts uses a base price or "standard costing" for the cost of the amount of precious metal in the parts. This makes it necessary to adjust that price when invoicing the customer. Below is a calculating worksheet to help you plug in your data to compute what the final cost (minus shipping) of the delivered parts would be.

This program calculates the final price for you. Please follow the steps in the text box above. If you have difficulty getting results you may download the spreadsheet in an excel file by clicking here. Norstan makes no warranty on the accuracy of the spreadsheet and is not responsible for errors and omissions.

Precious
Metal Type		 Quoted Market Price Of Precious Metal

Actual Market Price

Difference (calculated automatically) Factor of each precious metal
Silver (Ag) $
Gold (Au) $
Platinum (Pt) $
Palladium (Pd) $
Iridium (Ir) $
Ruthenium (Ru) $

Quoted Price of parts in $/M
(per thousand pieces)

Adjusted Price
you pay:

$

Fill in the necessary information in the yellow boxes. For each metal provide the information. Leave boxes blank if that metal is not included. The gray boxes will automatically be calculated based on your input.
 Revised: 12/26/01
Norstan, Inc. • 10333 82nd Ave, Pleasant Prairie, WI 53158 • Phone: 800.244.8338
Sales/Customer Service Fax: 262.947.0777 • Fax: 262.947.0778 • info@norstaninc.com