Spreadsheet: 185213d1349562739-index-match-return-data-from-one-sheet-to-another-lookup-problem
Sheet: Summary

 | 2012-08-01 00:00:00
 | Branch | Branch1 | Total
 | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt
 | [NAME] | 486 | 289 | 232 | 213 | 313
 | Sales to external Customers | 165 | 420 | 496 | 165 | 356
 | IG Sales within Processing | 102 | 168 | 221 | 484 | 403
 | Cost of Goods Sold - Variable | 382 | 123 | 207 | 382 | 294
 | Cost of Goods Sold - Fixed | 240 | 341 | 220 | 124 | 314
 | CERT Income | 269 | 369 | 382 | 472 | 181
 | Standard Margin from Sales | 126 | 154 | 467 | 467 | 200
 | Energy Surcharge Income | 426 | 308 | 338 | 443 | 254
 | Energy Surcharge Cost | 267 | 374 | 335 | 485 | 201
 | Energy Surcharge Margin | 478 | 328 | 235 | 478 | 434
 | CTS - Distribution | 433 | 333 | 127 | 225 | 468
 | CTS - Other prime | 483 | 229 | 223 | 452 | 210
 | CTS - Overhead | 199 | 151 | 191 | 390 | 437
 | CTS - Bad debt prv mvt | 237 | 441 | 262 | 495 | 369
 | Total Cost to Serve | 200 | 462 | 369 | 187 | 246
 | Margin from Sales | 178 | 362 | 163 | 167 | 462
 | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt
 | m2 Produced | 300 | 254 | 320 | 114 | 473
 | Direct Materials | 340 | 453 | 341 | 102 | 109
 | Energy | 211 | 161 | 145 | 200 | 325
 | Direct Labour | 460 | 139 | 235 | 353 | 236
 | Variable Costs of Manufacture | 275 | 278 | 193 | 235 | 313
 | BFC - Other prime | 319 | 400 | 371 | 118 | 131
 | BFC - Overhead | 443 | 327 | 470 | 435 | 333
 | BFC - Depreciation | 372 | 355 | 383 | 360 | 419
 | BFC - Operating Leases | 462 | 299 | 287 | 322 | 250
 | BFC - Others | 138 | 259 | 288 | 283 | 127
 | Total Branch Fixed Costs | 494 | 361 | 353 | 170 | 329
 | Total Branch Costs | 343 | 192 | 300 | 100 | 224
 | Production Credit - Variable | 318 | 265 | 203 | 333 | 109
 | Production Credit - Fixed | 373 | 182 | 116 | 102 | 227
 | Total Credit from Production | 367 | 174 | 423 | 234 | 461
 | Branch Performance | 357 | 178 | 467 | 460 | 252
 | Branch Profit / (Loss) | 315 | 229 | 387 | 478 | 427
 | Branch | Branch2 | Total
 | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt
 | [NAME] | 148 | 417 | 198 | 339 | 244
 | Sales to external Customers | 197 | 211 | 338 | 149 | 119
 | IG Sales within Processing | 197 | 305 | 138 | 171 | 240
 | Cost of Goods Sold - Variable | 407 | 418 | 342 | 286 | 370
 | Cost of Goods Sold - Fixed | 100 | 307 | 370 | 416 | 441
 | CERT Income | 153 | 469 | 372 | 421 | 341
 | Standard Margin from Sales | 432 | 428 | 475 | 356 | 436
 | Energy Surcharge Income | 371 | 401 | 195 | 440 | 421
 | Energy Surcharge Cost | 186 | 232 | 360 | 179 | 126
 | Energy Surcharge Margin | 181 | 123 | 297 | 238 | 375
 | CTS - Distribution | 222 | 130 | 352 | 323 | 113
 | CTS - Other prime | 454 | 173 | 303 | 307 | 375
 | CTS - Overhead | 499 | 244 | 314 | 269 | 159
 | CTS - Bad debt prv mvt | 283 | 450 | 177 | 380 | 324
 | Total Cost to Serve | 337 | 164 | 148 | 139 | 325
 | Margin from Sales | 286 | 477 | 168 | 316 | 469
 | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt
 | m2 Produced | 463 | 161 | 486 | 127 | 262
 | Direct Materials | 462 | 315 | 195 | 342 | 265
 | Energy | 196 | 373 | 424 | 129 | 242
 | Direct Labour | 470 | 131 | 424 | 491 | 326
 | Variable Costs of Manufacture | 107 | 177 | 388 | 440 | 178
 | BFC - Other prime | 472 | 231 | 473 | 330 | 437
 | BFC - Overhead | 442 | 100 | 474 | 298 | 156
 | BFC - Depreciation | 301 | 349 | 182 | 237 | 246
 | BFC - Operating Leases | 263 | 203 | 107 | 170 | 135
 | BFC - Others | 470 | 435 | 330 | 450 | 322
 | Total Branch Fixed Costs | 353 | 432 | 247 | 239 | 451
 | Total Branch Costs | 417 | 220 | 428 | 398 | 243
 | Production Credit - Variable | 203 | 461 | 471 | 283 | 239
 | Production Credit - Fixed | 167 | 132 | 107 | 266 | 232
 | Total Credit from Production | 443 | 478 | 467 | 134 | 206
 | Branch Performance | 322 | 190 | 437 | 109 | 191
 | Branch Profit / (Loss) | 143 | 321 | 492 | 119 | 173
 | Branch | Branch3 | Total
 | Commercial | Month Actual | Month Budget | Target | B/(W) Bud | B/(W) Tgt
 | [NAME] | 453 | 115 | 395 | 328 | 388
 | Sales to external Customers | 421 | 449 | 210 | 360 | 143
 | IG Sales within Processing | 175 | 137 | 467 | 214 | 347
 | Cost of Goods Sold - Variable | 490 | 388 | 192 | 276 | 284
 | Cost of Goods Sold - Fixed | 426 | 116 | 147 | 270 | 248
 | CERT Income | 378 | 390 | 305 | 307 | 142
 | Standard Margin from Sales | 328 | 345 | 120 | 134 | 151
 | Energy Surcharge Income | 450 | 208 | 281 | 168 | 138
 | Energy Surcharge Cost | 263 | 350 | 470 | 156 | 329
 | Energy Surcharge Margin | 380 | 394 | 120 | 441 | 377
 | CTS - Distribution | 126 | 226 | 105 | 150 | 473
 | CTS - Other prime | 246 | 441 | 362 | 312 | 401
 | CTS - Overhead | 266 | 351 | 272 | 490 | 396
 | CTS - Bad debt prv mvt | 480 | 299 | 471 | 172 | 249
 | Total Cost to Serve | 325 | 174 | 207 | 216 | 370
 | Margin from Sales | 217 | 461 | 135 | 296 | 224
 | Manufacturing | Actual | Budget | Target | B/(W) Bud | B/(W) Tgt
 | m2 Produced | 411 | 385 | 498 | 474 | 354
 | Direct Materials | 266 | 402 | 498 | 238 | 308
 | Energy | 114 | 262 | 476 | 121 | 289
 | Direct Labour | 127 | 480 | 349 | 108 | 359
 | Variable Costs of Manufacture | 324 | 388 | 126 | 488 | 339
 | BFC - Other prime | 128 | 119 | 428 | 391 | 274
 | BFC - Overhead | 361 | 409 | 447 | 176 | 342
 | BFC - Depreciation | 433 | 327 | 361 | 187 | 338
 | BFC - Operating Leases | 352 | 280 | 429 | 453 | 424
 | BFC - Others | 135 | 151 | 225 | 445 | 353
 | Total Branch Fixed Costs | 357 | 194 | 203 | 156 | 295
 | Total Branch Costs | 404 | 277 | 146 | 271 | 485
 | Production Credit - Variable | 259 | 258 | 293 | 457 | 468
 | Production Credit - Fixed | 208 | 304 | 139 | 220 | 272
 | Total Credit from Production | 157 | 417 | 484 | 186 | 214
 | Branch Performance | 394 | 231 | 179 | 402 | 182
 | Branch Profit / (Loss) | 405 | 265 | 223 | 329 | 222