Question

Column FHeadings Month Name, kWh/facility, Total kWh for 5 Facilities/Month 4. Using a spreadsheet, figure out how much money the TDSP charge is each month (Jan, Feb, March, etc) for the 5 facilities in total. Column Headings Month Name, Customer Charge, Peak Charge, Energy Charge, Sales Tax, Total (S) 5. Using a spreadsheet, calculate the amount of the energy/generation portion of the bill only (not TDSP charges) for each month of the year (Jan, Feb, March, etc) for the following options Column Headings Month Name, Peak kWh Amount, Peak kWh Rate (S/kWh), Sales Tax, Total S (You need separate on and off peak kWh Amount and Rate columns for Option 3) a. Option 1 b. Option 2 c. Option 3 6. What is the total cost of the overall electricity bill for the 5 plants for the year on each of the three options? a. Option 1 b. Option 2 c. Option 3 7. Which of the companies/options is the lowest cost option for the next year? 8. If you chose Safe & Easy, what could you do to save money compared to the total estimated electricity cost you came up with in 6a? 9. What are the disadvantages to you of staying with Safe & Easy? 10. If you chose the Traders R Us proposal, what could you do to save money compared to the total estimated cost you came up with in 6b? 11. What are the disadvantages of choosing the Traders R Us proposal? 12. If you chose the EcoMind proposal, what could you do to save money compared to the total estimated cost you came up with in 6c? 13. What are the disadvantages of the EcoMind 14. Which of the three options would you choose and why? proposal? You are the energy manager for a food company that operates 5 milk cheese processing acilities. The owners have asked vou to evaluate aggregating the usage oft e 5 acilities together and putting out a RFP (Request for Proposals) to energy providers to bid on supp the power for all 5 of the facilities as a single contract for one year to see if they can lowe electricity cost. Each facility has identical demand patens as follows (one facility) giver present mode of operation: price plus 15% of that amount. Traders R Us will also collect and pay the local TDSP T&D charges which will be listed as a straight pass through on the bill. Current Energy Futures Prices (Today) January February 24.00 March April May June 22.00 atte Midnight to 6am 300 kW 6 amto6pm.-500kW 6 p.m to Midnight-200 kW 32.00 35.00 45.00 65.00 85.00 98.00 July August September 88.00 October 68.00 November 48.00 December 32.00 The Transmission and Distribution Service Provider (TDSP) rate regardless of which Retail Energy Provider (REP), broker or aggregator you use is as follows: TDSP Transmission &Distribution Month ly Charges Customer Charge: $25 month per meter Monthly Peak Demand Charge: S10.00 peak kW per month meter Energy Charge: (all hours) S0.03Whfor all energy at all facilities Power Factor Penalty: None Option 3: EcoMind This company offers the generation/energy portion of your bill in incentive form with an on-peak and off-peak energy rate to promote conservation. They also guarantee the all energy you are consuming will be "renewable energy" meeting the definitions and requirements in the states your milk/cheese plants are located in. Similar to the others, they arrange your supply, collect t pass through charges Remember..you pay your contracted electricity supplier the total of the UDC T&D charges lus the contracted ener v eneration char es. The s ate wants their 6% sales tax of your MONTHLY bill total (TDSP+Supplier). he bill and pay any other suppliers like the TDSP the Their energy structure is as follows Off-peak hours (10 p.m.-10 am.) $0.02kWh Peak hours (10 am. -10 p.m) $0.20/kWh Bids from competitive REP's are recived and there are several viable options available including a new proposal from your current supplier "Safe & Easy Company" Questions: (Show your work and attach calculations or spreadsheet printouts on additional sheets stapled to this handout when you turn it in). Option 1 (Current Supplier): Safe & Easy Company This company offers the energy'generation portion of the bill at a fixed price for one year of $0.08kWh (all hours). They will take care of arranging your supply, aggregating the1. How much energy does an individual processing facility use per day? (show your bills and sending you a billeach month You pay them and they pay all the other suppliers. You like the fact that the $0.08 is easy to remember but you notice in the contract you must pay for a minimum 250,000 kWh every month even if you don't use that much. work) 2. Make a spreadsheet and calculate how much energy an individual facility uses per month (Jan, Feb, March, etc.)? Column Headings: Month Name, kWh/Day, Days in Month, Total kWhMonth Option 2: Traders R Us This company offers the energy'generation portion of the bill at a cost based on the utures man et orward price curve us a 5% premium an act ncarge. Here show it works, each month, the price you pay for energy will be based on the present futures 3How much en ry d the etc) for each month of the year? faciltes use in total together per month (Jan Feb. March

Answer 1

Avswer a) ph stal B) Sles Jan 25109305310235115 feb251 08 H05312846 3 8 Ma 25109 3255 6 235 5 Ap lof1495 ay 93058 10235 ls Ag 5101 305 lo 235 ep5 41u956 oct 25 lo 930 5310 2351l5 o 25lo1005 5991495 Dec 510350235115 woles . Assumed Peal eg , hence Pull dato mon

4on 2500 0 00 0%2000012o0 212 0ofe 25 000 00 os 20000 12 oo 212 oo Mot2.500000 082.ocool2 oD 212 00 Apr 25000 08200001200 21200 ny 25000 oo . 0820000 1206 외 200 25 000 00 0820000 D. 00 912 00 Juj 25 o0 8 2oo00 1200 21200 Ag 2 50ood o820000 2 00 Doo sep 35 00o0o 0E 2060 1200 212 00 oct 2500000 o8 2000 012bo 212 oo Nov 5 00ooo o82 oo o012 00212.00 Dec 95o000008 2 000012oo Cons 4nmn CS

rdan 15500 00.0220 . 02.53 q222 35457 fel,Nooooo 02uo 028 386H232106 15500 00 032 o357on 3 4260 l 6 Aps 1500000 350 040 6 363 626 400 may 1550060 0u50 052602lugl3so3 n 1500000 50 0751 2137311535 Tl 155 o0000 5o 9815151 079리2 172712Sg48 샤 1500000 .04 80.05,58 2804978 77 Dec 1550000 .0320.05+ 570 изче 60MB tal 1 4425 (to pm - lo Amy ale m tue

533462.00 35 621638 13105 feb 28533467-o 250 0232 434543 21 u M313 o 200 623596216 381219059 A 305 33467o 2.0 oo .62349 0 uu pey31533 4670, 오ㆀ.0235-96외633 12.1 a o 5 Jun 5 厅u0 3153346ヌ0 200。2359 62/ 63Z | 21qo59 Ag 1533 u 670 2.00 G23 6163120s9 p 353366 0 o23u30209363 918 u oc 1533u6o.2.00 2-3596126 3wa 30 5334670.200 200 2 bo 6 Nov30533 u 170 200 .02.3480 209 36t9 shuu Dec 3 1533467o 200 02359621 638 121qsa AsSuwu um cS Scanned with CamScanner