Vendor Cost Analysis Sample - Free Download
4.9,
3238
votes
Please vote for this template if it helps you.
Vendor Cost Analysis
Part Number
Description
Total Requirements (Units) 20,000
Number of Vendors 5
Requirement per Vendor 4,000
PRICES AND DELIVERY COSTS IN UNITS
Vendor Bid Price Delivery Total
1. Vendor $24 $1 $24
2. Vendor $21 $2 $23
3. Vendor $23 $2 $25
4. Vendor $22 $1 $23
5. Vendor $22 $1 23.45
Average Delivered Price Per Unit $23.75
ALLOCATION OF ORDERS AND COSTS
Manual Delivered Price vs. Actual Amount
Vendor Override Price/Unit Average Order of Order
1. Vendor 3000 $24 103% 3000 $73,200
2. Vendor 10000 $23 95% 10000 $226,500
3. Vendor 0 $25 104% 0 $0
4. Vendor 7000 $23 99% 7000 $164,150
5. Vendor 0 $23 99% 0 0
Total Units 20000
SUMMARY
Total Cost of Orders $463,850
Low Bidder Total $453,000
Multiple Bid Premium and % $10,850 2.40%
