accounting information system
youyousansan
roi_analysis_template.xlsxCopyright
This spreadsheet solution relates to the case San Francisco International Airport and Quantum Secure’s SAFE for Aviation System, Case #KEL720. ©2013 by the Kellogg School of Management at Northwestern University. This case was developed with support from the December 2009 graduates of the Executive MBA Program (EMP-76). This case was prepared by Evan Meagher ’09 under the supervision of Professor Daniel Diermeier. Cases are developed solely as the basis for class discussion. Cases are not intended to serve as endorsements, sources of primary data, or illustrations of effective or ineffective management. To order copies or request permission to reproduce materials, call 800-545-7685 (or 617-783-7600 outside the United States or Canada) or e-mail [email protected]. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of Kellogg Case Publishing.
ROI Analysis Templ_not_checked
| Discount Rate | ||||||
| Year | ||||||
| 0 | 1 | 2 | 3 | 4 | 5 | |
| 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | |
| Purchase Cost | ||||||
| On-Boarding Labor Costs | ||||||
| Current Time Cost (labor hours) | ||||||
| New Time Cost (labor hours) | ||||||
| Savings (labor hours) | 0.00 | |||||
| Hourly cost of labor hour | ||||||
| Dollar Savings per user | $0.00 | |||||
| Users | ||||||
| Dollar Savings from On-boarding | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Badge Processing Costs | ||||||
| Toronto ID Processing Cost Reduction (%) | ||||||
| SFO Current Badge Processing Cost | ||||||
| SFO Savings Per Badge Processed | $0.00 | |||||
| Users with new badges processed | ||||||
| SFO Savings on Badge Processing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Ongoing Identity Management Activity Costs | ||||||
| Reduction in Labor Time Spent on Identity Management | ||||||
| Hourly cost of labor | ||||||
| Hours spent annually per user on Identity Management | ||||||
| Dollar Savings per user | $0.00 | |||||
| Users | ||||||
| Dollar Savings from Ongonig Identity Management Activity Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Material Costs Savings | ||||||
| Cost of new badges | ||||||
| New badge purchases avoided through purchase of SAFE | ||||||
| Total cost savings from reduced new badge purchases | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Incremental badges made unnecessary | ||||||
| Percentage of badges lost each year | ||||||
| Badge losses avoided | - 0 | - 0 | - 0 | - 0 | 0 | |
| Cost of lost badge | ||||||
| Lost badge savings | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Record-Keeping Accuracy Savings | ||||||
| Labor Hours spent each month on error detection | ||||||
| Hourly cost of labor hour | ||||||
| Reduction in labor hours spent on detection | ||||||
| Savings in monthly labor hours | 0 | |||||
| Annual labor hour savings | 0 | 0 | 0 | 0 | 0 | |
| Value of labor savings | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Increased Compliance Savings | ||||||
| Likelihood of a compliance violation without SAFE | ||||||
| Likelihood of a compliance violation with SAFE | ||||||
| Change in likelihood of a compliance violation | 0% | |||||
| Cost of a compliance valuation | ||||||
| Value of compliance savings | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Compatibility Cost Savings | ||||||
| Savings from avoiding rip-and-replace implementation | ||||||
| Total Cash Outflows for Purchase | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Savings from Purchase | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Net Cash Flow from Purchase | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Discounted Cash Flow from purchase | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IRR from Purchase | N/A | |||||
| NPV of Purchase | $ - 0 |
