Spreadsheet: 180107d1347478248-index-match-formula-to-return-data-to-summary-sheet-lookup-key
Sheet: Summary

 | 2012-08-01 00:00:00
 | Branch | Branch1 | Total |  |  |  |  | Branch | Branch1 | 1129 |  |  |  |  | Branch | Branch1 | 1130 |  |  |  |  | Branch | Branch1 | 1240 |  |  |  |  | Branch | Branch1 | 1240 |  |  |  |  | Branch | Branch1 | 1240
 | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt |  | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt |  | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt |  | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt |  | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt |  | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt
 | [NAME] | #N/A |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 | Sales to external Customers | 137 | 69 |  |  |  |  | Sales to external Customers | 162 | 102 |  |  |  |  | Sales to external Customers | 0 | 0 |  |  |  |  | Sales to external Customers | 80 | 143 |  |  |  |  | Sales to external Customers | 80 | 143 |  |  |  |  | Sales to external Customers | 80 | 143
 | IG Sales within Processing | 20 | 74 |  |  |  |  | IG Sales within Processing | 126 | 24 |  |  |  |  | IG Sales within Processing | 0 | 0 |  |  |  |  | IG Sales within Processing | 111 | 30 |  |  |  |  | IG Sales within Processing | 111 | 30 |  |  |  |  | IG Sales within Processing | 111 | 30
 | Cost of Goods Sold - Variable | 0 | 0 |  |  |  |  | Cost of Goods Sold - Variable | 0 | 0 |  |  |  |  | Cost of Goods Sold - Variable | 0 | 0 |  |  |  |  | Cost of Goods Sold - Variable | 0 | 0 |  |  |  |  | Cost of Goods Sold - Variable | 0 | 0 |  |  |  |  | Cost of Goods Sold - Variable | 0 | 0
 | Cost of Goods Sold - Fixed | 0 | 0 |  |  |  |  | Cost of Goods Sold - Fixed | 0 | 0 |  |  |  |  | Cost of Goods Sold - Fixed | 0 | 0 |  |  |  |  | Cost of Goods Sold - Fixed | 0 | 0 |  |  |  |  | Cost of Goods Sold - Fixed | 0 | 0 |  |  |  |  | Cost of Goods Sold - Fixed | 0 | 0
 | CERT Income | 137 | 47 |  |  |  |  | CERT Income | 48 | 91 |  |  |  |  | CERT Income | 0 | 0 |  |  |  |  | CERT Income | 0 | 0 |  |  |  |  | CERT Income | 0 | 0 |  |  |  |  | CERT Income | 0 | 0
 | Standard Margin from Sales | 294 | 190 | 0 | 0 | 0 |  | Standard Margin from Sales | 336 | 217 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 191 | 173 | 0 | 0 | 0 |  | Standard Margin from Sales | 191 | 173 | 0 | 0 | 0 |  | Standard Margin from Sales | 191 | 173 | 0 | 0 | 0
 | Energy Surcharge Income | 191 | 99 |  |  |  |  | Energy Surcharge Income | 195 | 181 |  |  |  |  | Energy Surcharge Income | 0 | 0 |  |  |  |  | Energy Surcharge Income | 214 | 136 |  |  |  |  | Energy Surcharge Income | 214 | 136 |  |  |  |  | Energy Surcharge Income | 214 | 136
 | Energy Surcharge Cost | 70 | 286 |  |  |  |  | Energy Surcharge Cost | 42 | 147 |  |  |  |  | Energy Surcharge Cost | 0 | 0 |  |  |  |  | Energy Surcharge Cost | 108 | 127 |  |  |  |  | Energy Surcharge Cost | 108 | 127 |  |  |  |  | Energy Surcharge Cost | 108 | 127
 | Energy Surcharge Margin | 261 | 385 | 0 | 0 | 0 |  | Energy Surcharge Margin | 237 | 328 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 322 | 263 | 0 | 0 | 0 |  | Energy Surcharge Margin | 322 | 263 | 0 | 0 | 0 |  | Energy Surcharge Margin | 322 | 263 | 0 | 0 | 0
 | CTS - Distribution | 436 | 341 |  |  |  |  | CTS - Distribution | 335 | 619 |  |  |  |  | CTS - Distribution | -51.46 | 0 |  |  |  |  | CTS - Distribution | 0 | 0 |  |  |  |  | CTS - Distribution | 0 | 0 |  |  |  |  | CTS - Distribution | 0 | 0
 | CTS - Other prime | 195 | 280 |  |  |  |  | CTS - Other prime | 160 | 211 |  |  |  |  | CTS - Other prime | 0 | 0 |  |  |  |  | CTS - Other prime | 216 | 212 |  |  |  |  | CTS - Other prime | 216 | 212 |  |  |  |  | CTS - Other prime | 216 | 212
 | CTS - Overhead | 0 | 0 |  |  |  |  | CTS - Overhead | 0 | 0 |  |  |  |  | CTS - Overhead | 0 | 0 |  |  |  |  | CTS - Overhead | 0 | 0 |  |  |  |  | CTS - Overhead | 0 | 0 |  |  |  |  | CTS - Overhead | 0 | 0
 | CTS - Bad debt prv mvt | 115 | 145 |  |  |  |  | CTS - Bad debt prv mvt | 129 | 229 |  |  |  |  | CTS - Bad debt prv mvt | 0 | 0 |  |  |  |  | CTS - Bad debt prv mvt | 0 | 0 |  |  |  |  | CTS - Bad debt prv mvt | 0 | 0 |  |  |  |  | CTS - Bad debt prv mvt | 0 | 0
 | Total Cost to Serve | 746 | 766 | 0 | 0 | 0 |  | Total Cost to Serve | 624 | 1059 | 0 | 0 | 0 |  | Total Cost to Serve | -51.46 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 216 | 212 | 0 | 0 | 0 |  | Total Cost to Serve | 216 | 212 | 0 | 0 | 0 |  | Total Cost to Serve | 216 | 212 | 0 | 0 | 0
 | Margin from Sales | 1301 | 1341 | 0 | 0 | 0 |  | Margin from Sales | 1197 | 1604 | 0 | 0 | 0 |  | Margin from Sales | -51.46 | 0 | 0 | 0 | 0 |  | Margin from Sales | 729 | 648 | 0 | 0 | 0 |  | Margin from Sales | 729 | 648 | 0 | 0 | 0 |  | Margin from Sales | 729 | 648 | 0 | 0 | 0
 | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt |  | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt |  | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt |  | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt |  | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt |  | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt
 | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced
 | Direct Materials | 618 | 929 |  |  |  |  | Direct Materials | 654 | 676 |  |  |  |  | Direct Materials | 0 | 0 |  |  |  |  | Direct Materials | 378 | 44 |  |  |  |  | Direct Materials | 378 | 44 |  |  |  |  | Direct Materials | 378 | 44
 | Energy | 153 | 203 |  |  |  |  | Energy | 175 | 153 |  |  |  |  | Energy | 0 | 0 |  |  |  |  | Energy | 0 | 0 |  |  |  |  | Energy | 0 | 0 |  |  |  |  | Energy | 0 | 0
 | Direct Labour | 265 | 377 |  |  |  |  | Direct Labour | 565 | 338 |  |  |  |  | Direct Labour | 0 | 0 |  |  |  |  | Direct Labour | 638 | 299 |  |  |  |  | Direct Labour | 638 | 299 |  |  |  |  | Direct Labour | 638 | 299
 | Variable Costs of Manufacture | 1036 | 1509 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 1394 | 1167 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 1016 | 343 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 1016 | 343 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 1016 | 343 | 0 | 0 | 0
 | BFC - Other prime | 205 | 346 |  |  |  |  | BFC - Other prime | 416 | 164 |  |  |  |  | BFC - Other prime | 0 | 0 |  |  |  |  | BFC - Other prime | 195 | 187 |  |  |  |  | BFC - Other prime | 195 | 187 |  |  |  |  | BFC - Other prime | 195 | 187
 | BFC - Overhead | 4957 | 5187 |  |  |  |  | BFC - Overhead | 5564 | 5162 |  |  |  |  | BFC - Overhead | -0.01 | 0 |  |  |  |  | BFC - Overhead | 0 | 0 |  |  |  |  | BFC - Overhead | 0 | 0 |  |  |  |  | BFC - Overhead | 0 | 0
 | BFC - Depreciation | 37 | 71 |  |  |  |  | BFC - Depreciation | 50 | 35 |  |  |  |  | BFC - Depreciation | 0 | 0 |  |  |  |  | BFC - Depreciation | 0 | 0 |  |  |  |  | BFC - Depreciation | 0 | 0 |  |  |  |  | BFC - Depreciation | 0 | 0
 | BFC - Operating Leases | 229 | 240 |  |  |  |  | BFC - Operating Leases | 91 | 225 |  |  |  |  | BFC - Operating Leases | 0 | 0 |  |  |  |  | BFC - Operating Leases | 0 | 0 |  |  |  |  | BFC - Operating Leases | 0 | 0 |  |  |  |  | BFC - Operating Leases | 0 | 0
 | BFC - Others | 282 | 324 |  |  |  |  | BFC - Others | 318 | 191 |  |  |  |  | BFC - Others | 0 | 0 |  |  |  |  | BFC - Others | 0 | 0 |  |  |  |  | BFC - Others | 0 | 0 |  |  |  |  | BFC - Others | 0 | 0
 | Total Branch Fixed Costs | 5710 | 6168 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 6439 | 5777 | 0 | 0 | 0 |  | Total Branch Fixed Costs | -0.01 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 195 | 187 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 195 | 187 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 195 | 187 | 0 | 0 | 0
 | Total Branch Costs | 6746 | 7677 | 0 | 0 | 0 |  | Total Branch Costs | 7833 | 6944 | 0 | 0 | 0 |  | Total Branch Costs | -0.01 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 1211 | 530 | 0 | 0 | 0 |  | Total Branch Costs | 1211 | 530 | 0 | 0 | 0 |  | Total Branch Costs | 1211 | 530 | 0 | 0 | 0
 | Production Credit - Variable | 0 | 0 |  |  |  |  | Production Credit - Variable | 0 | 0 |  |  |  |  | Production Credit - Variable | 0 | 0 |  |  |  |  | Production Credit - Variable | 0 | 0 |  |  |  |  | Production Credit - Variable | 0 | 0 |  |  |  |  | Production Credit - Variable | 0 | 0
 | Production Credit - Fixed | 0 | 0 |  |  |  |  | Production Credit - Fixed | 0 | 0 |  |  |  |  | Production Credit - Fixed | 0 | 0 |  |  |  |  | Production Credit - Fixed | 0 | 0 |  |  |  |  | Production Credit - Fixed | 0 | 0 |  |  |  |  | Production Credit - Fixed | 0 | 0
 | Total Credit from Production | 0 | 0 | 0 | 0 | 0 |  | Total Credit from Production | 0 | 0 | 0 | 0 | 0 |  | Total Credit from Production | 0 | 0 | 0 | 0 | 0 |  | Total Credit from Production | 0 | 0 | 0 | 0 | 0 |  | Total Credit from Production | 0 | 0 | 0 | 0 | 0 |  | Total Credit from Production | 0 | 0 | 0 | 0 | 0
 | Branch Performance | 6746 | 7677 | 0 | 0 | 0 |  | Branch Performance | 7833 | 6944 | 0 | 0 | 0 |  | Branch Performance | -0.01 | 0 | 0 | 0 | 0 |  | Branch Performance | 1211 | 530 | 0 | 0 | 0 |  | Branch Performance | 1211 | 530 | 0 | 0 | 0 |  | Branch Performance | 1211 | 530 | 0 | 0 | 0
 | Branch Profit / (Loss) | 8047 | 9018 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 9030 | 8548 | 0 | 0 | 0 |  | Branch Profit / (Loss) | -51.47 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 1940 | 1178 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 1940 | 1178 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 1940 | 1178 | 0 | 0 | 0