This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Part Cost Model
Current Setup
What_If - I Change
Order Quantity
You can change values here to see the cost difference in results section below
Part Weight (gms)
# of cavities (no of imperssion)
Cycle Time (secs)
Material Cost ($/lb)
Machine Hourly Rate ($/hour)
Labor Hourly Rate ($/hour) $
Other Cost ($ per part)
Max working days in a year
RESULTS
Change in # Cavities
New Cycle Time
New Material
$
Max Volume/year (in Millions)
Hours/1000 parts
Hours to complete order
Material Cost ($)
Machine Cost ($)
Labor Cost ($)
Other Cost ($)
Total Order Cost ($)
Cost/part (in Cents)
Cost per 1000
Cost difference (from current setup)
Print
Reset
Print This