|
A Crowe Horvvath.
<br /> Mr. Steven Bocian Page 23
<br /> December 23, 2013
<br /> Pleasanton Garbage Service,Inc.
<br /> Rate Model With Crowe Adjustments
<br /> Calendar Years 2013 and 2014
<br /> PGS Crowe
<br /> CY2013 CY2014 I _ _ _C_ L Y2013_ _ I CY2014
<br /> Estimated Projected I Estimated 1 Adjustment 1 L Projected 'Adjustment�
<br /> Revenue
<br /> Service billings $22L522;544 I$1522544., $22,518,568 $ (3,976) $22,518,568 $ (3,976)
<br /> Other r$_ 308,6451$ 312337 i $ 318,079 $ 9,434 $ 322,010 $ 9,673
<br /> Total revenue $22,831,189 I$22834,881 I $22,836,647 $ 5,458 $22,840,578 $ 5,697
<br /> Expense
<br /> ROE Incentive Expenses _ _
<br /> Salaries&Wages �$ 5,153,2331$ 5,327,201 1 $ 5,137,331 $ (15,902) $ 5,272,601 $ (54,600)
<br /> Dump/Tip/Diversion 1$ 850,627_ 1$_ 876,1461 $ 829,573 $ (21,054) $ 833,152 $ (42,994)
<br /> Haul,Cleanup,Grinding,Process 1$ 2150_189 x•$2,200,4811 $ 1,737,633 $ (412,556) $ 1,782,116 $(418,365)
<br /> r I
<br /> Insurance I$'_607855 $ 626,091 $ 607,849 $ (6) $ 623,410 $ (2,681)
<br /> Depreciation F.$_ 6 i
<br /> L$. .9]1,028 924.665 $ 900,315 $ (10,714) $ 903,237 $ (21,428)
<br /> Repairs&Maintenance 1$ 2,965_730,.$_3,054,722,, $ 2,814,884 $ (150,846) $ 2,886,945 $(167,757)
<br /> Interest Expense I$ _ 85_340 L$_ _77;755•, $ 85,340 $ - $ 77,755 $ -
<br /> Employee Benefits 1$' 9,786.383 L$_1;879,3661 $ 1,767,426 $ (18,957) $ 1,858,578 $ (20,788)
<br /> Postage&Office Expense 11. 262,643 1.$ .270;523 1 $ 264,022 $ 1,379 $ 270,781 $ 258
<br /> Fuel&Oil r$_ _894,5_95J,$ _921,4331 $ 838,578 $ (56,017) $ 860,046 $ (61,387)
<br /> Legal&Accounting r$ 495,257_1$ _510;115 I $ 442,314 $ (52,943) $ 453,637 $ (56,478)
<br /> r - -
<br /> Taxes&Licenses $_ 603,7511$ 6237495 I $ 606,137 $ 2,388 _.. $ 621,930 $ (1,56$)
<br /> Land Use $ 189,120 1$ 194,794 I $ 189,120 $ - $ 194,794 $ -
<br /> Other Expense F$_ 586,975 I$ 602,119 I $ 586,975 $ - $ 802,002 $ (117)
<br /> Return on Equity(ROE) $_ 941,6_22_1$ 809,834 1 $ 941,622 $ - $ 809,834 $ -
<br /> Corporate Taxes �$ 705,722 1$ 606,951 1 $ 705,722 $ - $ 606,951 $ -
<br /> Cost Reimbursement Expenses $ $
<br /> Landfill Closure&Maintenance Expenses I$ _140_319 1$ 144,529 1 $ 139,720 $ (599) $ 143,296 $ (1;232)
<br /> Recycling.Subsidy-CARI I$ 1,486_496 $_ 1,_565,3_51 $ 1,486,496 $ - $ 1,538,967 $ (26;384)
<br /> Regulatory Costs(Dump Cost>$9.00/Ton) I$ 2,1_60_650 r$2,225,470 $ 2,141,164 $ (19,486) $ 2,213,211 $ (12,259)
<br /> Trans.Stn.Compliance-Interest Expense I$ _ 32_739 $_ _27,322 $ 32,739 $ - $ 27;322 $ -
<br /> Trans.Stn.Expansion-Interest Expense 1$ 18,722 L$ 1-$-,a44 $ 18,722 $ - $ 15,624 $ -
<br /> YID FY 03/09 Recoverable Deficit I$ _848,231 L$_ 848,231, $ 848,231 $ - $ 848,231 $ -
<br /> City Franchise Fee I$ _450_451 L$_ 490_,201 $ 473,383 $ 22,932 $ 478,458 $ (11,743)
<br /> Operational&Efficiency Study I$ 73,875 L$ - . $ 73,875 $ -
<br /> Total '$24,401,553_1$24,822,3981 $23,669,169 $ (732,384) $23,922,877 $(899,521)
<br /> 2013 2014 2013 . 2014
<br /> Revenue Excess/(Shortfall) $(1,570,364) $(1,987,517) $(1,150,601) $(1,082,299)
<br /> Years to Recover 5.5 1.0 5.5 1.0
<br /> Revenue per Year to Recover $ (285,521) $(1,987,517) $ (209,200) $(1,082,299)
<br /> Percent Change 1.27% 8.82% 0.93% 4.81%
<br /> PGS Requested Crowe Adjusted
<br /> Requested and Recommended Rate Adjustment CY 2012 2.06% 2.06%
<br /> CY 2013 1.27% 0.93%
<br /> CY 2014 8.82% 4.81%
<br /> Total 12.15% 7.8
<br />
|