Spreadsheet: 860691d1708696423-need-help-with-a-cost-report-function-cr2022
Sheet: Sunk Analysis

PO Number | Line item | PO Description | Vendor Code | Vendor | Spend to Jan | Spend from January |  | 2022-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | pos | [NAME]
6600520289 | 10 | Bromine Egg VR mock-up | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 11360 |  |  |  | Proces |  |  | Process
6600587265 | 10 | Scheme Design Transition | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Process |  |  | 0 |  |  |  | [NAME] |  |  | [NAME]
6600380718 | 10 | 4" Stainless Steel Gate Valves | 9910049063 | ESI PROCESS UK LTD |  |  |  |  |  | 5011 |  |  |  | Additional Sunk |  |  | Other
6600443197 | 10 | [NAME] | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  |  |  |  | 33537.86 |  |  |  |  |  |  | Piping
6600363173 | 10 | 1 x Camera System + Light | 9910085069 | VISILUME LTD |  |  |  |  |  | 2953 |  |  |  |  |  |  | Timebound
6600418613 | 10 | Bromine Tie-Ins | 9910210576 | Bilfinger UK Limited |  |  |  |  |  | 41223
6600730033 | 10 | Waste Ink Collector | 9910035688 | RICOH UK LTD |  |  |  |  |  | 0
3002232568 | 1 | CW50971, CW509076, CW509087 Process | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  |  |  |  | 103345
3002238420 | 1 | CW527963 - Process Engineer | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 106240
3002269976 | 1 | [NAME]. Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 29706.03
3002271439 | 1 | CW509060 Piping Engineering Support | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  |  |  |  | 49234
3002271453 | 1 | CW509064 - Mechanical Package Eng. | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | [NAME] |  |  | 35773.77999999999
6600106777 | 10 | BWA Document Control Services CW280825 | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 11492
6600317986 | 10 | CAD support for Bromine Project Tie-in P | 9910037087 | HGC CONSTRUCTORS PRIVATE LIMITED |  |  | Other |  |  | 0
6600327111 | 10 | Planning Resource – inc. [NAME] | 9910086080 | [NAME] (UK) LIMITED |  |  | Other |  |  | 19456
6600332973 | 10 | Document Controller Services Bromine | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 11492
6600372128 | 10 | CW911642 - Process Engineer | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Process |  |  | 85488.80999999998
6600372128 | 20 | CW911632 - Piping Engineer | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Piping |  |  | 22294.26
6600386297 | 10 | Bromine Isolator - Eng and Mock-up Phase | 9910024470 | HOWORTH AIR TECHNOLOGY LTD |  |  |  |  |  | 35700
6600406352 | 10 | Bromine Electrical Engineering Scheme De | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Other |  |  | 24865.5
6600406352 | 20 | Bromine Instrument Engineering Scheme De | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 27896.88
6600408260 | 10 | Project Controls Manager | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  |  |  |  | 53842.14
6600408273 | 10 | Procurement Specialist | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 55822.25
6600414025 | 10 | Daughting Services | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  |  |  |  | 1713
6600456529 | 10 | Document Control Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 8064
6600465466 | 10 | Planning Services CRW923047 Sept - Dec | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 44488.24000000001
6600465466 | 20 | Planning Services CRW924141 June - Dec | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 26383.5
6600470885 | 10 | Scheme Design Estimating Support | 9910035639 | GARDINER AND THEOBALD LLP |  |  | Other |  |  | 7375
6600529075 | 10 | CW509084 Rev 1 Project Engineer | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  |  |  |  | 23732
6600541460 | 10 | Bromine Process Design Works | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Process |  |  | 0
6600541460 | 20 | Bromine Piping Design Works | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Piping |  |  | 0
6600541460 | 30 | Bromine Mech Design Works | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | [NAME] |  |  | 0
6600541460 | 40 | Bromine Admin Design Works | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Timebound |  |  | 5957.76
6600547279 | 10 | Document Controller Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  |  |  |  | 3332
6600552799 | 10 | Procurement Specialist | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 0
6600552805 | 10 | Project Controls Manager | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 0
6600587266 | 10 | Validation Engineer Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600587266 | 20 | Construction Manager Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600595803 | 10 | Document Controller Services - 2 month o | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600600759 | 10 | B331 Detailed Design | 9910187315 | FAIRHURST |  |  | Other |  |  | 0
6600600910 | 10 | Bromine Scheme Design | 9910187315 | FAIRHURST |  |  | Other |  |  | 0
6600638069 | 10 | Construction Manager | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600702388 | 10 | HCl and Bromine Dispersion Report Update | 9910033895 | ABB LTD |  |  |  |  |  | 0
6600730030 | 10 | Process Engineer Resource Bromine | 9910085511 | DOOSAN BABCOCK ENERGY LTD |  |  | Timebound |  |  | 0
6600754617 | 10 | Validation Engineer Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600754617 | 20 | Construction Manager | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600754619 | 10 | Document Control Services | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Timebound |  |  | 0
6600208926 | 10 | B331 [NAME] | 9910085693 | ABB LTD |  |  |  |  |  | 7750
6600458857 | 10 | Process Engineer | 9910035797 | BOOTH WELSH AUTOMATION LTD |  |  | Process |  |  | 31573.2
6600639900 | 10 | Planning Specialist (CRW923047) | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 0
6600639900 | 20 | Planning Specialist (CRW924141) | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 0
6600639900 | 30 | Expenses | 9910035469 | FAITHFUL AND GOULD LIMITED |  |  | Timebound |  |  | 0
6600443198 | 10 | IT Services & Equipment | 9910085287 | MCEVOY ENGINEERING LTD |  |  |  |  |  | 11880
6600520474 | 10 | IT Equipment | 9910085287 | MCEVOY ENGINEERING LTD |  |  |  |  |  | 1537
6600500067 | 10 | P6 License and Database Charges | 9910086080 | [NAME] (UK) LIMITED |  |  |  |  |  | 6581.52
6600724902 | 10 | Dual Monitor 4K USB-C USB Docking Statio | 9910085287 | MCEVOY ENGINEERING LTD |  |  |  |  |  | 0
6600340878 | 10 | Cleaning Services | 9910085287 | MCEVOY ENGINEERING LTD |  |  |  |  |  | 7252
6600320973 | 10 | DELL PERFORMANCE DOCK WD19DC DOCKING STA | 9910033423 | CDW LIMITED |  |  |  |  |  | 250
6600323180 | 10 | Office Water Supply | 9910085254 | EDEN SPRINGS UK LTD |  |  | Other |  |  | 148.15
6600611089 | 10 | Cartridges | 9910035688 | RICOH UK LTD |  |  |  |  |  | 0
6600669579 | 10 | Cartridges | 9910035688 | RICOH UK LTD |  |  |  |  |  | 0
PO Number | Line item | PO Description | CBS for Cost Report | Name |  | Work Stream Description | Work Stream | Workstream Code | PO Date |  |  |  | Currency | Actuals
31001414 |  |  | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-01-21 00:00:00 |  |  |  | GBP | -5976
40000071 | mc232626 | UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-02-18 00:00:00 |  |  |  | GBP | 25200
40000071 | mc232626 | UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-02-18 00:00:00 |  |  |  | GBP | 2250
40000100 | 02.03 PROJECT CONTROLS | BWA for Process Engineer (PO [PHONE]) Feb-22 | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-02-28 00:00:00 |  |  |  | GBP | 1684.26
40000175 | mc232626 | UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-03-23 00:00:00 |  |  |  | GBP | 54450
40000210 | 03.05 Salb Redistribution | [NAME] | 90 | DandM |  | Sunk Costs | 94 | 90-94 | 2022-03-31 00:00:00 |  |  |  | GBP | 180218.44
PO Description | CBS for Cost Report | Name | Work Stream Description | Work Stream | Workstream Code | PO Date | Currency | Actuals
TRF Sunk Costs from A00099000 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2020-08-28 00:00:00 | GBP | 71262.45
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-07-22 00:00:00 | GBP | 35249.85
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-07-22 00:00:00 | GBP | 1800
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-08-23 00:00:00 | GBP | 25172
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-08-23 00:00:00 | GBP | 1800
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-09-23 00:00:00 | GBP | 48600
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-09-23 00:00:00 | GBP | 900
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-10-21 00:00:00 | GBP | 30600
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-10-21 00:00:00 | GBP | 900
BWA for Process Engineer (PO [PHONE]) Aug-21 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-10-29 00:00:00 | GBP | 1946.31
BWA for Process Engineer (PO [PHONE]) Sep-21 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-10-29 00:00:00 | GBP | 7119.06
BWA for Process Engineer (PO [PHONE]) Oct-21 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-10-29 00:00:00 | GBP | 6857.81
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-11-19 00:00:00 | GBP | 83295.12
UKMO - Salbutamol Refurb Programme - 90236 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-11-19 00:00:00 | GBP | 1800
BWA for Process Engineer (PO [PHONE]) Nov-21 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-11-30 00:00:00 | GBP | 6962.31
BWA for Process Engineer (PO [PHONE]) Dec-21 | 90 | DandM | Sunk Costs | 94 | 90-94 | 2021-12-28 00:00:00 | GBP | 8830.25