LED lighting, LED Lamp, LED Display, LED tube

How to invest future – Auto Insertion and SMT equipment ROI calculation

Fill in “Green Areas” on Summary Sheet Below & Production Need Sheet

Calculations in “Blue” or “White” and should not be changed

INPUTS
FinancialMachine PriceDepreciation Time (Years)

Electricity Cost ($/kWHr)

US$ 205,000

5

US$ 0.1200
Machine DataConfigurationPass Thru / Non Pass Thru

Spec Speed

Sm Triple Span (2.5/5.0/7.5)Pass Thru (Automatic BDH)

22,000

Labor Rates / HourMachine OperatorMaintenance
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