Spreadsheet: 180006d1347454786-lookup-and-match-formula-required-lookup-key
Sheet: Summary

 | Branch | Branch1 | Total |  |  |  |  | Branch | Branch1 | 1129 |  |  |  |  | Branch | Branch1 | 1130 |  |  |  |  | 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
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 | Sales to external Customers |  |  |  |  |  |  | Sales to external Customers |  |  |  |  |  |  | Sales to external Customers |  |  |  |  |  |  | Sales to external Customers
 | IG Sales within Processing |  |  |  |  |  |  | IG Sales within Processing |  |  |  |  |  |  | IG Sales within Processing |  |  |  |  |  |  | IG Sales within Processing
 | Cost of Goods Sold - Variable |  |  |  |  |  |  | Cost of Goods Sold - Variable |  |  |  |  |  |  | Cost of Goods Sold - Variable |  |  |  |  |  |  | Cost of Goods Sold - Variable
 | Cost of Goods Sold - Fixed |  |  |  |  |  |  | Cost of Goods Sold - Fixed |  |  |  |  |  |  | Cost of Goods Sold - Fixed |  |  |  |  |  |  | Cost of Goods Sold - Fixed
 | CERT Income |  |  |  |  |  |  | CERT Income |  |  |  |  |  |  | CERT Income |  |  |  |  |  |  | CERT Income
 | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0
 | Energy Surcharge Income |  |  |  |  |  |  | Energy Surcharge Income |  |  |  |  |  |  | Energy Surcharge Income |  |  |  |  |  |  | Energy Surcharge Income
 | Energy Surcharge Cost |  |  |  |  |  |  | Energy Surcharge Cost |  |  |  |  |  |  | Energy Surcharge Cost |  |  |  |  |  |  | Energy Surcharge Cost
 | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0
 | CTS - Distribution |  |  |  |  |  |  | CTS - Distribution |  |  |  |  |  |  | CTS - Distribution |  |  |  |  |  |  | CTS - Distribution
 | CTS - Other prime |  |  |  |  |  |  | CTS - Other prime |  |  |  |  |  |  | CTS - Other prime |  |  |  |  |  |  | CTS - Other prime
 | CTS - Overhead |  |  |  |  |  |  | CTS - Overhead |  |  |  |  |  |  | CTS - Overhead |  |  |  |  |  |  | CTS - Overhead
 | CTS - Bad debt prv mvt |  |  |  |  |  |  | CTS - Bad debt prv mvt |  |  |  |  |  |  | CTS - Bad debt prv mvt |  |  |  |  |  |  | CTS - Bad debt prv mvt
 | Total Cost to Serve | 0 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 0 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 0 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 0 | 0 | 0 | 0 | 0
 | Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Margin from Sales | 0 | 0 | 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
 | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced
 | Direct Materials |  |  |  |  |  |  | Direct Materials |  |  |  |  |  |  | Direct Materials |  |  |  |  |  |  | Direct Materials
 | Energy |  |  |  |  |  |  | Energy |  |  |  |  |  |  | Energy |  |  |  |  |  |  | Energy
 | Direct Labour |  |  |  |  |  |  | Direct Labour |  |  |  |  |  |  | Direct Labour |  |  |  |  |  |  | Direct Labour
 | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0
 | BFC - Other prime |  |  |  |  |  |  | BFC - Other prime |  |  |  |  |  |  | BFC - Other prime |  |  |  |  |  |  | BFC - Other prime
 | BFC - Overhead |  |  |  |  |  |  | BFC - Overhead |  |  |  |  |  |  | BFC - Overhead |  |  |  |  |  |  | BFC - Overhead
 | BFC - Depreciation |  |  |  |  |  |  | BFC - Depreciation |  |  |  |  |  |  | BFC - Depreciation |  |  |  |  |  |  | BFC - Depreciation
 | BFC - Operating Leases |  |  |  |  |  |  | BFC - Operating Leases |  |  |  |  |  |  | BFC - Operating Leases |  |  |  |  |  |  | BFC - Operating Leases
 | BFC - Others |  |  |  |  |  |  | BFC - Others |  |  |  |  |  |  | BFC - Others |  |  |  |  |  |  | BFC - Others
 | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0
 | Total Branch Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 0 | 0 | 0 | 0 | 0
 | Production Credit - Variable |  |  |  |  |  |  | Production Credit - Variable |  |  |  |  |  |  | Production Credit - Variable |  |  |  |  |  |  | Production Credit - Variable
 | Production Credit - Fixed |  |  |  |  |  |  | Production Credit - Fixed |  |  |  |  |  |  | Production Credit - Fixed |  |  |  |  |  |  | Production Credit - Fixed
 | 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 | 0 | 0 | 0 | 0 | 0 |  | Branch Performance | 0 | 0 | 0 | 0 | 0 |  | Branch Performance | 0 | 0 | 0 | 0 | 0 |  | Branch Performance | 0 | 0 | 0 | 0 | 0
 | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0
 | Branch | Branch2 | Total |  |  |  |  | Branch | Branch2 | 1133 |  |  |  |  | Branch | Branch2 | 1134
 | 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] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 | Sales to external Customers |  |  |  |  |  |  | Sales to external Customers |  |  |  |  |  |  | Sales to external Customers
 | IG Sales within Processing |  |  |  |  |  |  | IG Sales within Processing |  |  |  |  |  |  | IG Sales within Processing
 | Cost of Goods Sold - Variable |  |  |  |  |  |  | Cost of Goods Sold - Variable |  |  |  |  |  |  | Cost of Goods Sold - Variable
 | Cost of Goods Sold - Fixed |  |  |  |  |  |  | Cost of Goods Sold - Fixed |  |  |  |  |  |  | Cost of Goods Sold - Fixed
 | CERT Income |  |  |  |  |  |  | CERT Income |  |  |  |  |  |  | CERT Income
 | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Standard Margin from Sales | 0 | 0 | 0 | 0 | 0
 | Energy Surcharge Income |  |  |  |  |  |  | Energy Surcharge Income |  |  |  |  |  |  | Energy Surcharge Income
 | Energy Surcharge Cost |  |  |  |  |  |  | Energy Surcharge Cost |  |  |  |  |  |  | Energy Surcharge Cost
 | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0 |  | Energy Surcharge Margin | 0 | 0 | 0 | 0 | 0
 | CTS - Distribution |  |  |  |  |  |  | CTS - Distribution |  |  |  |  |  |  | CTS - Distribution
 | CTS - Other prime |  |  |  |  |  |  | CTS - Other prime |  |  |  |  |  |  | CTS - Other prime
 | CTS - Overhead |  |  |  |  |  |  | CTS - Overhead |  |  |  |  |  |  | CTS - Overhead
 | CTS - Bad debt prv mvt |  |  |  |  |  |  | CTS - Bad debt prv mvt |  |  |  |  |  |  | CTS - Bad debt prv mvt
 | Total Cost to Serve | 0 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 0 | 0 | 0 | 0 | 0 |  | Total Cost to Serve | 0 | 0 | 0 | 0 | 0
 | Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Margin from Sales | 0 | 0 | 0 | 0 | 0 |  | Margin from Sales | 0 | 0 | 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
 | m2 Produced |  |  |  |  |  |  | m2 Produced |  |  |  |  |  |  | m2 Produced
 | Direct Materials |  |  |  |  |  |  | Direct Materials |  |  |  |  |  |  | Direct Materials
 | Energy |  |  |  |  |  |  | Energy |  |  |  |  |  |  | Energy
 | Direct Labour |  |  |  |  |  |  | Direct Labour |  |  |  |  |  |  | Direct Labour
 | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0 |  | Variable Costs of Manufacture | 0 | 0 | 0 | 0 | 0
 | BFC - Other prime |  |  |  |  |  |  | BFC - Other prime |  |  |  |  |  |  | BFC - Other prime
 | BFC - Overhead |  |  |  |  |  |  | BFC - Overhead |  |  |  |  |  |  | BFC - Overhead
 | BFC - Depreciation |  |  |  |  |  |  | BFC - Depreciation |  |  |  |  |  |  | BFC - Depreciation
 | BFC - Operating Leases |  |  |  |  |  |  | BFC - Operating Leases |  |  |  |  |  |  | BFC - Operating Leases
 | BFC - Others |  |  |  |  |  |  | BFC - Others |  |  |  |  |  |  | BFC - Others
 | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Fixed Costs | 0 | 0 | 0 | 0 | 0
 | Total Branch Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 0 | 0 | 0 | 0 | 0 |  | Total Branch Costs | 0 | 0 | 0 | 0 | 0
 | Production Credit - Variable |  |  |  |  |  |  | Production Credit - Variable |  |  |  |  |  |  | Production Credit - Variable
 | Production Credit - Fixed |  |  |  |  |  |  | Production Credit - Fixed |  |  |  |  |  |  | Production Credit - Fixed
 | 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 | 0 | 0 | 0 | 0 | 0 |  | Branch Performance | 0 | 0 | 0 | 0 | 0 |  | Branch Performance | 0 | 0 | 0 | 0 | 0
 | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0 |  | Branch Profit / (Loss) | 0 | 0 | 0 | 0 | 0
 | More Branches will follow (15 in total and a total branch table)