Awarded Carrier= Multiply miles by carrier rate then you sum it with the answer u get after multiplying N910 and )910. Later the answer you will get, will be divided by the multiplication answer of O2 and O910.
A weighted average differs from an average in that a weighted average returns a number that depends on the variables of both value and weight.
=SUM((N2* O2)+(N910*O910))/SUM(O2:O910)
The weight average is different from the average such that the weight average returns a value that rely on the variables of both the weight and value.
In order to get Weighted average, one needs to type the following formula under its section:
=SUMPRODUCT (N2:N910, O2:O910)/SUM (O2:O910)
Increment Cost
It refers to the increase in the total cost as a result of an increase in the production
=SUM((N2*O2)+(N3*O3))/SUM(B2:B3)