Spreadsheet: 184973d1349444382-vlookup-not-working-incorrect-return-lookup-error
Sheet: Lookup

 | KEY | GL Codes | Allocation
1 | 212011 Sales in Cnt to PPE* Total Sales | 212011  Sales in Cnt to PPE | Sales to external Customers
2 | 212018 Sales in Cnt to Proc* Total Sales | 212018  Sales in Cnt to Proc | IG Sales within Processing
3 | 212201 Sales in Cnty out BL* Total Sales | 212201  Sales in Cnty out BL | Sales to external Customers
4 | 212401 Sales out Cnt to PPE* Total Sales | 212401  Sales out Cnt to PPE | Sales to external Customers
5 | 212701 Sales other group* Total Sales | 212701  Sales other group | Sales to external Customers
6 | 212708 Energy [NAME] Total Sales | 212708  Energy Surcharge Int | Energy Surcharge Income
7 | 213011 External Sales* Total Sales | 213011  External Sales | Sales to external Customers
8 | 213519 Energy Surcharge Ext* Total Sales | 213519  Energy Surcharge Ext | Energy Surcharge Income
9 | 213544 Other Income - Revenue* Total Sales | 213544  Other Income - Revenue | Sales to external Customers
10 | * Total Sales* Total Sales | *        Total Sales | Ignore
11 | 612114 Finished Gds PC Revv* Inter Segmental Transfers | 612114  Finished Gds PC Revv | Production Credit
12 | * Inter Segmental Transfers* Inter Segmental Transfers | *        Inter Segmental Transfers | Ignore
13 | ** Gross Segmental Sales** Gross Segmental Sales | **       Gross Segmental Sales | Ignore
14 | 622114 Finished Gds PC Cost* Inter Segmental Purchases | 622114  Finished Gds PC Cost | Cost of Goods Sold
15 | * Inter Segmental Purchases* Inter Segmental Purchases | *        Inter Segmental Purchases | Ignore
16 | 220906 Bought in Glass PPE* Bought in Glass Costs - PPE sources | 220906  Bought in Glass PPE | Direct Materials
17 | 220902 B-I-G Downstream* Bought in Glass Costs - PPE sources | 220902  B-I-G Downstream | Direct Materials
18 | * Bought in Glass Costs - PPE sources* Bought in Glass Costs - PPE sources | *        Bought in Glass Costs - PPE sources | Ignore
19 | 220518 PPV Batch Materials* Other Materials | 220518  PPV Batch Materials | Direct Materials
20 | 220537 Fittings - Pilk Arch* Other Materials | 220537  Fittings - Pilk Arch | Direct Materials
21 | 220553 Other Direct Materials* Other Materials | 220553  Other Direct Materials | Direct Materials
22 | 220574 PPV other [NAME] Other Materials | 220574  PPV other [NAME] | Direct Materials
23 | 220578 Revaluation of Raw Materials* Other Materials | 220578  Revaluation of Raw Materials | Direct Materials
24 | 220597 PPV Finished Goods* Other Materials | 220597  PPV Finished Goods | Direct Materials
25 | 220817 Purchase [NAME] | 220817  Purchase Rebates Rec | CERT Income
26 | 221601 Stores Stock Diffs* Other Materials | 221601  Stores Stock Diffs | Direct Materials
27 | 222109 Engy [NAME]* Other Materials | 222109  Engy Srchrg Paid Int | Energy Surcharge Cost
28 | 222111 Engy Srchrg Paid Ext* Other Materials | 222111  Engy Srchrg Paid Ext | Energy Surcharge Cost
29 | 612124 Raw Material PC Revv* Other Materials | 612124  Raw Material PC Revv | Direct Materials
30 | 620609 Other Stk Change P C* Other Materials | 620609  Other Stk Change P C | Direct Materials
31 | 622121 Packing Mats PC Cst* Other Materials | 622121  Packing Mats PC Cst | Direct Materials
32 | 622124 Raw Material PC Cost* Other Materials | 622124  Raw Material PC Cost | Direct Materials
33 | 622127 Stores Matls PC Cost* Other Materials | 622127  Stores Matls PC Cost | Direct Materials
34 | * Other Materials* Other Materials | *        Other Materials | Ignore
35 | 220557 Semi Fin. Stk Issued* Prime Costs in Stock Movement | 220557  Semi Fin. Stk Issued | Direct Materials
36 | 220568 Finished Stock Loss* Prime Costs in Stock Movement | 220568  Finished Stock Loss | Direct Materials
37 | 220583 Finished Goods Cost of Sales* Prime Costs in Stock Movement | 220583  Finished Goods Cost of Sales | Direct Materials
38 | 220588 Fin Gds Revaluation* Prime Costs in Stock Movement | 220588  Fin Gds Revaluation | Direct Materials
39 | 620611 Glass Stk Change PC* Prime Costs in Stock Movement | 620611  [NAME] PC | Direct Materials
40 | * Prime Costs in Stock Movement* Prime Costs in Stock Movement | *        Prime Costs in Stock Movement | Ignore
41 | ** Total Direct Materials** Total Direct Materials | **       Total Direct Materials | Ignore
42 | 222511 Prime Wages/salaries* Production Prime Labour | 222511  Prime Wages/salaries | Direct Labour
43 | 222512 Prime Oth Emp. Costs* Production Prime Labour | 222512  Prime Oth Emp. Costs | Direct Labour
44 | 222513 Prime Overtime Costs* Production Prime Labour | 222513  Prime Overtime Costs | Direct Labour
45 | 222521 Prime Social Charges* Production Prime Labour | 222521  Prime Social Charges | Direct Labour
46 | 222531 Prime Health care* Production Prime Labour | 222531  Prime Health care | Direct Labour
47 | 222541 [NAME] pension* Production Prime Labour | 222541  [NAME] pension | Direct Labour
48 | 222551 Prm Defnd Bnft pens* Production Prime Labour | 222551  [NAME] pens | Direct Labour
49 | 222561 Prime Bonuses* Production Prime Labour | 222561  Prime Bonuses | Direct Labour
50 | 222571 Prme Temporary Staff* Production Prime Labour | 222571  Prme Temporary Staff | Direct Labour
51 | * Production Prime Labour* Production Prime [NAME] | *        Production Prime Labour | Ignore
52 | 222511 Prime Wages/salaries* Distribution Labour | 222511  Prime Wages/salaries | CTS - Distribution
53 | 222512 Prime Oth Emp. Costs* Distribution Labour | 222512  Prime Oth Emp. Costs | CTS - Distribution
54 | 222513 Prime Overtime Costs* Distribution Labour | 222513  Prime Overtime Costs | CTS - Distribution
55 | 222521 Prime Social Charges* Distribution Labour | 222521  Prime Social Charges | CTS - Distribution
56 | 222551 Prm Defnd Bnft pens* Distribution Labour | 222551  [NAME] pens | CTS - Distribution
57 | 222561 Prime Bonuses* Distribution Labour | 222561  Prime Bonuses | CTS - Distribution
58 | 222571 Prme Temporary Staff* Distribution Labour | 222571  Prme Temporary Staff | CTS - Distribution
59 | * Distribution Labour* Distribution Labour | *        Distribution Labour | Ignore
60 | 227015 Vehicle Hire* Vehicle Hire | 227015  [NAME] | CTS - Distribution
61 | * Vehicle Hire* Vehicle Hire | *        [NAME] | Ignore
62 | 224021 Carriage&Freight Hme* Freight Costs | 224021  Carriage&Freight Hme | CTS - Distribution
63 | 224024 Carriage&Freight Exp* Freight Costs | 224024  Carriage&Freight Exp | CTS - Distribution
64 | * Freight Costs* Freight Costs | *        Freight Costs | Ignore
65 | 224031 Fuel - Distribution* Other Distribution Costs | 224031  Fuel - Distribution | CTS - Distribution
66 | 224095 Prime Travel Expenses* Other Distribution Costs | 224095  Prime Travel Expenses | CTS - Distribution
67 | 224099 Other Distribution Costs* Other Distribution Costs | 224099  Other Distribution Costs | CTS - Distribution
68 | 223032 Maint. Distrib Equip* Other Distribution Costs | 223032  Maint. Distrib Equip | CTS - Distribution
69 | 226551 Transport Insurance* Other Distribution Costs | 226551  Transport Insurance | CTS - Distribution
70 | 223542 Logistics Services* Other Distribution Costs | 223542  Logistics Services | CTS - Distribution
71 | * Other Distribution Costs* Other Distribution Costs | *        Other Distribution Costs | Ignore
72 | ** Total Distribution Costs** Total Distribution Costs | **       Total Distribution Costs | Ignore
73 | 220111 Selling Agency Commission* Other Prime Costs | 220111  Selling Agency Commission | CTS - Other prime
74 | 220121 Discount allowed* Other Prime Costs | 220121  Discount allowed | CTS - Other prime
75 | 220131 Warranty Claims* Other Prime Costs | 220131  Warranty Claims | CTS - Other prime
76 | 220134 Green Card Discounts* Other Prime Costs | 220134  Green Card Discounts | CTS - Other prime
77 | 220539 Packing Materials* Other Prime Costs | 220539  Packing Materials | Direct Materials
78 | 220596 Prime Waste Disposal* Other Prime Costs | 220596  Prime Waste Disposal | BFC - Other prime
79 | 221011 External Processing* Other Prime Costs | 221011  External Processing | BFC - Other prime
80 | 221511 Factory Consumables* Other Prime Costs | 221511  Factory Consumables | BFC - Other prime
81 | 221544 Clothing Costs* Other Prime Costs | 221544  Clothing Costs | BFC - Other prime
82 | 222011 Electricity - prime* Other Prime Costs | 222011  Electricity - prime | Energy
83 | 222018 Gas - prime* Other Prime Costs | 222018  Gas - prime | Energy
84 | 222019 Prime Interruptible Gas* Other Prime Costs | 222019  Prime Interruptible Gas | Energy
85 | 222032 Other Fuel & power - prime* Other Prime Costs | 222032  Other Fuel & power - prime | Energy
86 | 222039 Prime Water* Other Prime Costs | 222039  Prime Water | Energy
87 | 226531 Credit Insurance* Other Prime Costs | 226531  Credit Insurance | CTS - Other prime
88 | 224011 Packages & Dist Eqmt* Other Prime Costs | 224011  Packages & Dist Eqmt | BFC - Other prime
89 | * Other Prime Costs* Other Prime Costs | *        Other Prime Costs | Ignore
90 | *** Total Prime Costs*** Total Prime Costs | ***      Total Prime Costs | Ignore
91 | **** Prime Margin**** Prime Margin | ****     Prime Margin | Ignore
92 | ***** Prime Margin / Gross Sales in %***** Prime Margin / Gross Sales in % | *****    Prime Margin / Gross Sales in % | Ignore
93 | 222516 Ohd Wages & salaries* Production Overhead Labour | 222516  Ohd Wages & salaries | BFC - Overhead
94 | 222518 O'hd Overtime Costs* Production Overhead Labour | 222518  O'hd Overtime Costs | BFC - Overhead
95 | 222526 Ovrhd Social Charges* Production Overhead Labour | 222526  Ovrhd Social Charges | BFC - Overhead
96 | 222536 Overhead Health Care* Production Overhead Labour | 222536  Overhead Health Care | BFC - Overhead
97 | 222546 Ohd Def Cnt pension* Production Overhead Labour | 222546  Ohd Def Cnt pension | BFC - Overhead
98 | 222556 [NAME] pens* Production Overhead Labour | 222556  [NAME] pens | BFC - Overhead
99 | 222566 Overhead Bonuses* Production Overhead Labour | 222566  Overhead Bonuses | BFC - Overhead
100 | 222576 Ovhd Temporary Staff* Production Overhead Labour | 222576  Ovhd Temporary Staff | BFC - Overhead
101 | 226686 Pension Administration* Production Overhead Labour | 226686  Pension Administration | BFC - Overhead
102 | * Production Overhead Labour* Production Overhead Labour | *        Production Overhead Labour | Ignore
103 | 222046 Electricity - overhead* P & M Other Overhead Costs | 222046  Electricity - overhead | BFC - Overhead
104 | 222053 Gas - overhead* P & M Other Overhead Costs | 222053  Gas - overhead | BFC - Overhead
105 | 222074 Overhead Water* P & M Other Overhead Costs | 222074  Overhead Water | BFC - Overhead
106 | 222595 Overhed Company Cars* P & M Other Overhead Costs | 222595  Overhed Company Cars | BFC - Overhead
107 | 226024 Services Recovered* P & M Other Overhead Costs | 226024  Services Recovered | BFC - Overhead
108 | 226511 Rates & Local Taxes* P & M Other Overhead Costs | 226511  Rates & Local Taxes | BFC - Overhead
109 | 226571 Buildings Insurance* P & M Other Overhead Costs | 226571  Buildings Insurance | BFC - Overhead
110 | 226583 Other insurance* P & M Other Overhead Costs | 226583  Other insurance | BFC - Overhead
111 | 226611 Purchase of Office Equipment* P & M Other Overhead Costs | 226611  Purchase of Office Equipment | BFC - Overhead
112 | 226631 Travel Expenses* P & M Other Overhead Costs | 226631  Travel Expenses | BFC - Overhead
113 | 226651 Disallowable Entertaining* P & M Other Overhead Costs | 226651  Disallowable Entertaining | BFC - Overhead
114 | 226654 Allowable Entertaining* P & M Other Overhead Costs | 226654  Allowable Entertaining | BFC - Overhead
115 | 226683 Health & Safety at Work* P & M Other Overhead Costs | 226683  Health & Safety at Work | BFC - Overhead
116 | 226691 Training* P & M Other Overhead Costs | 226691  Training | BFC - Overhead
117 | 226711 Comms Equipment* P & M Other Overhead Costs | 226711  Comms Equipment | BFC - Overhead
118 | 226714 Telephone Rental & Charges* P & M Other Overhead Costs | 226714  Telephone Rental & Charges | BFC - Overhead
119 | 226734 Courier Costs* P & M Other Overhead Costs | 226734  Courier Costs | BFC - Overhead
120 | 226751 Stationery* P & M Other Overhead Costs | 226751  Stationery | BFC - Overhead
121 | 226840 Ext Legal Fees Rev* P & M Other Overhead Costs | 226840  Ext Legal Fees Rev | BFC - Overhead
122 | 226857 Consultants (Other)* P & M Other Overhead Costs | 226857  Consultants (Other) | BFC - Overhead
123 | 226863 Other Professional Fees* P & M Other Overhead Costs | 226863  Other Professional Fees | BFC - Overhead
124 | 226871 IT Equipt purchase* P & M Other Overhead Costs | 226871  IT Equipt purchase | BFC - Overhead
125 | 226872 IT Software Purchase* P & M Other Overhead Costs | 226872  IT Software Purchase | BFC - Overhead
126 | 226934 Subs - Publications* P & M Other Overhead Costs | 226934  Subs - Publications | BFC - Overhead
127 | 226961 Canteen Costs* P & M Other Overhead Costs | 226961  Canteen Costs | BFC - Overhead
128 | 226977 Miscellaneous Expenses* P & M Other Overhead Costs | 226977  Miscellaneous Expenses | BFC - Overhead
129 | 226981 Waste Disposal* P & M Other Overhead Costs | 226981  Waste Disposal | BFC - Overhead
130 | * P & M Other Overhead Costs* P & M Other Overhead Costs | *        P & M Other Overhead Costs | Ignore
131 | 223013 Maint Mats N/S-Prem.** Production Other Overhead | 223013  Maint Mats N/S-Prem. | BFC - Overhead
132 | 223014 Maint Mats N/S-Plant** Production Other Overhead | 223014  Maint Mats N/S-Plant | BFC - Overhead
133 | 223021 Bought in Maint Prem** Production Other Overhead | 223021  Bought in Maint Prem | BFC - Overhead
134 | 223022 Bought in Maint P&M** Production Other Overhead | 223022  Bought in Maint P&M | BFC - Overhead
135 | 223031 Vehicle Maintenance - Cars** Production Other Overhead | 223031  Vehicle Maintenance - Cars | BFC - Overhead
136 | * SR Maintenance accounts only** Production Other Overhead | *        SR Maintenance accounts only | Ignore
137 | 223511 Quality Standards** Production Other Overhead | 223511  Quality Standards | BFC - Overhead
138 | 223546 Canteen** Production Other Overhead | 223546  Canteen | BFC - Overhead
139 | 223551 Security** Production Other Overhead | 223551  Security | BFC - Overhead
140 | 223561 Cleaning** Production Other Overhead | 223561  Cleaning | BFC - Overhead
141 | 223591 Other Services** Production Other Overhead | 223591  Other Services | BFC - Overhead
142 | 223596 Facilities Management** Production Other Overhead | 223596  Facilities Management | BFC - Overhead
143 | * SR Contracted Out Services** Production Other Overhead | *        SR Contracted Out Services | Ignore
144 | ** Production Other Overhead** Production Other Overhead | **       Production Other Overhead | Ignore
145 | *** Total Production Overhead*** Total Production Overhead | ***      Total Production Overhead | Ignore
146 | 222516 Ohd Wages & salaries* Site Overhead Labour | 222516  Ohd Wages & salaries | BFC - Overhead
147 | 222526 Ovrhd Social Charges* Site Overhead Labour | 222526  Ovrhd Social Charges | BFC - Overhead
148 | 222556 [NAME] pens* Site Overhead Labour | 222556  [NAME] pens | BFC - Overhead
149 | 226686 Pension Administration* Site Overhead Labour | 226686  Pension Administration | BFC - Overhead
150 | * Site Overhead Labour* Site Overhead Labour | *        Site Overhead Labour | Ignore
151 | 222046 Electricity - overhead* P & M Other Overhead Costs | 222046  Electricity - overhead | BFC - Overhead
152 | 222053 Gas - overhead* P & M Other Overhead Costs | 222053  Gas - overhead | BFC - Overhead
153 | 222074 Overhead Water* P & M Other Overhead Costs | 222074  Overhead Water | BFC - Overhead
154 | 222595 Overhed Company Cars* P & M Other Overhead Costs | 222595  Overhed Company Cars | BFC - Overhead
155 | 226024 Services Recovered* P & M Other Overhead Costs | 226024  Services Recovered | BFC - Overhead
156 | 226511 Rates & Local Taxes* P & M Other Overhead Costs | 226511  Rates & Local Taxes | BFC - Overhead
157 | 226571 Buildings Insurance* P & M Other Overhead Costs | 226571  Buildings Insurance | BFC - Overhead
158 | 226611 Purchase of Office Equipment* P & M Other Overhead Costs | 226611  Purchase of Office Equipment | BFC - Overhead
159 | 226631 Travel Expenses* P & M Other Overhead Costs | 226631  Travel Expenses | BFC - Overhead
160 | 226683 Health & Safety at Work* P & M Other Overhead Costs | 226683  Health & Safety at Work | BFC - Overhead
161 | 226691 Training* P & M Other Overhead Costs | 226691  Training | BFC - Overhead
162 | 226711 Comms Equipment* P & M Other Overhead Costs | 226711  Comms Equipment | BFC - Overhead
163 | 226714 Telephone Rental & Charges* P & M Other Overhead Costs | 226714  Telephone Rental & Charges | BFC - Overhead
164 | 226751 Stationery* P & M Other Overhead Costs | 226751  Stationery | BFC - Overhead
165 | 226774 Company Searches* P & M Other Overhead Costs | 226774  Company Searches | BFC - Overhead
166 | 226840 Ext Legal Fees Rev* P & M Other Overhead Costs | 226840  Ext Legal Fees Rev | BFC - Overhead
167 | 226857 Consultants (Other)* P & M Other Overhead Costs | 226857  Consultants (Other) | BFC - Overhead
168 | 226863 Other Professional Fees* P & M Other Overhead Costs | 226863  Other Professional Fees | BFC - Overhead
169 | 226934 Subs - Publications* P & M Other Overhead Costs | 226934  Subs - Publications | BFC - Overhead
170 | 226961 Canteen Costs* P & M Other Overhead Costs | 226961  Canteen Costs | BFC - Overhead
171 | 226977 Miscellaneous Expenses* P & M Other Overhead Costs | 226977  Miscellaneous Expenses | BFC - Overhead
172 | 226981 Waste Disposal* P & M Other Overhead Costs | 226981  Waste Disposal | BFC - Overhead
173 | 227006 Building Rents Paid* P & M Other Overhead Costs | 227006  Building Rents Paid | BFC - Operating Leases
174 | * P & M Other Overhead Costs* P & M Other Overhead Costs | *        P & M Other Overhead Costs | Ignore
175 | 223013 Maint Mats N/S-Prem.** Site Other Overheads | 223013  Maint Mats N/S-Prem. | BFC - Overhead
176 | 223014 Maint Mats N/S-Plant** Site Other Overheads | 223014  Maint Mats N/S-Plant | BFC - Overhead
177 | 223021 Bought in Maint Prem** Site Other Overheads | 223021  Bought in Maint Prem | BFC - Overhead
178 | 223022 Bought in Maint P&M** Site Other Overheads | 223022  Bought in Maint P&M | BFC - Overhead
179 | * SR Maintenance accounts only** Site Other Overheads | *        SR Maintenance accounts only | Ignore
180 | 223511 Quality Standards** Site Other Overheads | 223511  Quality Standards | BFC - Overhead
181 | 223551 Security** Site Other Overheads | 223551  Security | BFC - Overhead
182 | 223556 Gardening** Site Other Overheads | 223556  Gardening | BFC - Overhead
183 | 223561 Cleaning** Site Other Overheads | 223561  Cleaning | BFC - Overhead
184 | 223591 Other Services** Site Other Overheads | 223591  Other Services | BFC - Overhead
185 | 223596 Facilities Management** Site Other Overheads | 223596  Facilities Management | BFC - Overhead
186 | * SR Contracted Out Services** Site Other Overheads | *        SR Contracted Out Services | Ignore
187 | ** Site Other Overheads** Site Other Overheads | **       Site Other Overheads | Ignore
188 | *** Total Site Overheads*** Total Site Overheads | ***      Total Site Overheads | Ignore
189 | 222516 Ohd Wages & salaries* Sales Overhead Labour | 222516  Ohd Wages & salaries | CTS - Overhead
190 | 222517 Ohd Other Emp. Costs* Sales Overhead Labour | 222517  Ohd Other Emp. Costs | CTS - Overhead
191 | 222518 O'hd Overtime Costs* Sales Overhead Labour | 222518  O'hd Overtime Costs | CTS - Overhead
192 | 222526 Ovrhd Social Charges* Sales Overhead Labour | 222526  Ovrhd Social Charges | CTS - Overhead
193 | 222536 Overhead Health Care* Sales Overhead Labour | 222536  Overhead Health Care | CTS - Overhead
194 | 222546 Ohd Def Cnt pension* Sales Overhead Labour | 222546  Ohd Def Cnt pension | CTS - Overhead
195 | 222556 [NAME] pens* Sales Overhead Labour | 222556  [NAME] pens | CTS - Overhead
196 | 222566 Overhead Bonuses* Sales Overhead Labour | 222566  Overhead Bonuses | CTS - Overhead
197 | 222576 Ovhd Temporary Staff* Sales Overhead Labour | 222576  Ovhd Temporary Staff | CTS - Overhead
198 | 226686 Pension Administration* Sales Overhead Labour | 226686  Pension Administration | CTS - Overhead
199 | * Sales Overhead Labour* Sales Overhead Labour | *        Sales Overhead Labour | Ignore
200 | 222595 Overhed Company Cars* P & M Other Overhead Costs | 222595  Overhed Company Cars | CTS - Overhead
201 | 226024 Services Recovered* P & M Other Overhead Costs | 226024  Services Recovered | CTS - Overhead
202 | 226583 Other insurance* P & M Other Overhead Costs | 226583  Other insurance | CTS - Overhead
203 | 226591 Marketing* P & M Other Overhead Costs | 226591  Marketing | CTS - Overhead
204 | 226594 Advertising & Promotions* P & M Other Overhead Costs | 226594  Advertising & Promotions | CTS - Overhead
205 | 226603 Gifts Allowable* P & M Other Overhead Costs | 226603  Gifts Allowable | CTS - Overhead
206 | 226607 Samples to Customers* P & M Other Overhead Costs | 226607  Samples to Customers | CTS - Overhead
207 | 226631 Travel Expenses* P & M Other Overhead Costs | 226631  Travel Expenses | CTS - Overhead
208 | 226651 Disallowable Entertaining* P & M Other Overhead Costs | 226651  Disallowable Entertaining | CTS - Overhead
209 | 226654 Allowable Entertaining* P & M Other Overhead Costs | 226654  Allowable Entertaining | CTS - Overhead
210 | 226683 Health & Safety at Work* P & M Other Overhead Costs | 226683  Health & Safety at Work | CTS - Overhead
211 | 226691 Training* P & M Other Overhead Costs | 226691  Training | CTS - Overhead
212 | 226711 Comms Equipment* P & M Other Overhead Costs | 226711  Comms Equipment | CTS - Overhead
213 | 226714 Telephone Rental & Charges* P & M Other Overhead Costs | 226714  Telephone Rental & Charges | CTS - Overhead
214 | 226721 Broadband Communications* P & M Other Overhead Costs | 226721  Broadband Communications | CTS - Overhead
215 | 226731 Postage* P & M Other Overhead Costs | 226731  Postage | CTS - Overhead
216 | 226734 Courier Costs* P & M Other Overhead Costs | 226734  Courier Costs | CTS - Overhead
217 | 226751 Stationery* P & M Other Overhead Costs | 226751  Stationery | CTS - Overhead
218 | 226857 Consultants (Other)* P & M Other Overhead Costs | 226857  Consultants (Other) | CTS - Overhead
219 | 226871 IT Equipt purchase* P & M Other Overhead Costs | 226871  IT Equipt purchase | CTS - Overhead
220 | 226934 Subs - Publications* P & M Other Overhead Costs | 226934  Subs - Publications | CTS - Overhead
221 | 226977 Miscellaneous Expenses* P & M Other Overhead Costs | 226977  Miscellaneous Expenses | CTS - Overhead
222 | * P & M Other Overhead Costs* P & M Other Overhead Costs | *        P & M Other Overhead Costs | Ignore
223 | 223031 Vehicle Maintenance - Cars** Sales Others | 223031  Vehicle Maintenance - Cars | CTS - Overhead
224 | * SR Maintenance accounts only** Sales Others | *        SR Maintenance accounts only | Ignore
225 | 223521 EDP Services** Sales Others | 223521  EDP Services | CTS - Overhead
226 | * SR Contracted Out Services** Sales Others | *        SR Contracted Out Services | Ignore
227 | ** Sales Others** Sales Others | **       Sales Others | Ignore
228 | *** Total Sales Overhead*** Total Sales Overhead | ***      Total Sales Overhead | Ignore
229 | 222516 Ohd Wages & salaries* Administration Overhead Labour | 222516  Ohd Wages & salaries | BFC - Overhead
230 | 222517 Ohd Other Emp. Costs* Administration Overhead Labour | 222517  Ohd Other Emp. Costs | BFC - Overhead
231 | 222518 O'hd Overtime Costs* Administration Overhead Labour | 222518  O'hd Overtime Costs | BFC - Overhead
232 | 222526 Ovrhd Social Charges* Administration Overhead Labour | 222526  Ovrhd Social Charges | BFC - Overhead
233 | 222536 Overhead Health Care* Administration Overhead Labour | 222536  Overhead Health Care | BFC - Overhead
234 | 222546 Ohd Def Cnt pension* Administration Overhead Labour | 222546  Ohd Def Cnt pension | BFC - Overhead
235 | 222556 [NAME] pens* Administration Overhead Labour | 222556  [NAME] pens | BFC - Overhead
236 | 222557 DB Ovhd Exec Pension* Administration Overhead Labour | 222557  DB Ovhd Exec Pension | BFC - Overhead
237 | 222566 Overhead Bonuses* Administration Overhead Labour | 222566  Overhead Bonuses | BFC - Overhead
238 | 222576 Ovhd Temporary Staff* Administration Overhead Labour | 222576  Ovhd Temporary Staff | BFC - Overhead
239 | 226686 Pension Administration* Administration Overhead Labour | 226686  Pension Administration | BFC - Overhead
240 | * Administration Overhead Labour* Administration Overhead Labour | *        Administration Overhead Labour | Ignore
241 | 222595 Overhed Company Cars* P & M Other Overhead Costs | 222595  Overhed Company Cars | BFC - Overhead
242 | 226024 Services Recovered* P & M Other Overhead Costs | 226024  Services Recovered | BFC - Overhead
243 | 226026 [NAME] lgl ent* P & M Other Overhead Costs | 226026  [NAME] lgl ent | BFC - Overhead
244 | 226511 Rates & Local Taxes* P & M Other Overhead Costs | 226511  Rates & Local Taxes | BFC - Overhead
245 | 226577 Emp Liability ins* P & M Other Overhead Costs | 226577  Emp Liability ins | BFC - Overhead
246 | 226583 Other insurance* P & M Other Overhead Costs | 226583  Other insurance | BFC - Overhead
247 | 226594 Advertising & Promotions* P & M Other Overhead Costs | 226594  Advertising & Promotions | BFC - Overhead
248 | 226597 Donations Allowable* P & M Other Overhead Costs | 226597  Donations Allowable | BFC - Overhead
249 | 226603 Gifts Allowable* P & M Other Overhead Costs | 226603  Gifts Allowable | BFC - Overhead
250 | 226606 Gifts Disallowable* P & M Other Overhead Costs | 226606  Gifts Disallowable | BFC - Overhead
251 | 226611 Purchase of Office Equipment* P & M Other Overhead Costs | 226611  Purchase of Office Equipment | BFC - Overhead
252 | 226617 Office Consumables* P & M Other Overhead Costs | 226617  Office Consumables | BFC - Overhead
253 | 226631 Travel Expenses* P & M Other Overhead Costs | 226631  Travel Expenses | BFC - Overhead
254 | 226651 Disallowable Entertaining* P & M Other Overhead Costs | 226651  Disallowable Entertaining | BFC - Overhead
255 | 226654 Allowable Entertaining* P & M Other Overhead Costs | 226654  Allowable Entertaining | BFC - Overhead
256 | 226671 Working Lunches* P & M Other Overhead Costs | 226671  Working Lunches | BFC - Overhead
257 | 226674 Recruitment Costs* P & M Other Overhead Costs | 226674  Recruitment Costs | BFC - Overhead
258 | 226677 Relocation of Employees* P & M Other Overhead Costs | 226677  Relocation of Employees | BFC - Overhead
259 | 226680 Personnel Expenses* P & M Other Overhead Costs | 226680  Personnel Expenses | BFC - Overhead
260 | 226683 Health & Safety at Work* P & M Other Overhead Costs | 226683  Health & Safety at Work | BFC - Overhead
261 | 226691 Training* P & M Other Overhead Costs | 226691  Training | BFC - Overhead
262 | 226711 Comms Equipment* P & M Other Overhead Costs | 226711  Comms Equipment | BFC - Overhead
263 | 226714 Telephone Rental & Charges* P & M Other Overhead Costs | 226714  Telephone Rental & Charges | BFC - Overhead
264 | 226717 Facsimile Rental & Charges* P & M Other Overhead Costs | 226717  Facsimile Rental & Charges | BFC - Overhead
265 | 226721 Broadband Communications* P & M Other Overhead Costs | 226721  Broadband Communications | BFC - Overhead
266 | 226731 Postage* P & M Other Overhead Costs | 226731  Postage | BFC - Overhead
267 | 226734 Courier Costs* P & M Other Overhead Costs | 226734  Courier Costs | BFC - Overhead
268 | 226751 Stationery* P & M Other Overhead Costs | 226751  Stationery | BFC - Overhead
269 | 226771 Duplicating* P & M Other Overhead Costs | 226771  Duplicating | BFC - Overhead
270 | 226774 Company Searches* P & M Other Overhead Costs | 226774  Company Searches | BFC - Overhead
271 | 226777 Purchased Office Services* P & M Other Overhead Costs | 226777  Purchased Office Services | BFC - Overhead
272 | 226791 External Audit Fees* P & M Other Overhead Costs | 226791  External Audit Fees | BFC - Overhead
273 | 226840 Ext Legal Fees Rev* P & M Other Overhead Costs | 226840  Ext Legal Fees Rev | BFC - Overhead
274 | 226857 Consultants (Other)* P & M Other Overhead Costs | 226857  Consultants (Other) | BFC - Overhead
275 | 226863 Other Professional Fees* P & M Other Overhead Costs | 226863  Other Professional Fees | BFC - Overhead
276 | 226871 IT Equipt purchase* P & M Other Overhead Costs | 226871  IT Equipt purchase | BFC - Overhead
277 | 226872 IT Software Purchase* P & M Other Overhead Costs | 226872  IT Software Purchase | BFC - Overhead
278 | 226911 Bank Charges* P & M Other Overhead Costs | 226911  Bank Charges | BFC - Overhead
279 | 226931 Subs - Affiliations* P & M Other Overhead Costs | 226931  Subs - Affiliations | BFC - Overhead
280 | 226934 Subs - Publications* P & M Other Overhead Costs | 226934  Subs - Publications | BFC - Overhead
281 | 226937 Discounts Not Taken* P & M Other Overhead Costs | 226937  Discounts Not Taken | BFC - Overhead
282 | 226961 Canteen Costs* P & M Other Overhead Costs | 226961  Canteen Costs | BFC - Overhead
283 | 226967 Demurrage Costs* P & M Other Overhead Costs | 226967  Demurrage Costs | BFC - Overhead
284 | 226977 Miscellaneous Expenses* P & M Other Overhead Costs | 226977  Miscellaneous Expenses | BFC - Overhead
285 | 226981 Waste Disposal* P & M Other Overhead Costs | 226981  Waste Disposal | BFC - Overhead
286 | 227006 Building Rents Paid* P & M Other Overhead Costs | 227006  Building Rents Paid | BFC - Operating Leases
287 | * P & M Other Overhead Costs* P & M Other Overhead Costs | *        P & M Other Overhead Costs | Ignore
288 | 223012 Maint Mats-Stk Plant** Administration Other Overheads | 223012  Maint Mats-Stk Plant | BFC - Overhead
289 | 223013 Maint Mats N/S-Prem.** Administration Other Overheads | 223013  Maint Mats N/S-Prem. | BFC - Overhead
290 | 223014 Maint Mats N/S-Plant** Administration Other Overheads | 223014  Maint Mats N/S-Plant | BFC - Overhead
291 | 223021 Bought in Maint Prem** Administration Other Overheads | 223021  Bought in Maint Prem | BFC - Overhead
292 | 223022 Bought in Maint P&M** Administration Other Overheads | 223022  Bought in Maint P&M | BFC - Overhead
293 | 223031 Vehicle Maintenance - Cars** Administration Other Overheads | 223031  Vehicle Maintenance - Cars | BFC - Overhead
294 | * SR Maintenance accounts only** Administration Other Overheads | *        SR Maintenance accounts only | Ignore
295 | 223546 Canteen** Administration Other Overheads | 223546  Canteen | BFC - Overhead
296 | 223551 Security** Administration Other Overheads | 223551  Security | BFC - Overhead
297 | 223561 Cleaning** Administration Other Overheads | 223561  Cleaning | BFC - Overhead
298 | 223571 Other Office Services** Administration Other Overheads | 223571  Other Office Services | BFC - Overhead
299 | 223591 Other Services** Administration Other Overheads | 223591  Other Services | BFC - Overhead
300 | 223596 Facilities Management** Administration Other Overheads | 223596  Facilities Management | BFC - Overhead
301 | * SR Contracted Out Services** Administration Other Overheads | *        SR Contracted Out Services | Ignore
302 | ** Administration Other Overheads** Administration Other Overheads | **       Administration Other Overheads | Ignore
303 | *** Total Administration Overhead*** Total Administration Overhead | ***      Total Administration Overhead | Ignore
304 | 222516 Ohd Wages & salaries** P & M Overhead Labour | 222516  Ohd Wages & salaries | BFC - Overhead
305 | 222518 O'hd Overtime Costs** P & M Overhead Labour | 222518  O'hd Overtime Costs | BFC - Overhead
306 | 222526 Ovrhd Social Charges** P & M Overhead Labour | 222526  Ovrhd Social Charges | BFC - Overhead
307 | 222536 Overhead Health Care** P & M Overhead Labour | 222536  Overhead Health Care | BFC - Overhead
308 | 222556 [NAME] pens** P & M Overhead Labour | 222556  [NAME] pens | BFC - Overhead
309 | 222566 Overhead Bonuses** P & M Overhead Labour | 222566  Overhead Bonuses | BFC - Overhead
310 | 222576 Ovhd Temporary Staff** P & M Overhead Labour | 222576  Ovhd Temporary Staff | BFC - Overhead
311 | 226686 Pension Administration** P & M Overhead Labour | 226686  Pension Administration | BFC - Overhead
312 | ** P & M Overhead Labour** P & M Overhead Labour | **       P & M Overhead Labour | Ignore
313 | 222046 Electricity - overhead* P & M Other Overhead Costs | 222046  Electricity - overhead | BFC - Overhead
314 | 222053 Gas - overhead* P & M Other Overhead Costs | 222053  Gas - overhead | BFC - Overhead
315 | 222074 Overhead Water* P & M Other Overhead Costs | 222074  Overhead Water | BFC - Overhead
316 | 222595 Overhed Company Cars* P & M Other Overhead Costs | 222595  Overhed Company Cars | BFC - Overhead
317 | 226511 Rates & Local Taxes* P & M Other Overhead Costs | 226511  Rates & Local Taxes | BFC - Overhead
318 | 226571 Buildings Insurance* P & M Other Overhead Costs | 226571  Buildings Insurance | BFC - Overhead
319 | 226591 Marketing* P & M Other Overhead Costs | 226591  Marketing | BFC - Overhead
320 | 226607 Samples to Customers* P & M Other Overhead Costs | 226607  Samples to Customers | BFC - Overhead
321 | 226611 Purchase of Office Equipment* P & M Other Overhead Costs | 226611  Purchase of Office Equipment | BFC - Overhead
322 | 226631 Travel Expenses* P & M Other Overhead Costs | 226631  Travel Expenses | BFC - Overhead
323 | 226683 Health & Safety at Work* P & M Other Overhead Costs | 226683  Health & Safety at Work | BFC - Overhead
324 | 226691 Training* P & M Other Overhead Costs | 226691  Training | BFC - Overhead
325 | 226711 Comms Equipment* P & M Other Overhead Costs | 226711  Comms Equipment | BFC - Overhead
326 | 226714 Telephone Rental & Charges* P & M Other Overhead Costs | 226714  Telephone Rental & Charges | BFC - Overhead
327 | 226731 Postage* P & M Other Overhead Costs | 226731  Postage | BFC - Overhead
328 | 226734 Courier Costs* P & M Other Overhead Costs | 226734  Courier Costs | BFC - Overhead
329 | 226751 Stationery* P & M Other Overhead Costs | 226751  Stationery | BFC - Overhead
330 | 226774 Company Searches* P & M Other Overhead Costs | 226774  Company Searches | BFC - Overhead
331 | 226840 Ext Legal Fees Rev* P & M Other Overhead Costs | 226840  Ext Legal Fees Rev | BFC - Overhead
332 | 226863 Other Professional Fees* P & M Other Overhead Costs | 226863  Other Professional Fees | BFC - Overhead
333 | 226871 IT Equipt purchase* P & M Other Overhead Costs | 226871  IT Equipt purchase | BFC - Overhead
334 | 226934 Subs - Publications* P & M Other Overhead Costs | 226934  Subs - Publications | BFC - Overhead
335 | 226961 Canteen Costs* P & M Other Overhead Costs | 226961  Canteen Costs | BFC - Overhead
336 | 226971 Water Extraction Costs* P & M Other Overhead Costs | 226971  Water Extraction Costs | BFC - Overhead
337 | 226977 Miscellaneous Expenses* P & M Other Overhead Costs | 226977  Miscellaneous Expenses | BFC - Overhead
338 | 226981 Waste Disposal* P & M Other Overhead Costs | 226981  Waste Disposal | BFC - Overhead
339 | 227006 Building Rents Paid* P & M Other Overhead Costs | 227006  Building Rents Paid | BFC - Overhead
340 | * P & M Other Overhead Costs* P & M Other Overhead Costs | *        P & M Other Overhead Costs | Ignore
341 | 223013 Maint Mats N/S-Prem.** P & M Other Overheads - Branch Repor | 223013  Maint Mats N/S-Prem. | BFC - Overhead
342 | 223014 Maint Mats N/S-Plant** P & M Other Overheads - Branch Repor | 223014  Maint Mats N/S-Plant | BFC - Overhead
343 | 223021 Bought in Maint Prem** P & M Other Overheads - Branch Repor | 223021  Bought in Maint Prem | BFC - Overhead
344 | 223022 Bought in Maint P&M** P & M Other Overheads - Branch Repor | 223022  Bought in Maint P&M | BFC - Overhead
345 | 223031 Vehicle Maintenance - Cars** P & M Other Overheads - Branch Repor | 223031  Vehicle Maintenance - Cars | BFC - Overhead
346 | * SR Maintenance accounts only** P & M Other Overheads - Branch Repor | *        SR Maintenance accounts only | Ignore
347 | 223511 Quality Standards** P & M Other Overheads - Branch Repor | 223511  Quality Standards | BFC - Overhead
348 | 223551 Security** P & M Other Overheads - Branch Repor | 223551  Security | BFC - Overhead
349 | 223561 Cleaning** P & M Other Overheads - Branch Repor | 223561  Cleaning | BFC - Overhead
350 | * SR Contracted Out Services** P & M Other Overheads - Branch Repor | *        SR Contracted Out Services | Ignore
351 | ** P & M Other Overheads - Branch Repor** P & M Other Overheads - Branch Repor | **       P & M Other Overheads - Branch Repor | Ignore
352 | *** Overheads posted to Prime Cost Centres*** Overheads posted to Prime Cost Centres | ***      Overheads posted to Prime Cost Centres | Ignore
353 | **** Subtotal Overheads**** Subtotal Overheads | ****     Subtotal Overheads | Ignore
354 | 227046 Fixed Costs Stk Mvnt* Stock Movements | 227046  Fixed Costs Stk Mvnt | BFC - Overhead
355 | * Stock Movements* Stock Movements | *        Stock Movements | Ignore
356 | ***** Total Overheads***** Total Overheads | *****    Total Overheads | Ignore
357 | 224511 Depn Land/Buildings* Depreciation | 224511  Depn Land/Buildings | BFC - Depreciation
358 | 224521 Depn Plant & Machnry* Depreciation | 224521  Depn Plant & Machnry | BFC - Depreciation
359 | 224524 [NAME]* Depreciation | 224524  [NAME] | BFC - Depreciation
360 | 224541 Depn Patents & licns* Depreciation | 224541  Depn Patents & licns | BFC - Depreciation
361 | * Depreciation* Depreciation | *        Depreciation | Ignore
362 | 227018 Hire of Office Equipment* Operating Lease Costs (exc Vehicles) | 227018  Hire of Office Equipment | BFC - Operating Leases
363 | 227011 Hire of Plant & Machinery* Operating Lease Costs (exc Vehicles) | 227011  Hire of Plant & Machinery | BFC - Operating Leases
364 | * Operating Lease Costs (exc Vehicles)* Operating Lease Costs (exc Vehicles) | *        Operating Lease Costs (exc Vehicles) | Ignore
365 | 226022 Other Income (Cst C)* Other Items | 226022  Other Income (Cst C) | BFC - Others
366 | 227033 Technical Fees* Other Items | 227033  Technical Fees | BFC - Others
367 | 227034 Other Licensing Fees Paid* Other Items | 227034  Other Licensing Fees Paid | BFC - Others
368 | 227042 Loss on Disposals* Other Items | 227042  Loss on Disposals | BFC - Others
369 | 227076 Bad Debts* Other Items | 227076  Bad Debts | BFC - Others
370 | 227077 Bad Debt Write Back* Other Items | 227077  Bad Debt Write Back | BFC - Others
371 | 227081 Exchange Gains* Other Items | 227081  Exchange Gains | BFC - Others
372 | 227083 FX Exchange Gains MM* Other Items | 227083  FX Exchange Gains MM | BFC - Others
373 | 227084 Exchange Losses* Other Items | 227084  Exchange Losses | BFC - Others
374 | 227089 Exchange Commissions* Other Items | 227089  Exchange Commissions | BFC - Others
375 | 227111 B/S Analysis B/F* Other Items | 227111  B/S Analysis B/F | BFC - Others
376 | 227112 B/S Analysis Invoice* Other Items | 227112  B/S Analysis Invoice | BFC - Others
377 | 227113 B/S Analysis P&L* Other Items | 227113  B/S Analysis P&L | BFC - Others
378 | 227114 B/S Analysis Settle* Other Items | 227114  B/S Analysis Settle | BFC - Others
379 | 227121 Purchases Capital* Other Items | 227121  Purchases Capital | BFC - Others
380 | * Other Items* Other Items | *        Other Items | Ignore
381 | ****** Operating Profit before Redundancy****** Operating Profit before Redundancy | ******   Operating Profit before Redundancy | Ignore
382 | 227036 Redundancy & PFMU* Redundancy | 227036  Redundancy & PFMU | Ignore
383 | * Redundancy* Redundancy | *        Redundancy | Ignore
384 | ******* Operating Profit after Redundancy******* Operating Profit after Redundancy | *******  Operating Profit after Redundancy | Ignore
385 | 231574 Pilkington Technical Fees* S.C.A.A Charges / Technical Fees | 231574  Pilkington Technical Fees | Ignore
386 | * S.C.A.A Charges / Technical Fees* S.C.A.A Charges / Technical Fees | *        S.C.A.A Charges / Technical Fees | Ignore
387 | ******** Operating Profit after Exceptional******** Operating Profit after Exceptional | ******** Operating Profit after Exceptional | Ignore
388 | *** Direct Materials as % of Sales*** Direct Materials as % of Sales | ***      Direct Materials as % of Sales | Ignore
389 | ** Direct Labour as % of Sales** Direct Labour as % of Sales | **       Direct Labour as % of Sales | Ignore
390 | ***** Overhead as % of Sales***** Overhead as % of Sales | *****    Overhead as % of Sales | Ignore
391 | ******* Operating Profit as % of Sales******* Operating Profit as % of Sales | *******  Operating Profit as % of Sales | Ignore
392 | ***** Gross Margin as % of Sales***** Gross Margin as % of Sales | *****    Gross Margin as % of Sales | Ignore
393 | *** Total Distribution Costs as % of Sales*** Total Distribution Costs as % of Sales | ***      Total Distribution Costs as % of Sales | Ignore
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431