Detail
Sheets
Complex Lisp
Routine
|
Problem: |
Create a typical sheet of details for a project. Each project would have 4 sheets typically or more. Each sheet would have 15 (average) details. Quantity of Projects per year are 100 to 120. There are 22 different typical detail sheets to pick from. Each detail sheet needs to be created in 24x36, 30x42 and 36x42 size sheets. The same details are used on a variety of different detail sheets. Would like to have one location to maintain details as they can change at any time. |
|
Solution: |
Create a
routine that will create any detail sheet required at the size required for
the project. |
|
Development Cost |
|
|
$85.00
|
Hourly
Rate for Development Time |
|
150 hrs |
Total Time
to Develop Routine |
|
$12,750 |
Total Cost
for Developing Routine |
|
Ideal Time |
Run Times |
Real World |
|
75 min |
Time to
Complete Task Manually |
100 min |
|
10 min |
Time to
Run Custom Routine |
20 min |
|
65 min |
Time Saved
by Using Custom Routine |
80 min |
|
Ideal Time |
Pay Back |
Real World |
|
$60.00 |
Hourly
Billing Rate of Users |
$60.00 |
|
420 |
Quantity
Used Yearly* |
420 |
|
455 hrs |
Time Saved
Per Year |
560 hrs |
|
$27,300 |
Annual
Dollars Saved |
$33,600 |
|
5.6 month(s) |
Payback
Time Frame |
4.6 month(s) |
|
114% |
One Year
Return on Investment |
164% |
|
87% |
Productivity Increase |
80% |
|
* This is based on the Users request and there estimate of how much they would be using it in a year. The usage of our ROI function to verify the usage of this routine was not possible. |