{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Procurement Analysis Worksheet","Annual Cost-Benefits Summary"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Annual Cost-Benefits Summary","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Procurement Analysis Worksheet","index":0,"n_rows":44,"n_cols":11,"rows_kept":44,"merged":[[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[13,2,13,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[41,2,41,3],[42,2,42,3],[42,5,42,6],[43,2,43,3],[43,5,43,6]],"flags":["formulas_cached_only"]}
[null,"[Company Name]",{"$nulls":7},"List Data:","Type of Purchase"]
[null,"Procurement Analysis Worksheet",{"$nulls":8},"Capital"]
[null,"[Date]",{"$nulls":8},"Operating"]
[]
[null,"Gray cells are calculated for you. You do not need to enter anything into them. "]
[null,"Procurement information"]
[null,"Date of purchase request"]
[null,"Requested by"]
[null,"Description of purchase"]
[null,"Type of purchase"]
[null,"Delivery date requested"]
[]
[null,"Vendor information"]
[null,"Name of vendor"]
[null,"If a formal contract is in place, indicate contract number here"]
[null,"Vendor address"]
[null,"Vendor contact number"]
[null,"Vendor contact name and title"]
[]
[null,"Investment","Year 0","Year 1","Year 2","Year 3"]
[null,"Initial investment",{"v":1200000,"d":"$1,200,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Implementation costs",{"v":400000,"d":"400,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"On-going support costs",{"v":0,"d":"0 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "}]
[null,"Training costs",{"v":50000,"d":"50,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "}]
[null,"Other costs",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total costs",{"v":1650000,"d":"$1,650,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"}]
[null,"Cumulative costs",{"v":1650000,"d":"$1,650,000"},{"v":1775000,"d":"$1,775,000"},{"v":1900000,"d":"$1,900,000"},{"v":2025000,"d":"$2,025,000"}]
[]
[null,"Benefits","Year 0","Year 1","Year 2","Year 3"]
[null,"Total benefits realized",{"v":0,"d":"$0"},{"v":1243675,"d":"$1,243,675"},{"v":1275000,"d":"$1,275,000"},{"v":1342980,"d":"$1,342,980"}]
[null,"Cumulative benefits",{"v":0,"d":"$0"},{"v":1243675,"d":"$1,243,675"},{"v":2518675,"d":"$2,518,675"},{"v":3861655,"d":"$3,861,655"}]
[]
[null,"Net flow",{"v":-1650000,"d":"(1,650,000)"},{"v":1118675,"d":"1,118,675 "},{"v":1150000,"d":"1,150,000 "},{"v":1217980,"d":"1,217,980 "}]
[null,"Cumulative net",{"v":-1650000,"d":"($1,650,000)"},{"v":-531325,"d":"($531,325)"},{"v":618675,"d":"$618,675"},{"v":1836655,"d":"$1,836,655"}]
[]
[null,"Financial measures"]
[null,"Cost of capital",{"v":0.15,"d":"15%"}]
[null,"Net present value",{"v":993167.7077340349,"d":"$993,168"}]
[null,"Payback (in years)",{"v":1.4620217391304346,"d":"1.46"}]
[]
[null,"Signatures"]
[null,"Requester",null,null,"Notes"]
[null,"Approver—Level 1",null,null,"If request is denied, please indicate reason."]
[null,"Approver—Level 2 (if required)",null,null,"Please provide any other notes regarding the procurement request."]