Spreadsheet: mary_hain__25864__Data_Response_BPA_SP_009
Sheet: Attachment 1B

 |  |  |  |  |  |  | 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 1B
Augmentation Costs with $91.8/MWh Average Augmentation Price
 | BPA Figures with no load loss
 | See BPA Toolkit File "TK_145_S2000_210Mkt_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 | 4179.536397757534 | 1639.30228464 | 1166.26228464 |  | 207.5263042824682 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 1838.963773788078 | 1648.48136304 | 1175.44136304 |  | 112.1167129644154 |  |  |  |  |  |  | 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_210Mkt_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 | 1626 | 1348.9 | 875.9 |  | 207.5263042824682 |  |  |  |  |  |  | PF
2 | 744 | 585 | 1358.1 | 885 |  | 112.1167129644154 |  |  |  |  |  |  | DSI
3 | 616 | 129 | 1365.9 | 892.9 |  | 44.31727154985469 |  |  |  |  |  |  | IOU
4 | 458 | 105 | 1377.4 | 904.4 |  | 47.25333207419796 |  |  |  |  |  |  | Slice
5 | 609 | 146 | 1387.2 | 914.1 |  | 47.63730412210631
Average
 | Augmentation Calculation with IP TAC CRAC
 | See BPA Toolkit File "TK_145_S2000_210Mkt_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 | 4179.536397757534 |  |  |  | 207.5263042824682 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 1838.963773788078 |  |  |  | 112.1167129644154 |  |  |  |  |  |  | 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