Item 5b-Response to Request by Lanetta Cooper to Extend Previous Weatherization Program Data Set — original pdf

Backup

1 MEMORANDUM TO: Low Income Consumer Advisory Task Force FROM: Liz Jambor, Customer Energy Solutions DATE: August 21, 2015 SUBJECT: Response to Request by Lanetta Cooper to Extend Previous Data Set Lanetta Cooper requested an extension to a data set provided earlier in the LICATF process. This data set included the before and after kWh usage and payment status of customers in the weatherization program. The original data set contained 32 customers. Table 1 provides the original data set. The updated data, found in Table 2, set contains 9 customers. These are the customers that have consistently resided at the weatherized dwelling across the time line from October 2013 through July 2015. There is not consistent savings, post install, across all customers or across all months. It appears that there may be some behavioral impacts to energy savings post-weatherization. 2 Table 1. Original Data Set, Pre and Post kWh Usage StatusInstall DateActual Job CostOct-13Nov-13Dec-13Jan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Current12/5/13$5,939.65927.00 625.00 Install853.00 803.00 829.00 723.00 784.00 1,025.00 1,172.00 1,284.00 1,350.00 Current12/19/13$6,237.27740.00 432.00 Install934.00 706.00 669.00 505.00 520.00 656.00 776.00 737.00 805.00 Current1/14/14$5,998.901,060.00 1,018.00 914.00 Install840.00 860.00 1,180.00 1,046.00 820.00 1,228.00 1,086.00 1,446.00 Current2/20/14$7,050.72960.00 552.00 758.00 864.00 Install544.00 524.00 690.00 836.00 1,208.00 1,184.00 1,270.00 Delinquent3/4/14$5,700.991,810.00 312.00 596.00 744.00 744.00 Install426.00 538.00 1,024.00 1,614.00 1,796.00 2,130.00 Current3/5/14$6,910.172,416.00 1,300.00 1,948.00 2,546.00 2,232.00 Install844.00 1,198.00 1,616.00 2,450.00 2,498.00 2,534.00 Delinquent3/7/14$9,195.884,670.00 3,154.00 3,868.00 4,596.00 3,810.00 Install2,372.00 2,840.00 3,408.00 4,524.00 4,972.00 5,100.00 Current3/14/14$7,945.061,350.00 756.00 634.00 674.00 600.00 Install589.00 826.00 925.00 1,241.00 1,276.00 1,303.00 Delinquent3/26/14$6,970.931,162.00 754.00 797.00 878.00 685.00 Install534.00 836.00 1,025.00 1,339.00 1,525.00 1,597.00 Current3/27/14$5,933.89749.00 410.00 401.00 388.00 345.00 Install365.00 444.00 797.00 855.00 956.00 970.00 Delinquent4/2/14$9,735.133,852.00 2,152.00 2,404.00 2,624.00 2,022.00 1,566.00 Install2,150.00 2,802.00 3,548.00 3,754.00 4,022.00 Current4/4/14$7,000.561,744.00 1,218.00 1,030.00 1,290.00 1,110.00 1,010.00 Install1,412.00 1,774.00 2,098.00 2,104.00 2,146.00 Current4/11/14$9,831.912,104.00 2,390.00 2,643.00 3,269.00 2,488.00 2,022.00 Install1,333.00 2,031.00 2,402.00 2,279.00 2,219.00 Delinquent4/16/14$11,920.871,465.00 1,185.00 2,297.00 2,584.00 2,076.00 1,743.00 Install1,478.00 1,884.00 2,349.00 2,221.00 1,533.00 Current4/17/14$8,843.714,226.00 2,602.00 3,058.00 1,874.00 1,972.00 1,406.00 Install2,594.00 3,430.00 3,736.00 3,894.00 3,832.00 Current4/17/14$5,580.693,024.00 2,286.00 1,726.00 1,120.00 1,372.00 1,668.00 Install2,480.00 2,878.00 4,084.00 3,942.00 4,114.00 Delinquent5/1/14$5,406.834,914.00 3,622.00 2,706.00 3,050.00 2,672.00 2,494.00 3,100.00 Install4,632.00 4,268.00 5,120.00 4,854.00 Current5/1/14$5,094.823,302.00 2,808.00 3,446.00 3,344.00 3,398.00 2,854.00 2,612.00 Install3,296.00 3,612.00 3,466.00 3,962.00 Current5/2/14$6,474.623,372.00 2,078.00 2,370.00 3,374.00 2,580.00 1,906.00 1,330.00 Install2,410.00 3,062.00 3,148.00 3,480.00 Current5/7/14$7,517.552,574.00 1,662.00 1,537.00 1,797.00 1,534.00 1,280.00 1,279.00 Install1,648.00 2,150.00 2,498.00 2,754.00 Delinquent5/8/14$7,161.654,480.00 3,034.00 2,996.00 3,398.00 2,758.00 2,700.00 3,078.00 Install4,814.00 6,050.00 6,266.00 5,152.00 Current5/14/14$7,643.023,182.00 2,228.00 3,628.00 3,970.00 2,634.00 1,830.00 1,562.00 Install3,050.00 2,084.00 1,892.00 2,462.00 Current5/15/14$8,574.25948.00 928.00 1,136.00 988.00 888.00 832.00 759.00 Install903.00 1,029.00 1,275.00 1,389.00 Current5/27/14$6,769.54850.00 436.00 886.00 740.00 784.00 556.00 382.00 Install950.00 1,212.00 1,498.00 1,312.00 Current5/28/14$8,150.113,510.00 1,696.00 2,518.00 3,818.00 4,030.00 2,404.00 1,522.00 Install2,252.00 2,754.00 3,044.00 3,156.00 Current6/3/14$5,953.281,956.00 1,425.00 1,201.00 1,139.00 918.00 921.00 1,149.00 1,356.00 Install1,975.00 2,206.00 2,081.00 Current6/10/14$6,648.703,716.00 2,604.00 2,072.00 2,564.00 2,132.00 2,182.00 2,994.00 3,634.00 Install4,380.00 4,348.00 3,748.00 Current6/13/14$8,386.181,134.00 670.00 938.00 1,152.00 774.00 754.00 740.00 800.00 Install1,788.00 2,408.00 1,598.00 Current6/17/14$7,438.181,820.00 1,328.00 6,044.00 6,626.00 6,432.00 2,380.00 1,178.00 1,430.00 Install2,286.00 2,338.00 2,486.00 Current6/19/14$8,670.283,302.00 2,072.00 1,836.00 2,254.00 2,618.00 1,394.00 1,212.00 2,002.00 Install3,508.00 3,636.00 4,082.00 Current7/3/14$9,018.644,466.00 3,876.00 4,642.00 5,634.00 4,696.00 3,998.00 3,830.00 3,536.00 4,700.00 Install5,494.00 5,376.00 Current7/3/14$7,482.782,255.00 1,366.00 756.00 753.00 631.00 661.00 834.00 1,198.00 842.00 Install2,681.00 3,022.00 3 Table 2. Extension of Original Data Set StatusInstall DateActual Job CostOct-13Nov-13Dec-13Jan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Oct-14Nov-14Dec-14Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Current12/5/2013$5,939.65927.00 625.00 Install853.00 803.00 829.00 723.00 784.00 1,025.00 1,172.00 1,284.00 1,350.00 893.00 809.00 625.00 720.00 574.00 637.00 788.00 1,022.00 1,411.00 1,464.00 Current3/14/2014$7,945.061,350.00 756.00 634.00 674.00 600.00 Install589.00 826.00 925.00 1,241.00 1,276.00 1,303.00 911.00 711.00 567.00 835.00 561.00 639.00 666.00 765.00 1,086.00 1,325.00 Delinquent3/26/2014$6,970.931,162.00 754.00 797.00 878.00 685.00 Install534.00 836.00 1,025.00 1,339.00 1,525.00 1,597.00 974.00 800.00 558.00 780.00 539.00 584.00 623.00 817.00 989.00 1,232.00 Current3/27/2014$5,933.89749.00 410.00 401.00 388.00 345.00 Install365.00 444.00 797.00 855.00 956.00 970.00 587.00 458.00 311.00 495.00 359.00 404.00 320.00 551.00 662.00 898.00 Current4/11/2014$9,831.912,104.00 2,390.00 2,643.00 3,269.00 2,488.00 2,022.00 Install1,333.00 2,031.00 2,402.00 2,279.00 2,219.00 1,591.00 1,857.00 1,625.00 2,593.00 1,736.00 1,940.00 1,488.00 1,855.00 2,097.00 2,291.00 Delinquent4/16/2014$11,920.871,465.00 1,185.00 2,297.00 2,584.00 2,076.00 1,743.00 Install1,478.00 1,884.00 2,349.00 2,221.00 1,533.00 1,179.00 1,385.00 1,481.00 2,284.00 1,409.00 1,670.00 1,117.00 1,193.00 1,437.00 1,549.00 Current5/15/2014$8,574.25948.00 928.00 1,136.00 988.00 888.00 832.00 759.00 Install903.00 1,029.00 1,275.00 1,389.00 1,097.00 1,008.00 860.00 1,009.00 783.00 691.00 676.00 650.00 919.00 1,252.00 Current6/3/2014$5,953.281,956.00 1,425.00 1,201.00 1,139.00 918.00 921.00 1,149.00 1,356.00 Install1,975.00 2,206.00 2,081.00 1,457.00 1,228.00 925.00 983.00 762.00 807.00 1,091.00 1,371.00 1,538.00 2,000.00 Current7/3/2014$7,482.782,255.00 1,366.00 756.00 753.00 631.00 661.00 834.00 1,198.00 842.00 Install2,681.00 3,022.00 1,927.00 1,667.00 1,053.00 1,257.00 1,035.00 1,083.00 1,312.00 1,646.00 1,845.00 2,225.00