ࡱ> ih Fɀ\pJennifer Bebermeyer Ba= =.8X@"1Courier1Arial1Arial1Arial1Arial1Courier1Courier1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)#. dd\-mmm\-yy_) 0.0%0.0                + ) , *       a@   $  !     #    #  !  "  "     #   Date Fixed Heading1 Heading2 Total`CBA Current Process ECBA Alternative 1zCBA Alternative 2  ;[  ;Z  ;[  ;[' Print_Area_MI;' Print_Area_MI;' Print_Area_MI;' PRINT_AREA_MI;  ;  ;  ;TG=-Relocation ExpenseStaff TrainingTOTAL ONE-TIME COSTSRecurring CostsNetwork AdminstrationTOTAL RECURRING COSTTOTAL ANNUAL COST(One-Time and Recurring)BENEFITSStaff Savings and Avoidance STAFF SAVINGS!Operational Savings and AvoidanceFormsTOTAL OPERATIONAL SAVINGSTOTAL ANNUAL BENEFITSNET BENEFIT (COST)SUMMARY-------------------ONE-TIME COSTSRECURRING COSTS ---------- ==========TOTALSFY 1SFY 2SFY 3SFY 4SFY 5SFY 6 EquipmentSoftwareLicenseState Development StaffContractor Development StaffVendor/Consultant Costs FacilitiesCommunications Installation+<>Equipment MaintenanceSoftware SupportAnnual Licensing FeeSystem maintenance/enhancementsCommunicationsSecurityInfo-Tech ChargesOperations Costs,<>Division Staff Supervisory StaffOvertimeAvoid Hiring New StaffSpacePostage*Elimination/reduction in Maintenance CostsReduced Info-Tech Charges*<>3<> PROJECT NPVRevenue ChangesExpected increase fees paid3<>COSTSOne-Time CostsTOTAL REVENUE SAVINGS(Staff + Operational + Revenue)(Operational + Staff + Revenue) PROJECT IRRPayback Occurs in YearIRRJ H B   .x0+ Fɀ  e%|4 CC  dMbP?_*+%,d91"\027E\027&l0o8C\027(s17H\027&k7.2H&J &C&15&A &D(%&LCIO-13287-E&C&"Arial,Regular"&P&R&D(RQ?)Gz?MAcrobat DistillerS oE,,LetterPRIV0''''(\KhC(EBDAeBook"E,,?Q?U} &}  } } } }  }  e,h@h@h@,h@h@h@ h@ h@ h@ h@ h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@ h@        "?  !@  * -?  * !*  "*    #*    $*    *    %*   &*  '               ! -!!!!! !  (* -? )* * ** +* ,* -* .* /* 0*!D+ lb,,v[[[[[[[[b,,v[[[[[[[[[!h@"h@#h@$h@%h@&h@'h@(h@)h@*h@+h@,h@-h@.h@/h@0h@1h@2h@3h@4h@5h@6h@7h@8h@9h@:h@;h@<h@=h@>h@?h@@h@ !!#!!! -?!#!!#!!#!!#!!#!!#! "  "  "  "  "  "  "  #!#P DD!#P### LL#P##P##P##P##P# $ $  $  $  $  $  $  $ % &" & '' (! ( )) *1**#*+ %**? +2*+#+, %++? ,3*,#,- %,,? -4*-#-. %--? .:*.#.0 %..? /  /  /  /  /  /  /  0 #0; %*.R;0;000 -R;0;00;00;00;00401 2! 2 33 48*445449 -? 57*5564 6*6674 75*7784 86*8894 99*99;4 :  :  :  :  :  :  :  ;#;B %49R;;B;;; -R;;B;;B;;B;;B;;?; =!<= >> ?=*?#?@ %??? @>*@#@B %@@?Dlbp&&&&cccccb &&v[[[[[b &&cAh@Bh@Ch@Dh@Eh@Fh@Gh@Hh@Ih@Jh@Kh@Lh@Mh@Nh@Oh@Ph@Qh@Rh@Sh@Th@Uh@Vh@Wh@Xh@Yh@Z,[h`\h@]h@^h@_h@`h@ A  A  A  A  A  A  A  BA#BD %5@BDBBB -BDBBDBBDBBDBBDB D'DSD0D;DBDSDDDLLLDSDDSDDSDDSDDSD EB E  E  E  E  E  E  E F GG GGG LLGNGGGGGGGGGGGGGGGG H  H  H  H  H  H  H I J# JJ KK LLGLLLLLNLLNLLNLLNLLNLLNLM NNLNNNLNLNNLNNLNNLNNLNNLN PPVPPPLPVPPVPPVPPVPPVPPVP Q  Q  Q  Q  Q  Q  Q R SSSSSLSSSSSSSSSSSS TC T  T  T  T  T  T  T U VV0VVV LLV0VV0VV0VV0VVYVVGV W  W  W  W  W  W  W X  Y';1Y%[)\(@@%VVB Y Z'E [&F#[%$ * %UUB>D\lb pb.&bp bW5ah@bh@ch@dh@ P< ;0 >9@K ????mPXI 0, 0 0xL  0x 0? `hܕq 0qq      7 Fɀ  dMZ}i xx  dMbP?_*+%,d91"\027E\027&l0o8C\027(s17H\027&k7.2H&J &C&15&A &D(%&LCIO-13287-E&C&"Arial,Regular"&P&R&D(RQ?)Gz?MAcrobat DistillerS oE,,LetterPRIV0''''(\KhC(EBDAeBook"E,,?Q?U} &}  } } } }  }  d,h@h@h@,h@h@h@ h@ h@ h@ h@ h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@ h@        "?  !@  * -?  * !*  "*    #*    $*    *    %*   &*  '               ! -!!!!! !  (* -? )* * ** +* ,* -* .* /* 0*!D+ lb,,v[[[[[[[[b,,v[[[[[[[[[!h@"h@#h@$h@%h@&h@'h@(h@)h@*h@+h@,h@-h@.h@/h@0h@1h@2h@3h@4h@5h@6h@7h@8h@9h@:h@;h@<h@=h@>h@?h@@h@ !!#!!! -?!#!!#!!#!!#!!#!!#! "  "  "  "  "  "  "  ##P### LL#P##P##P##P##P##P# $ $  $  $  $  $  $  $ % &" & '' (! ( )) *1**#*+ %**? +2*+#+, %++? ,3*,#,- %,,? -4*-#-. %--? .:*.#.0 %..? /  /  /  /  /  /  /  0 0;000 -R;0;00;00;00;00;00401 2! 2 33 48*445449 -? 57*5564 6*6674 75*7784 86*8894 99*99;4 :  :  :  :  :  :  :  ;;B;;; -R;;B;;B;;B;;B;;B;;?; =!<= >> ?=*?#?@ %??? @>*@#@B %@@?Dllbp&&&&cccccb&&v[[[[[b&&cAh@Bh@Ch@Dh@Eh@Fh@Gh@Hh@Ih@Jh@Kh@Lh@Mh@Nh@Oh@Ph@Qh@Rh@Sh@Th@Uh@Vh@Wh@Xh@Yh@Z,[h`\h@]h@^h@_h@`h@ A  A  A  A  A  A  A  BABDBBB -BDBBDBBDBBDBBDBBDB DDSDDDLLLDSDDSDDSDDSDDSDDSD EB E  E  E  E  E  E  E F GGP1GGG LLGNGGGGGGGGGGGGGGGG H  H  H  H  H  H  H I J# JJ KK LLGLLLLLNLLNLLNLLNLLNLLNLM NNLNNNLNLNNLNNLNNLNNLNNLN PPVPPPLPVPPVPPVPPVPPVPPVP Q  Q  Q  Q  Q  Q  Q R SSSSSLSSSSSSSSSSSS TC T  T  T  T  T  T  T U VV0VVV LLV0VV0VV0VV0VVYVV[V W  W  W  W  W  W  W X Y';1Y%*)\(@@%VVB Y Z'E [&F#[%$ G %VVB>DFlbpb.&bp bW5ah@bh@ch@ <( 0G >9@KZZZ????m (hp@HI 0,ZZ 0 0xL   0x 0 ? `hܕq 0qq      7 Fɀ  ea  dMbP?_*+%,d61"\027E\027&l0o8C\027(s17H\027&k7.2H&J &C&15&A &D74&L&9CIO-13287-E (N. 07/2002)&C&"Arial,Regular"&P&R&D(RQ?)Gz?MAcrobat DistillerS oE,,LetterPRIV0''''(\KhC(EBDAeBook"E,,?Q?U} &}  } } } }  }  e,h@h@h@,h@h@h@ h@ h@ h@ h@ h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@ h@        "?  !@  * -?  * !*  "*    #*    $*    *    %*   &*  '               ! -!!!!! !  (* -? )* * ** +* ,* -* .* /* 0*!D+ lb,,v[[[[[[[[b,,v[[[[[[[[[!h@"h@#h@$h@%h@&h@'h@(h@)h@*h@+h@,h@-h@.h@/h@0h@1h@2h@3h@4h@5h@6h@7h@8h@9h@:h@;h@<h@=h@>h@?h@@h@ !!#!!! -?!#!!#!!#!!#!!#!!#! "  "  "  "  "  "  "  ##P### LL#P##P##P##P##P##P# $ $  $  $  $  $  $  $ % &" & '' (! ( )) *1**#*+ %**? +2*+#+, %++? ,3*,#,- %,,? -4*-#-. %--? .:*.#.0 %..? /  /  /  /  /  /  /  0 0;000 -R;0;00;00;00;00;00401 2! 2 33 48*445449 -? 57*5564 6*6674 75*7784 86*8894 99*99;4 :  :  :  :  :  :  :  ;;B;;; -R;;B;;B;;B;;B;;B;;?; =!<= >> ?=*?#?@ %??? @>*@#@B %@@?Dllbp&&&&cccccb&&v[[[[[b&&cAh@Bh@Ch@Dh@Eh@Fh@Gh@Hh@Ih@Jh@Kh@Lh@Mh@Nh@Oh@Ph@Qh@Rh@Sh@Th@Uh@Vh@Wh@Xh@Y@Z@[h`\h@]h@^h@_h@`h@ A  A  A  A  A  A  A  BABDBBB -BDBBDBBDBBDBBDBBDB DDSDDDLLLDSDDSDDSDDSDDSDDSD EB E  E  E  E  E  E  E F GGAGGG LLGNGGGGGGGGGGGGGGGG H  H  H  H  H  H  H I J# JJ KK LLGLLLLLNLLNLLNLLNLLNLLNLM NNLNNNLNLNNLNNLNNLNNLNNLN PPVPPPLPVPPVPPVPPVPPVPPVP Q  Q  Q  Q  Q  Q  Q R SSSSSLSSSSSSSSSSSS TC T  T  T  T  T  T  T U VV0VVV LLV0VV0VV0VV0VVYVV[V W  W  W  W  W  W  W X Y';1Y%*)\(@@%VVB Y Z'E [D#[$$ G %VVB>[DZlbpb.&bp bWIah@bh@ch@dh@ P<;0 0G >6@KYYY????m@X`tI 0,tYYt 0 0xL t 0 x 0? ܕq 0qq      7 Oh+'0 hp(   CBA Spreadsheet CIO-13287-ERose Lynch; 608-266-6753icr_CBA, One-time, Recurring, NPV, Payback, Savings, Avoidance, Revenue Changes, Net Present ValueThe spreadsheet is used to determine the costs, benefits, net present value and payback period for each alternative solution examined.Jennifer BebermeyerMicrosoft Excel@*Qk%@@sk%՜.+,0 `h  Stage 3, Project JustificationEllen Vogel; 608-266-5863tiDWD CIO Office8A  CBA Current Process CBA Alternative 1CBA Alternative 2'CBA Alternative 1'!Print_Area'CBA Alternative 2'!Print_Area"'CBA Current Process '!Print_Area"'CBA Alternative 1'!Print_Area_MI"'CBA Alternative 2'!Print_Area_MI%'CBA Current Process '!Print_Area_MI!'CBA Alternative 1'!Print_Titles!'CBA Alternative 2'!Print_Titles$'CBA Current Process '!Print_Titles  Worksheets Named Ranges   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWYZ[\]^_abcdefgRoot Entry FWorkbookӯSummaryInformation(XDocumentSummaryInformation8`