OPENING PAGE Welcome to the Disaster Impact Calculator using the ECLAC Methodology Page 1 of 132MENU 1 1.1 Direct damages 1.2 1.3 1.4 1.5 i. ii. iii. 23 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 3.10 4 4.1 4.2 5 Exit Read introduction Indirect damages Secondary effects or macro-economic impacts Direct and indirect impacts based on ECLAC methodology Philippine Study Brief info: Typhoons Unding, Violeta, Winnie & Yoyong Estimating Damages Caused in 2004 Using ECLAC Summary of Steps to Determine Total Impact of Disaster Read instructions Enter data Exchange rate Social Sector Infrastructure Agriculture Trade and Industry Tourism -Yield Loss Environment Foreign Assistance Tax Revenues GDP and GVA ratios Unit: In US dollars -Details -Summary View and print output Unit: In local currency -Details -SummaryINTRODUCTION Introduction Since February 2004, the United Nations Economic and Social Commission for Asia and the Pacific (UNESCAP) has implemented the project on "Improvement of Methodologies for Assessing the Socio-Economic Impact of Hydro-Meteorological Disasters" with technical support from the United Nations Economic Commission for Latin America and the Caribbean (ECLAC) and United National Development Programme (UNDP) Bureau for Crisis Prevention and Recovery (BCPR). The project involves adoption of those methodologies already developed in the region and supports a small number of pilot/demonstration assessments and presentation of results to national planning and development agencies in Asia. At present, the way countries gather data and estimate the damages of disasters is generally in terms of people affected, infrastructure and productive assets destroyed and production losses. On the people affected, the numbers of death, missing, injured and displaced are the usual indicators used. This is not surprising since this will determine the government action and relief operations that will be necessary. Similarly, appeals for assistance and donations from other sources are usually based on the number and immediate needs of the people affected. Page 3 of 132INTRODUCTION 1 The cost of stoppage of operations of certain vital firms for several days, weeks or months is not reflected. How much did the electric cooperative, water district, telecommunication companies, etc. lost during their non-operating period? Similarly, the income lost by the transport sector is not accounted for. How many transport vehicles were not able to ply their routes due to the destruction of roads and bridges? On the business side, reports do not indicate the forgone income of factories, groceries, stores, tourist facilities, etc. which make it difficult to assess the total disaster impact to the economy whether local or national. There are, generally three (3) ways by which disaster impacts are categorized and can be measured, and these are: Direct Damages. These include the physical damages to capital assets and social infrastructure like roads, bridges, buildings, equipment and other productive assets, as well as lost inventory of goods like agricultural products; finished goods; and raw materials for production, among others. Direct costs are generally termed as "stock". Read more... click the number "1". Infrastructure damages like buildings, roads, bridges, houses, etc. are quoted as the value of the asset lost or the cost of replacement or repair. It is not unusual also if some reports on damaged roads and bridges reflect only the initial needed amount for emergency repairs. The same is true for equipment and other productive assets like machineries, communications and power lines, irrigation canals, etc. On the other hand, needs of the victims and relief assistances extended are likewise reported, which are just appropriate for accountability and transparency. Other losses as well as the long term effects on the economy of disaster damages are appropriately included. For instance: Page 4 of 132INTRODUCTION 23 Indirect Damages. These include the costs due to the disruption to the normal flow of goods and services in the economy like reduced output, income, wages, etc. Indirect costs are generally termed as "flows". Read more... click the number "2". Secondary Effects. These are the short and long term impacts to the overall economy which can affect the socio-economic conditions of the population like prices, inflation, employment, trade balance, fiscal and monetary performance, debt burden and poverty incidence. Secondary effects are generally macro-economic in nature. Read more... click the number "3". The full appreciation of these impacts may lead to a better policy environment that will promote economically viable and sustainable disaster management practices.Page 5 of 132DIRECT DAMAGE Direct damages Direct damages can be inflicted on immovable assets, whether complete or partial destruction like buildings, roads, bridges, houses and other infrastructure as well as stock which includes final goods, goods in process, raw materials, spare parts and other similar factors of production. Such damages usually occur right at the time or just after the actual disaster. Included in this category are the total or partial destruction of physical infrastructure, economic installations like power, transportation and communication, machinery, equipment, damage to farmlands, irrigation systems including the destruction of crops ready for harvest. Quantifying direct damages basically follows a straight-forward approach as long as the damage assessor is familiar with the prevailing prices of reconstruction, rehabilitation, repair or replacement. Page 6 of 132INDIRECT DAMAGE Indirect Damages Disasters cause impacts that go beyond the direct damages to economic stock. Indirect losses essentially refer to the current value of goods and services that were and will not be produced or rendered over a time span due to the disaster. Such losses are economically termed as "flows". These effects are estimated up to the period of total recovery for the affected production capacity. Essentially, indirect losses result from the damages to production capacity and economic infrastructure. Also included are disaster-induced increases in financial outlays for the provision of essential services and reduced expected income. Examples of indirect effects are losses of future harvests due to flooding or volcanic eruption or prolonged droughts; losses in industrial production due to damage to factories and equipment or a resulting shortfall in access to raw materials; and greater transportation and communication costs. Disasters also produce some major indirect effects like human suffering, insecurity, psycho-social stress on victims, reduction of human capital, etc. These effects are very difficult to identify and quantify in a general context. For the purpose of this tool, such indirect damages will not be valued in monetary terms. Page 7 of 132Secondary Effects or Macro-economic Impacts i. Taking into account the direct and indirect effects, some important macro-economic should be looked into are those that have a bearing on: Growth in gross domestic product (GDP) like those that affect the productive manufacturing, services, power, transport, communications, etc. This will various supply chains for these sectors. Macro-economic effects are the changes caused by the disaster to the expected performance economy. Since they reflect the impacts of direct damages and indirect losses, secondary added to the two types of losses. Macro-economic effects must complement the assessment and indirect losses from a different perspective --that is from the economic vantage economy. It must be realized that a disaster may cause a great macro-economic effect provincial economy although it may have minimal macro-economic effects on the instance, an island province may be totally devastated by a typhoon but if its contribution may appear that the impact is negligible to the national economy. Quantification of macro-economic effects requires data input from various productive assessment, therefore, require the assistance of specialists in sectoral assessment statistical institution which can provide the data needed. If such data exist, assessment can be done not only for the national economy but also for disasters region, a province or municipality. To estimate the macro-economic effects of disasters, there must be a reliable forecast economic sectors/variables would have performed if the disaster did not occur. These available from economic planning ministries often on an annual projection. Such baseline for calculating the degree to which the disaster has disrupted or reduced that would have been achieved.ii. iii. iv. v. vi. Prices of commodities. Obviously, with the reduction in supply, prices of basic inflation and erode the value of income. Employment. The closure of factories, whether temporary or permanent will underemployment and reduce family income. Under such situation, unemployment inflation causes more strain on the family income and sometimes result in The current account balance. Exports may decline due to diminished production balance, tourism and other services that affect sources of foreign currency foreign obligations. This may also trigger higher interest rates that will result lower monetary reserves. Moreover, there will be a pressure on foreign exchange replacement will require importation. Public finances. Budget realignments may shift to less productive activities slower economic growth. Moreover, should government decide to float bonds interest rates may go up. Gross investment. Aside from the reduction of the value of total investment, cause potential investors to postpone or totall withdraw their investment projects profitability prospects. Projected investment growth may therefore decline.economic Impacts some important macro-economic effects of a disaster that those that affect the productive sectors like agriculture, communications, etc. This will include value-added along the disaster to the expected performance of the national damages and indirect losses, secondary effects must not be effects must complement the assessment on direct damages from the economic vantage point of the national or local a great macro-economic effect on a regional or macro-economic effects on the national economy. For by a typhoon but if its contribution to GDP is minimal, it economy. input from various productive sectors of the economy. Its specialists in sectoral assessment as well as an existing welldeveelope data needed. If such data exist, macro-economic economy but also for disasters affecting smaller areas or a there must be a reliable forecast of how each of the the disaster did not occur. These forecasts are usually annual projection. Such projections will serve as the has disrupted or reduced the macro-economic results reduction in supply, prices of basic goods may rise causing temporary or permanent will cause unemployment or Under such situation, unemployment that is coupled with income and sometimes result in migration. decline due to diminished production which affects trade sources of foreign currency to pay for imports and other higher interest rates that will result in higher indebtedness and be a pressure on foreign exchange reserves if the cost of to less productive activities which again can cause government decide to float bonds to finance reconstruction, the value of total investment, disaster damages may withdraw their investment projects due to reduced growth may therefore decline.DIRECT and INDIRECT IMPACTS I. PRIMARY CONSIDERATIONS Damages to agriculture, cattle raising and fishing * Agriculture production ready to be harvested * Stocked agricultural produce and grains * Losses in animal stock * Damages or destruction of fish farming * Loss of employment ponds and shrimp factories * Differential impact on women * Damages or destruction of fishing fleet * Reduced fishing * Repair or reconstruction costs of * Reduced yields in future crops agriculture, cattle farming and fishing infrastructure including tertiary level roads * Not planting of future crops Direct & indirect impacts based on ECLAC methodology The ECLAC methodology presented valuable methods in classifying and identifying direct and indirect damages and how they result in secondary impacts. The following are the major and salient features and classifications according to the ECLAC handbook. Direct Damages Indirect Damages Page 13 of 132DIRECT and INDIRECT IMPACTS II. OTHER CONSIDERATIONS Damages in water and sanitation * Fall of income due to decreased billing of supplying enterprises * Increase of reproduction work of rural women treatment plants * Repair costs of leakages in water distribution network * Repair costs of sanitary sewage network * Rehabilitation cost of served water processing plants wells * Repair or reconstruction costs of distribution pipes collection works trucks * Repair or reconstruction costs in water * Digging and equipment of emergency Direct Damages Indirect Damages * Repair or reconstruction costs in water * Increased costs of water supply by Page 14 of 132DIRECT and INDIRECT IMPACTS Damages to housing and human settlements * Repair or reconstruction of public buildings and facilities * Household furnishing and appliances * Cost of migration to families replacement * Reconstruction of destroyed housing * Relocation of housing in safe areas Direct Damages Indirect Damages * Repair of damaged housing * Temporary housing supply Page 15 of 132DIRECT and INDIRECT IMPACTS Damages in transport and communications * Rehabilitation costs of ports and airports reduction or cancellation Commerce, industry and services (stocks and inventories) * Differential impact on women * Losses in finished production * Repair or replacement cost of * Temporary employment losses equipment and machinery * Repair or reconstruction of infrastructure * Reduced production canals due to reduced water level in the face of drought Direct Damages Indirect Damages railway tracks * Income losses due to air transport * Income reduction in waterways and * Relocation costs for telecommunication * Repair or reconstruction cost of towers in poor condition * Replacement cost of automotive stock * Repair or reconstruction of roads * Increased transport costs due to the use and bridges of longer alternative routes or roads Direct Damages Indirect Damages Page 16 of 132DIRECT and INDIRECT IMPACTS Damages to tourism * Differential impact on women attractions * Unemployment furniture and tourism equipment * Cancelled future reservations and cost * Damages to beaches and other tourist of promotion campaigns * Repair or reconstruction costs of * Negative effect in linked activities * Repair or reconstruction costs of * Temporary fall in hotel occupancy and tourism infrastructure income of enterprises Direct Damages Indirect Damages Page 17 of 132DIRECT and INDIRECT IMPACTS Damages to the education and culture sectors * Repairs to schooling centers used as Damages to the health sector * Preventive campaign costs in the face of potential epidemics or infective diseases centers to safer grounds Damages to the environment * Replacement of equipment, furnishings and loss medicines and stocks * Relocation costs for moving health infrastructure: hospitals, health clinics, etc. medical attention Direct Damages Indirect Damages * Repair or reconstruction of health * Increased expenditure to provide heritage * Reduced income from damaged culture and historical centers (museums, etc.) replacement shelters for displaced population during * Rehabilitation of historical and cultural disaster * Rent of temporary facilities * Furnishings and educational materials' * Repair or reconstruction costs of * Delay in school year schooling facilities Direct Damages Indirect Damages Page 18 of 132DIRECT and INDIRECT IMPACTS Damages should likewise be assessed according to their impacts on women * Effect on gender relationships * Effect on gender relationships * Double burden on women * Double burden on women * Beach cleanup and replenishing Direct Damages Indirect Damages stabilization, protection against slippage * Cost of alternative water resources * Loss of environmental services * Repair costs of natural resources to their previous state: reforestation, land * Cleanup from spills of toxic materials Direct Damages Indirect Damages (estimated indirectly) Page 19 of 132PHILIPPINE STUDY Philippine Study (page 1 of 9) TYPHOONS UNDING, VIOLETA, WINNIE AND YOYONG CASE STUDY 1. INTRODUCTION The Typhoone Unding, Violeta, Winnie and Yoyong (UVWY) Case Study aims to facilitate the complete application of the template used in the Disaster Impact Calculator. The case study includes a brief description of the typhoons and a report on the total socio-economic impact they have caused. The template together with the detailed assessment of the UVWY case study will guide the users through the process of assessment in providing an initial estimate for similar events. It is expected that an initial estimate of socio-economic impacts would enable template users to identify key areas of assessment so that efforts could focus on areas and/or sectors where assistance and corrective measures are needed. It should be noted that several items and parameters included in the ECLAC methodology were not included in this study due to absence of data and/or the difficulty of quantifying their impacts and effects. There are the differential impacts of the typhoons on women and on the environment like biodiversity, among others. Page 20 of 132PHILIPPINE STUDY 2. CONTENTS OF THE CASE STUDY i. Brief information about the Typhoons Unding, Violeta, Winnie and Yoyong ii. Estimating the Damages Caused by the Philippine Typhoons in Late 2004 Using the ECLAC Methodology iii. Summary of Steps to Determine the Total Impact of Disaster The case study consists of the following components: After this study, several refinements were made to the rapid impact assessment tool. It will be further noted that several templates in the tool were improved for ease of use and more accurate valuation. For instance, damages on houses/dwellings were further classified into the types of housing materials they were made of and the percentage of damages inflicted into these various types of houses/dwellings. Also, several sectors were included in the input templates of the disaster impact calculator. These are intended to estimate the damages more accurately. Page 21 of 132PHILIPPINE STUDY Philippine Study (page 2 of 9) BRIEF INFORMATION ABOUT TYPHOONS UNDING, VIOLETA, WINNIE AND YOYONG extracted from "2004 Pacific Typhoon Season", see http://en.wikipedia.org/wiki/pacific_typhoon_season TYPHOON MUIFA (UNDING) The name Muifa is taken from the name "blossom". The disturbance that was to become Typhoon Muifa was noted early on November 14th when located 215 nm north of Palau. It became Tropical Depression 29W later that day and strengthened into a tropical storm early on the 15th when the center was 550 miles east-southeast of Manila, Philippines. PAGASA assigned the name Unding on the 14th as it passed the 135th meridian. On the 16th, the tropical cyclone started drifting north-northeast. Muifa turned back onto a west-northwest heading and intensified. It reached typhoon intensity on the 17th prior to beginning a two-day clockwise loop. Late on the 18th, Muifa's intensity peaked at 115 kts/130 mph still to the east of the Philippines. Muifa/Unding made landfall very late on the 19th near Naga City with maximum winds of 70 kts/80 mph. The system ambled across the Philippine Archipelago, dropping to tropical storm intensity on the afternoon of the 20th. On the 21st, Muifa regained typhoon intensity in the South China Sea. Now moving west-southwest, early on the 22nd Muifa re-strengthened into a 90-kt/105 mph typhoon 440 miles east of Ho Chi Minh City, Vietnam. Muifa held onto typhoon status until late on the 23rd when it again weakened to a tropical storm. On the 25th, Tropical Storm Muifa accelerated westward at a 21 kt/23 mph clip. By early on the 26th, a weakening Tropical Depression Muifa was located 250 nm south of Bangkok, Thailand. Later than day Muifa turned northward into an environment of increased wind shear and dissipated 120 nm south-southwest of Bangkok. Page 22 of 132PHILIPPINE STUDY The highest 24-hour rainfall amount in the Philippines was 246.4 nm in Catanduanes between midday of the 15th and 16th. The lowest pressure was at Naga City was 986.1 mb early on the 16th. Typhoon Muifa also had a destructive impact on Vietnam. The highest 24-hour rainfall amount reported was 251.5 nm at Prachuap Khirikhan between the afternoon of the 25th and 26th. Floods and landslides triggered by the typhoon killed 40 people and 40 more were reported missing. There were also many villages in the mountains which needed urgent relief but which could not be quickly reached. Hoi An, a World Heritage site, was hit by the flood, and more than 80 old houses were in danger of collapse. Page 23 of 132PHILIPPINE STUDY TROPICAL STORM MERBOK (VIOLETA) TROPICAL DEPRESSION (WINNIE) Merbok is the Malaysian word for the "spotted-necked dove". This is the first tropical cyclone recognized by the Japan Meteorological Agency, but not by the Joint Typhoon Warning Center, since Changmi in 2002. Tropical Storm Merbok started from a disturbance located in the Philippine Sea and was first recognized as Tropical Depression Violeta by PAGASA on November 22nd. Later that day, it developed into a tropical storm. Tropical Storm Merbok tracked slowly towards the northwest and made landfall south of Baer on the east coast of Luzon. The storm's intensity held steady at 35 kts/40 mph (its peak strength) as it ambled its way across the mountains of Luzon, finally emerging off the northwest coast late on the 23rd. By this time, Merbok had lost most or all of its deep convection, the remnants continuing slowly north-westwards before dissipating southwest of Taiwan. Tropical Storm Merbok added to the devastation caused by Typhoon Muifa/Unding in the Philippines. The heaviest rainfall in the Philippines from this cyclone was 185.2 nm at Casiguran between midday of the 22nd and 23rd. Tropical Depression Winnie was a large system which brought torrential rains to Luzon, resulting in deadly flashfloods and landslides. Winnie formed east of the central Philippines on the 27th of November. JMA and the Central Weather Bureau of Taiwan were the only other agencies classifying Winnie as a tropical depression. The system moved west-northwest over southeastern Luzon on the 29th. After moving well inland over Luzon, Winnie turned to a more north-northwesterly track up the west side of the island on the 30th when it was last located along the northwestern Luzon coast. Page 24 of 132PHILIPPINE STUDY SUPER TYPHOON NANMADOL (YOYONG) In the Philippines, it was reported that 1,404 people died primarily due to massive flashfloods and landslides in Quezon and Aurora Provinces triggered by the attendant heavy rains. The highest rainfall report from this system was 157.8 nm from Cabanatuan between midday that 29th and 30th. The name Nanmadol is from a famous ruin found on Pohmpei. Super Typhoon Nanmadol developed from a cluster of thunderstorms that was first noted early on November 28th located at 155 nm south-southwest of Pohnpei. It developed into a Tropical Depression 30W about 690 miles east-southeast of Yap, and into Tropical Storm Nanmadol by midday the 29th as it moved westward south of the subtropical ridge. Nanmadol continued to strengthen, reaching typhoon intensity late that day after passing south of Satawal. The storm's track curved to the west-northwest. Late on the 30th, the storm passed just north of Yap, bringing typhoon-force gusts and sustained tropical storm strength winds. The tropical cyclone reached its peak intensity of 130 kts/150 mph midday on the December 2nd, a super typhoon 220 miles east of Manila, Philippines. Upon reaching the Luzon coastline, Super Typhoon Nanmadol began to lose strength and was downgraded to typhoon status. Page 25 of 132PHILIPPINE STUDY Turning northwestward, Typhoon Nanmadol took roughly six hours to cross the island of Luzon, and by early on December 3rd had reemerged over water. The northwesterly turn weakened Nanmadol in the subtropical ridge before being lured away by a major shortwave trough. Nanmadol weakened markedly during the 3rd as it gradually veered more towards the north. The cloud pattern became increasingly asymmetrical sa Nanmadol moved east-northeastward across southern Taiwan before becoming extra tropical during the afternoon of the 4th. Nanmadol became the first known December tropical cyclone in the past 108 years to make landfall in the island. The remnants of Super Typhoon Nanmadol continued to rapidly move to the east-northeast and northeast and ultimately merged with another LOW, forming a powerful extra tropical cyclone which brough strong winds and led to unseasonably warm temperatured to Japan. Because Muifa, Merbok, Winnie and Nanmadol all occurred within a space of two weeks, the exact number of casualties and total cost of damages is difficult to determine. The maximum rain in the Philippines was 228.1 nm in Daet between midday on the 2nd and 3rd. In Taiwan, as much as 907 nm fell in Hualien county between early on the 3rd and 4th. Puluowan reported the total accumulation of 1,090 nm of rainfall during the 35-hour period ending on the afternoon of the 4th. In China, 106.3 nm of rain fell at Dachen Dao between the morning of the 3rd and 4th. In Taiwan, 2 deaths were reported, and agricultural losses were estimated to have been US$ 670 million New Taiwan dollars. Page 26 of 132PHILIPPINE STUDY Philippine Study (page 3 of 9) ESTIMATING THE DAMAGES CAUSED BY THE PHILIPPINE TYPHOONS IN LATE 2004 USING THE ECLAC METHODOLOGY BACKGROUND Starting 14 November 2004, four tropical cyclones in succession hit the shored of the Philippines and wrought massive destruction as each treaded the country one after the other, bringing strong winds and dumping heavy rains. A total of 9 regions were collectively affected by Typhoons Unding, Violeta, Winnie and Yoyong from mid-November to early December. The typhoons varied in intensity with the strongest --Typhoon Yoyong --blowing sustained winds of 185 kph and gustiness of up to 220 kph and the weakest --Typhoon Violeta --bringing sustained winds of 45 kph near the center. Page 27 of 132PHILIPPINE STUDY DIRECT DAMAGES Areas and Population Affected Table 1. Population Affected Regions Unding Violeta Winnie Yoyong Total CAR ---101,529 101,529 I ---9,621 9,621 II -13,853 1,803 650,207 665,863 III -85,608 696,961 371,121 1,153,690 NCR --11,068 26,286 37,354 IV 133,543 -135,059 107,191 375,793 V 625,100 -538 667,529 1,293,167 VI 222 ---222 VIII 180 --6,351 6,531 Total 759,045 99,461 845,429 1,939,835 3,643,770 As expected, the population adversely affected by the typhoons was positively correlated with the degree of strength of the typhoon. The weakest, Typhoon Violeta, affected only two regions located in the eastern and central portions of Luzon Island affecting a population of only 99,461. The strongest, Typhoon Yoyong, extended its destructive forces to 8 regions, affective a total of 1.9 million persons. In totality, the 4 typhoons caused difficulties to a population of 3.6 million over a 3-week span. Page 28 of 132PHILIPPINE STUDY Casualties Table 2. Casualties by Typhoon Regions Unding Violeta Winnie Yoyong Total Dead 71 31 893 73 1,068 Missing 69 17 443 24 553 Injured 160 187 648 168 1,163 Total 300 235 1,984 265 2,784 Interestingly, despite the fury and might of Typhoon Yoyong, the highest number of casualties was brought about by Typhoon Winnie. This may be attributed to the massive landslides caused by the latter in Region IV --Southern Tagalog Region --as heavy rains weakened the slopes of the upland terrains located in Quezon province. A total of 893 persons were killed, and scores of missing and injured persons were recorded as Typhoon Winnie trekked the southern part of Luzon entering the Bicol Region and exiting the Southern Tagalog Region. Page 29 of 132PHILIPPINE STUDY Philippine Study (page 4 of 9) Total Direct Damages Based on calculations using these assumptions, total damages to housing brought about by the typhoons amounted to Php 5 billion, over two-thirds of which were from totally damages houses. However, partially damages houses outnumbered totally damaged houses by a ratio of almost 3:1. Based largely on reports filed by members of the National Disaster Coordination Council (NDCC), a total of Php 11.3 billion in assets were lost due to Typhoons Unding, Violeta, Winnie and Yoyong. These were damages on housing, infrastructure, transportation, agriculture crops and facilities, school facilities, electric transmission and generation facilities, health care facilities and water facilities. Damage to housing units include ceilings and roofs that were torn off, walls that collapsed, and total destruction of houses due to strong winds, heavy rain, flooding, landslide, branches of trees falling and other typhoonrellate destructive effects. Department reports only provided information on the number of housing units that were totally damaged and partially damaged. In this study, the simple valuation used was by assuming replacement and repair costs, and that majority of the houses that were damaged were the most vulnerable low cost housing units. The costs are mainly based on the amount that individuals may borrow from commercial banks or government financial institutions for their low cost housing financial needs. This study assumed that partial damages to houses may be valued using the bank loans of Php 10,000 for low cost housing repairs and Php 60,000 for putting up a low cost house or replacing a housing unit. Page 30 of 132PHILIPPINE STUDY Table 3. Houses Damaged Whole Partial Whole Partial I 78 783 861 4,680,000 7,830,000 12,510,000 II 2,411 14,101 16,512 144,660,000 141,010,000 285,670,000 CAR 358 1,350 1,708 21,480,000 13,500,000 34,980,000 III 4,116 9,981 14,097 246,960,000 99,810,000 346,770,000 NCR 2 7 9 120,000 70,000 190,000 IV 23,407 25,161 48,568 1,404,420,000 251,610,000 1,656,030,000 V 26,191 115,347 141,538 1,571,460,000 1,153,470,000 2,724,930,000 VI 27 9 36 1,620,000 90,000 1,710,000 VIII 1 514 515 60,000 5,140,000 5,200,000 Total 56,591 167,253 223,844 3,395,460,000 1,672,530,000 5,067,990,000 It is useful to note that the Department of Agriculture's (DA) methodology in assessing damage to agriculture does not delineate direct and indirect losses unlike the ECLAC methodology. For the DA and for purposes of its reports, all damages are considered direct damages. For this study, indirect damages were estimated by making use of several assumptions which is discussed further in another section of this study. Region Houses Damaged Total Amount of Damage Total Information from the Department of Public Works showed that infrastructure damages caused by heavy flow of water and landslides include impairment to bridges, national highways, provincial roads, municipal roads, and military installations. Damages to agriculture were on harvested or ready-to-be-harvested commodities such as rice, corn, vegetables and fruits, legumes and root crops, livestock, fish, and other aquatic food. Likewise, damages to assets such as irrigation facilities and equipment were counted in the reports. Page 31 of 132PHILIPPINE STUDY Health facilities such as hospitals, regional health units and barangay health units were damaged by the typhoons. Water and toilet facilities, drainage systems and solid waste collection and disposal were also affected. It is useful to note that the Department of Agriculture's (DA) methodology in assessing damage to agriculture does not delineate direct and indirect losses unlike the ECLAC methodology. For the DA and for purposes of its reports, all damages are considered direct damages. For this study, indirect damages were estimated by making use of several assumptions which is discussed further in another section of this study. The DA's conceptual treatment of damages and their methodology for estimating damages are very well grounded. The DA makes use of information such as the amount of rain, wind speed, amount and duration of flooding in a certain area, among others and compares these with the vulnerability of crops in particular stages of their life cycles. With this information, the area or yield loss is determined. The amount of loss is then acquired by getting the average inputs per particular variety and stage of the crop. School facilities were also hit by the typhoons. Harsh winds and rain damaged buildings, equipment and furniture including desks and arm chairs as well as textbooks. In addition, schools were used as evacuation and relocation centers thereby disrupting classes even after the typhoons. Damages to transmission facilities include towers that broke, downed conductors, damaged transmission line and accessories, damaged perimeter fences, lighting fixtures in transmission centers, and toppled or washed out poles. Meanwhile, damages to electric cooperatives included damaged lines, broken or leaning poles, inaccessible backbone lines, and substations submerged in mud. Page 32 of 132PHILIPPINE STUDY Water facilities, in particular the Umiray Dam, were heavily damaged. Heavy downpour caused floods leading to the clogging of the conveyance channel at the intake with big boulders, logs, and other debris. Likewise, the 13-km. tunnel of the facility was clogged by boulders and debris. a 5.5 km. access road was closed and became impassable due to 31 landslides along the way. All bunkhouses in the area were washed out. And a concrete bridge leading to the tunnel was completely washed out. Summing up the figures from each sector shows that direct damages caused by Typhoons Unding, Violeta, Winnie and Yoyong amounted to about Php 11.3 billion. By order of magnitude, damages to housing were the biggest followed by agricultural crops and facilities, and infrastructure as shown in Table 4. Page 33 of 132PHILIPPINE STUDY Table 4. Cost of Damage to Assets/Properties (in Php) 3,078,690,000 31,140,000 659,120,000 1,299,040,000 5,067,990,000 358,156,000 71,635,500 696,905,455 560,829,323 1,687,526,278 1,125,000 3,691,830,000 461,846,000 26,580,000 34,300,000 221,468 72,900,000 300,000,000 3,463,426,000 11,317,738,746 Health facilities Water facilities Total School facilities Transmission facilities 7,720,000 Electric facilities Housing Infrastructure Transportation Agri. crops & facilities Asset Unding Violeta Winnie Yoyong Amount Page 34 of 132PHILIPPINE STUDY Philippine Study (page 5 of 9) INDIRECT DAMAGES Agriculture Had this study relied on agency reports alone, indirect losses would have been minimal at best. Instead, extra effort was exerted to consider the limitations faced by agencies in estimating losses. Assumptions were made to come up with reasonbale estimates of indirect losses. The Department of Agriculture (DA) implements a comprehensive methodology in assessing the damages to crops, livestock and fishery incurred by farmers and fishermen during disasters. For rice and corn, information such as type and variety, growth stage, hectares of area planted, wind speed, amount of rainfall, among others is gathered to determine the degree/amount of salvageable or recoverable amount. The methodology also incorporates some assumptions on average crop productivity and inputs costs. This set of information is then used to compute the volume and value of production loss as a result of the disaster. However, since this information is not available for other crops, this study makes several assumptions and adjustments to make the information presented herein compatible with the ECLAC methodology. Page 35 of 132PHILIPPINE STUDY In computing the damage to crops, information was gathered on the growth stage of the crops, the area devoted to specific crops, the wind speed and the amount of flooding in specific areas. Assumptions and adjustments were made on input costs and labor costs. But since the DA report only provides information on the area for rice and corn and input costs per hectare for the same, it was assumed that one-third of the total reported damage for other crops are indirect losses. However, for rice and corn, the information on the area affected was used along with agency estimates of input costs per hectare for the respective crops. Multiplying the input cost per hectare with the number of hectares that were affected yielded estimates of indirect losses. Based on these assumptions, calculations showed that indirect damage to agriculture in terms of investment and labor cost losses on crops not ready to be harvested amounted to Php 1.1 billion. In computing the indirect damage to crops, it was assumed that reports from the DA included direct and indirect damages. To simplify the valuation procedure, it was further assumed that the total amount of direct damage specified in the report is only 50 percent of the total amount indicated. This procedure provided margin to estimate indirect losses without exceeding the amount indicated in the reports. The rationale for this step is that direct damages conceptually represent the maximum amount of losses that may be credited to a particular crop since direct damages under the ECLAC methodology are applied only to crops which are already harvested or those which are ready for harvesting. Page 36 of 132PHILIPPINE STUDY Table 5. Crops not ready to be harvested Reports Direct Damage Units (hectares) Input cost/unit Total Input costs (in Php) Rice 748,790,000 374,395,000 19,446 13,001 252,813,591 Corn 1,095,990,000 547,995,000 57,124 7,503 402,896,863 Vegetables 564,970,000 282,485,000 188,323,333 Onion 109,240,000 54,620,000 36,413,333 Mango 155,180,000 77,590,000 51,726,667 Banana 229,420,000 114,710,000 76,473,333 Other crops 30,580,000 15,290,000 10,193,333 Abaca 17,130,000 8,565,000 5,710,000 Coconut 383,860,000 19,193,000 127,953,333 Total 3,335,160,000 1,494,843,000 1,152,503,786 A breakdown of estimates is shown in the table below. With this, the total amount of indirect losses to agriculture increased to Php 3 billion. In addition to crop losses, the DA estimate that a total of Php 1.9 billion in funding is needed to restore the growth of the agriculture sector of the regions affected to its original path prior to the typhoons. Page 37 of 132PHILIPPINE STUDY Table 6. Mitigation/prevention works and emergency expenditures Amount (in Php) 1,400,000,000 315,600,000 561,000,000 66,400,000 46,400,000 20,000,000 353,600,000 30,000,000 22,600,000 2,433,600,000 Irrigation Restoration/Rehabilitation of Damaged Buildings and Facilities Management of Rehabilitation Implementation Total Compensatory Productivity Program --Corn --Vegetables Agri-fishery Livelihood Rehabilitation Type of Expenditure Subsidy to cover production losses --Rice and Corn Page 38 of 132PHILIPPINE STUDY Philippine Study (page 6 of 9) Industry Manufacturing Agencies reported that the series of typhoons knocked-out the supply of electricity in the affected regions for a number of days. No report on the impact of blackouts on the manufacturing sector was filed simply because there is no agency mandated to gather information on the amount of damages in the private sector, most especially the manufacturing sector. Agencies reported that the series of typhoons knocked-out the supply of electricity in the affected regions for a number of days. No report on the impact of blackouts on the manufacturing sector was filed simply because there is no agency mandated to gather information on the amount of damages in the private sector, most especially the manufacturing sector. To incorporate the manifacturing losses due to power supply loss, it was assumed that firms located in the Philippine Economic Zone Authority (PEZA) in the regions affected by the typhoons were not able to conduct regular production activities as power supply was not enough. Though these firms have back-up power supply units, power generators can only hold maximum capacity production for a limited period. As a result of the power supply interruption, manufacturing firms limited its production or even closed for a number of days until power supply was restored. It is assumed that four production days were lost due to power interruption. Compunding the loss is the foreign exchange loss as firms located in PEZA are mostly export firms. Page 39 of 132PHILIPPINE STUDY Table 7. Production losses (for export) No. of days w/o operation Average income per month Loss (in Php) PEZA firms 4 4,813,836,000 19,255,344,000 Total 19,255,344,000 Electricity and Water Table 8. Generation and Distribution Losses Multiplying the number of days without production by the average income of PEZA firms converted into Philippine pesos, it was estimated that a total of Php 19.2 billion were lost during the typhoons. To calculate indorect losses on utilities, the information on the extent of brownouts and the dependence of water stations proved useful. Reports showed that certain electric coops in particular regions suffered downtime as long as one month until power was restored. However, most of the electric coops were not able to supply power only for 2-6 days. Along with the power interruption, water was also affected. Information on the length of service interruption time for utilities multiplied with the average revenue per month of electric coops and water districts estimates the losses at Php 2.1 billion due to typhoons. In addition to these damages, the Metropolitan Waterworks and Sewerage System reported than an additional Php 1.5 billion in mitigation expenses is needed to strengthen the Umiray-Angat Dam facilities and make it structurally stronger than it was before the typhoons struck. Page 40 of 132PHILIPPINE STUDY Number of electric coops Hrs. of Interrupted Service Average revenue per month Loss (in Php) Electric cooperatives --Region I 6 48 33,000,000 13,200,000 --Region II 8 144 33,000,000 52,800,000 --CAR 5 48 33,000,000 11,000,000 --Region III * 13 144 33,000,000 110,000,000 --NCR 1 96 12,303,083,333 1,640,411,111 --Region IV-A * 5 144 33,000,000 81,400,000 --Region IV-B 7 144 33,000,000 46,200,000 --Region V 11 144 33,000,000 72,600,000 --Region VI 10 48 33,000,000 22,000,000 --Region VIII 11 96 33,000,000 48,400,000 Total 2,098,011,111 * One electric coop in Region III and two coops in Region IV-A experienced 1 month of downtime Page 41 of 132PHILIPPINE STUDY Table 9. Water Service Losses Days of Interrupted Service Average revenue per month Loss (in Php) MWSS MWC 1 878,000 878,000 MWSI 1 225,067 225,067 Water Districts 1 881,183 881,183 --NCR 7 492,333 3,446,331 Total 5,430,581 Table 10. Additional Mitigation Costs (in Php) Loss (in Php) 1,500,000,000 1,500,000,000 Type of Expenditure Umiray Angat Dam facilities --mitigation works Total Page 42 of 132PHILIPPINE STUDY Philippine Study (page 7 of 9) Services Transport Similar to the case of manufaturing, no information on indirect losses was gathered on the effects of the typhoons on local transportation. Instead, reports were limited to the number of transportation vehicles that were lost or damaged during the typhoons. To fill in the gap, research was made on the number of air flights that were cancelled during the height of the typhoons. Furthermore, information was gathered on the number of land and sea vehicles that suspended their daily trips. Additional assumptions were made on the average income per trip by multiplying the number of passengers for each type of craft with the trip fares. Multiplying the number of cancelled trips for each type of land, sea and aircraft that were affected with their corresponding average income per trip gives Php 163 million as the amount lost due to the cancellation of trips or services due to the typhoons. Page 43 of 132PHILIPPINE STUDY Table 11. Service Losses/Trips Cancelled Number Ave. income per trip Loss (in Php) 41,650,000 39 500,000 19,500,000 21 350,000 7,350,000 32 400,000 12,800,000 12 100,000 1,200,000 8 100,000 800,000 10,000 7,000 70,000,000 25,000 1,500 37,500,000 5,000 14,182,800 4,582,800 12 225,000 2,700,000 24 60,000 1,440,000 36 7,500 270,000 48 3,600 172,800 48 100,000 4,800,000 48 100,000 4,800,000 163,332,800 --Sorsogon Port Total ** Batangas-Occ. Mindoro (Calapan)-slow ** Batangas-Occ. Mindoro (Calapan)-fast ** Batangas-Or. Mindoro --Catanduanes Port Jeepney trips cancelled Sea craft trips cancelled --Batangas Port ** Batangas-Occ. Mindoro (San Jose) --Cebu Pacific --Asian Spirit --SEAir Bus trips cancelled Flights cancelled --PAL --Air Philippines Page 44 of 132PHILIPPINE STUDY Telecommunications Table 12. Telephone Service Losses Days of interrupted service No. of subscribers affected Ave. income per month Loss (in Php) Region II 30 26,939 21,551,200 21,551,200 CAR 30 34,713 28,570,400 28,570,400 Region III 30 281,842 225,473,600 225,473,600 Region IV 45 588,688 470,950,400 706,425,600 Region V 30 72,647 58,117,600 58,117,600 Region VIII 7 27,737 22,189,600 5,177,573 Total 1,045,315,973 Aside from the obvious direct damages to cables and poles, an effort was made to estimate the indirect losses for telecommunication despite the lack of information provided by the agencies. Reseach was made on the number of subscribers by each carrier per region. Furthermore, a conservative assumption that each subscriber pays the basic residential line cost of Php 800/month was applied. Multiplying the number of subscribers with the average cost per line gives an estimate of the average income by the telecommunication companies per region per month. Adjusting this value to a daily income basis and multiplying this with the number of days of telecommunication service downtime gathered from reports and from the assumption that telecommunication services are directly related to power supply gives a value of Php 1 billion. This is the estimated amount lost due to telecommunication service interruption. Page 45 of 132PHILIPPINE STUDY Government and Private Services Table 13. Emergency Costs Amount (in Php) 170,000 (134,125,648) (206,145,902) (340,101,550) Government services Service losses* Total Emergency assistance Private services Emergency assistance For the duration of the typhoons and immediately thereafter the government provided immediate emergency assistance in the form of rescue operations, relocation assistance, relief goods, and medicine, among others. This represented emergency costs on the part of the government. However, it should be noted that the amount allotted for these assistance activities would not have been disbursed had the typhoon not occurred since this was sourced from the government's funds budgeted mainly for calamities. In assessing the indirect loss, it is important to note that there is no opportunity cost associated with the use of these funds. Thus, these expenses can be considered as gains to every local area/region's economy. The private sector also provided emergency assistance. To simplify the treatment of this assistance, it was also assumed that there is no opportunity costs associated with the use of private sector funds, i.e., the private sector also allots a portion of their funds for welfare and altruistic activities each year. Thus, this amount cannot be considered as a loss to the economy. Type of Expenditure Page 46 of 132PHILIPPINE STUDY Philippine Study (page 8 of 9) MACROECONOMIC IMPACT Table 14. Loss in Gross Domestic Product Gross Value GVA Ratio GVA Nominal Agriculture 3,052,503,787 0.72 2,199,218,641 Manufacturing 19,255,344,000 0.32 6,201,406,985 Utilities 3,603,441,694 0.54 1,948,460,156 Transpo., Communication 1,208,648,773 0.49 594,069,097 Private Services (206,145,902) 0.55 (112,571,502) Government Services (133,955,648) 0.69 (92,454,631) GRDP 26,739,836,705 10,738,128,746 Table 15. Gross Regional Domestic Product 2004 From the estimated indirect damages, the corresponding loss in the Gross Domestic Product was computer using GVA ratios derived from the 1994 Input-Output Accounts. The resulting figures were then multiplied with the implicit price index for 2004 to arrive at constant 1985 values. Based on the calculations made, the aggregate damage brought about by Typhoons Unding, Violeta, Winnie and Yoyong shaved off 0.24 percentage points off the growth of the Philippine economy in 2004. Had the series of typhoons not occurred or had they not passed the Philippines, the real GDP growth would have been 6.26 percent instead of only 6.03 percent in 2004. Page 47 of 132PHILIPPINE STUDY Constant 1985 Prices (in Php) 1,145,798,630 6.03 1,148,348,204,885 6.26 (0.24) Fiscal Balance --growth rate (in percent) Difference Tax elasticity is a method used to roughly estimate the amount of taxes that are lost given a decrease in GDP. It is tax revenue growth divided by nominal gross domestic product growth, where tax revenues include both direct and indirect taxes collected by the government, i.e., tax elasticity = tax revenues growth rate /nominal GDP growth rate. Multiplying this with GDP losses, which are the indirect losses, we can estimate the forgone revenues due to the typhoons. Based on the national tax effort ratio, Php 5 billion in revenues is lost for every one percentage point decline in GDP growth. Using this as benchmark in estimating the loss in tax revenues, together with the share of the affected regions in the nation's income, approximatelyy Php 894 million in tax revenues was lost due to the destruction brought about by Typhoons Unding, Violeta, Winnie and Yoyong to the economy. GRDP with Typhoons --growth rate (in percent) GRDP without Typhoons Page 48 of 132PHILIPPINE STUDY TOTAL DAMAGES Table 16. Damages Amount (in Php) Amount (in US$) Direct damages 11,317,738,746 201,958,505 Indirect losses 27,959,328,024 489,918,046 Total damages 39,277,066,770 700,876,551 --% of GDP 0.80 Summing up direct and indorect damages (including lost revenues), an estimated Php 39 billion or US$ 691 million in damages was brought about by four typhoons, equivalent to 0.8 percent of the gross domestic product in 2004. Page 49 of 132PHILIPPINE STUDY Philippine Study (page 9 of 9) SUMMARY OF THE STUDY 1. 2. 3. 4. 5. Indirect damages for agriculture, trade and industry, tourism and other services were then multiplied to their corresponding Gross Value Added ratios derived from National Input-Output Accounts The resulting losses, expressed in nominal GVA, were then adjusted for inflation using a price deflator. The losses are then summed up and expressed in terms of percentage point loss in the gross domestic product (GDP) growth rate. Upon determination of the percentage point/s taken away from the GDP, the potential tax revenue loss per percentage point reduction in GDP was then calculated through the use of a tax elasticity. This study was done using the ECLAC methodology for estimating the socio-economic and environmental effects of disasters, which incorporated not only the usual direct damages but also the equally important indirect damages resulting from the disaster. In summing up the total impact of the series of typhoons, the following steps were undertaken following the ECLAC principles on damage assessment: Direct damages were assessed using cost of repair or replacement cost, as the case may be, for the tangible assets or stocks. Indirect damages were estimated using the principle of opportunity cost that the agents in the economy incurred due to the disruption of economic activities. Page 50 of 132PHILIPPINE STUDY 6. REFINEMENTS MADE AFTER THE STUDY After this study, several refinements were made to the rapid impact assessment tool. It may be noted that several templates were improved to facilitate easier encoding of inputs and more accurate valuation. For instance, damages on houses/dwellings were further classified into the types of housing materials they were made of and the percentage of damages inflicted into these various types of houses/dwellings. Indirect damages on major crops, such as paddy rice and corn, were derived using disaster damage matrixes provided by the Philippines' Department of Agriculture. These damage matrixes made use of information such as the typhoon's wind velocity, length of exposure of crops to such wind speed, and days of submergence to flood, among others, to compute the average weighted yield loss per hectare of crop. The total damages and losses to the economy were then summed up. It is useful to note that the GVA ratios and the amount of tax revenue losses per percentage point reduction in GDP (i.e., tax elasticity) may differ from one country to another. Furthermore, these values may change over time depending on the structure and performance of the economy. Page 51 of 132INSTRUCTIONS Instructions How to use the Disaster Calculator? First of all, make sure you have an extra copy of this file backed-up for future use. To create a back-up file: click FILE, SAVE AS, enter desired filename then SAVE. Always RETURN TO MENU to get an overview of this entire tool. The link is always found at the top of each page. Another option is to click the icons below each page to return to PREVIOUS page; go back to MENU; e-mail comments or questions; or proceed to NEXT page. Page 52 of 132INSTRUCTIONS How to enter data? Users can enter data in Sections 3.1 to 3.9 You can only enter data in yellow shaded cells. The rest of the cells are locked to avoid accidental deletion. Most of the cells require numbers. In some instances, users are allowed to add items or texts in the tables. If necessary, add rows to the appropriate tables. If not sure, do not hesitate to send us an e-mail by clicking How to print? Most of the pages here are already in print-ready format. Just click FILE, PRINT. However, if rows were added to one or more tables, please adjust the tables as necessary. If not sure, e-mail us. How to protect /unprotect sheets /format the file? This tool is password protected. The password is disaster. Click TOOLS, PROTECTION. You can view how this tool was done or change parameters to fit your country context. If not sure, e-mail us. Page 53 of 132EXCHANGE RATE Enter data: EXCHANGE RATE Present Year Previous Year 50.00 54.20 Local Currency per US dollar Average exchange rate Page 54 of 132SOCIAL SECTOR (data entry) Enter data: SOCIAL SECTOR Affected Population Direct loss Dead Missing Injured Displaced Families 300 Persons 1,068 553 1,163 -Women 600 299 500 Housing and Human settlements Direct loss Number/Unit Full Cost % of Damage Partially Damaged Hut/Cottage Made of Light Non-Durable Materials With Thatched Roof 200.0 3,573,245 65 One-Storey Wooden House With Thatched Roof 123.0 5,346,778 54 Two-Storey Wooden House With Thatched Roof 455.0 346,424 76 One-Storey Wooden House With Galvanized Iron Roof 888.0 564,565 34 Two-Storey Wooden House With Galvanized Iron Roof 442.0 4,364 54 One-Storey Semi-Concrete House With Galvanized Iron Roof 125.0 54,354 34 Two-Storey Semi-Concrete House With Galvanized Iron Roof 589.0 543,555 98 One-Storey Concrete House With Galvanized Iron Roof 692.0 646,878 45 Two-Storey Concrete House With Galvanized Iron Roof 937.0 6,456,578 54 Townhouses 953.0 46,456,542 67 Mansions 704.0 56,456 34 Others Subtotal 6,108 Population affected Housing Page 55 of 132SOCIAL SECTOR (data entry) Number Full Cost Amount Hut/Cottage Made of Light Non-Durable Materials With Thatched Roof 5,355.0 646,566 3,462,360,930 One-Storey Wooden House With Thatched Roof 45.0 654,656 29,459,520 Two-Storey Wooden House With Thatched Roof 536.0 64,566 34,607,376 One-Storey Wooden House With Galvanized Iron Roof 5,354.0 435,345 2,330,837,130 Two-Storey Wooden House With Galvanized Iron Roof 7,657.0 53,455 409,304,935 One-Storey Semi-Concrete House With Galvanized Iron Roof 4,545.0 87,876 399,396,420 Two-Storey Semi-Concrete House With Galvanized Iron Roof 5,355.0 464,654 2,488,222,170 One-Storey Concrete House With Galvanized Iron Roof 546.0 64,677 35,313,642 Two-Storey Concrete House With Galvanized Iron Roof 6,546.0 8,758,788 57,335,026,248 Townhouses 65,656.0 54,656,546 ############# Mansions 5,466.0 435,555 2,380,743,630 Others 0 Subtotal 107,061 ############# Number Replacement Cost/Unit Chairs 64,666.0 500 32,333,000 Beds 4,535.0 1,000 4,535,000 Tables 3,535.0 800 2,828,000 Cabinets 23,424.0 2,000 46,848,000 Stove 53,455.0 800 42,764,000 Refrigerator 64,645.0 4,000 258,580,000 Subtotal 214,260.0 387,888,000 Totally damaged Housing Appliances/Furniture/Equipment Totally damaged Page 56 of 132SOCIAL SECTOR (data entry) Number Repair Cost /Unit Chairs 545.0 500 272,500 Beds 5,345.0 1,000 5,345,000 Tables 75,676.0 800 60,540,800 Cabinets 4,656.0 2,000 9,312,000 Stove 6,456.0 800 5,164,800 Refrigerator 86.0 4,000 344,000 Subtotal 92,764 80,979,100 Education and culture Direct loss Number/Unit Replacement Cost/Unit Totally damaged Concrete 54.0 20,000 1080000 Semi concrete 34.0 15,000 510000 Light material 76.0 10,000 760000 Subtotal 164.0 2350000 Number/Unit Repair Cost/Unit Partially damaged Concrete 65.0 15,000 975000 Semi concrete 87.0 12,000 1044000 Light material 23.0 11,000 253000 Subtotal 175.0 2272000 School buildings School buildings Appliances/Furniture/Equipment Partially damaged Page 57 of 132SOCIAL SECTOR (data entry) Number Price per unit Totally damaged Chairs 4,545.0 500 2272500 Tables 5,435.0 1,000 5435000 Books 2,334.0 400 933600 Other equipment 765.0 4,000 3060000 Subtotal 13,079 11701100 Health sector Direct loss Number/Unit Replacement Cost/Unit Totally damaged Concrete 645.0 20,000.00 12,900,000.00 Semi concrete 545.0 18,000.00 9,810,000.00 Light material 423.0 17,000.00 7,191,000.00 Subtotal 1,613.0 29,901,000.00 Partially damaged Concrete 986.0 20,000.00 19,720,000.00 Semi concrete 676.0 18,000.00 12,168,000.00 Light material 645.0 17,000.00 10,965,000.00 Subtotal 2,307 42,853,000.00 Number Price per unit Totally damaged Hospital beds 890.0 10,000 8900000 Hospital equipment 598.0 60,000 35880000 Other equipment 789.0 50,000 39450000 Subtotal 2,277 84230000 School equipment Hospitals and health care units Health care facilities/equipment Page 58 of 132SOCIAL SECTOR (data entry) Housing and Health sector Amount 56,773 87,555 907,778 234,886 Subtotal 1,286,992 Amount 345,799 453,457 Subtotal 799256.00 Type of Expenditure Emergency relief Indirect losses Housing Others Search and rescue Emergency housing Others Insurance claims Page 59 of 132INFRASTRUCTURE (data entry) Enter data: INFRASTRUCTURE Energy Direct loss Units Replacement Cost/Unit Totally Damaged Buildings 235.0 1,049,898 246726030 Generation Equipment 543.0 565,477 307054011 Transmission Poles 655.0 346,565 227000075 Transmission Wires 342.0 646,787 221201154 Other Power Structure 766.0 435,645 333704070 Subtota l 2,541.0 1335685340 Units Repair Cost/Unit Partially Damaged Buildings 235.0 1,049,898 246726030 Generation Equipment 543.0 565,477 307054011 Transmission Poles 655.0 346,565 227000075 Transmission Wires 342.0 646,787 221201154 Other Power Structure 766.0 435,645 333704070 Subtotal 2541 1335685340 Energy Energy Page 60 of 132INFRASTRUCTURE (data entry) Drinking Water and Sanitation Direct loss Units Replacement Cost/Unit Totally Damaged Buildings 453.0 436,456 197714568 Water facilities 675.0 53,555 36149625 Water distribution 645.0 5,355 3453975 Flood Control Dikes 34.0 3,453,454 117417436 Flood Control Spillways 65.0 756,777 49190505 Other water supply structures 0 Subtota l 1,872.0 403926109 Units Repair Cost/Unit Partially Damaged Buildings 453.0 436,456 197714568 Water facilities 675.0 53,555 36149625 Water distribution 645.0 5,355 3453975 Flood Control Dikes 34.0 3,453,454 117417436 Flood Control Spillways 65.0 756,777 49190505 Other water supply structures 0 Subtotal 1872 403926109 Drinking Water and Sanitation Drinking Water and Sanitation Page 61 of 132INFRASTRUCTURE (data entry) Transportation and Communication Direct loss Units Replacement Cost/Unit Vehicles Totally Damaged 377 377000000 Land vehicles 123.0 1,000,000 123000000 Sea vehicles 34.0 1,000,000 34000000 Air vehicles 7.0 1,000,000 7000000 Other vehicles 213.0 1,000,000 213000000 Partially Damaged 377.0 377000000 Land vehicles 123.0 1,000,000 123000000 Sea vehicles 34.0 1,000,000 34000000 Air vehicles 7.0 1,000,000 7000000 Other vehicles 213.0 1,000,000 213000000 Units Replacement Cost/Unit Ports and Terminals Totally Damaged 0 0 Ports --0 Airports --0 Land transportation terminals --0 Other transport structures --0 Partially Damaged 4.0 600000 Ports 1.0 100,000 100000 Airports 1.0 200,000 200000 Land transportation terminals 1.0 200,000 200000 Other transport structures 1.0 100,000 100000 Transportation Transportation Page 62 of 132INFRASTRUCTURE (data entry) Units Replacement Cost/Unit Roads Totally Damaged 0 0 Concrete Road --0 Paved Road --0 Rough Road --0 Other Types --0 Partially Damaged 10.0 10000000 Concrete Road 1.0 1,000,000 1000000 Paved Road 2.0 1,000,000 2000000 Rough Road 3.0 1,000,000 3000000 Other Types 4.0 1,000,000 4000000 Units Replacement Cost/Unit Bridges Totally Damaged 0 0 Concrete --0 Semi-concrete --0 Wooden --0 Other Types --0 Partially Damaged 12.0 12000000 Concrete 5.0 1,000,000 5000000 Semi-concrete 4.0 1,000,000 4000000 Wooden 2.0 1,000,000 2000000 Other Types 1.0 1,000,000 1000000 Transportation Transportation Page 63 of 132INFRASTRUCTURE (data entry) Units Replacement Cost/Unit Totally Damaged --0 --0 --0 Partially Damaged 2.0 500,000 1000000 2.0 500,000 1000000 3.0 500,000 1500000 Subtotal 7 3500000 Telecommunications equipment Communication Telecommunications equipment Other telecommunication structures Telecommunications towers Telecommunications towers Other telecommunication structures Page 64 of 132INFRASTRUCTURE (data entry) Indirect loss Days of interrupted production Monthly income Electric power producers 10.0 2,000,000 20000000 Electric power distributors 10.0 2,500,000 25000000 Subtotal 45000000 Days of interrupted production Monthly income Water supply producers 12.0 780,000 9360000 Sanitation service providers 12.0 780,000 9360000 Subtotal 18720000 Number of trips cancelled Income per trip Land Transportation 8.0 50,000 400000 Water Transportation 8.0 50,000 400000 Air Transportation 8.0 50,000 400000 Subtotal 1200000 Days of interrupted production Monthly income 4.0 900,000 3600000 5.0 900,000 4500000 6.0 900,000 5400000 2.0 900,000 1800000 Subtotal 15300000 Radio stationsTransportation Communication Energy Drinking Water and Sanitation Telephone service providers Cable TV providers Non-Cable TV stations Page 65 of 132AGRICULTURE (data entry) Enter data: AGRICULTURE SECTOR Direct loss Volume Price per volume Paddy Rice 76 5,000.00 380,000 Corn 54 5,000.00 270,000.00 Vegetables 22 5,000.00 110,000.00 Onion 14 5,000.00 70,000.00 Mango 23 5,000.00 115,000.00 Banana 52 5,000.00 260,000.00 Other crops 45 5,000.00 225,000.00 Abaca 87 5,000.00 435,000.00 Coconut 98 5,000.00 490,000.00 Others 67 5,000.00 335,000.00 Cows 34 10,000.00 340,000.00 Water Buffalo 65 10,000.00 650,000.00 Goat 95 3,000.00 285,000.00 Swine/Pigs 25 7,000.00 175,000.00 Poultry 54 100.00 5,400.00 Poultry products/Eggs 87 100.00 8,700.00 Others 12 500.00 6,000.00 Tilapia 56 5,000.00 280,000.00 Milkfish 32 5,000.00 160,000.00 Tuna 23 5,000.00 115,000.00 Shrimp 45 5,000.00 225,000.00 Carrageenan 34 5,000.00 170,000.00 Other marine products 12 5,000.00 60,000.00 Forestry Lumber 76 15,000.00 1,140,000.00 Other Forest products 54 15,000.00 810,000.00 Subtotal 7,120,100.00 Crops Livestock Fishery Agriculture products harvested Page 66 of 132AGRICULTURE (data entry) Units/Number Replacement Cost/Unit Totally Damaged Irrigation facilities 56 1,000,000.00 56000000.00 Post harvest facilities 43 1,000,000.00 43000000.00 Others 87 1,000,000.00 87000000.00 Machinery & Equipment Tractors 23 1,000,000.00 23000000.00 Threshers 45 1,000,000.00 45000000.00 Rice dryers 54 1,000,000.00 54000000.00 Plows 76 1,000,000.00 76000000.00 Other Farm equipment 34 1,000,000.00 34000000.00 Fishing fleet/boats 23 1,000,000.00 23000000.00 Fishing gears 87 1,000,000.00 87000000.00 Other Fishing equipment 65 1,000,000.00 65000000.00 Others 23 1,000,000.00 23000000.00 Partially Damaged Irrigation facilities 43 500,000.00 21500000.00 Post harvest facilities 12 500,000.00 6000000.00 Others 43 500,000.00 21500000.00 Machinery & Equipment Tractors 76 500,000.00 38000000.00 Threshers 54 500,000.00 27000000.00 Rice dryers 87 500,000.00 43500000.00 Plows 67 500,000.00 33500000.00 Other Farm equipment 65 500,000.00 32500000.00 Fishing fleet/boats 23 500,000.00 11500000.00 Fishing gears 65 500,000.00 32500000.00 Other Fishing equipment 23 500,000.00 11500000.00 Others 23 500,000.00 11500000.00 Subtotal 906,500,000.00 Agricultural Facilities/Equipment Page 67 of 132AGRICULTURE (data entry) Variety 1 Variety 2 Variety 3 Variety 4 Vegetative 9,815 Reproductive 12,415 Ripening 13,286 Vegetative 10,140 12,025 Reproductive 11,115 13,000 Ripening 11,635 13,520 Variety Growth stage of crop Typhoon wind velocity (KpH) Typhoon wind exposure (Hrs) Flood water turbidity Flood submergence (Days) Crop lodging (Days) Total Affected Area (Has) Rice 1 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 2 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 3 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 4 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 5 Variety 1 Reproductive 70-100 >12 Muddy water 3-4 1-7 1,000 Rice 6 Variety 1 Ripening 101-150 >12 Muddy water 5-6 >7 1,000 Rice 7 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 8 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 9 Variety 1 Vegetative <70 ≤12 Clear water 1-2 0 1,000 Rice 10 Variety 1 Vegetative >150 ≤12 Clear water ≥7 0 1,000 Indirect losses Paddy Rice Growth stage of crop Cost of input per growth stage per hectare Paddy Rice Paddy Rice Corn Page 68 of 132AGRICULTURE (data entry) Variety Growth stage of crop Typhoon wind velocity (KpH) Typhoon wind exposure (Hrs) Flood submergenc e (Days) Total Affected Area (Has) Corn Corn 1 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 2 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 3 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 4 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 5 Variety 1 Reproductive 70-100 >12 3-4 1,200 Corn 6 Variety 1 Ripening 101-150 >12 5-6 1,200 Corn 7 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 8 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 9 Variety 1 Vegetative <70 ≤12 1-2 1,200 Corn 10 Variety 1 Vegetative >150 ≤12 ≥7 1,200 Ave input cost per hectare Total Affected Area (Has) Other fruits, crops and vegetables Vegetable 1 5,000.00 1,200 6000000 Vegetable 2 5,000.00 65,465.0 327325000 Vegetable 3 5,000.00 3,244.0 16220000 Vegetable 4 5,000.00 42,344.0 211720000 Vegetable 5 5,000.00 4,236.0 21180000 Fruit 1 5,000.00 4,236.0 21180000 Fruit 2 5,000.00 4,236.0 21180000 Fruit 3 5,000.00 4,236.0 21180000 Fruit 4 5,000.00 4,236.0 21180000 Fruit 5 5,000.00 4,236.0 21180000 Crop 1 5,000.00 56,654.0 283270000 Crop 2 5,000.00 7,657.0 38285000 Crop 3 5,000.00 6,576.0 32880000 Crop 4 5,000.00 344.0 1720000 Crop 5 5,000.00 3,445.0 17225000 Subtotal 1,061,725,000 Corn Not Harvested/Harvestable Page 69 of 132AGRICULTURE (data entry) Foregone income By-Product of Production Livestock Cows 5,000.00 Water Buffalo 5,000.00 Goat 5,000.00 Swine/Pigs 5,000.00 Poultry 5,000.00 Poultry products/Eggs 5,000.00 Others 5,000.00 Fishery Tilapia 5,000.00 Bangus 5,000.00 Tuna 5,000.00 Shrimp 5,000.00 Carrageenan 5,000.00 Other marine products 5,000.00 Subtotal 65,000 Volume Price per Volume Livestock Cows 32.0 15,000.00 480000 Water Buffalo 76.0 14,000.00 1064000 Goat 12.0 3,000.00 36000 Swine/Pigs 76.0 7,000.00 532000 Poultry 56.0 100.00 5600 Poultry products/Eggs 87.0 100.00 8700 Others 23.0 500.00 11500 Subtotal 2137800 Not Harvested/Harvestable Decrease in future production Page 70 of 132AGRICULTURE (data entry) Volume Price per Volume Crops Paddy Rice 12.0 10,000.00 120000 Corn 45.0 10,000.00 450000 Vegetables 65.0 10,000.00 650000 Onion 87.0 10,000.00 870000 Mango 12.0 10,000.00 120000 Banana 54.0 10,000.00 540000 Other crops 83.0 10,000.00 830000 Abaca 38.0 10,000.00 380000 Coconut 24.0 10,000.00 240000 Others 41.0 10,000.00 410000 Subtotal 4610000 Volume Price per Volume Fisheries Tilapia 34.0 10,000.00 340000 Bangus 54.0 10,000.00 540000 Tuna 45.0 10,000.00 450000 Shrimp 23.0 10,000.00 230000 Carrageenan 12.0 10,000.00 120000 Other marine products 56.0 10,000.00 560000 Subtotal 2240000 Volume Price per Volume Forestry Lumber 34.0 5,000.00 170000 Other Forest Products 12.0 4,000.00 48000 Subtotal 218000 Number/Units Cost/Unit Disaster mitigation works 23.0 10,000.00 230000 Subtotal 230000 Reduced yield Reduced Future Production Non-planting of future crops Prevention/mitigation Page 71 of 132AGRICULTURE (data entry) Amount 200,000.00 100,000.00 Subtotal 300000.00 Amount 200,000.00 100,000.00 Subtotal 300000.00 Crop Insurance Others Type of Expenditure Agricultural Subsidies Others Insurance claims Page 72 of 132AGRICULTURE --YIELD LOSS (data entry) Agriculture Sector (Yield Loss) Paddy Rice Damage matrix for rice due to strong wind induced by typhoon ≤12 >12 ≤12 >12 ≤12 >12 Vegetative 15 20 25 30 30 35 Reproductive 25 30 30 35 40 50 Ripening 15 20 20 25 25 30 Damage matrix for rice due to flood 1-2 3-4 5-6 ≥7 1-2 3-4 5-6 ≥7 Vegetative 10 20 30 50 20 30 50 100 Reproductive 25 45 80 100 30 70 85 100 Ripening 15 25 30 70 30 70 90 100 Growth Stage Clear water Muddy water Days of Submergence Growth Stage Wind Velocity (KpH) 70-100 101-150 >150 Period of Exposure (Hrs) Estimated Yield Loss (%) Page 73 of 132AGRICULTURE --YIELD LOSS (data entry) Damage matrix for rice due to lodging Vegetative Reproductive Ripening Corn Damage matrix for corn due to strong wind induced by typhoon ≤12 >12 ≤12 >12 ≤12 >12 Vegetative 5 15 20 25 40 50 Reproductive 10 50 55 60 80 100 Ripening 10 15 25 30 60 75 Damage matrix for corn due to flood 1-2 3-4 5-6 ≥7 Vegetative 10 50 100 100 Reproductive 80 90 100 100 Ripening 70 80 90 100 Growth Stage Days of Submergence Estimated Yield Loss (%) 25 60 Growth Stage Wind Velocity (KpH) 70-100 101-150 >150 Period of Exposure (Hrs) Estimated Yield Loss (%) 0 0 45 90 Growth Stage Lodging w/o water < 7 Days > 7 Days Estimated Yield Loss Page 74 of 132TRADE AND INDUSTRY (data entry) Enter data: TRADE & INDUSTRY Industry Direct loss Manufacturing/Mining Unit/Volume Price per volume Stock and Inventories in Factory -Processed Food Products 0 -Tobacco 0 -Beverages 0 -Garments 0 -Manufactured Steel 0 -Electronics 0 -Mining Products 0 -Others 0 Subtotal 0 Manufacturing/Mining Unit/Number Replacement Cost/Unit Buildings and Equipment Totally Damaged Buildings 0 Machineries and Equipment 0 Partially Damaged Buildings 0 Machineries and Equipment 0 Subtotal 0 Page 75 of 132TRADE AND INDUSTRY (data entry) Indirect loss Days of interrupted production Monthly income Manufacturing firms 12.0 1,000,000.00 400,000.00 Mining firms 12.0 1,000,000.00 12,000,000.00 Other Factories 12.0 1,000,000.00 12,000,000.00 Subtotal 24,400,000.00 Amount 500,000.00 500,000.00 Subtotal 1000000.00 Insurance claims Amount Buildings 200,000.00 Factories 200,000.00 Others 200,000.00 Subtotal 600000.00 Cost of demolition and debris removal Incentives provided Type of Expenditure Page 76 of 132TRADE AND INDUSTRY (data entry) Trade Direct loss Wholesale/Retail Trade Unit/Volume Price per volume Stock and Inventories in Stores -Processed Food Products 23.0 15,000.00 345000 -Tobacco 43.0 15,000.00 645000 -Beverages 67.0 15,000.00 1005000 -Garments 38.0 15,000.00 570000 -Manufactured Steel 58.0 15,000.00 870000 -Electronics 54.0 15,000.00 810000 -Others 44.0 15,000.00 660000 Subtotal 4905000 Wholesale/Retail Trade Unit/Number Replacement Cost/Unit Buildings and Equipment Totally Damaged Buildings 54.0 1,000,000.00 54000000 Machineries and Equipment 33.0 1,000,000.00 33000000 Partially Damaged Buildings 12.0 500,000.00 6000000 Machineries and Equipment 39.0 500,000.00 19500000 Subtotal 112500000 Indirect loss Days of interrupted service Monthly income Trading firms 12.0 800,000.00 320,000.00 Public market 12.0 800,000.00 9,600,000.00 Subtotal 9,920,000.00 Page 77 of 132TOURISM AND OTHERS (data entry) Enter data: TOURISM, OTHER SERVICES Tourism Direct loss Buildings/equipment Number/Units Repair cost Totally Damaged Hotels 1.0 500,000.00 500,000.00 Resorts 2.0 500,000.00 1,000,000.00 Restaurants, bars and related services 3.0 500,000.00 1,500,000.00 Others 4.0 500,000.00 2,000,000.00 Partially Damaged Hotels 1.0 300,000.00 300,000.00 Resorts 2.0 300,000.00 600,000.00 Restaurants, bars and related services 3.0 300,000.00 900,000.00 Others 4.0 300,000.00 1,200,000.00 Subtotal 8,000,000.00 Page 78 of 132TOURISM AND OTHERS (data entry) Indirect loss Cancelled reservations Number/Units Amount Hotels 1.0 200,000.00 200,000.00 Resorts 4.0 200,000.00 800,000.00 Restaurants, bars and related services 3.0 200,000.00 600,000.00 Others 7.0 200,000.00 1,400,000.00 Subtotal 3,000,000.00 Non-operating days Number/Units Days of Interrupted Services Monthly Income Hotels 1.0 10.0 250,000.00 83,333.33 Resorts 4.0 10.0 250,000.00 333,333.33 Restaurants, bars and related services 3.0 10.0 250,000.00 250,000.00 Others 7.0 10.0 250,000.00 583,333.33 Subtotal 1,250,000.00 Page 79 of 132TOURISM AND OTHERS (data entry) Other Private Services Direct loss Vehicles Number/Units Repair /Replacement cost Totally Damaged Land transport 4.0 100,000.00 400,000.00 Sea transport 3.0 100,000.00 300,000.00 Air transport 6.0 100,000.00 600,000.00 Others 2.0 100,000.00 200,000.00 Partially Damaged Land transport 4.0 50,000.00 200,000.00 Sea transport 3.0 50,000.00 150,000.00 Air transport 6.0 50,000.00 300,000.00 Others 2.0 50,000.00 100,000.00 Subtotal 2,250,000.00 Buildings/equipment Number/Units Repair /Replacement cost Totally Damaged Communication towers 1.0 150,000.00 150,000.00 Communication equipment 2.0 150,000.00 300,000.00 Partially Damaged Communication towers 1.0 100,000.00 100,000.00 Communication equipment 2.0 100,000.00 200,000.00 Subtotal 750,000.00 Page 80 of 132TOURISM AND OTHERS (data entry) Indirect loss Non-operating days Number/Units Days of Interrupted Services Monthly Income Banks and other financial institutions 89.0 12.0 900,000.00 32040000.00 TV/Cable TV network 34.0 12.0 900,000.00 12240000.00 Phone services 67.0 12.0 900,000.00 24120000.00 Radio services 12.0 12.0 900,000.00 4320000.00 Internet services 56.0 12.0 900,000.00 20160000.00 Private hospitals 67.0 12.0 900,000.00 24120000.00 Personal care services 23.0 12.0 900,000.00 8280000.00 Other trade and services 56.0 12.0 900,000.00 20160000.00 Subtotal 145440000.00 Cancelled trips Number/Units Number of trips Income per trip Land transport -Buses 120.0 240.0 100,000.00 2,880,000,000.00 -Trains 2.0 6.0 100,000.00 1,200,000.00 -Etc 5.0 5.0 100,000.00 2,500,000.00 Sea transport -Ferries, Cruise ships 78.0 50.0 100,000.00 390,000,000.00 -Boats 76.0 50.0 100,000.00 380,000,000.00 Air transport -Air planes 45.0 30.0 100,000.00 135,000,000.00 Others 2.0 2.0 100,000.00 400,000.00 Subtotal 3,789,100,000.00 Page 81 of 132TOURISM AND OTHERS (data entry) Government Services Direct loss Vehicles Number/Units Repair /Replacement cost Totally Damaged Land transport 12.0 100,000.00 1,200,000.00 Sea transport 3.0 100,000.00 300,000.00 Air transport 4.0 100,000.00 400,000.00 Others 12.0 100,000.00 1,200,000.00 Partially Damaged Land transport 12.0 50,000.00 600,000.00 Sea transport 3.0 50,000.00 150,000.00 Air transport 4.0 50,000.00 200,000.00 Others 12.0 50,000.00 600,000.00 Subtotal 4,650,000.00 Page 82 of 132TOURISM AND OTHERS (data entry) Indirect loss Type of Service Days of Interrupted Services Monthly Income Healthcare 12.0 1,500,000.00 600000.00 Tax services 12.0 1,500,000.00 600000.00 Licensing services 12.0 1,500,000.00 600000.00 Other services 12.0 1,500,000.00 600000.00 Subtotal 2400000.00 Type of Expenditure Amount Incentives provided 1,000,000.00 Others 1,000,000.00 Subtotal 2000000.00 Insurance claims Amount Land Transport 50,000.00 Water Transport 50,000.00 Air Transport 50,000.00 Power 50,000.00 Telecommunications 50,000.00 Others 50,000.00 Subtotal 300000.00 Page 83 of 132Enter data: ENVIRONMENT & NATURAL RESOURCES Direct Cost of natural resources to return to their previous state Cost Reforestation 100,000.00 Land stabilization 100,000.00 Protection against slippage 100,000.00 Cost of alternative water sources 100,000.00 Clean-up from spills of toxic materials 100,000.00 Others 100,000.00 Subtotal 600,000.00 Indirect Cost Loss of future source of raw materials 200,000.00 increase vulnerability to natural disasters 200,000.00 Loss of forest as atmospheric carbon sink 200,000.00 Loss of biodiversity resources 200,000.00 Others 200,000.00 Subtotal 1,000,000.00 Page 84 of 132Enter data: FOREIGN ASSISTANCE Foreign Aid and Donations Type of Aid/Assistance Amount Agriculture subsidies 1,000,000.00 Emergency relief 1,000,000.00 Search and rescue 1,000,000.00 Emergency housing 1,000,000.00 Cash 1,000,000.00 Others 1,000,000.00 Page 85 of 132Enter data: TAX REVENUES Present Year Previous Year 604,964,000,000.00 550,468,000,000.00 Tax Revenues Page 86 of 132Enter data: GDP & GVA RATIOS GVA Ratio Agriculture, Fishery and Forestry 0.72 Trade and Industry 0.42 Tourism and Other Services 0.64 Present Year Previous Year 4,858,835,000,000.00 4,316,402,000,000.00 1,152,164,000,000.00 1,085,071,000,000.00 Present Year Previous Year GDP deflator 421.71 397.80 SECTOR LEVEL Gross Domestic Product (Current Prices) Gross Domestic Product (Constant Prices) Page 87 of 132A B C D E Table Input Table Input Input Variety Growth stage Cost of Input per Ha Velocity Period of exposure Paddy rice -Area 1 Variety 1 Vegetative 9,815 <70 ≤12 -Area 2 Variety 1 Vegetative 9,815 <70 ≤12 -Area 3 Variety 1 Vegetative 9,815 <70 ≤12 -Area 4 Variety 1 Vegetative 9,815 <70 ≤12 -Area 5 Variety 1 Reproductive 12,415 70-100 >12 -Area 6 Variety 1 Ripening 13,286 101-150 >12 -Area 7 Variety 1 Vegetative 9,815 <70 ≤12 -Area 8 Variety 1 Vegetative 9,815 <70 ≤12 -Area 9 Variety 1 Vegetative 9,815 <70 ≤12 -Area 10 Variety 1 Vegetative 9,815 >150 ≤12 Corn -Area 1 Variety 1 Vegetative 10,140 <70 ≤12 -Area 2 Variety 1 Vegetative 10,140 <70 ≤12 -Area 3 Variety 1 Vegetative 10,140 <70 ≤12 -Area 4 Variety 1 Vegetative 10,140 <70 ≤12 -Area 5 Variety 1 Reproductive 11,115 70-100 >12 -Area 6 Variety 1 Ripening 11,635 101-150 >12 -Area 7 Variety 1 Vegetative 10,140 <70 ≤12 -Area 8 Variety 1 Vegetative 10,140 <70 ≤12 -Area 9 Variety 1 Vegetative 10,140 <70 ≤12 -Area 10 Variety 1 Vegetative 10,140 >150 ≤12 Table 1: Cost of inputs per adjusted growth stage per hectarage PALAY (pesos) Variety 1 Variety 2 Variety 3 Variety 4 Vegetative 9,815 ---Reproductive 12,415 ---Ripening 13,286 ---CORN (pesos) Variety 1 Variety 2 Variety 3 Variety 4 Vegetative 10,140 12,025 --Reproductive 11,115 13,000 --Ripening 11,635 13,520 --Table 2: Adjusted damage matrix for rice due to strong wind induced by typhoon (maximum damage) ≤12 >12 ≤12 >12 ≤12 Wind Growth Stage Wind Velocity (KpH) 70-100 101-150 >150 Period of Exposure (Hrs) Estimated Yield Loss (%)Vegetative 15 20 25 30 30 Reproductive 25 30 30 35 40 Ripening 15 20 20 25 25 Table 3: Adjusted damage matrix for rice due to flood (maximum damage) 1-2 3-4 5-6 ≥7 1-2 Vegetative 10 20 30 50 20 Reproductive 25 45 80 100 30 Ripening 15 25 30 70 30 Partially means leaves (9-15cm long) remain above water surface Source: Tsuitsui (1997), with long modifications based on experience and opinions of experts Table 4: Adjusted damage matrix for rice due to lodging Vegetative Reproductive Ripening Table 5: Adjusted damage matrix for corn due to strong wind induced by typhoon (maximum damage) ≤12 >12 ≤12 >12 ≤12 Vegetative 5 15 20 25 40 Reproductive 10 50 55 60 80 Ripening 10 15 25 30 60 Table 6: Adjusted damage matrix for corn due to flood 1-2 3-4 5-6 ≥7 Vegetative (7 WAE) 10 50 100 100 Reproductive (9 WAE) 80 90 100 100 Ripening (10-13 WAE) * 70 80 90 100 WAE -Weeks After Emergence * Submerged ears Table 6: Adjusted damage matrix for rice and corn due to drought Rice Corn Vegetative 50 50 Reproductive 60 80 Ripening 15 15 Estimated Yield Loss (%) Estimated Yield Loss (%) 0 0 60 25 45 90 Growth Stage Estimated Yield Loss (%) Growth Stage Wind Velocity (KpH) 70-100 101-150 >150 Period of Exposure (Hrs) Growth Stage Days of Submergence Growth Stage Lodging w/o water < 7 Days > 7 Days Estimated Yield Loss Growth Stage Clear water Days of SubmergenceFormula Step 2 Actual Cost = Total Affected Area * Cost of Inputs per Ha * Weighted Yield Loss Compute separately for each major stage (e.g. planting, vegetative, reproductive, maturity) IRRI stage Rice Vegetative 0 Germination to Emergence Seedling 1 Seedling Planting 2 Tillering Vegetative Seedling 3 Stem elongation Reproductive Booting Reproductive 4 Panicle initiation to Booting Maturing Ripening 5 Heading or Panicle exsertion 6 Flowering Ripening 7 Milk grain 8 Dough grain 9 Mature grain http://www.knowledgebank.irri.org/RP/growthStages/growthStages.htm Corn Planting Vegetative Reproductive Maturity Vegetative Germination and Emergence 1st leaf-nth leaf Tasseling Reproductive Silking Blister Milk Dough Dent Physiological maturity iowa state university http://maize.agron.iastate.edu/corngrows.htmlF G H I J K L Input Input Input Input Input Table Formula Rice Lodging Drought Total Affected Area Weighted Yield Loss Actual Cost Turbidity Days submerged Days C * J * K 3,242,590,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water 1-2 0 1,000 10 98,150,000 Muddy water 3-4 1-7 1,000 70 869,050,000 Muddy water 5-6 >7 1,000 90 1,195,740,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water 1-2 0 1,000 10 98,150,000 Clear water ≥7 0 1,000 50 490,750,000 4,525,560,000 1-2 1,200 10 121,680,000 1-2 1,200 10 121,680,000 1-2 1,200 10 121,680,000 1-2 1,200 10 121,680,000 3-4 1,200 90 1,200,420,000 5-6 1,200 90 1,256,580,000 1-2 1,200 10 121,680,000 1-2 1,200 10 121,680,000 1-2 1,200 10 121,680,000 ≥7 1,200 100 1,216,800,000 maximum damage) >12 Flood >15035 50 30 3-4 5-6 ≥7 30 50 100 70 85 100 70 90 100 maximum damage) >12 50 100 75 >150 Muddy waterTillering FloweringLTable Table Table Weighted Yield Loss Weighted Yield Loss Weighted Yield Loss Wind Flood Rice Lodging 0 10 0 0 10 0 0 10 0 0 10 0 30 70 45 25 90 60 0 10 0 0 10 0 0 10 0 30 50 0 0 10 0 10 0 10 0 10 50 90 30 90 0 10 0 10 0 10 40 100 Rice Wind Growth stage Vegetative Wind velocity <70 Period exposure ≤12 Estimated loss 0 ≤12 <70 70-100 101-150 Vegetative 0 15 25 Reproductive 0 25 30 Ripening 0 15 20 >12 <70 70-100 101-150 Vegetative 0 20 30 Reproductive 0 30 35 Ripening 0 20 25Rice Flooding Growth stage Reproductive Water turbidity Muddy water Submergence 3-4 Estimated loss 70 Clear water 1-2 3-4 5-6 Vegetative 10 20 30 Reproductive 25 45 80 Ripening 15 25 30 Muddy water 1-2 3-4 5-6 Vegetative 20 30 50 Reproductive 30 70 85 Ripening 30 70 90 Rice Lodging Growth stage Reproductive Days lodged >7 Estimated loss 90 0 1-7 >7 Vegetative 0 0 0 Reproductive 0 45 90 Ripening 0 25 60Corn Wind Growth stage Ripening Wind velocity 70-100 Period exposure ≤12 Estimated loss 10 ≤12 <70 70-100 101-150 Vegetative 0 5 20 Reproductive 0 10 55 Ripening 0 10 25 >12 <70 70-100 101-150 Vegetative 0 15 25 Reproductive 0 50 60 Ripening 0 15 30 Corn Flooding Growth stage Reproductive Submergence 1-2 Estimated loss 80 1-2 3-4 5-6 Vegetative 10 50 100 Reproductive 80 90 100 Ripening 70 80 90Growth stage Wind Period Loss Vegetative <70 ≤12 0 Vegetative <70 >12 0 Vegetative 70-100 ≤12 15 Vegetative 70-100 >12 20 >150 Vegetative 101-150 ≤12 25 30 Vegetative 101-150 >12 30 40 Vegetative >150 ≤12 30 25 Vegetative >150 >12 35 Reproductive <70 ≤12 0 >150 Reproductive <70 >12 0 35 Reproductive 70-100 ≤12 25 50 Reproductive 70-100 >12 30 30 Reproductive 101-150 ≤12 30 Reproductive 101-150 >12 35 Reproductive >150 ≤12 40 Reproductive >150 >12 50 Ripening <70 ≤12 0Ripening <70 >12 0 Ripening 70-100 ≤12 15 Ripening 70-100 >12 20 Ripening 101-150 ≤12 20 Ripening 101-150 >12 25 Ripening >150 ≤12 25 Ripening >150 >12 30 Growth stage Submergence Turbidity Loss Vegetative 1-2 Clear water 10 Vegetative 1-2 Muddy water 20 Vegetative 3-4 Clear water 20 Vegetative 3-4 Muddy water 30 ≥7 Vegetative 5-6 Clear water 30 50 Vegetative 5-6 Muddy water 50 100 Vegetative ≥7 Clear water 50 70 Vegetative ≥7 Muddy water 100 Reproductive 1-2 Clear water 25 Reproductive 1-2 Muddy water 30 ≥7 Reproductive 3-4 Clear water 45 100 Reproductive 3-4 Muddy water 70 100 Reproductive 5-6 Clear water 80 100 Reproductive 5-6 Muddy water 85 Reproductive ≥7 Clear water 100 Reproductive ≥7 Muddy water 100 Ripening 1-2 Clear water 15 Ripening 1-2 Muddy water 30 Ripening 3-4 Clear water 25 Ripening 3-4 Muddy water 70 Ripening 5-6 Clear water 30 Ripening 5-6 Muddy water 90 Ripening ≥7 Clear water 70 Ripening ≥7 Muddy water 100 Growth stage Vegetative Reproductive Ripening Days lodged 0 1-7 >7Growth stage Wind Period Loss Vegetative <70 ≤12 0 Vegetative <70 >12 0 Vegetative 70-100 ≤12 5 Vegetative 70-100 >12 15 >150 Vegetative 101-150 ≤12 20 40 Vegetative 101-150 >12 25 80 Vegetative >150 ≤12 40 60 Vegetative >150 >12 50 Reproductive <70 ≤12 0 >150 Reproductive <70 >12 0 50 Reproductive 70-100 ≤12 10 100 Reproductive 70-100 >12 50 75 Reproductive 101-150 ≤12 55 Reproductive 101-150 >12 60 Reproductive >150 ≤12 80 Reproductive >150 >12 100 Ripening <70 ≤12 0 Ripening <70 >12 0 Ripening 70-100 ≤12 10 Ripening 70-100 >12 15 Ripening 101-150 ≤12 25 Ripening 101-150 >12 30 Ripening >150 ≤12 60 Ripening >150 >12 75 Growth stage Vegetative Reproductive Ripening ≥7 Submergence 100 1-2 100 3-4 100 5-6 ≥7Growth stage Vegetative Reproductive Ripening Wind velocity <70 70-100 101-150 >150 Period exposure ≤12 >12Growth stage Vegetative Reproductive Ripening Submergence 1-2 3-4 5-6 ≥7 Turbidity Clear water Muddy waterGrowth stage Vegetative Reproductive Ripening Wind velocity <70 70-100 101-150 >150 Period exposure ≤12 >12Table to Compute Impact of Disaster on GDP Year n Gross value GVA ratio Current Prices Gross Value Added Unit: Pesos Agriculture, Fishery and Forestry 1,071,825,800.00 0.72 772,211,746 Trade and Industry 26,000,000.00 0.42 10,968,601 Tourism and Other Services 3,943,490,000.00 0.64 2,525,950,366 Gross Domestic Product 3,309,130,713 Year n+1 Current Prices Gross Value Added Unit: Pesos Million Agriculture, Fishery and Forestry Industry Services Gross Domestic Product -Legend Red Input value Green Value derived from formula Blue Value derived from other table(2004 Gross value GDP -Agriculture, Fishery and Forestry Mining and Quarrying Manufacturing Construction Electricity, Steam and Water Transportation, Communication and Storage Trade Finance Real Estate and Ownership of Dwellings Private Services Government ServicesNG Deficit -tax losses 0 less P5 billion every 1% decline in GDP growth 75.8 share of Regions affected to GDP 0 Prices/Inflation Employment/Income Balance of PaymentsYear n Year n Year n Year n Year n Current Prices Current Prices GDP Constant Prices Constant Prices Actual GDP GDP w/o Disaster Deflator GDP w/o Disaster Actual GDP Unit: Unit: Unit: Unit: Pesos Pesos Pesos Pesos 4,858,835,000,000 4,862,144,130,713 421.71 1,152,948,686,304 1,152,164,000,000 Year n+1 Year n+1 Year n+1 Year n+1 Year n+1 Current Prices Current Prices GDP Constant Prices Constant Prices Actual GDP GDP w/o Disaster Deflator GDP w/o Disaster Actual GDP Unit: Unit: Unit: Unit: Pesos Pesos Pesos Pesos Million Million Million Million 4,826,343,626,778 4,826,343,626,778 421.22 1,145,798,917,630 1,145,798,917,630 derived from formula derived from other table(s) Nominal GVA ratio Gross Value Added -0.72 -0.56 0.32 -0.54 0.54 -0.49 -0.66 0.72 0.88 0.55 -0.69 -Year n-1 Year n Year n Year n Constant Prices Constant Prices Constant Prices Impact Actual GDP GDP w/o Disaster Actual GDP GDP Loss Unit: Unit: Unit: Unit: Pesos Growth rate (%) Growth rate (%) Growth rate (%) 1,085,071,000,000 6.26 6.18 -0.07 Year n Year n+1 Year n+1 Year n+1 Constant Prices Constant Prices Constant Prices Impact Actual GDP GDP w/o Disaster Actual GDP GDP Loss Unit: Unit: Unit: Unit: Pesos Growth rate Percent Percent Million Percent Growth rate Growth rate 1,152,164,000,000 -0.55 -0.55 0.00OUTPUT TABLES (Unit: in local currency) I. SOCIAL SECTOR Affected Population Direct Impact Affected Dead Missing Injured Displaced Families 300 -300 Persons 2,784 1,068 553 1,163 -Women 1,399 600 299 500 Housing and Human Settlements Direct Impact Housing units Partially damaged Appliances/Furniture/Equipment Partially damaged Destroyed Destroyed Number of units 107,061.0 6,108.0 Number of units 214,260.0 92,764.0 Value 3,657,435,456,177.00 464,521,850.00 Value 387,888,000.00 80,979,100.00 View and Print data: IN LOCAL CURRENCY UNIT Page 108 of 132OUTPUT TABLES (Unit: in local currency) Education and Culture Direct Impact School Buildings Patrially damaged School Equipment Health Sector Direct Impact Hospitals and Health Care Units Patrially damaged Hospital/Health Care Equipment Summary matrix of disaster impact for social sector Direct Indirect Private Public 3,658,368,845,127.00 1,253,577.00 5,666,000.00 72,754,000.00 597,785.00 3,658,447,265,127.00 1,851,362.00 -Health Total Destroyed Destroyed Number of units 164.0 Property 42,853,000.00 2,277.0 84,230,000.00 Number of units Value 2,307.0 Disaster impact Value 2,350,000.00 2,272,000.00 Value 29,901,000.00 Value 1,044,000.00 175.0 Number of units 1,613.0 Number of units 87.0 Destroyed Destroyed Social Sectors -Housing -Education Page 109 of 132OUTPUT TABLES (Unit: in local currency) II. INFRASTRUCTURE Energy Direct Impact Units Value 1,001.0 580,430,100.00 1,540.0 755,255,240.00 1,001.0 580,430,100.00 1,540.0 755,255,240.00 Drinking water and sanitation Direct Impact Units Value 552.0 364,322,509.00 1,320.0 39,603,600.00 552.0 364,322,509.00 1,320.0 39,603,600.00 Partially Damaged Totally Damaged Buildings and structures Equipment, poles, wires Totally Damaged Buildings and structures Equipment, poles, wires Buildings and structures Equipment and facilities Buildings and structures Equipment and facilities Partially Damaged Page 110 of 132OUTPUT TABLES (Unit: in local currency) Transportation and communication Direct Impact Units Value 377.0 377,000,000.00 ------377.0 377,000,000.00 4.0 600,000.00 10.0 10,000,000.00 12.0 12,000,000.00 Units Value ----5.0 2,500,000.00 2.0 1,000,000.00 Summary matrix of disaster impact for infrastructure Direct Indirect Private Public 2,671,370,680.00 45,000,000.00 807,852,218.00 18,720,000.00 780,100,000.00 16,500,000.00 4,259,322,898.00 80,220,000.00 Total Infrastructure -Energy -Water and sanitation -Transportation and communications Totally Damaged Roads Land, Sea, and Air Vehicles Ports and Terminals Ports and Terminals Communication equipment Communication buildings/structures Bridges Land, Sea, and Air Vehicles Partially Damaged Totally Damaged Partially Damaged Property Roads Bridges Communication buildings/structures Disaster impact Communication equipment Page 111 of 132OUTPUT TABLES (Unit: in local currency) III. ECONOMIC SECTORS Agriculture Direct Impact Indirect Impact Totally Damaged Partially Damaged Agricultural subsidies 300,000.00 Crop insurance, etc. 300,000.00 Reduced future production 218,000.00 Disaster mitigation works 230,000.00 Nonplanting of future crops 4,610,000.00 Reduced yield 2,240,000.00 Foregone income 65,000.00 Decrease in future production 2,137,800.00 241,500,000.00 Value8,829,875,000.00 Investment losses in crops Machinery and equipment 430,000,000.00 49,000,000.00 Value 2,690,000.00 1,470,100.00 1,010,000.00 1,950,000.00 Value 186,000,000.00 Crops Livestock Fishery Forestry Buildings and facilities Machinery and equipment Buildings and facilities Page 112 of 132OUTPUT TABLES (Unit: in local currency) Trade and Industry Direct Impact Indirect Impact Buildings and facilities 6,000,000.00 Machinery and equipment 19,500,000.00 Machinery and equipment 33,000,000.00 Partially Damaged Value Buildings and facilities 54,000,000.00 Inventory/stock losses 4,905,000.00 Totally Damaged Value Losses due to interrupted production 34,320,000.00 Other indirect losses 1,600,000.00 Page 113 of 132OUTPUT TABLES (Unit: in local currency) Tourism and Other Services Direct Impact Indirect Impact Damage to buildings Sea transport 900,000.00 Damage to Vehicles 1,600,000.00 2,400,000.00 3,200,000.00 800,000.00 Resorts Land transport 2,400,000.00 Restaurants, bars and related services Others Losses due to cancelled reservations Value Value Hotels Air transport 1,500,000.00 Others 2,100,000.00 Others Value 3,000,000.00 2,300,000.00 Losses due to interrupted services 149,090,000.00 Losses due to cancelled trips 3,789,100,000.00 Page 114 of 132OUTPUT TABLES --SUMMARY (Unit: in local currency) IV. OVERALL EFFECTS OF DAMAGES Summary matrix of disaster impact for Agriculture, Trade and Industry, Tourism and Other Services Direct Indirect 913,620,100.00 1,071,825,800.00 117,405,000.00 26,000,000.00 15,650,000.00 3,943,490,000.00 1,046,675,100.00 5,041,315,800.00 Macroeconomic effect of damages Direct Indirect 0.02 0.02 0.00 0.00 0.00 0.08 In percent6.26 6.18 -0.07 0.04 Trade and Industry 0.00 Tourism and Other Services 0.08 3,959,140,000.00 In percent of GDP Disaster impact Total Total 6,087,990,900.00 Total Agriculture 1,985,445,900.00 Trade and Industry 143,405,000.00 View and Print Data: SUMMARY IN LOCAL CURRENCY UNIT Disaster impact Tourism and Other Services Agriculture Impact of disaster on GDP growth Real GDP growth without disaster Real GDP growth with disaster Impact of disaster on GDP growth Page 115 of 132OUTPUT TABLES --SUMMARY (Unit: in local currency) Total 3,971,478,671.85 Environment Direct Indirect 600,000.00 1,000,000.00 Disaster impact Total 1,600,000.00 Environment Implied impact of disaster on tax revenues Foregone tax revenues Page 116 of 132OUTPUT TABLES (Unit: in US$) View and Print Data: IN US$ CURRENCY UNIT I. SOCIAL SECTOR Affected Population Direct Impact Population Affected Dead Missing Injured Displaced Families 300 -300 Persons 2,784 1,068 553 1,163 -Women 1,399 600 299 500 Housing and Human Settlements Direct Impact Housing units Partially damaged Appliances/Furniture/Equipment Partially damaged Destroyed 92,764.0 1,619,582.00 Number of units Value 214,260.0 7,757,760.00 Destroyed Number of units Value 107,061.0 73,148,709,123.54 6,108.0 9,290,437.00 Page 117 of 132OUTPUT TABLES (Unit: in US$) Education and Culture Direct Impact School Buildings Patrially damaged School Equipment Health Sector Direct Impact Hospitals and Health Care Units Patrially damaged Hospital/Health Care Equipment Summary matrix of disaster impact for social sector Direct Indirect Private Public 73,167,376,902.54 25,071.54 113,320.00 --Health 1,455,080.00 11,955.70 73,168,945,302.54 37,027.24 Destroyed Social Sectors Destroyed Destroyed Destroyed -Housing -Education Total 2,277 1,684,600.00 Disaster impact Property 2,307 857,060.00 Number of units Value Number of units Value 1,613 598,020.00 Number of units Value 87 20,880.00 164 47,000.00 175 45,440.00 Number of units Value Page 118 of 132OUTPUT TABLES (Unit: in US$) II. INFRASTRUCTURE Energy Direct Impact Units Value 1,001.0 11,608,602.00 1,540.0 15,105,104.80 1,001.0 11,608,602.00 1,540.0 15,105,104.80 Drinking water and sanitation Direct Impact Units Value 552.0 7,286,450.18 1,320.0 792,072.00 552.0 7,286,450.18 1,320.0 792,072.00 Totally Damaged Partially Damaged Buildings and structures Equipment and facilities Buildings and structures Equipment and facilities Equipment, poles, wires Buildings and structures Equipment, poles, wires Partially Damaged Buildings and structures Totally Damaged Page 119 of 132OUTPUT TABLES (Unit: in US$) Transportation and communication Direct Impact Units Value 377.0 7,540,000.00 ------377.0 7,540,000.00 4.0 12,000.00 10.0 200,000.00 12.0 240,000.00 Units Value ----5.0 50,000.00 2.0 20,000.00 Summary matrix of disaster impact for infrastructure Direct Indirect Private Public 53,427,413.60 900,000.00 16,157,044.36 374,400.00 15,602,000.00 330,000.00 85,186,457.96 1,604,400.00 -Water and sanitation -Transportation and communications Total Infrastructure Communication buildings/structures Communication equipment -Energy Totally Damaged Bridges Land, Sea, and Air Vehicles Disaster impact Property Bridges Communication buildings/structures Communication equipment Totally Damaged Partially Damaged Ports and Terminals Roads Partially Damaged Land, Sea, and Air Vehicles Ports and Terminals Roads Page 120 of 132OUTPUT TABLES (Unit: in US$) III. ECONOMIC SECTORS Agriculture Direct Impact Indirect Impact Trade and Industry Direct Impact Value Crops 53,800.00 Livestock 29,402.00 Fishery 20,200.00 Forestry 39,000.00 Value Buildings and facilities 3,720,000.00 Machinery and equipment 8,600,000.00 Totally Damaged Buildings and facilities 980,000.00 Partially Damaged Machinery and equipment 4,830,000.00 Value Investment losses in crops 176,597,500.00 Foregone income 1,300.00 Decrease in future production 42,756.00 Nonplanting of future crops 92,200.00 Reduced yield 44,800.00 Reduced future production 4,360.00 Disaster mitigation works 4,600.00 Agricultural subsidies 6,000.00 Crop insurance, etc. 6,000.00 Value Inventory/stock losses 98,100.00 Page 121 of 132OUTPUT TABLES (Unit: in US$) Indirect Impact Buildings and facilities 1,080,000.00 Totally Damaged Machinery and equipment 660,000.00 Partially Damaged Buildings and facilities 120,000.00 Machinery and equipment 390,000.00 Value Losses due to interrupted production 686,400.00 Other indirect losses 32,000.00 Page 122 of 132OUTPUT TABLES (Unit: in US$) Tourism and Other Services Direct Impact Indirect Impact Value Hotels 16,000.00 Resorts 32,000.00 Damage to buildings Restaurants, bars and related services 48,000.00 Others 64,000.00 Value Land transport 48,000.00 Damage to Vehicles 42,000.00 Value Sea transport 18,000.00 Air transport 30,000.00 Losses due to cancelled trips 75,782,000.00 Others 46,000.00 Losses due to cancelled reservations 60,000.00 Losses due to interrupted services 2,981,800.00 Others Page 123 of 132View and Print Data: IN US$ CURRENCY UNIT IV. OVERALL EFFECTS OF DAMAGES Summary matrix of disaster impact for Agriculture, Trade and Industry, Tourism and Other Services Direct Indirect 18,272,402.00 21,436,516.00 2,348,100.00 520,000.00 313,000.00 78,869,800.00 Total 79,429,573.44 Environment Direct Indirect 12,000.00 20,000.00 Agriculture Environment 32,000.00 39,708,918.00 Disaster impact Total Implied impact of disaster on tax revenues Foregone tax revenues Trade and Industry 2,868,100.00 Tourism and Other Services 79,182,800.00 Disaster impact Total Page 124 of 132Restrict cursor movement to unprotected cells Q. The formulas in my worksheet use values in several input cells. I've unlocked the input cells and protected the sheet so the user can't change the formulas. Can I set things up so the cell cursor moves Yes. You've already unlocked your input cells and ensured that all other cells are locked. By default all cells are locked, but you can change that by using the Protection tab of the Format Cells dialog box. Select the cells to be changed and choose Format, Cells. In this case, the input cells are unlocked and all other cells are locked. Protect the worksheet in Excel 97 by using Worksheet, Protect or Tools, Protection, Protect Sheet (you can specify a password to keep others from "unprotecting" the sheet). Once the sheet is protected, press Tab to move the cell pointer to the next unlocked cell. This does not prevent the user from selecting unlocked cells using the cursor keys. To make those cells unselectable, change the worksheet's EnableSelection property. Select View, Toolbars, Control Toolbox to display the Control Toolbox toolbar. Click the Properties button to display the Properties box for the worksheet, then click the cell labeled "xlNoRestrictions" and use the drop-down list to change the EnableSelection property to xlUnlockedCells. Close the Properties box. As long as the worksheet is protected, users cannot select the locked This procedure does not save the EnableSelection property setting with the workbook. To create a simple macro that turns this setting on when the workbook is opened, press Alt-F11 to activate the Visual Basic Editor. Locate your workbook name in the Project window, and double-click it to expand its listing. Then double-click the item labeled ThisWorkbook and enter the following VBA code: Private Sub Workbook_Open() Worksheets("Sheet1").EnableSelection = xlUnlockedCells End Sub This macro executes whenever the workbook is opened, and sets the EnableSelection property of Sheet1 to xlUnlockedCells. The technique can be circumvented by changing the EnableSelection property to its default value (xlNoRestrictions). Few users know about this dodge, however.Table 1: Cost of inputs per growth stage per hectarage PALAY IRRI stage Rice Seedlings* 650 Vegetative 0 Germination to Emergence Planting Stage 8,190 1 Seedling Vegetative Stage 9,815 2 Tillering Reproductive Stage 12,415 3 Stem elongation Maturity Stage 13,286 Reproductive 4 Panicle initiation to Booting CORN OPV Hybrid 5 Heading or Panicle exsertion Planting Stage 5,915 6,435 6 Flowering Vegetative Stage 10,140 12,025 Ripening 7 Milk grain Reproductive Stage 11,115 13,000 8 Dough grain Maturity Stage 11,635 13,520 9 Mature grain * price per cavan http://www.knowledgebank.irri.org/RP/growthStages/Table 2: Damage matrix for rice due to strong wind induced by typhoon (maximum damage) ≤ 12 > 12 ≤ 12 > 12 ≤ 12 > 12 Booting 15 20 25 30 30 35 Flowering 25 30 30 35 40 50 Maturity 15 20 20 25 25 30 Table 3: Damage matrix for rice due to flood (maximum damage) 1 – 2 3 – 4 5 – 6 7 1 – 2 3 – 4 Min Tillering /Max Tillering 10 20 30 50 20 30 Panicle Initiation /Booting Stage Partially Inundated Panicle Initiation /Booting Stage Completely Inundated Flowering Stage /Maturity Stage 15 25 30 70 30 70 Ripening Stage 0 15 20 20 5 20 Partially means leaves (9-15cm long) remain above water surface Source: Tsuitsui (1997), with long modifications based on experience and opinions of experts Table 4: Damage matrix for rice due to lodging Flowering /Milking Stage Soil /Hard Dough Yellow Ripening Table 5: Damage matrix for corn due to strong wind induced by typhoon (maximum damage) Cost (PhP) Growth Stage Wind Velocity (KpH) 70 -100 101 -150 > 150 Period of Exposure (Hrs) Estimated Yield Loss (%) Growth Stage Clear Water Muddy Water Days of Submergence 10 30 65 80 20 52 25 45 80 100 30 70 Growth Stage Lodging w/o water < 7 Days > 7 Days Estimated Yield Loss 45 90 25 60 15 35 Wind Velocity (KpH) 70 -100 101 -150 > 150≤ 12 > 12 ≤ 12 > 12 ≤ 12 > 12 Vegetative 5 15 20 25 40 50 Reproductive 10 50 55 60 80 100 Maturity 10 15 25 30 60 75 Table 6: Damage matrix for corn due to flood 1 – 2 3 – 4 5 – 6 > 7 Newly Planted 10 75 100 100 Seedlings (2 WAE) 10 50 100 100 Vegetative (7 WAE) 10 50 100 100 Reproductive (9 WAE) 80 90 100 100 Maturity (10-13 WAE) * 70 80 90 100 WAE -Weeks After Emergence * Submerged ears Table 6: Damage matrix for rice and corn due to drought Rice Corn Seedlings 40 25 Vegetative 50 50 Reproductive 60 80 Maturity 15 15 Department of Agriculture procedures to estimate rice and corn damages due to disaster Step 1 Determine the nature and duration of the calamity (e.g. flooding, wind velocity, and drought) Take note of the number of occurrences Determine the affected area Determine the breed of crops and disaggregate the affected crop by plant stages 1st occurrence (first time for crop to be hit by disaster) Equivalent Damaged Area = Equivalent Productive Area * Yield Loss where: Equivalent Productive Area = Area Affected 2nd occurrence (affected area or fraction thereof was subsequently aggravated by another calamity) Equivalent Productive Area (of subsequent calamity) = Equivalent Productive Area (of previous calamity) -Equivalent Damaged Step 2 Weighted Yield Loss = Total Equivalent Damaged Area /Total Affected Area where: Total Equivalent Damaged Area is the sum of all Equivalent Damaged Areas Step 3 Production Loss = Total Affected Area * Standard Yield * Weighted Yield Loss where: Total Affected Area (Ha) is the total hectarage of standing crop Unit of Standard Yield is MT/Ha Unit of Weighted Yield Loss is % Growth Stage Period of Exposure (Hrs) Estimated Yield Loss (%) Growth Stage Days of Submergence Estimated Yield Loss (%) Growth Stage Estimated Yield Loss (%)Compute separately for each major stage (e.g. planting, vegetative, reproductive, maturity) Step 4 Actual Cost = Total Affected Area * Cost of Inputs per Ha * Weighted Yield Loss Actual Cost TAA Compute separately for each major stage (e.g. planting, vegetative, reproductive, maturity)Germination to Emergence Seedling Planting Vegetative Seedling Tillering Stem elongation Reproductive Booting Flowering Panicle initiation to Booting Maturing Ripening Heading or Panicle exsertion Flowering Milk grain Dough grain Mature grain knowledgebank.irri.org/RP/growthStages/growthStages.htm Corn Planting Vegetative Reproductive Maturity Vegetative Germination and Emergence 1st leaf-nth leaf Tasseling Reproductive Silking Blister Milk Dough 5 – 6 7 Dent 50 100 Physiological maturity iowa state university http://maize.agron.iastate.edu/corngrows.html 90 100 30 30 Muddy Water 85 100 85 100another calamity) previous calamity) -Equivalent Damaged Area (previous calamity) Equivalent Damaged Areas standing cropCost/ha WYL TEDA TAA EDA AA YLSOCIAL SECTOR Affected Population Housing and human settlements Education and culture Health Sector INFRASTRUCTURE Energy Drinking water and sanitation Transport and communications ECONOMIC SECTORS Agriculture Trade and industry Tourism OVERALL EFFECTS OF DAMAGES Environment Impact of disasters on women Damage overview Macroeconomic effects of damages Employment and income