Question

1 Approved Answer

Posted on Sep 25, 2024

A commercial office building customer in the Southern California Edison service area (Santa Catalina Island) is receiving bundled electrical power service at 480V 3Phase, and

A commercial office building customer in the Southern California Edison service area (Santa Catalina Island) is receiving bundled electrical power service at 480V 3Phase, and is considering a change from Schedule GS-1 to schedule GS-2.

Write two user-defined functions using VisualBasic in Excel. One to calculate the total monthly energy bill using SCE Schedule GS-1, and the other to calculate the total monthly energy bill using SCE Schedule GS-2.

Determine the utility bill for every month during the last year for both electric meters (A01 and A02), using both electric rate schedules (GS-1 and GS-2).

Write a brief summary on the anticipated financial impact of changing from Schedule GS-1 to Schedule GS-2

image text in transcribed

Meter A01 Meter A02 Meter A01 Energy Demand [kWh] kw] Energy Demand MonthEergy [kWh] [kW] 124,067.1180.7 121,461.8193.2 103,431.4 202.1 114,237.0 180.0 106,902.4191.4 107,347.7198.2 89,534.5 196.7 95.150.1 193.0 127,547.9 195.2 109,061.4 194.4 127,506.4 188.1 114.354.2 209.1 2,796.6 01-05-18 02-05-18 3,854.6 01-05-18 02-05-18 03-05-18 04-05-18 3,090.6 3,459.9 8,018.9 2,655.4 2,765.0 04-05-18 05-05-18 06-05-18 07-05-18 08-05-18 09-05-18 10-05-18 11-05-18 12-05-18 13-05-18 14-05-18 15-05-184,251.8 16-05-18 17-05-18 18-05-18 19-05-183,215.2 132.1 180.3 164.2 150.3 3,581.1 3,855.0 3,758.5 3,534.5 3,138.3 3,590.9 2,088.1 2,356.6 3,573.5 07-05-18 December-17 09-05-18 10-05-18 11-05-18 12-05-18 13-05-18 14-05-18 15-05-18 16-05-18 17-05-18 February-18 3,066.2 3,851.6 3,803.2 3,461.3 3,720.6 3,023.9 2,627.9 18-05-18 2,248.7 2,846.0 2,974.0 2,782.0 2,800.1 3,066.4 1,998.6 2,067.4 2,703.5 3,132.1 ual Energy Consumption 195.3 Meter A02 3,692.8 3,320.5 3,153.9 Demand Month Energy [kWh] [kW] 19-05-18 90,204.0 197.3 99,567.1 190.9 98,458.5 196.8 84,899.2 188.4 84,530.9 164.0 85,630.0 184.0 85,706.0 163.3 73,279.7 183.1 83,264.5 82,156.8 211.2 91,149.5 239.3 90,639.1 195.3 189.7 172.0 21-05-18 22-05-18 3,346.7 3,472.5 2,846.8 3,654.3 3,380.3 21-05-18 22-05-18 23-05-18 24-05-18 October-17 24-05-18 25-05-18 26-05-18 27-05-18 142.8 26-05-18 27-05-18 February-18 18 3,780.2 2,841.9 3,042.1 202 3,708.5 31-05-18 2,726.1 30-05-18 31-05-18 109.6 Meter A01 Meter A02 Meter A01 Energy Demand [kWh] kw] Energy Demand MonthEergy [kWh] [kW] 124,067.1180.7 121,461.8193.2 103,431.4 202.1 114,237.0 180.0 106,902.4191.4 107,347.7198.2 89,534.5 196.7 95.150.1 193.0 127,547.9 195.2 109,061.4 194.4 127,506.4 188.1 114.354.2 209.1 2,796.6 01-05-18 02-05-18 3,854.6 01-05-18 02-05-18 03-05-18 04-05-18 3,090.6 3,459.9 8,018.9 2,655.4 2,765.0 04-05-18 05-05-18 06-05-18 07-05-18 08-05-18 09-05-18 10-05-18 11-05-18 12-05-18 13-05-18 14-05-18 15-05-184,251.8 16-05-18 17-05-18 18-05-18 19-05-183,215.2 132.1 180.3 164.2 150.3 3,581.1 3,855.0 3,758.5 3,534.5 3,138.3 3,590.9 2,088.1 2,356.6 3,573.5 07-05-18 December-17 09-05-18 10-05-18 11-05-18 12-05-18 13-05-18 14-05-18 15-05-18 16-05-18 17-05-18 February-18 3,066.2 3,851.6 3,803.2 3,461.3 3,720.6 3,023.9 2,627.9 18-05-18 2,248.7 2,846.0 2,974.0 2,782.0 2,800.1 3,066.4 1,998.6 2,067.4 2,703.5 3,132.1 ual Energy Consumption 195.3 Meter A02 3,692.8 3,320.5 3,153.9 Demand Month Energy [kWh] [kW] 19-05-18 90,204.0 197.3 99,567.1 190.9 98,458.5 196.8 84,899.2 188.4 84,530.9 164.0 85,630.0 184.0 85,706.0 163.3 73,279.7 183.1 83,264.5 82,156.8 211.2 91,149.5 239.3 90,639.1 195.3 189.7 172.0 21-05-18 22-05-18 3,346.7 3,472.5 2,846.8 3,654.3 3,380.3 21-05-18 22-05-18 23-05-18 24-05-18 October-17 24-05-18 25-05-18 26-05-18 27-05-18 142.8 26-05-18 27-05-18 February-18 18 3,780.2 2,841.9 3,042.1 202 3,708.5 31-05-18 2,726.1 30-05-18 31-05-18 109.6