Pamwin Component Accounting User Manual
Contents
1. E ea lt a A PS BEE TE A US TA Choice of types Enter a short title to identify the choice of types of the component Some of these can alternatives eg on Pitched roofs you could have concrete tiles natural slate etc Others could be sub components all of which might be present eg under Fences Gates you might have different types of fence paths and paved areas all of which could be present Measure of Qty Having picked a Component the default unit of quantity is looked up from the Components table on the Setup sheet But a different unit of quantity can be selected here Life The expected average life of the type of component is entered in the Life column in whole years In practice some will last longer and some will fail early But for the purpose of component accounting we need a reasonable average which is likely to relate to the way any elemental renewal programmes would be planned Cost This is the cost of renewing the components including VAT and any associated on costs It should be the cost assuming the renewal is being carried out as part of a planned maintenance contract as opposed to a responsive repair or void repair For example gutter renewals would require scaffolding but would normally be carried out at the same time as other roof works were undertaken So the cost of renewing the gutters should only include a share of the scaffolding cost Getting this right requires good judgement based on an understanding of the w2. cement sheeting le Sam 14 2 Flat roofs 2 Lead other specialist lle Sam useful for components where the quantity depends on the oa gt Fiat roofs gt Other ee som size of the units and there is a mix of different sized units 16 3 Chimneys and flashings 3 Pointing Render item 17 3 Chimneys and flashings 3 Rebuild o tem 18 4 Rainwater Goods 4 PVC po p3o Mete For other components such as kitchens and bathrooms _19 4 Rainwater Goods 4 Cast Iron o pp Mete th i 1 it d it will b ient 20 4 Rainwater Goods 4 Metal PT Metre ere Is usually one per UNIT ana It WI e more convenien 21 5 Fascia Sofft Bargeboards 5 Timber I TI 30 T Metre to enter 1 in the per house column and 1 in the per flat 22 5 Fasci Sofft Bargeboards 5 Pvc OO Metre 23 6 Windows 6 Timber hl Item column But with 6 units you could achieve the same affect 24 6 Windows 6 PVC ee ten by entering 6 in the scheme column _25 7 External Front Rear doors 7 Timber Pte A block is a convenient way of quantifying roofs and the common parts to flats The components to be entered per block are highlighted in green in the per block column By looking at these components you should be able to decide the most convenient way of grouping the flats into blocks If there is no obvious way you can enter their quantities in the scheme column Quite a few of these components are measured in sq m or metres
3. changing an item here does not automatically change it on the Components sheet it merely changes the list of options that can be picked on the components sheet Ages It is almost impossible for a surveyor to guess the exact age of a component simply by looking at it so ages are uSually expressed in ranges These ranges should match the ones used by your surveyors New rows can be inserted anywhere within the box The Years column in the table of Ages determines which year within the range will be used as the age of the component to determine its remaining life By default this is set to the top year in the range so if you pick the range 11 15 it would give it an age of 15 years But this can be changed by the supervisor The O option is used to indicate that a component needs immediate renewal The Years for this must be longer than the life of any of the components so we recommend leaving this at 99 Levels This table cannot be edited It is used to prompt the user whether to enter quantities for flats per flat or per block on the Components sheet The special option is used for other components see above Pamwin Component Accounting User Manual 13 of 17 Assumptions This is where the economic assumptions are set as follows Cost year for component prices Inflation rate Interest rate net of inflation Discount rate net of inflation Assumptions The renewal costs of the comp
4. 1 021 Reports Documents Total Reconstruction ES Hsg Corp SHG Enter this figure into the Reconstruction per m field on Timetable Revenue Projection years Discount Kateas Mortgage 7 Housing Corporation Rate 5 D interes the Assumptions screen of the scheme in Pamwin Plus N K E ol Include Years before 2002 E en Evaluate Long Term to Achieve Target RR NPV Period years teruel 1 LITTEFENT nTiacion arter Sale Handback Unit o al Comnletion Costs to Targ et Rent Re Increment Maintenance u Mortgage Drawdown A No Convergence until 4 01 04 2003 el ed Cak Reconstruction Reconstruction 32 Standard MRP Patterns i Per sq m i Defanlt E EEE Method to Anoortion Develooment Cost to U 33 regular new build 1 021 a a Revenue Forecast 8 11 ID Number of units z 35 regular rehab 8 169 Basic Tenure Type 37 Slow start new build 1 146 a Ten 39 Cro113 23 vrs 4 6 IMS Fields 41 Company 1MRP 972 43 NBSlowStart 574 45 47 49 Welcome Dave Treanor logged into PAMWINPLUSDEMO25 at08 12 2009 17 30 26 Pamwin Component Accounting User Manual 11 of 17 Setting up component accounting Setup This is where the system supervisor can edit the list of Components and other tables looked up within the Component Accounting spreadsheet Components It is generally considered helpful to structure the list of items against which repairs are forecast In this system we have adopted a very simple two part
5. Pamwin Component Accounting User Manual December 2009 For support phone 020 8254 5581 email Pamwin m3h co uk HOUSING 5 Commonside East Mitcham Surrey CR4 2QA Pamwin Component Accounting User Manual 1 of 17 Contents MroduU cO ee ee ie onecees bahia beta beet ea er vice RO 3 VAINGE1SJ COFNBONENE SECOUNEING o rol dto daa 3 WAV AO CIT NO 3 Using Panwi Component AGCOUREING paa daa e ieh 4 Caiculating the major repair provisions TOF a Schema ASA A AAA 5 Speciiyina the components N a CN dl de deL de LE di 5 Nom standard CompohenB sisas rd teases bee takes da viarinct dometenecewanewaceraedeueaeeatacerstanaee 6 Majo Fepalrs OM Stock re ImprovemenB esa ia TE 6 Comparing the whole life costs of alternative components zu a a Be run AA 7 Me te Eyale Costina Calculation A ee A A A RA 7 Calculating the major repair PFOVISIORS aa adas 8 Caiculating NON Standard MRES rOn Rear wun in A ia 9 Entering the major repairs Into Par WINinisistoriaiasiaio caco liderada lidiar ci n 10 Seto Up COMMONeNE AGCCOUNMEING ea ee OE Atte bs 12 A ee ee EE E dale a Sheena cea cn ae era 12 COMPONENTS en ne ee hanes ct te cise cee estates iste Poe cece tate N cit ash eR aN Eee ERBEN aun Amnon SEE aac enone RA 12 ANS E RR 13 Measures E A een ean te eri eeatcesmie totes 13 PISS it A A A ek eens Gaudet eae ume nee 13 A Sd dl dl O leo 13 ASSUIMPROAS raices socia teats 14 TYPES tase tinct mucha ele ee oocyte ee eae oie Same cece oe eae vation
6. The Measure of Quantity for each component is shown in column I Pamwin Component Accounting User Manual 5 of 17 Complete this form for all the components listed Non Standard Components The component accounting spreadsheet can A B A A D E F G H M N be configured to include Others at the 1 Components present 2 Houses Schemes bottom of the standard components These 3 EOE 2009 Hoses Mats piocs a are for user defined components details of Quantity present which are entered by the design team when o they complete the form It is up to the 4 sort Component Type e AAA 5 supervisor to decide whether to do this see 49 is Communal areas 18 Communal main entr door page 13 50 18 Communal areas 18 Door entry phone intercom 51 19 Services 19 Boiler communal 52 19 Services 19 Wiring emergency lighting If there are other components that are not 53 19 Services 19 Communal area finishes list n then th t th ttom 54 19 Services 19 Bin stores refuse chute de A 55 20 Others enter descrotion aja A of the list Enter a description for them in the 56 Others enter desorption 0 57 20 Others enter description ss S o Type column and then enter the quantities as normal For these you will also have to enter the renewal cost per tem in column M and the component life in column N These additional cells will be coloured green indicat
7. ay gutter renewals are carried out Level When dealing with flats it can be more convenient to enter the quantities for some component types eg roofs at block level rather than at unit level So the Components sheet has separate columns for entering quantities per flat or per block The user can use either column The choice of per unit or per block in column H merely highlights the more likely choice in green on the Components sheet Pamwin Component Accounting User Manual 16 of 17 MRPs Organisations that use only the standard Major Repair Provisions do not need to set these up they are already provided on the MRPs sheet in rows 19 to 25 Those that have their own unique MRP patterns should print them to Excel from Data Maintenance in Pamwin and copy the sheet into the FromPamwin sheet Then click on the Set Up button in row 35 of the MRPs sheet This will copy all MRPs that are set as of Reconstruction into the bottom section of the MRPs sheet Development officers can then use the Calc button to calculate the break even Reconstruction per sq m for each of these MRP patterns See page 8 Pamwin Component Accounting User Manual 17 of 17
8. block been edited 15 Flat roofs Asphalt Sqm 30 39 per block 16 2 Flat roofs Corr mineral cement sheeting Sqm 20 37 per block New rows can be inserted anywhere within the 17 2 Flat roofs Lead other specialist Sqm 50 125 per block D i 18 2 Flat roofs Other Sqm 20 40 per block table so as to keep similar Components listed 19 3 Chimneys and flashings Pointing Render Item 40 180 per block together New rows should not be inserted on the 20 3 Chimneys and flashings Rebuild Item 60 1 030 per block Types sheet after quantities have been entered for _21 4 Rainwater Goods PVC Metre 30 16 per block a scheme on the Components sheet If you did 22 4 Rainwater Goods Cast Iron Metre 60 25 per block neern tonc onte Toes ee eee e 23 4 Rainwater Goods Metal Metre 40 20 per block l yp q 24 5 Fascia Sofft Bargeboards Timber Metre 30 43 per block for all items that follow would need to be re 25 5 Fascia Sofft Bargeboards PWC Metre 30 43 per block entered on the Components sheet because they 26 6 Windows Timber Item 30 334 per unit would then be appearing against the wrong components Sort The Sort key is looked up from the Component entered in column B Having edited the list of components all rows containing components can be sorted by column A ascending so as to get them into a sensible sequence Component Pick the Component in column B from the table of Components defined on the Setup sheet see page 12 Pamwin Component Accounting User Manual 15 of 17
9. c button in cell A32 to calculate the break even reconstruction cost per sq m for each of these patterns The result in each case is shown in column D To set the reconstruction cost to the level required to generate sufficient major repair provisions select the cost per sq m from column D for the MRP pattern that is selected on the Assumptions screen of the scheme Pamwin Component Accounting User Manual 32 33 35 37 39 41 43 45 47 49 l Reconstruction Standard MRP Patterns cost regular new build 428 848 regular rehab Slow start new build Cro113 23 yrs Company 1MRP NBSlowStart Reconstruction Per sq m 1 021 8 169 1 146 476 972 574 0 80 0 10 0 00 0 60 0 12 1 50 0 80 0 10 0 00 0 60 0 12 1 50 9 of 17 Entering the major repairs into Pamwin Once the design team have completed the Component Accounting spreadsheet for a scheme they should have saved it in an appropriate directory with a name that identifies the scheme Attaching the component accounting file to the scheme The development officer should then attach this file as a document to the scheme in Pamwin This is done at the Reports Documents screen by picking the Documents tab Enter a Description for the file eg Component Accounting and click on the Browse button to Pamwin Plus SCHEME Reports drury York scheme 1 browse for the file provided by the design team Click Main Menu OK a coup
10. construction cost per sq m 1 300 You could also choose to enter the current default reconstruction cost 7 Default break even year per sqm This will then be used to calculate the break even increment 8 for a slow start MRP see row 15 and the break even MRP for a regular MRP see row 17 It is not needed otherwise 11 Lo Enter in C7 the length of time in years over which you wish to set the Se EEE ae ae Sea MRP to break even The HCA recommends 80 years so this is set as 14 Increment Standard MRP Patterns cost Per sq m the default when Pamwin Component Accounting is issued 15 Beak even increment 1 300 0 00 0 00 0 00 17 Break even regular MRP 1 300 0 88 0 88 Click the Calc button to calculate the break even MRPs 19 Regular new build 1 423 0 80 0 80 0 80 21 Regular rehab 1 139 1 00 1 00 1 00 The system will then calculate the break even MRP for each of the Be 1 649 Bas ae ae standard MRP patterns specified in rows 15 to 25 as follows E ARA 1 099 el aa ee This calculates the increment required for a slow start major repair provision to break even in the target year assuming that the reconstruction cost is based on the cost per sq m in cell C6 The increment is shown in A15 The full MRP pattern over 100 years is shown in E15 to DZ15 This calculates the reconstruction cost that would be required so that a regular MRP of 0 8 of the reconstruction cost would break even in the target year The Reconstruction Co
11. e cost less in future repairs You can see this by comparing the NPV in column J for the different components By entering their Age as zero and picking the option in cell J 3 to include current works in the NPV calculation you can compare the whole life costs of choosing slate rather than concrete tiles This is illustrated in the second snapshot The extra cost of the slates is then shown to outweigh the savings in future repairs and concrete tiles come out cheaper In this way the Component Accounting system can be used to assess the most economic options in the design of the properties In practice the lives and costs of the alternative building A E D E F G H J Components present MRP assessment year 2009 sort Component Type oaNlalua Pitched roofs 1 Pitched roofs 1 Pitched roofs 1 Pitched roofs 1 Concrete tiles 1 Natural slate 1 Synthetic slates 1 Clay wald beat are 6 1 Quantity present The amount can be entered for the scheme s as a whole or at unit or block level but not at both Measure of quantity Include current works No Include current components may be over simplified for this purpose A slate roof might require a stronger roof structure which the design team would want to take into account And they will want to consider a wider range of design options than might be provided by the list of componen
12. es ree bau E ET one eee ee tare ieetese 15 MRR Sons reciente trite seein ere ey trees bso N ER E REN EEE ENENERRE 17 Pamwin Component Accounting User Manual 2 of 17 Introduction What is component accounting Social landlords will have to introduce component accounting under enhancements to the SORP where they account for the various parts of houses eg kitchens roofs and bathrooms separately rather than as one home as at present The change is likely to come into effect for March 2011 Component accounting is based on life cycle costing The major building components that require renewal during the lifetime of the building are identified with their lives and renewal costs There is no standard list of these components or the extent to which they might be broken down into significant sub components For example a kitchen is made up of kitchen units work surfaces floor finishes etc each of which could have a different live and renewal cost The consultation documents on interpreting the SORP all indicate a general view that these should be broadly identified with lists such as kitchens bathrooms boilers heating systems windows roofs fences etc There is no standard list of component lives and renewal costs M3 Housing publish the NHF Schedule of Rates Planned Maintenance Module which includes the lives and renewal costs of major building components But this is only one source and opinions on lives and costs vary widely The meth
13. he first five years 0 3 for the next five 0 6 for the following and an additional 0 3 added to each subsequent five year period with no further increase after year 30 These standard major repair provisions make no attempt to explore the benefits of using higher quality building components that might have longer lives and hence might have lower long term major repair costs Pamwin Component Accounting User Manual 3 of 17 Others use life cycle costing to assess the expected demand for future repairs on typical building archetypes such as one bed flats or three bed houses They then calculate the level of major repair provisions needed to fund these forecast repairs expressed either as an amount per unit in each year or as a of the reconstruction cost in each year By using archetypes they take account of the design brief to which their new developments are expected to comply In determining the design brief they may well have explored the potential benefits of using higher quality building components that might have lower life cycle costs In looking at the costs and benefits of developing zero carbon homes the additional costs of improving the energy efficiency should be balanced against the benefits of lower energy consumption This whole life cost should include both the initial construction cost and the long term life cycle costs of improved insulation heat sinks ground source heat pumps solar water heating and the use of other techno
14. ing it should be net of inflation in reconstruction costs Pamwin Component Accounting User Manual 14 of 17 Types This sheet lists all the types of component against which major repairs can be forecast How detailed this list is will be a matter of choice for each organisation Setting up this list is the most important part of the implementation of the Pamwin component accounting system It will require agreement between the finance department and those responsible for stock condition surveys There should be some consistency between the level of detail at which component accounting on existing stock is assessed and the way it is done on new developments so that Pamwin appraisals can show the impact of each new scheme on the organisation s overall business plan The general rule should be to keep it as simple as possible The list on the Components sheet will be in the same sequence as the list you create here 7 Sort Component Choice of types Measure of Qty Life Cost Level 8 years Any changes made to the list on the Types sheet 9 1 Pitched roofs Concrete tiles Sqm 55 49 per block will automatically get carried through to the 10 1 Pitched roofs Natural slate Sqm 80 88 per black Components sheet 11 1 Pitched roofs Synthetic slates Sqm 35 52 per block 12 1 Pitched roofs Clay Sqm 65 50 per block l l 13 1 Ptched roofs Other Specialist Sq m 35 52 per block The Types sheet should be hidden once it has 14 7 Flat roofs Felt Sqm i5 49 per
15. ing the need to enter data into them Major repairs on stock re improvements The same system can be used for assessing the future major repairs to existing stock The only difference is that you also enter the age of the components in the Age column It is almost impossible for a surveyor to guess the exact age of a component simply by looking at it so ages are usually expressed in ranges The table of Ages on the Setup sheet determines which year within the range will be used to determine the expected life By default this is set to the top year in the range so if you pick the range 11 15 it would give it an age of 15 years But this can be changed by the supervisor Entering an age of O implies that the component needs replacing as part of the initial works on the re improvement So if you plan to renew the component now enter zero in the Age column It will then get included in the Immediate Works on the LCC sheet The Age is left blank on new build or complete refurbishment schemes ie where all the renewable building components are new and the component does not then get included in the Immediate Works Pamwin Component Accounting User Manual 6 of 17 Comparing the whole life costs of alternative components In some cases the Types list shows alternative qualities of component For example the roof covering might be concrete tiles natural slate or one of the other options Slates have a longer life than concrete tiles and therefor
16. le of times to save it Properties Appraisal i o m Appraisal Description Component Accounting FileName Wi sa EN A E xe TH Open Bu Timetable Or i My Received Files rr sen A faz Views New Folder ara avorite Links Date modified Type Bird_8634 JPG wh Internal and customer speakers doc Winzip exe bil 4 Recently Changed Development Statistic SG Recent Places Desktop Computer Scheme Details y Documents J Pictures IMS Fields Run this w Music Accounts Comment Searches Consolidated Public Template Run Report Data Maintenance New Document Famwin Trail Pamwin Component Accounting User Manual 10 of 17 Adjusting the reconstruction cost The reconstruction cost should be set so that the major repair provisions are sufficient to fund the major repairs forecast by the component accounting system 3 Pamwin Plus SCHEME Assumptions drury York scheme 1 This is done at the Assumptions screen of the scheme Appraisal Assumptions Check which MRP Pattern is being used The one ns Ian Rate illustrated here is Regular New Build Rental Period HC Weekly Mortgage Source Appraisal Reconstruction E per m 30 Year Annuity 6 5 Look up this pattern on the MRP sheet of the Component as TCI tid MRP Pattern Accounting file Find the Reconstruction Per Sq min Voids Pattern column D In the case illustrated this is
17. logies Putting a value on the lower energy consumption can be tricky especially where the benefit to tenants from lower fuel bills cannot always be matched by an increase in charges to recoup the cost of the improvements Using Pamwin Component Accounting The primary purpose of the Pamwin Component Accounting system is to calculate the level of major repair provisions required for each scheme in Pamwin using life cycle costing The data should be entered by the design team architect contractor or a consultant who should identify the quantities and types of the relevant components in the scheme The system then calculates the major repair provisions required by the scheme using life cycle costing The design team can immediately see which components give better value for money in the longer term and feed that in to the design process This places the assessment of the major repair provisions required with the people that can decide on the most cost effective design Having done the assessment the spreadsheet should be attached to the scheme as a document so that it can be opened from the reports menu This is how the building components in the scheme are recorded This assessment stays with the scheme throughout the development process and can eventually be passed to housing management when the units are handed over Major repair provisions are calculated by forecasting the annual balance in a major repair fund for the scheme Each yea
18. ntities against each component present in the scheme 3 On the MRPs sheet enter the gross floor area of the scheme and other optional information and click the Calc button to calculate the Major Repair Provisions Specifying the components in a scheme Open the Components worksheet and enter the name of A E E ED T EITE I er hr Be the scheme or project in cell C2 EA Components present 2 Project Park Street Pt Blocks Schemes 3 MRP assessment year 2009 6 1 Enter the number of houses and flats and the number of Quantity present easure blocks in which the flats are situated in row 3 The number The amount can be entered for the scheme s as i block level but both e of schemes is usually entered as 1 4 sort Component Type a een eh but not at both quantity ei per block scheme 6 Pitched roofs 1 Concrete tiles Sqm You could enter the quantity of each component at scheme _7_ Pitched roofs 1 Natural slate le Sam 8 1 Pitched roofs 1 Synthetic slates jp sqm level For example if you have six flats and each flat has SN 1 Pached roofs 1 Clay ee a com five windows you could simply enter 30 windows in the 10 1 Pitched roofs 1 Other Specialist pp Sa i E e 1 2 Flat roofs 2 Fett le sam scheme column against the type of window This is the 12 2 Flat roofs 2 Asphalt MS a sam most flexible way of entering quantities and is particularly 13 2 Flat roofs 2 Corr mineral
19. odology is fairly straightforward A matrix is created on a spreadsheet listing the major components in rows down the page and each future year in columns across the page up to 80 or 100 years If the average life of a boiler is expected to be 15 years then the current cost of renewing the boiler is shown in the 15 30 45 60 75 and 90 year The same is done for all the other components The projected costs in each year are then totalled to give the forecast renewal costs over each of the next 80 to 100 years at current prices You can see this calculation on the LCC sheet Life cycle costing has been used in maintenance planning systems for many years to forecast the expected level of demand for major repairs based on stock condition data collected from surveys So most social housing providers will already have some idea of the component lives and costs they might require for this purpose The surveyor estimates the age of the relevant building components so as to assess their remaining lives which is then fed into the life cycle costing analysis Why do it in Pamwin Most Pamwin clients currently use standard major repair provisions expressed either as a percentage of the reconstruction cost or as an amount per unit Some use standard levels of provision as previously recommended by the National Housing Federation The best known of these is a regular new build MRP at 0 8 of the reconstruction cost or a slow start MRP with nothing for t
20. onent types listed on the Types sheet will 5 need inflating in future years to take account of inflation The cost year 3 E entered here is the year from which they will need inflating ug Cost Year for component prices a Inflation rate 3 50 This is the annual rate at which the renewal costs will be inflated On the Components sheet the user sets the year from which the MRPs will be z assessed The renewal costs are then inflated for the number of years 2 between the MRP Assessment Year and the Cost Year The resulting inflation adjustment is displayed in cell M3 of the Components sheet Interest rate net of inflation 3 00 Discount rate net of inflaton 3 00 The calculation of break even Major Repair Provisions calculates the balance in a major repair fund at the end of each year by deducting any forecast repairs in the year adding any contributions and adding any interest on the balance in the fund These projections are all at current prices So the rate of interest should be net of inflation Strictly speaking it should be net of inflation in reconstruction costs The Components sheet shows the NPV of future repairs against each selected component so that the cost in use of the different alternative components can be compared This is calculated on the LCC sheet by applying discounted cash flow to the forecast repairs The future repairs are projected at current prices So the discount factor should be net of inflation Stricthy speak
21. r the fund is credited with the amount specified in the major repair provision and debited with the cost of forecast repairs The repair costs and major repair provisions are projected at current prices Interest on the closing balance is debited or credited The interest rate used is the rate net of inflation Goal seek trigged by clicking on a Calc button is then used to set the major repair provisions to a level that would result in the major repair fund breaking even in the target year The HCA has suggested that major repairs should be assessed over 80 years Where you use regular major repair provisions eg at 0 8 of the reconstruction cost or slow start major repair provisions eg rising at 0 3 every five years goal seek can determine the reconstruction cost that would be required to generate sufficient funding This is expressed as an amount in per sq m so that it can then be entered on the assumptions screen of the scheme where the reconstruction cost is calculated Pamwin Component Accounting User Manual 4 of 17 Calculating the major repair provisions for a scheme There are three stages to calculating the major repairs for a scheme 1 Open the Pamwin Component Accounting template and use Save As to save the file in an appropriate directory with a name that identifies the scheme being appraised 2 Onthe Components sheet identify the scheme and enter the number of houses flats and blocks in the scheme Then enter the qua
22. r unit per unit per unit per unit per unit per block per block special Default Measure Sg m Sg m Item Metre Metre Item Item Item Item sqm Metre Metre Item Item Unit Unit Unit Item Item Item Default level On the Components sheet some items are best entered per flat and some per block The default level picked here will determine which option is highlighted in green for that component Default Measure This is the default unit of measure used in quantifying a component It can be overridden on the Types sheet for certain types of component For example fences might be per Metre while paved areas might be per Sq m Pamwin Component Accounting User Manual 12 of 17 Other components Others is a special case and should only be changed if you are sure you do not need it It is used to add user defined components at the bottom of the Components sheet The person specifying the components in a scheme can then enter a description for each additional component They also enter a Life and Renewal Cost for each of these additional components on the Components sheet see page 6 Measure The choices of units of measure are set up in the Measures table on the Setup sheet The list can be edited by inserting new rows with additional units of measure provided these are inserted within the box Or any of the units of measure listed can be overwritten and changed But note that
23. st per sq mis shown in D19 This is the figure that should be entered on the Assumptions screen of the scheme Regular rehab This calculates the reconstruction cost that would be required so that a regular MRP of 1 of the reconstruction cost would break even in the target year The Reconstruction Cost per sq m is shown in D21 This is the figure that should be entered on the Assumptions screen of the scheme Pamwin Component Accounting User Manual 8 of 17 Slow start new build This calculates the reconstruction cost that would be required so that a slow start MRP starting at 0 for the first five years and then incrementing at 0 3 every five years would break even in the target year The Reconstruction Cost per sq mis shown in D23 This is the figure that should be entered on the Assumptions screen of the scheme Slow stat rehab This calculates the reconstruction cost that would be required so that a slow start MRP starting at 0 for the first five years and then incrementing at 0 4 every five years would break even in the target year The Reconstruction Cost per sq m is shown in D25 This is the figure that should be entered on the Assumptions screen of the scheme Calculating non standard MRPs from Pamwin For those that use non standard major repair provisions all the MRP patterns currently in use in their Pamwin database can be set up by the supervisor see page 17 These will then appear starting in row 33 Click on the Cal
24. structure of Components and Types You can see these listed on the Types sheet In some cases such as for roofs the Component might be pitched roof while the Types might be concrete tiles slates clay tiles etc where only one would normally be present In other instances the Component might be Fences Gates and the Types might be a mix of different types of fences and gates and other landscaping features a number of which might be present Fences Gates Kitchens As far as possible there should be consistency in the list of components used for stock 7 surveys and component accounting But they do not have to be rigidly the same There may 18 Wiring be reasons for sub dividing components for stock survey purposes that are unnecessary for 19 Central Heating system component accounting purposes Boilers Communal areas Services You could create a completely new list of components by overwriting the ones provided Or _ E fia 23 Others you could edit and extend the list This can be done by inserting rows at any point in the list or at the end of the list provided they are inserted within the box containing the list Comp ID This is used to sort the list of components into a sensible sequence It has not further meaning Default Level per b per b per b per b per b lock lock lock lock lock per unit per unit per unit per unit per block per block per block pe
25. ts included in the Component Accounting system But it can give a useful indication The Life Cycle Costing calculation The calculation of life cycle costs is done on the LCC sheet Pamwin Component Accounting User Manual ea Components present works 4 bre il hana ao _3 6 1 Yes Quantity present Measure The amount can be entered for the scheme s as of 4 sort Component Type Age a whole or at unit or block level but not at both quantity Es u 53 893 6 Pitched roofs 1 Concrete tiles 7 Pitched roofs 1 Natural slate 8 Pitched roofs 1 Synthetic slates 9 1 Pitched roofs 1 Clay Nothing should be entered on this sheet But you can view it to see how they are calculated 7 of 17 Calculating the major repair provisions Once the components are fully specified on the Components sheet the major repair provisions can be calculated on the MRPs sheet This would normally be done by the development officer appraising the scheme But it could also be done by the design team so as to review the major repair provisions required l A B c D E F G Enter the gross floor area of the scheme in C4 This should include the ET aa Major Repair Provisions circulation space on flats which is typically about 15 more than the 3 internal floor area This is used in calculating the reconstruction cost 3 Interest rate net of inflation 3 00 per squ are metre see below 4 Gross floor area of scheme sqm 3 Units 6 l 6 Default re
Download Pdf Manuals
Related Search