|
Fill in “Green Areas” on Summary Sheet Below & Production Need Sheet |
|||
|
Calculations in “Blue” or “White” and should not be changed |
|||
| INPUTS | |||
| Financial | Machine Price | Depreciation Time (Years) |
Electricity Cost ($/kWHr) |
| US$ 205,000 |
5 |
US$ 0.1200 | |
| Machine Data | Configuration | Pass Thru / Non Pass Thru |
Spec Speed |
| Sm Triple Span (2.5/5.0/7.5) | Pass Thru (Automatic BDH) |
22,000 |
|
| Labor Rates / Hour | Machine Operator | Maintenance | |
| US$ 10.00 | US$ 15.00 | ||
| Factory Work Time |
Hours / Day |
Days / Week |
Weeks / Year |
|
20 |
6 |
50 |
|
| Hand Labor |
Hand Labor Rate |
Insertion Rate / Hour |
|
| US$ 6.00 |
250 |
||
| OUTPUTS | |||
| Production Data | |||
| Insertions Needed | 4,900,000 | Annual Component Insertion | |
| Machine Work Time | |||
| Machine Time |
613 |
Hours to MFG | |
| Hours in Year |
6000 |
||
| Machine Utilization |
10.22% |
||
| Machine Yearly Costs | |||
| Depreciation | US$ 41,000 | Straight Line Depreciation | |
| Utilities | US$ 155 | Electricity for Machine & Air | |
| Maintenance | US$ 900 | Parts & Labor for Machine | |
| Operator | US$ 6,132 | Operator Time @ machine | |
| Total Yearly Costs | US$ 48,186 | Sum of all costs | |
| Hand Labor Equivalents | |||
| Labor Hours | 19,600 | ||
| Labor Costs | US$ 117,600 | ||
| MACHINE DRIVEN SAVINGS | |||
| Hand Placement Cost | US$ 117,600 | Per Year | |
| Machine Placement Cost | US$ 48,186 | Per Year | |
| Annual Savings | US$ 69,414 | Per Year | |
|
Price |
Unit |
Notes |
|
|
Machine Cost |
US$ 205,000 |
$ |
Machine Costs |
|
Depreciation Time |
5 |
Years |
Straight Line Assumed |
|
Yearly Deprciation Expense |
US$ 41,000 |
Result |
|
|
Work Days per Week |
6 |
Days |
|
|
Hours Per Day |
20 |
Hours |
|
|
Weeks per year |
50 |
Weeks |
|
|
Hours per Year Available |
6,000 |
Hrs/Year |
Work Hours per Year |
|
PM Hours per 100 Hrs |
12 |
Hours |
Maintenance |
|
Machine Working Hours |
522 |
Hours |
Total Production Hours |
|
Maintenance Intervals |
5 |
Periods |
Maintenance Times |
|
Maintenance Time |
60 |
Hours |
Maintenance Times |
|
Maintenance Labor Cost |
US$ 900 |
Costs |
Labor Hours x Rate |
|
Production Hours Needed |
522 |
Hours |
Machine Production Time |
|
Intrinsic Availability |
94.00% |
Uptime |
Downtime (Increased based on Age) |
|
Lost Hours |
31 |
Hours/Yr |
Downtime |
|
Machine Hours To Produce |
553 |
Hours |
Production Hours |
|
Guide Jaw / Clinch Costs |
US$3,000 |
Cost |
Per Unit |
|
Tooling Replacement |
6,000,000 |
Cycles |
Cycles per replacement |
|
Tooling Replacements / Yr |
0 |
Replacements |
Replacements Needed |
|
Yearly Replacement Costs |
US$0.00 |
Costs |
Total Yearly Tooling Costs |
|
Chain Clip Replacments |
US$780 |
Cost |
Cost Per Replacement |
|
Tooling Replacement |
15,000,000 |
Cycles |
Cycles per replacement |
|
Tooling Replacements / Yr |
0 |
Replacements |
Replacements in a Year |
|
Yearly Replacement Costs |
US$0.00 |
Costs |
Total Yearly Chain Costs |