Click on this link ROI - machine rate.xlsm to determine payback of a robot based on average or specific machine rates with or without labor costs.
Click on this link ROI - detailed data.xlsm to determine payback of a robot based on specific data including number of operators, labor rates, machine hours,productivity, cavitation, part cost, part value, mold open, overall cycle, scrap, mold damage and lost production. It identifies savings resulting from increased yield,decreased labor, decreased scrap and decreased damage.
How well did this work for you? Please e-mail us at firstname.lastname@example.org. We welcome all comments and suggestions.