This workbook allows you to analyze why the value of goods received varies from the purchase order value.

The following variance types exist:

• The price variance of the value of goods received gives you the difference between the value of goods received and the effective purchase order value. The difference is caused by a price variance, meaning the vendor has billed you for more (positive value) or less (negative value) of the material than was agreed in the purchase order.
• The quantity variance of the value of goods received gives you the difference between the value of the goods received and the effective purchase order value. The difference is caused by a quantity variance, meaning the vendor has delivered more (positive value) or less (negative value) of the material than you ordered.

The workbook contains the following queries: