|
Under
Construction
Project Estimator/Justification Spread Sheet in Excel®
Project Cost Estimator/Justification is a
downloadable Excel® spreadsheet designed to
create a cost per record/image of specific backfile or current
projects. With this cost information, justification parameters can
be implemented for payback and ROI on the system.
It features
user defined areas such as shift cost, time functions for various procedures including
indexing and scanning, and determines a per record/image cost based on daily, monthly or
yearly activity. It also estimates the number of production and management personnel for
each project, the size of the compressed image database and total cost of various
production activities.
You must have Excel 5.0 or higher or a
spreadsheet program capable of converting Excel files to use this
program. See below for downloading instructions.
Instructions: MS
Internet Explorer/Netscape - right
mouse click HERE and save the file to your hard drive. File
size is 63k.You must have Excel 5.0 or higher or a spreadsheet capable of converting Excel.
The project cost sheet has several
defaults entered (where you see
ENT)
Number
of files/records to process |
10,000
|
Average
Pages per file |
1 |
Length
of each shift - hours |
7.00 |
Prep
+ deprep time per page for scanning - seconds |
4.00 |
Rate
per shift - $$$ - Loaded |
100 |
Pg
scanned per minute |
100 |
Length
of each shift - hours |
7.00 |
Key
Rejects and/or QA (percent) |
5.0% |
Time
to key one reject file - seconds |
20 |
Characters
per page |
10 |
Number
of char per shift per operator-KEY |
65,000 |
Equipment/SW
Cost - TOTAL |
50,000
|
Straight
Depreciation - Years |
5 |
Physical
Overhead -Space - Month |
1,000
|
Change the above defaults on the downloaded
spreadsheet for your specific project and save the completed Excel file under a different
name. Please call 1-904-439-0360 if we can answer any questions!
|
