The following question requires your selection of CCC/CCE Scenario 6 (2.7.50.1.3) from the right side of your split screen., using the drop down menu, to reference during your response/choice of responses.

The following question requires your selection of CCC/CCE Scenario 6 (2.7.50.1.3) from the right side of your split screen., using the drop down menu, to reference during your response/choice of responses.

Calculate the weighted average unit cost.
A . $46.13
B . $47.63
C . $48.35
D . $48.09

View Answer

Answer: B

Explanation:

The weighted average unit cost takes into account both the cost and the quantity:

Weighted Average=∑(Unit Cost×Quantity)∑Quantitiestext{Weighted Average} = frac{sum (text{Unit Cost} times text{Quantity})}{sum text{Quantities}}Weighted Average=∑Quantities∑(Unit Cost×Quantity)

Multiplying each unit cost by the respective quantity:

(55.00×147)+(34.50×143)+(37.30×462)+(55.00×530)+(40.00×308)+(26.78×45)+(46.59×256)+(75.00×1

76)+(65.00×80)(55.00 times 147) + (34.50 times 143) + (37.30 times 462) + (55.00 times 530) + (40.00 times 308) + (26.78 times 45) + (46.59 times 256) + (75.00 times 176) + (65.00 times 80)(55.00×147)+(34.50×143)+(37.30×462)+(55.00×530)+(40.00×308)+(26.78×45)+(46.59×256)+(75.0 0×176)+(65.00×80)

Summing these and dividing by the total quantity:

Weighted Average=20941.6+4933.5+17247.6+29150.0+12320.0+1205.1+11926.1+13200.0+5200.021 47text{Weighted Average} = frac{20941.6 + 4933.5 + 17247.6 + 29150.0 + 12320.0 + 1205.1 + 11926.1 + 13200.0 + 5200.0}{2147}Weighted Average=214720941.6+4933.5+17247.6+29150.0+12320.0+1205.1+11926.1+13200.0+5200.0

This gives a weighted average of approximately $47.63, making B. $47.63 the correct answer.