Spreadsheet Calculator 46383 | Roi Calculation Sheet And Web Cleaning 1

172x Filetype XLS File size 0.03 MB Source: www.ccsteven.com

File: Spreadsheet Calculator 46383 | Roi Calculation Sheet And Web Cleaning 1

sheet 1 calc instructions instruction page to calculate your return on investment roi please follow these steps print this page and follow the instructions step operating time 1 enter the ...

Filetype Excel XLS | Posted on 18 Aug 2022 | 3 years ago

Download

Partial file snippet.

Sheet 1: Calc. Instructions

Instruction Page

To Calculate your Return on Investment (R.O.I.), please follow these steps:

Print this page and follow the instructions

Step #

Operating Time
1
Enter the number of hours the machine operates per day.

Work days/year
2
Enter the operating days per year. For example 5 days a week for 50 weeks per year, enter 250.

Machine Profit/hr
3
Enter the average profitability of the machine. Industry average is $400/hr. Default is $400/hr

Machine Cost
4
If the operating cost of the machine is not know, use the "machine cost calculator".

Machine cost calculator

Enter the machine value when new, and the program will give an estimated machine operating cost.

Operator Cost
5
Enter the cost of the operator. Industry average, including benefits is $25/hr. Default is $25/hr.

Scrap/Returns Cost
6
This is the cost each year of returns and scrap due to rejects and dirty product.

Enter what the reject and scrap costs can be reduced by with cleaning.

Average Downtime
7
Enter the average amount of downtime each day associated with cleaning your machine,

material, or facility.

Cleaning Costs
8
An estimated cost of cleaning and the associated loss of production are then calculated.

Production Losses

System Cost
9
Enter the cost of the Simco cleaning system.

Installation
10
Enter the cost of installation. If installation is included, enter 0.

Filters and brushes
11
Operating costs include replacement filters and brushes. Default cost is $1500/yr.

Energy cost
12
This is the average cost to operate the cleaner. At $0.05/kWh, cost is $400/yr. Default is $400/yr.

Depreciation
13
Financial data like depreciation is typically used in the accounting department. Default is 5 years.

Interest
14
Interest, or the cost of money, will vary. Default is 10%.

Payback Period
15
Your ROI and Payback Period is now calculated.

Return-on-Investment

Click on the ROI Calculation Sheet for the ROI Calculator

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet calc instructions instruction page to calculate your return on investment roi please follow these steps print this and the step operating time enter number of hours machine operates per day work daysyear days year for example a week weeks profithr average profitability industry is hr default cost if not know use quot calculator value when new program will give an estimated operator including benefits scrapreturns each returns scrap due rejects dirty product what reject costs can be reduced by with cleaning downtime amount associated material or facility loss production are then calculated losses system simco installation included filters brushes include replacement yr energy operate cleaner at kwh depreciation financial data like typically used in accounting department years interest money vary payback period now returnoninvestment click calculation...

Related files

Share

Help

Instruction Page
	To Calculate your Return on Investment (R.O.I.), please follow these steps:
		Print this page and follow the instructions
	Step #
Operating Time	1	Enter the number of hours the machine operates per day.

Work days/year	2	Enter the operating days per year. For example 5 days a week for 50 weeks per year, enter 250.

Machine Profit/hr	3	Enter the average profitability of the machine. Industry average is $400/hr. Default is $400/hr

Machine Cost	4	If the operating cost of the machine is not know, use the "machine cost calculator".
Machine cost calculator		Enter the machine value when new, and the program will give an estimated machine operating cost.

Operator Cost	5	Enter the cost of the operator. Industry average, including benefits is $25/hr. Default is $25/hr.

Scrap/Returns Cost	6	This is the cost each year of returns and scrap due to rejects and dirty product.
		Enter what the reject and scrap costs can be reduced by with cleaning.

Average Downtime	7	Enter the average amount of downtime each day associated with cleaning your machine,
		material, or facility.

Cleaning Costs	8	An estimated cost of cleaning and the associated loss of production are then calculated.
Production Losses

System Cost	9	Enter the cost of the Simco cleaning system.

Installation	10	Enter the cost of installation. If installation is included, enter 0.

Filters and brushes	11	Operating costs include replacement filters and brushes. Default cost is $1500/yr.

Energy cost	12	This is the average cost to operate the cleaner. At $0.05/kWh, cost is $400/yr. Default is $400/yr.

Depreciation	13	Financial data like depreciation is typically used in the accounting department. Default is 5 years.

Interest	14	Interest, or the cost of money, will vary. Default is 10%.

Payback Period	15	Your ROI and Payback Period is now calculated.
Return-on-Investment

Click on the ROI Calculation Sheet for the ROI Calculator

Related files

Share

Share to social media

Help

Login Area