Average Amount - Sum of ARFE2.ClaimAmt / Sum of ARFE2.PurchasedUnits for all UPC/PLUs for the Units group. Detail line: UPC/PLU DetailProduct.UPC – UPC/PLU Description - DetailProduct.Description UOM Display the Description from List Management where the – LM Code = Code = Size’ and the LM value = ‘Container ProdContainer.ContainerSizeCd Units - DetailProduct.Quantity Target Price Current DetailProductPeerGroup.PriceAmt – Lift Factor Current DetailProductPeerGroup.Factor – NTE Price Current DetailProductPeerGroup.PriceAmt times – current DetailProductPeerGroup.Factor Units Purchased Sum of ARFE2.PurchasedUnits – Average Claim Amount Sum of ARFE2.ClaimAmt / Sum of – ARFE2.PurchasedUnits Claim / Target Price – (Average Claim Amount / Target Price) – 1.0 Claim / NTE Price (Average Claim Amount / NTE Price) 1.0 – – Sort Order Peer Group, Category, Subcategory, Units (rounded values), UPC sequence. Total /Count None Columns State Totals None Primary Group Peer Group (page break) Additional Category, Subcategory, Units (the rounded values) Group By
Average Amount - Sum of ARFE2.ClaimAmt / Sum of ARFE2.PurchasedUnits for all UPC/PLUs for the Units group. Detail line: UPC/PLU – DetailProduct.UPC UPC/PLU Description - DetailProduct.Description UOM – Display the Description from List Management where the LM Code = Code = ‘Container Size’ and the LM value = ProdContainer.ContainerSizeCd Units - DetailProduct.Quantity Target Price – Current DetailProductPeerGroup.PriceAmt Lift Factor – Current DetailProductPeerGroup.Factor NTE Price – Current DetailProductPeerGroup.PriceAmt times current DetailProductPeerGroup.Factor Units Purchased – Sum of ARFE2.PurchasedUnits Average Claim Amount – Sum of ARFE2.ClaimAmt / Sum of ARFE2.PurchasedUnits Claim / Target Price – (Average Claim Amount / Target Price) – 1.0 Claim / NTE Price – (Average Claim Amount / NTE Price) – 1.0 Sort Order Peer Group, Category, Subcategory, Units (rounded values), UPC sequence. Total /Count Columns None State Totals None Primary Group (page break) Peer Group Additional Group By Category, Subcategory, Units (the rounded values)
DFDD%20VM%20Vendor%20Management%20Reports%20(3).docx