Loading...
HomeMy WebLinkAbout20150728AVU to Staff 7 Attachment.xlsMacro1 Transaction Detail Staff_PR_007, Attachment C Macro1 Macro10 Macro2 Macro3 Macro4 Macro5 Macro6 Macro7 Macro8 Macro9 Recover TableName Dummy Transaction Detail Selection: Ferc Acct Jurisdiction Service Voucher Number Organization Desc Accounting Period Expenditure Organization Project Number Journal Name Transaction Desc Ava Jet Expenditure Category Invoice Number Report Category Accounting Year Task Number Summary Exp Category Expenditure Type Source Id Transaction Amount Electric Amt SUM Gas North Amt SUM Project Desc Vendor Number Vendor Name Employee Number - E01 - Exec Administration E01 Labor Cost USD Labor 340 Regular Payroll - NU PA 00365 02565 305 Incentive/Bonus Pay 02885 03511 U01 - Legal Staff U01 920000 AA CD 09903691 OPER Corporate Planning-099 09900172 Contract Service - Common 09900330 Common-Company Communications 921000 09905107 921600 Telecom Services 928000 ED WA 930200 Macro1 Macro10 Macro2 Macro3 Macro4 Macro5 Macro6 Macro7 Macro8 Macro9 Recover Auto_Open Grand Total Sum of Transaction Amount Total 00365 Total 02565 Total 02885 Total 03511 Total Transaction Qty SUM 03998 Purchase Invoices USD Employee Expenses Non-Labor 215 Employee Business Meals 220 Employee Car Rental 230 Employee Lodging 235 Employee Misc Expenses GD 205 Airfare 210 Employee Auto Mileage 09902811 A and G Common Training 928010 02805810 CDWA General Rate Case Activ 928020 03998 Total Ferc Acct Desc Gas South Amt SUM 417120 EXPENSES OF NONUTILITY OPERATI ZZ 201408 77705077 NONOP 2014 Strategic Analysis 201411 201412 426400 POLITICS EXPEND 201401 77705239 Salix, Inc. ADMIN & GEN SALARIES 201410 201409 201407 201402 201403 201404 201405 201406 MISC GENERAL EXPENSE Travel to and from Las Vegas for 4/8-4/9 Peak Reliabiity funding meeting Travel to and from Salt Lake City for 5/13 meeting with WECC Travel to and from Madison, WI for 7/13-7/16 EEI Rates course Travel to and from Portland for 3/11 BPA Segmentation meeting Travel to and from Portland for 3/7 Colstrip/Mt. Intertie meeting Tri-Met tickets for travel to 3/11 BPA Segmentation meeting light rail tickets for travel from Salt Lake City for 5/13 meeting with WECC Travel to and from Madison, WI for 7/13-7/16 EEI Rates course (airport to hotel) Travel to and from Madison, WI for 7/13-7/16 EEI Rates course (hotel to airport) Travel to and from Portland for 8/8 EIM Legal Group meeting Travel to and from Portland for 8/8 EIM Legal Group meeting (Tri-Met ticket for travel to/from meeting) Travel to and from Portland for 10/2 ColumbiaGrid Order 1000 meeting Travel to and from Portland for 10/8 ColumbiaGrid Order 1000 meeting Travel to and from Portland for 10/9 ColumbiaGrid Order 1000 meeting Tri-Met ticket for travel to 10/8 ColumbiaGrid Order 1000 meeting Registration fee for EEI advance rate course to be held 7/2014 Voucher 950 Training Oregon required CLE program Travel to and from airport for travel to Portland for 3/11 BPA Segmentation meeting (see attached Mapquest) Travel to and from airport for travel to Portland for 3/7 Colstrip/MT. Intertie meeting (see attached MapQuest) Travel to and from airport for travel to Las Vegas for 4/8-4/9 Peak Reliability funding meeting (see attached MapQuest) Travel to and from airport for travel to Madison, WI, for EEI rate course (see attached MapQuest) Travel to and from airport for travel to Portland for 8/8 EIM legal group meeting (see attached MapQuest) Travel to and from airport for travel to Portland for 10/2 ColumbiaGrid Order 1000 meeting (see attached mapquest) Travel to and from airport for travel to Portland for 10/8 ColumbiaGrid Order 1000 meeting (see attached mapquest) Travel to and from airport for travel to Portland for 10/9 ColumbiaGrid Order 1000 meeting (see attached mapquest) Travel to and from Madison, WI for 7/13-7/16 EEI Rates course (item on lodging receipt) Travel to and from Madison, WI for 7/13-7/16 EEI Rates course (item on loging receipt) 2014 Total Name 77703430 Avista Subsidiary Support Meyer, David John 77705232 Bkfst at airport - Project Everest mtg in Seattle Everest Durkin, Marian McMahon Lunch at airport - Project Everest mtg in Seattle Cab far to meeting location - Project Everest mtg in Seattle Cab fare to airport - Project Everest mtg in Seattle Parking at airport while at Project Everest mtg in Seattle Andrea, Michael G Bachtel-Browning, Britt 426500 MISC INCOME DEDUCTIONS-OTHER D 77705228 Project Chinook Parking at airport while in Juneau for AERC closing event 77705242 Salix-Pearl Harbor Wood, Patricia Prouty OFFICE SUPPLIES & EXPENSES 925100 INJURIES & DAMAGES NON PB OR 06803410 Breakfast 925130 Risk Mgmt Admin Activity-068G Dinner Dinner for Britt, Jeff Webb, Jeff Daniels Lunch Snack Water Airport parking Cab from airport Cab to airport Change fee cab from airport REGULATORY COMMISSION EXPENSES 06805169 GDOR General Rate Case Activ ID 03805343 CDID General Rate Case Activ 09905328 NARUC Reg Activities AN 09800544 Comm Regulatory Activities Hotel in Seattle Cab Fare from Hotel to SeaTac Airport Parking at Spokane International Airport Western Conference Activities Parking at Spokane Internaitonal Airport Transportation from Seatac Airport to Hotel where Board Retreat was located 09900310 Airfare for Marian Durkin travel to New Orleans for EEI Spring Legal Conference, April 22-26, 2014 Com - Trade/Professional Assoc Meal while in Albuquerque, NM for EWE Board meeting 09800310 Breakfast - EEI Fall Legal Conference, Portland, OR Elect-Trade/Professional Assoc Car rental while in Albuquerque, NM for EWE Board meeting Gas for rental car while in Albuquerque, NM for EWE Board meeting 2 nights at hotel for EEI Annual Convention & Legal Planning Committee Meeting Lodging while in Albuquerque, NM for EWE Board meeting Colstrip Owner's Litigation Meeting - Hotel while in WA DC for meeting Hotel while at EEI Fall Legal Conference, Portland, OR Parking at airport while in Albuquerque, NM for EWE Board meeting Colstrip Owner's Litigation Meeting - Parking while in WA DC for meeting Cab to airport EEI Fall Legal Conference, Portland, OR Parking at airport while at EEI Fall Legal Conference, Portland, OR Registration fee for Minnesota's American Indian Tribes Simulcast Cloud and IT CLE Leaderhip Conference 09805691 930221 Post Street Annex Education Coffee Lunch/breakfast items Marriott stay Airport to hotel airline bag fee 293.04 2.40 195.36 1.60 201.92 1.60 151.44 1.20 201.92 1.60 201.92 1.60 201.92 1.60 252.40 2.00 201.92 1.60 201.92 1.60 201.92 1.60 201.92 1.60 0.00 0.00 0.00 0.00 0.00 121127.00 0.00 4858.75 32.08 2892.49 19.10 3670.94 23.00 3915.33 24.38 3915.33 24.38 3915.33 24.38 3297.12 20.53 5563.89 34.64 3709.26 23.10 2472.84 15.40 3503.19 21.81 3503.19 21.81 361.22 5.00 866.92 12.00 794.68 11.00 297.10 5.00 0.00 0.00 2320.25 19.00 1587.56 13.00 2271.61 18.00 2524.00 20.00 504.80 4.00 504.80 4.00 0.00 1060.09 7.00 605.76 4.00 4817.30 30.00 602.17 3.75 722.60 4.50 963.48 6.00 2328.38 14.50 57.69 1.00 14238.64 10150.73 2822.39 1265.52 116.60 12871.01 9175.75 2551.30 1143.96 105.40 11913.45 8493.10 2361.48 1058.87 94.40 9439.92 6729.72 1871.18 839.02 74.80 11282.47 8043.27 2236.41 1002.79 89.40 9515.63 6783.69 1886.19 845.75 75.40 7243.97 5164.23 1435.90 643.84 57.40 7067.31 5038.28 1400.89 628.14 56.00 11787.26 8403.14 2336.47 1047.65 93.40 11913.46 8493.11 2361.49 1058.86 94.40 14185.10 10112.56 2811.77 1260.77 112.40 13554.08 9662.70 2686.69 1204.69 107.40 25505.48 18182.85 5055.70 2266.93 168.42 0.00 0.00 17855.10 12728.90 3539.23 1586.97 117.90 15164.90 10811.06 3005.99 1347.85 94.50 19890.27 14179.77 3942.65 1767.85 123.87 19769.85 14093.92 3918.78 1757.15 123.12 19528.97 13922.20 3871.04 1735.73 121.62 16855.35 12016.18 3341.07 1498.10 104.97 27354.49 19501.01 5422.20 2431.28 170.36 19413.90 13840.16 3848.22 1725.52 120.90 12942.60 9226.78 2565.48 1150.34 80.60 18977.66 13529.17 3761.75 1686.74 118.19 18335.35 13071.27 3634.43 1629.65 114.19 4173.10 2975.00 827.19 370.91 59.50 9223.17 6575.19 1828.22 819.76 131.50 3331.46 2375.00 660.36 296.10 47.50 7329.44 5225.15 1452.84 651.45 104.50 3431.59 2446.38 680.21 305.00 47.50 7549.46 5382.01 1496.46 670.99 104.50 2636.90 1879.84 522.69 234.37 36.50 6032.37 4300.47 1195.74 536.16 83.50 3467.72 2472.14 687.38 308.20 48.00 7802.32 5562.28 1546.58 693.46 108.00 2853.65 2034.37 565.66 253.62 39.50 6393.57 4557.97 1267.34 568.26 88.50 3142.62 2240.38 622.93 279.31 43.50 7260.49 5176.01 1439.18 645.30 100.50 5093.21 3630.95 1009.58 452.68 70.50 11450.63 8163.16 2269.75 1017.72 158.50 3106.50 2214.62 615.78 276.10 43.00 7007.64 4995.74 1389.06 622.84 97.00 3287.11 2343.38 651.58 292.15 45.50 7404.98 5279.01 1467.82 658.15 102.50 3106.52 2214.64 615.78 276.10 43.00 7296.64 5201.78 1446.34 648.52 101.00 2347.94 1673.84 465.40 208.70 32.50 5382.17 3836.95 1066.86 478.36 74.50 4875.39 3475.67 966.40 433.32 67.50 10725.75 7646.40 2126.06 953.29 148.50 3069.69 2188.38 608.48 272.83 42.50 6753.25 4814.40 1338.63 600.22 93.50 3315.42 2363.56 657.18 294.68 45.00 7293.78 5199.74 1445.78 648.26 99.00 3425.93 2442.34 679.09 304.50 46.50 7625.32 5436.09 1511.49 677.74 103.50 2578.66 1838.32 511.14 229.20 35.00 5672.94 4044.24 1124.49 504.21 77.00 2578.66 1838.33 511.14 229.19 35.00 5672.94 4044.24 1124.49 504.21 77.00 3352.25 2389.81 664.49 297.95 45.50 7698.99 5488.61 1526.09 684.29 104.50 4973.13 3545.34 985.77 442.02 67.50 10940.67 7799.60 2168.67 972.40 148.50 3425.93 2442.34 679.09 304.50 46.50 7220.11 5147.21 1431.17 641.73 98.00 3315.42 2363.56 657.18 294.68 45.00 7293.78 5199.74 1445.78 648.26 99.00 3499.61 2494.87 693.69 311.05 47.50 7698.99 5488.61 1526.10 684.28 104.50 1178.80 840.37 233.66 104.77 16.00 2836.52 2022.15 562.25 252.12 38.50 6372.85 4543.21 1263.22 566.42 86.50 9634.65 6868.55 1909.78 856.32 167.00 8769.26 6251.61 1738.24 779.41 152.00 9507.40 6777.82 1884.56 845.02 160.00 9507.40 6777.82 1884.56 845.02 160.00 9032.03 6438.93 1790.33 802.77 152.00 9032.03 6438.93 1790.33 802.77 152.00 8556.66 6100.04 1696.10 760.52 144.00 12062.50 8599.36 2391.03 1072.11 203.00 9032.03 6438.93 1790.33 802.77 152.00 9507.40 6777.82 1884.56 845.02 160.00 9032.03 6438.93 1790.33 802.77 152.00 7605.92 5422.26 1507.65 676.01 128.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 0.00 71.26 50.80 14.13 6.33 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 1587.51 1587.51 13.00 6960.60 5473.88 1486.72 57.00 4640.39 3649.25 991.14 38.00 244.24 192.07 52.17 2.00 1388.20 1091.69 296.51 11.00 4417.04 3473.60 943.44 35.00 126.20 126.20 1.00 378.60 378.60 3.00 378.60 297.73 80.87 3.00 2145.40 1687.16 458.24 17.00 1135.80 893.20 242.60 9.00 883.40 883.40 7.00 1893.00 1488.67 404.33 15.00 4290.83 3374.35 916.48 34.00 3028.86 2159.27 600.38 269.21 24.00 1009.62 1009.62 8.00 2902.62 2282.64 619.98 23.00 126.20 126.20 1.00 883.40 694.71 188.69 7.00 1009.60 793.96 215.64 8.00 3533.65 2778.90 754.75 28.00 126.20 126.20 1.00 378.60 378.60 3.00 6183.90 4863.08 1320.82 49.00 1514.40 1190.93 323.47 12.00 883.40 694.71 188.69 7.00 1766.82 1766.82 14.00 13251.20 10420.87 2830.33 105.00 378.60 297.73 80.87 3.00 2902.60 2902.60 23.00 1009.60 1009.60 8.00 2902.60 2282.63 619.97 23.00 252.40 198.49 53.91 2.00 3281.21 3281.21 26.00 1766.80 1766.80 14.00 1766.83 1389.45 377.38 14.00 4038.41 4038.41 32.00 378.60 297.73 80.87 3.00 126.20 99.24 26.96 1.00 126.20 99.24 26.96 1.00 2524.01 2524.01 20.00 883.40 883.40 7.00 757.20 595.47 161.73 6.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 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 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 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 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 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 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 1178.80 1178.80 16.00 2357.60 1680.73 467.32 209.55 32.00 589.40 420.18 116.83 52.39 8.00 221.02 173.81 47.21 3.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 1029654.18 586980.93 162273.14 88357.44 9309.50 Page of 130111.20 0.00 0.00 0.00 0.00 0.00 0.00 2022.82 0.00 132134.02 135012.30 0.00 0.00 2507.60 9713.02 90162.94 237395.86 231593.92 0.00 0.00 0.00 0.00 0.00 0.00 45217.66 121127.00 0.00 0.00 11099.78 0.00 855.12 409893.48 111279.31 0.00 0.00 0.00 297.10 57.69 855.12 0.00 0.00 112489.22 133394.78 4346.82 0.00 0.00 0.00 0.00 137741.60 1029654.18 1029654.18