| Cost-benefit Analysis: Template for Mobile Job Centers |
| Escalation rate (ex. technology) | 3% |
| % still employed the next year | 50% |
| # of Buses | 9 |
| Host site agreements per bus | $20,000 |
| Purchase/outfitting per bus | $175,000 |
| Fuel/maint./cleaning per bus | $10,000 |
| Technology leasing per bus | $8,000 |
| Supplies and printing per bus | $6,000 |
| Insurance | $25,000 |
| Driver compensation | $55,000 |
| Placement spec. compensation | $65,000 |
| Director compensation | $90,000 |
| Project office+tech (1-3 buses) | $7,500 |
| Project office+tech (4-6 buses) | $15,000 |
| Project office+tech (7-9 buses) | $18,750 |
| Dir. assistant compensation | $50,000 |
| Sup'v compensation (>3 buses) | $75,000 |
| Sup'v assistant compensation | $45,000 |
| Budget analyst (>6 buses) | $70,000 |
| | | Computation of intial benefit |
| Applicants placed per bus for | first 3 (1-3 buses) | 312 | Add'l taxable income for full year employed |
| Applicants placed per bus for | next 3 (4-6 buses) | 234 | (operational year) | $20,000 |
| Applicants placed per bus for | last 3 (7-9 buses) | 156 | (transition year) | $10,000 |
| | | | $3,120,000 | $99,840 |
| $20K per placement*312 per bus*0.5 (average 1/2 year employed) | | | $20K*312*0.5=$3,120,000 | *3.2% =$99,840 |
| /|\ per bus taxable income: 1st-time placements (not residual) | | | /|\ per bus taxable income | /|\ per bus tax |
| One-Time Costs |
| Description | Quantity | Unit cost | | Transition Year |
| Host site agreements per bus | 9 | $20,000 | | $ 180,000 |
| Purchase/outfitting per bus | 9 | $175,000 | | $ 1,575,000 |
| Recurring Costs |
| Description | Quantity | Trans. year unit cost | Op'l year unit cost | Transition Year | Op'l Yr 1 | Op'l Yr 2 | Op'l Yr 3 | Op'l Yr 4 | Op'l Yr 5 | Op'l Yr 6 | Op'l Yr 7 | Op'l Yr 8 |
| Technology leasing per bus | 9 | $4,000 | $8,000 | $ 36,000 | $ 72,000 | $ 72,000 | $ 72,000 | $ 72,000 | $ 72,000 | $ 72,000 | $ 72,000 | $ 72,000 |
| Fuel/maint./cleaning per bus | 9 | $5,000 | $10,000 | $ 45,000 | $ 92,700 | $ 95,481 | $ 98,345 | $ 101,296 | $ 104,335 | $ 107,465 | $ 110,689 | $ 114,009 |
| Supplies and printing per bus | 9 | $3,000 | $6,000 | $ 27,000 | $ 55,620 | $ 57,289 | $ 59,007 | $ 60,777 | $ 62,601 | $ 64,479 | $ 66,413 | $ 68,406 |
| Insurance | 9 | $12,500 | $25,000 | $ 112,500 | $ 231,750 | $ 238,703 | $ 245,864 | $ 253,239 | $ 260,837 | $ 268,662 | $ 276,722 | $ 285,023 |
| Driver compensation | 9 | $27,500 | $55,000 | $ 247,500 | $ 509,850 | $ 525,146 | $ 540,900 | $ 557,127 | $ 573,841 | $ 591,056 | $ 608,788 | $ 627,051 |
| Placement spec. compensation | 9 | $32,500 | $65,000 | $ 292,500 | $ 602,550 | $ 620,627 | $ 639,245 | $ 658,423 | $ 678,175 | $ 698,521 | $ 719,476 | $ 741,060 |
| Director compensation | 1 | $90,000 | $90,000 | $ 90,000 | $ 92,700 | $ 95,481 | $ 98,345 | $ 101,296 | $ 104,335 | $ 107,465 | $ 110,689 | $ 114,009 |
| Dir. assistant compensation | 1 | $50,000 | $50,000 | $ 50,000 | $ 51,500 | $ 53,045 | $ 54,636 | $ 56,275 | $ 57,964 | $ 59,703 | $ 61,494 | $ 63,339 |
| Project office+tech (7-9 buses) | 1 | $18,750 | $18,750 | $ 18,750 | $ 19,313 | $ 19,892 | $ 20,489 | $ 21,103 | $ 21,736 | $ 22,388 | $ 23,060 | $ 23,752 |
| Sup'v compensation (>3 buses) | 1 | $75,000 | $75,000 | $ 75,000 | $ 77,250 | $ 79,568 | $ 81,955 | $ 84,413 | $ 86,946 | $ 89,554 | $ 92,241 | $ 95,008 |
| Sup'v assistant compensation | 1 | $45,000 | $45,000 | $ 45,000 | $ 46,350 | $ 47,741 | $ 49,173 | $ 50,648 | $ 52,167 | $ 53,732 | $ 55,344 | $ 57,005 |
| Budget analyst (>6 buses) | 1 | $70,000 | $70,000 | $ 70,000 | $ 72,100 | $ 74,263 | $ 76,491 | $ 78,786 | $ 81,149 | $ 83,584 | $ 86,091 | $ 88,674 |
| Recurring Benefits |
| Description | Quantity | Trans. year unit benefit | Op'l year unit benefit | Transition Year | Op'l Yr 1 | Op'l Yr 2 | Op'l Yr 3 | Op'l Yr 4 | Op'l Yr 5 | Op'l Yr 6 | Op'l Yr 7 | Op'l Yr 8 |
| "Seed" grant | 1 | $600,000 | $300,000 | $ 600,000 | $ 309,000 | $ 318,270 | $ 327,818 | $ 337,653 | $ 347,782 | $ 358,216 | $ 368,962 | $ 380,031 |
| Employment benefit | 9 | $18,720 | $74,880 | $ 168,480 | $ 694,138 | $ 714,962 | $ 736,411 | $ 758,503 | $ 781,258 | $ 804,696 | $ 828,837 | $ 853,702 |
| Residual employment benefit | NOTHING ENTERED IN THESE CELLS | | 2106 | $ - | $ 694,138 | $ 1,072,443 | $ 1,288,719 | $ 1,422,193 | $ 1,513,687 | $ 1,584,245 | $ 1,644,723 | $ 1,700,734 |
| Number of new/resdidual employees | | | annual new employees /|\ | residual employees--> | 1053.0 | 1579.5 | 1842.8 | 1974.4 | 2040.2 | 2073.1 | 2089.5 | 2097.8 |
| Disc. factors: formulas divide by (1+disc. rate) ====> | | | 5.00% | 1 | 0.952 | 0.907 | 0.864 | 0.823 | 0.784 | 0.746 | 0.711 | 0.677 |
| Present Value | | | | Transition Year | Op'l Yr 1 | Op'l Yr 2 | Op'l Yr 3 | Op'l Yr 4 | Op'l Yr 5 | Op'l Yr 6 | Op'l Yr 7 | Op'l Yr 8 | Total |
| Present Value of Benefits | | | | $ 768,480 | $ 1,616,453 | $ 1,909,909 | $ 2,032,564 | $ 2,071,852 | $ 2,070,646 | $ 2,049,970 | $ 2,020,127 | $ 1,986,162 | $ 16,526,163 |
| Present Value of Costs | | | | $ 2,864,250 | $ 1,832,079 | $ 1,795,223 | $ 1,759,162 | $ 1,723,877 | $ 1,689,349 | $ 1,655,559 | $ 1,622,490 | $ 1,590,123 | $ 16,532,111 |
| Net Present Value | | | | $ (2,095,770) | $ (215,626) | $ 114,686 | $ 273,402 | $ 347,974 | $ 381,297 | $ 394,411 | $ 397,637 | $ 396,039 | $ (5,948) |
| Benefit/Cost Ratio=======================> | | 1.000 | | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ annual PV | /|\ Total PV |
| | | | | Transition Year | Op'l Yr 1 | Op'l Yr 2 | Op'l Yr 3 | Op'l Yr 4 | Op'l Yr 5 | Op'l Yr 6 | Op'l Yr 7 | Op'l Yr 8 | Entire project |
| | | | Cumulative NPV through… | $ (2,095,770) | $ (2,311,396) | $ (2,196,710) | $ (1,923,308) | $ (1,575,333) | $ (1,194,036) | $ (799,625) | $ (401,988) | $ (5,948) |
Vicky-shema
CBA_WorkedforMobileJobCenters_9buses_revised_.xlsx
