Spreadsheet: mary_hain__25863__Data_Response_DS_SP_001
Sheet: 123.81 avg market w Slice

 |  |  |  |  |  |  | With Slice
 |  |  |  |  |  |  | PF |  | 21.83
 |  |  |  |  |  |  | DSI | 1486 | 23
 |  |  |  |  |  |  | IOU | 1000 | 19.26
 |  |  |  |  |  |  | Slice | 2000 | 27
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | LB CRAC Rev Basis
 |  |  |  |  |  |  |  |  | FB CRAC Rev Basis
 |  |  |  |  |  |  |  | FB/LB
 |  |  |  |  |  |  |  | Avg CRACable Rate
Attachment 1C
Augmentation Costs with $123.8/MWh Average Augmentation Price
 | BPA Figures with no load loss
 | See BPA Toolkit File "TK_145_S2000_315Mkt_LR0_021001"
 | Rem Aug | Net Augm | LB CRAC | FB  CRAC |  | Market | Rem Aug | Net Augm | LB CRAC | FB  CRAC | LB Rate |  | Rate | Rates | Rates with LB CRAC
Year | Q (aMW) | Cost | Rev Basis | Rev Basis |  | Price | Q (aMW) | Cost | Rev Basis | Rev Basis | Increase |  | Schedule | No LB CRAC | Year 1 | [NAME]
 | aMW | $ Millions | $ Millions | $ Millions |  | $/MWh | aMW | $ Millions | $ Millions | $ Millions |  |  |  | $/MWh | $/MWh | $/MWh
1 | 2549.657530864197 | 6497.136397757534 | 1639.30228464 | 1166.26228464 |  | 311.2916950626129 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 2970.063773788078 | 1648.48136304 | 1175.44136304 |  | 168.5668416241306 |  |  |  |  |  |  | DSI
3 | 2159.868751714678 | 461.402277226965 | 1656.32182584 | 1183.28182584 |  | 44.31727154985469 |  |  |  |  |  |  | IOU
4 | 2001.018560385889 | 485.3469814684757 | 1667.79567384 | 1194.75567384 |  | 47.25333207419796 |  |  |  |  |  |  | Slice
5 | 2149.758003445949 | 519.2982896350935 | 1677.54844464 | 1204.50844464 |  | 47.63730412210631
Average
 | BPA Figures with 1500 aMW load loss
 | See BPA Toolkit File "TK_145_S2000_315Mkt_LR1500_021001"
 | Rem Aug | Net Augm | LB CRAC | FB  CRAC |  | Market | Rem Aug | Net Augm | LB CRAC | FB  CRAC | LB Rate |  | Rate | Rates | Rates with LB CRAC
Year | Q (aMW) | Cost | Rev Basis | Rev Basis |  | Price | Q (aMW) | Cost | Rev Basis | Rev Basis | Increase |  | Schedule | No LB CRAC | Year 1 | [NAME]
 | aMW | $ Millions | $ Millions | $ Millions |  | $/MWh | aMW | $ Millions | $ Millions | $ Millions |  |  |  | $/MWh | $/MWh | $/MWh
1 | 1006.130056075146 | 2521.130397757534 | 1348.90828464 | 875.86828464 |  | 311.2916950626129 |  |  |  |  |  |  | PF
2 | 743.819031444075 | 938.1577737880784 | 1358.08736304 | 885.0473630399999 |  | 168.5668416241306 |  |  |  |  |  |  | DSI
3 | 616.3412769256264 | 128.5918772269649 | 1365.92782584 | 892.88782584 |  | 44.31727154985469 |  |  |  |  |  |  | IOU
4 | 457.7931270732334 | 105.1409814684758 | 1377.40167384 | 904.3616738399999 |  | 47.25333207419796 |  |  |  |  |  |  | Slice
5 | 609.0333915389492 | 145.7922896350935 | 1387.15444464 | 914.1144446399999 |  | 47.63730412210631
Average
 | Augmentation Calculation with IP TAC CRAC
 | See BPA Toolkit File "TK_145_S2000_315Mkt_LR0_021001"
 | Application of IP TAC CRAC
 |  | Sales (aMW) | LB CRAC Rates ($/MWh) | Revenue   ($ millions)
 | PF |  | 21.83
 | DSI | 1486 |  |  | ------>
 | IOU | 1000 | 19.26
 | Slice | 2000 | 27
 | Total
 |  |  | LB CRAC Rev Basis
 |  |  | FB CRAC Rev Basis |  | ------> | FB CRAC Rev Basis = LB CRAC Rev Basis minus [NAME]
 |  |  | FB/LB
 |  | Avg CRACable Rate
 | Rem Aug | Net Augm | LB CRAC | FB  CRAC |  | Market | Rem Aug | Net Augm | LB CRAC | FB  CRAC | LB Rate |  | Rate | Rates | Rates with LB CRAC
Year | Q (aMW) | Cost | Rev Basis | Rev Basis |  | Price | Q (aMW) | Cost | Rev Basis | Rev Basis | Increase |  | Schedule | No LB CRAC | Year 1 | [NAME]
 | aMW | $ Millions | $ Millions | $ Millions |  | $/MWh | aMW | $ Millions | $ Millions | $ Millions |  |  |  | $/MWh | $/MWh | $/MWh
1 | 2549.657530864197 | 6497.136397757534 |  |  |  | 311.2916950626129 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 2970.063773788078 |  |  |  | 168.5668416241306 |  |  |  |  |  |  | DSI
3 | 2159.868751714678 | 461.402277226965 |  |  |  | 44.31727154985469 |  |  |  |  |  |  | IOU
4 | 2001.018560385889 | 485.3469814684757 |  |  |  | 47.25333207419796 |  |  |  |  |  |  | Slice
5 | 2149.758003445949 | 519.2982896350935 |  |  |  | 47.63730412210631
Average