This workbook allows you to analyze why the invoice value varies from the purchase order value.

The following variance types exist:

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

The workbook contains the following queries: