Cost & Allowables User Manual
Contents
1. Remaining y Allowable Allowable Cost Allowable Cost ep CONCRETE FORM 601 489 681 489 2 632 561 2 832 561 2 634 051 2 832 561 681 489 _ 51188 CONCRETE 396 254 396 254 1 549 448 1 549 448 1 939 762 1 549 448 396 254 El 1161 Concrete Blinding 18 869 18 869 61 089 61 089 79 958 61 089 18 869 _ 11101 910002 General Labour 4 382 4 382 14 186 14 186 18 567 14 186 4 3827 _ 1161 920004 Aggregates 1 729 15729 5 596 5 596 7 325 5 596 1 729 _ 11161 920016 Ready Mix Concrete J _ n101 920012 Cement 6 318 6 318 20 455 20 455 26 773 20 455 6 318 _ 11101 920020 Stone 3 523 3 523 11 404 11 404 14 927 11 404 3 523 _ 11101 960000 External Plant hire 2 490 2 490 8 060 8 060 10 550 8 060 2 490 _ 11101 960002 Fuel 429 429 1 388 1 388 1 816 1 388 429 _ 1162 Concrete Foundation 318 689 318 689 1 022 765 1 922 765 1 341 454 1 022 765 318 689 E 1102 910002 General Labour 40 233 40 233 130 064 130 064 170 297 130 064 40 233 _ 1162 920004 Aggregates 29 035 29 035 92 900 92 900 121 935 92 900 29 035 _ 11162 920016 Ready Mix Concrete _ 1162 920012 Cement 136 458 136 458 438 199 438 199 574 658 438 199 136 458 _ 1102 920020 Stone 59 632 59 632 190 631 190 631 250 263 190 631 59 632 _ 11102 960000 External Plant hire 45 498 45 498 145 861 145 861 191 358 145 861 45 498 _ 1162 960002 Fuel 7 833 7 833 25 111 25 111 32 943 25 111 7 833 Bi _ 5 1183 Concrete Walls 28 188 28 186 169 0782. Cost Allowables User Manual Contents INTO Ce id Te Mar ol is 1 nm rr Mecaneenacadseasataaneeancenactdcees 1 DENON S essetis niire era i E AE rear 1 Getting Started A A 2 Analyse Allowable To dale spas n a eee cio 3 MDOT TOGE COS ui atte ari ene a a eee 4 COSAS MES cerna a diu states ates ee eGelal alias Seed G cee 6 Reasons COSIS ii o ol a tad aula hoes 7 a naa ceed Dabs atte Meade hed aaaute tu ata tact Oust acta ed aa feulG a Nae Deh aeeate th bales clei ae oe Dah cee 9 GOS WONSICO Sian 11 SUDCON TAC COSTS iris 12 Subcontract Cost COE ooccccocccccccncccccncconnnoconnnonacnnonnnnnnnnnnnnnnnnnnnnnnnoncnnnnnnnennnnnnoncnnns 12 Net WoOrksheSt GOSECOde sinni raioliticndicads 13 Cost Alowables Al COMPICTION nssustcinacta concilios 15 SELU NEXT VAGA O N eeo A 16 BackUp OF CODY NE JOD cerisa diia 16 Vall ATION SOlUDicsmosioaarsietisit nace os beto a ici loas abs 17 Introduction Cost Allowables is used to monitor the financial performance of a project The current allowable generated by Candy is compared with the current costs as captured in the accounting system like BuildSmart6 Whilst it is important to understand where a project stands financially at any point in time it is more important to have the ability to forecast the financial status at completion The Cost amp Allowables module provides all the tools necessary to achieve these goals and thus assists the project team to make valued decisions in order to maxim
3. 169 078 197 258 169 678 28 186 _ n103 910002 General Labour 4 864 4 864 29 183 29 183 34 046 29 183 4 864 _ n103 920004 Aggregates 2 301 2 301 13 804 13 804 16 104 13 804 2 301 _ 11163 920010 Ready Mix Concrete _ 1103 920012 Cement 11 944 11 944 71 664 71 664 83 608 71 664 11 944 7 Indirects excluded Allowables comprise original bill items amp approved VO s Complete calculation on 12 11 2013 15 43 58 The above document shows the To date Remaining and At completion Allowables for the current Valuation The Task code column is included by default in this document The BuildSmart accounting system has both the Task code Activity code and Cost code Ledger code for more comprehensive financial reporting If your accounting system does not make use of Task codes then this column can be deleted from the document see below Estimating Planning Link amp Forecast Cashflow Valuations Subcontract Manager Cost amp Allowables _ Materials Drawings Main Documents Reports Advanced RSS ESMtzHhvr BART TS ssl aaau O Edit View Tools At completion Indirects excluded Allowables comprise original bill items amp approved VO s Complete calculation on 12 11 2013 15 43 58 Codes i Allowable EN Job Total 233 185 233 185 6 652 762 5 059 167 _ 801 GBD Excavations 247 022 247 022 973 322 973 322 803 Gradiant Const 132 552 132 552 123 244 129 710 _ 900 S
4. 188 28 458 276 169 678 169 678 1103 910002 General Labour 4 864 4 864 29 183 29 183 1103 920064 Aggregates 2 301 2 err 2d 13 804 3 804 1103 920010 Ready Mix Concrete 1103 920012 Cement 11 944 12 063 119 71 664 71 664 1103 920026 Stone 4 607 4 699 92 27 639 27 639 1103 960008 External Plant hire 3 809 3 885 76 22 855 22 855 1103 960002 Fuel 656 662 6 3 935 3 935 51184 Concrete Ground Sla 24 516 24 287 229 296 516 296 516 1184 310002 General Labour 5 848 5 731 117 59 166 59 166 1164 920004 Aggregates 1 842 1 823 19 23 419 23 419 1104 920016 Ready Mix Concrete 1164 920012 Cement 9 563 9 563 121 586 121 586 1164 3920020 Stone 3 688 3 651 37 46 893 46 893 1184 960000 External Plant hire 3 050 2 989 61 38 776 38 776 1164 960002 Fuel 525 530 5 6 675 6 675 Whilst there are variances between Allowable and Cost there are no variances forecast in the remaining work to completion Future cost variances can also be analysed in Candy Future costs are influenced by e A change in the rate of a resource e A change in the production outputs as used on the original worksheets e A change in the amount of waste allowed by the estimator e The necessity to employ another subcontractor with rates that differ from the allowable rates A far more accurate financial forecast can be achieved by making use of the following e Cost rates future resource rate adjustment e Cost worksheets e Subcontract manager PE Cost rate It is inevitable
5. 20 1102 920004 Aggregates 29 615 21 1102 920010 Ready Mix Concrete 0 234 300 y i y y ised for Costs amp Allowables The screen shot below displays the To date financial position of the job as the Actual allowable is compared against the To date costs of the job broken down into the project codes Task amp Cost 1 1 Cost Allowable by period x Edit View Tools Ed Codes To date Remaining Task Cost Description Allowable Cost Variance Allowable Cost Variance 44 CONCRETE FORMAORK amp 661 489 603 723 2 234 2 032 561 2 032 561 E 51188 CONCRETE 390 254 396 969 715 1 549 448 1 549 448 11101 Concrete Blinding 18 869 18 845 4 61 689 61 689 1161 310002 General Labour 4 382 4 425 43 14 186 14 186 1161 920004 Aggregates 1 729 2 194 465 5 596 5 596 1101 920016 Ready Mix Concrete 1161 920012 Cement 6 318 5 818 506 20 455 20 455 1161 920020 Stone 3 523 3 523 11 404 11 404 1161 960006 External Plant hire 2 4960 2 465 25 8 060 8 060 1161 960002 Fuel 429 420 9 1 388 1 388 1162 Concrete Foundation 318 689 319 387 698 1 822 765 1 822 765 1162 910002 General Labour 40 233 40 635 402 130 064 130 064 1102 920004 Aggregates 29 035 29 615 G80 92 900 92 900 1162 920010 Ready Mix Concrete 1162 920012 Cement 136 458 137 822 1 364 438 199 438 199 1102 920020 Stone 59 632 58 439 1 193 190 631 190 631 3 1102 960006 External Plant hire 45 498 45 043 455 145 861 145 861 1102 960002 Fuel 7 833 7 833 25 111 25 111 21163 Concrete Walls 28
6. H18 18Novl 18 Nov Ventshaft amp Substation Contract Valuation No 1 160911 H19 E Ventshaft Substation Contract Valuation No 2 If 18 Novl 18 Nov 1 New heading Duplicate job Delete this job Ctrl Del Backup Recover job LilUseripeter o locuments CCSDAT A COY HA Job properties 16 Valuation setup To setup the next valuation select Valuations gt Main gt Valuation setup manager J Estimating Planning Link amp Forecast Cashflo MY al cae Master Job Manager Estimate Details ERA E E rates Sond aT Costs amp Allowables Backup Recover Estimate amp Valuation Confirm Next valuation QQ2x xNRG O 1 233 185 1 233 185 5 052 702 1 233 185 6 285 886 35 368 900 36 602 084 6 285 886 gt Backup all valuation data files before setting up the next valuation Yes mo AAA E Wa a Once the next valuation is confirmed the current valuation will be archived and the details of the new valuation required as below Current quantity date 18 11 2013 Valuation number Valuation Title Valuation No 3 Transfer escalation data 17
7. Reg No 96 003 1023 E m De EARTH 12 Earthworks 27 Mar Subcontractor name GBD Excavations ee i 46123456789 Contact person Gordon Drummat Type Domestic v Work description Subcontract Cost code Q 801 GBD Excavat v Order number Networksheet Cost code Postal address 123 Station Street Groot Rivier Tel No 0412223333 Cell No Fax No 0412223334 Email address gbd telkomsa net Notes Net worksheet Cost code This is the cost code of the subcontract resource in the worksheets of the current subcontract bill In the example below the column 16 3 Resource Cost code list has been added to document 1 1 Subcontract bill which indicates that the Net worksheet Cost code for the items in the subcontract bill in this example is 900 s 2 oE View Tools A Subcontract EARTH Earthworks S C certificate 2 a a xA lka E a of Quantities Awarded omy Awarded 11 SECTION 2 VENTILATION SHAFT 431 Jal 1 SCHEDULE HO 1 FAM FOUNDATION als 1 EARTHWORKS Clear and strip site m2 5 600 Excavate in bulk Class A material m3 10 800 and dispose within km freenaul distance Excavation in foundations ne m deep ms Excavate for working space in Class A m3 Material and backfill and compact to 95 mod AASHTO Excavate in class A material for trenches and use for backfill compact and dispose of surplus material New drainage sump a DP SESS AA 13 Follow the same procedure for Subcontractor EARTH but in
8. gt Calculate The changes that were made to Resource costs Cost worksheets and Subcontract Manager are all reflected on the above document and the resultant variances to allowables are shown in Remaining Variance and At Completion Variance 15 Set up next valuation Completion of the Cost 4 Allowables documents is probably the final stage in the valuation cylcle and at this point it is important to set up the next valuation Set up next valuation will copy all the To date quantities and costs into previous Backup or Copy the job It is good practice to backup or copy each valuation job before entering the next valuation quantities Eventually there will be an electronic copy of each valuation which can be referred to if required Go to the job manager and Duplicate job 1 below Job Edit View Tools xH Ma Job Name Code No Created Last date Ventshaft amp Substation Contract 107460 H17 18 Nov1 18 Nov Ventshaft amp Substation Contract Remodelled 105528 H18 18 Nov1 18 Now nme 1 1 E Ventshaft Substation Contract Valuation No 1 Delete this job Ctrl Del 4 ill Backup Recover job d LilUseripeter o locuments CCSDAT A COY HA Job properties F2 Once copied Rename the new job 1 below lab Manager lobs in company Nemo Models Job Edit View Tools Job Name Ventshatt amp Substation Contract 107460 H17 18Nov1 18 Nov 1 Ventshaft amp Substation Contract Remodelled 105528
9. on site Similarly waste allowances and other variables may require adjustment To do this open document 5 7Bill with Cost rates for Cost w s adjustment and select the worksheet requiring adjustment Select View 1 gt Flip to Cost worksheet 2 ES a lola xno OQ ff Decimal display for Resource rates 2 085 ma Selling Rate Total Rate 624 88 A a stored 13 Nov 13 L Labour 76 89 Decimal display for Net rates i Recalc 14 Nov 13 P Plant 89 21 E MacroQty Recale IM Material 456 78 Change to Mechanical worksheet Multi line bill descriptions Show bill items with headings 578 59 2 46 29 7 624 88 Day 25m3 per day Change to display Rates Amounts Ctrl A q Wel Ro a Resize amp Position Linelof3 Tracking Valuation order en Inserta w s lt Complex w s Store worksheet In this exercise the production output is to be reduced from 25m3 day to 20m3 day and the waste allowance reduced from 7 5 to 4 ry g peca ig e PE a ptes 6 A a E E A EE a a C341 Price code Cost worksheet Created PP 14 11 2013 Amended PP 15 11 2013 4 Edit View Tools 034 Cone Z lMpa Foundations 21B Ceb Concrete in foundations JA Ceb Concrete in foundations Stored 15 Now 13 L Labour Recale 16 Now 13 F Plant MacroQty Recale M Material 440 72 515203 C20 19 Concrete Mixed amp Delivered 637 08 m3 il 4swas te 558 56 24516 Placing Gang 6 6
10. that during the course of a project the price of resources will change To analyse the effect of these price changes the cost rate has to be entered Go to Estimating gt Document manager gt Document 2 3 Resource list with cost rates Edit View Tools Resource L I Code 2 M 8121 River Sand ES 115122 Crusher Sand a M 5123 Filler Sand 65 004 a 115124 Plaster Sand im 5 00f M 5125 Building Sand m3 60 00 E 1151311 OPC Bulk S kg bag 1 91F EE hl 51312 OPC Bags S kg bag 9 79 Resource usage calculation Excludes Indirects Includes Go to Complex worksheet Complex worksheet oan The Final rate allowable rate is displayed in 1 above and must not be altered The Cost rate 2 defaults to the same as the Final rate but can be adjusted as necessary Changing the Cost rate does not change the allowables but does change the forecast cost to completion In this example a buying saving was achieved on the aggregate but cements cost more than the allowable 72 Pe cource list writ 1 cost rates Sake Edit View Tools Hoax HOR SG F LiT Code unit E M 5121 River Sand m3 Ei i 5122 Crusher Sand m3 I 5123 Filler Sand im M 5124 Flaster Sand m3 E h 5125 Building Sand im iM 57311 OPC Bulk S kg bag E M 51312 OPC Bags S kg bag 11512341 Slagment Bulk 5 kc bad 1151342 Slagment Bags 50kg bag Ej M 51413 15mm Aggregate ime Resource usage calculation Excludes Indirec
11. then customised by using the Customise button 4 Estimating Planning Link amp Forecast Cashflow Valuations Subcontract Manager Main Documents Reports Advanced a ABS ESHA zhvr SHAATTS a View Tools Costs Allowables Cost amp Allowables documents New Heading m New Sub Heading Bl 1 Cost amp Allowable gt PEL ia 2 Allowable Escalation gt e 3 Costs gt E gt gt gt 1 2 Cost amp Allowable by type 1 3 Cost amp Allowable with VO s by period 1 4 Cost amp Allowable with VO s by type 1 5 Production and Average Rate 1 6 Average Rates by Period 1 7 Quantities and Manhours 1 8 Cost Recon Amounts and Quantities E B iti 4 Fixed price Variances e js 5 Bill Es i 6 Resources 41 2 Allowable Escalation UA 3 Costs El 3 1 Cost Import E 3 2 Costs summary S Customise Select Analyse Allowable to date To ensure the correct comparison between Cost Allowables it is essential to measure the actual quantity on the same date as the cost close for accounts Select document reference 1 1 Cost amp Allowables by Period and open the document Press Calculate to summarise the latest information Estimating Main Documents Reports Advanced Planning Link amp Forecast Cashflow Valuations 46 0 E3Mz byw p ARTT Edit View Tools Subcontract Manager Cost amp Allowables Materials Drawin si Joe TETE
12. 02 KP Plant Hire Item 46 Manhour codes 803 Gradiant Const Item 4 7 Resource combinations 900 Subcontract Work Item s 11910000 Salaries Sum 5 Miscellaneous settings 970002 General Labour Sum 5 1 General settings 19206068 Mechanical fittings SUM j l npp 920002 Grout m3 5 2 Decimalisation 920004 Aggregates m3 p ei 820006 Pipework im 2 3 Dual currency options 1320018 Ready Mix Concrete m3 54 Printing options 920012 Cement Bag In this example there are two subcontractors executing the same bill items namely GBD Excavations Cost code 801 and KP Plant Hire Cost code 802 Once the Cost codes have been defined above go to Subcontract Manager 1 below gt S C 2 and then to the Details tab 3 of the subcontractors assigned to do this work The Subcontract Cost code is selected from the dropdown box 4 and will be the code that the cost and allowable is reported against In this example the Subcontract Cost code is 801 12 Estimating Planning Link amp Forecast Cashflow Valuations Subcontract Manager Cost amp Allowables Materials Drawings Main Documents Reports AByS ESHM thw C amp M 4 YT amp El Earthworks Certificate 2 View Tools Details Contract Extras Charges Materials on site Advanced payments Escalation Certificate Values Subcontracts S E Subcontracts Area 1 a 5 B pe 28 Mar Subcontractor code Z0002 e
13. 1157 35 Day 20m3 per day 57 B7 7 616 43 Line 430f3 Tracking Bill order o Inserta w s lt Complex w s Store worksheet 5 Notice that the title of the worksheet is clearly shown as Cost Worksheet 1 above and after changing the production output the cost rate now differs from the net rate 2 11 Subcontract costs Forecasting the cost to completion for subcontract work has been simplified by using Subcontract Manager The Cost Allowable will be reported against the subcontract accounts ledger code without changing cost or allowable worksheets even if there are multiple subcontractors to one or more BOQ items This is possible by identifying the Subcontract Cost code and the Net worksheet cost code Subcontract Cost code The Subcontract Cost code is the code to which the payments for this subcontract are allocated This code will typically be the ledger code used by the accounts department to identify the cost against the subcontractor To define a Cost code go to Definitions amp Settings gt 4 1 Cost Codes Ledger Code Definitions amp Settings Estimating amp Valuations ri Isted definiti l e gt _4 Resource related definitions _ _ Resource Cost code definitions 41 Cost codes Ledger code ae A a O Ge g SE E E O Edit Tools 4 2 Group codes En 43 Tax codes code Description Unit 44 Currency exchange rates TT ATT rer 45 Production codes AE GBD Excavations Item 3
14. 2 920064 Aggregates 29 615 102 920076 Ready Mix Concrete ll 102 920012 Cement 137 822 102 920020 Stone 58 439 From the document 3 1 Cost Import select Tools gt Release costs for Cost amp Allowables The Actual cost column will now be used in the Cost amp allowables documents and now termed as To date cost SP EGIT VIEW 10015 GOV DY Y wy _ CONCRETE FORMMORK amp a _ ja CONCRETE 398 254 396 969 715 1 549 448 1 549 448 1 939 702 1 948 417 E ME Concrete Blinding 18 869 18 845 24 61 089 61 089 79 958 79 934 E 1101 910002 General Labour 4 382 4 425 43 14 186 14 186 18 567 18 611 1101 920004 Aggregates 1 729 2 194 465 5 596 5 596 7 325 7 790 _ 1101 920010 Ready Mix Concrete _ 1101 920012 Cement 6 318 5 818 500 20 455 20 455 26 773 26 273 _ 1101 920020 Stone 3 523 3 523 404 11 404 14 927 14 927 _ 1101 960000 External Plant hire 2 490 2 465 25 8 008 8 060 10 550 10 525 _ 11101 960002 Fuel 429 420 9 1 388 1 388 1 816 1 808 dit View Tools Imported Adjustments ne Taskcode Costcode Cost code description Costto date Accrual Reallocation Accruals S C Liability Materials 12 1101 910002 General Labour 4 425 13 1101 920004 Aggregates 1 694 500 14 1101 920010 Ready Mix Concrete 6 15 1101 920012 Cement 6 318 500 16 1101 920020 Stone 3 523 17 1101 960000 External Plant hire 2 465 18 1101 960002 Fuel 420 19 1102 910002 General Labour 40 635
15. 270 169 078 167 692 1 386 197 258 196 142 1103 910002 General Labour 4 864 4 864 29 183 29 183 34 046 34 047 1103 920004 Aggregates 2 301 2 277 24 13 804 13 804 16 104 16 081 1103 920010 Ready Mix Concrete 1103 920012 Cement 11 944 12 063 119 71 664 74 884 83 608 86 947 1103 920020 Stone 4 607 4 699 92 27 639 23 033 32 246 27 732 1103 960000 External Plant hire 3 809 3 885 76 22 855 22 855 26 664 26 740 1103 960002 Fuel 656 662 6 3 935 3 935 4 590 4 597 1184 Concrete Ground Sla 24 516 24 287 229 296 516 294 164 321 032 318 451 1104 910002 General Labour 5 848 6 731 117 59 166 59 166 65 014 64 897 1104 920004 Aggregates 1 842 1 823 19 23 419 23 419 25 261 25 242 1104 920010 Ready Mix Concrete 1104 920012 Cement 9 563 9 563 121 586 127 050 131 149 136 613 1104 920020 Stone 3 688 3 651 37 46 893 39 078 50 581 42 729 1104 960000 External Plant hire 3 050 2 989 61 38 776 38 776 41 826 41 765 1104 960002 Fuel 525 530 5 6 675 6 675 7 200 7 205 9201 980002 20 500 a 20 500 Ey 18506 SUBCONTRACT WORK 379 574 386 767 7 193 1 996 567 1 193 532 1 476 141 1 498 299 58561 Excavation 379 574 386 767 7 193 1 996 567 1 193 532 1 476 141 1 498 299 8501 801 GBD Excavations 247 022 246 917 105 973 322 973 322 1 220 344 1 220 239 8501 802 KP Plant Hire 132 552 139 850 7 298 123 244 130 210 255 796 270 060 8501 900 Subcontract Work Indirects excluded Allowables comprise original bill items amp approved VO s Complete calculation on 15 11 2013 13 05 00 Graph lt
16. 8 137 822 1 364 438 199 467 710 574 658 605 532 1102 920020 Stone 59 632 58 439 1 193 190 631 158 859 250 263 217 298 1102 960000 External Plant hire 45 498 45 043 455 145 861 145 861 191 358 190 904 4102 960002 Fuel 7 833 7 833 25 111 25 111 32 943 32 944 EN 21103 Concrete Walls 28 180 28 450 278 169 078 167 692 197 258 196 142 1103 910002 General Labour 4 864 4 864 29 183 29 183 34 046 34 047 1103 920004 Aggregates 2 301 2 277 24 13 804 13 804 16 104 16 081 1103 920010 Ready Mix Concrete 1103 920012 Cement 11 944 12 063 119 71 664 74 884 83 608 86 947 3 339 1103 920020 Stone 4 607 4 699 92 27 639 23 033 32 246 27 732 4 514 103 960000 External Plant hire 3 809 3 885 76 22 855 22 855 26 664 26 740 76 1103 960002 Fuel 656 662 6 3 935 3 935 4 590 4 597 6 EE 51184 Concrete Ground Sla 24 516 24 287 229 296 516 294 164 321 032 318 451 2 581 1104 910002 General Labour 5 848 5 731 117 59 166 59 166 65 014 64 897 117 1104 920004 Aggregates 1 842 1 823 19 23 419 23 419 25 261 25 242 1104 920010 Ready Mix Concrete 1104 920012 Cement 9 563 9 563 121 586 127 050 131 149 136 613 1104 920020 Stone 3 688 3 651 37 46 893 39 078 50 581 42 729 1104 960000 External Plant hire 3 050 2 989 61 38 776 38 776 41 826 41 765 1104 960002 Fuel 525 530 5 6 675 6 675 7 200 7 205 10 Cost worksheets Production outputs used for the original estimate may also need adjustment to reflect the current conditions
17. al Labour 5 848 5 731 59 166 59 166 920004 Aggregates 1 842 1 823 23 419 23 419 920010 Ready Mix Concrete 920012 Cement 9 563 9 563 121 586 920020 Stone 3 688 3 651 46 893 960000 External Plant hire 3 050 2 989 38 776 960002 Fuel 525 530 6 675 TER E A a N A N Ya A i E A Pe CE After updating Resource cost rates s J oae Edit View Tools GON aq tama O a E a y Task Cost Descriptio Allowable Cost Variance Allowable Cost Variance ff Allowable Cost Variance BE CONCRETE FORMWORK amp 661 489 603 723 2 234 2 032 561 2 026 057 Y 2 634 051 2 629 780 21106 CONCRETE 398 254 396 969 716 1 549 448 1 542 944 1 939 762 1 933 913 El 24161 Concrete Blinding 18 869 18 845 24 61 089 60 584 79 958 79 429 1101 910002 General Labour 4 382 4 425 43 14 186 14 186 18 567 18 611 1164 920004 Aggregates 1 729 2 194 465 5 596 5 596 7 325 7 790 _ 1101 920010 Ready Mix Concrete 1104 920012 Cement 6 318 5 818 500 20 455 21 851 26 773 27 669 11101 920020 Stone 3 523 3 523 11 404 9 504 14 927 13 027 1101 960000 External Plant hire 2 490 2 465 25 8 060 8 060 10 550 10 525 1101 960002 Fuel 429 420 9 1 388 1 388 1 816 1 808 E 41162 Concrete Foundation 318 689 319 387 698 1 022 765 1 626 564 1 341 454 1 339 891 1102 910002 General Labour 40 233 40 635 402 130 064 130 064 170 297 170 699 1102 920004 Aggregates 29 035 29 615 580 92 900 92 900 121 935 122 515 1102 920010 Ready Mix Concrete 1102 920012 Cement 136 45
18. ce Allowable Cost fVariance P Allowable Cost Variance El Job Total 1 233 185 1 242 093 8 908 5 052 702 5 645 520 7 182 6 285 886 6 287 613 1 726 2111 CONCRETE FORMMORK 2 661 489 603 723 2 234 2 032 561 2 014 679 17 882 2 634 051 2 618 402 15 649 11166 CONCRETE 396 254 396 969 715 1 549 448 1 531 566 17 882 1 939 702 1 922 535 17 167 1161 Concrete Blinding 18 869 18 845 24 61 089 60 584 505 79 958 79 429 1101 910002 General Labour 4 382 4 425 43 14 186 14 186 18 567 18 611 1101 920004 Aggregates IA 2 194 465 5 596 5 596 7 325 7 790 1101 920010 Ready Mix Concrete 1101 920012 Cement 6 318 5 818 500 20 455 21 851 1 396 26 773 27 669 1101 920020 Stone 3 523 3 523 11 404 9 504 1 901 14 927 13 027 1101 960000 External Plant hire 2 490 2 465 25 8 060 8 060 10 550 10 525 1101 960002 Fuel 429 420 9 1 388 1 388 1 816 1 808 1182 Concrete Foundation 318 689 319 387 698 1 922 765 1 909 126 13 639 1 341 454 1 328 513 1102 910002 General Labour 40 233 40 635 402 130 064 146 620 16 557 170 297 187 255 1102 920004 Aggregates 29 035 29 615 580 92 900 89 980 2 919 121 935 119 595 1102 920010 Ready Mix Concrete 1102 920012 Cement 136 458 137 822 1 364 438 199 453 054 14 854 574 658 590 876 1102 920020 Stone 59 632 58 439 1 193 190 631 153 863 36 768 250 263 212 302 1102 960000 External Plant hire 45 498 45 043 455 145 861 141 286 4 575 191 358 186 329 1102 960002 Fuel 7 833 7 833 25 111 24 323 788 32 943 32 156 211163 Concrete Walls 28 180 28 450
19. ces 1103 920004 Aggregates 1103 920076 Ready hix Concrete 1163 920012 Cement 1103 920020 Stone 2 The total of the subcontract due quantity must equal the Actual quantities in the main contract Valuation If there is a difference a message will be displayed for you to make the necessary corrections 3 No subcontract Due quantity may exceed the Final awarded quantity 4 The total Final awarded quantities must equal the Final bill quantities Go to Subcontract Manager gt Document Manager gt Document 2 1 BOQ with Subcontract allocation to check for any differences 5 If rules 2 3 or 4 have not been obeyed there will be a message displayed for you to correct the error 6 Internal bill items must be created where the main contractor and subcontractors are undertaking work using the same bill items 14 Cost amp Allowables at completion By using the three methods described previously we now can calculate the forecast cost to completion Allowable at completion is calculated using the Final quantities x Net rate and the Cost at completion is the sum of the Cost to date and Remaining costs This information is used to determine the financial performance of the project at completion Open the document 1 1 Cost amp Allowables by period and calculate 1 1 Cost Allowable by period ec ae Edit View Tools Q2Q2xn0R a O Codes To date Remaining At completion _ Task Cost Description Allowable Cost Varian
20. e 3 From the Candy Material received module 4 From BuildSmart accounting software From the Cost amp Allowables document manager select document 3 1 Cost Import Select Tools gt Import costs to date gt Import from file Use the explorer to find the text file and import the file E nm Edit View Tools Import from BuildSmart Import from Materials Received 920020 SEO External Plant hire 950002 Fuel 310002 General Labour S20004 Aggregates 920076 Ready hix Concrete 920012 cement a ELLE ELLE L LL To complete the import process select from the available columns headings 1 below which match the headings 2 of the imported document The Code description does not require matching as Candy already associates the Cost code description with the Cost code Column Identification Import file information Numeric Punctuation Number of lines 93 Thousands separator 1 000 000 00 Number of columns 4 Decimal point Select column headings that match the imported information Identify Cjlumn Available Columns 2 Task co 3 Costco lt ignore gt 4 Imported real cost to date Description GBD Excavations 4 Imported real cost to date Gradiant Const 5 Imported accrual ex accounts GBD Excavations 6 Accruals Eocene A 7 Subcontract liability 8 Uncosted material Subcontract Work 9 Contra charges GBD Excavations 10 Residual 3 Gradiant Const 11 Others Subcont
21. ise the profitability of a project To summarise Cost amp Allowables is used to analyse e To date Allowable v To Date costs e Remaining Allowable v Remaining cost e At Completion Allowable v At Completion cost There are a variety of documents and reports available which can be customised to the requirements of the project team Requirements In order to get the most benefit out of Cost amp Allowables the user should have a good knowledge of Candy Estimating amp Valuations as this manual will refer to the bill document valuations worksheets resources project codes and Subcontract Manager Definitions The following is a list of definitions for the terminology used in this manual e Allowable to date Actual quantity x Net rate e Cost to date Imported cost to date e Variance to date Allowable to date Cost to date e Allowable remaining Remaining quantity x Net rate e Cost remaining Remaining quantity x Cost rate e Variance remaining Allowable remaining Cost remaining e Allowable at completion Final quantity x Net rate e Cost at completion Cost to date Cost remaining e Variance at completion Allowable at completion Cost at completion Getting Started The Cost Allowables documents can be found under the Cost amp Allowables menu 1 below and then to Document Manager 2 By using the New document button 3 there are a variety of standard documents that can be selected and
22. ract Work GBD Excavations Gradiant Const Subcontract Work General Labour Aggregates Manh AS Ignore the first lines Ignore similar lines When the import is complete the imported information needs to be checked against the Candy information for differences Select Tools Select Housekeeping Select Check import file Select the codes for checking If the imported file is not fully compatible with information within Candy a message will be displayed advising which line lines are not compatible These lines can be filtered out and displayed 6 Itis most likely that the column headings in the import document which are not defined as cost codes in Candy These should be deleted using Control Delete 7 Once the file has been corrected run the Check import file again and you should get a message Validation successful Candy Main Documents Reports Advanced ABCO ESHMEzEDw p ART TS Edit View Tools AAN ENE Planning Link amp Forecast Cashflow Subcontract Manager 19 1162 910002 General Labour 20 1102 920004 Aggregates 21 1162 920010 Ready Mix Concrete 5 a bi be amen y Import costs to date gt mported Adjustments Line Task cod Accrual Reallocation Accruals S C Liability Materials Contras O 1 Codes Release costs for Cost amp Allowables 0 2 Task 3 0100 g E 2 Export to Excel E 4 0100 i WE ET t file El 5 0100 900 Subcon
23. this case the Subcontract cost code would be 802 and the Net worksheet code 900 After following the above procedure the following rules need to be adhered to in order to calculate the subcontract costs to completion 1 From the Cost amp Allowables gt Document Manager gt Document 1 1 Cost Allowable by period gt Costs Allowables settings make sure that under Advanced calculation options that Costs for subcontract items from Subcontract Manager is ticked as indicated below 1 1 Cost Allowable by period Edit View Tools Calculate To date Remainii Task wable Cost Variance Allowable Cost 11 661 489 603 723 2 234 2 032 561 2 814 1166 Te Cost codes to Excel 398 254 396 969 T16 1 549 448 1 531 21101 Cost report export 1101 910 Housekee i 1161 9201 p A 1161 920016 Rea dy Mix Concrete 1161 920012 cement Bill item 1101 920020 Stone E 1101 960006 External Plant hire ES 1101 960002 Fuel _ Original Bill items 21182 Concrete Foundation O Digna Bill items and approved VO s 1102 310002 General Labour A EE 1102 920004 Aggregates ia Original Bill items and all VO s 1102 9200176 Ready Mix Concrete BS 920012 Cement Advanced calculation options 1102 S20020 Stone 1162 Seog GG External Plant hire i 1102 060062 Fuel as for subcontract items from Subcontract Manager e162 na Disable automatic calculation i oncrete 5 1163 510002 General Labour a Disable Bill item cross referen
24. tra charges that have yet to be processed Residual pre purchase of equipment such as formwork which must be written off over the period of the structure Other any other cost adjustment Notes to explain the reasons of the cost adjustments Edit View Tools Imported Adjustments Line Taskcode Costcode Costcode description Costto date Accrual Reallocation Accruals S C Liability Materials Contras Residual Others Actual Cost 9100 801 3 0100 4 0100 5 0100 GBD Excavations 12 800 12 800 803 Gradiant Const 6 000 6 000 9 0 0 Subcontract Work y 0 1 f 0 801 GBD Excavations 234 222 203 234 222 Gradiant Const 126 552 126 552 Subcontract Work 0 801 GBD Excavations 0 0 Gradiant Const Subcontract Work 0 96 0 910002 General Labour 4 425 4 425 234 900 k y 234 900 Not released for Costs amp Allowables Note Release the costs Having made the adjustments the adjusted costs can now be released for comparison with the allowable 12 800 6 000 0 22 GBU Excavations eo 2d 234 222 116 803 Gradiant Const 126 552 126 552 116 JAR Subcontract Work i GBD Excavations i Gradiant Const Subcontract Work General Labour A A ee A 4 425 101 920064 Aggregates 1 694 A 161 920016 Ready Mix Concrete is 161 920012 Cement 6 318 506 161 920020 Stone 3 523 101 960000 External Plant hire 2 465 161 960002 Fuel 420 102 916662 General Labour 40 635 10
25. tract Work s BI 6 0110 801 GBD Excavations 234 Validate and transfer costs to BOQ EN 7 0110 803 Gradiant Const 126 mi 8 0110 900 Subcontract Work Ej 9 0120 801 GBD Excavations 8 i 10 0120 803 Gradiant Const 8 a 11 0120 900 Subcontract Work _ 12 1101 910002 General Labour Select codes for checking 13 1161 920004 Aggregates Imported actual costs Failed code on line 1 iz 14 1101 920010 Ready Mix Concrete al 15 1101 920012 Cement El 16 1101 920020 Stone _ 17 1101 960000 External Plant hire Y Taskcode 18 1101 960002 Fuel Bill code E ei Cost Adjustments After the costs have been imported further adjustments can be made by the site personnel to reflect the true costs to date These adjustments are made to the imported costs on the same document 3 1 Cost import Adjustments can be made under the following headings 1 2 3 1 Cost Import Re allocation costs that have been misallocated can be corrected The total of this column must always add up to zero Accruals known costs that have not been captured in the accounts ledger SC Liability the difference between the subcontract Pay amount and Due amount Go to Subcontract Manager gt Subcontract document manager gt Document reference 3 1 Subcontract summary to see these amounts Materials materials that may have been pre purchased but not claimable in the current valuation such as materials off site Contras con
26. ts Includes to Complex worksheet _ Complex worksheet The result of updating the resource costs now gives a very different picture as can be seen in the Remaining Variance column 1 below Before updating Resource cost rates X Edit View Tools Codes To date Remaining a la A a A A A A A l OOS ar A vols Efi CONCRETE vOF T S 6 34 _ 5 1186 CONCRETE 390 254 390 se 1 549 448 l _ 51181 Concrete Blinding 18 869 18 845 61 989 910002 General Labour 4 382 4 425 14 186 920004 Aggregates 1 729 2 194 5 596 920010 Ready Mix Concrete 920012 Cement 6 318 5 818 20 455 920020 Stone 3 523 3 523 11 404 960000 External Plant hire 2 490 2 465 8 060 960002 Fuel 429 420 1 388 Concrete Foundation 318 689 319 387 1 022 765 910002 General Labour 40 233 40 635 130 064 920004 Aggregates 29 035 29 615 92 900 920010 Ready Mix Concrete 920012 Cement 136 458 137 822 438 199 920026 Stone 59 632 58 439 E 190 631 190 631 960006 External Plant hire 45 498 45 043 145 861 145 861 960002 Fuel 7 833 7 833 25 111 25 111 Concrete Walls 28 180 28 450 169 078 169 078 910002 General Labour 4 864 4 864 29 183 29 183 920004 Aggregates 2 301 A 13 804 13 804 920010 Ready Mix Concrete 920012 Cement 11 944 12 063 71 664 71 664 920020 Stone 4 607 4 699 27 639 27 639 960000 External Plant hire 3 809 3 885 22 855 22 855 960002 Fuel 656 662 3 935 3 935 Concrete Ground Sla 24 516 24 287 296 516 296 516 910002 Gener
27. ubcontract Work _ 910000 Salaries 228 000 228 000 _ 910002 General Labour 306 026 306 026 1 323 992 1 323 992 _ 920000 Mechanical fittings 58 501 58 501 29 644 29 644 _ 920004 Aggregates 36 582 36 582 151 109 151 109 _ 920006 Pipework 8 316 8 316 _ 920016 Ready Mix Concrete _ 920012 Cement 171 692 171 692 717 985 717 985 _ 920014 Bricks 7 598 7 598 358 798 358 798 _ 920016 Reinforcing 60 357 60 357 166 865 166 865 _ 920020 Stone 13 217 73 217 282 957 282 957 _ 920022 Drainage amp Manhole ma 4 893 4 893 6 382 6 382 _ 950000 Internal Plant hire 56 161 56 161 125 616 125 616 _ 960000 External Plant hire 56 195 56 195 219 827 219 827 _ 960002 Fuel 9 674 9 674 38 358 38 358 _ 970000 Sundry Materials 12 714 12 714 144 504 144 504 _ 980002 Subcontractors 153 784 153 784 6 466 255 796 228 000 1 630 018 88 144 187 692 8 316 889 676 366 396 227 222 356 174 11 275 181 777 276 022 48 032 157 218 153 784 1 220 344 859 167 973 322 129 710 228 000 1 323 992 29 644 151 109 8 316 717 985 358 798 166 865 282 957 6 382 125 616 219 827 38 358 144 504 153 784 247 022 126 086 306 026 58 501 36 582 171 692 7 598 60 357 73 217 4 893 56 161 56 195 9 674 12 714 Graph Calculate Import To date costs The To date costs can be imported as follows 1 Using a text file from accounting software package 2 From an Excel fil
Download Pdf Manuals
Related Search