Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: 1 of O2 Transport

 |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted# |  |  | Actual |  |  |  | Price [NAME] |  | Grade | AUS Rate | Australian Price | Adjusted Aus Price
 | Labour | Grade |  |  |  |  |  |  |  |  |  | Cost | Personnel | Days | Hr/Day | Personnel | Days | Hr/Day
 | Based on proposal timescale of 16 weeks (+4 for overrun) x 5 days = 100 |  |  |  |  |  |  |  |  |  |  |  | 1 | 65 | 7.4 | 1 | 50 | 7.4 |  |  |  | Project Manager | 62.89
 | Based on proposal timescale of 14 weeks (not involved for painting) (+2 for overrun) x 5 days = 80 |  |  |  |  |  |  |  |  |  |  |  | 1 | 55 | 7.4 | 1 | 40 | 7.4 |  |  |  | Engineer | 57.34
 | For general design advise etc. |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 7.4 | 1 | 2 | 7.4 |  |  |  | Senior Engineer | 62.85
 | QA   - General |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 7.4 | 1 | 5 | 7.4 |  |  |  | QA Manager | 62.89
 | Assembly |  |  |  |  |  |  |  |  |  |  |  | 2 | 10 | 7.4 | 2 | 10 | 7.4 |  |  |  | Engineer | 57.34
 | QA  - Test procedures |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 7.4 | 1 | 2 | 7.4 |  |  |  | QA Manager | 62.89
 | Design Review Test Procedures (included in above allowances)
 | Workshop  prepare  for test, including manufacture  of load test blanks |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 7.4 | 2 | 3 | 7.4 |  |  |  | Engineer | 57.34
 | Workshop conduct test |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 7.4 | 2 | 3 | 7.4 |  |  |  | Senior Engineer | 62.85
 | QA - Test Witness |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 7.4 | 1 | 3 | 7.4 |  |  |  | QA Manager | 62.89
 | Workshop Pack and Dispatch |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 7.4 | 1 | 1 | 7.4 |  |  |  | Mechanical Tech | 57.34
 | QA  - Manuals |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 7.4 | 1 | 5 | 7.4 |  |  |  | QA Manager | 62.89
 | Travel and Subsistence | Basis |  |  |  |  |  |  |  |  |  |  | Adjusted Cost |  |  |  |  |  |  |  |  | [NAME] | Ajusted Markup
 | Materials and Subcontract | Basis | Price Source |  |  |  |  |  |  |  |  | Quantity | Single Unit Cost | Cost | Adjusted Cost |  |  |  |  |  |  | [NAME]
 | Oxyegn Transport Frame Fabrication -  including NDT |  | Written fixed quote |  |  |  |  |  |  |  |  | 1 | 8260.4
 | Primary Structure (Main Frame)
 | Steel Structure |  |  |  |  |  |  |  |  |  |  | 1
 | Secondary Structure  (Between 2 storage halves)
 | Centre Beam |  |  |  |  |  |  |  |  |  |  | 2
 | Secondary Frame Half Assmebly |  |  |  |  |  |  |  |  |  |  | 2
 | Support Beam,  T-Section 100 x 100 x 6mm THK  , 990 Length |  |  |  |  |  |  |  |  |  |  | 2
 | Secondary Frame Half Assembly (Bottle storage frames)
 | Main  farbicated framework
 | M6 HEX NUT |  | Online Quote |  |  |  |  |  |  |  |  | 160 | 0.04
 | M6 WING NUT |  | Online Quote |  |  |  |  |  |  |  |  | 160 | 0.2
 | [NAME]55 HEX HEAD BOLT |  | Online Quote |  |  |  |  |  |  |  |  | 160 | 0.24
 | M6  X  24CIRCLIP PIN |  | Online Quote |  |  |  |  |  |  |  |  | 160 | 0.5
 | [NAME] |  | Online Quote |  |  |  |  |  |  |  |  | 160 | 0.07
 | [NAME] 01 - Plate 711 X 10 X 5MM THK |  | Estimated |  |  |  |  |  |  |  |  | 160 | 10
 | [NAME] 02 - Plate 711 X 10 X 5MM THK |  | Estimated |  |  |  |  |  |  |  |  | 160 | 10
 | [NAME] |  | Estimated |  |  |  |  |  |  |  |  | 80 | 40
 | [NAME] at Ends - 4 off
 | Steel   Profile |  |  |  |  |  |  |  |  |  |  | 4
 | Vent Cover |  | Online Quote |  |  |  |  |  |  |  |  | 8 | 22.8
 | Barrel  Lock  and Retainer |  | Online Quote |  |  |  |  |  |  |  |  | 8 | 4.4
 | 8 off Padlocks - RS Stock No.788-7949 |  | Online Quote |  |  |  |  |  |  |  |  | 8 | 12.8
 | Lift off hinges |  | Online Quote |  |  |  |  |  |  |  |  | 12 | 5.97
 | 8 off Recessed Pull Handle Black Finish - Wixroyd  79500.W0100-4 |  | Online Quote |  |  |  |  |  |  |  |  | 8 | 14.17
 | Vent  covers |  | Online Quote |  |  |  |  |  |  |  |  | 4 | 22.8
 | [NAME] screws |  | Online Quote |  |  |  |  |  |  |  |  | 32 | 0.22
 | M6 Captive nuts |  | Online Quote |  |  |  |  |  |  |  |  | 32 | 0.12
 | Side Weather  Panels  - 4 off
 | Steel   Profile |  |  |  |  |  |  |  |  |  |  | 4
 | Vent Cover |  | Online Quote |  |  |  |  |  |  |  |  | 8 | 22.8
 | [NAME] screws |  | Online Quote |  |  |  |  |  |  |  |  |  | 0.22
 | M6 Captive nuts |  | Online Quote |  |  |  |  |  |  |  |  |  | 0.12
 | A4 Document Holder |  | Online Quote |  |  |  |  |  |  |  |  | 2 | 42
 | Hot Dip Galvanising |  | Written fixed quote |  |  |  |  |  |  |  |  | 1 | 1120
 | Load test - Speedy / Scot-Test (Emailed 30.05.2014) |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 1567
 | [NAME] NDT - Scot-Test (post  load test) (Emailed 30.05.2014) |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 460
 | O2 Storage Frame Lettering |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 1183.52
 | Optional Painting - Surface Technology |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 4383.42
 | [NAME] etc - McLean Buchanan & Wilson   (Emailed 30.05.2014) |  | Derived from previous quote |  |  |  |  |  |  |  |  | 1 | 500
 | Engraved Plates - Alexander Pollock |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 132.5
 | Safety Stickers - Cargo Labels Ltd |  | Online Quote |  |  |  |  |  |  |  |  | 1 | 2.2
 | [NAME] (used to be [NAME]) |  | Previous quote adjusted |  |  |  |  |  |  |  |  | 1 | 200
 | Shipping Crate |  | Written fixed quote |  |  |  |  |  |  |  |  | 1 | 4441.37
 | Estimate of delivery cost to Henderson, WA |  | Written fixed quote |  |  |  |  |  |  |  |  | 1
 | [NAME] additionals allowance |  | Estimated |  |  |  |  |  |  |  |  | 1 | 1000
 | Consumables allowance |  | Estimated |  |  |  |  |  |  |  |  | 1 | 500
 | Pricing
 | Total labour
 | Total T&S
 | Total materials