{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home","Overview","Financial Details"],"not_rendered":{"charts":6,"images":10,"macros":1,"external_links":1,"defined_names":196,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,2,37,14],[23,12,25,13],[8,11,13,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"The Total Economic Impact™       of Microsoft                           Application Virtualization (App-V)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Learn more about Forrester's TEI methodology"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Use these links to obtain your copy of the Forrester case study, The Total Economic Impactt™ of Microsoft Application Virtualization (App-V) and the Business Insights Webcast:"]
[]
[null,null,null,null,null,null,null,null,"Forrester case study"]
[]
[null,null,null,null,null,null,null,null,"Webcast: Application Virtualization (App-V)"]

{"sheet":"Overview","index":1,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,2,72,16],[7,2,9,16],[13,2,15,16],[19,2,23,16],[27,2,27,3],[27,5,27,16],[29,5,31,16],[30,2,30,3],[33,2,33,3],[33,5,33,13],[37,2,44,16],[48,2,55,16],[59,2,66,16]]}
[]
[null,"Interactive Model of The Total Economic Impact™ Of Microsoft Application Virtualization (App-V) "]
[]
[]
[]
[null,null,"Executive summary:"]
[]
[null,null,"In March 2010, Microsoft commissioned Forrester Consulting to examine the total economic impact and potential return on investment (ROI) that enterprises may expect to realize by deploying Microsoft App-V, part of the Microsoft Desktop Optimization Pack (MDOP) suite of desktop and infrastructure management tools. To understand the financial impact of investing in MDOP and deploying App-V, Forrester conducted in-depth interviews with five Microsoft customers that have extensive experience with the product and compiled their results and forward-looking expectations into a case study based on a composite organization that encompasses the characteristics of the companies interviewed in the study. "]
[]
[]
[]
[null,null,"Purpose:"]
[]
[null,null,"The purpose of the study and this companion ROI calculator is to provide readers with a framework to evaluate the potential financial impact of Microsoft App-V on their organizations. Forrester’s aim is to clearly show all calculations and assumptions used in the analysis. Readers should use this study to better understand and communicate a business case for deploying Microsoft App-V, part of the MDOP dynamic desktop tool suite."]
[]
[]
[]
[null,null,"TEI methodology: "]
[]
[null,null,"TEI not only measures costs and cost reduction (areas that are typically accounted for within IT) but also weighs the enabling value of a technology in increasing the effectiveness of overall business processes. For this study, Forrester employed four fundamental elements of TEI in modeling the financial impact of producing a TEI study: 1) cost and cost reduction, 2) benefits to the entire organization, 3) risk, and 4) flexibility.  Forrester’s TEI methodology provides a complete picture of the total economic impact of technology investment decisions. Please see \"The Total Economic Impact™ Of Microsoft Application Virtualization (App-V) for additional information on the TEI methodology."]
[]
[]
[]
[]
[]
[null,null,"Keys:"]
[]
[null,null,null,null,null,"Orange boxes are User Inputs. "]
[]
[null,null,null,null,null,"Green boxes are Default Values provided by Forrester Consulting. Forrester applied industry research to knowledge of the vendor solution in order to derive the default values."]
[]
[]
[]
[null,null,null,null,null,"Blue boxes are Calculated Values and are not changeable. "]
[]
[null,null,"Approach:"]
[]
[null,null,"Forrester used a five-step approach for this study:\n1. Forrester gathered data from existing Forrester research relative to Microsoft and the application virtualization platforms market in general.\n2. Forrester interviewed Microsoft marketing and sales personnel to fully understand the value proposition of Microsoft App-V.\n3. Forrester conducted a series of in-depth interviews with 5 enterprise customers currently using Microsoft solutions. \n4. Forrester constructed a financial model representative of the interviews. This model can be found in the TEI Framework section below.\n5. Forrester created a composite organization based on the interviews and populated the financial framework using data from the interviews."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disclosure:"]
[]
[null,null,"The user should be aware of the following: \n1. The study was commissioned by Microsoft and delivered by the Forrester Consulting group.\n2. Microsoft reviewed and provided feedback to Forrester, but Forrester maintains editorial control over the study.\n3. The customer names for the interviews were provided by Microsoft, but interviews were conducted solely between Forrester and the customers.\n4. Forrester makes no assumptions as to the potential return on investment that other organizations will receive. Forrester strongly advises that readers should use their own estimates within the framework provided to determine the value of an investment in Microsoft MDOP and  deployment of App-V.\n5. This study is not meant to be used as a competitive product analysis."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disclaimer: "]
[]
[null,null,"This tool was developed for use as a Microsoft Excel 2003/2007 workbook operating on a Microsoft Windows XP platform. Although great care has been taken to ensure the accuracy and completeness of this model, Microsoft and Forrester Research are unable to accept any legal responsibility for any actions taken on the basis of the information contained herein. The tool is provided ‘AS IS,’ and Forrester and Microsoft make no warranties of any kind. Use, disclosure, or reproduction is prohibited without the prior express written permission of Microsoft Forrester Consulting developed this commissioned business case model in March 2010 exclusively for Microsoft. Microsoft is not permitted to change the calculations or equations. Forrester believes that this analysis is representative of what companies may achieve by deploying App-V. The information and results in this document are only an estimate of potential costs and savings. Actual results will vary and may be affected by individual human factors/interactions, implementation of alternate processes and procedures or unanticipated events. Forrester does not endorse Microsoft nor its offerings."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Forrester Copyright:"]
[]
[null,null,"© 2010, Forrester Research, Inc. All rights reserved. Unauthorized reproduction is strictly prohibited. Information is based on best available resources. Opinions reflect judgment at the time and are subject to change. Forrester®, Technographics®, Forrester Wave, RoleView, TechRadar, and Total Economic Impact are trademarks of Forrester Research, Inc. All other trademarks are the property of their respective companies. For additional information, go to www.forrester.com."]

{"sheet":"Financial Details","index":2,"n_rows":365,"n_cols":38,"rows_kept":365,"cut":false,"hidden":false,"merged":[[91,2,92,11],[9,4,11,9],[12,4,14,9],[15,4,17,9],[44,5,44,11],[45,5,45,11],[46,5,46,11],[47,5,47,11],[56,6,56,7],[55,2,55,3],[58,2,58,3],[21,2,21,10],[55,4,55,5],[56,4,56,5],[57,4,57,5],[360,2,361,11],[357,2,358,11],[352,2,353,11],[342,2,343,11],[337,2,340,11],[99,3,99,4],[97,3,97,4],[153,2,153,9],[166,2,166,9],[227,2,227,9],[112,3,112,4],[121,3,121,4],[122,3,122,4],[116,3,116,4],[117,3,117,4],[164,2,164,9],[151,2,151,9],[177,2,177,9],[192,2,192,9],[206,2,206,9],[225,2,225,9],[95,3,95,4],[39,5,39,11],[40,5,40,11],[41,5,41,11],[42,5,42,11],[43,5,43,11],[60,2,60,3],[57,6,57,7],[60,6,60,7],[57,2,57,3],[58,6,58,7],[59,6,59,7],[55,6,55,7],[56,2,56,3],[59,2,59,3],[94,3,94,4],[179,2,179,9],[194,2,194,9],[114,3,114,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[126,3,126,4],[125,3,125,4],[291,2,291,10],[304,2,304,10],[318,2,318,10],[208,2,208,9],[250,3,250,4],[249,3,249,4],[246,3,246,4],[247,3,247,4],[248,3,248,4],[244,3,244,4],[278,2,278,10],[289,2,289,10],[302,2,302,10],[316,2,316,10],[58,4,58,5],[59,4,59,5],[60,4,60,5],[65,8,75,11],[99,30,99,31],[76,8,78,11],[80,8,80,11],[81,8,81,11],[82,8,82,11],[83,8,83,11],[55,9,58,9],[94,30,94,31],[95,30,95,31],[96,30,96,31],[97,30,97,31],[96,3,96,4]]}
[]
[null,"Interactive Model of The Total Economic Impact™ Of Microsoft Application Virtualization (App-V)"]
[]
[null,"CONTENTS",null,null,"KEY"]
[]
[]
[]
[]
[]
[null,null,null,"Key","Orange boxes are designated user input cells. Override these values with values that pertain to your organization in order to customize the financial value. "]
[null,null,null,"Financial Summary"]
[null,null,null,"General Inputs"]
[null,null,null,"Benefits","Green boxes are Default Values provided by Forrester Consulting. Forrester applied industry research to knowledge of the vendor solution in order to derive the default values. "]
[null,null,null,"Costs"]
[null,null,null,"Disclaimers"]
[null,null,null,"More Information","Blue boxes are Calculated Values and are not changeable. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"GENERAL INPUTS",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[null,null,null,"Enter your company data here:"]
[null,null,null,"Number of seats (MDOP)",10000,"Typically, the number of information workers in the organization."]
[null,null,null,"Number of servers for App-V Admin",3,"This number will range from 6 to 0.  If App-V is integrated with existing software systems, or if servers are re-purposed, then this hardware cost would likely be lower -- and potentially even zero."]
[null,null,null,"Hourly compensation per FTE (App-V implementation. PC refresh tasks)",50,"Hourly rate INCLUDING benefits."]
[null,null,null,"Number of IT staff receiving App-V training",4,"The number of employees who will attend vendor- or partner-provided courses for learning the ongoing operation of App-V."]
[null,null,null,"Number of FTEs to be reassigned from application management tasks",2.5,"This amount of labor typically ranges from 1 to 2  FTEs  per 100 applications in the enterprise (depending on application complexity, age, dependencies and degree of customization) OR  2 to 4  FTEs per 10,000 seats. "]
[null,null,null,"Annual compensation for reassigned FTEs (application management)",100000,"A starting point for estimating this amount of labor is 1.0 FTE per 25 to 50 applications in a terminal services environment, depending on workload predictability, size of applications, level of application complexity, degree of customization, and type of iWorkers accessing applications (e.g. mobile, office, task, etc.)."]
[null,null,null,"Number of FTEs to be reassigned from terminal services application / server tasks",0.75,"Only applicable in connection with App-V for RDS."]
[null,null,null,"Number of servers removed from terminal services",30,"When estimating the number of servers that can be made redundant with the implementation of App-V for terminal services, consider the frequency of patches / updates required, the number of incompatibilities with co-resident applications, bandwidth latency and network connectivity, and the type of iWorkers accessing applications (mobile, office, task)."]
[null,null,null,"Servers re-purposed for App-V",20,"This number is roughly the number of branch or satellite locations from which App-V will house application for streaming to local users."]
[null,null,null,null,"Year 1","Year 2","Year 3"]
[null,null,null,"Number of new PCs to be deployed",1500,3000,3000,"Enter the number of new PCs to be provisioned and provided to to users each year."]
[]
[null,"FINANCIAL SUMMARY",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[]
[null,null,"Summary Financial Results",null,"Original Calculation",null,"Risk-Adjusted Calculation",null,null,"Learn about risk adjustments"]
[null,null,"ROI ",null,{"$f":"AL100","v":4.5491338830705512},null,{"$f":"$K$100","v":3.6309554543579465}]
[null,null,"Payback period (months)","Payback period (months)",{"$f":"AL101","v":2.0785321100917429},null,{"$f":"$K$101","v":2.695716664816254}]
[null,null,"Total costs (PV)",null,{"$f":"AL96","v":-307685.19909842219},null,{"$f":"$K$96","v":-311915.19909842219}]
[null,null,"Total benefits (PV)",null,{"$f":"AL97","v":1707386.3636363633},null,{"$f":"$K$97","v":1444465.3925619831}]
[null,null,"Total (NPV)",null,{"$f":"AL98","v":1399701.1645379411},null,{"$f":"$K$98","v":1132550.1934635609}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"In March 2010, Microsoft commissioned Forrester Consulting to examine the total economic impact and potential return on investment (ROI) that enterprises may expect to realize by deploying Microsoft App-V, part of the Microsoft Desktop Optimization Pack (MDOP) suite of desktop and infrastructure management tools. To understand the financial impact of investing in MDOP and deploying App-V, Forrester conducted in-depth interviews with Microsoft customers that have extensive experience with the product and compiled their results and forward-looking expectations into a case study, The Total Economic Impact of Microsoft Application Virtualization (App-V)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"In conducting the interviews with Microsoft customers, Forrester found that organizations can achieve significant and quantifiable benefits from App-V in terms of:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"1.  Labor cost savings associated with software and infrastructure management"]
[null,null,null,null,null,null,null,null,"2.  Hardware cost and footprint reductions"]
[null,null,null,null,null,null,null,null,"3.  Reduced help desk workloads"]
[null,null,null,null,null,null,null,null,"4.  Enhanced user productivity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Summary",null,"Initial","Year 1","Year 2","Year 3","Total","Present Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary",null,"Initial","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,null,"Total Costs",null,{"$f":"F251","v":-63230},{"$f":"G251","v":-100000},-100000,-100000,{"$f":"SUM(F96:I96)","v":-363230},{"$f":"F96+NPV($F$103,G96:I96)","v":-311915.19909842219},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Costs",null,{"$f":"F298+F312+F325","v":-59000},{"$f":"G285+G298+G312+G325","v":-100000},{"$f":"H285+H298+H312+H325","v":-100000},{"$f":"I285+I298+I312+I325","v":-100000},{"$f":"J285+J298+J312+J325","v":-359000},{"$f":"K285+K298+K312+K325","v":-307685.19909842219}]
[null,null,null,"Total Benefits",null,null,{"$f":"G123","v":381468.75},646312.5,750062.5,{"$f":"SUM(G97:I97)","v":1777843.75},{"$f":"NPV($F$103,G97:I97)","v":1444465.3925619831},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Benefits",null,null,{"$f":"F160+F173+F188+F202+F221+F234","v":440625},{"$f":"G160+G173+G188+G202+G221+G234","v":768750},{"$f":"H160+H173+H188+H202+H221+H234","v":893750},{"$f":"I160+I173+I188+I202+I221+I234","v":2103125},{"$f":"J160+J173+J188+J202+J221+J234","v":1707386.3636363633}]
[null,null,null,"Total (Risk-Adjusted)",null,{"$f":"F97+F96","v":-63230},281468.75,546312.5,650062.5,1414613.75,1132550.1934635609,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Original)",null,{"$f":"AG97+AG96","v":-59000},340625,668750,793750,1744125,1399701.1645379411]
[null,null,null,"Running Total (Risk-Adjusted)",null,{"$f":"SUM(F98:F98)","v":-63230},{"$f":"SUM(F98:G98)","v":218238.75},{"$f":"SUM(F98:H98)","v":764551.25},{"$f":"SUM(F98:I98)","v":1414613.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Running Total (Orig)",null,{"$f":"SUM(AG98:AG98)","v":-59000},{"$f":"SUM(AG98:AH98)","v":281625},{"$f":"SUM(AG98:AI98)","v":950375},{"$f":"SUM(AG98:AJ98)","v":1744125}]
[null,null,null,"ROI",null,null,null,null,null,null,{"$f":"K98/ABS(K96)","v":3.6309554543579465},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROI",null,null,null,null,null,null,{"$f":"AL98/ABS(AL96)","v":4.5491338830705512}]
[null,null,null,"Payback Period (months)",null,null,{"$f":"IF(AND(G99>=0,F99<0,MIN(H99:$J99)>=0),(ABS(F99)/G98)*12,0)","v":2.695716664816254},{"$f":"IF(AND(H99>=0,G99<0,SUM($G101:G101)=0,MIN(I99:$J99)>=0),((COLUMN()-COLUMN($G101))+ABS(G99)/H98)*12,0)","v":0},{"$f":"IF(AND(I99>=0,H99<0,SUM($G101:H101)=0,MIN(J99:$J99)>=0),((COLUMN()-COLUMN($G101))+ABS(H99)/I98)*12,0)","v":0},null,{"$f":"IF(MIN(F99:I99)>=0,0,IF(MAX(G101:I101)>0,MAX(G101:I101),\"> \"&((COLUMN()-COLUMN($G101)-1)*12)))","v":2.695716664816254},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payback Period (months)",null,null,{"$f":"IF(AND(AH99>=0,AG99<0,MIN(AI99:$AK99)>=0),(ABS(AG99)/AH98)*12,0)","v":2.0785321100917429},{"$f":"IF(AND(AI99>=0,AH99<0,SUM($AH101:AH101)=0,MIN(AJ99:$AK99)>=0),((COLUMN()-COLUMN($AH101))+ABS(AH99)/AI98)*12,0)","v":0},{"$f":"IF(AND(AJ99>=0,AI99<0,SUM($AH101:AI101)=0,MIN($AK99:AK99)>=0),((COLUMN()-COLUMN($AH101))+ABS(AI99)/AJ98)*12,0)","v":0},null,{"$f":"IF(MIN(AG99:AJ99)>=0,0,IF(MAX(AH101:AJ101)>0,MAX(AH101:AJ101),\"> \"&((COLUMN()-COLUMN($G101)-1)*12)))","v":2.0785321100917429}]
[]
[null,null,null,"Financial discount rate",null,0.1]
[]
[]
[]
[]
[]
[]
[null,"TOTAL BENEFITS",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[]
[]
[null,null,null,"Total Benefits",null,"Initial","Year 1","Year 2","Year 3","Total","Present Value"]
[]
[null,null,null,{"$f":"$C$152","v":"Labor savings - application packaging, testing, deployment"},null,null,{"$f":"F161","v":103750},{"$f":"G161","v":207500},207500,{"$f":"SUM(F117:I117)","v":518750},{"$f":"F117+NPV($F$103,G117:I117)","v":421703.60631104431}]
[null,null,null,{"$f":"C165","v":"Labor cost savings: App-V for RDS"},null,null,{"$f":"F174","v":70500},{"$f":"G174","v":70500},70500,211500,175323.06536438764]
[null,null,null,{"$f":"C178","v":"Server consolidation - hardware cost avoidance"},null,null,{"$f":"F189","v":49000},{"$f":"G189","v":0},0,49000,44545.454545454544]
[null,null,null,{"$f":"C193","v":"Labor savings - PC refresh cycle"},null,null,{"$f":"F203","v":93375},{"$f":"G203","v":186750},186750,466875,379533.24567993981]
[null,null,null,{"$f":"C207","v":"Labor cost savings - Helpdesk"},null,null,{"$f":"F222","v":25937.5},{"$f":"G222","v":72625},114125,212687.5,169344.00826446275]
[null,null,null,{"$f":"C226","v":"End-user productivity"},null,null,{"$f":"F235","v":38906.25},{"$f":"G235","v":108937.5},171187.5,319031.25,254016.01239669416]
[null,null,null,"Total (Risk-Adjusted)",null,null,{"$f":"SUM(G116:G122)","v":381468.75},{"$f":"SUM(H116:H122)","v":646312.5},{"$f":"SUM(I116:I122)","v":750062.5},{"$f":"SUM(J116:J122)","v":1777843.75},{"$f":"SUM(K116:K122)","v":1444465.3925619833}]
[null,null,null,null,null,null,null,null,null,null,null,"d"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Labor savings - application packaging, testing, deployment"]
[]
[null,null,"Time saved from delivering application updates or hotfixes, including changes to existing apps on terminal services and new applications deployed to the desktops"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 2","Year 3","Total","Present Value"]
[null,null,"E1",{"$f":"+$D$44","v":"Number of FTEs to be reassigned from application management tasks"},null,{"$f":"$E$44","v":2.5}]
[null,null,"E2",{"$f":"+$D$45","v":"Annual compensation for reassigned FTEs (application management)"},null,{"$f":"$E$45","v":100000}]
[null,null,"Et","Labor savings - application packaging, testing, deployment","E1 * E2",{"$f":"F157*F158","v":250000}]
[null,null,"Eto","Total (Original)",null,{"$f":"$F$159*0.5","v":125000},{"$f":"$F$159","v":250000},{"$f":"$F$159","v":250000},{"$f":"SUM(F160:H160)","v":625000},{"$f":"NPV($F$103,F160:H160)","v":508076.63410969189}]
[null,null,"Etr","Total (Risk Adjusted)",null,{"$f":"$F$160*ROUND(AVERAGE(0.5,1,1),2)","v":103750},{"$f":"$G$160*ROUND(AVERAGE(0.5,1,1),2)","v":207500},{"$f":"$H$160*ROUND(AVERAGE(0.5,1,1),2)","v":207500},{"$f":"SUM(F161:H161)","v":518750},{"$f":"NPV($F$103,F161:H161)","v":421703.60631104431}]
[]
[]
[]
[null,null,"Labor cost savings: App-V for RDS"]
[]
[null,null,"Labor savings for App-V for RDS Terminal services) only"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 2","Year 3","Total","Present Value"]
[null,null,"F1",{"$f":"$D$46","v":"Number of FTEs to be reassigned from terminal services application / server tasks"},null,{"$f":"$E$46","v":0.75}]
[null,null,"F2",{"$f":"$D$45","v":"Annual compensation for reassigned FTEs (application management)"},null,{"$f":"$E$45","v":100000}]
[null,null,"Ft","Labor cost savings: App-V for RDS","F1 * F2",{"$f":"F170*F171","v":75000}]
[null,null,"Fto","Total (Original)",null,{"$f":"$F$172","v":75000},{"$f":"$F$172","v":75000},{"$f":"$F$172","v":75000},{"$f":"SUM(F173:H173)","v":225000},{"$f":"NPV($F$103,F173:H173)","v":186513.89932381664}]
[null,null,"Ftr","Total (Risk Adjusted)",null,{"$f":"$F$173*ROUND(AVERAGE(0.8,1,1.03),2)","v":70500},{"$f":"$G$173*ROUND(AVERAGE(0.8,1,1.03),2)","v":70500},{"$f":"$H$173*ROUND(AVERAGE(0.8,1,1.03),2)","v":70500},{"$f":"SUM(F174:H174)","v":211500},{"$f":"NPV($F$103,F174:H174)","v":175323.06536438764}]
[]
[]
[]
[null,null,"Server consolidation - hardware cost avoidance"]
[]
[null,null,"Smaller hardware footprint resulting from eliminating application conflicts and need for redundancy"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 2","Year 3","Total","Present Value"]
[null,null,"G1",{"$f":"$D$47","v":"Number of servers removed from terminal services"},null,{"$f":"$E$47","v":30}]
[null,null,"G2",{"$f":"$D$48","v":"Servers re-purposed for App-V"},null,{"$f":"$E$48","v":20}]
[null,null,"G3","Number of servers removed (net)","G1-G2",{"$f":"F183-F184","v":10}]
[null,null,"G4","Cost per server",null,5000]
[null,null,"Gt","Server consolidation - hardware cost avoidance","G3 * G4",{"$f":"F185*F186","v":50000}]
[null,null,"Gto","Total (Original)",null,{"$f":"$F$187","v":50000},{"$f":"$F$187*0","v":0},{"$f":"$F$187*0","v":0},{"$f":"SUM(F188:H188)","v":50000},{"$f":"NPV($F$103,F188:H188)","v":45454.545454545449}]
[null,null,"Gtr","Total (Risk Adjusted)",null,{"$f":"$F$188*ROUND(AVERAGE(0.9,1,1.05),2)","v":49000},{"$f":"$G$188*ROUND(AVERAGE(0.9,1,1.05),2)","v":0},{"$f":"$H$188*ROUND(AVERAGE(0.9,1,1.05),2)","v":0},{"$f":"SUM(F189:H189)","v":49000},{"$f":"NPV($F$103,F189:H189)","v":44545.454545454544}]
[]
[]
[]
[null,null,"Labor savings - PC refresh cycle"]
[]
[null,null,"Time savings from deployment  / provisioning:  regression testing, compatibility testing"]
[]
[null,null,"Ref.","Metric","Calculation","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"H1",{"$f":"$D$50","v":"Number of new PCs to be deployed"},null,{"$f":"$E$50","v":1500},{"$f":"$F$50","v":3000},{"$f":"$G$50","v":3000}]
[null,null,"H2","Hours saved per machine on new software installation, image management",null,1.5]
[null,null,"H3",{"$f":"$D$42","v":"Hourly compensation per FTE (App-V implementation. PC refresh tasks)"},null,{"$f":"$E$42","v":50}]
[null,null,"Ht","Labor savings - PC refresh cycle","H1 x H2 x H3",{"$f":"F198*$F$199*$F$200","v":112500},{"$f":"G198*$F$199*$F$200","v":225000},{"$f":"H198*$F$199*$F$200","v":225000}]
[null,null,"Hto","Total (Original)",null,{"$f":"$F$201","v":112500},{"$f":"$G$201","v":225000},{"$f":"$H$201","v":225000},{"$f":"SUM(F202:H202)","v":562500},{"$f":"NPV($F$103,F202:H202)","v":457268.9706987227}]
[null,null,"Htr","Total (Risk Adjusted)",null,{"$f":"$F$202*ROUND(AVERAGE(0.5,1,1),2)","v":93375},{"$f":"$G$202*ROUND(AVERAGE(0.5,1,1),2)","v":186750},{"$f":"$H$202*ROUND(AVERAGE(0.5,1,1),2)","v":186750},{"$f":"SUM(F203:H203)","v":466875},{"$f":"NPV($F$103,F203:H203)","v":379533.24567993981}]
[]
[]
[]
[null,null,"Labor cost savings - Helpdesk"]
[]
[null,null,"Fewer and shorter calls by eliminating conflicts and a more stable computing environment"]
[]
[null,null,"Ref.","Metric","Calculation","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"J1",{"$f":"+$D$50","v":"Number of new PCs to be deployed"},"Refresh cycle",{"$f":"$E$50","v":1500},{"$f":"$F$50","v":3000},{"$f":"$G$50","v":3000}]
[null,null,"J2","Shorter call duration (min)",null,10]
[null,null,"J3","Number of calls","1.0 per new PC",{"$f":"F212*1","v":1500},{"$f":"G212*1","v":3000},{"$f":"H212*1","v":3000}]
[null,null,"J4","Hours ",null,{"$f":"F214*($F$213/60)","v":250},{"$f":"G214*($F$213/60)","v":500},{"$f":"H214*($F$213/60)","v":500}]
[null,null,"J5","Calls avoided","2 per PC",{"$f":"F212*2","v":3000},{"$f":"(F212+G212)*2","v":9000},{"$f":"(F212+G212+H212)*2","v":15000}]
[null,null,"J6","Duration (min)",null,20]
[null,null,"J7","Hours ",null,{"$f":"F216*($F$217/60)","v":1000},{"$f":"G216*($F$217/60)","v":3000},{"$f":"H216*($F$217/60)","v":5000}]
[null,null,"J8","Cost per hour",null,25]
[null,null,"Jt","Labor cost savings - Helpdesk","(J4 + J7) * J8",{"$f":"(F215+F218)*$F$219","v":31250},{"$f":"(G215+G218)*$F$219","v":87500},{"$f":"(H215+H218)*$F$219","v":137500}]
[null,null,"Jto","Total (Original)",null,{"$f":"$F$220","v":31250},{"$f":"$G$220","v":87500},{"$f":"$H$220","v":137500},{"$f":"SUM(F221:H221)","v":256250},{"$f":"NPV($F$103,F221:H221)","v":204028.92561983468}]
[null,null,"Jtr","Total (Risk Adjusted)",null,{"$f":"$F$221*ROUND(AVERAGE(0.5,1,1),2)","v":25937.5},{"$f":"$G$221*ROUND(AVERAGE(0.5,1,1),2)","v":72625},{"$f":"$H$221*ROUND(AVERAGE(0.5,1,1),2)","v":114125},{"$f":"SUM(F222:H222)","v":212687.5},{"$f":"NPV($F$103,F222:H222)","v":169344.00826446275}]
[]
[]
[]
[null,null,"End-user productivity"]
[]
[null,null,"Corresponding benefit in user productivity from fewer and shorter support calls"]
[]
[null,null,"Ref.","Metric","Calculation","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"K1","Hours saved - Helpdesk",null,{"$f":"F215+F218","v":1250},{"$f":"G215+G218","v":3500},{"$f":"H215+H218","v":5500}]
[null,null,"K2","Avg hourly comp: end-users",null,{"$f":"75000/2000","v":37.5}]
[null,null,"Kt","End-user productivity","K1*K2*K3",{"$f":"F231*F232","v":46875},{"$f":"G231*$F$232","v":131250},{"$f":"H231*$F$232","v":206250}]
[null,null,"Kto","Total (Original)",null,{"$f":"$F$233","v":46875},{"$f":"$G$233","v":131250},{"$f":"$H$233","v":206250},{"$f":"SUM(F234:H234)","v":384375},{"$f":"NPV($F$103,F234:H234)","v":306043.38842975209}]
[null,null,"Ktr","Total (Risk Adjusted)",null,{"$f":"$F$234*ROUND(AVERAGE(0.5,1,1),2)","v":38906.25},{"$f":"$G$234*ROUND(AVERAGE(0.5,1,1),2)","v":108937.5},{"$f":"$H$234*ROUND(AVERAGE(0.5,1,1),2)","v":171187.5},{"$f":"SUM(F235:H235)","v":319031.25},{"$f":"NPV($F$103,F235:H235)","v":254016.01239669416}]
[]
[]
[]
[]
[]
[null,"TOTAL COSTS",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[]
[null,null,null,"Total Costs",null,"Initial","Year 1","Year 2","Year 3","Total","Present Value"]
[]
[null,null,null,{"$f":"C279","v":"Software license fees"},null,{"$f":"F286","v":0},{"$f":"G286","v":-100000},-100000,-100000,{"$f":"SUM(F247:I247)","v":-300000},{"$f":"F247+NPV($F$103,G247:I247)","v":-248685.19909842219}]
[null,null,null,{"$f":"C290","v":"Hardware costs"},null,{"$f":"F299","v":-15150},{"$f":"G299","v":0},0,0,{"$f":"SUM(F248:I248)","v":-15150},{"$f":"F248+NPV($F$103,G248:I248)","v":-15150}]
[null,null,null,{"$f":"C303","v":"Implementation labor costs"},null,{"$f":"F313","v":-28080},{"$f":"G313","v":0},0,0,{"$f":"SUM(F249:I249)","v":-28080},{"$f":"F249+NPV($F$103,G249:I249)","v":-28080}]
[null,null,null,{"$f":"C317","v":"Training fees"},null,{"$f":"F326","v":-20000},{"$f":"G326","v":0},0,0,{"$f":"SUM(F250:I250)","v":-20000},{"$f":"F250+NPV($F$103,G250:I250)","v":-20000}]
[null,null,null,"Total (Risk-Adjusted)",null,{"$f":"SUM(F246:F250)","v":-63230},-100000,-100000,-100000,-363230,-311915.19909842219]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Software license fees"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"A1","License Fees",null,10]
[null,null,"A2",{"$f":"$D$40","v":"Number of seats (MDOP)"},null,{"$f":"$E$40","v":10000}]
[null,null,"At","Software license fees","A1*A2",{"$f":"F282*F283","v":100000}]
[null,null,"Ato","Total (Original)",null,{"$f":"$F$284*0*-1","v":0},{"$f":"$F$284*-1","v":-100000},{"$f":"$F$284*-1","v":-100000},{"$f":"$F$284*-1","v":-100000},{"$f":"SUM(F285:I285)","v":-300000},{"$f":"F285+NPV($F$103,G285:I285)","v":-248685.19909842219}]
[null,null,"Atr","Total (Risk Adjusted)",null,{"$f":"$F$285*ROUND(AVERAGE(1,1,1),2)","v":0},{"$f":"$G$285*ROUND(AVERAGE(1,1,1),2)","v":-100000},{"$f":"$H$285*ROUND(AVERAGE(1,1,1),2)","v":-100000},{"$f":"$I$285*ROUND(AVERAGE(1,1,1),2)","v":-100000},{"$f":"SUM(F286:I286)","v":-300000},{"$f":"F286+NPV($F$103,G286:I286)","v":-248685.19909842219}]
[]
[]
[]
[null,null,"Hardware costs"]
[]
[null,null,"Two central streaming / distribution servers, one database server"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"B1","Cost per server",null,5000]
[null,null,"B2",{"$f":"$D$41","v":"Number of servers for App-V Admin"},null,{"$f":"$E$41","v":3}]
[null,null,"Bt","Hardware costs","B1 * B2",{"$f":"F295*F296","v":15000}]
[null,null,"Bto","Total (Original)",null,{"$f":"$F$297*-1","v":-15000},{"$f":"$F$297*0*-1","v":0},{"$f":"$F$297*0*-1","v":0},{"$f":"$F$297*0*-1","v":0},{"$f":"SUM(F298:I298)","v":-15000},{"$f":"F298+NPV($F$103,G298:I298)","v":-15000}]
[null,null,"Btr","Total (Risk Adjusted)",null,{"$f":"$F$298*ROUND(AVERAGE(0.98,1,1.05),2)","v":-15150},{"$f":"$G$298*ROUND(AVERAGE(0.98,1,1.05),2)","v":0},{"$f":"$H$298*ROUND(AVERAGE(0.98,1,1.05),2)","v":0},{"$f":"$I$298*ROUND(AVERAGE(0.98,1,1.05),2)","v":0},{"$f":"SUM(F299:I299)","v":-15150},{"$f":"F299+NPV($F$103,G299:I299)","v":-15150}]
[]
[]
[]
[null,null,"Implementation labor costs"]
[]
[null,null,"Deploy App-V infrastructure"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"C1","Number of FTEs",null,3]
[null,null,"C2",{"$f":"$D$42","v":"Hourly compensation per FTE (App-V implementation. PC refresh tasks)"},null,50]
[null,null,"C3","Hours","2 months @ 50%",{"$f":"8*40*0.5","v":160}]
[null,null,"Ct","Implementation labor costs","C1 * C2 * C3",{"$f":"F308*F309*F310","v":24000}]
[null,null,"Cto","Total (Original)",null,{"$f":"$F$311*-1","v":-24000},{"$f":"$F$311*0*-1","v":0},{"$f":"$F$311*0*-1","v":0},{"$f":"$F$311*0*-1","v":0},{"$f":"SUM(F312:I312)","v":-24000},{"$f":"F312+NPV($F$103,G312:I312)","v":-24000}]
[null,null,"Ctr","Total (Risk Adjusted)",null,{"$f":"$F$312*ROUND(AVERAGE(1,1,1.5),2)","v":-28080},{"$f":"$G$312*ROUND(AVERAGE(1,1,1.5),2)","v":0},{"$f":"$H$312*ROUND(AVERAGE(1,1,1.5),2)","v":0},{"$f":"$I$312*ROUND(AVERAGE(1,1,1.5),2)","v":0},{"$f":"SUM(F313:I313)","v":-28080},{"$f":"F313+NPV($F$103,G313:I313)","v":-28080}]
[]
[]
[]
[null,null,"Training fees"]
[]
[null,null,"Training for staff who will provide ongoing support for App-V capability"]
[]
[null,null,"Ref.","Metric","Calculation","Per Period","Year 1","Year 2","Year 3","Total","Present Value"]
[null,null,"D1",{"$f":"$D$43","v":"Number of IT staff receiving App-V training"},null,{"$f":"$E$43","v":4}]
[null,null,"D2","Cost per person",null,5000]
[null,null,"Dt","Training fees","D1 * D2",{"$f":"F322*F323","v":20000}]
[null,null,"Dto","Total (Original)",null,{"$f":"$F$324*-1","v":-20000},{"$f":"$F$324*0*-1","v":0},{"$f":"$F$324*0*-1","v":0},{"$f":"$F$324*0*-1","v":0},{"$f":"SUM(F325:I325)","v":-20000},{"$f":"F325+NPV($F$103,G325:I325)","v":-20000}]
[null,null,"Dtr","Total (Risk Adjusted)",null,{"$f":"$F$325*ROUND(AVERAGE(1,1,1),2)","v":-20000},{"$f":"$G$325*ROUND(AVERAGE(1,1,1),2)","v":0},{"$f":"$H$325*ROUND(AVERAGE(1,1,1),2)","v":0},{"$f":"$I$325*ROUND(AVERAGE(1,1,1),2)","v":0},{"$f":"SUM(F326:I326)","v":-20000},{"$f":"F326+NPV($F$103,G326:I326)","v":-20000}]
[]
[]
[]
[]
[]
[]
[null,"DISCLAIMERS",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[null,null,"Liability and Accuracy"]
[]
[null,null,"Microsoft  commissioned Forrester Consulting to develop this business case model in March 2010 using its proprietary Total Economic Impact™ methodology. The intent is for Microsoft to guide prospects through the questionnaire in order to solicit inputs specific to their business. Microsoft is not permitted to change the calculations or equations. Forrester believes that this analysis is representative of what companies may achieve with App-V based on the inputs provided and any assumptions made. Forrester does not endorse Microsoft or its offerings."]
[]
[]
[]
[]
[null,null,"Although great care has been taken to ensure the accuracy and completeness of this model, Microsoft and Forrester Research are unable to accept any legal responsibility for any actions taken on the basis of the information contained herein. The tool is provided ‘AS IS,’ and Forrester and Microsoft make no warranties of any kind. \""]
[]
[]
[]
[]
[null,"MORE INFORMATION",null,null,null,null,null,null,null,null,null,"Ý Return To Top"]
[]
[]
[null,null,"Contact Microsoft"]
[]
[null,null,"Please contact a Microsoft account representative to learn more about App-V and how it can improve the way your organization does business."]
[]
[]
[null,null,"The Total Economic Impact™ Of Microsoft Application Virtualization (App-V)"]
[]
[]
[]
[]
[null,null,"Use these links to obtain your copy of the Forrester case study and the Webcast:"]
[]
[null,null,null,null,null,"Webcast: Application Virtualization (App-V)"]
[]
[null,null,null,null,null,"Forrester case study"]