Spreadsheet: mary_hain__25863__Data_Response_DS_SP_001
Sheet: 70.5 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 1A
Augmentation Costs with $70.5/MWh Average Augmentation Price
 | BPA Figures with no load loss
 | See BPA Toolkit File "TK_145_S2000_140Mkt_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 | 2634.536397757533 | 1639.30228464 | 1166.26228464 |  | 138.3523619475858 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 1093.563773788078 | 1648.48136304 | 1175.44136304 |  | 74.91582365051589 |  |  |  |  |  |  | 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_140Mkt_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 | 1014.363765822091 | 1037.150734028628 | 1258.40637696 | 1258.40637696 |  | 138.3523619475858 |  |  |  |  |  |  | PF
2 | 800.7316235375598 | 378.4114789646414 | 1278.48561096 | 1278.48561096 |  | 74.91582365051589 |  |  |  |  |  |  | DSI
3 | 714.0254055711101 | 146.2500813850862 | 1297.22622936 | 1297.22622936 |  | 44.31727154985469 |  |  |  |  |  |  | IOU
4 | 600.3436572668552 | 130.8740573790607 | 1316.92300176 | 1316.92300176 |  | 47.25333207419796 |  |  |  |  |  |  | Slice
5 | 773.3063956460956 | 181.7585605540772 | 1332.03023496 | 1332.03023496 |  | 47.63730412210631
Average
 | Augmentation Calculation with IP TAC CRAC
 | See BPA Toolkit File "TK_145_S2000_140Mkt_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 | 2634.536397757533 |  |  |  | 138.3523619475858 |  |  |  |  |  |  | PF
2 | 2287.346506233126 | 1093.563773788078 |  |  |  | 74.91582365051589 |  |  |  |  |  |  | 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