Loading...
HomeMy WebLinkAbout20150901AVU to Staff 1 Attachment B.xlsAuthorized FERC Accounts RRC Instructions Our Focus Notes ID Rec Adjustment ID LCA IDmonthly ID summary WA RCC WA monthly WA summary Instructions Directions WA act vs auth WA bud vs auth AVARpt DefRpt GLAccts IDAVARpt IDRevRpt INputs WAAVARpt Line No. Actual 555 Purchased Power 501 Thermal Fuel 547 CT Fuel 447 Sale for Resale Authorized Net Expense Actual - Authorized Net Expense ACTUAL TOTAL Adjusted Actual Net Expense AUTHORIZED NET EXPENSE - SYSTEM 90% of Net Power Cost Change AUTHORIZED NET EXPENSE-SYSTEM 555 PURCHASED POWER Rocky Reach Wanapum Wells Small Power Non-Mon. Accruals 501 FUEL-DOLLARS Kettle Falls wood coal Colstrip 547 FUEL 447 SALES FOR RESALE Short-Term Sales 501 FUEL-TONS Colstrip 501 FUEL-COST PER TON Nichols Pumping Index Sale Boulder Park WPM Ancillary Services Merchant Ancillary Services WASHINGTON POWER COST DEFERRALS IDAHO POWER COST DEFERRALS Authorized Variance SYSTEM Retail Revenue Credit MWH Total Hydro Generation Kettle Falls-Wood Kettle Falls CT Gas Northeast CT Rathdrum Coyote Springs 2 Total Thermal 100 % Net Power Cost Increase (Decrease) 90% Net Power Cost above $9.0 million Company Band average short-term purchase price average short-term sales price Pend Oreille DES Peaker LLC/PGE Cap Sale TOTAL NET EXPENSE NO Amount in excess of $9.0 million Company Band?? Authorized Net Expense Settlement/Compliance Filing Adj. Credit CS2 1/2 Exchange WASHINGTON ALLOCATION @ 65.16% budget Potlatch 62 aMW directly assigned Potlatch 62 aMW directly assigned. CUMULATIVE YTD gas price $/dth Heat Rate BTU/MWh $/MWh gas rate CS2 Fuel Variance RRC Variance PV on Auth surplus/deficiency balancing the system KF Fuel Variance Colstrip Fuel Variance LADWP margin Douglas Settlement Reserve Sales + Asset Optimization Forward Sales MWh Forward Sales Rate Forward Purchase MWh Forward Purchase Rate SYSTEM TOTAL CS2 Transportation lowers def Washington Share @ 65.16% incr def Forward Sales $ not included in Authorized Forward Purchase $ not included in Authorized Native Load (Budget is net 40 aMW for Potlatch) KF MWh Variance Colstrip MWh Variance CS2 MWh Variance Boulder Park Fuel Variance Boulder Park MWh Variance when expense is higher, increases the deferral Hydro Average MW Native Load Average MW Hydro Variance @ 65.16% Other Load Variance @ 65.16% Total increase in deferral before RRC Washington Share + = increase deferral CS2 gas price $/DTH input and up check #-should be zero Deferral Amount, Monthly 565 Transmission Expense 557 Broker Fees Company Band Gross Margin Impact, Cumulative Kettle Falls fuel expense Colstrip fuel expense CS2 fuel expense Boulder Park fuel expense CS2 transportation Colstrip oil YTD Adjusted Net Expense KFCT fuel expense Stimson Lumber Soverign/Kaiser Load Following Rathdrum fuel expense SYS VAR WA SHARE $ IMPACT NET WNP3 Small Pwr Upriver AUTH Grant Displacement egy PPM Wind 2007 ANNUAL SMUD 50 and 25 SMUD 50 + 25 SMUD margin Stimson average ST purchase price average ST sales price SYS VARIANCE Colstrip $/MWh company absorbed WA ALLOCATION @ 65.83% 456 Transmission Revenue RRC-WA Share MWh Thompson River Northeast fuel expense Thompson River Co-Gen ACT BPA NT 555 + 447 Seattle + Douglas Capacity Payment small power receive less from customers Northwest Energy capacity revenue Priest Rapids Products/Grant Displ () = lowers deferral + = increases deferral NET SALES/PURCHASES Native Load less Potlatch gen lowers deferral 456100 ED AN 565000 ED AN 565710 ED AN Well's Tribe Grant Residential Exchg Credit Fiancial Swap out of money wnp3 Colstrip Oil-501160 Colstrip Coal-501140 Resource Optimization Clearwater (PFI) WNP3 Mid Point WA ERM / ID PCA WNP#3 needs adjustment for Mid Point in WA (Vol's from PTR) KFGS Hog Fuel and Colstrip Coal tons burned input form JV's Most data entry occurs on the WA Monthly tab (highlighted yellow) The ID Monthly tab then links as appropriate. deferral calculations (highlighted green). GL Wand updates are added for each specific account used in the on the WA & ID Summary tabs. Kettle Falls CT-547211 Boulder Park-547216 Coyote Springs2-547610 Rathdrum CT-547310 Econ Dispatch-557150 Gas Bookouts-557700 Fuel Dispatch-456015 Fuel Bookouts-456720 NE CT Gas/Oil-547213 565 Transmission Exp 456 Transmission Rev RESOURCE OPTIMIZATION Specific deal activity is input for 447 and 555 from NUCUT PTR or Sales and G&P reports. Overrides of GL can occur if necessary for all accounts 456016 rev's and 557160 exp's may require overides for special circumstances Clearwater Revenue 100% actual Clearwater Revenue 100% authorized Less Clearwater directly assigned to ID Clearwater Purchase @ 100% authorized Clearwater Purchase @ 100% actuals Lancaster-547312 565312 ED AN Lancaster Net Resource Optimization Net Power Cost (+) Surcharge (-) Rebate If new accounts added to GL etc make sure they are added/excluded as appropriate Fed Prod Tax credit for ID comes from J McCauley-Corp Authorized levels come from Bill Johnson after Gen Rate case settlements. Carbon Credits - ID only Res Opt - gas Lancaster Costs tracked seperately PCA - 100% of fixed PPA, Transmission, Pipeline charges identified. Backed out 100% in ID System costs, ID share added back in after 90/10 split. WA excludes 100%. Actual, and certain calculations, removed 100% from WA System. Deferred seperately in WA using WA share. Season - Nov-April, new rate in late summer, for following contract season ID uses actual dollars recorded in Purchases PTR. These contracts document actuals as filed in the initial Authorized expenses from GRC in ID/WA Certain costs/benefits may need tracked outside of Authorized accounts Econ Dispatch-557010 Fuel Dispatch-456010 FPTC - ID (From J. McCauley) Retail Revenue credits are calculated by Rates and input Wind REC Exp Authorized Intraco Thermal Gas-557730 Intraco Thermal Gas-456730 Total Fuel DispatchFin -456010 Fuel Bookouts-456711 Gas Bookouts-557711 Washington Allocation Washington Share Avista Corp. - Resource Accounting WASHINGTON ACTUALS Wind REC Exp Actual 557395 Wind REC Subtotal Total 547 Fuel Expense Total 501 Fuel Expense Total 447 Sales for Resale Total 555 Purchased Power (1) Effective November, 2008, WNP-3 purchase expense has been adjusted to reflect the mid-point price, per Settlement Agreement, Cause No. U-86-99 Total 565 Transmission Expense Total 456 Transmission Revenue 456 TRANSMISSION REVENUE 565 TRANSMISSION EXPENSE WASHINGTON DEFERRED POWER COST CALCULATION - ACTUAL SYSTEM POWER SUPPLY EXPENSES IDAHO ACTUALS Idaho Allocation Idaho Share Clearwater Purchase Actual - Authorized Clearwater Revenue Actual - Authorized Total Clearwater Differences at 100% Total 555 Purchased Power IDAHO DEFERRED POWER COST CALCULATION - ACTUAL SYSTEM POWER SUPPLY EXPENSES Kettle Falls Gas-501120 Kettle Falls Wood-501110 Subtotal Resource Optimization Net Resource Optimization City of Spokane-Upriver Deal Number BPA 573 Fin Swaps Clearwater NonMonetary Bookouts Intercompany Ancillary from Nichols billing worksheet - POWERACC\BILLING\NICHOLS B on A Low Voltage - in Auth revenues Resource Optimizaton Subtotal Adjusted Actual - Authorized Net Expense WA Retail Revenue Adjustment (+) Surcharge (-) Rebate Deferral Amount, Cumulative (Customer) customer deferred W/O Interest Short-Term Purchases Net Power Cost Increase (+) Surcharge; (-) Rebate Acct 557280 Entry; (+) Rebate, (-) Surcharge Acct 557380 Entry; (+) Rebate, (-) Surcharge Misc Revs 456016 ED AN All LT charges (filter by LT in PTR) Total Power Cost Deferral (+) Surcharge; (-) Rebate REC Purchases Subtotal Paouse Wind in PCA at 100% until later GRC REC's Purchases & Sales Inland Power & Light - Deer Lake Rathdrum Power, LLC (Lancaster PPA ) 100074, 100075, 100076 Chelan County PUD (Rocky Reach Slice) Douglas County PUD (Wells Settlement) Grant County PUD (Priest Rapids/Wanapum) Bonneville Power Admin. (WNP-3)1 Douglas County PUD (Wells) Other Short-Term Purchases H:\Generation\Colstrip\Colstrip Fuel ….\YYYY Colstrip Fuel.xls - Used Burned amount for current month H:\Generation\KFGS Hog Fuel\....\YYYY KFGS SAUP.xls - use estimate Hog Fuel Consumed 573 - Enter $$$ Power Deferral Calculation lnstructions Open File H:\Power Deferrals\Power Deferral Calculations\YYYY WA & ID Actual Deferrals.xls Log into GLWand and recalculate all In WA Monthly TAB Expand Groups for Deal #s and hidden rows 555 Purchase Power Input Log into NUC PROD - Merchant Accounts Receivable and Payable System ---> Application Repots ---> Power Transactions Register (PTR) Enter actual volume 447 Sales for Resale From PTR above - query sales and enter deal data for current month Enter deal data for current month Exceptions: Nichols Pumping data from H:\Power Accounting\Billings\Nicholspump\YYYY\ Using current month file use estimated Hog Fuel Consumed Use current month file and total 501 Fuel Tons Kettle Falls H:\Generation\KFGS Hog Fuel\KFGSYYYY\YYYY KFGS SAUP.xls Colstrip H:\Generation\Colstrip\Colstrip Fuel\YYYY\Colstrip Fuel|YYYY Colstrip Fuel.xls Use Burned amount for current month REC Expense Authorized Wind REC Expense Authorized From Tara Knox Authorized Exhibits - only changes with Rate Cases - $0 for 2012 In ID Monthly TAB Input the Bonneville Power Admin (WNP-3) dollar amount from the PTR above In WA Summary TAB WA Retail Revenue Adjustment From Retail Revenue Credit Calculation H:\Power Deferrals\Power Deferral Calculation\WA Retail Rev YYYY.XLS In ID Summary TAB Palouse Wind - Remove from Power Purchase calculation once the contract starts. Data from the PTR above Authorized and Idaho Allocation From Bill Johnson and Liz Andrews - only update with Rate Case Updates Authorized & WA Allocation ID Retail Revenue Adjustment H:\Power Deferrals\Power Deferral Calculation\ID Retail Rev YYYY.XLS Clearwater Purchase @ 100% From Bill Johnson and Rick Lloyd - only update with Rate Case Updates Clearwater Revenue 100% Actual Before Finalizing Before printing regroup all groups on the individual pages To Begin Check with Gina Armstrong and/or Rick Lloyd if any new accounts need to be added For SMUD Deal filter PTR on all Long Term Charges WNP3 Mid Point (from PTR above) go to Bonneville Power Admin Deal #573 From Rick Lloyed - only changes with Rate Case Updates -- 2012 complete Rate (Nov-April) from Dave Spannagel REC Revenue Subtotal REC Rev in Base Rates and 01/01/2012 respectively. not been tracking 456016 Rev's against the proforma amounts, instead had been including 100% The revenues were included in Base Rates, thereby lowering Customer Rates. Resource Acct had of 456016 in Other Res Costs. This effectively gives the customers twice the benefits up to Starting Feb 2012 a separate calculation of actual REC Rev's as compared to proforma amounts (proforma amounts of $700K and $850K) in the last ID and WA GRC's effective 10/1/2011 the proforma amount in Rates (lower Base Rates, and credits in the ERM and PCA). Feb 2012 entry (surcharge direction). will be included in the ERM and PCA for 2012 A true up of Jan 2012 will be included in the While preparing the 2013 WA GRC it became appearent that 456016 REC Sales Rev had been included Spoke with Liz Andrews, Ron Mckenzie and Bill Johnson - start at 1/1/2012 both ID & WA. ID customers keep any benefit for 10-12/2011 (immaterial at 10%) REC's 456 Rev The 2013 WA GRC for Transmission Rev is to only include 456100, no other subtasks (700&705) Select Purchases for current month and submit query Misc. Power Exp. Authorized Misc. Power Exp. Actual-557160 ED AN Misc. Power Exp. Actual-557160 NE CT Gas-547213 Difference Cumulative Balance Palouse Wind City of Spokane - Waste-to-Energy Less SMUD RECs ID Load Change Adjustment (+) Surcharge; (-) Rebate City of Spokane- Waste-to-Energy 456705 ED AN - Do not include Low Voltage 456120 ED AN - BPA Settlement Misc. Power Exp. Subtotal KFWF Contract Buyout 456120 ED AN - BPA Trans. WASHINGTON POWER COST DEFERRALS - For Our Focus 456017 ED AN - Low Voltage 456700 ED ID - Low Voltage 456705 ED AN - Low Voltage WNP Correction* Resource Optimization - Subtotal Instructions on How to Calculate the Retail Revenue Credit To Calculate Idaho's Retail Revenue Credit Open File H:\Power Deferrals\Power Deferral Calculation\ID Retail Rev YYYY.xlsx Total Billed Sales Discoverer - Open an existing workbook - Revenue_RateSch_CM_YTD Report Period = YYYYMM Rate Schedule = % Choose the Electric Tab at the bottom of page Change the State Code (Top of Screen) from <All> to ID (for Idaho) Enter current month usage at "Total Billed Sales" Check that YTD Usage is correct Deduct Clearwater Paper Generation From a file provided by Cheryl Kettner called PotlatchGen.xls She will email this file to you every month Enter in Generation MWhs for correct month Prior Month Unbilled This is a calculation from the previous month Can be verified by checking the Prior Month Unbilled Calculation Information is provided by Rick Lloyd but the file can be found H:\Revenue\Unbilled Revenue\ Current Month Unbilled Rest of the file is based on calculations. The inputs only change with a new rate case. Bill Johnson, Tara Knox and/or Liz Andrews provide the inputs To Calculate Washington's Retail Revenue Credit Open File H:\Power Deferrals\Power Deferral Calculation\WA Retail Rev YYYY.xlsx Change the State Code (Top of Screen) from <All> to WA (for Washington) Idaho Electric Jurisdiction Retail Revenue Credit excluding Clearwater - MWh YTD Deduct Prior Month Unbilled Add Current Month Unbilled Difference from Test Year Load Change Adjustment Rate - $/MWh Total Revenue on Clearwater Purchases Values to Put in Deferral Calculaton Spreadsheet: Retail Revenue Credit (+Surcharge, -Rebate) Clearwater 100% Actual Revenue Budget Forecast Washington Electric Jurisdiction Retail Sales - MWh Total Retail Sales Test Year Retail Sales Production Rate - $/MWh Total Revenue Credit - $ Value to Put in Deferral Calculaton Spreadsheet: Test Year Consumption Total Load Change Adjustment - $ Incorrect Authorized Idaho REC Revenue Adjustment from 2013 Rebate PT Ratio Idaho Share - 100% Idaho Share - 90% As Recorded Corrected Correct Authorized Difference - Adjusted in Jan. 2014 2013 REC Authorized Adjustment 456020 ED AN-Sale of excess BPA Trans Change to only include "actual" months Change to include only "actual" months 223173-177 Capacity and Reserves excludes deviation energy 223178-180 Capacity only - RF (Regulation) Bonneville Power Admin Deal #573 Enter actual volume Nov - Apr Delivery period - need to update volumes (difference between midpt. & commodity rate Source: 2014 WA & ID Actual Deferrals Workbook Purpsoe: Identify FERC accounts currently being captured to compare to "Authorized". PB: T. Moses 12.12.14 FERC Description Purchased Power Purchased Power Financial Purchased Power Lancaster Energy Deviations Lancaster ID WPI & PFI Nonmon Expense Power Bookout Purchases Purchased Power Intraco Power Sale for Resale Physical - Merchant Sale for Resale Financial Energy Deviations - Lancaster Sale for Resale Bookout - Merchant Sale for Resale - Intracompany Transmission Revenue from Merchant Kettle Falls Hog Fuel Kettle Falls Gas Fuel Colstrip Coal Fuel Oil Colstrip Fuel Northeast CT Fuel Boulder Park CT Fuel Kettle Falls CT Fuel Coyote Springs 2 CT Fuel Commodity - Lancaster CT Fuel Rathdrum CT Transmission Revenue of Others Parallel Capacity Support Revenue Sale of Excess Transmission Low Voltage B on A Transmission of Energy by Others Transmission BPA Demand - Lancaster Transmissino of Energy by Others Broker Fees - Power Captured for deferral calculation only SV JD ED AN Quantity * Change in Mid-Point Price (mini surcharge) SMUD REC revenue included in 447000, remove to be captured in REC deferral Other Power Supply Expense - Financial Not an "Authorized" Fuel Economic Dispatch Line Item Turbine Gas Bookout Expense Turbine Gas Bookout Offset Other Power Expense - Intracompany Thermal Other Electric Revenue - Financial Other Electric Revenue - CT Fuel Sales Other Electric Revenue - Intracompany Thermal Other Electric Revenue - Revenue Bookout Offset Other Electric Revenue - Turbine Gas Bookout Miscellaneous Other Resource Costs Optional Renewable Power Expense Energy Recovery Mechanism (ERM) Retail Revenue Credit Calculation - 2015 EWEB REC WA EIA 937 Compliance WA EIA937 Requirement (EWEB) - Expense WA EIA937 Requirement (EWEB) - Broker Fee Exp WA EIA 937 Requirement (EWEB) - Broker Fee Exp WA EIA REC Purchase - Authorized 557 Broker & Related Fees Total 557 ED AN Broker & Related Fees 557172 ED AN 557170 ED AN From Dec '14 Mid Month (Budget) Arch Ford (Jim Ford) 100133, Glen/Rose Marie (Sheep Creek) 100151, Idaho County L&P (John Day) 100460, James White 100163, Mike Johnson (Hydrotech) 214285, Spokane Co. 186693, Deep Creek Place Holder Intercompany Transmission At 35.29% Feb Adjust At 64.71% Washington 100% Activity (EIA 937) Power Costs Adjustment (PCA) - Load Change Adjustment - 2015 Deferral Amount, Monthly Entry Spokane Energy Net Capacity Sale 456700 ED WA - Do not include Low Voltage 456130 ED AN - Ancillary Services Revenue 456020 ED AN - Sale of excess BPA Trans Total through June Error (Period) 555000.00 555100.00 555312.00 555313.00 555380.00 555550.00 555700.00 555710.00 447000.00 447100.00 447313.00 447700.00 447710.00 447720.00 501110.00 501120.00 501140.00 501160.00 547213.00 547216.00 547211.00 547610.00 547312.00 547310.00 456100.00 456120.00 456020.00 456705.00 565000.00 565312.00 565710.00 557170.00 557010.00 557150.00 557700.00 557711.00 557730.00 456010.00 456015.00 456730.00 456711.00 456720.00 557160.00 557395.00 1.00 2.00 3.00 4.00 5.00 6.00 1.00 2.00 3.00 4.00 5.00 ?1?/?31?/?2013 ?2?/?28?/?2013 ?3?/?31?/?2013 ?4?/?30?/?2013 ?5?/?31?/?2013 ?6?/?30?/?2013 ?7?/?31?/?2013 ?8?/?31?/?2013 ?9?/?30?/?2013 ?10?/?31?/?2013 ?11?/?30?/?2013 ?12?/?31?/?2013 1.00 $88,800,154.00 $18,508,249.00 $18,369,404.00 $16,707,284.00 $12,949,168.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2.00 1.00 ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4.00 $13,516,667.00 $3,024,714.00 $719,974.00 $2,528,524.00 $2,524,040.00 $2,145,449.00 $2,573,966.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5.00 $38,704,298.00 $7,034,057.00 $4,606,393.00 $6,304,366.00 $6,287,738.00 $6,983,594.00 $7,488,150.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 6.00 7.00 $8,561,671.00 $1,469,091.00 $1,407,165.00 $1,470,845.00 $1,429,297.00 $1,382,721.00 $1,402,552.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 8.00 $227,317.00 $31,393.00 $40,529.00 $36,550.00 $31,429.00 $45,056.00 $42,360.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 9.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10.00 $76,209,832.00 $18,424,432.00 $14,319,467.00 $13,811,767.00 $8,717,571.00 $7,405,959.00 $13,530,636.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total through June ?1?/?31?/?2013 ?2?/?28?/?2013 ?3?/?31?/?2013 ?4?/?30?/?2013 ?5?/?31?/?2013 ?6?/?30?/?2013 ?7?/?31?/?2013 ?8?/?31?/?2013 ?9?/?30?/?2013 ?10?/?31?/?2013 ?11?/?30?/?2013 ?12?/?31?/?2013 11.00 1.00 $67,667,968.00 $14,241,308.00 $12,816,216.00 $12,684,102.00 $10,157,992.00 $8,801,839.00 $8,966,511.00 $9,032,312.00 $10,449,135.00 $8,227,612.00 $8,950,494.00 $12,731,418.00 $12,617,776.00 12.00 ($46,735,623.00) ($5,385,864.00) ($7,026,454.00) ($8,167,295.00) ($8,655,099.00) ($9,111,902.00) ($8,389,009.00) ($5,130,621.00) ($3,284,320.00) ($4,661,364.00) ($4,875,558.00) ($6,000,154.00) ($4,742,812.00) 13.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 14.00 1.00 $12,972,288.00 $2,663,532.00 $2,484,671.00 $2,578,707.00 $2,068,252.00 $1,665,745.00 $1,511,381.00 $2,254,578.00 $2,621,357.00 $2,672,936.00 $2,757,933.00 $2,649,850.00 $2,700,185.00 15.00 $40,434,825.00 $10,133,311.00 $9,419,650.00 $9,305,476.00 $5,867,735.00 $3,112,735.00 $2,595,918.00 $5,623,100.00 $7,743,935.00 $8,219,145.00 $8,834,779.00 $9,035,104.00 $9,873,776.00 16.00 17.00 $8,395,035.00 $1,447,542.00 $1,429,504.00 $1,405,324.00 $1,394,208.00 $1,365,074.00 $1,353,383.00 $1,377,511.00 $1,429,273.00 $1,414,185.00 $1,374,889.00 $1,403,813.00 $1,423,031.00 18.00 $538,000.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 19.00 $83,272,493.00 $23,189,496.00 $19,213,254.00 $17,895,980.00 $10,922,755.00 $5,923,158.00 $6,127,850.00 $13,246,547.00 $19,049,047.00 $15,962,180.00 $17,132,204.00 $19,909,698.00 $21,961,622.00 20.00 ($7,062,661.00) 0.00 ($4,765,064.00) 0.00 ($4,893,787.00) ($4,084,213.00) ($2,205,184.00) $1,482,801.00 $7,402,786.00 0.00 21.00 ($5,170,883.00) ($706,789.00) ($739,146.00) ($906,411.00) ($781,452.00) ($985,070.00) ($1,052,015.00) 22.00 ($12,233,544.00) ($5,471,853.00) ($5,632,933.00) ($4,990,624.00) ($2,986,636.00) $497,731.00 $6,350,771.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 23.00 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 24.00 ($7,981,163.00) ($3,569,837.00) ($3,674,925.00) ($3,255,883.00) ($1,948,481.00) $324,720.00 $4,143,243.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25.00 $557,805.00 $262,948.00 $910,309.00 $465,355.00 ($286,147.00) $214,781.00 ($1,009,441.00) 26.00 ($7,423,358.00) ($3,306,889.00) 0.00 ($2,764,616.00) ($2,790,528.00) ($2,234,628.00) $539,501.00 $3,133,802.00 27.00 ($3,306,889.00) 0.00 ($6,071,505.00) 0.00 ($8,862,033.00) 0.00 ($11,096,661.00) ($10,557,160.00) ($7,423,358.00) 0.00 0.00 0.00 10000000.00 0.90 0.90 $0.00 0.00 0.00 $0.00 $0.00 ($1,096,661.00) ($557,160.00) $0.00 4000000.00 to $#,##0,, M to $10M 0.50 0.75 $0.00 0.00 0.00 ($2,071,505.00) ($4,862,033.00) ($6,000,000.00) ($6,000,000.00) ($3,423,358.00) 0.00 to $#,##0,, M to $4M 0.00 0.00 ($3,306,889.00) 0.00 0.00 ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) $0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 0.00 ($1,553,629.00) ($3,646,525.00) ($5,486,995.00) ($5,001,444.00) ($2,567,519.00) $0.00 0.00 ($1,553,629.00) ($2,092,896.00) ($1,840,470.00) $485,551.00 $2,433,925.00 $4,121,148.00 $0.00 0.00 $1,553,629.00 0.00 $3,646,525.00 0.00 $1,840,470.00 0.00 ($485,551.00) ($2,433,925.00) ($3,306,889.00) 0.00 ($4,517,876.00) ($5,215,508.00) ($5,609,666.00) ($5,555,716.00) ($4,855,839.00) gaa9730: Authorized doesn't include SMUD RECS Updated Feb. 2013 to correct Authorized ?3?/?4?/?2012 ?1?/?1?/?2013 ($58,333.00) ($70,550.00) $12,217.00 0.35 4256.00 3830.40 0.90 ?2?/?1?/?2013 ($58,333.00) ($82,772.00) $24,439.00 0.35 8515.00 7663.50 ?3?/?1?/?2013 ($58,333.00) ($213,066.00) $154,733.00 0.35 53909.00 48518.10 ?4?/?1?/?2013 ($70,833.00) ($408,270.00) $337,437.00 0.35 117293.00 105563.70 ?5?/?1?/?2013 ($70,833.00) ($448,670.00) $377,837.00 0.35 131336.00 118202.40 ?6?/?1?/?2013 ($70,833.00) ($277,300.00) $206,467.00 0.35 71768.00 64591.20 ?7?/?1?/?2013 ($70,833.00) ($46,500.00) ($24,333.00) 0.35 -8458.00 -7612.20 ?8?/?1?/?2013 ($70,833.00) $0.00 ($70,833.00) 0.35 -24622.00 -22159.80 ?9?/?1?/?2013 ($70,833.00) ($31,250.00) ($39,583.00) 0.35 -13759.00 -12383.10 ?10?/?1?/?2013 ($70,833.00) ($440,000.00) $369,167.00 0.35 128322.00 115489.80 ?11?/?1?/?2013 ($70,833.00) ($96,450.00) $25,617.00 0.35 8904.00 8013.60 ?12?/?1?/?2013 ($70,833.00) ($499,575.00) $428,742.00 0.35 149031.00 134127.90 ($812,496.00) ($2,614,403.00) $1,801,907.00 $626,495.00 $563,846.00 ?1?/?1?/?2013 ($58,333.00) ($70,550.00) $12,217.00 0.35 4256.00 3830.40 0.90 ?2?/?1?/?2013 ($58,333.00) ($82,772.00) $24,439.00 0.35 8515.00 7663.50 ?3?/?1?/?2013 ($58,333.00) ($213,066.00) $154,733.00 0.35 53909.00 48518.10 ?4?/?1?/?2013 ($31,500.00) -31500.00 ($408,270.00) $376,770.00 0.35 130965.00 117868.50 ?5?/?1?/?2013 ($31,500.00) ($448,670.00) $417,170.00 0.35 145008.00 130507.20 ?6?/?1?/?2013 ($31,500.00) ($277,300.00) $245,800.00 0.35 85440.00 76896.00 ?7?/?1?/?2013 ($31,500.00) ($46,500.00) $15,000.00 0.35 5214.00 4692.60 ?8?/?1?/?2013 ($31,500.00) $0.00 ($31,500.00) 0.35 -10949.00 -9854.10 ?9?/?1?/?2013 ($31,500.00) ($31,250.00) ($250.00) 0.35 -87.00 -78.30 ?10?/?1?/?2013 ($31,500.00) ($440,000.00) $408,500.00 0.35 141995.00 127795.50 ?11?/?1?/?2013 ($31,500.00) ($96,450.00) $64,950.00 0.35 22577.00 20319.30 ?12?/?1?/?2013 ($31,500.00) ($499,575.00) $468,075.00 0.35 162703.00 146432.70 ($458,499.00) ($2,614,403.00) $2,155,904.00 $749,546.00 $674,591.00 ?1?/?1?/?2013 $0.00 $0.00 $0.00 0.35 0.00 0.00 0.90 ?2?/?1?/?2013 $0.00 $0.00 $0.00 0.35 0.00 0.00 ?3?/?1?/?2013 $0.00 $0.00 $0.00 0.35 0.00 0.00 ?4?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?5?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?6?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?7?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?8?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?9?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?10?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?11?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 ?12?/?1?/?2013 $39,333.00 $0.00 $39,333.00 0.35 13672.00 12304.80 $353,997.00 $0.00 $353,997.00 $123,048.00 $110,743.00 ?1?/?1?/?2015 ?2?/?1?/?2015 ?3?/?1?/?2015 ?4?/?1?/?2015 ?5?/?1?/?2015 ?6?/?1?/?2015 ?7?/?1?/?2015 ?8?/?1?/?2015 ?9?/?1?/?2015 ?10?/?1?/?2015 ?11?/?1?/?2015 ?12?/?1?/?2015 294106.00 312818.00 254945.00 254944841.00 1000.00 228815.00 228814849.00 1000.00 227317.00 227317203.00 1000.00 230128.00 230128288.00 1000.00 1548129.00 -180213.00 -169098.00 0.00 0.00 -100380.00 -102857.00 -101346.00 -95764.00 0.00 0.00 0.00 0.00 0.00 0.00 -749658.00 169098.00 100380.00 102857.00 102857330.00 1000.00 101346.00 101345712.00 1000.00 95764.00 95763708.00 1000.00 108233.00 108233389.00 1000.00 677678.00 282991.00 244100.00 257422.00 227304.00 221735.00 242597.00 0.00 0.00 0.00 0.00 0.00 0.00 1476149.00 288554.00 259942.00 251709.00 220890.00 215126.00 211354.00 242247.00 239641.00 218705.00 210034.00 262809.00 299304.00 1447575.00 -5563.00 0.00 -15842.00 5713.00 6414.00 6609.00 31243.00 0.00 28574.00 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 $26.97 ($150,034.00) 0.00 ($427,259.00) $154,080.00 $172,986.00 $178,245.00 $842,624.00 0.00 $770,642.00 $150,034.00 $427,259.00 ($154,080.00) ($172,986.00) ($178,245.00) ($842,624.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($770,642.00) 0.00 Rebate Surcharge Surcharge Surcharge Rebate Rebate Rebate Rebate Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Rebate ($290,661.00) $128,666.00 ($496,627.00) ($355,057.00) ($378,644.00) ($413,670.00) ($411,614.00) ($450,892.00) ($134,430.00) ($1,054,559.00) ($195,218.00) ($354,398.00) -4407104.00 0.00 Rebate Surcharge Rebate Surcharge Rebate Rebate Rebate Rebate Rebate Rebate Rebate Rebate Rebate Rebate Rebate 0.00 Rebate Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge CKettner: From Revenue_RateSch_CM_YTD 20XX XX.xls that Rates sends CKettner: From X-XX Electric Unbilled Calc.xlsx CKettner: We receive when new test year is put into place. CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho CKettner: Provided by the Rates Department - Elec Rev Report by Rev Class for Idaho Page +1 of 3 ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 ?1?/?31?/?2015 ?2?/?28?/?2015 1.00 1.00 $41,966,726.00 $9,083,672.00 $9,144,844.00 $8,407,240.00 $5,002,455.00 $4,325,233.00 $6,003,282.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,966,726.00 2.00 $6,823,308.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6,823,308.00 3.00 1.00 $754,224.00 $100,730.00 $167,368.00 $179,310.00 $101,686.00 $127,824.00 $77,306.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $754,224.00 4.00 $923,112.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $923,112.00 5.00 $3,710,004.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,710,004.00 6.00 $7,897,074.00 $2,746,372.00 $2,481,636.00 $1,355,897.00 $1,313,169.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,897,074.00 7.00 $3,853.00 $505.00 $517.00 $925.00 $925.00 $274.00 $707.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,853.00 8.00 $775,795.00 $132,037.00 $185,432.00 $128,447.00 $137,815.00 $98,964.00 $93,100.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $775,795.00 9.00 $640,657.00 $133,876.00 $104,002.00 $101,861.00 $105,278.00 $139,830.00 $55,810.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $640,657.00 10.00 $1,847,915.00 $483,338.00 $368,892.00 $456,175.00 $326,459.00 $184,051.00 $29,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,847,915.00 11.00 1.00 $2,407,361.00 $407,336.00 $454,551.00 $391,828.00 $415,522.00 $397,638.00 $340,486.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,407,361.00 12.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 13.00 $12,331,159.00 $2,085,311.00 $1,964,556.00 $2,071,992.00 $2,019,583.00 $1,997,492.00 $2,192,225.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,331,159.00 14.00 $7,916,556.00 $1,241,479.00 $1,373,528.00 $1,578,196.00 $1,591,612.00 $1,135,977.00 $995,764.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,916,556.00 15.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 16.00 $823,086.00 $147,986.00 $137,599.00 $148,814.00 $128,251.00 $114,327.00 $146,109.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $823,086.00 17.00 ($59,333.00) $22,759.00 $64,927.00 ($29,442.00) ($109,419.00) $10,993.00 ($19,151.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($59,333.00) 18.00 $88,761,497.00 $18,494,805.00 $18,357,256.00 $16,700,647.00 $12,942,740.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88,820,830.00 555 PURCHASED POWER 555000.00 $65,880,443.00 $13,830,192.00 $12,242,707.00 $11,249,703.00 $9,829,052.00 $8,332,081.00 $10,396,708.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $65,880,443.00 555100.00 $19,423,862.00 $4,003,221.00 $5,611,055.00 $5,165,020.00 $2,718,288.00 $1,589,170.00 $337,108.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19,423,862.00 555312.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555313.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555380.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555550.00 ($59,333.00) $22,759.00 $64,927.00 ($29,442.00) ($109,419.00) $10,993.00 ($19,151.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($59,333.00) 555700.00 $2,693,439.00 $490,647.00 $300,968.00 $166,552.00 $376,568.00 $395,436.00 $963,268.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,693,439.00 555710.00 $823,086.00 $147,986.00 $137,599.00 $148,814.00 $128,251.00 $114,327.00 $146,109.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $823,086.00 $88,761,497.00 $18,494,805.00 $18,357,256.00 $16,700,647.00 $12,942,740.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,457,192.00 19.00 1.00 ($62,829,164.00) ($10,076,763.00) ($8,945,881.00) ($11,106,285.00) ($12,632,630.00) ($11,598,297.00) ($8,469,308.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($62,829,164.00) 20.00 ($535,770.00) ($145,955.00) ($146,345.00) ($146,020.00) ($97,450.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($535,770.00) 21.00 ($463,403.00) ($76,281.00) ($46,957.00) ($58,438.00) ($63,200.00) ($103,441.00) ($115,086.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($463,403.00) 22.00 ($69,355.00) ($11,963.00) ($10,725.00) ($11,866.00) ($11,448.00) ($11,943.00) ($11,410.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($69,355.00) 23.00 ($272,107.00) ($48,666.00) ($47,964.00) ($46,761.00) ($42,464.00) ($47,066.00) ($39,186.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($272,107.00) 24.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25.00 ($9,430,476.00) ($1,283,444.00) ($1,626,126.00) ($1,866,432.00) ($1,656,909.00) ($1,832,121.00) ($1,165,444.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($9,430,476.00) 26.00 ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($73,600,275.00) 447000.00 ($41,866,163.00) ($6,220,728.00) ($4,379,603.00) ($6,260,901.00) ($7,205,832.00) ($9,416,648.00) ($8,382,451.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($41,866,163.00) 447100.00 ($18,819,462.00) ($3,496,091.00) ($4,364,375.00) ($4,758,416.00) ($5,120,908.00) ($1,823,360.00) $743,688.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($18,819,462.00) 447313.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 447700.00 ($2,661,088.00) ($494,823.00) ($316,295.00) ($201,239.00) ($392,201.00) ($406,412.00) ($850,118.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($2,661,088.00) 447710.00 ($823,086.00) ($147,986.00) ($137,599.00) ($148,814.00) ($128,251.00) ($114,327.00) ($146,109.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($823,086.00) 447720.00 ($9,430,476.00) ($1,283,444.00) ($1,626,126.00) ($1,866,432.00) ($1,656,909.00) ($1,832,121.00) ($1,165,444.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($9,430,476.00) ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($12,914,650.00) 27.00 1.00 $2,790,958.00 $787,016.00 $101,852.00 $625,932.00 $639,128.00 $580,843.00 $56,187.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,790,958.00 28.00 1.00 $11,942.00 ($159.00) $1,725.00 $4,325.00 ($231.00) ($142.00) $6,424.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,942.00 29.00 1.00 $10,566,693.00 $2,191,973.00 $614,689.00 $1,875,568.00 $1,859,178.00 $1,545,596.00 $2,479,689.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,566,693.00 30.00 1.00 $147,074.00 $45,884.00 $1,708.00 $22,699.00 $25,965.00 $19,152.00 $31,666.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $147,074.00 31.00 1.00 $13,516,667.00 $3,024,714.00 $719,974.00 $2,528,524.00 $2,524,040.00 $2,145,449.00 $2,573,966.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,516,667.00 32.00 1.00 207517.00 57572.00 9136.00 48506.00 50870.00 36438.00 4995.00 0.00 0.00 0.00 0.00 0.00 0.00 $207,517.00 33.00 1.00 491168.00 98812.00 61132.00 79441.00 82336.00 75681.00 93766.00 0.00 0.00 0.00 0.00 0.00 0.00 $491,168.00 34.00 1.00 $13.67 0.00 $11.15 $12.90 $12.56 $15.94 $11.25 $13.00 35.00 1.00 $22.18 0.00 $10.06 $23.61 $22.58 $20.42 $26.45 $22.00 36.00 1.00 $27,878.00 $1,933.00 $18,530.00 $389.00 $4,365.00 $1,014.00 $1,647.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27,878.00 37.00 $308,732.00 $16,613.00 $26,723.00 $9,055.00 $34,725.00 $73,584.00 $148,032.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $308,732.00 38.00 $47,108.00 $1,161.00 $2,033.00 $353.00 $2,214.00 $26,771.00 $14,576.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47,108.00 39.00 $21,052,033.00 $3,756,118.00 $2,625,208.00 $3,197,538.00 $3,866,344.00 $4,540,165.00 $3,066,660.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21,052,033.00 40.00 $16,537,291.00 $3,234,280.00 $1,883,752.00 $3,098,143.00 $2,380,061.00 $2,067,728.00 $3,873,327.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,537,291.00 41.00 $731,256.00 $23,952.00 $50,147.00 ($1,112.00) $29.00 $274,332.00 $383,908.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $731,256.00 42.00 $38,704,298.00 $7,034,057.00 $4,606,393.00 $6,304,366.00 $6,287,738.00 $6,983,594.00 $7,488,150.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38,704,298.00 43.00 1.00 $67,382,187.00 $16,910,504.00 $12,859,625.00 $12,297,735.00 $7,250,417.00 $5,978,182.00 $12,085,724.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $125,821,240.00 201501.00 201502.00 201503.00 201504.00 201505.00 201506.00 201507.00 201508.00 201509.00 201510.00 201511.00 201512.00 201401.00 201401.00 44.00 1.00 ($5,601,800.00) ($1,044,935.00) ($1,131,484.00) ($1,128,135.00) ($958,901.00) ($966,487.00) ($371,858.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($5,601,800.00) 45.00 ($1,596,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 46.00 ($11,054.00) ($3,058.00) ($288.00) ($6,108.00) ($1,600.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 47.00 ($823,086.00) $0.00 $0.00 $0.00 $0.00 $0.00 ($823,086.00) 48.00 ($30,120.00) ($5,020.00) ($5,020.00) ($5,020.00) ($5,020.00) ($5,020.00) ($5,020.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 49.00 ($25,392.00) ($4,232.00) ($4,232.00) ($4,232.00) ($4,232.00) ($4,232.00) ($4,232.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 50.00 ($464,472.00) ($77,412.00) ($77,412.00) ($77,412.00) ($77,412.00) ($77,412.00) ($77,412.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($464,472.00) 51.00 ($8,551,924.00) ($1,400,657.00) ($1,484,436.00) ($1,486,907.00) ($1,313,165.00) ($1,319,151.00) ($1,547,608.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($8,551,924.00) 52.00 1.00 $8,549,491.00 $1,467,061.00 $1,405,135.00 $1,468,815.00 $1,427,267.00 $1,380,691.00 $1,400,522.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,549,491.00 53.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 53.00 1.00 $12,180.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,180.00 54.00 1.00 $8,561,671.00 $1,469,091.00 $1,407,165.00 $1,470,845.00 $1,429,297.00 $1,382,721.00 $1,402,552.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,561,671.00 63.00 $22,541,835.00 $2,591,889.00 $4,538,335.00 $4,958,303.00 $3,500,937.00 $3,500,737.00 $3,451,634.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22,541,835.00 64.00 1.00 ($4,779,545.00) $814,972.00 $1,095,205.00 $41,601.00 ($1,727,201.00) ($2,781,563.00) ($2,222,559.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($4,779,545.00) 65.00 $1,375,960.00 $0.00 $0.00 $173,218.00 $102,290.00 $415,282.00 $685,170.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,375,960.00 66.00 ($1,375,960.00) $0.00 $0.00 ($173,218.00) ($102,290.00) ($415,282.00) ($685,170.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,375,960.00) 67.00 $20,672,101.00 $2,862,530.00 $1,424,635.00 $2,838,743.00 $3,289,671.00 $4,603,050.00 $5,653,472.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,672,101.00 68.00 ($15,986,823.00) ($2,013,173.00) ($3,448,826.00) ($3,528,867.00) ($2,401,120.00) ($2,192,179.00) ($2,402,658.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($15,986,823.00) 69.00 ($3,940,160.00) ($1,010,407.00) ($970,092.00) ($1,879,468.00) ($28,849.00) ($28,550.00) ($22,794.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($3,940,160.00) 70.00 ($23,679,460.00) ($3,952,616.00) ($3,378,430.00) ($3,336,760.00) ($3,415,778.00) ($4,086,650.00) ($5,509,226.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($23,679,460.00) 71.00 $259,824.00 $63,150.00 $7,360.00 $189,314.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $259,824.00 72.00 ($259,824.00) ($63,150.00) ($7,360.00) ($189,314.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($259,824.00) 73.00 1.00 ($5,172,052.00) ($706,805.00) ($739,173.00) ($906,448.00) ($782,340.00) ($985,155.00) ($1,052,131.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($5,172,052.00) 74.00 1.00 ($189,000.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($31,500.00) ($378,000.00) 75.00 1.00 ($1,347,879.00) ($188,804.00) ($160,040.00) ($258,135.00) ($289,048.00) ($265,692.00) ($186,160.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,347,879.00) 76.00 1.00 ($1,158,879.00) ($157,304.00) 0.00 ($128,540.00) ($226,635.00) ($257,548.00) ($234,192.00) ($154,660.00) ($1,158,879.00) 77.00 1.00 $173,760.00 $29,760.00 $26,880.00 $29,760.00 $28,800.00 $29,760.00 $28,800.00 $0.00 29760.00 0.00 $0.00 29760.00 0.00 $0.00 28800.00 0.00 $0.00 29800.00 0.00 $0.00 28800.00 0.00 $0.00 29760.00 0.00 $173,760.00 78.00 1.00 $812.00 $0.00 $477.00 $335.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $812.00 79.00 1.00 ($172,948.00) ($29,760.00) ($26,403.00) ($29,425.00) ($28,800.00) ($29,760.00) ($28,800.00) ($172,948.00) 80.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 7419.00 1.75 0.00 $0.00 7071.00 1.75 0.00 $0.00 7851.00 1.75 0.00 $0.00 6234.00 1.75 0.00 $0.00 6681.00 1.75 0.00 $0.00 5094.00 1.75 0.00 $0.00 5320.00 1.75 0.00 $0.00 6420.00 1.75 0.00 $0.00 5317.00 1.75 0.00 $0.00 81.00 1.00 $337.00 $16.00 $27.00 $37.00 $56.00 $85.00 $116.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $337.00 82.00 1.00 $337.00 $16.00 $27.00 $37.00 $56.00 $85.00 $116.00 $337.00 83.00 1.00 ($6,503,542.00) ($893,853.00) 0.00 ($894,089.00) 0.00 ($1,162,471.00) ($1,068,632.00) ($1,249,022.00) 0.00 ($1,235,475.00) 0.00 0.00 ($6,503,542.00) 84.00 1.00 $60,888,392.00 $16,085,085.00 0.00 $11,888,265.00 $11,119,202.00 $6,297,917.00 $4,792,730.00 0.00 $10,705,193.00 $60,888,392.00 Net gas not burned plus act v auth REC expense, and other misc rev's tzj0fg: from Tara Knox - comes from Authorized Exhibits tzj0fg: If Act<Auth (+) Surcharge If Act>Auth (-) Rebate tzj0fg: Exclude EWEB and other EIA-937 RECs tzj0fg: Clearwater included to offset any variance in SMUD sale 447 rev's for Brown Power gaa9730: For KFGS Hog fuel Contract buyout Clearwater Recs and Stateline Rec sale loss gaa9730: For KFGS Hog fuel Contract buyout Clearwater Recs and Stateline Rec sale loss gaa9730: Includes KFWF Contract buyout tmm8381: November through April only each year. Data Source: Nucleus, Power Transaction Register Deal 573 tmm8381: Was JP Morgan Wind: Contract ended April 2014 Page of ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 1.00 $88,761,497.00 $18,494,805.00 $18,357,256.00 $16,700,647.00 $12,942,740.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2.00 1.00 ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3.00 1.00 $13,516,667.00 $3,024,714.00 $719,974.00 $2,528,524.00 $2,524,040.00 $2,145,449.00 $2,573,966.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4.00 1.00 $38,704,298.00 $7,034,057.00 $4,606,393.00 $6,304,366.00 $6,287,738.00 $6,983,594.00 $7,488,150.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5.00 1.00 ($8,551,924.00) ($1,400,657.00) ($1,484,436.00) ($1,486,907.00) ($1,313,165.00) ($1,319,151.00) ($1,547,608.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 6.00 1.00 $8,561,671.00 $1,469,091.00 $1,407,165.00 $1,470,845.00 $1,429,297.00 $1,382,721.00 $1,402,552.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 7.00 1.00 $67,391,934.00 $16,978,938.00 $12,782,354.00 $12,281,673.00 $7,366,549.00 $6,041,752.00 $11,940,668.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total through June ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 8.00 1.00 $46,090,109.00 $10,717,432.00 $9,359,487.00 $8,546,885.00 $6,841,564.00 $5,337,699.00 $5,287,042.00 $5,648,618.00 $7,939,502.00 $5,551,282.00 $5,789,904.00 $8,437,276.00 $8,726,282.00 9.00 ($27,486,590.00) ($4,641,568.00) ($4,386,361.00) ($4,792,538.00) ($5,372,207.00) ($5,022,215.00) ($3,271,701.00) ($6,033,100.00) ($3,115,032.00) ($4,649,875.00) ($4,672,288.00) ($5,573,841.00) ($6,089,913.00) 10.00 $13,362,658.00 $2,789,917.00 $2,632,215.00 $2,785,057.00 $2,031,330.00 $1,718,372.00 $1,405,767.00 $2,715,972.00 $2,948,383.00 $2,925,528.00 $3,051,784.00 $2,909,636.00 $3,002,771.00 11.00 $33,158,340.00 $8,264,229.00 $7,537,533.00 $7,376,233.00 $4,927,841.00 $2,851,219.00 $2,201,285.00 $6,893,937.00 $8,303,984.00 $8,561,441.00 $9,099,171.00 $9,713,701.00 $10,900,577.00 12.00 ($7,474,480.00) ($1,324,260.00) ($1,118,308.00) ($1,231,356.00) ($1,159,556.00) ($1,231,179.00) ($1,409,821.00) ($1,563,830.00) ($1,439,516.00) ($1,361,638.00) ($1,498,286.00) ($1,294,553.00) ($1,278,524.00) 13.00 $8,726,347.00 $1,495,284.48 $1,530,877.00 $1,480,537.53 $1,427,248.00 $1,371,517.68 $1,420,882.00 $1,432,251.00 $1,480,124.00 $1,483,239.00 $1,547,809.00 $1,665,262.00 $1,635,447.00 14.00 $66,376,384.00 $17,301,034.00 $15,555,443.00 $14,164,819.00 $8,696,220.00 $5,025,414.00 $5,633,454.00 $9,093,848.00 $16,117,445.00 $12,509,977.00 $13,318,094.00 $15,857,481.00 $16,896,640.00 15.00 $1,015,550.00 ($322,096.00) 0.00 ($2,773,089.00) 0.00 ($1,883,146.00) ($1,329,671.00) $1,016,338.00 $6,307,214.00 0.00 16.00 ($6,503,542.00) ($893,853.00) ($894,089.00) ($1,162,471.00) ($1,068,632.00) ($1,249,022.00) ($1,235,475.00) ($5,313,000.00) ($4,347,000.00) ($966,000.00) 17.00 1.00 ($10,800,992.00) ($1,215,949.00) ($3,667,178.00) 0.00 ($7,392,617.00) 0.00 ($2,398,303.00) ($232,684.00) $4,105,739.00 0.00 18.00 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 19.00 ($3,754,425.00) ($422,664.00) ($1,274,711.00) 0.00 ($2,569,674.00) 0.00 ($833,650.00) ($80,881.00) $1,427,155.00 20.00 ($770,642.00) $150,034.00 $427,259.00 0.00 ($154,080.00) 0.00 ($172,986.00) 0.00 ($178,245.00) 0.00 ($842,624.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 21.00 $0.00 22.00 ($4,525,067.00) ($272,630.00) ($847,452.00) ($2,723,754.00) ($1,006,636.00) ($259,126.00) 0.00 $584,531.00 23.00 ($4,072,560.00) ($245,367.00) ($762,707.00) 0.00 0.90 ($2,451,379.00) ($905,972.00) ($233,213.00) $526,078.00 ($4,525,067.00) 0.90 24.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25.00 $9,117,752.00 $1,684,910.00 $1,538,596.00 $1,141,844.00 $1,659,201.00 $1,652,935.00 $1,440,266.00 $1,665,897.00 $1,673,537.00 $1,533,746.00 $1,650,145.00 $1,669,545.00 $1,770,021.00 26.00 ($9,117,752.00) ($1,684,910.00) ($1,538,596.00) ($1,141,844.00) ($1,659,201.00) ($1,652,935.00) ($1,440,266.00) 27.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 28.00 ($10,293,225.00) ($1,896,882.00) ($1,746,450.00) ($1,285,700.00) ($1,875,387.00) ($1,860,881.00) ($1,627,925.00) ($1,875,474.00) ($1,884,078.00) ($1,733,585.00) ($1,857,742.00) ($1,886,753.00) ($1,992,699.00) 29.00 $1,896,882.00 $1,746,450.00 $1,285,700.00 $1,875,387.00 $1,860,881.00 $1,627,925.00 30.00 $1,175,473.00 $211,972.00 0.00 $207,854.00 $143,856.00 $216,186.00 $207,946.00 $187,659.00 31.00 ($2,897,087.00) ($33,395.00) ($554,853.00) ($2,307,523.00) ($689,786.00) ($25,267.00) $713,737.00 32.00 $33,395.00 $33,395.00 -1.00 $554,853.00 -1.00 $2,307,523.00 -1.00 $689,786.00 $25,267.00 ($713,737.00) $39,195.00 ($5,800.00) tzj0fg: From Retail Rev Credit worksheet Line 25 - Total Revenue on Clearwater Purchases ?1?/?1?/?2015 ?2?/?1?/?2015 ?3?/?1?/?2015 ?4?/?1?/?2015 ?5?/?1?/?2015 ?6?/?1?/?2015 ?7?/?1?/?2015 ?8?/?1?/?2015 ?9?/?1?/?2015 ?10?/?1?/?2015 ?11?/?1?/?2015 ?12?/?1?/?2015 548342.00 594181.00 501376.00 501375816.00 1000.00 432369.00 432369112.00 1000.00 420959.00 420958730.00 1000.00 434818.00 434817848.00 1000.00 2932045.00 -388674.00 -372468.00 0.00 0.00 -231077.00 -194123.00 -198222.00 -188570.00 0.00 0.00 0.00 0.00 0.00 0.00 -1573134.00 372468.00 231077.00 194123.00 194122845.00 1000.00 198222.00 198221653.00 1000.00 188570.00 188570340.00 1000.00 224824.00 224824438.00 1000.00 1409284.00 532136.00 452790.00 464422.00 436468.00 411307.00 471072.00 0.00 0.00 0.00 0.00 0.00 0.00 2768195.00 545205.00 498034.00 487551.00 422246.00 421982.00 420901.00 464392.00 489763.00 426967.00 452424.00 490319.00 570023.00 2795919.00 -13069.00 -45244.00 0.00 -23129.00 14222.00 -10675.00 50171.00 -27724.00 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 $20.12 ($262,948.00) ($910,309.00) 0.00 0.00 ($465,355.00) $286,147.00 ($214,781.00) $1,009,441.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($557,805.00) ?1?/?1?/?2015 ?2?/?1?/?2015 ?3?/?1?/?2015 ?4?/?1?/?2015 ?5?/?1?/?2015 ?6?/?1?/?2015 ?7?/?1?/?2015 ?8?/?1?/?2015 ?9?/?1?/?2015 ?10?/?1?/?2015 ?11?/?1?/?2015 ?12?/?1?/?2015 YTD $262,948.00 0.00 -1.00 $910,309.00 0.00 -1.00 $465,355.00 ($286,147.00) $214,781.00 ($1,009,441.00) $557,805.00 -1.00 0.00 Rebate Surcharge Surcharge Surcharge Surcharge Rebate Surcharge Rebate Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge ($261,428.00) $545,565.00 $2,962.00 $67,804.00 ($31,482.00) $70,378.00 ($335,309.00) $104,179.00 $142,002.00 ($177,225.00) ($88,397.00) ($70,408.00) -31359.00 0.00 Rebate Surcharge Rebate Surcharge Surcharge Surcharge Rebate Surcharge Rebate Surcharge Surcharge Rebate Rebate Rebate Rebate 0.00 Rebate Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge Surcharge CKettner: From Revenue_RateSch_CM_YTD 20XX XX.xls that Rates sends CKettner: From X-XX Electric Unbilled Calc.xlsx - Page +1 of 5 ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 1.00 1.00 $41,966,726.00 $9,083,672.00 $9,144,844.00 $8,407,240.00 $5,002,455.00 $4,325,233.00 $6,003,282.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,966,726.00 2.00 100096.00 $6,823,308.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $1,137,218.00 $6,823,308.00 3.00 107240.00 $754,224.00 $100,730.00 $167,368.00 81016.95 86350.95 $179,310.00 $101,686.00 $127,824.00 $77,306.00 $754,224.00 4.00 100131.00 $923,112.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $153,852.00 $923,112.00 5.00 100085.00 $3,710,004.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $618,334.00 $3,710,004.00 6.00 1.00 $7,935,731.00 $2,759,816.00 $2,493,784.00 $1,362,534.00 $1,319,597.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,935,731.00 7.00 100137.00 $3,853.00 $505.00 $517.00 $925.00 $925.00 $274.00 $707.00 $3,853.00 8.00 $775,795.00 $132,037.00 33443.80 21226.48 25253.73 7105.55 39958.40 5048.98 $185,432.00 73224.48 19114.60 25177.51 11638.10 49075.63 7201.81 $128,447.00 24541.37 26983.83 43874.02 13814.95 14709.73 4523.44 $137,815.00 37093.60 12629.88 18447.12 20906.39 42444.07 6293.92 $98,964.00 299.69 26083.23 36882.37 14098.30 15453.55 6147.33 $93,100.00 1232.61 42603.02 13573.68 9627.53 23484.44 2578.38 $775,795.00 9.00 185895.00 $640,657.00 $133,876.00 $104,002.00 34009.13 69992.58 $101,861.00 $105,278.00 $139,830.00 $55,810.00 $640,657.00 10.00 186298.00 $1,847,915.00 $483,338.00 $368,892.00 106571.39 262320.89 $456,175.00 $326,459.00 $184,051.00 $29,000.00 $1,847,915.00 11.00 1.00 223063.00 $2,407,361.00 $407,336.00 $454,551.00 $391,828.00 $415,522.00 $397,638.00 $340,486.00 $2,407,361.00 12.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 13.00 1.00 $12,331,159.00 $2,085,311.00 $1,964,556.00 1964556.05 $2,071,992.00 $2,019,583.00 $1,997,492.00 $2,192,225.00 $12,331,159.00 14.00 1.00 181462.00 $7,916,556.00 $1,241,479.00 $1,373,528.00 $1,578,196.00 $1,591,612.00 $1,135,977.00 $995,764.00 $7,916,556.00 15.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 16.00 $823,086.00 $147,986.00 $137,599.00 $148,814.00 $128,251.00 $114,327.00 $146,109.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $823,086.00 17.00 ($59,333.00) $22,759.00 $64,927.00 ($29,442.00) ($109,419.00) $10,993.00 ($19,151.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($59,333.00) 18.00 $88,800,154.00 $18,508,249.00 $18,369,404.00 $16,707,284.00 $12,949,168.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88,859,487.00 555000.00 $65,880,443.00 $13,830,192.00 $12,242,707.00 $11,249,703.00 $9,829,052.00 $8,332,081.00 $10,396,708.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $65,880,443.00 555100.00 $19,423,862.00 $4,003,221.00 $5,611,055.00 $5,165,020.00 $2,718,288.00 $1,589,170.00 $337,108.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19,423,862.00 555312.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555313.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555380.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 555550.00 ($59,333.00) $22,759.00 $64,927.00 ($29,442.00) ($109,419.00) $10,993.00 ($19,151.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($59,333.00) 555700.00 $2,693,439.00 $490,647.00 $300,968.00 $166,552.00 $376,568.00 $395,436.00 $963,268.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,693,439.00 555710.00 $823,086.00 $147,986.00 $137,599.00 $148,814.00 $128,251.00 $114,327.00 $146,109.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $823,086.00 $38,657.00 $13,444.00 64018.00 43.11 42.90 $12,148.00 57847.00 43.11 42.90 $6,637.00 31606.00 43.11 42.90 $6,428.00 30610.00 43.11 42.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 43.11 42.90 $0.00 0.00 43.11 42.90 $38,657.00 $88,800,154.00 $18,508,249.00 $18,369,404.00 $16,707,284.00 $12,949,168.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $88,800,154.00 19.00 1.00 ($62,829,164.00) ($10,076,763.00) ($8,945,881.00) ($11,106,285.00) ($12,632,630.00) ($11,598,297.00) ($8,469,308.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($62,829,164.00) 20.00 100062.00 ($535,770.00) ($145,955.00) ($146,345.00) ($146,020.00) ($97,450.00) $0.00 $0.00 ($535,770.00) 21.00 ($463,403.00) ($76,281.00) ($46,957.00) ($58,438.00) ($63,200.00) ($103,441.00) ($115,086.00) ($463,403.00) 22.00 ($69,355.00) ($11,963.00) -5766.00 3098.59 3098.59 ($10,725.00) -5208.00 2758.39 2758.39 ($11,866.00) 5758.25 3054.04 3054.04 ($11,448.00) 5580.00 2934.11 2934.11 ($11,943.00) 5766.00 3088.46 3088.46 ($11,410.00) 5580.00 2914.76 2914.76 ($69,355.00) 23.00 ($272,107.00) ($48,666.00) -5295.04 5295.04 21111.16 8482.16 8482.16 ($47,964.00) -5307.08 5307.08 20709.08 8320.61 8320.61 ($46,761.00) 6657.19 6657.19 18544.40 7450.88 7450.88 ($42,464.00) 6419.36 6419.36 16425.92 6599.70 6599.70 ($47,066.00) 5642.55 5642.55 19839.12 7971.08 7971.08 ($39,186.00) 5804.21 5804.21 15290.52 6143.51 6143.51 ($272,107.00) 24.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25.00 ($9,430,476.00) ($1,283,444.00) ($1,626,126.00) ($1,866,432.00) ($1,656,909.00) ($1,832,121.00) ($1,165,444.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($9,430,476.00) 26.00 ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($73,600,275.00) 447000.00 ($41,866,163.00) ($6,220,728.00) ($4,379,603.00) ($6,260,901.00) ($7,205,832.00) ($9,416,648.00) ($8,382,451.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($41,866,163.00) 447100.00 ($18,819,462.00) ($3,496,091.00) ($4,364,375.00) ($4,758,416.00) ($5,120,908.00) ($1,823,360.00) $743,688.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($18,819,462.00) 447313.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 447700.00 ($2,661,088.00) ($494,823.00) ($316,295.00) ($201,239.00) ($392,201.00) ($406,412.00) ($850,118.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($2,661,088.00) 447710.00 ($823,086.00) ($147,986.00) ($137,599.00) ($148,814.00) ($128,251.00) ($114,327.00) ($146,109.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($823,086.00) 447720.00 ($9,430,476.00) ($1,283,444.00) ($1,626,126.00) ($1,866,432.00) ($1,656,909.00) ($1,832,121.00) ($1,165,444.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($9,430,476.00) ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($73,600,275.00) 27.00 1.00 $2,790,958.00 $787,016.00 $101,852.00 $625,932.00 $639,128.00 $580,843.00 $56,187.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,790,958.00 28.00 1.00 $11,942.00 ($159.00) $1,725.00 $4,325.00 ($231.00) ($142.00) $6,424.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,942.00 29.00 1.00 $10,566,693.00 $2,191,973.00 $614,689.00 $1,875,568.00 $1,859,178.00 $1,545,596.00 $2,479,689.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,566,693.00 30.00 1.00 $147,074.00 $45,884.00 $1,708.00 $22,699.00 $25,965.00 $19,152.00 $31,666.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $147,074.00 31.00 1.00 $13,516,667.00 $3,024,714.00 $719,974.00 $2,528,524.00 $2,524,040.00 $2,145,449.00 $2,573,966.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,516,667.00 32.00 1.00 207517.00 57572.00 9136.00 35063.00 25927.00 48506.00 50870.00 36438.00 4995.00 207517.00 33.00 1.00 491168.00 98812.00 61132.00 79441.00 82336.00 75681.00 93766.00 491168.00 34.00 1.00 $13.67 0.00 $11.15 0.00 $12.90 0.00 $12.56 $15.94 0.00 $11.25 0.00 $13.45 35.00 1.00 $22.18 0.00 $10.06 0.00 $23.61 $22.58 $20.42 0.00 $26.45 $21.51 36.00 1.00 $27,878.00 $1,933.00 $18,530.00 $389.00 $4,365.00 $1,014.00 $1,647.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27,878.00 37.00 $308,732.00 $16,613.00 $26,723.00 $9,055.00 $34,725.00 $73,584.00 $148,032.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $308,732.00 38.00 $47,108.00 $1,161.00 $2,033.00 $353.00 $2,214.00 $26,771.00 $14,576.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $47,108.00 39.00 $21,052,033.00 $3,756,118.00 $2,625,208.00 $3,197,538.00 $3,866,344.00 $4,540,165.00 $3,066,660.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $21,052,033.00 40.00 1.00 $16,537,291.00 $3,234,280.00 $1,883,752.00 $3,098,143.00 $2,380,061.00 $2,067,728.00 $3,873,327.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,537,291.00 41.00 1.00 $731,256.00 $23,952.00 $50,147.00 ($1,112.00) $29.00 $274,332.00 $383,908.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $731,256.00 42.00 $38,704,298.00 $7,034,057.00 $4,606,393.00 $6,304,366.00 $6,287,738.00 $6,983,594.00 $7,488,150.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $38,704,298.00 43.00 1.00 $67,420,844.00 $16,923,948.00 $12,871,773.00 $12,304,372.00 $7,256,845.00 $5,978,182.00 $12,085,724.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $214,680,727.00 201501.00 201502.00 201503.00 201504.00 201505.00 201506.00 201507.00 201508.00 201509.00 201510.00 201511.00 201512.00 44.00 1.00 ($5,601,800.00) ($1,044,935.00) ($1,131,484.00) ($1,128,135.00) ($958,901.00) ($966,487.00) ($371,858.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($5,601,800.00) 45.00 ($1,596,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) ($266,000.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,596,000.00) 46.00 1.00 ($11,054.00) ($3,058.00) ($288.00) ($6,108.00) ($1,600.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 47.00 1.00 ($823,086.00) $0.00 $0.00 $0.00 $0.00 $0.00 ($823,086.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($823,086.00) 48.00 1.00 ($49,932.00) $0.00 $0.00 $0.00 $0.00 $0.00 ($49,932.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 49.00 1.00 ($464,472.00) $0.00 $0.00 $0.00 $0.00 $0.00 ($464,472.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($464,472.00) 50.00 1.00 ($8,546,344.00) ($1,313,993.00) ($1,397,772.00) ($1,400,243.00) ($1,226,501.00) ($1,232,487.00) ($1,975,348.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($8,546,344.00) 51.00 1.00 $8,549,491.00 $1,467,061.00 $1,405,135.00 $1,468,815.00 $1,427,267.00 $1,380,691.00 $1,400,522.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,549,491.00 52.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 53.00 1.00 $12,180.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $2,030.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,180.00 54.00 1.00 $8,561,671.00 $1,469,091.00 $1,407,165.00 $1,470,845.00 $1,429,297.00 $1,382,721.00 $1,402,552.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8,561,671.00 55.00 1.00 $224,014.00 $31,018.00 $39,248.00 $35,278.00 $31,054.00 $45,056.00 $42,360.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 56.00 1.00 $3,303.00 $375.00 $1,281.00 $1,272.00 $375.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 57.00 1.00 $227,317.00 $31,393.00 $40,529.00 $36,550.00 $31,429.00 $45,056.00 $42,360.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 58.00 1.00 $22,541,835.00 $2,591,889.00 $4,538,335.00 $4,958,303.00 $3,500,937.00 $3,500,737.00 $3,451,634.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22,541,835.00 59.00 1.00 ($4,779,545.00) $814,972.00 $1,095,205.00 $41,601.00 ($1,727,201.00) ($2,781,563.00) ($2,222,559.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($4,779,545.00) 60.00 $1,375,960.00 $0.00 $0.00 $173,218.00 $102,290.00 $415,282.00 $685,170.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,375,960.00 61.00 ($1,375,960.00) $0.00 $0.00 ($173,218.00) ($102,290.00) ($415,282.00) ($685,170.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,375,960.00) 62.00 $20,672,101.00 $2,862,530.00 $1,424,635.00 $2,838,743.00 $3,289,671.00 $4,603,050.00 $5,653,472.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,672,101.00 63.00 ($15,986,823.00) ($2,013,173.00) ($3,448,826.00) ($3,528,867.00) ($2,401,120.00) ($2,192,179.00) ($2,402,658.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($15,986,823.00) 64.00 ($3,940,160.00) ($1,010,407.00) ($970,092.00) ($1,879,468.00) ($28,849.00) ($28,550.00) ($22,794.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($3,940,160.00) 65.00 ($23,679,460.00) ($3,952,616.00) ($3,378,430.00) ($3,336,760.00) ($3,415,778.00) ($4,086,650.00) ($5,509,226.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($23,679,460.00) 66.00 $259,824.00 $63,150.00 $7,360.00 $189,314.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $259,824.00 67.00 ($259,824.00) ($63,150.00) ($7,360.00) ($189,314.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($259,824.00) 68.00 1.00 ($5,172,052.00) ($706,805.00) ($739,173.00) ($906,448.00) ($782,340.00) ($985,155.00) ($1,052,131.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($5,172,052.00) 69.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 70.00 1.00 $832.00 $0.00 $0.00 $0.00 $832.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $832.00 71.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 72.00 1.00 $832.00 $0.00 0.00 $0.00 0.00 $0.00 $832.00 $0.00 $0.00 $0.00 $832.00 73.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 74.00 1.00 $337.00 $16.00 $27.00 $37.00 $56.00 $85.00 $116.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $337.00 75.00 1.00 $337.00 $16.00 $27.00 $37.00 $56.00 $85.00 $116.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $337.00 76.00 1.00 $290,000.00 $154,715.00 $0.00 $0.00 $135,285.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $290,000.00 77.00 1.00 $181,250.00 $181,250.00 $0.00 $0.00 $181,250.00 $0.00 $0.00 $181,250.00 $0.00 $0.00 $181,250.00 $0.00 $0.00 77.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 78.00 1.00 $22,968.00 $3,828.00 $3,828.00 $3,828.00 $3,828.00 $3,828.00 $3,828.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22,968.00 79.00 1.00 ($22,707.00) ($22,707.00) $3,828.00 $3,828.00 ($42,137.00) $3,828.00 $3,828.00 ($181,250.00) $0.00 $0.00 ($181,250.00) $0.00 $0.00 $0.00 $312,968.00 80.00 1.00 ($5,170,883.00) ($706,789.00) 0.00 ($739,146.00) 0.00 ($906,411.00) ($781,452.00) ($985,070.00) ($1,052,015.00) 0.00 ($4,464,094.00) 81.00 1.00 $62,443,073.00 $16,380,943.00 0.00 $12,186,377.00 $11,508,941.00 $6,667,481.00 $5,192,230.00 $10,507,101.00 tzj0fg: Fin Swaps Net gas not burned plus act v auth REC expense, and other misc rev's tzj0fg: If Act<Auth (+) Surcharge If Act>Auth (-) Rebate tzj0fg: BuckaBlock from Tara Knox - comes from Authorized Exhibits zero in 2012 tzj0fg: Bookouts tzj0fg: Lancaster tzj0fg: Inter Company - Ancil Services tzj0fg: Inter Co - Transmission tzj0fg: Clearwater included to offset any variance in SMUD sale 447 rev's for Brown Power No Longer use included Clr water RECS her due to new REC Deferral gaa9730: H:\Power Accountingk\Billings\Nicholspump gaa9730: Add these together tzj0fg: Financial tzj0fg: Physical gaa9730: This should be the KFWF Contract buyout TMM8381: Inventory adjustment expense, physical less than book tmm8381: Removed Kootenai Electric, Fighting Creek April 2014 month end per Cheryl Kettner & Gina Armstrong tmm8381: PWRCAP deal 100078 tmm8381: ACCTPW deal 100131 tmm8381: Power, deal 107240 tmm8381: PWRCAP deal 100085 tmm8381: ACCTPW deal 100137 tmm8381: Power deal 185895 tmm8381: Power deal 186298, currently does not include deal 186297 tmm8381: Power deal 223063 tmm8381: Was JP Morgan Wind: Contract ended April 2014 tmm8381: Power "Lancaster CT" tmm8381: Power deal 181462 tmm8381: Deal 573, actual volume tzj0fg: If Act<Auth (+) Surcharge If Act>Auth (-) Rebate tmm8381: Contract ended 12.31.14 tmm8381: Excluded in ERM, activity picked up in REC deferral for WA. tmm8381: Booked Q1 NSJ 013 (201503) to recognize company benefit portion of Spokane Energy capacity purchase/sale to 557160 ED WA for WA portion. Do not want to capture in ERM deferral calculation. Already added in as Resouce Optimization on WA Summary tab, $1,449,000 per month for January, February & March to calculate monthly amount for interest. TM 4.8.15 CKettner: Prior to June 2015, per the note of "Do not include Low Voltage", it was not being picked up. It is in Authorized, so the past amounts and the June amount are being picked up for June. CKettner: Prior to June 2015, per the note of "Do not include Low Voltage", it was not being picked up. It is in Authorized, so the past amounts and the June amount are being picked up for June. - Page of 3 ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 1.00 $88,800,154.00 $18,508,249.00 $18,369,404.00 $16,707,284.00 $12,949,168.00 $10,442,007.00 $11,824,042.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 2.00 1.00 ($73,600,275.00) ($11,643,072.00) ($10,823,998.00) ($13,235,802.00) ($14,504,101.00) ($13,592,868.00) ($9,800,434.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4.00 $13,516,667.00 $3,024,714.00 $719,974.00 $2,528,524.00 $2,524,040.00 $2,145,449.00 $2,573,966.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5.00 $38,704,298.00 $7,034,057.00 $4,606,393.00 $6,304,366.00 $6,287,738.00 $6,983,594.00 $7,488,150.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 6.00 ($8,546,344.00) ($1,313,993.00) ($1,397,772.00) ($1,400,243.00) ($1,226,501.00) ($1,232,487.00) ($1,975,348.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 7.00 $8,561,671.00 $1,469,091.00 $1,407,165.00 $1,470,845.00 $1,429,297.00 $1,382,721.00 $1,402,552.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 8.00 $227,317.00 $31,393.00 $40,529.00 $36,550.00 $31,429.00 $45,056.00 $42,360.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 9.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10.00 $67,663,488.00 $17,110,439.00 $12,921,695.00 $12,411,524.00 $7,491,070.00 $6,173,472.00 $11,555,288.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ?1?/?31?/?2015 ?2?/?28?/?2015 ?3?/?31?/?2015 ?4?/?30?/?2015 ?5?/?31?/?2015 ?6?/?30?/?2015 ?7?/?31?/?2015 ?8?/?31?/?2015 ?9?/?30?/?2015 ?10?/?31?/?2015 ?11?/?30?/?2015 ?12?/?31?/?2015 11.00 1.00 $67,667,968.00 $14,241,308.00 $12,816,216.00 $12,684,102.00 $10,157,992.00 $8,801,839.00 $8,966,511.00 $9,032,312.00 $10,449,135.00 $8,227,612.00 $8,950,494.00 $12,731,418.00 $12,617,776.00 12.00 ($46,735,623.00) ($5,385,864.00) ($7,026,454.00) ($8,167,295.00) ($8,655,099.00) ($9,111,902.00) ($8,389,009.00) ($5,130,621.00) ($3,284,320.00) ($4,661,364.00) ($4,875,558.00) ($6,000,154.00) ($4,742,812.00) 13.00 1.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 14.00 1.00 $12,972,288.00 $2,663,532.00 $2,484,671.00 $2,578,707.00 $2,068,252.00 $1,665,745.00 $1,511,381.00 $2,254,578.00 $2,621,357.00 $2,672,936.00 $2,757,933.00 $2,649,850.00 $2,700,185.00 15.00 $40,434,825.00 $10,133,311.00 $9,419,650.00 $9,305,476.00 $5,867,735.00 $3,112,735.00 $2,595,918.00 $5,623,100.00 $7,743,935.00 $8,219,145.00 $8,834,779.00 $9,035,104.00 $9,873,776.00 16.00 ($7,618,598.00) ($1,304,329.00) ($1,105,921.00) ($1,123,977.00) ($1,154,782.00) ($1,377,232.00) ($1,552,357.00) ($1,659,835.00) ($1,502,892.00) ($1,306,364.00) ($1,460,291.00) ($1,241,936.00) ($1,225,427.00) 17.00 $8,395,035.00 $1,447,542.00 $1,429,504.00 $1,405,324.00 $1,394,208.00 $1,365,074.00 $1,353,383.00 $1,377,511.00 $1,429,273.00 $1,414,185.00 $1,374,889.00 $1,403,813.00 $1,423,031.00 18.00 $538,000.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 $89,667.00 $89,667.00 $89,666.00 19.00 $75,653,895.00 $21,885,167.00 $18,107,333.00 $16,772,003.00 $9,767,973.00 $4,545,926.00 $4,575,493.00 $11,586,712.00 $17,546,155.00 $14,655,816.00 $15,671,913.00 $18,667,762.00 $20,736,195.00 20.00 ($7,990,407.00) 0.00 ($4,774,728.00) 0.00 ($5,185,638.00) ($4,360,479.00) ($2,276,903.00) $1,627,546.00 $6,979,795.00 0.00 21.00 ($5,170,883.00) ($706,789.00) ($739,146.00) ($906,411.00) ($781,452.00) ($985,070.00) ($1,052,015.00) ($4,347,000.00) ($4,347,000.00) -4347000.00 ($966,000.00) 22.00 1.00 ($18,474,290.00) ($5,481,517.00) ($5,924,784.00) 0.00 0.00 ($9,613,890.00) 0.00 0.00 ($3,058,355.00) 0.00 0.00 $642,476.00 $4,961,780.00 0.00 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 23.00 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 24.00 ($12,043,391.00) ($3,573,401.00) ($3,862,367.00) ($6,267,295.00) ($1,993,742.00) $418,830.00 $3,234,584.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25.00 ($49,532.00) ($22,707.00) $3,828.00 $3,828.00 ($42,137.00) $3,828.00 $3,828.00 ($181,250.00) $0.00 $0.00 ($181,250.00) $0.00 $0.00 26.00 $557,805.00 $262,948.00 $910,309.00 $465,355.00 ($286,147.00) $214,781.00 ($1,009,441.00) 27.00 ($11,535,118.00) ($3,333,160.00) 0.00 ($2,948,230.00) ($5,798,112.00) ($2,322,026.00) $637,439.00 $2,228,971.00 28.00 $0.00 29.00 ($3,333,160.00) 0.00 ($6,281,390.00) 0.00 ($12,079,502.00) ($14,401,528.00) ($13,764,089.00) ($11,535,118.00) 0.00 0.00 10000000.00 0.90 0.90 $0.00 $0.00 ($2,079,502.00) ($4,401,528.00) ($3,764,089.00) ($1,535,118.00) 4000000.00 to $#,##0,, M to $10M 0.50 0.75 $0.00 ($2,281,390.00) ($6,000,000.00) ($6,000,000.00) ($6,000,000.00) ($6,000,000.00) 0.00 to $#,##0,, M to $4M 0.00 0.00 ($3,333,160.00) ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) ($4,000,000.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,711,043.00) ($6,371,552.00) ($8,461,375.00) ($7,887,680.00) ($5,881,606.00) 0.00 0.00 0.00 0.00 $0.00 0.00 ($1,711,043.00) ($4,660,509.00) 0.00 ($2,089,823.00) $573,695.00 $2,006,074.00 0.00 0.00 $5,881,606.00 $0.00 0.00 $1,711,043.00 $4,660,509.00 $2,089,823.00 ($573,695.00) ($2,006,074.00) ($3,333,160.00) ($4,570,347.00) 0.00 ($5,707,950.00) ($5,940,153.00) ($5,876,409.00) ($5,653,512.00) ($3,298,835.00) ($34,325.00) Updated Feb. 2013 to correct Authorized gaa9730: Authorized doesn't include SMUD RECS tmm8381: Contract ended 12.31.15 1.00 2.00 3.00 4.00 5.00 6.00 7.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 1.00 2.00 3.00 4.00 4.00 1.00 2.00 3.00 1.00 2.00 3.00 4.00 5.00 1.00 2.00 sw ?1?/?1?/?2008 ?2?/?1?/?2008 ?3?/?1?/?2008 ?4?/?1?/?2008 ?5?/?1?/?2008 ?6?/?1?/?2008 ?7?/?1?/?2008 ?8?/?1?/?2008 ?9?/?1?/?2008 ?10?/?1?/?2008 ?11?/?1?/?2008 ?12?/?1?/?2008 555 Purchased Power $45,988,961.00 $18,508,249.00 $14,241,308.00 $4,266,941.00 $18,369,404.00 $12,816,216.00 $5,553,188.00 $16,707,284.00 $12,684,102.00 $4,023,182.00 $12,949,168.00 $10,157,992.00 $2,791,176.00 $10,442,007.00 $8,801,839.00 $1,640,168.00 $11,824,042.00 $8,966,511.00 $2,857,531.00 $0.00 $9,032,312.00 ($9,032,312.00) $0.00 $10,449,135.00 ($10,449,135.00) $0.00 $8,227,612.00 ($8,227,612.00) $0.00 $8,950,494.00 ($8,950,494.00) $0.00 $12,731,418.00 ($12,731,418.00) $0.00 $12,617,776.00 ($12,617,776.00) 501 Thermal Fuel $8,250,817.00 $3,024,714.00 $2,663,532.00 $361,182.00 $719,974.00 $2,484,671.00 ($1,764,697.00) $2,528,524.00 $2,578,707.00 ($50,183.00) $2,524,040.00 $2,068,252.00 $455,788.00 $2,145,449.00 $1,665,745.00 $479,704.00 $2,573,966.00 $1,511,381.00 $1,062,585.00 $0.00 $2,254,578.00 ($2,254,578.00) $0.00 $2,621,357.00 ($2,621,357.00) $0.00 $2,672,936.00 ($2,672,936.00) $0.00 $2,757,933.00 ($2,757,933.00) $0.00 $2,649,850.00 ($2,649,850.00) $0.00 $2,700,185.00 ($2,700,185.00) 547 CT Fuel $21,776,508.00 $7,034,057.00 $10,133,311.00 ($3,099,254.00) $4,606,393.00 $9,419,650.00 ($4,813,257.00) $6,304,366.00 $9,305,476.00 ($3,001,110.00) $6,287,738.00 $5,867,735.00 $420,003.00 $6,983,594.00 $3,112,735.00 $3,870,859.00 $7,488,150.00 $2,595,918.00 $4,892,232.00 $0.00 $5,623,100.00 ($5,623,100.00) $0.00 $7,743,935.00 ($7,743,935.00) $0.00 $8,219,145.00 ($8,219,145.00) $0.00 $8,834,779.00 ($8,834,779.00) $0.00 $9,035,104.00 ($9,035,104.00) $0.00 $9,873,776.00 ($9,873,776.00) 447 Sale for Resale ($40,370,971.00) ($11,643,072.00) ($5,385,864.00) ($6,257,208.00) ($10,823,998.00) ($7,026,454.00) ($3,797,544.00) ($13,235,802.00) ($8,167,295.00) ($5,068,507.00) ($14,504,101.00) ($8,655,099.00) ($5,849,002.00) ($13,592,868.00) ($9,111,902.00) ($4,480,966.00) ($9,800,434.00) ($8,389,009.00) ($1,411,425.00) $0.00 ($5,130,621.00) $5,130,621.00 $0.00 ($3,284,320.00) $3,284,320.00 $0.00 ($4,661,364.00) $4,661,364.00 $0.00 ($4,875,558.00) $4,875,558.00 $0.00 ($6,000,154.00) $6,000,154.00 $0.00 ($4,742,812.00) $4,742,812.00 $1,469,091.00 $1,447,542.00 $21,549.00 $1,407,165.00 $1,429,504.00 ($22,339.00) $1,470,845.00 $1,405,324.00 $65,521.00 $1,429,297.00 $1,394,208.00 $35,089.00 $1,382,721.00 $1,365,074.00 $17,647.00 $1,402,552.00 $1,353,383.00 $49,169.00 $0.00 $1,377,511.00 ($1,377,511.00) $0.00 $1,429,273.00 ($1,429,273.00) $0.00 $1,414,185.00 ($1,414,185.00) $0.00 $1,374,889.00 ($1,374,889.00) $0.00 $1,403,813.00 ($1,403,813.00) $0.00 $1,423,031.00 ($1,423,031.00) ($1,313,993.00) ($1,304,329.00) ($9,664.00) 0.66 ($1,397,772.00) ($1,105,921.00) ($291,851.00) ($1,400,243.00) ($1,123,977.00) ($276,266.00) ($1,226,501.00) ($1,154,782.00) ($71,719.00) ($1,232,487.00) ($1,377,232.00) $144,745.00 ($1,975,348.00) ($1,552,357.00) ($422,991.00) $0.00 ($1,659,835.00) $1,659,835.00 $0.00 ($1,502,892.00) $1,502,892.00 $0.00 ($1,306,364.00) $1,306,364.00 $0.00 ($1,460,291.00) $1,460,291.00 $0.00 ($1,241,936.00) $1,241,936.00 $0.00 ($1,225,427.00) $1,225,427.00 Resource Optimization - Subtotal ($706,789.00) $0.00 ($706,789.00) ($739,146.00) ($739,146.00) ($906,411.00) ($906,411.00) ($781,452.00) $0.00 ($781,452.00) ($985,070.00) ($1,052,015.00) 0.66 557 Broker Fees $65,694.00 $31,393.00 $89,667.00 ($58,274.00) $40,529.00 $89,667.00 ($49,138.00) $36,550.00 $89,666.00 ($53,116.00) $31,429.00 $89,667.00 ($58,238.00) $45,056.00 $89,667.00 ($44,611.00) $42,360.00 $89,666.00 ($47,306.00) $0.00 $89,667.00 ($89,667.00) $0.00 $89,667.00 $0.00 $89,666.00 ($89,666.00) $0.00 $89,667.00 ($89,667.00) $0.00 $89,667.00 ($89,667.00) $0.00 $89,666.00 ($89,666.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,505,113.00 $6,709,618.00 $5,188,402.00 $10,503,273.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Adjusted Net Expense $35,711,009.00 $16,403,650.00 $12,182,549.00 $11,505,113.00 $6,709,618.00 $5,188,402.00 $10,503,273.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10798523.00 0.66 0.66 8019772.00 0.66 0.66 7573816.00 0.66 0.66 4416942.00 0.66 0.66 3415525.00 0.66 0.66 6914305.00 0.66 0.66 0.00 0.66 0.66 0.00 0.66 0.66 0.00 0.66 0.66 0.00 0.66 0.66 0.00 0.66 0.66 0.00 0.66 0.66 $2,070,053.00 $2,070,053.00 $262,948.00 $262,948.00 $910,309.00 $910,309.00 $465,355.00 $465,355.00 $206,958.00 $206,958.00 $1,303,361.00 $1,303,361.00 ($1,009,441.00) ($1,009,441.00) $1,047,830.00 $1,047,830.00 Net Power Cost (+) Surcharge (-) Rebate $637,439.00 0.90 1.00 0.90 929759.00 969458.00 39699.00 927800.00 -1959.00 -1290.00 0.66 $92,777.00 799025.00 834330.00 35305.00 819900.00 20875.00 13742.00 0.66 ($925,111.00) 798494.00 835957.00 37463.00 835700.00 37206.00 24493.00 0.66 ($1,753,699.00) 730822.00 762494.00 31672.00 704400.00 -26422.00 17394.00 0.66 $1,537,804.00 693621.00 727927.00 34306.00 698800.00 5179.00 -3409.00 0.66 -181700.00 678119.00 711210.00 33091.00 688800.00 10681.00 -7031.00 0.66 -116293.00 764120.00 798625.00 34505.00 762800.00 -1320.00 869.00 0.66 50237.00 745365.00 782126.00 36761.00 791000.00 45635.00 -30042.00 0.66 -1914877.00 673392.00 700540.00 27148.00 695500.00 22108.00 -14554.00 0.66 -740944.00 726525.00 758273.00 31748.00 769600.00 43075.00 28356.00 0.66 -1331598.00 746122.00 784278.00 38156.00 760300.00 14178.00 9333.00 0.66 ($433,051.00) 945765.00 984142.00 38377.00 897100.00 48665.00 32036.00 0.66 $1,928,247.00 612060.00 0.66 610771.00 0.66 -1289.00 525998.00 0.66 539740.00 0.66 13742.00 460020.00 0.66 0.00 0.00 457848.00 0.66 457848.00 556497.00 559753.00 3256.00 507980.00 502124.00 -5856.00 476148.00 514703.00 38555.00 432520.00 437704.00 5184.00 398505.00 429845.00 31340.00 390087.00 414160.00 24073.00 434299.00 459551.00 25252.00 434143.00 474756.00 40613.00 15000.00 -146100.00 ($96,178.00) 0.66 0.00 323950.00 -323950.00 213256.00 0.66 $15,269,130.00 0.00 0.00 0.00 147400.00 1522642.00 $1,002,355.00 0.66 228850.00 228850.00 -150652.00 0.66 ($10,786,683.00) 0.00 0.00 0.00 7080040.00 331554.00 157490.00 100221.00 73843.00 352500.00 337500.00 15000.00 -20946.00 -13789.00 $991,705.00 282837.00 282837.00 370700.00 359100.00 11600.00 -87863.00 57840.00 0.66 $3,893,789.00 331107.00 148074.00 124035.00 58998.00 343400.00 333300.00 10100.00 -12293.00 8092.00 0.66 $579,387.00 334852.00 473000.00 461600.00 11400.00 -138148.00 90943.00 0.66 $8,040,271.00 657019.00 450132.00 120566.00 86321.00 699200.00 687700.00 11500.00 -42181.00 27768.00 0.66 $1,480,034.00 698946.00 489979.00 116611.00 92356.00 697300.00 685000.00 12300.00 1646.00 -1084.00 0.66 ($17,929.00) 561735.00 484300.00 473100.00 11200.00 77435.00 -50975.00 0.66 ($2,946,865.00) 284087.00 289500.00 279900.00 9600.00 -5413.00 3563.00 0.66 227106.00 251337.00 229700.00 222500.00 7200.00 21637.00 -14244.00 0.66 -725162.00 272599.00 272599.00 232700.00 223900.00 8800.00 39899.00 26266.00 0.66 ($1,233,451.00) 280180.00 250100.00 240200.00 9900.00 30080.00 19802.00 0.66 ($918,813.00) 371146.00 191544.00 97343.00 82259.00 354400.00 342800.00 11600.00 16746.00 11024.00 0.66 ($663,535.00) 189009.00 191762.00 -2753.00 163948.00 154932.00 9016.00 5935.00 ($426,845.00) 153371.00 146356.00 7015.00 -4618.00 ($310,884.00) 163178.00 151397.00 11781.00 -7755.00 0.66 ($555,258.00) 150929.00 124649.00 26280.00 -17300.00 ($1,529,493.00) 137537.00 102558.00 34979.00 -23027.00 ($1,227,339.00) 73250.00 122128.00 -48878.00 32176.00 $532,191.00 140563.00 154838.00 -14275.00 9397.00 $543,241.00 153906.00 156448.00 -2542.00 1673.00 106637.00 134230.00 151403.00 -17173.00 11305.00 575538.00 163230.00 155183.00 8047.00 5297.00 ($248,747.00) 159637.00 151403.00 8234.00 5420.00 ($251,488.00) 163880.00 153931.00 9949.00 6549.00 ($394,184.00) 282523.00 3333167.00 -3050644.00 29837.00 33513.00 -3676.00 -2420.00 $174,046.00 30893.00 31625.00 -732.00 482.00 $32,448.00 29524.00 33969.00 -4445.00 2926.00 0.66 $209,502.00 5075.00 32618.00 -27543.00 18132.00 $1,603,050.00 469.00 2427.00 -1958.00 1289.00 $68,704.00 -216.00 0.00 -216.00 142.00 $2,349.00 0.00 31474.00 -31474.00 20719.00 $1,197,765.00 22350.00 33683.00 -11333.00 7461.00 475564.00 13504.00 32911.00 -19407.00 12776.00 650426.00 8562.00 34300.00 -25738.00 -16943.00 $795,643.00 27374.00 33194.00 -5820.00 -3831.00 $177,758.00 33336.00 34300.00 -964.00 -635.00 $38,221.00 -2736.00 11149.00 -13885.00 1083.00 117.00 966.00 636.00 ($45,741.00) 210.00 181.00 29.00 -19.00 ($1,279.00) 202.00 104.00 98.00 -65.00 ($4,654.00) 0.00 32.00 -32.00 21.00 $1,857.00 0.00 25.00 -25.00 16.00 $853.00 0.00 30.00 -30.00 20.00 $331.00 0.00 457.00 -457.00 301.00 $17,401.00 959.00 768.00 191.00 -126.00 -8031.00 157.00 833.00 -676.00 445.00 22655.00 0.00 385.00 -385.00 -253.00 $11,881.00 0.00 435.00 -435.00 -286.00 $13,270.00 151.00 180.00 -29.00 -19.00 $1,144.00 1356.00 -33311.00 34667.00 31.00 0.00 31.00 20.00 ($1,438.00) 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 $0.00 24.00 24.00 -16.00 ($1,415.00) 547.00 547.00 -360.00 ($19,188.00) 0.00 0.00 0.00 $0.00 0.00 103.00 -103.00 68.00 $3,931.00 985.00 140.00 845.00 -556.00 -35439.00 0.00 52.00 -52.00 34.00 1731.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 0.00 $0.00 2899.00 23308.00 -20409.00 1611.00 45.00 1566.00 1031.00 ($74,150.00) -39.00 0.00 -39.00 26.00 $1,750.00 -18.00 -18.00 12.00 $859.00 -13.00 -13.00 9.00 $796.00 -30.00 -30.00 20.00 $1,066.00 28.00 27.00 1.00 -1.00 ($17.00) 1493.00 809.00 684.00 -450.00 ($26,015.00) 24.00 1196.00 -1172.00 772.00 49207.00 -45.00 697.00 -742.00 488.00 24844.00 206.00 0.00 206.00 136.00 ($6,387.00) -62.00 26.00 -88.00 -58.00 $2,691.00 9912.00 0.00 9912.00 6525.00 ($392,740.00) 8880.00 -306923.00 315803.00 5403.00 87.00 5316.00 3500.00 ($251,720.00) 600.00 65.00 535.00 -352.00 ($23,697.00) 84.00 125.00 -41.00 27.00 $1,933.00 3769.00 24.00 3745.00 -2465.00 ($217,931.00) 112.00 8.00 104.00 -68.00 ($3,624.00) 109.00 52.00 57.00 -38.00 ($629.00) 1145.00 906.00 239.00 -157.00 ($9,076.00) 3407.00 1419.00 1988.00 -1309.00 -83436.00 1577.00 1393.00 184.00 -121.00 -6160.00 233.00 349.00 -116.00 -76.00 $3,569.00 63.00 246.00 -183.00 -120.00 $5,568.00 4107.00 73.00 4034.00 2656.00 ($159,865.00) -3295275.00 -3817207.00 521932.00 188733.00 86897.00 101836.00 67039.00 ($4,821,445.00) 186014.00 96660.00 89354.00 -58822.00 ($3,959,897.00) 178323.00 92510.00 85813.00 -56491.00 0.66 ($4,044,756.00) 94865.00 48387.00 46478.00 -30596.00 ($2,704,992.00) 45002.00 40653.00 4349.00 -2863.00 ($152,598.00) 3274.00 31981.00 -28707.00 18898.00 $312,573.00 99684.00 103983.00 -4299.00 2830.00 $163,602.00 179819.00 134233.00 45586.00 -30009.00 -1912774.00 176348.00 155354.00 20994.00 -13820.00 -703576.00 189295.00 152825.00 36470.00 24008.00 ($1,127,416.00) 166974.00 153389.00 13585.00 8943.00 ($414,955.00) 187988.00 134092.00 53896.00 35480.00 0.66 ($2,135,541.00) -60840.00 -144722.00 83882.00 76140.00 66000.00 10140.00 6675.00 ($480,066.00) 68800.00 61700.00 7100.00 -4674.00 ($314,654.00) 37590.00 32600.00 4990.00 -3285.00 ($235,206.00) 36407.00 31600.00 4807.00 -3164.00 ($279,729.00) 0.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 76757.00 63800.00 12957.00 8530.00 ($395,792.00) 79305.00 66000.00 13305.00 8759.00 ($527,204.00) 46090.00 -12933.00 59023.00 1081.00 1700.00 -619.00 -407.00 $29,271.00 942.00 1900.00 100.00 700.00 400.00 600.00 100.00 -958.00 631.00 $42,479.00 1433.00 2200.00 100.00 700.00 500.00 600.00 300.00 -767.00 505.00 $36,158.00 2335.00 3300.00 -965.00 635.00 $56,140.00 2879.00 2900.00 -21.00 14.00 $746.00 3170.00 3200.00 -30.00 20.00 $331.00 3174.00 2200.00 974.00 -641.00 ($37,056.00) 1907.00 900.00 1007.00 -663.00 -42260.00 1063.00 600.00 463.00 -305.00 -15528.00 833.00 800.00 33.00 22.00 ($1,033.00) 871.00 1000.00 -129.00 -85.00 $3,944.00 1131.00 1300.00 -169.00 -111.00 $6,681.00 116219.00 -69042.00 185261.00 3627.00 5300.00 -1673.00 -1101.00 $79,184.00 2814.00 8200.00 -5386.00 3546.00 $238,717.00 7693.00 9700.00 -2007.00 1321.00 $94,584.00 8035.00 10200.00 -2165.00 1425.00 $125,984.00 4725.00 9200.00 -4475.00 2946.00 $157,022.00 4682.00 5300.00 -618.00 407.00 $6,732.00 4257.00 0.00 4257.00 -2802.00 ($161,984.00) -269.00 -2000.00 1731.00 -1140.00 -72664.00 1109.00 -500.00 1609.00 -1059.00 -53914.00 2388.00 700.00 1688.00 1111.00 ($52,173.00) 2518.00 1100.00 1418.00 933.00 ($43,291.00) 4469.00 3100.00 1369.00 901.00 ($54,231.00) 27297.00 119536.00 -92239.00 1128.00 1800.00 -672.00 -442.00 $31,789.00 1110.00 1800.00 -690.00 454.00 $30,563.00 1716.00 2100.00 -384.00 253.00 $18,115.00 2078.00 2100.00 -22.00 14.00 $1,238.00 5219.00 3400.00 1819.00 -1197.00 ($63,800.00) 5982.00 4700.00 1282.00 -844.00 ($13,960.00) 4023.00 5100.00 -1077.00 709.00 $40,987.00 1935.00 3900.00 -1965.00 1294.00 82480.00 1010.00 1700.00 -690.00 454.00 23113.00 909.00 2000.00 -1091.00 -718.00 $33,717.00 918.00 1800.00 -882.00 -581.00 $26,958.00 541.00 1800.00 -1259.00 -829.00 $49,898.00 79239.00 72636.00 6603.00 12982.00 12900.00 82.00 54.00 ($3,884.00) 12227.00 12200.00 27.00 -18.00 ($1,212.00) 13140.00 13200.00 -60.00 39.00 $2,792.00 18845.00 18900.00 -55.00 36.00 $3,183.00 23684.00 23700.00 -16.00 11.00 $586.00 22750.00 22800.00 -50.00 33.00 $546.00 20526.00 20500.00 26.00 -17.00 ($983.00) 14649.00 14700.00 -51.00 34.00 2167.00 13667.00 13700.00 -33.00 22.00 1120.00 13947.00 13900.00 47.00 31.00 ($1,456.00) 13856.00 13800.00 56.00 37.00 ($1,717.00) 14298.00 14300.00 -2.00 -1.00 $60.00 392422.00 1243160.00 -850738.00 0.00 8500.00 -8500.00 -5596.00 $402,464.00 0.00 7900.00 -7900.00 5201.00 $350,131.00 0.00 8500.00 -8500.00 5596.00 $400,674.00 0.00 8200.00 -8200.00 5398.00 $477,237.00 0.00 8500.00 -8500.00 5596.00 $298,267.00 0.00 6000.00 -6000.00 3950.00 $65,333.00 0.00 8500.00 -8500.00 5596.00 $323,505.00 0.00 8500.00 -8500.00 5596.00 356689.00 0.00 8200.00 -8200.00 5398.00 274812.00 0.00 8500.00 -8500.00 -5596.00 $262,788.00 0.00 8200.00 -8200.00 -5398.00 $250,467.00 0.00 8500.00 -8500.00 -5596.00 $336,823.00 13767.00 24844.00 -11077.00 2667.00 3200.00 -533.00 -351.00 $25,244.00 2710.00 3000.00 -290.00 191.00 $12,858.00 3246.00 3200.00 46.00 -30.00 ($2,148.00) 3013.00 3100.00 -87.00 57.00 $5,039.00 3646.00 3200.00 446.00 -294.00 ($15,670.00) 3282.00 3100.00 182.00 -120.00 ($1,985.00) 2685.00 3200.00 -515.00 339.00 $19,598.00 3427.00 3200.00 227.00 -149.00 -9497.00 2570.00 3100.00 -530.00 349.00 17768.00 3625.00 3200.00 425.00 280.00 ($13,149.00) 3160.00 3100.00 60.00 39.00 ($1,810.00) 3549.00 3200.00 349.00 230.00 ($13,844.00) -140180.00 -277712.00 137532.00 6943.00 6200.00 743.00 489.00 ($35,169.00) 7619.00 4400.00 3219.00 -2119.00 ($142,651.00) 10000.00 6300.00 3700.00 -2436.00 ($174,418.00) 9549.00 5300.00 4249.00 -2797.00 ($247,283.00) 7320.00 6400.00 920.00 -606.00 ($32,300.00) 9736.00 6600.00 3136.00 -2064.00 ($34,139.00) 6745.00 6100.00 645.00 -425.00 ($24,569.00) 6050.00 6100.00 -50.00 33.00 2103.00 3633.00 5500.00 -1867.00 1229.00 62568.00 4605.00 5600.00 -995.00 -655.00 $30,759.00 4901.00 6400.00 -1499.00 -987.00 $45,797.00 6276.00 2700.00 3576.00 2354.00 ($141,687.00) $7.42 $8.10 601188.00 $7.85 $7.85 $7.66 $9.79 $7.13 ($2.66) $10.33 $7.10 $11.10 $7.19 $9.35 $7.27 $2.08 $8.37 $7.35 $8.57 $7.40 $7.93 $7.53 $7.80 $7.95 $7.76 $8.40 $71.92 $61.59 $10.33 $67.32 $60.86 ($6.46) $71.60 $60.60 $11.00 $88.41 $58.29 ($30.12) $53.30 $58.58 $16.54 $0.00 $64.69 $67.00 ($2.31) $63.74 $62.11 $50.91 $66.52 $46.96 $66.11 $43.88 $64.88 $60.19 $66.84 $62.99 $53.25 $9.74 $68.23 $59.41 ($8.82) $69.92 $53.60 $82.69 $47.06 $35.63 $55.66 $39.87 $31.60 $35.41 $57.81 $49.12 $8.69 $66.75 $58.13 $55.62 $56.27 $51.14 $54.45 $46.40 $62.44 $50.20 $66.84 $10.33 $8.64 $11.33 $8.64 $10.37 $8.64 $9.80 $8.64 $9.20 $8.64 $8.64 $10.97 $8.64 $2.33 $8.64 $9.39 $8.64 $8.32 $8.64 $7.10 $8.64 $8.64 $874,112.00 872100.00 2012.00 $963,808.00 ($89,696.00) ($59,047.00) 0.66 $114,999.00 $925,212.00 $909,218.00 $15,994.00 $10,529.00 0.66 $1,024,893.00 $976,372.00 $48,521.00 $31,941.00 0.66 $186,627.00 $937,983.00 ($751,356.00) ($494,618.00) 0.66 $50,016.00 $70,701.00 ($20,685.00) ($13,617.00) 0.66 ($51,371.00) $0.00 ($51,371.00) ($33,818.00) 0.66 ($3,169.00) $907,141.00 ($910,310.00) ($599,257.00) 0.66 $0.00 $968,779.00 ($968,779.00) ($637,747.00) $963,741.00 $945,888.00 $17,853.00 $11,753.00 0.66 $310,535.00 $985,759.00 ($675,224.00) ($444,500.00) 0.66 $991,364.00 $953,961.00 $37,403.00 $24,622.00 0.66 $1,496,899.00 $985,759.00 $511,140.00 $336,483.00 0.66 $1,693,941.00 $1,338,874.00 $355,067.00 $233,741.00 ($193,104.00) $1,738,116.00 $1,264,764.00 $473,352.00 $311,608.00 $1,691,663.00 $1,308,319.00 $383,344.00 $252,355.00 $1,479,583.00 $1,077,180.00 $402,403.00 $264,902.00 $1,265,176.00 $886,276.00 $378,900.00 $249,430.00 $784,963.00 $1,055,387.00 ($270,424.00) ($178,020.00) $1,541,332.00 $1,338,060.00 $203,272.00 $133,814.00 $0.00 $1,351,971.00 ($1,351,971.00) ($890,003.00) $1,260,985.00 $1,308,376.00 ($47,391.00) ($31,197.00) $1,358,851.00 $1,341,037.00 $17,814.00 $11,727.00 $1,132,866.00 $1,308,376.00 ($175,510.00) ($115,538.00) $3,575,916.00 $1,330,222.00 $2,245,694.00 $1,478,340.00 12803.00 $21,500.00 ($8,697.00) ($5,725.00) ($5,725.00) $0.00 $21,500.00 ($21,500.00) ($14,153.00) $565.00 $21,500.00 ($20,935.00) ($13,782.00) $9,391.00 $21,500.00 ($12,109.00) ($7,971.00) 14693.00 $21,500.00 ($6,807.00) ($4,481.00) $20,872.00 $21,500.00 ($628.00) ($413.00) $354.00 $21,500.00 ($21,146.00) ($13,920.00) $0.00 $21,500.00 ($21,500.00) ($14,153.00) $2,816.00 $21,500.00 ($18,684.00) ($12,300.00) $75,164.00 $21,500.00 $53,664.00 $35,327.00 $2,533.00 $21,500.00 ($18,967.00) ($12,486.00) $0.00 $21,500.00 ($21,500.00) ($14,153.00) $10,182,899.00 $4,867,055.00 $5,315,844.00 $3,499,420.00 ($1,322,025.00) $10,099,474.00 $5,347,254.00 $4,752,220.00 $3,128,386.00 $9,822,823.00 $4,986,965.00 $4,835,858.00 $3,183,445.00 $6,581,106.00 $2,452,270.00 $4,128,836.00 $2,718,013.00 $3,192,828.00 $2,099,641.00 $1,093,187.00 $719,645.00 $329,813.00 $1,717,818.00 ($1,388,005.00) ($913,724.00) $6,673,809.00 $5,500,834.00 $1,172,975.00 $772,169.00 $10,529,339.00 $7,042,078.00 $3,487,261.00 $2,295,664.00 $10,577,865.00 $8,125,040.00 $2,452,825.00 $1,614,695.00 $10,488,426.00 $8,053,724.00 $2,434,702.00 $1,602,764.00 $9,110,372.00 $8,545,976.00 $564,396.00 $371,542.00 $10,274,415.00 $8,037,225.00 $2,237,190.00 $1,472,742.00 $108,578.00 $8,912.00 $99,666.00 $65,610.00 $19,869.00 $19,666.00 $13,655.00 $6,011.00 $3,957.00 $19,133.00 $7,523.00 $11,610.00 $7,643.00 $1,228.00 $2,169.00 ($941.00) ($619.00) ($2,347.00) $1,661.00 ($4,008.00) ($2,638.00) ($3,137.00) $2,097.00 ($5,234.00) ($3,446.00) $9,531.00 $32,143.00 ($22,612.00) ($14,885.00) $0.00 $54,496.00 ($54,496.00) ($35,875.00) $16,920.00 $58,460.00 ($41,540.00) ($27,346.00) ($461.00) $26,948.00 ($27,409.00) ($18,043.00) ($100.00) $32,847.00 ($32,947.00) ($21,689.00) $14,439.00 $15,066.00 ($627.00) ($413.00) $427,640.00 $6,813.00 $420,827.00 $277,030.00 $25,310.00 $52,113.00 $5,093.00 $47,020.00 $30,953.00 $12,878.00 $9,304.00 $3,574.00 $2,353.00 376549.00 $1,649.00 $374,900.00 $246,797.00 $20,022.00 $535.00 $19,487.00 $12,828.00 $19,673.00 $3,735.00 $15,938.00 $10,492.00 $114,111.00 $65,731.00 $48,380.00 $31,849.00 $0.00 $104,090.00 ($104,090.00) ($68,522.00) $138,663.00 $100,859.00 $37,804.00 $24,886.00 $28,001.00 $25,111.00 $2,890.00 $1,902.00 $11,330.00 $19,231.00 ($7,901.00) ($5,201.00) $319,156.00 $6,379.00 $312,777.00 $205,901.00 $160,396.00 $4,234.00 $156,162.00 $102,801.00 $28,651.00 ($493.00) ($493.00) ($325.00) ($1,709.00) ($1,709.00) ($1,125.00) -16690.00 ($16,690.00) ($10,987.00) ($5,531.00) $0.00 ($5,531.00) ($3,641.00) $2,364.00 $2,279.00 $85.00 $56.00 $207,422.00 $70,824.00 $136,598.00 $89,922.00 $0.00 $107,456.00 ($107,456.00) ($70,738.00) ($26.00) $61,156.00 ($61,182.00) ($40,276.00) $29,292.00 $29,292.00 $19,283.00 $804.00 $2,506.00 ($1,702.00) ($1,120.00) $953,206.00 $0.00 $953,206.00 $627,496.00 $3,168.00 $0.00 $3,168.00 $2,085.00 $647.00 $60,320.00 $60,320.00 $39,709.00 $402.00 $402.00 $265.00 $6,633.00 $6,633.00 $4,367.00 $83,109.00 $0.00 $83,109.00 $54,711.00 $116.00 $0.00 $116.00 $76.00 ($351.00) $10,548.00 ($10,899.00) ($7,175.00) $0.00 $14,925.00 ($14,925.00) ($9,825.00) $153.00 $5,433.00 ($5,280.00) ($3,476.00) ($648.00) ($648.00) ($427.00) ($141.00) ($141.00) ($93.00) $674,872.00 $613,583.00 $61,289.00 $40,347.00 $40,347.00 $635,455.00 $613,583.00 $21,872.00 $14,398.00 ($457,063.00) $613,583.00 ($1,070,646.00) ($704,806.00) 0.66 $549,830.00 $613,583.00 ($63,753.00) ($41,969.00) $414,552.00 $613,583.00 ($199,031.00) ($131,022.00) $428,074.00 $613,583.00 ($185,509.00) ($122,121.00) $578,512.00 $613,583.00 ($35,071.00) ($23,087.00) $581,452.00 $613,583.00 ($32,131.00) ($21,152.00) $531,666.00 $613,583.00 ($81,917.00) ($53,926.00) $494,711.00 $613,583.00 ($118,872.00) ($78,253.00) $551,310.00 $613,583.00 ($62,273.00) ($40,994.00) $597,647.00 $613,583.00 ($15,936.00) ($10,491.00) $120,364.00 428571.00 308207.00 $120,364.00 $79,236.00 $9,299.00 237071.00 227772.00 $9,299.00 $6,122.00 0.66 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($1,101,540.00) ($725,144.00) $79,209.00 $121,900.00 ($42,691.00) ($28,103.00) $1,168.00 $116,287.00 $127,000.00 ($10,713.00) ($7,052.00) $142,816.00 $125,400.00 $17,416.00 $11,465.00 135435.00 $130,000.00 $5,435.00 $127,086.00 $114,400.00 $12,686.00 $8,351.00 $132,277.00 $117,100.00 $15,177.00 $9,991.00 $103,154.00 $92,600.00 $10,554.00 $6,948.00 0.66 $0.00 $44,300.00 ($44,300.00) $61,383.00 $86,700.00 ($25,317.00) ($16,666.00) $159,443.00 $212,630.00 ($53,187.00) ($35,013.00) $44,171.00 $123,703.00 $193,300.00 ($69,597.00) ($45,816.00) $193,300.00 ($193,300.00) ($127,249.00) 274717.00 $231,960.00 $42,757.00 $28,147.00 $148,761.00 $231,960.00 ($83,199.00) ($54,770.00) $160,078.00 $231,960.00 ($71,882.00) ($47,320.00) $187,138.00 $135,310.00 $51,828.00 $34,118.00 0.66 $0.00 ($1,125,518.00) ($740,928.00) $196,457.00 $231,960.00 ($35,503.00) ($23,372.00) $158,526.00 $173,083.00 ($14,557.00) ($9,583.00) $15,661.00 $160,952.00 $173,083.00 ($12,131.00) ($7,986.00) $173,083.00 ($173,083.00) ($113,941.00) 139267.00 $173,083.00 ($33,816.00) ($22,261.00) $158,548.00 $173,083.00 ($14,535.00) ($9,568.00) $151,527.00 $173,083.00 ($21,556.00) ($14,190.00) $157,286.00 $173,083.00 ($15,797.00) ($10,399.00) 0.66 $0.00 $173,083.00 $988,010.00 $650,407.00 $207,071.00 $173,083.00 $33,988.00 $22,374.00 ($615,229.00) ($615,229.00) ($405,005.00) $158,623.00 $0.00 $158,623.00 $104,422.00 $0.00 $0.00 -117691.00 ($117,691.00) ($77,476.00) $207,930.00 $207,930.00 $136,880.00 ($80,024.00) $0.00 ($80,024.00) ($52,680.00) $0.00 0.00 $874,277.00 $575,537.00 $491,463.00 0.00 $491,463.00 $323,530.00 0.66 $479,728.00 $479,728.00 $315,805.00 0.66 $397,652.00 $0.00 $397,652.00 $261,774.00 $257,200.00 192200.00 65000.00 $0.00 $257,200.00 $169,315.00 $238,600.00 173600.00 65000.00 $238,600.00 $157,070.00 $322,200.00 192200.00 130000.00 $322,200.00 $212,104.00 162500.00 $162,500.00 $106,974.00 $162,500.00 0.00 $162,500.00 $106,974.00 $195,000.00 $195,000.00 $128,369.00 $387,200.00 192200.00 195000.00 $387,200.00 $254,894.00 0.66 $0.00 ($1,068,805.00) ($703,594.00) $0.00 0.66 $240,950.00 192200.00 48750.00 $29,269.00 $211,681.00 $139,350.00 $625,799.00 $506,083.00 ($119,716.00) ($78,809.00) $569,909.00 $506,083.00 $63,826.00 $42,017.00 $642,980.00 $506,083.00 ($136,897.00) ($90,119.00) $506,083.00 $0.00 $1,282,734.00 $506,083.00 ($776,651.00) ($511,269.00) $2,640,600.00 $506,083.00 $2,134,517.00 ($1,405,153.00) 0.66 $1,100,858.00 $506,083.00 $594,775.00 ($391,540.00) 0.66 $733,395.00 $506,083.00 $677,127.00 $506,083.00 $0.00 $646,824.00 $506,083.00 ($140,741.00) ($92,650.00) 0.66 $583,383.00 $506,083.00 $77,300.00 $50,887.00 0.66 $475,050.00 $506,083.00 $31,033.00 $20,429.00 $279,300.00 279300.00 ($279,300.00) ($183,863.00) $0.00 $108,000.00 ($108,000.00) ($71,096.00) $0.00 $274,110.00 $261,145.00 $12,965.00 $8,535.00 ($26,634.00) $394,800.00 $265,742.00 $129,058.00 $84,959.00 $376,995.00 $224,719.00 $152,276.00 $100,243.00 $283,687.00 $270,062.00 $13,625.00 $8,969.00 $0.00 $266,293.00 $257,434.00 $8,859.00 $5,832.00 0.66 $0.00 $258,829.00 $0.00 $0.00 ($794,732.00) $0.00 ($794,732.00) ($523,172.00) 0.66 $2,912,355.00 320549.00 2591806.00 $2,510,890.00 $401,465.00 $264,284.00 ($215,782.00) $2,631,597.00 $2,348,897.00 $282,700.00 $186,101.00 1279564.00 $1,241,609.00 $37,955.00 $24,986.00 $1,392,567.00 1239294.00 153273.00 $1,201,557.00 $191,010.00 $125,742.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $933,501.00 0.00 $933,501.00 $614,524.00 0.66 $933,501.00 $0.00 $933,501.00 $614,524.00 0.66 $933,501.00 $933,501.00 $614,524.00 $124,067.00 $188,667.00 ($64,600.00) ($42,526.00) $66,882.00 $188,667.00 ($121,785.00) ($80,171.00) $114,001.00 $188,667.00 ($74,666.00) ($49,153.00) 102873.00 $188,667.00 ($85,794.00) ($56,478.00) $136,410.00 $188,667.00 ($52,257.00) ($34,401.00) $456,189.00 $188,667.00 $267,522.00 $176,110.00 $116,097.00 $188,667.00 ($72,570.00) ($47,773.00) $188,667.00 $188,667.00 $128,411.00 $188,667.00 ($60,256.00) ($39,667.00) $151,228.00 $188,667.00 ($37,439.00) ($24,646.00) 0.66 $421,955.00 $188,667.00 $233,288.00 $153,573.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 684950.00 $420,500.00 $264,450.00 $174,087.00 $457,314.00 457314.00 $420,500.00 $36,814.00 $24,235.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 $420,500.00 $420,500.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 $457,314.00 $420,500.00 $36,814.00 $24,235.00 0.66 $14,032.00 $420,500.00 ($406,468.00) ($267,578.00) $116,071.00 $115,250.00 $821.00 $540.00 $116,071.00 $115,250.00 $821.00 $540.00 $116,071.00 $115,250.00 $821.00 $540.00 116071.00 $115,250.00 $821.00 $540.00 $116,071.00 $115,250.00 $821.00 $540.00 $116,071.00 $115,250.00 $821.00 $540.00 $116,071.00 $115,250.00 $821.00 $540.00 0.00 $115,250.00 $115,250.00 $124,153.00 $115,250.00 $8,903.00 $5,861.00 $124,153.00 $115,250.00 $8,903.00 $5,861.00 0.66 $0.00 $115,250.00 ($115,250.00) ($75,869.00) $882,536.00 $911,059.00 507823.00 403236.00 ($28,523.00) ($18,777.00) $871,017.00 871017.00 $809,883.00 416015.00 393868.00 $61,134.00 $40,245.00 $869,662.00 $749,233.00 357560.00 391673.00 $120,429.00 $79,278.00 0.66 $640,550.00 $861,505.00 507228.00 354277.00 ($220,955.00) ($145,455.00) $1,007,639.00 1007639.00 $843,969.00 313927.00 530042.00 $163,670.00 $107,744.00 $793,710.00 $766,727.00 325702.00 441025.00 $26,983.00 $17,763.00 $979,166.00 $883,856.00 364496.00 519360.00 $95,310.00 $62,743.00 $0.00 $338,463.00 ($338,463.00) ($222,810.00) 0.66 $279,248.00 ($279,248.00) ($183,829.00) 0.66 $917,753.00 $820,478.00 327163.00 493315.00 $97,275.00 $64,036.00 $823,722.00 $904,640.00 384064.00 520576.00 ($80,918.00) ($53,268.00) 0.66 $972,856.00 $1,008,625.00 454524.00 554101.00 ($35,769.00) ($23,547.00) $0.00 $0.00 $507,228.00 ($507,228.00) ($333,908.00) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $444,756.00 $439,184.00 $247,776.00 $127,489.00 $120,287.00 $79,185.00 $0.00 $496,174.00 ($496,174.00) ($326,631.00) $75,833.00 $0.00 $496,174.00 ($496,174.00) ($326,631.00) $0.00 $496,174.00 ($496,174.00) ($326,631.00) $480,168.00 ($480,168.00) ($316,095.00) $496,174.00 ($496,174.00) ($326,631.00) $352,123.00 ($352,123.00) ($231,803.00) $496,174.00 ($496,174.00) ($326,631.00) $496,174.00 ($496,174.00) ($326,631.00) 0.66 $480,168.00 ($480,168.00) ($316,095.00) $496,174.00 ($496,174.00) ($326,631.00) $0.00 $480,168.00 ($480,168.00) ($316,095.00) 0.66 $0.00 $496,174.00 ($496,174.00) ($326,631.00) ($19,520,159.00) ($19,520,159.00) ($12,850,121.00) 0.66 $0.00 $2,571,568.00 ($2,571,568.00) ($1,692,863.00) $10,285,559.00 $10,285,559.00 $6,770,983.00 0.66 -1596691.00 ?1?/?1?/?2007 ?2?/?1?/?2006 ?3?/?1?/?2006 ?4?/?1?/?2006 ?5?/?1?/?2006 ?6?/?1?/?2006 ?7?/?1?/?2006 ?8?/?1?/?2006 ?9?/?1?/?2006 ?10?/?1?/?2006 ?11?/?1?/?2006 ?12?/?1?/?2006 555 Purchased Power $130,381,374.00 $26,249,707.00 $11,090,357.00 $13,604,488.00 $10,288,508.00 $6,214,710.00 $6,973,574.00 $6,479,782.00 $11,165,165.00 $7,465,617.00 $11,922,083.00 $8,697,940.00 $10,229,443.00 501 Thermal Fuel $23,109,270.00 $1,943,989.00 $1,881,758.00 $2,084,051.00 $2,048,943.00 $806,914.00 $2,086,930.00 $2,225,970.00 $2,142,237.00 $2,060,328.00 $2,000,705.00 $1,902,528.00 $1,924,917.00 547 CT Fuel $93,267,468.00 $352,819.00 525000.00 172181.00 $10,759,178.00 10725658.00 33520.00 $13,598,095.00 13670045.00 71950.00 $210,000.00 525000.00 315000.00 $525,000.00 $525,000.00 $9,534,819.00 $10,175,122.00 $10,042,730.00 $11,598,604.00 $12,457,409.00 $13,488,692.00 $0.00 $0.00 ($93,145,882.00) ($9,535,791.00) ($8,656,319.00) ($16,419,702.00) ($9,587,693.00) ($9,613,741.00) ($12,352,353.00) ($11,607,670.00) ($1,616,134.00) ($1,590,665.00) ($2,323,495.00) ($6,708,026.00) ($3,134,293.00) ($1,533,000.00) ($130,200.00) ($117,600.00) ($130,200.00) ($125,825.00) ($130,200.00) ($126,000.00) ($130,200.00) ($130,200.00) ($126,000.00) ($130,375.00) ($126,000.00) ($130,200.00) ($22,419,906.00) ($1,877,965.00) ($1,587,997.00) ($1,915,992.00) ($1,848,650.00) ($1,621,518.00) ($1,789,893.00) ($2,124,926.00) ($1,796,588.00) ($1,888,265.00) ($2,084,152.00) ($1,874,188.00) ($2,009,772.00) $129,659,324.00 $17,002,559.00 $13,369,377.00 $10,820,740.00 $985,283.00 ($3,818,835.00) ($4,682,742.00) $4,377,775.00 $19,939,602.00 $15,963,745.00 $20,983,370.00 $14,349,663.00 $20,368,787.00 84486016.00 0.65 0.65 11078867.00 0.65 0.65 8711486.00 0.65 0.65 7050794.00 0.65 0.65 642010.00 0.65 0.65 -2488353.00 0.65 0.65 -3051275.00 0.65 0.65 2852558.00 0.65 0.65 12992645.00 0.65 0.65 10401976.00 0.65 0.65 13672764.00 0.65 0.65 9350240.00 0.65 0.65 13272302.00 0.65 0.65 ($9,954,077.00) ($9,954,077.00) ($1,021,784.00) ($1,021,784.00) $145,512.00 $145,512.00 ($389,601.00) ($389,601.00) ($648,479.00) ($648,479.00) ($1,000,049.00) ($1,000,049.00) ($1,458,084.00) ($1,458,084.00) ($1,911,136.00) ($1,911,136.00) ($972,212.00) ($972,212.00) ($622,762.00) ($622,762.00) ($42,449.00) ($42,449.00) ($1,086,605.00) ($1,086,605.00) ($946,428.00) ($946,428.00) $391,512.00 $391,512.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 $32,626.00 1024.70 8760.00 959.20 8760.00 -65.50 545.00 8760.00 503.70 8760.00 $41.30 4773882.00 4412300.00 361582.00 349531.00 311600.00 37931.00 352032.00 313400.00 38632.00 379656.00 353500.00 26156.00 498497.00 425100.00 73397.00 698088.00 617600.00 80488.00 697424.00 622300.00 75124.00 453192.00 444900.00 8292.00 259896.00 277600.00 -17704.00 220560.00 171900.00 48660.00 223638.00 217000.00 6638.00 291120.00 322400.00 -31280.00 350248.00 335000.00 15248.00 8976405.00 8402700.00 -573705.00 875528.00 919303.00 43775.00 819800.00 -55728.00 781917.00 818916.00 36999.00 694500.00 -87417.00 792135.00 836776.00 24986.00 19655.00 723400.00 -68735.00 683929.00 727001.00 25082.00 17990.00 641200.00 -42729.00 669683.00 707463.00 21153.00 16627.00 630300.00 -39383.00 646148.00 687851.00 23096.00 18607.00 630500.00 -15648.00 730507.00 780016.00 27601.00 21908.00 681000.00 -49507.00 770039.00 811898.00 23969.00 17890.00 675700.00 -94339.00 672520.00 716515.00 23561.00 20434.00 637900.00 -34620.00 744163.00 792722.00 28196.00 20363.00 685600.00 -58563.00 735135.00 778802.00 23990.00 19677.00 740300.00 5165.00 874701.00 921527.00 25293.00 21533.00 842500.00 -32201.00 1614672.00 1586000.00 28672.00 145080.00 148000.00 -2920.00 131040.00 133500.00 -2460.00 145080.00 136500.00 8580.00 140205.00 102100.00 38105.00 80352.00 88300.00 -7948.00 111600.00 96700.00 14900.00 145080.00 147000.00 -1920.00 145080.00 148700.00 -3620.00 140400.00 143900.00 -3500.00 145275.00 148700.00 -3425.00 140400.00 143900.00 -3500.00 145080.00 148700.00 -3620.00 352704.00 357400.00 -4696.00 32736.00 32000.00 736.00 29568.00 28700.00 868.00 32736.00 33800.00 -1064.00 31636.00 32500.00 -864.00 0.00 17200.00 -17200.00 31680.00 12200.00 19480.00 32736.00 32200.00 536.00 32736.00 34200.00 -1464.00 31680.00 33100.00 -1420.00 32780.00 34200.00 -1420.00 31680.00 33100.00 -1420.00 32736.00 34200.00 -1464.00 0.00 10900.00 -10900.00 200.00 -200.00 100.00 -100.00 1500.00 -1500.00 500.00 -500.00 1600.00 -1600.00 0.00 0.00 800.00 -800.00 1500.00 -1500.00 1500.00 -1500.00 2700.00 -2700.00 500.00 -500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1200.00 -1200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 200.00 -200.00 0.00 0.00 0.00 0.00 400.00 -400.00 0.00 100.00 -100.00 0.00 0.00 0.00 0.00 500.00 -500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60100.00 -60100.00 0.00 1500.00 -1500.00 0.00 500.00 -500.00 0.00 9500.00 -9500.00 0.00 4400.00 -4400.00 0.00 7300.00 -7300.00 0.00 100.00 -100.00 0.00 4200.00 -4200.00 0.00 7400.00 -7400.00 0.00 8400.00 -8400.00 0.00 11600.00 -11600.00 0.00 4800.00 -4800.00 0.00 400.00 -400.00 1473573.00 1525700.00 -52127.00 0.00 133900.00 -133900.00 170016.00 101200.00 68816.00 186744.00 172900.00 13844.00 0.00 136600.00 -136600.00 0.00 72600.00 -72600.00 0.00 21100.00 -21100.00 174766.00 89500.00 85266.00 183792.00 131000.00 52792.00 181120.00 157600.00 23520.00 191919.00 175100.00 16819.00 189040.00 170500.00 18540.00 196176.00 163700.00 32476.00 3440949.00 3541300.00 -100351.00 177816.00 315600.00 -137784.00 330624.00 264000.00 66624.00 364560.00 354200.00 10360.00 171841.00 276100.00 -104259.00 80352.00 187200.00 -106848.00 143280.00 130100.00 13180.00 352582.00 274100.00 78482.00 361608.00 322900.00 38708.00 353200.00 344500.00 8700.00 369974.00 372800.00 -2826.00 361120.00 352800.00 8320.00 373992.00 347000.00 26992.00 $65.50 $61.06 $4.44 $67.00 $59.04 $7.96 $55.00 $63.96 ($8.96) $0.00 $46.94 ($46.94) $0.00 $49.00 ($49.00) $0.00 $49.39 ($49.39) $0.00 61.85 ($61.85) $77.48 $65.92 $11.56 $75.00 $65.31 $9.69 $72.50 $60.51 $11.99 $0.00 $59.38 ($59.38) $83.50 $68.64 $14.86 $0.00 $60.13 ($60.13) $0.00 $61.17 ($61.17) $63.00 $56.05 $6.95 $53.46 $46.37 $7.09 $30.59 $38.45 ($7.86) $32.64 $37.10 ($4.46) 59.77 51.21 $8.56 $0.00 $68.07 ($68.07) $0.00 $54.45 ($54.45) $62.00 $51.14 $10.86 $69.52 $57.63 $11.89 $72.00 $61.07 $10.93 7.00 10316862.00 10681883.00 $87,493,079.00 87493079.00 $77,443,651.75 7.25 $10,049,427.25 $8.00 ($8.00) 8.05 $8.01 $0.04 8.15 $7.86 $0.29 8.08 $6.93 $1.15 $8.10 $6.79 $1.31 $8.15 $6.93 $1.22 $8.22 $6.89 $1.33 $8.27 $6.94 $1.33 $8.29 $6.92 $1.37 $8.35 $6.95 $1.40 $8.89 $7.29 $1.60 $9.50 $7.60 $1.90 $6,548,206.80 0.65 7.00 ($7.00) 6.98 7.00 ($0.02) 6.95 7.00 ($0.05) 6.94 7.00 ($0.06) 6.94 7.00 ($0.06) 6.95 7.00 ($0.05) 6.96 7.00 ($0.04) 6.95 7.00 ($0.05) 6.94 7.00 ($0.06) 6.94 7.00 ($0.06) 6.97 7.00 ($0.03) 6.99 7.00 ($0.01) $2,071,923.10 61.00 0.65 $0.00 $56.02 7501.00 1000.00 ($56.02) $56.16 $56.10 5677.00 1000.00 $0.06 $56.66 $55.05 9518.00 1000.00 $1.61 $56.10 $48.50 6625.00 1000.00 $7.60 $56.20 $47.55 3452.00 1000.00 $8.65 $56.62 $48.53 1024.00 1000.00 $8.09 $57.23 $48.21 4315.00 1000.00 $9.02 $57.49 $48.59 6365.00 1000.00 $8.90 $57.54 $48.42 7631.00 1000.00 $9.12 $57.98 $48.66 8520.00 1000.00 $9.32 $61.95 $51.00 8695.00 1000.00 $10.95 $66.38 $53.22 8712.00 1000.00 $13.16 $4,476,283.70 ($11,420,799.00) 0.65 ($2,484,481.00) ($2,588,344.00) ($1,438,580.00) ($3,923,804.00) ($2,462,128.00) ($2,452,047.00) ($495,613.00) $1,371,706.00 ($3,649,500.00) ($481,255.00) $2,174,586.00 ($1,097,856.00) $23,690,518.00 0.65 $3,650,184.00 $5,856,939.00 $3,780,425.00 $2,284,292.00 $1,204,726.00 $510,751.00 $2,959,033.00 $7,309,386.00 $2,596,500.00 $4,245,818.00 ($359,071.00) $2,318,472.00 $8,770,450.00 $4,610,672.00 ($7,501,000.00) ($5,048,658.00) 5677000.00 10725658.00 $5,000.00 525000.00 520000.00 $80,808.00 18200.00 ($357,404.00) -44900.00 $137,323.00 865323.00 728000.00 $137,323.00 865323.00 728000.00 ($48,208.00) ($116,000.00) -116000.00 ($98,250.00) $77,171.00 1066171.00 989000.00 $191,260.00 ($325,725.00) -25.00 4343.00 3.00 ($69,812.00) ($317,400.00) $7,402,450.00 ($1,206,150.00) $6,612,200.00 $501,600.00 $14,137,350.00 $5,260,026.00 $5,663,000.00 $638,883.00 $6,234,450.00 $1,933,250.00 $5,874,200.00 $1,513,688.00 $1,760,050.00 $134,368.00 $547,950.00 ($56,394.00) $562,000.00 ($38,000.00) $544,906.00 $34,956.00 $530,000.00 ($26,160.00) $569,750.00 ($49,450.00) 94600.00 91200.00 161400.00 117875.00 140600.00 133600.00 27200.00 7800.00 8000.00 8225.00 8000.00 8600.00 $78.25 $72.50 $87.59 $48.04 $44.34 $43.97 $64.71 $70.25 $70.25 $66.25 $66.25 $66.25 $840,000.00 185000.00 $0.00 $3,488,100.00 -464160.00 $2,908,500.00 -349009.00 10000.00 0.00 48000.00 47875.00 $84.00 $72.67 $60.75 930170.00 3112128.00