Bid Summary and Total Cost Analysis Worksheet
Bid Summary	Computadora	PhotosRUs	Keompyuteo	Changhong
Quoted Price	$10.00	$14.00	$10.00	$6.00
Tooling Costs (total)	$500,000	$300,000	$250,000	$150,000
Quality (defects per million cameras)	500	1,000	300	100
Ordering, Inbound Receiving, and Inspection Cost (per unit)	$0.75	$0.50	$1.50	$1.50
On Time Delivery	99%	90%	95%	98%
Duties and Customs (per unit)	$1.00	$0.00	$2.00	$2.50
Ramp up Time (weeks)	8	5	10	4
Shipment Frequency	2 per week	1 per week	2 per month	1 per month
Lead Time (from time of order until product ships)	1 day	2 days	4 weeks	6 weeks
Capacity Utilization (based on maximum capacity)	90%	97%	75%	80%
Denomination of Contract	Dollars	Dollars	Korean Republic Won	Dollars
Cost Category: use formulas for your calculations and calculate per unit cost
All Calculations should be done for the first year volumes only except tooling (amortized over 2 years)
Cost Element / Supplier	Computadora	PhotosRUs	Keompyuteo	Changhong
Quoted Unit Price
Tooling
Quality Nonconformance Costs
Late Delivery Cost
Ordering, Inbound Receiving, and Inspection Cost (per unit)
Shipping/Transportation Cost
Duties and Customs
Transportation Inventory
Safety Stock Inventory
Estimated Per Unit TCO