Management

CAD ROI Worksheet

10 Mar, 2010 By: Robert Green

CAD Manager's Toolbox: Delight upper management by organizing your cost-saving ideas with this spreadsheet analysis tool.


Over the years, I've found that being able to produce a return on investment (ROI) analysis for my CAD management projects helps me get projects funded with greater success than any other tool or tactic. The premise is pretty simple: Demonstrate that a project yields savings that are greater than its costs, and a positive return is the result.

To help you perform your analysis, I've posted a slightly edited version of the spreadsheet analysis tool I use on my web site for your use. You can download the spreadsheet, then follow along as I walk through the simple process below.

Simply enter a cost-saving idea into column A, then add in the time savings and labor rate for the person whose time you're saving into columns B and C, respectively. Finally, enter in the costs of implementing your idea in column E and the entire savings, ROI, and payback period will appear as a result.

You still have to collect the data on time savings and costs (sorry, I can't automate that process for you), but you'll have a nice log sheet to document your ideas, and your management teams will love to see it.

 

 

Do you have a helpful tip or item for the CAD Manager's Newsletter? Send it to me at rgreen@cad-manager.com. If I use your tip in the newsletter you'll receive a cool Cadalyst prize!


About the Author: Robert Green

Robert Green

Add comment

Note: Comments are moderated and will appear live after approval by the site moderator.

AutoCAD Tips!

Lynn Allen

Autodesk Technical Evangelist Lynn Allen guides you through a different AutoCAD feature in every edition of her popular "Circles and Lines" tutorial series. For even more AutoCAD how-to, check out Lynn's quick tips in the Cadalyst Video Gallery. Subscribe to Cadalyst's free Tips & Tools Weekly e-newsletter and we'll notify you every time a new video tip is published. All exclusively from Cadalyst!
Follow Lynn on Twitter Follow Lynn on Twitter


Poll
Which file format do you use most often for CAD drawing/model exchange?
Native format
PDF
3D PDF
DWF
STEP or IGES
JT
IFC
Other
Submit Vote