Home > Business > Analysis Template > Cost Analysis Template > Vendor Cost Analysis Sample

Vendor Cost Analysis Sample

At Speedy Template, You can download Vendor Cost Analysis Sample . There are a few ways to find the forms or templates you need. You can choose forms in your state, use search feature to find the related forms. At the end of each page, there is "Download" button for the forms you are looking form if the forms don't display properly on the page, the Word or Excel or PDF files should give you a better reivew of the page.

Vendor Cost Analysis Sample
Vendor Cost Analysis Sample
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%
Vendor Cost Analysis Sample