site-logo

4 Creative Business Case Template Npv Solutions

View Image 4 Creative Business Case Template Npv Solutions

Creative Business Case Template Npv Solutions - ) enterprise case spreadsheet (template) table of contents introduction review this workbook is called the commercial enterprise case spreadsheet template (bct). Its motive is to provide the consumer with a head begin in constructing a thorough monetary analysis and justification for a project. The bct turned into built as a result of research and evaluation of pass-enterprise, industrial great practices. The delivery of the bct is a part of the business enterprise integration toolkit which presents a structured approach, guidance and equipment to dod employees in applying pass- enterprise, commercial quality practices to commercial off-the-shelf (cots) software program application procurement and venture implementations per omb circular a-ninety four. The bct is a multi-tabbed excel workbook containing pre-constructed bureaucracy for enter of all key task estimates, financial analysis, sensitivity analysis and precis charting of consequences. The purpose of the bct is to manual the user thru the technique of collecting venture parameters and financial estimation enter, iterating on and refining undertaking estimates, completing an in depth financial evaluation, generating summary metrics, and, ultimately, the usage of those effects to aid a "pass"/"no-move" decision for assignment approval and investment. The bct allows for 3 increasingly specific strategies of estimation for every fundamental class of price or advantage. The 3 estimation sorts are high-degree, parametric & actual. A number of the element degree tabs have headings for each of these 3 forms of estimation inside the left margin. Statistics waft inside the bct commonly goes from tabs on the proper (detail) to tabs at the left (calculation, aggregation and summarization). Therefore, navigation for consumer familiarity is suggested to start from left (view effects/consequences at summary level) and continue to the proper (know-how of exact input & estimations). Conventions: fields to be used for person input are in red text, fields carried forward or referenced by using different tabs are bold, calculated fields are in black textual content. Assessment commands are provided underneath. More special, supplemental instructions are supplied inside each tab on its use. Ei toolkit record model 1.Zero, december 2003 final established: december 2003 web page 1 of 39 eitk0604 busines case spreadsheet (template) consistent with tab information cash flow & roi evaluation this tab carries diverse measures of monetary feasibility, return on investment (roi) and justification, inclusive of: internet present value (npv), inner price of go back (irr), and breakeven. Pulls data mainly from the fee & advantage precis tab. Additionally pulls a few, key enter parameters from input of assumptions location of enter sensitivity tab. Additionally consists of the underlying yr-to-yr estimated economic results, which roll-up into a cash flow (cf) evaluation containing the subsequent sub-categories: one-time fees (expenses and capital), ongoing prices, ongoing benefits, depreciation. Enter & tornado sensitivity analysis area of all key enter parameters. Also, affords workspace to run the incorporated twister macro. This macro takes person-described enter parameters and produces a twister diagram. This chart allows the person to analyze the relative importance of the enter parameters in terms in their impact at the outcome of the bct model (normally final results is measured in 5 year npv). This form of sensitivity evaluation is in compliance with omb circular a-seventy four. Cost & advantage precis summarizes important categories of expenses and benefits. Acts as a rudimentary "pivot desk" for user selection of level of estimate. As directed by using "x" marks from the consumer, the costbenefit precis tab pulls records from the suitable estimation type vicinity of every supporting, designated workbook tabs: savings, sales, incremental ongoing expenses, undertaking costs & project capital. Savings gain estimates affords a workspace for user quantification of incremental value financial savings blessings of a challenge at 3, increasingly more correct/unique levels of estimation. Pulls key input parameters from input of assumptions area of input sensitivity tab. Sales advantage estimates presents a workspace for quantification of incremental revenue producing blessings of a project at three, increasingly correct/particular tiers of estimation. Pulls key input parameters from input of assumptions vicinity of input sensitivity tab. Sample advantages identification version offers an method to questioning thru the capacity gain regions, gain metrics and gain calculations related to a proposed undertaking in a industrial placing. Currently no inbound or outbound hyperlinks to/from the rest of the enterprise case template. Incremental ongoing charges offers a workspace for user quantification of numerous, incremental, ongoing fees because of imposing the assignment. This sheet gives for this quantification at three, an increasing number of correct/special levels of estimation. Pulls key input parameters from input of assumptions location of input sensitivity tab. Assignment expenses presents a workspace for quantification of challenge costs required for challenge implementation. In it projects, this usually includes consulting, integration, programming, associated journey & fees, and laptop hardware, community system, or software program that doesn't fulfill the regulations for availability to depreciate over time. Inner exertions costs and associated tour & costs also are typically counted in this class. Task capital expenditures offers a workspace for quantification of assignment capital items required for assignment implementation. In it tasks this generally consists of computer hardware, network device, a few custom-developed computer software and a few consulting. Once in a while, this category might also encompass different capital gadgets which include buildings, fixtures, telecommunications system, or constructing renovations. Glossary offers a list of key words or terms, their definition, and how their used. Charts provides graphical summaries of monetary and other analysis results from the bct. Simulation provides workspace where the user may additionally run a one at a time downloadable excel add-in to mechanically simulate many eventualities of the bct, with user-exact variance of a parameter to generate an inverse cumulative distribution curve. Ei toolkit record version 1.Zero, december 2003 last tested: december 2003 page 2 of 39 eitk0604 busines case spreadsheet (template) set up simtools upload-inside the bct makes use of an excel add-in, simtools, which is to be had for down load on the above url. Simtools supports monte carlo simulation and further statistical evaluation of uncertainty in the fee-benefits version. Click on on the above link and follow the commands for downloading to permit those functions. Commands 1 read the enterprise case developers manual to recognize the overall technique to developing a enterprise case. 2 get yourself up to speed with the general structure of the workbook, the technique used for each tab and its next statistics go with the flow. Three use the advantages identification tab to identify all savings and sales blessings of the ability mission. 4 carry out ballpark parameter research. 5 revise benefit eventualities within the savings and sales tabs. 6 revise incremental ongoing prices, if necessary. 7 revise assignment charges and task capital tabs as this data turns into to be had. Eight revise and evidence workbook calculations. 9 10 eleven run initial sensitivity evaluation & produce tornado diagram with the aid of using the twister macro. 12 become aware of high impact input parameters by searching at pinnacle of twister (biggest bars mean diploma of have an effect on). Thirteen carry out parametric research, prioritizing the ones parameters that were at the pinnacle of the maximum latest tornado diagram. 14 refine accuracy of all estimates used as input parameters. 15 run 2d sensitivity evaluation & produce twister diagram. 16 down load simtools and location in suitable directory 17 pick out key parameters and run simulation sensitivity analysis. 18 produce charts. 19 make use of effects as endorsed in the manual 20 refresh input parameters as greater accurate or reliable estimates or facts end up available. Repeat steps sixteen -19 as essential. 21 22 troubleshooting eitk0304 input all key input parameters inside the enter of assumptions segment of the enter twister tab. Then, create references to them from all suitable, underlying designated tabs. A brand new sheet may be created on your workbook. It's going to incorporate the new twister diagram, looked after so that the parameters having the most affect on the output cell (npv in our sample) are at the pinnacle and include the largest horizontal bars. After venture is implemented and operations are anticipated to be taking part in the expected advantages, seize actual key overall performance indicator (kpi) facts. Comply with the instructions within the enter tornado tab and inside the macro, itself. Npv is endorse because the best output mobile as demonstrated within the sample. Utilize the information amassed inside the step above as actual outcomes-level input parameters. Make sure "x" marks in in the ideal columns in costbenefit precis tab. Carry out calculations of actual mission roi & summarize/chart effects to be used in government presentation. If the person is making an attempt to build a reference to a cell inside challenge capital or inctl ongoing costs and the everyday excel cursor turns into a hand, preventing precise mobile reference, kind inside the cellular vicinity alternatively. If you do not see the twister macro below the toolsmacros sub-menu, your example of excel has been configured to disable macros. Please talk over with your helpdesk to have macros enabled. Immediately upon commencing the bct, click on at the enable macros button to permit the proper operation of the twister diagramming macro for sensitivity analysis. Make certain "x" marks are supplied in the best column of the costbenefit precis tab and factor to the most correct/suitable phase/records in every designated tab. At this level, maximum are probable to be "parametric" estimates. Ei toolkit record version 1.Zero, december 2003 final tested: december 2003 web page three of 39 eitk0604 enterprise case spreadsheet (template) business case spreadsheet (template) charts 1 word that this unmarried chart incorporates all full-size cash glide measures. For some displays it is able to be beneficial to supply more than one, easier charts. ($Three) ($2) ($1) $0 $1 $2 $3 $4 $5 $6 0 1 2 three four five m i l l i o n s precis coins flow inflows outflows net coins go with the flow annual cumulative coins go with the flow ei toolkit template web page four of 39 business case spreadsheet (template) commercial enterprise case spreadsheet (template) simulation sensitivity analysis step # sensitivity simulation instructions 1 generate a tornado diagram following steps in tornado diagram segment of input tornado tab. Pick out top influencial parameters. 2 plug the subsequent formula into the high-quality estimate cellular for a key parameter of the enter sensitivity tab: =norminv(rand(),0.15,0.1) where norminv is the function that satisfactory approximates the form of the distribution for this parameter. Where the mean of the distribution is 15 and the standard deviation is 10. Where rand() is used to generate random numbers among zero and 1 three run simtable through using the gear, simtool, simtable menu command from within the bct 4 comply with on display instructions, the usage of 2 columns and approx. A hundred rows, beginning from cell c4 five kind cells d5 to lead to descending order. 6 use chart wizard to devise a line graph as above. 7 8 refine the chart to be used in summary shows nine 10 * remember the fact that after the primary time simulation is run consistent with the steps above, the model outcome (npv) will alternate each and on every occasion the consumer causes the workbook to re-calculate. Therefore, the bct will now not be re-usable for dependable roi metrics until all parameters within the enter sensitivity tab are once more "difficult-coded." In which the norminv feature makes use of this random quantity to genarate simulations of results (usually npv in cellular d4) for this a extra sophisticated and thorough version on step 9 above is to run a simulation on multiple, key parameters concurrently. To do this, the person would execute step 2 for pick parameters (ex: pinnacle five). If warranted, the consumer can carry out this technique for another, key parameter: to isolate the results of every simulation, begin by way of re-keying a "tough- have a look at line graph "tilt": the greater horizontal most of the people of the curve, the greater predictable final results (npv) is as the key parameter varies according to the form of the selected distribution curve. $Zero $1 $2 $three $4 $five $6 1 9 17 25 33 forty one 49 57 65 73 81 89 ninety seven m i l l i o n s simulation of npv effects varying of development in volume cut price throughout an inverse everyday distribution consequences, descending… ei toolkit template page 5 of 39 challenge xxx business case template enterprise integration toolkit commercial enterprise case spreadsheet (template) enter & twister sensitivity evaluation enter of assumptions (assumptions) tab name segment call best estimate parameter name of parameter low estimate of parameter excessive estimate of parameter roi and cf analysis assumptions in keeping with yr 15.00 bargain price 10 25 roi and cf analysis assumptions in keeping with year 2.5 annual price will increase 0 7 roi and cf evaluation assumptions in step with 12 months 2.Five annual advantage increases zero 7 roi and cf analysis assumptions according to year forty two corporate tax charge 35 49 roi and cf analysis depreciation & interest 8.5 hobby rate 6 12 financial savings purchasing 10 est. Development in buying productiveness 0 25 financial savings shopping 10 est. Incremental of comparable merchandise diagnosed 5 15 savings purchasing 10 est. Improvement in price per p.O. 7 15 savings purchasing 10 est. Incremental of same supplier/same month 4 18 savings shopping 15 est. Improvement in extent bargain 5 forty savings preservation & restore 10 est. Improvement in protection & repair worker productiveness 5 15 financial savings warehousing/inventory 10 est. Avg. Discount in # parts consistent with warehouse 7 13 financial savings logistics, et al. 10 est. Improvement in logistics worker productiveness five 15 savings logistics, et al. 20 est. Avg. Reduction in price according to work order 10 30 financial savings logistics, et al. 25 expected reduction in top class freight shipments zero 30 financial savings customer support 10 est. Avg development in c.S. & O.M. Employee 5 15 financial savings customer support 50 est. Reduction of incorrect orders 35 60 financial savings customer service 50 est. Reduction in complaint calls 10 70 financial savings is 3 est. # Decomissioned structures 2 four savings finance 10 est. Avg development in finance worker productivity 5 15 savings hr 10 est. Avg development in hr employee productiveness 5 15 sales income 5 est. Growth in rate according to order 2 10 sales 10 est. Improvement in close rate zero 20 income 10 est. Lower so as processing time 3 thirteen sales 10 est. Improvement in sales tour performance 0 25 income 10 est avg annual discount in client loss 5 15 customer support 10 est. Development in customer pleasure 2 14 customer support 10 est. Incremental of leads surpassed in keeping with c.S. Worker 5 30 benefits identification ongoing fees assignment charges mission capital 1. Ensure all key input parameters are "tough coded" (typed in, not calculated or referenced) into the segment beneath. Start with column d. The person may additionally ought to point key cells of the various targeted price and benefits tabs to these cells on this tab. These "pointer" cells inside the element tabs are coloured black in this bct pattern to reveal that they may be now not enter cells. Also in the desk underneath, offer minimal (column f) and most (column g) records factors for the first-class estimate of enter parameter supplied in column d. Web page 6 of 39 assignment xxx business case template organisation integration toolkit tornado sensitivity evaluation 5 year npv 2,827,104 financial savings sensitivity analysis outputs parameters: output d48 with low price from f4:f24 for parameter in d4:d24 output d48 with excessive cost from g4:g24 for parameter in d4:d24 output differences: est. Improvement in quantity discount 1,614,270 five,069,681 3,455,411 est. Incremental of equal dealer/equal month orders 1,712,996 three,786,243 2,073,246 bargain charge 3,245,260 1,624,707 1,620,553 est. Incremental of similar products diagnosed 2,094,042 3,109,019 1,014,977 est. Development in charge consistent with p.O. 2,297,037 three,109,019 811,982 company tax charge 2,986,293 2,216,767 769,526 annual value will increase 2,478,708 2,835,470 356,762 est. Development in buying productiveness 2,520,332 2,723,328 202,995 est. # Decomissioned systems 2,520,332 2,682,728 162,396 est. Discount in criticism calls 2,500,033 2,652,279 152,247 est. Avg. Reduction in # components per warehouse 2,530,711 2,672,349 141,638 est. Avg. Discount in price in line with work order 2,551,938 2,651,123 99,186 est. Development in maintenance & repair worker productivity 2,560,931 2,642,129 eighty one,198 est. Development in logistics employee productiveness 2,560,931 2,642,129 eighty one,198 est. Avg improvement in c.S. & O.M. Worker productivity 2,560,931 2,642,129 eighty one,198 est. Avg development in finance worker productiveness 2,560,931 2,642,129 eighty one,198 est. Avg improvement in hr worker productivity 2,560,931 2,642,129 eighty one,198 estimated discount in premium freight shipments 2,576,156 2,606,605 30,449 est. Reduction of wrong orders 2,584,448 2,612,918 28,470 annual advantage will increase 2,601,530 2,601,530 0 interest fee 2,601,530 2,601,530 zero 2. From the tools menu, select macros, spotlight twister and click on the "run" button. Then, follow the pop-up instructions supplied by the macro itself. The resulting chart will seem inside a newly inserted tab (sheet 1) in this workbook. 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 est. Improvement in volume discount discount rate est. Improvement in charge in keeping with p.O. Annual value will increase est. # Decomissioned structures est. Avg. Reduction in # elements consistent with warehouse est. Improvement in renovation & repair employee productiveness est. Avg improvement in c.S. & O.M. Employee productivity est. Avg development in hr worker productivity est. Reduction of incorrect orders interest fee key savings parameters page 7 of 39 undertaking xxx enterprise case template agency integration toolkit sales sensitivity analysis outputs 5 yr npv 2,827,104 parameters: output d46 with low cost from f28:f34 for parameter in output d46 with excessive fee from g28:g34 for parameter in output variations: est. Improvement in near charge 2,505,863 2,975,924 470,061 est. Development in income travel efficiency 2,598,236 2,984,093 385,857 est. Increase in charge in keeping with order 2,624,439 2,960,811 336,372 est. Decrease in order processing time 2,635,471 2,788,590 153,119 est. Incremental of leads handed in keeping with c.S. Employee 2,727,748 2,819,661 ninety one,912 est avg annual discount in purchaser loss 2,733,408 2,748,379 14,971 est. Improvement in patron delight 2,740,894 2,740,894 0 2,200,000 2,300,000 2,four hundred,000 2,500,000 2,six hundred,000 2,seven hundred,000 2,800,000 2,900,000 three,000,000 three,100,000 est. Development in near charge est. Development in sales journey efficiency est. Growth in rate in keeping with order est. Lower so as processing time est. Incremental of leads handed consistent with c.S. Employee est avg annual reduction in patron loss est. Improvement in patron pleasure key revenue parameters page eight of 39 undertaking xxx enterprise case template organization integration toolkit commercial enterprise case spreadsheet (template) coins float & roi analysis five 12 months npv 2,827,104 $ 5 year irr 60 payback (yrs.) 1.6 challenge name: commonplace it project project #: assumptions consistent with 12 months yr 0 yr 1 12 months 2 yr three year 4 year five yr 6 yr 7 12 months eight 12 months 9 assumptions discount price 15 annual price will increase 0 2.Five 2.5 2.5 2.Five 2.5 2.Five 2.Five 2.Five annual benefit will increase zero 2.5 2.Five 2.5 2.Five 2.5 2.Five 2.5 2.5 company tax rate 42 forty two 42 forty two forty two forty two 42 forty two forty two one time undertaking prices yr zero yr 1 12 months 2 yr three yr four 12 months 5 yr 6 yr 7 year 8 year nine capital outlays (display as negative numbers) outside consulting fees 0 computer & other system (1,659,619) asset class 3 zero asset class 4 0 asset class five 0 sub-overall capital outlay (1,659,619) 0 0 zero zero 0 0 zero 0 0 one time charges outside consulting charges (621,575) inner employees costs (582,981) it set up charges zero sub-overall one time prices (1,204,556) 0 0 0 0 0 0 0 zero zero overall outlays (2,864,a hundred seventy five) zero zero 0 zero zero zero 0 zero 0 income impact year zero yr 1 year 2 year three yr four yr five 12 months 6 yr 7 12 months 8 12 months nine projected expenses (display as poor numbers) depreciation (331,924) (331,924) (331,924) (331,924) (331,924) zero zero zero zero on-going fees (1,240,720) (874,016) (670,740) (571,778) (531,886) one time prices (1,204,556) 0 zero 0 zero zero 0 0 zero 0 overall prices (1,204,556) (1,572,644) (1,205,940) (1,002,664) (903,702) (863,810) zero 0 zero zero projected benefits extra on-going blessings 1,908,801 1,344,640 1,031,907 879,659 818,287 incremental contribution/earnings 1,918,201 1,966,156 2,0.5,310 2,008,half 2,039,475 general blessings 3,827,002 three,310,796 three,047,217 2,887,684 2,857,762 zero 0 zero 0 net projected impact (1,204,556) 2,254,357 2,104,856 2,044,554 1,983,982 1,993,952 0 0 zero 0 tax 505,914 (946,830) (884,040) (858,713) (833,272) (837,460) zero 0 zero 0 profits after tax (698,642) 1,307,527 1,220,817 1,185,841 1,150,709 1,156,492 zero zero zero 0 web page 9 of 39 task xxx business case template enterprise integration toolkit cash glide year 0 yr 1 yr 2 year 3 yr 4 12 months 5 yr 6 year 7 yr eight year 9 capital outlay (1,659,619) 0 0 zero 0 zero zero zero 0 zero one-time exp. (After tax) (698,642) 0 zero zero zero 0 0 0 0 0 income after tax 1,307,527 1,220,817 1,185,841 1,150,709 1,156,492 zero zero 0 0 depreciation 331,924 331,924 331,924 331,924 331,924 0 0 0 zero net coins drift (2,358,261) 1,639,451 1,552,740 1,517,765 1,482,633 1,488,416 0 0 0 zero discounted cash flows (2,358,261) 1,425,610 1,174,0.5 997,955 847,seven-hundred 740,006 - - - - cumulative discounted (2,358,261) (932,652) 241,443 1,239,398 2,087,098 2,827,104 2,827,104 2,827,104 2,827,104 2,827,104 cumulative nominal (2,358,261) (718,810) 833,930 2,351,695 3,834,328 five,322,744 5,322,744 5,322,744 5,322,744 five,322,744 zero 1 2 3 4 5 6 7 eight nine depreciation and interest time table beginning balance close 12 months 1 year 2 yr three 12 months four year 5 year 6 year 7 year 8 yr 9 external consulting fees 0 0 zero 0 zero 0 zero zero zero 0 pc & different device 1,659,619 1,659,619 1,327,695 995,771 663,848 331,924 0 zero 0 zero asset category three 0 0 zero zero zero zero 0 zero zero zero asset category 4 zero zero 0 0 0 zero 0 0 0 zero asset class five zero zero zero 0 zero zero 0 0 0 zero total outlay 1,659,619 1,659,619 1,327,695 995,771 663,848 331,924 zero 0 zero zero depreciation existence (# of years) outside consulting fees 3 zero 0 zero 0 0 zero zero zero zero pc & other system five 331,924 331,924 331,924 331,924 331,924 zero zero 0 zero asset category 3 three 0 zero zero 0 zero zero 0 zero zero asset category four five zero zero 0 0 0 zero 0 0 zero asset class five 10 0 0 zero 0 zero zero 0 0 0 total outlay 331,924 331,924 331,924 331,924 331,924 zero 0 0 zero ending balance outside consulting costs zero zero 0 zero 0 zero 0 zero 0 0 laptop & other equipment 1,659,619 1,327,695 995,771 663,848 331,924 0 0 0 zero 0 asset category 3 0 zero zero zero zero zero 0 0 zero zero asset class 4 zero zero 0 0 zero 0 zero zero zero zero asset category five 0 zero zero zero zero zero 0 0 0 zero general outlay 1,659,619 1,327,695 995,771 663,848 331,924 zero zero zero 0 0 hobby on avg balance 126,961 ninety eight,747 70,534 forty two,320 14,107 0 zero 0 zero hobby fee 8.Five web page 10 of 39 challenge xxx commercial enterprise case template company integration toolkit year 10 total 2.Five 2.Five forty two year 10 overall zero (1,659,619) zero zero 0 0 (1,659,619) (621,575) (582,981) 0 zero (1,204,556) 0 (2,864,a hundred seventy five) year 10 overall 0 (1,659,619) (3,889,141) 0 (1,204,556) 0 (6,753,316) five,983,294 9,947,167 zero 5,983,294 0 (770,022) 0 (4,360,314) zero (5,one hundred thirty,337) page 11 of 39 project xxx enterprise case template corporation integration toolkit yr 10 overall zero (1,659,619) 0 (698,642) 0 6,021,386 zero 1,659,619 0 five,322,744 - 2,827,104 5,322,744 10 12 months 10 general zero zero 0 zero 0 0 0 zero zero 1,659,619 0 zero 0 0 0 zero 0 1,659,619 0 0 zero 0 zero zero zero 352,669 web page 12 of 39 task xxx commercial enterprise case template organisation integration toolkit commercial enterprise case spreadsheet (template) price & advantage precis everyday it challenge level of estimation* all rows ought to have an "x" in handiest one of the three columns under. 1 2 3 12 months zero yr 1 12 months 2 yr three yr four yr five avg. - Blessings - incremental revenue x - $ 1,908,801 $ 1,344,640 $ 1,031,907 $ 879,659 $ 818,287 $ incremental value financial savings x - $ 1,918,201 $ 1,966,156 $ 2,half,310 $ 2,008,1/2 $ 2,039,475 $ - fees - incremental commissions & price of sales x - $ 286,320 $ 201,696 $ 154,786 $ 131,949 $ 122,743 $ incremental price of operations x - $ 763,520 $ 537,856 $ 412,763 $ 351,864 $ 327,315 $ incremental sg&a fee x - $ 190,880 $ 134,464 $ 103,191 $ 87,966 $ 81,829 $ outside task costs (costs & different prices) x 621,575 $ - $ - $ - $ - $ - $ internal project expenses (employees & other x 582,981 $ - $ - $ - $ - $ - $ gross gain (1,204,556) $ 2,586,281 $ 2,436,780 $ 2,376,477 $ 2,315,905 $ 2,325,876 $ 2,408,264 $ cumulative gross gain (1,204,556) $ 1,381,725 $ 3,818,505 $ 6,194,983 $ 8,510,888 $ 10,836,764 $ * level of estimation footnotes: 1 - excessive stage ("ballpark") estimates are usually based on initial research on similar initiatives, rfi responses and/or non-binding estimates. 2 - parametric estimates are generally based on in-intensity studies, rfp reaction and/or documented contractual responsibility. Three - actual costs and blessings as measured post-implementation for validation. Web page thirteen of 39 undertaking xxx business case template employer integration toolkit business case spreadsheet (template) task capital expenses level 1 - excessive level estimates yr zero 12 months 1 yr 2 yr three yr 4 year five overall capex - $ - $ - $ - $ - $ - $ buildout computers servers community components software software license os/db/utilities software program license premise-base telecom equip. Other infrastructure web page 14 of 39 project xxx enterprise case template business enterprise integration toolkit stage 2 - parametric estimates (sample) assignment capital expenses for a brand new name center variety of sites required 12 months zero year 1 year 2 yr three yr four 12 months 5 1.00 total capex 1,659,619 $ - $ - $ - $ - $ - $ variables capex according to site agent stations 175 1,659,619 $ non-agent stations 75 sq. Toes. (120 in step with seat) 30000 capex value/seat nine,484 $ one time capex expenses unit price amount general buildout 6,000 $ 30 a hundred and eighty,000 $ lan sub-general lan server (novell) 6,739 $ 1 6,739 $ 539,254 $ front end cisco router 10,000 $ 2 20,000 $ 100mb fault tolerance transceiver 4,500 $ 1 4,500 $ voice sub-total accelar spine transfer 35,000 $ 2 70,000 $ 279,865 $ cisco switch (24 port) 2,500 $ 9 22,500 $ lan tape backup 3,four hundred $ 1 three,four hundred $ brick and mortar sub-general tapes 20 $ 40 800 $ 840,500 $ lan control workstations 3,000 $ 1 3,000 $ sniffer community probe 17,000 $ 1 17,000 $ hp laser jet 4000 1,500 $ 1 1,500 $ fax server four,800 $ 1 4,800 $ pc laptop 1,000 $ 250 250,000 $ surge protectors for computer's 14 $ 250 three,500 $ equipment racks 300 $ 1 three hundred $ tools, tywraps, labels 500 $ 1 500 $ novel four.Eleven os forty $ 250 10,000 $ novell gateway sessions 50 $ 25 1,250 $ 10 managewise lan software 10,000 $ 1 10,000 $ hp openview 18,000 $ 1 18,000 $ optivity transfer control software 10,000 $ 1 10,000 $ cisco works 18,000 $ 1 18,000 $ faraway get admission to software 1,000 $ 1 1,000 $ attachmate for home windows 360 $ 25 9,000 $ 10 1ec5f5ec77c51a968271b2ca9862907d software seventy one $ 250 17,750 $ msoffice 500 $ 1 500 $ communications line frame three,000 $ 1 3,000 $ modems frads 500 $ 1 500 $ education device 5,000 $ 1 five,000 $ web page 15 of 39 task xxx business case template organization integration toolkit solar sparc 250 iws intranet server 16,865 $ 1 sixteen,865 $ intel based totally intranet server 4,000 $ 1 four,000 $ wiznet gateway 2,400 $ 1 2,400 $ sun backup unit 2,200 $ 1 2,200 $ iws backup tapes 20 $ 40 800 $ solaris license 150 $ 3 450 $ sun sparc 250 iws intranet server sixteen,865 $ 1 16,865 $ lucent pbx - $ 1 - $ fee in keeping with station set up - $ 2000 paraphonics ivr 150,000 $ 1 a hundred and fifty,000 $ genesis cti server 20,000 $ 1 20,000 $ open client sybase license 31,000 $ 3 93,000 $ fixtures (cubes) 2,000 $ 250 500,000 $ wiring for computer's and cubes 120 $ 250 30,000 $ safety device seventy five,000 $ 1 75,000 $ reception area 20,000 $ 1 20,000 $ cafeteria 20,000 $ 1 20,000 $ pc set up 50 $ 250 12,500 $ data roomsetup 3,000 $ 1 3,000 $ 1,659,619 $ web page sixteen of 39 task xxx commercial enterprise case template company integration toolkit degree 3 - actual outcomes 12 months zero year 1 yr 2 yr three 12 months 4 year 5 overall capex - $ - $ - $ - $ - $ - $ page 17 of 39 task xxx business case template company integration toolkit commercial enterprise case spreadsheet (template) undertaking fees outside undertaking expenses (fees & other fees) stage 1 - excessive level estimates assumptions year 0 year 1 yr 2 yr three year four 12 months 5 external challenge expenses (prices & other costs) - $ - $ - $ - $ - $ - $ page 18 of 39 task xxx enterprise case template employer integration toolkit degree 2 - parametric estimates assumptions 12 months zero 12 months 1 12 months 2 yr 3 yr four 12 months 5 external challenge prices (prices & different prices) 621,575 $ external costs contingency 15 eighty one,0.5 $ tour & expenses 15 70,500 $ integrator charges (day by day charge) 1,000 $ 470,000 $ assignment paintings breakdown shape (wbs) for time-honored it mission participants # occurrences estimating issue period (days) ftes outside integrator ftes customer ftes task name phase i 1890.Zero 470.Zero 1420.0 workstream 1 1220.0 210.0 1010.0 undertaking package 1 task 1 four three conferences 10 120.0 50 60.Zero 60.0 assignment 2 2 5 tables 20 two hundred.Zero zero zero.0 2 hundred.0 undertaking 3 undertaking bundle 2 mission 1 four three meetings 25 300.0 50 one hundred fifty.Zero a hundred and fifty.Zero challenge 2 2 5 tables 60 600.Zero 0 zero.Zero 600.0 workstream 2 670.Zero 260.0 410.Zero mission package deal 1 venture 1 4 three conferences 10 120.Zero 50 60.Zero 60.Zero undertaking 2 2 5 tables 35 350.Zero 0 0.Zero 350.Zero undertaking three 2 five classes 20 200.0 a hundred 200.Zero 0.0 degree three - real consequences assumptions year 0 year 1 12 months 2 yr three year 4 yr 5 page 19 of 39 assignment xxx commercial enterprise case template corporation integration toolkit external challenge expenses (fees & other fees) - $ - $ - $ - $ - $ - $ page 20 of 39 project xxx business case template corporation integration toolkit inner venture costs (personnel & other prices) yr 0 12 months 1 year 2 yr 3 year four yr five inner task fees (employees & different charges) - $ - $ - $ - $ - $ - $ page 21 of 39 mission xxx enterprise case template employer integration toolkit assumptions yr 0 year 1 12 months 2 year 3 12 months 4 year 5 inner task costs (personnel & other charges) 582,981 $ internal task fees contingency 15 seventy six,041 $ personnel travel & costs five 24,140 $ tour inner exertions fee (every day fee) 340 $ 482,800 $ personnel corresponding government value classes 12 months 0 12 months 1 year 2 12 months three year four year five (from omb circular no. Seventy six: revised supplemental guide, performance of commercial sports page 22 of 39 undertaking xxx business case template company integration toolkit internal assignment fees (employees & different charges) - $ - $ - $ - $ - $ - $ web page 23 of 39 assignment xxx enterprise case template enterprise integration toolkit business case spreadsheet (template) incremental ongoing charges stage 1 - excessive degree estimates incremental commissions & fee of sales estimated as percentage of sales from earlier operating financial information. - Utilized in row 10 of costbenefit summary tab 12 months zero year 1 yr 2 year three yr 4 12 months five estimate: commissions & cost of income zero 15 15 15 15 15 description of supporting research and facts supply(s): incremental fee of operations - utilized in row eleven of costbenefit summary tab envisioned as percentage of sales from previous running economic information. 12 months 0 12 months 1 12 months 2 12 months three year four 12 months 5 estimate: cost of operations zero 40 forty 40 forty 40 description of supporting research and information supply(s): incremental sg&a price - used in row 12 of costbenefit precis tab predicted as percentage of revenues from earlier running economic facts. Year 0 yr 1 12 months 2 yr three yr 4 12 months five estimate: sg&a fee 0 10 10 10 10 10 description of helping research and facts supply(s): page 24 of 39 mission xxx enterprise case template business enterprise integration toolkit stage 2 - parametric estimates incremental commissions & value of income - utilized in row 10 of costbenefit precis tab (insert parametric estimates of commissions & fee of sales sub-categories on this area.) 12 months 0 year 1 year 2 year three yr four year 5 overall commissions & price of sales - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-classes of parametric estimates of ongoing commissions & value of income from rows in degree 2 phase above.) Incremental fee of operations (sample) ongoing working prices of a name center - used in row eleven of costbenefit precis tab year zero yr 1 12 months 2 12 months three 12 months 4 12 months 5 total annual cost of operations - $ 15,037,991 $ thirteen,770,359 $ thirteen,770,359 $ thirteen,770,359 $ thirteen,770,359 $ # sites variables administrative seats 34 1.00 center size (seats) 250 schooling seats 41 sq. Feet. (A hundred and twenty consistent with seat) 30000 agent seats 70 a hundred seventy five turnover - annual 60 250 blessings loading factor 24 operating cost/seat annual operating expenses per web page 52,521 $ variable - yr one 13,one hundred thirty,291 $ 47,450.64 variable - out years eleven,862,659 $ 7,630.80 fixed - each year 1,907,seven-hundred $ web page 25 of 39 assignment xxx business case template company integration toolkit 12 months one operating costs out years operating prices corresponding authorities price classes headcount income/ value in keeping with unit total loaded fee headcount revenue/ price in keeping with unit total loaded fee (from omb circular no. 76: revised supplemental handbook, overall performance of business sports variable based totally on headcount variable based totally on headcount employees center director 1 70,000 $ 86,800 $ middle director 1 70,000 $ 86,800 $ personnel managers 2 fifty seven,324 $ 142,164 $ one hundred ratio managers 2 fifty seven,324 $ 142,164 $ personnel supervisors eleven 32,913 $ 446,383 $ 20 ratio supervisors eleven 32,913 $ 446,383 $ employees leads 9 28,198 $ 314,690 $ 25 ratio leads 9 28,198 $ 314,690 $ personnel retailers 219 19,608 $ five,318,670 $ 9.50 $ agents 219 19,608 $ five,318,670 $ employees tech assist 1 fifty five,000 $ 68,200 $ tech help 1 fifty five,000 $ 68,2 hundred $ employees facility supervisor 1 35,000 $ 43,four hundred $ facility manager 1 35,000 $ forty three,400 $ employees group of workers coordinator 3 20,640 $ seventy six,781 $ workforce coordinator three 20,640 $ 76,781 $ employees admin 2 20,640 $ fifty one,187 $ admin 2 20,640 $ 51,187 $ personnel hr coordinator 2 32,913 $ 81,624 $ hr coordinator 2 32,913 $ 81,624 $ personnel running shoes 2 32,913 $ 81,624 $ running shoes 2 32,913 $ 81,624 $ employees initial recruiting 253 1,500 $ 379,031 $ preliminary recruiting 0 1,500 $ - $ personnel initial hiring 253 2,000 $ 505,375 $ initial hiring 0 2,000 $ - $ employees initial education 253 1,200 $ 303,225 $ initial training zero 1,200 $ - $ employees recruiting for churn 131 1,500 $ 196,875 $ recruiting to cowl churn 131 1,500 $ 196,875 $ personnel churn hiring prices 131 2,000 $ 262,500 $ churn hiring costs 131 2,000 $ 262,500 $ employees churn training fee 131 1,2 hundred $ 157,500 $ churn training price 131 1,2 hundred $ 157,500 $ employees holiday exp. 253 2,400 $ 606,450 $ excursion exp. 253 2,400 $ 606,450 $ personnel bonus exp. 253 1,three hundred $ 328,494 $ bonus exp. 253 1,three hundred $ 328,494 $ personnel carrier awards 253 a hundred $ 25,269 $ carrier awards 253 one hundred $ 25,269 $ personnel incent. Pay 253 275 $ sixty nine,489 $ incent. Pay 253 275 $ 69,489 $ employees unemployment taxes 253 1,one hundred $ 277,956 $ unemployment taxes 253 1,a hundred $ 277,956 $ employees payroll taxes 253 three,000 $ 758,063 $ payroll taxes 253 3,000 $ 758,063 $ employees grp. Medical ins. 253 four,2 hundred $ 1,061,288 $ grp. Clinical ins. 253 four,two hundred $ 1,061,288 $ employees pens. Plan contrib.. 253 480 $ 121,290 $ pens. Plan contrib.. 253 480 $ 121,290 $ employees 401k contrib.. 253 4,050 $ 1,023,384 $ 401k contrib.. 253 4,050 $ 1,023,384 $ employees unwell pay exp. 253 410 $ 103,602 $ sick pay exp. 253 410 $ 103,602 $ personnel different ee blessings 253 - $ - $ different ee advantages 253 - $ - $ personnel seminars and instructions 253 - $ - $ seminars and instructions 253 - $ - $ employees academic reimb. 253 410 $ 103,602 $ academic reimb. 253 410 $ 103,602 $ employees different pers. Exp. 253 a hundred and forty $ 35,376 $ different pers. Exp. 253 140 $ 35,376 $ employees temp assist days 500 200 $ 100,000 $ $ 25.00 / hour temp help days one hundred two hundred $ 20,000 $ employees overall thirteen,one hundred thirty,291 $ total 11,862,659 $ page 26 of 39 undertaking xxx commercial enterprise case template business enterprise integration toolkit fixed annual fees - each year tour and entertainment tour lodging 24 two hundred $ four,800 $ tour airfare 8 800 $ 6,four hundred $ travel hire cars 0 - $ - $ tour other 253 - $ - $ travel food 24 50 $ 1,200 $ travel meals-entertainment 24 50 $ 1,200 $ travel meetings three 5,000 $ 15,000 $ travel postage 253 seventy five $ 18,952 $ substances & deliver prices office supplies 253 seventy five $ 18,952 $ materials & deliver prices stationary/bureaucracy 253 0.50 $ 126 $ substances & deliver prices workplace eq. 1 288,000 $ 288,000 $ substances & supply charges lease- workplace eq. 1 84,000 $ 84,000 $ materials & supply costs depreciation of pc's 1 80,340 $ eighty,340 $ depreciation depreciation of furnishings 1 61,956 $ sixty one,956 $ depreciation computer supplies 253 20 $ five,054 $ substances & supply fees hardware preservation 1 forty nine,116 $ 49,116 $ renovation & repair software program protection 1 24,567 $ 24,567 $ maintenance & repair bank costs 1 1,000 $ 1,000 $ different fees dues/subscriptions 253 14 $ 3,538 $ different charges centers - hire 30000 22 $ 660,000 $ rent utilities 30000 9.50 $ 285,000 $ utilities facil. Repair 30000 four.20 $ 126,000 $ preservation & repair other occ. Exp. 30000 five.Seventy five $ 172,500 $ coverage general 1,907,700 $ incremental sg&a price - utilized in row 12 of costbenefit summary tab (insert parametric estimates of sg&a fee sub-classes in this area.) Year 0 yr 1 yr 2 12 months three yr 4 year five overall annual sg&a expenses - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-classes of parametric estimates of ongoing sg&a from rows in level 2 section above.) Page 27 of 39 project xxx commercial enterprise case template company integration toolkit degree 3 - actual effects incremental commissions & price of income - used in row 10 of costbenefit summary tab (insert quantification of actual commissions & fee of income sub-classes in this area.) Year 0 year 1 12 months 2 12 months 3 yr four yr five total annual commissions & fee of income - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-categories of real ongoing commissions & value of sales from rows in stage three phase above.) Incremental price of operations - utilized in row eleven of costbenefit precis tab (insert quantification of actual cost of operations sub-classes in this area.) Yr zero yr 1 yr 2 12 months 3 12 months four year 5 total annual cost of operations - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-categories of real ongoing price of operations from rows in level three phase above.) Incremental sg&a value - used in row 12 of costbenefit precis tab (insert quantification of actual sg&a sub-classes in this area.) Yr 0 year 1 year 2 12 months three year 4 12 months five total annual sg&a charges - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-classes of actual ongoing sg&a from rows in level 3 phase above.) Web page 28 of 39 challenge xxx enterprise case template employer integration toolkit commercial enterprise case spreadsheet (template) financial savings benefit estimates level 1 - excessive stage estimates year zero year 1 yr 2 yr three year 4 12 months 5 (insert high stage price financial savings sub-class estimates on this space.) Grand overall fee financial savings - $ - $ - $ - $ - $ - $ (insert calculations in row bove to sum sub-categories of excessive-degree savings from rows in stage 1 section above.) Web page 29 of 39 venture xxx commercial enterprise case template organisation integration toolkit level 2 - parametric estimates dept. Description gadgets yr 1 12 months 2 yr three year 4 12 months 5 total improvement purchasing development in efficiency of personnel est. Development in shopping productiveness 10 10.Zero 10.0 10.Zero 10.0 actual annual harassed value of employee forty,000 $ 41,000 $ forty two,half $ forty three,076 $ 44,153 $ avg wide variety of people in dept. Using device 10 10 10 10 10 annual price savings 40,000 $ forty one,000 $ forty two,1/2 $ forty three,076 $ forty four,153 $ 210,253 $ higher visibility of purchased product excellent avg. Annual variety of buy orders 1,000 1,000 1,000 1,000 1,000 avg. P.O. Quantity 50,000 $ 51,250 $ fifty two,531 $ 53,845 $ 55,191 $ est. Incremental of comparable merchandise diagnosed 10 10 10 10 10 est. Development in charge per p.O. 10 10 10 10 10 annual value financial savings 500,000 $ 512,500 $ 525,313 $ 538,445 $ 551,906 $ 2,628,164 $ better visibility of identical vendor purchases avg. Annual range of purchase orders 1,000 1,000 $ 1,000 $ 1,000 $ 1,000 $ avg. P.O. Quantity 50,000 $ 51,250 $ fifty two,531 $ 50,000 $ 50,000 $ est. Incremental of same vendor/equal month orders 10 10 10 10 10 est. Improvement in extent discount 15 15 15 15 15 annual cost financial savings 750,000 $ 768,750 $ 787,969 $ 750,000 $ 750,000 $ 3,806,719 $ general purchasing 1,290,000 $ 1,322,250 $ 1,355,306 $ 1,331,521 $ 1,346,059 $ 6,645,136 $ protection & restore development in efficiency of employees est. Improvement in upkeep & repair worker 10 10.Zero 10.Zero 10.Zero 10.0 real annual careworn value of employee 40,000 $ forty one,000 $ forty two,1/2 $ forty three,076 $ forty four,153 $ avg range of people in dept. Using device 10 10 10 10 10 annual fee financial savings forty,000 $ 41,000 $ 42,half $ forty three,076 $ forty four,153 $ 210,253 $ placeholder actual 0 - - - - real 10 10 10 10 10 estimate 10 10 10 10 10 actual 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ annual value savings - $ - $ - $ - $ - $ - $ total maintenance & restore 40,000 $ forty one,000 $ forty two,0.5 $ 43,076 $ 44,153 $ 210,253 $ warehousing/stock manage improvement in performance of personnel est. Improvement in warehouse/stock worker 10 10.0 10.Zero 10.0 10.0 real annual careworn fee of worker forty,000 $ forty one,000 $ forty two,1/2 $ 43,076 $ 44,153 $ real quantity of workers in dept. Using system 10 10 10 10 10 annual price savings 40,000 $ forty one,000 $ 42,1/2 $ forty three,076 $ forty four,153 $ 210,253 $ decreased sporting fees est. Avg. Reduction in # parts per warehouse 10 10.Zero 10.Zero 10.Zero 10.0 avg # parts consistent with warehouse 10,000 $ 10,000 10,000 10,000 10,000 actual # warehouses 3 3 3 three 3 avg annual carrying fee in line with component 25.43 $ 26.07 $ 26.72 $ 27.39 $ 28.07 $ annual value financial savings 76,290 $ seventy eight,197 $ eighty,152 $ eighty two,156 $ eighty four,210 $ 401,half $ overall warehousing 116,290 $ 119,197 $ 122,177 $ 125,232 $ 128,362 $ 611,258 $ web page 30 of 39 undertaking xxx enterprise case template agency integration toolkit dept. Description units yr 1 year 2 yr three 12 months 4 yr 5 general development logistics/ shipping/ receiving improvement in efficiency of personnel est. Improvement in logistics worker productivity 10 10.Zero 10.Zero 10.Zero 10.0 real annual burdened price of worker 40,000 $ 41,000 $ 42,1/2 $ 43,076 $ forty four,153 $ avg variety of employees in dept. Using machine 10 10 10 10 10 annual value financial savings forty,000 $ forty one,000 $ forty two,1/2 $ 43,076 $ 44,153 $ 210,253 $ improvement in non-labor cost of labor order handling real avg non-exertions price according to work order fifty four.29 $ 55.65 $ 57.04 $ 58.Forty six $ 59.Ninety three $ est. Avg. Discount in cost per work order 20 20.Zero 20.Zero 20.Zero 20.Zero actual annual number of work orders four,500 four,500 $ four,500 $ four,500 $ 4,500 $ annual cost savings 48,861 $ 50,083 $ 51,335 $ 52,618 $ 53,933 $ 256,829 $ reduce premium freight avg annual shipments 10,000 10,000 10,000 10,000 10,000 real avg. Fee in keeping with premium shipment 50.00 $ fifty one.25 $ fifty two.53 $ fifty three.84 $ fifty five.19 $ actual of top rate freight shipments 10 10 10 10 10 anticipated discount in premium freight shipments 25 25 25 25 25 annual price savings 12,500 $ 12,813 $ thirteen,133 $ 13,461 $ thirteen,798 $ 65,704 $ total distribution one zero one,361 $ 103,895 $ 106,492 $ 109,155 $ 111,884 $ 532,787 $ customer support & order mgt. Improvement in performance of employees est. Avg improvement in c.S. & O.M. Worker productivity 10 10.0 10.0 10.Zero 10.0 actual annual stressed fee of employee 40,000 $ 41,000 $ 42,half $ forty three,076 $ 44,153 $ avg annual number of people in dept. The use of system 10 10 10 10 10 annual price savings 40,000 $ 41,000 $ 42,0.5 $ forty three,076 $ forty four,153 $ 210,253 $ accelerated accuracy of orders real avg annual # consumer orders 2,2 hundred 2,2 hundred 2,2 hundred 2,2 hundred 2,200 avg annual of orders which might be wrong 10 10.0 10.0 10.0 10.0 est. Discount of wrong orders 50 50 50 50 50 real returns of wrong orders 85 85 eighty five 85 85 avg price to re-inventory returns three hundred $ 308 $ 315 $ 323 $ 331 $ annual cost savings 28,050 $ 28,751 $ 29,470 $ 30,207 $ 30,962 $ 147,440 $ reduced client complaint calls actual avg annual # consumer complaint calls 5,000 five,000 5,000 five,000 5,000 est. Discount in criticism calls 50 50 50 50 50 avg price in step with grievance call 25 $ 25.63 $ 26.27 $ 26.Ninety two $ 27.60 $ annual price savings 62,500 $ 64,063 $ sixty five,664 $ sixty seven,306 $ 68,988 $ 328,521 $ general customer support / admin. A hundred thirty,550 $ 133,814 $ 137,159 $ a hundred and forty,588 $ one hundred forty four,103 $ 686,214 $ records systems development in performance of personnel est. Avg development in is employee productivity 10 10.Zero 10.0 10.0 10.Zero actual avg careworn price of worker 40,000 $ forty one,000 $ forty two,1/2 $ forty three,076 $ 44,153 $ avg annual variety of employees in dept. The use of system 10 10 10 10 10 annual value financial savings forty,000 $ forty one,000 $ forty two,1/2 $ 43,076 $ 44,153 $ 210,253 $ reduction in preservation expenses (consolidation) est. # Decommissioned structures 3 3 3 three 3 actual annual fee of software preservation contracts according to 10,000 $ 10,250 10,506 10,769 eleven,038 actual annual fee of hardware upkeep contracts in step with system 30,000 $ 30,750 $ 31,519 $ 32,307 $ 33,114 $ annual price savings a hundred and twenty,000 $ 123,000 $ 126,0.5 $ 129,227 $ 132,458 $ 630,759 $ page 31 of 39 assignment xxx enterprise case template employer integration toolkit dept. Description devices year 1 year 2 12 months 3 12 months four year five overall improvement total statistics structures one hundred sixty,000 $ 164,000 $ 168,100 $ 172,303 $ 176,610 $ 841,013 $ page 32 of 39 project xxx commercial enterprise case template business enterprise integration toolkit dept. Description units year 1 12 months 2 12 months three yr 4 12 months 5 total improvement finance/ accounting improvement in performance of personnel est. Avg improvement in finance employee productiveness 10 10.0 10.0 10.0 10.0 actual annual pressured cost of employee forty,000 $ 41,000 $ forty two,1/2 $ 43,076 $ forty four,153 $ avg annual number of employees in dept. The use of device 10 10 10 10 10 annual price financial savings forty,000 $ forty one,000 $ forty two,half $ forty three,076 $ 44,153 $ 210,253 $ placeholder real 0 - - - - actual 10 10 10 10 10 estimate 10 zero zero zero zero real 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ annual value financial savings - $ - $ - $ - $ - $ - $ general finance & accounting forty,000 $ forty one,000 $ 42,half $ forty three,076 $ 44,153 $ 210,253 $ human assets improvement in efficiency of personnel est. Avg development in hr employee productivity 10 10.0 10.Zero 10.Zero 10.Zero actual annual confused fee of worker 40,000 $ 41,000 $ 42,1/2 $ 43,076 $ 44,153 $ avg annual variety of people in dept. The usage of machine 10 10 10 10 10 annual value financial savings 40,000 $ forty one,000 $ 42,half $ forty three,076 $ forty four,153 $ 210,253 $ placeholder real 0 - - - - real 10 10 10 10 10 estimate 10 zero zero zero 0 actual 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ annual fee financial savings - $ - $ - $ - $ - $ - $ overall human assets 40,000 $ forty one,000 $ 42,1/2 $ forty three,076 $ forty four,153 $ 210,253 $ 12 months zero 12 months 1 12 months 2 year 3 yr four yr five grand total value financial savings 1,918,201 $ 1,966,156 $ 2,half,310 $ 2,008,half $ 2,039,475 $ 9,947,167 $ level 3 - real consequences 12 months zero year 1 12 months 2 year 3 yr four 12 months 5 (insert actual cost savings sub-class quantification on this space.) Grand general price savings - $ - $ - $ - $ - $ - $ (insert calculations in row bove to sum sub-classes of actual savings from rows in stage 3 phase above.) Web page 33 of 39 project xxx business case template corporation integration toolkit sales benefit estimates level 1 - excessive degree estimates 12 months 0 year 1 yr 2 year 3 yr four year five (insert high degree revenue sub-class estimates on this space.) Grand general incremental revenue - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-classes of excessive-degree sales estimates from rows in level 1 section above.) Web page 34 of 39 challenge xxx enterprise case template corporation integration toolkit stage 2 - parametric estimates dept. Description gadgets yr 1 accelerated revenues year 2 accelerated revenues yr 3 extended sales year 4 expanded sales 12 months five multiplied revenues total development income & advertising 1 elevated revenue in keeping with order 1a avg. Annual purchaser orders 2,two hundred 2,200 2,2 hundred 2,two hundred 2,200 checked actual rate according to order 2,000 $ 2,one hundred $ 2,205 $ 2,315 $ 2,431 $ checked 1b est. Boom in price in line with order five five.Zero 5.0 5.0 five.Zero checked annual sales boom 220,000 $ 231,000 $ 242,550 $ 254,678 $ 267,411 $ 1,215,639 $ checked 2 stepped forward close charge 2a avg annual # of consumer orders 2,200 2,200 2,2 hundred 2,two hundred 2,200 checked 2b purchaser order charge 2,000 $ 2,one hundred $ 2,205 $ 2,315 $ 2,431 $ checked 2c avg annual close fee 72 seventy two 72 seventy two 72 checked 2d est. Development in close charge 10 10 10 10 10 checked annual sales boom 316,800 $ 332,640 $ 349,272 $ 366,736 $ 385,072 $ 1,750,520 $ checked three shortened processing time for orders annual est. Change 3a annual customer orders 2,two hundred 2,420 2,541 2,605 2,637 checked 3b client order charge 2,000 $ 2,one hundred $ 2,205 $ 2,315 $ 2,431 $ checked three-d est. Decrease in order processing time 10 50 five.Zero 2.5 1.Three zero.6 checked 3e resulting incremental customer orders 220 121 sixty four 33 16 checked annual revenue increase 440,000 $ 254,one hundred $ one hundred forty,073 $ seventy five,377 $ 40,067 $ 949,617 $ checked four higher performance for personnel who travel annual est. Change 4a est. Development in income travel efficiency 10 50 five three 1 1 checked 4b avg annual sales in line with rep 440,000 $ 484,000 508,200 520,905 527,416 checked 4c avg annual variety of reps 10 10 10 10 10 checked annual revenue boom 440,000 $ 242,000 $ 127,050 $ 65,113 $ 32,964 $ 907,127 $ checked 5 increase in consumer retention 5a avg annual # of clients 500 500 500 500 500 checked 5b average patron loss in step with 12 months 5 5.Zero 5.Zero five.Zero five.0 checked 5c common annual revenue in line with current consumer eight,800 $ eight,800 $ eight,800 $ eight,800 $ eight,800 $ checked 5d est avg annual reduction in purchaser loss 10 10.Zero 10.Zero 10.0 10.Zero checked annual sales increase 22,000 $ 22,000 $ 22,000 $ 22,000 $ 22,000 $ a hundred and ten,000 $ checked 6 total income & advertising and marketing 1,438,800 $ 1,081,740 $ 880,945 $ 783,903 $ 747,515 $ four,932,902 $ checked customer service & order mgt. 6 improvement in market percentage due to client satisfaction annual est. Change # of present customers 500 523 521 508 488 checked 6a est. Improvement in purchaser pride 10 50 5.0 2.5 1.Three zero.6 checked 6b avg annual incremental clients 50 26 thirteen 6 3 checked 6c average annual revenue per present client 8,800 $ 8,800 8,800 eight,800 eight,800 checked annual revenue boom 440,000 $ 229,900 $ 114,663 $ 55,826 $ 26,849 $ 867,238 $ checked 7 incremental income leads surpassed by means of customer real leads exceeded in keeping with c.S. Employee one hundred fifty a hundred sixty five 182 2 hundred 220 checked 7a est. Incremental of leads handed consistent with c.S. Employee 10 10 10 10 10 checked 7b avg annual c.S. Workers the usage of new device 10 10 10 10 10 checked 7c avg annual leads that change into offers 10 10 10 10 10 checked 7d average purchaser order size 2,000 2,000 $ 2,000 $ 2,000 $ 2,000 $ checked annual sales boom 30,000 $ 33,000 $ 36,300 $ 39,930 $ forty three,923 $ 183,153 $ checked eight total customer support / admin. 470,001 $ 262,900 $ a hundred and fifty,963 $ ninety five,756 $ 70,772 $ 1,050,391 $ checked year 0 12 months 1 yr 2 12 months three yr 4 yr five grand general benefit income, mktg., C.S. & Admin. 1,908,801 $ 1,344,640 $ 1,031,907 $ 879,659 $ 818,287 $ five,983,294 $ web page 35 of 39 venture xxx enterprise case template employer integration toolkit stage three - real effects dept. Description gadgets year 1 improved revenues yr 2 extended revenues yr three extended revenues year 4 multiplied revenues year 5 accelerated revenues overall improvement (insert real sales sub-class quantifications in this area.) Grand total incremental sales - $ - $ - $ - $ - $ - $ (insert calculations in row above to sum sub-classes of real sales quantification from rows in degree 3 phase above.) Web page 36 of 39 task xxx enterprise case template corporation integration toolkit business case spreadsheet (template) sample blessings identification version financial levers operational levers essential success elements key performance signs (kpis) # of lost customers avg value in keeping with identical size p.O. # Days to fill an avg order # returns $ consistent with work order avg $ of top class frieght price/order # of criticism calls # is personnel $ annual maintenance contract price • advanced deliver chain visibility – progressed order fill charges avg days for order fill of orders crammed in much less than 1 day agency-huge fee creation boom net running profit after tax enhance capital allocation (b/s) capital deployment cost of capital increas e gross earnings decreas e operatin growth decrease manufacturin reduce lessen distribution reduce administrative fees reduce r&d boom rate boom quantity improve blend enhance reduce value of enhance plant growth decrease optimize scheduling optimize physical network lower decrease customer support & lower i/s prices lower finance/acctg. Prices lower hr improve capital reduce lessen a/p increase n/a use alternative distribution •earnings-pushed income efforts: – offer “proper” mix – enhance tactical pricing • awareness on excessive-profit debts • reduced income management • optimum manufacturing techniques • most profitable ability allocation/usage • advanced inventory flow visibility – lower transportation charges – higher centers utilization – much less “firefighting”, greater correct planning • improved customer service access to statistics – extra constant service – faster hassle decision – lower c.S. Cost • stepped forward admin. Access to facts - appreciably decrease g&a "overhead" •advanced capital stewardship – accelerated capital productiveness – reduced inventory funding & wearing charges – decreased receivables investment page 37 of 39 mission xxx commercial enterprise case template employer integration toolkit gain calculations income & advertising purchasing renovation & restore warehousing/inv entory manage logistics/ shipping/ receiving customer support & order mgt. Records structures finance/ accounting hr ($/fte) x ftes saved = reduction in hard work ($/gadget/mainte nance agt.) X structures consolidated = discount in preservation contract price web page 38 of 39 mission xxx enterprise case template business enterprise integration toolkit thesaurus method/metric definition/brief description use net gift cost (npv) is the sum of the discounted (on the cost of capital) coins flows of the mission. To examine tasks the usage of a commonplace price of capital or bargain rate. Npv does no longer explicitly reflect the uncertainty of the coins waft forecasts. Inner charge of go back (irr) is the discount price, which while implemented to the coins flows of the undertaking produces a npv same to zero. Irr affords a uniform degree for evaluating unique initiatives. It's miles a special case of npv. Payback length (aka breakeven) is the length of time required for the sum of the internet coins flows of the task to identical zero. Used to examine initiatives in terms of time to produce advantageous nominal consequences. Many corporations will no longer adopt projects which take longer than x years to "pay for themselves" parameter is an estimate or assumption furnished as enter. Allows person to tailor the commercial enterprise case template to the specific venture to hand. Tornado diagram is a set of calculations and a chart summarizing the relative have an impact on of various parameters at the described output cell. Affords preliminary analysis of the sensitivity or relative power of have an effect on of a parameter provided in three factor (minimum, satisfactory estimate, most) variety. Lets in easy visualization of parameters that convey the maximum have an impact on in a model's final results. Within the business case template, npv is typically used because the great measure of bct final results. Business case spreadsheet (template) page 39 of 39.

Business Case Template Npv Popular Source: Business Case Template Excel Excel Document Collections

Business Case Template Npv Popular Source: Business Case Template Excel Excel Document Collections

Business Case Template Npv Best Excel, Present Value Template Business Valuation Report Template Collections

Business Case Template Npv Best Excel, Present Value Template Business Valuation Report Template Collections

Business Case Template Npv Fantastic Template:, Analysis Excel Template Business Plan Spreadsheet Images

Business Case Template Npv Fantastic Template:, Analysis Excel Template Business Plan Spreadsheet Images

Business Case Template Npv Practical Data Input Parameters To Assist In Modelling, Business Case Pictures

Business Case Template Npv Practical Data Input Parameters To Assist In Modelling, Business Case Pictures

View Another plan that you might be looking for: