MARS BUDGET ANALYSIS OCTOBER 2020.PDF
Extracted text (via pymupdf)
7389 characters
Previous Vendor Project Costs Actuals thru FY20 6,787,341 $ 6,787,341 $ ESRI Canada Project Costs Actuals thru FY20 FY21 Budget FY21 Projected FY21 Additional Request FY22 Adopted CIP FY22 Total Request FY22 Additional Request FY 23 Total Additional ESRI-C Total Project Project Management 845,124 $ - $ - $ 845,124 $ Software 904,561 $ - $ 904,561 $ Deliverables 5,464,987 $ 1,080,005 $ 1,865,762 $ 785,757 $ 1,509,116 $ 1,776,880 $ 267,764 $ 476,000 $ 1,529,521 $ 9,583,629 $ Travel 176,254 $ 100,000 $ 30,000 $ (70,000) $ 70,580 $ 70,580 $ 580 $ 276,834 $ Project Totals 7,390,926 $ 1,180,005 $ 1,895,762 $ 715,757 $ 1,509,116 $ 1,847,460 $ 338,344 $ 476,000 $ 1,530,101 $ 11,610,148 $ Other Professional Services Actuals thru FY20 FY21 Budget FY21 Projected FY21 Additional Request FY22 Total Request FY22 Additional Request FY 23 Total Additional Consulting Total Project Project Consulting 452,390 $ 90,000 $ 74,000 $ (16,000) $ 74,000 $ 74,000 $ 58,000 $ 600,390 $ Total Other Professional Services 452,390 $ 90,000 $ 74,000 $ (16,000) $ 74,000 $ 74,000 $ - $ 58,000 $ 600,390 $ Total Direct Project Costs Actuals thru FY20 FY21 Budget FY21 Projected FY21 Additional Request FY22 Total Request FY22 Additional Request FY 23 Total Additional Direct Total Project 14,630,657 $ 1,270,005 $ 1,969,762 $ 699,757 $ 1,921,460 $ 1,921,460 $ 476,000 $ 1,588,101 $ 18,997,879 $ FY21 Budget FY21 Projected FY21 Additional Request FY22 Total Request FY22 Additional Request FY 23 Total Additional Contingency 10% of Project Budget 390,569 $ 322,491 $ (68,078) $ 372,569 $ 372,569 $ 128,704 $ 433,194 $ Indirect Costs Actuals thru FY20 FY21 Budget FY21 Projected FY21 Additional Request FY22 Total Request FY22 Additional Request FY 23 Total Additional Indirect Total Project Internal Staff 4,213,120 $ 818,616 $ 990,332 $ 171,716 $ 1,029,945 $ 1,029,945 $ 257,486 $ 1,459,147 $ 6,490,883 $ Contract Labor 1,623,511 $ 360,072 $ 252,813 $ (107,259) $ 479,213 $ 479,213 $ 119,803 $ 491,757 $ 2,475,340 $ Travel 60,056 $ 12,000 $ 12,000 $ - $ 12,000 $ 12,000 $ 12,000 $ 84,056 $ Total Indirect Costs 5,896,687 $ 1,190,688 $ 1,255,145 $ 64,457 $ 1,521,158 $ 1,521,158 $ 377,289 $ 1,962,904 $ 9,050,279 $ Total Direct & Indirect Project Costs Actuals thru FY20 FY21 Budget FY21 Projected FY21 Additional Request FY22 Adopted CIP FY22 Total Request FY22 Additional Request FY 23 Total Additional Project Need Total Project 20,527,344 $ 2,851,262 $ 3,547,397 $ 696,135 $ 1,509,116 $ 3,815,187 $ 2,306,071 $ 981,993 $ 3,984,200 $ 28,871,921 $ Contingency (budget only; actuals reflected in lines where spent) Ongoing Costs FY21 Budget FY21 Projected FY21 Additional Request FY22 Forecast FY22 Total Request FY22 Additional Request FY 23 FY 25 FY 24 Software Subscription - $ 263,069 $ 263,069 $ 393,750 $ 393,750 $ 393,750 $ Azure Maintenance - $ 20,000 $ 20,000 $ 40,000 $ 40,000 $ 40,000 $ Total ESRI CA Ongoing Costs - $ - $ - $ 283,069 $ 433,750 $ 433,750 $ 433,750 $ Cloud Services 240,000 $ 300,000 $ 60,000 $ 480,000 $ 600,000 $ 120,000 $ 600,000 $ 600,000 $ 600,000 $ Total Ongoing Costs 240,000 $ 300,000 $ 60,000 $ 480,000 $ 883,069 $ 120,000 $ 1,033,750 $ 1,033,750 $ 1,033,750 $ FY 26 FY 27 FY 28 FY 29 FY 30 FY 31 FY 32 FY 33 FY 34 FY 35 FY 36 1st half FY 37 393,750 $ 582,750 $ 835,900 $ 877,700 $ 921,600 $ 967,700 $ 1,016,100 $ 1,066,900 $ 1,120,200 $ 1,176,200 $ 1,235,000 $ 632,550 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 20,000 $ 433,750 $ 622,750 $ 875,900 $ 917,700 $ 961,600 $ 1,007,700 $ 1,056,100 $ 1,106,900 $ 1,160,200 $ 1,216,200 $ 1,275,000 $ 652,550 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 600,000 $ 300,000 $ 1,033,750 $ 1,222,750 $ 1,475,900 $ 1,517,700 $ 1,561,600 $ 1,607,700 $ 1,656,100 $ 1,706,900 $ 1,760,200 $ 1,816,200 $ 1,875,000 $ 952,550 $