Weighted Average Unit Cost Formula. Weighted average unit cost is computed using the following formula: = 850,000 + 700,000 + 640,000 =.

A video explaining the calculation of a weighted average in excel is provided on the microsoft office support website. Cost of goods available for sale / total number of units in inventory. Total equivalent units for a cost component = a + b × c