Skip to main content

Indonesia

Valuation of Renewable Energy Resources in Indonesia

Languages and translations
English

Economic Commission for Europe Conference of European Statisticians Group of Experts on National Accounts Twenty-third session Geneva, 23-25 April 2024 Item 2 (b) of the provisional agenda Towards the 2025 System of National Accounts: Measuring intangible assets and natural capital in 2025 System of National Accounts

Valuation of Renewable Energy Resources in Indonesia

Prepared by BPS-Statistics Indonesia1

Summary

Indonesia has many types of energy resources, including non-renewable energy resources and renewable energy resources. BPS-Statistics Indonesia has published asset accounts for mineral and energy resources both in physical and monetary unit annually. However, currently those accounts only covered non-renewable mineral and energy resources. It excluded the renewable energy resources as it was outside of the boundary of mineral and energy resources according to the 2012 SEEA Central Framework. This paper aimed to calculate the monetary value of renewable energy resources in Indonesia. The Net Present Value (NPV) method were applied in estimating the monetary value of renewable energy resources. The main data source for this study was obtained from Electricity Statistics as the renewable energy resources in Indonesia has been mainly utilized for electricity generation.

The results show that the monetary value of Indonesia hydroelectric and geothermal resources in 2022 was Rp113,884 billion and Rp106,986 billion respectively. It constituted only 1 percent of total monetary value of Indonesian energy resources, which also included coal, oil, and natural gas resources. The monetary value of solar energy resources could not be obtained as the resource rent derived from residual value method produced negative value. Meanwhile, this study did not calculate the value of wind energy resources because of insufficient data sources. In conclusion, the monetary value of renewable energy resources in Indonesia was depended on how much economic activities utilized those resources. Furthermore, an in-depth study to the electricity generation establishment was recommended in order to obtain sufficient data, particularly on operating cost, to derive resource rent and to apply NPV method for all types of renewable energy resources.

1 Prepared by Zanial Fahmi Firdaus.

United Nations ECE/CES/GE.20/2024/19

Economic and Social Council Distr.: General 27 March 2024 English only

ECE/CES/GE.20/2024/19

2

I. Introduction

1. Renewable energy is defined as energy derived from natural sources which has higher rate of replenishment than their rate of extraction.

2. Renewable energy plays an important role in reaching the target of Net Zero Emission (NZE). More than half of greenhouse gas emissions released to the atmosphere in Indonesia were come from the energy sector, which mainly caused by the fuel combustion activities. As the demand of energy would still be expected to increase over time, the strategy toward NZE will be highly depend on the shifting of energy supply from non-renewable energy resources to the non-emitting renewable energy resources.

3. Indonesia is estimated to have huge potential of renewable energy-based power plant, which theoretically could reach 3.6 TW. In 2022, there were many types of renewable energy-based power plant in Indonesia, including hydropower, geothermal energy, solar energy, wind energy, and bioenergy.

4. In accordance with the commitment to reduce greenhouse gas emissions, the Government of Indonesia has set a target for renewable energy mix in the primary energy supply, which is set at 23 percent in 2025. Some policy directions and strategies has been deployed, including the diversification of energy and electricity by increasing new and renewable energy sources, such as geothermal, water, solar, and bioenergy.

II. Renewable Energy Assets in the Current Accounting Framework

5. The 2008 System of National Accounts (SNA) has classified natural resources as part of the non-produced assets. They have to fulfill two requirements to be considered as economic asset, which are the establishment of ownership right and the capability of bringing economic benefits to the owner. However, in regard to the renewable natural resources, the 2008 SNA only explains about the naturally occurring assets in the form of biota, such as animals and plants. There is no clear explanation on renewable energy even though renewable energy assets could also be regarded as economic assets.

6. The System of Environmental-Economic Accounting (SEEA) describes more specifically about the recording of natural resources in the accounting framework, including energy. Energy is covered not only in the asset accounts as part of environmental assets along with mineral, but also in the flow accounts as an important natural input from the environment to economic activities. Moreover, the United Nations has published a special accounting framework for energy in the form of SEEA for Energy (SEEA-Energy).

7. According to the physical energy flow accounts framework in SEEA-Energy, the flows of energy from natural inputs could be classified into three broad categories:

a. Energy natural resources input;

b. Inputs of energy from renewable sources; and

c. Other natural inputs.

Thus, the contribution of renewable energy to the economic activities is well presented in the physical energy flow accounts.

ECE/CES/GE.20/2024/19

3

Table 1 Energy from Natural Inputs by Type

Energy natural resources inputs

Mineral and energy resources

Oil resources

Natural gas resources

Coal and peat resources

Uranium and other nuclear fuels

Natural timber resources

Inputs of energy from renewable sources

Solar

Hydro

Wind

Wave and tidal

Geothermal

Other electricity and heat

Other natural inputs

Energy inputs to cultivated biomass Source: SEEA-Energy

8. However, the contribution of renewable energy as economic assets, which could derive economic benefits to the owner, does not have the same visibility as in the energy flow accounts. The energy asset accounts only covered non-renewable energy resources, such as oil resources, natural gas resources, and coal resources.

Table 2 Classification of Environmental Assets in the SEEA Central Framework

1 Energy natural resources inputs

1.1 Oil resources

1.2. Natural gas resources

1.3. Coal and peat resources

1.4. Non-metallic mineral resources (excluding coal and peat resources)

1.5. Metallic mineral resources

2 Land

3 Soil Resources

4 Timber Resources

4.1. Cultivated timber resources

4.2. Natural timber resources

5 Aquatic Resources

ECE/CES/GE.20/2024/19

4

5.1. Cultivated aquatic resources

5.2. Natural aquatic resources

6 Other Biological Resources (excluding timber resources and aquatic resources)

7 Water Resources

7.1. Surface water

7.2. Groundwater

7.3. Soil water Source: SEEA Central Framework

9. Nonetheless, SEEA Central Framework still recognized that renewable energy resources do have value. However, those values are attributed not in the mineral and energy resources class, but in the value of land or in the value of water resources, in case of hydropower.

10. The Government of Indonesia has demanded that renewable energy resources has its own classification in the environmental asset accounts, in which the value of renewable energy resources could be differentiated from the value of land or the value of water resources.

11. Therefore, the methodology to value renewable energy resources needs to be developed and agreed internationally so that the National Statistical Office (NSO) could provide the statistical products related to the value of renewable energy resources based on the internationally agreed standards and accounting framework.

12. This paper aimed to calculate the monetary value of renewable energy resources in Indonesia based on the current availability of the source data, discuss the limitation of the applied methodology, and provide recommendations for future improvements related to the valuation of renewable energy resources.

III. Scope and Data Sources

13. There are many types of renewable energy and each type has its own functions. This paper only focused on the valuation of renewable energy assets in electricity generation. Therefore, the economic benefits from renewable energy resources which were obtained from the production of other energy products, such as biofuel, was excluded from the scope of this research.

14. Indonesia has a state-owned company which is specialized in electricity supply activities, namely PT Perusahaan Listrik Negara (PLN). However, the electricity generation activities were not only carried out by PLN, but also by Independent Power Producer (IPP) and Private Power Utility (PPU). Nonetheless, both IPP and PPU power plants should sold their electricity to PLN as PLN controls electricity distribution network in Indonesia. Meanwhile, there are also some off grid power plants, which are not integrated with PLN electricity network and usually operates in isolated islands and rural area, but its production only constituted 7.63 percent of total electricity production in 2022.

15. This paper used Electricity Statistics from PLN as the main data source to estimate the monetary value of renewable energy resources in Indonesia. It presents data on the electricity production and operating cost by type of power plant. While the data on electricity production covered five types of renewable energy resources, the operating cost data was limited only for hydroelectric, geothermal, and solar energy.

IV. Monetary changes in asset value

16. As recommended by the SEEA, which applied the Net Present Value (NPV) method to determine the monetary value of environmental asset in general, the valuation of renewable

ECE/CES/GE.20/2024/19

5

energy resources in Indonesia was also carried out by using the NPV approach. This approach would determine the value of renewable energy resources by calculating the sum of discounted value of future income in the future periods.

17. The formula of NPV is as follows:

where

𝑉𝑉𝑉𝑉 is the value of the resources of period 𝑉𝑉;

𝑅𝑅𝑅𝑅 is the resource rent;

𝑁𝑁 is the asset life; and

𝑟𝑟 is the discount rate.

18. Resource rent reflects the gross measure of the return on environmental asset. By considering the availability of the data source, the residual value method was chosen as the method to estimate resource rent.

Resource rent = output

− intermediate consumption

− compensation of employees

− taxes on production

+ subsidies on production

− specific subsidies on extraction

+ specific taxes on extraction

− consumption of fixed capital

− return to produced asset

19. The source data were not able to differentiate the revenue of electricity sales by type of power plant which produced them. Therefore, the value of output for each type of renewable energy power plant was calculated by multiplying the quantity of produced electricity and the highest benchmark price for purchasing electricity. Those prices were regulated in the Presidential Regulation Number 112 of 2022 concerning the Acceleration of Renewable Energy Development for Electricity Supply.

20. The asset life of hydroelectric resources was set to 50 years because the use of lifetime beyond 50 years has small impact on the result of NPV calculation. Meanwhile, the asset life of geothermal and solar energy resources was set to 25 years as the future revenues and costs of such power plants were assumed to be less certain than the hydroelectric power plant.

ECE/CES/GE.20/2024/19

6

V. Results and Discussion

21. The valuation of renewable energy resources in Indonesia only managed to obtain monetary value of hydroelectric and geothermal resources. The monetary value of solar energy resources could not be acquired because the resource rent of solar energy was negative due to high consumption of fixed capital.

22. In 2022, the hydroelectric resources in Indonesia were estimated to have monetary value around IDR 113,884 billion. Meanwhile, the monetary value of geothermal energy resources was IDR 106,986 billion.

23. By considering the monetary value of non-renewable energy resources, comprising of coal, oil, and natural gas; the share of monetary value of Indonesia renewable energy resources in 2022 was only 1.07 percent. The detailed monetary value of each type of energy resources is presented in the Table 3 below.

Table 3 Classification of Environmental Assets in the SEEA Central Framework

No Type of Energy Asset Monetary Value (billion IDR)

Share (percent)

(1) (2) (3) (4) 1 Coal 15,178,689 73.35 2 Natural Gas 3,019,090 14.59 3 Crude Oil 2,275,564 10.99

Sub-Total of Non-Renewable Energy 20,473,343 98.93 4 Hydroelectric 113,884 0.55 5 Geothermal 106,986 0.52 6 Solar Energy - -

Sub-Total of Renewable Energy 220,869 1.07 Total Energy Resources 20,694,212 100.00

24. However, the monetary value of renewable energy resources in the Table 3 was only limited to the hydroelectric and geothermal energy for electricity generation purposes only. It excluded the direct use of geothermal as well as other types of renewable energy power plant due to the limited data availability. The figure also did not take bioenergy used as fuel into consideration.

VI. Sensitivity Analysis

25. Sensitivity analysis was conducted to assess the impact of asset life and discount rate to the estimated renewable energy asset values for both hydroelectric and geothermal energy resources. It was not applied to the solar energy resources because the variable of asset life did not affect the value of resource rent, which was already less than zero.

26. The estimates of net present value of renewable energy resources by asset life was as follows:

ECE/CES/GE.20/2024/19

7

Figure 1 Sensitivity Analysis of Asset Life

140000

120000

100000

80000

60000

40000

20000

0 5 10 15 20 25 30 35 40 45 50 55 60 65 70

Asset Life (years)

Hydroelectric Geothermal

27. From the Figure 1 above, it could be observed that the effect of the use of lifetime beyond 50 years in the NPV calculations was not significant to the estimated asset values. Hence, the decision to set the asset life into some numbers less than 50 years should be made carefully and take many factors into consideration.

28. It is also noted that by applying the same asset life for both hydroelectric and geothermal energy resources, the monetary value of geothermal energy asset would be higher than hydroelectric resources as the geothermal energy asset had higher per unit resource rent.

29. Meanwhile, the choice of discount rate would also influence the estimated monetary value of renewable energy resources as shown in the Figure 2 below.

Figure 2 Sensitivity Analysis of Discount Rate

300000

250000

200000

150000

100000

50000

0 3 4 5 6 7 8 9 10 11 12 13 14

Discount Rate (percent) Hydroelectric

Geothermal

30. This paper chose 8 percent of discount rate, referring to the government bond rate, which used for the valuation of Indonesian mineral and non-renewable energy assets. The result showed that the value of hydroelectric energy resources was higher than the value of geothermal energy resources. However, by applying higher discount rate, the value of

Es tim

at ed

A ss

et V

al ue

(b ill

io n

ID R)

Es

tim at

ed A

ss et

V al

ue (b

ill io

n ID

R)

ECE/CES/GE.20/2024/19

8

geothermal energy resources might surpass the value of hydroelectric energy resources, which was the case when the discount rate was above 10 percent.

31. The impact of discount rate to the estimated asset value of renewable energy resources was only significant when the choice of asset life was different among the type of renewable energy resources. In the previous figure, the asset life of hydroelectric was 50 years while the lifetime of geothermal energy asset was assumed to be 25 years.

32. By assuming the same asset life for both hydroelectric and geothermal energy resources, the estimated asset value of geothermal energy resources, which had higher resource rent, would still be consistently above the estimated asset value of hydroelectric resources, regardless of the choice of discount rate, as presented in the Figure 3 below.

Figure 3 Sensitivity Analysis of Asset Life and Discount Rate

300000

250000

200000

150000

100000

50000

0 3 4 5 6 7 8 9 10 11 12 13 14 15

Discount Rate (percent)

Hydroelectric (50 years) Geothermal (25 years)

Hydroelectric (25 years) Geothermal (50 years)

33. Nevertheless, the choice of discount rate still had an impact. The higher discount rate would make the difference between the monetary value of geothermal energy resources and hydroelectric resources smaller.

VII. Conclusion

34. Even though the potential of renewable energy resources in Indonesia is enormous, the monetary value of renewable energy resources in Indonesia was highly dependent on the installed capacity of renewable energy power plants as well as on the quantity of electricity generation.

Es tim

at ed

A ss

et V

al ue

(b ill

io n

ID R)

ECE/CES/GE.20/2024/19

9

35. The high operating cost may also influence the derivation of resource rent from the residual value method. For solar energy resources in Indonesia, the resource rent had negative value due to high consumption of fixed capital.

36. The net present value of renewable energy resources was also impacted by the choice of asset life and discount rate for each type of renewable energy resources.

37. The valuation of renewable energy resources might be better to be carried out by applying bottom-up approach or site-by-site basis. The calculation based on macro data would not be able to take into account the remaining lifespan of renewable energy generation equipment of certain power plant.

38. An in-depth study to the electricity generation establishment was recommended in order to obtain sufficient data, particularly on operating cost, to derive resource rent and to apply NPV method on the valuation of other types of renewable energy resources, such as wind and biomass energy.

ECE/CES/GE.20/2024/19

10

References

BPS-Statistics Indonesia. (2023). Indonesia System of Integrated Environmental-Economic Accounting 2018-2022.

Ministry of Energy and Mineral Resources Republic of Indonesia. (2023). Handbook of Energy & Economic Statistics of Indonesia 2022.

Ministry of Energy and Mineral Resources Republic of Indonesia. (2023). Performance Report of General Directorate of New, Renewable Energy and Energy Conservation 2022.

Ministry of Environment and Forestry Republic of Indonesia. (2024). Report of Greenhouse Gas (GHG) Inventory and Monitoring, Reporting, and Verification (MPV) 2023. Volume 9, January 2024.

PT Perusahaan Listrik Negara (Persero). (2023). PLN Statistics 2022.

Republic of Indonesia. (2020). Presidential Regulation Number 18 of 2020 concerning the National Medium-Term Development Plan for 2020-2024.

Republic of Indonesia. (2022). Presidential Regulation Number 112 of 2022 concerning the Acceleration of Renewable Energy Development for Electricity Supply.

United Nations, European Commission, International Monetary Fund, Organization for Economic Cooperation and Development and World Bank. (2009). System of National Accounts 2008. Sales No. E.08.XVII.29.

United Nations, European Commission, Food and Agriculture Organization of the United Nations, International Monetary Fund, Organization for Economic Cooperation and Development and World Bank. (2014). System of Environmental-Economic Accounting 2012: Central Framework. Studies in Methods, Series F, No. 109. Sales No. E.12. XVII.12.

United Nations. (2019). System of Environmental-Economic Accounting for Energy: SEEA- Energy. Studies in Methods, Series F No. 116. Sales No. E.17.XVII.12.

  • Group of Experts on National Accounts
  • Twenty-third session
  • Valuation of Renewable Energy Resources in Indonesia
    • Prepared by BPS-Statistics Indonesia0F
  • I. Introduction
  • II. Renewable Energy Assets in the Current Accounting Framework
  • III. Scope and Data Sources
  • IV. Monetary changes in asset value
  • V. Results and Discussion
  • VI. Sensitivity Analysis
  • VII. Conclusion
  • References

The Compilation of Quarterly GRDP of 514 Regencies and Cities in Indonesia (A recent study in Statistics Indonesia)

Languages and translations
English

Economic Commission for Europe Conference of European Statisticians Group of Experts on National Accounts Twenty-third session Geneva, 23-25 April 2024 Item 4 of the provisional agenda Subnational and regional accounts

The Compilation of Quarterly GRDP of 514 Regencies and Cities in Indonesia (A recent study in Statistics Indonesia)

Prepared by BPS-Statistics Indonesia1

Summary

Recent global economic trends, accelerated by the impact of the pandemic, have highlighted the need for more frequent and detailed economic data at the regencies and cities in Indonesia. One of them is the demand for quarterly GRDP compilation at the 514 regencies / cities in Indonesia from various stakeholders, including policymakers. Two main reasons underpinning the necessity of quarterly regency/city-level GRDP in Indonesia include: High demand for quarterly regency/city -level GRDP from data users; High-frequency indicators such as quarterly GRDP are essential for prompt policy responses, especially during rapidly changing economic conditions as witnessed during the covid 19; and, The need for quarterly GRDP for economic modeling at the regency/ city level.

In late 2023, BPS started the first study on compiling quarterly GRDP 2018-2023 of 514 regencies / cities. The activities consist of benchmarking the annual GRDP data to quarterly for the period of 2018 – 2022, as well as estimating the GRDP of regencies and cities for Quarter I and II year 2023. Despite all challenges and resource constraints, BPS successfully completed the quarterly GRDP for regency/city-level data, spanning 17 industries from Q1 2018 to Q2 2023, where it is found that the average discrepancy between quarterly provincial GRDP and quarterly GRDP of regencies and cities is mostly less than 1 percent. Lessons learned from this study emphasize the need to enhance cooperation with other ministries and institutions to obtain supplementary data for improving the quality of quarterly regency GRDP. Internally, BPS must provide disaggregated data at the regency/city level, and capacity-building efforts within regional BPS offices are deemed beneficial. Lastly, more detailed data presentation in the tables is recommended to improve the value of the data for users.

1 Prepared by Ria Arinda.

United Nations ECE/CES/GE.20/2024/18

Economic and Social Council Distr.: General 27 March 2024 English only

ECE/CES/GE.20/2024/18

2

I. Introduction

1. Gross Regional Domestic Product (GRDP) stands as a pivotal indicator for gauging the economic performance of a region over a specified period. It represents the total value added by all industries within a specific area or the aggregate final value of goods and services produced by all economic entities. GRDP serves to illustrate overall economic growth or the performance of individual sectors over consecutive periods. Recognizing the demand from numerous data users for quarterly GRDP data, particularly amid the necessity to swiftly respond to policy changes, notably during crises such as the COVID-19 pandemic, and for economic modeling at the smaller regional level, in 2023, BPS initiated a study on compiling Quarterly Regency/City GRDP.

2. The objectives of this study are; to produce data on the GRDP of regencies / cities by industry in the quarterly period for the period that has passed (back series) and for the current period (forward series); to identify the availability of necessary data needed for compiling quarterly regency/city GRDP; to review the business process of preparing the regency/city GRDP in the quarterly period, which includes methods and procedures for compilation, scope, levels, systems, schedules, and revision policies; and, to increase the capacity of BPS human resources in preparing the compilation of quarterly regency/city GRDP in accordance with international guidelines.

3. Quarterly GRDP of regencies and cities will be useful for analyzing short-term volatility and business cycles; generating more data periods for forecasting compared to annual GDP; and providing a more comprehensive and consistent economic overview compared to other short-term indicators.

II. Methodology

A. Data

4. The data used in the study on compiling GRDP of regencies and cities come from various sources, such as internal BPS, ministries/agencies/institutions, company reports, and other sources. From data source identification phase, we found that, in general the main data sources used are from BPS. However, if we zoom in, still only a few industries source their data from BPS, making provincial and regency/city BPS offices require other external data sources to produce quarterly GRDP by industry. Thus, the support of sectoral data from ministries/agencies/institutions plays an important role.

5. Furthermore, we discovered that several industries still lack robust data support from both BPS and ministries/agencies/institutions, prompting provincial and district/city BPS offices to explore alternative data sources. These industries include; Agriculture services and hunting (A.1.g); Wholesale trade and retail trade except of motor vehicles and motorcycles (G.2); River, lake, and ferry transport (H.4); Warehousing and support services for transportation, postal and courier (H.6); Other financial services (K.3); Financial supporting services (K.4)

6. In detail, the overview of data source for each industry is shown in Table 1 and Table 2. From these tables, it is evident that, unlike production data and indicators, data sources for price data and indicators in the compiling quarterly GRDP of regencies and cities generally come from BPS as most provinces have used price data and indicators from BPS due to limited availability elsewhere.

ECE/CES/GE.20/2024/18

3

Table 1 The status of production data and indicators availability

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

A. Agriculture, forestry and fishing 100.00 88.24 23.53 41.18

1 Agriculture, livestock, hunting and agriculture services

100.00 85.29 11.76 38.24

a. Food crops 97.06 47.06 0.00 14.71

b. Horticultural crops 82.35 52.94 0.00 11.76

c. Plantation crops 34.48 51.72 3.45 24.14

d. Annual horticultural crops and others 85.29 50.00 0.00 11.76

e. Other plantation 66.67 69.70 6.06 18.18

f. Livestock 70.59 79.41 2.94 14.71

g. Agriculture services and hunting 44.12 26.47 0.00 35.29

2 Forestry and Logging 33.33 69.70 9.09 18.18

3 Fishery 61.76 82.35 8.82 11.76

B. Mining and quarrying 82.35 76.47 41.18 38.24

1 Crude petroleum, natural gas, and geothermal 50.00 68.18 18.18 22.73

2 Coal and lignite mining 35.71 71.43 21.43 21.43

3 Iron ore mining 50.00 35.71 32.14 25.00

4 Other mining and quarrying 79.41 44.12 2.94 32.35

C. Manufacturing 94.12 44.12 29.41 29.41

1 Manufacture of coal and refined petroleum products 64.29 42.86 35.71 28.57

a. Manufacture of coal 0.00 50.00 50.00 50.00

b. Manufacture of refined petroleum products 75.00 41.67 33.33 25.00

2 Manufacture of food products and beverages 88.24 23.53 5.88 20.59

3 Manufacture of tobacco products 66.67 16.67 5.56 33.33

4 Manufacture of textiles; and wearing apparel 88.24 11.76 2.94 20.59

5 Manufacture of leather and related products and footwear

81.82 9.09 4.55 13.64

6 Manufacture of wood and of products of wood and 85.29 14.71 5.88 20.59

ECE/CES/GE.20/2024/18

4

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

cork, and articles of straw and plaiting materials

7 Manufacture of paper and paper products, printing and reproduction of recorded media

82.35 14.71 11.76 20.59

8 Manufacture of chemicals and pharmaceuticals and botanical products

79.41 11.76 5.88 20.59

9 Manufacture of rubber, rubber products and plastics products

81.25 25.00 12.50 21.88

10 Manufacture of other non-metallic mineral products 91.18 8.82 8.82 20.59

11 Manufacture of basic metals 78.95 21.05 0.00 15.79

12 Manufacture of fabricated metal products, computer, and optical products, and electrical equipment

88.24 11.76 2.94 20.59

13 Manufacture of machinery and equipment 90.00 5.00 5.00 20.00

14 Manufacture of transport equipment 84.85 12.12 6.06 24.24

15 Manufacture of furniture 88.24 11.76 2.94 20.59

16 Other manufacturing, repair and installation of machinery and equipment

82.35 11.76 2.94 20.59

D. Electricity and Gas 67.65 35.29 64.71 20.59

1 Electricity 17.65 35.29 64.71 8.82

2 Manufacture of gas and production of ice 67.65 11.76 29.41 20.59

E. Water supply, sewerage, waste management and remediation activities

61.76 29.41 55.88 20.59

F. Construction 55.88 58.82 26.47 32.35

G. Wholesale and retail trade; repair of motor vehicles and motorcycles

44.12 58.82 32.35 50.00

1 Wholesale and retail trade and repair of motor vehicles and motorcycles

26.47 52.94 32.35 38.24

2 Wholesale trade and retail trade except of motor vehicles and motorcycles

41.18 35.29 8.82 47.06

H. Transportation and storage 85.29 64.71 55.88 47.06

1 Railways transport 50.00 10.00 50.00 20.00

2 Land transport 23.53 52.94 20.59 29.41

ECE/CES/GE.20/2024/18

5

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

3 Sea transport 81.82 39.39 6.06 15.15

4 River, lake, and ferry transport 42.42 48.48 21.21 27.27

5 Air transport 76.47 32.35 23.53 14.71

6 Warehousing and support services for transportation, postal and courier

38.24 38.24 38.24 35.29

I. Accommodation and food and beverage service activities

91.18 44.12 2.94 20.59

1 Accommodation 85.29 26.47 2.94 20.59

2 Food and beverage service activities 76.47 41.18 0.00 20.59

J. Information and communication 50.00 20.59 26.47 32.35

K. Financial and insurance activities 44.12 73.53 17.65 41.18

1 Financial intermediary services 44.12 67.65 5.88 29.41

2 Insurance and pension fund 20.59 50.00 11.76 32.35

3 Other financial services 20.59 47.06 14.71 32.35

4 Financial supporting services 23.53 35.29 8.82 32.35

L. Real estate 58.82 26.47 8.82 38.24

M,N. Business activities 70.59 23.53 14.71 29.41

O. Public administration and defence; compulsory social security

38.24 94.12 2.94 17.65

P. Education 76.47 76.47 5.88 23.53

Q. Human health and social work activities 79.41 73.53 14.71 23.53

R,S,T,U. Other services activities 76.47 44.12 8.82 29.41

ECE/CES/GE.20/2024/18

6

Table 2 The status of price data and indicators availability

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

A. Agriculture, forestry and fishing 94.12 26.47 2.94 17.65

1 Agriculture, livestock, hunting and agriculture services

94.12 23.53 2.94 17.65

a. Food crops 94.12 14.71 2.94 14.71

b. Horticultural crops 88.24 20.59 2.94 17.65

c. Plantation crops 79.31 20.69 3.45 17.24

d. Annual horticultural crops and others 85.29 11.76 2.94 17.65

e. Other plantation 84.85 12.12 3.03 18.18

f. Livestock 88.24 14.71 2.94 14.71

g. Agriculture services and hunting 82.35 5.88 2.94 14.71

2 Forestry and Logging 81.82 9.09 3.03 15.15

3 Fishery 91.18 23.53 2.94 14.71

B. Mining and quarrying 85.29 29.41 26.47 29.41

1 Crude petroleum, natural gas, and geothermal 68.18 31.82 27.27 18.18

2 Coal and lignite mining 78.57 35.71 14.29 21.43

3 Iron ore mining 78.57 10.71 14.29 28.57

4 Other mining and quarrying 85.29 5.88 5.88 20.59

C. Manufacturing 91.18 17.65 8.82 17.65

1 Manufacture of coal and refined petroleum products 85.71 7.14 14.29 14.29

a. Manufacture of coal 50.00 0.00 50.00 50.00

b. Manufacture of refined petroleum products 91.67 8.33 8.33 8.33

2 Manufacture of food products and beverages 88.24 8.82 2.94 8.82

3 Manufacture of tobacco products 83.33 5.56 5.56 22.22

4 Manufacture of textiles; and wearing apparel 88.24 5.88 2.94 11.76

5 Manufacture of leather and related products and footwear

81.82 4.55 4.55 9.09

6 Manufacture of wood and of products of wood and 88.24 8.82 2.94 11.76

ECE/CES/GE.20/2024/18

7

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

cork, and articles of straw and plaiting materials

7 Manufacture of paper and paper products, printing and reproduction of recorded media

85.29 5.88 2.94 11.76

8 Manufacture of chemicals and pharmaceuticals and botanical products

82.35 5.88 2.94 11.76

9 Manufacture of rubber, rubber products and plastics products

84.38 6.25 3.13 12.50

10 Manufacture of other non-metallic mineral products 91.18 5.88 5.88 11.76

11 Manufacture of basic metals 84.21 15.79 0.00 21.05

12 Manufacture of fabricated metal products, computer, and optical products, and electrical equipment

85.29 5.88 2.94 11.76

13 Manufacture of machinery and equipment 85.00 10.00 5.00 15.00

14 Manufacture of transport equipment 87.88 6.06 3.03 12.12

15 Manufacture of furniture 88.24 5.88 2.94 11.76

16 Other manufacturing, repair and installation of machinery and equipment

88.24 5.88 2.94 11.76

D. Electricity and Gas 82.35 14.71 38.24 20.59

1 Electricity 67.65 14.71 38.24 17.65

2 Manufacture of gas and production of ice 82.35 5.88 17.65 17.65

E. Water supply, sewerage, waste management and remediation activities

79.41 11.76 26.47 17.65

F. Construction 79.41 8.82 0.00 14.71

G. Wholesale and retail trade; repair of motor vehicles and motorcycles

82.35 2.94 8.82 17.65

1 Wholesale and retail trade and repair of motor vehicles and motorcycles

79.41 2.94 8.82 14.71

2 Wholesale trade and retail trade except of motor vehicles and motorcycles

79.41 2.94 2.94 17.65

H. Transportation and storage 91.18 8.82 8.82 14.71

1 Railways transport 70.00 0.00 10.00 20.00

2 Land transport 88.24 5.88 2.94 14.71

ECE/CES/GE.20/2024/18

8

Industry

Percentage of Provinces by Source of Data Used (%)

BPS ministries/ agencies/

institutions

Company reports Others

(1) (2) (3) (4) (5)

3 Sea transport 87.88 3.03 0.00 12.12

4 River, lake, and ferry transport 84.85 6.06 0.00 12.12

5 Air transport 88.24 2.94 5.88 14.71

6 Warehousing and support services for transportation, postal and courier

88.24 5.88 2.94 14.71

I. Accommodation and food and beverage service activities

94.12 2.94 0.00 14.71

1 Accommodation 88.24 2.94 0.00 14.71

2 Food and beverage service activities 94.12 2.94 0.00 14.71

J. Information and communication 88.24 2.94 2.94 17.65

K. Financial and insurance activities 88.24 8.82 2.94 14.71

1 Financial intermediary services 85.29 8.82 2.94 14.71

2 Insurance and pension fund 85.29 8.82 2.94 14.71

3 Other financial services 82.35 8.82 2.94 14.71

4 Financial supporting services 82.35 5.88 2.94 14.71

L. Real estate 85.29 2.94 2.94 14.71

M,N. Business activities 88.24 2.94 2.94 14.71

O. Public administration and defence; compulsory social security

79.41 11.76 0.00 11.76

P. Education 91.18 8.82 2.94 14.71

Q. Human health and social work activities 94.12 11.76 2.94 14.71

R,S,T,U. Other services activities 91.18 2.94 2.94 14.71

7. Furthermore, an identification of the strength of data and indicator is also conducted. This is to see to what extent the data or indicator for compiling GRDP of regencies and cities is available. The strength of data sources is grouped into 3 types, namely:

• Basic (Main) Data Available: The strength of data in this classification is based on the availability of production/income data on a quarterly basis at the regency/city level.

• Indicator Data Available: The strength of data in this classification is based on the absence of basic or main production/income data on a quarterly basis at the regency/city level. However, there are related production indicators available on a a quarterly basis at the regency/city level, such as the number of workers, export of goods, tourist arrivals, household consumption, and restaurant taxes. This

ECE/CES/GE.20/2024/18

9

classification also includes the use of processed sample data from quarterly surveys that cannot be used to estimate up to the regency/city level, such as the Special Quarterly Production Accounts Survey for Goods and Services (SKTNP).

• Data and Indicators Not Available: The strength of data in this classification indicates the absence of production data and indicators on a quarterly basis at the regency/city level, thus the compilation of GRDP is estimated from data/indicators on an annual basis or from data/indicators at the provincial/national level. This classification also includes the compilation of GRDP by industry that are solely based on phenomena or statistical modeling.

8. The results of the identification of the strength of data sources/production indicators for the compilation of quarterly GRDP by industry are shown in Table 3:

Table 3 Strength of data sources by industry

Industry

Percentage of Regencies and Cities by the strength of data source (%)

Basic data available

Indicator data available

Data and indicator not

available

(1) (2) (3) (4)

A. Agriculture, forestry and fishing 40.67 14.21 45.12

1a Food crops 91.19 1.17 7.63

1b Horticultural crops 76.37 6.25 17.38

1c Plantation crops 20.32 11.50 68.18

1d Annual horticultural crops and others 70.57 5.85 23.59

1e Other plantation 26.88 21.59 51.53

1f Livestock 28.60 28.02 43.39

1g Agriculture services and hunting 0.00 24.61 75.39

2 Forestry and Logging 15.67 7.84 76.49

3 Fishery 29.18 20.23 50.58

B. Mining and quarrying 10.77 45.91 43.32

1 Crude petroleum, natural gas, and geothermal 47.30 21.62 31.08

2 Coal and lignite mining 28.07 19.30 52.63

3 Iron ore mining 5.33 21.33 73.33

4 Other mining and quarrying 4.90 60.20 34.90

C. Manufacturing 7.11 25.53 67.36

1a Manufacture of coal 14.29 0.00 85.71

1b Manufacture of refined petroleum products 17.95 35.90 46.15

2 Manufacture of food products and beverages 10.12 52.14 37.74

ECE/CES/GE.20/2024/18

10

Industry

Percentage of Regencies and Cities by the strength of data source (%)

Basic data available

Indicator data available

Data and indicator not

available

(1) (2) (3) (4)

3 Manufacture of tobacco products 16.02 23.20 60.77

4 Manufacture of textiles; and wearing apparel 6.37 32.87 60.76

5 Manufacture of leather and related products and footwear

11.70 15.85 72.45

6 Manufacture of wood and of products of wood and cork, and articles of straw and plaiting materials

6.07 28.38 65.56

7 Manufacture of paper and paper products, printing and reproduction of recorded media

5.82 21.83 72.35

8 Manufacture of chemicals and pharmaceuticals and botanical products

7.06 20.31 72.63

9 Manufacture of rubber, rubber products and plastics products

8.29 26.24 65.47

10 Manufacture of other non-metallic mineral products 6.28 22.47 71.26

11 Manufacture of basic metals 11.35 19.15 69.50

12 Manufacture of fabricated metal products, computer, and optical products, and electrical equipment

5.17 18.75 76.08

13 Manufacture of machinery and equipment 3.43 12.25 84.31

14 Manufacture of transport equipment 4.91 17.06 78.04

15 Manufacture of furniture 6.20 30.00 63.80

16 Other manufacturing, repair and installation of machinery and equipment

5.35 20.37 74.28

D. Electricity and Gas 30.51 25.05 44.44

1 Electricity 56.13 18.77 25.10

2 Manufacture of gas and production of ice 3.72 31.61 64.67

E. Water supply, sewerage, waste management and remediation activities

52.78 36.71 10.52

F. Construction 0.97 56.81 42.22

G. Wholesale and retail trade; repair of motor vehicles and motorcycles

2.63 36.90 60.47

1 Wholesale and retail trade and repair of motor vehicles and motorcycles

0.58 39.77 59.65

ECE/CES/GE.20/2024/18

11

Industry

Percentage of Regencies and Cities by the strength of data source (%)

Basic data available

Indicator data available

Data and indicator not

available

(1) (2) (3) (4)

2 Wholesale trade and retail trade except of motor vehicles and motorcycles

4.67 34.05 61.28

H. Transportation and storage 15.38 32.20 52.42

1 Railways transport 23.73 48.31 27.97

2 Land transport 0.78 30.86 68.36

3 Sea transport 33.74 41.15 25.10

4 River, lake, and ferry transport 17.97 25.42 56.61

5 Air transport 60.44 25.27 14.29

6 Warehousing and support services for transportation, postal and courier

1.76 31.96 66.27

I. Accommodation and food and beverage service activities

10.17 64.81 25.02

1 Accommodation 20.20 64.71 15.10

2 Food and beverage service activities 0.19 64.91 34.89

J. Information and communication 0.19 21.44 78.36

K. Financial and insurance activities 3.20 20.03 76.77

1 Financial intermediary services 11.13 17.19 71.68

2 Insurance and pension fund 0.00 21.15 78.85

3 Other financial services 0.40 27.15 72.46

4 Financial supporting services 0.25 13.38 86.36

L. Real estate 7.00 24.90 68.09

M,N. Business activities 2.54 32.42 65.04

O. Public administration and defence; compulsory social security

55.06 40.27 4.67

P. Education 5.06 63.23 31.71

Q. Human health and social work activities 3.50 61.48 35.02

R,S,T,U. Other services activities 5.84 47.67 46.05

Overall 16.66 29.90 53.44

ECE/CES/GE.20/2024/18

12

9. Based on the recapitulation of data source strength above, it is shown that the strength of data sources varies across industries. Most industries are not supported by strong data or indicators. Only a few industries have the availability of basic data on a quarterly basis down to the regency/city level, namely: Food crops (A.1.a); Horticultural crops (A.1.b); horticultural crops and others (A.1.d); Crude petroleum, natural gas, and geothermal mining (B.1); Electricity (D.1); Water supply, sewerage, waste management and remediation activities (E); Air transport (H.5); and, Public administration and defence; compulsory social security (O).

B. Calculation methodology

10. The study on compiling quarterly GRDP of regencies and cities consists of benchmarking the annual GRDP data to quarterly for the period of 2018 – 2022, followed by estimating the GRDP of regencies and cities for Quarter I and II year 2023. The study involves BPS’ staffs in the 514 regional BPS offices. Due to resource and time constraints, staff from the headquarters and provincial BPS offices assisted in compiling the quarterly GRDP for regencies.

1. Benchmarking Annual GRDP to Quarterly GRDP for Regencies and Cities

Benchmarking is a procedure aimed at ensuring that quarterly data is consistent with annual data. This is based on the assumption that annual estimates are considered superior to quarterly estimates, given that annual data is usually more comprehensive and accurate compared to quarterly data.

The benchmarking process can involve interpolating annual data to construct a "back series" or extrapolating to produce quarterly estimates when annual data is not yet available ("forward series"). The benchmarking process must preserve as much as possible the movements of the original indicators, with the given constraints. In the case of interpolation, the number of data points for the 4 quarters must match the annual data. In the case of extrapolation, the forward series estimates should closely resemble the unknown annual data. For some cases where the availability of quarterly data is sufficiently good, the benchmarking procedure is not required.

The benchmarking principle is based on a measure called the Benchmark-to-Indicator (BI) Ratio. The BI Ratio can be used to identify whether the movement of benchmarked data aligns with its indicators. The BI Ratio is formulated as follows:

𝐵𝐵𝐵𝐵 𝑅𝑅𝑅𝑅𝑅𝑅𝑅𝑅𝑅𝑅 = 𝐵𝐵𝑡𝑡 𝐵𝐵𝑡𝑡

where:

𝐵𝐵𝑡𝑡 is the benchmark result for period t; and

𝐵𝐵𝑡𝑡 is an indicator in period t.

The benchmarking process of quarterly GRDP conducted by most provinces utilizes the Denton Proportional Method. The principle of the Denton method is to maintain the BI Ratio as stable as possible within given constraints. Benchmarking using the Denton Proportional Method is carried out by minimizing the function:

�� 𝐵𝐵𝑡𝑡 𝐵𝐵𝑡𝑡 − 𝐵𝐵𝑡𝑡−1 𝐵𝐵𝑡𝑡−1

� 𝑞𝑞

𝑡𝑡=2

2

within the constraint of ∑ 𝐵𝐵𝑡𝑡 = 𝐴𝐴𝑛𝑛4𝑛𝑛 4=4𝑛𝑛−3 for n = 1, ..., y

where:

𝐵𝐵𝑡𝑡 is the quarterly estimate level for quarter t;

𝐵𝐵𝑡𝑡 is the quarterly indicator level for quarter t;

𝐴𝐴𝑛𝑛 is the annual estimated level for the year n;

ECE/CES/GE.20/2024/18

13

n is the time index for the year;

t is the time index for the quarter; and

y is the last year of available data.

In the Denton method, changes in the BI Ratio between years are smoothed to minimize sudden changes during the transition of years. Thus, the Denton method can reduce the "step problem." Growth in Denton results also tends to align with the growth of the original indicator. However, not all provinces use the Denton method in compiling quarterly GRDP. The Riau Archipelago Province and the Special Region of Yogyakarta use indirect methods in compiling quarterly GRDP for the period 2018- 2022. Some other provinces also use different methods, East Java province for instance, applying allocation methods; North Kalimantan, conducting benchmarking studies of GRDP of regencies and cities; and, North Sulawesi, utilizing pro rata adjustment methods.

2. Estimating Quarterly GRDP of Regencies and Cities for The Current and Subsequent Periods

Methods to estimate quarterly GRDP of regencies and cities for 2023 period are carried out through two methods, namely Direct Method, and Indirect Method. The direct method is a calculation method using data sourced from each region. Using the direct method, quarterly GRDP of regencies and cities can be measured by three different approaches: production, income, and expenditure approach. The production approach measures the value added of goods and services produced by all economic activities by subtracting intermediate costs from each gross production value of each industry. In the income approach, the value added of each economic activity is measured by summing up all factor income payments, namely labor compensation, business surplus, consumption of fixed capital, and taxes minus other subsidies on production. Lastly, the expenditure approach focuses on the final use of goods and services within the regencies/cities.

The indirect method is a calculation method using allocation, which allocates Provincial GRDP into Regency/City GRDP using various production indicators or other suitable indicators as allocators. One assumption used in the allocation method is the availability of good Provincial GRDP data. Without good Provincial GRDP data, the results of the allocation method for districts/cities will not be satisfactory.

3. Calculating Quarterly GRDP of Regencies and Cities at Constant Price

Quarterly GRDP of regencies and cities at constant price can be obtained through revaluation, extrapolation, deflation, and double deflation methods. In the revaluation method, output at constant prices is calculated by multiplying the current quarter's production quantity by the base year prices. In the extrapolation method, the output at constant prices is calculated by multiplying the value of output at base year current prices by a production index. In the deflation method, the output at constant prices is calculated by dividing the current quarter value by a price index. Lastly, in the double deflation method, both output at constant prices and intermediate consumption at constant prices are calculated by dividing the current quarter value by a price index.

III. Results

11. The activity of compiling quarterly GRDP of regencies and cities results in the quarterly GRDP by industry of 514 regencies and cities of Indonesia, comprising of 17 categories of industries, from the first quarter of 2018 to the second quarter of 2023. After reconciling quarterly GRDP between Provincial GRDP and regency/city GRDP, discrepancies were still found as shown in Table 4.

Table 4 Average of (Absolute) Discrepancy between provincial and regency/city GRDP

ECE/CES/GE.20/2024/18

14

Period Average of absolute discrepancy (percentage) GRDP at current price GRDP at constant price

(1) (2) (3) Q1 - 2018 0.73 0.73 Q2 - 2018 0.70 0.65 Q3 - 2018 0.68 0.58 Q4 - 2018 0.68 0.66 Y - 2018 0.54 0.56

Q1 - 2019 1.10 0.93 Q2 - 2019 0.74 0.70 Q3 - 2019 0.70 0.70 Q4 - 2019 0.75 0.77 Y - 2019 0.57 0.65

Q1 - 2020 1.36 1.34 Q2 - 2020 0.98 0.96 Q3 - 2020 1.00 0.81 Q4 - 2020 0.76 0.68 Y - 2020 0.53 0.62

Q1 - 2021 1.30 1.25 Q2 - 2021 0.85 0.78 Q3 - 2021 0.68 0.73 Q4 - 2021 0.70 0.69 Y - 2021 0.49 0.60

Q1 - 2022 1.03 0.70 Q2 - 2022 0.77 0.87 Q3 - 2022 0.57 0.75 Q4 - 2022 0.73 0.64 Y - 2022 0.47 0.66

Q1 - 2023 1.59 1.19 Q2 - 2023 3.80 2.20

12. Based on the table 4, it can be seen that the average discrepancy between quarterly provincial GRDP and quarterly GRDP of regencies and cities is mostly less than 1 percent. In the reconciliation phase, BPS set a limit that the total discrepancy of GRDP should be less than 5 percent and the discrepancy at the category level should be less than 7 percent. Although on average, the total discrepancy of GRDP both at current prices and constant prices is below 5 percent, when viewed by province, there are still 6 provinces that have not met the requirement of total GRDP discrepancy, namely West Java, Central Kalimantan, West Sulawesi, DKI Jakarta, Riau Archipelago, and Papua. West Java Province still has a discrepancy above 5 percent for the first quarter of 2019, Central Kalimantan Province still has a discrepancy above 5 percent for the first quarter of 2019-2023, West Sulawesi Province still has a discrepancy above 5 percent for the second and third quarters of 2020, DKI Jakarta Province still has a discrepancy above 5 percent for the first and second quarters of 2023, while Riau Archipelago Province and Papua Province still have a discrepancy above 5 percent in the second quarter of 2023.

IV. Conclusion

13. The compilation of quarterly GRDP of 514 regencies and cities of Indonesia by industry relies significantly on the availability of data and indicators from BPS alongside ministries/agencies/institutions. While data on production primarily stems from BPS and ministries/agencies/institutions, certain industry subcategories still lack sufficient support from these sources. Meanwhile, all price data and indicators utilize data from BPS. Addressing the data deficit requires strengthened collaboration between BPS and relevant ministries/agencies/institutions so that it can obtain comprehensive data for all necessary categories/subcategories essential for calculating quarterly GRDP of 514 regencies and cities of Indonesia.

ECE/CES/GE.20/2024/18

15

14. Additionally, beyond the focus on data evaluation as an asset, another critical challenge is the limited number of qualified personnel and their understanding on national accounting, particularly within the BPS offices at the regency/city level. Therefore, facilitating capacity-building initiatives is expected to significantly enhance competency in compiling quarterly regency/city GRDP by industry.

15. The study reveals that most provinces use the Denton Proportional method for benchmarking quarterly GRDP for regencies and cities by industry for the 2018-2022 estimates. Some provinces utilize alternative methods such as the indirect approach, allocation method, and pro-rata adjustment. Notably, despite the widespread use of the Denton method, benchmarking outcomes for certain categories/subcategories may still exhibit suboptimal data patterns, often influenced by the selection of benchmarking indicators.

16. In general, the reconciliation process between provincial GRDP and regencies/cities GRDP has been useful in minimizing discrepancies between provincial GRDP and the total regencies/cities GRDP. The discrepancy can be eliminated by narrowing the limitations in the future work.

17. The study was conducted within a relatively short timeframe, which posed challenges given the involvement of human resources from regional BPS offices (regencies and cities). It is essential to recognize that these individuals are often engaged in various tasks, which limited the time available to complete the study. Consequently, the allocated time for compiling the quarterly GRDP of regencies and cities was deemed insufficient, warranting consideration for an extension.

18. Policymakers' demand for rapid economic indicators to inform tailored policies for each regency and city underscores the importance of this study. While acknowledging the study's imperfections and limitations highlighted throughout the paper, it remains a valuable foundation for future refinement and improvement.

  • Group of Experts on National Accounts
  • Twenty-third session
  • The Compilation of Quarterly GRDP of 514 Regencies and Cities in Indonesia (A recent study in Statistics Indonesia)
    • Prepared by BPS-Statistics Indonesia0F
  • I. Introduction
  • II. Methodology
    • A. Data
    • B. Calculation methodology
  • III. Results
    • IV. Conclusion

Compilation and Utilisation of the Financial Account of the Household Sector (Indonesia)

Compilation and Utilisation of the Financial Account of the Household Sector: Experience, Challenges, and Opportunities

  1. Introduction: Overview of Financial Account and Balance Sheet Indonesia (FABSI)
  2. Compilation Practices of Household Sector’s Financial Account
  3. Utilisation of Household Sector’s Financial Account
  4. Next Steps
Languages and translations
English

Compilation and Utilisation of the Financial Account of the

Household Sector: Experience, Challenges, and Opportunities

Brussels, 11 October 2023

Bank Indonesia Statistics Department

Monetary and Fiscal Statistics Division

Outline

2

1 Introduction: Overview of Financial Account and Balance Sheet of Indonesia (FABSI)

2 Compilation Practices of Household Sector’s Financial Account

3 Utilisation of Household Sector’s Financial Account

4 Next Steps

3

1. Introduction

• To analyze liquidity, financial imbalances, and intersectoral systemic risks financial system stability assessment. • As data input for Sectoral Account and Balance Sheets (SAB) Indonesia (G20 DGI Phase 2 rec #8)

Purpose

Concept and Framework

FINANCIAL ACCOUNT (FA) A statement that records net transactions with financial assets and liabilities between institutional sectors in a specific period.

BALANCE SHEET (BS) A statement of the values of the financial assets owned and the liabilities owed by an institutional unit at a specific time.

Non Financial Corporations Households + NPISHOther Depository

Corporations Other Financial Corporations

Central Bank Central Government

Local Government

Rest of the World

SECTORS

EquityMonetary Golds & SDRs

Currency & Deposits

Debt Securities Loans Insurance & Pension Funds

Financial Derivative

Other accounts receivable/payable

INSTRUMENTS

MANUAL System of National Accounts (2008)

Description Financial Account and Balance Sheet Indonesia (FABSI) is a quarterly internal publication with a data lag of 4 months.

Balance Sheet (opening)

Financial Account (transaction)

Revaluation and Other Changes (others)

Balance Sheet (closing)

PUBLICATIONCOMPILATIONCOLLECT

Financial Account and Balance Sheet

Analysis

DATA SOURCES

Infographic

Outputs

Sectoral Account Balance Sheet (SAB) Indonesia –

G20 DGI II.8

Statistics Indonesia

Internal Bank Indonesia

Supply Data for Sectoral Accounts and Balance

Sheet (SAB)

Banks Financial Report

BOP, IIP, Indonesia External Debt Statistics

Gov Finance Stat - MoF

Bloomberg

Financial Account Dataset

Balance Sheets Dataset

Sectoral Balance Sheet – CG & LG

Sectoral Balance Sheet - ODC

Sectoral Balance Sheet – CB Sectoral Balance

Sheet - NFC

Whom to Whom Matrix

NFC : Non Financial Corp

CB : Central Bank

ODC : Other Deposit Taking Corporations

OFC : Other Financial Corporations

Gov : Government

HH & NPISHs : Household & Non Profit Institutions serving households

ROW : Rest of the World

CB Financial Report

OFCs Financial Report

State –owned enterprises Financial Report

Tax Report - MoF

Sectoral Balance Sheet – HH &

NPISH

Sectoral Balance Sheet - ROW

Sectoral Balance Sheet - OFC

1. Introduction

MoF: Ministry of Finance

BOP: Balance of Payments IIP: International Investment Position GFS: Gov Finance Statistics

Survey

Central Securities Depository

BI-Scripless Securities Settlement System

Data Source Periodicity Lag Source Notes

Household accounts survey

Annual ~ 4 months Bank Indonesia Samples: around 6,000 households in 21 provinces (~90% HH population).

Instruments: F2, F3, F4, F5, and Non-Financial Assets (NFA).

Tax report Annual ~ 6 months Ministry of Finance Aggregate data.

Instruments: F2--F8 and NFA.

Capital market statistics Monthly ~ 1 month Central Securities Depository Instrument: F3 5

2. Compilation Practices of Household Sector’s Financial Account

HH data availability

HH’s financial instruments

Assets Liabilities

F2 Currency and Deposits F4 Loans

F3 Debt securities F7 Financial derivatives

F4 Loans F8 Other accounts payable

F5 Equity

F6 Insurance and Pensions

F7 Financial derivatives

F8 Other accounts receivable

6

Lagging data

Lack of data availability

Incomplete data from source

Challenges

1

2

3

Solution

1 Data mirroring

2 Estimation: e.g. by proportion

2. Compilation Practices of Household Sector’s Financial Account

Weaknesses

1 Inaccurate data

2 Undervalued data

HHA L

Loans 120Deposits 10

Deposits owned by HH

10

ODCA L

Loans to HH 100

OFCA L

Loans to HH 20

Data mirroring

2. Compilation Practices of Household Sector’s Financial Account

Instruments Households

(HH)

Non-financial Produced non-financial assets 145.9

Fixed assets 140.8 Inventories - Valuables 5.1

Non-produced non-financial assets 21.3 Total NonFinancial Assets 167.2

Financial Account (Trillion Rp)

Net Lending/Borrowing

Instruments Households

(HH)

Financial assets Monetary gold and SDRs - Currency and deposits 188.2 Debt securities 35.8 Loans (2.2) Equity 40.3 Insurance and pension (12.7) Financial derivatives (0.0) Other accounts receivable 4.0 Total Financial Assets 253.4 Total NonFinancial Assets 167.2 Total Assets 420.7

Financial Liabilities Monetary gold and SDRs - Currency and deposits - Debt securities - Loans 117.1 Equity - Insurance and pension - Financial derivatives (0.1) Other accounts payable 1.3 Total Financial Liabilities 118.3

135.2 8

Data estimation

Loans flows = 70% NFA flows

87.3% Fixed 96.5% proportion, 0.0% based on 3.5% Household 12.7% Accounts 100% Survey

2. Compilation Practices of Household Sector’s Financial Account

Data mirroring Fixed proportion, based on Household Accounts Survey

1

2

3

9

Data source

Code Instrument Data Source - HH Asset On

NFC CB ODC OFC CG ROW

F1 Mon’ Gold & SDRs

F2 Currency & Deposit Mirroring CB BS (SRF 1SR)

Mirroring Bank Reporting (SRF 2SR)

N/A

F3 Debt Securities Central Securities Depository

BI-Scripless Securities Settlement System

Mirroring Bank Reporting (SRF 2SR)

Central Securities Depository

BI-Scripless Securities Settlement System

N/A

F4 Loans - Mirroring Bank Reporting (SRF 2SR)

Mirroring OFC Reporting (SRF 4SR)

N/A

F5 Equity Bloomberg Mirroring Bank Reporting (SRF 2SR)

Mirroring OFC Reporting (SRF 4SR)

N/A

F6 Insurance & Pension Fund

Mirroring OFC Reporting (SRF 4SR)

N/A

F7 Financial Derivatives Mirroring Bank Reporting (SRF 2SR)

- N/A

F8 Other Account Receivable

Bloomberg Mirroring CB BS (SRF 1SR)

Mirroring Bank Reporting (SRF 2SR)

Mirroring OFC Reporting (SRF 4SR)

-Ministry of Finance N/A

2. Compilation Practices of Household Sector’s Financial Account

Not relevant

10

Data source

Code Instrument Data Source - HH Liab On

NFC CB ODC OFC CG ROW

F1 Mon’ Gold & SDRs

F2 Currency & Deposit

F3 Debt Securities

F4 Loans - Mirroring CB BS (SRF 1SR)

Mirroring Bank Reporting (SRF 2SR)

Mirroring OFC Reporting (SRF 4SR)

Ministry of Finance

N/A

F5 Equity

F6 Insurance & Pension Fund

F7 Financial Derivatives Mirroring Bank Reporting (SRF 2SR)

F8 Other Account Payable Bloomberg, Ministry of Finance

Mirroring CB BS (SRF 1SR)

Mirroring Bank Reporting (SRF 2SR)

Mirroring OFC Reporting (SRF 4SR)

Ministry of Finance

2. Compilation Practices of Household Sector’s Financial Account

Not relevant

11

3. Utilisation of Household Sector’s Financial Account Network Analysis

Net lending Net borrowing Net financial assets

Net financial liabilities

Network shows the position of a sector, which is described as nodes , and connected by edges, which are the size of interconnected exposures.

Network is formed using the whom-to-whom matrix which contains information regarding the bilateral exposure position between institutional sectors.

Network analysis using Financial Account (FA) and Balance Sheet (BS) data helps to understand the interconnection and potential risk transmission between sectors.

Bilateral exposure reflects sectoral balance sheets that are interconnected potentially trigger systemic risk when a shock occurs in one of the sectors.

NET FINANCIAL TRANSACTION NETWORK FINANCIAL POSITION NETWORK

12

3. Utilisation of Household Sector’s Financial Account

LEVERAGE RATIO AND SOLVENCY RATIO OF HOUSEHOLDS SECTOR

Risk Profile Analysis

Leverage ratio measures the capacity of a sector to repay its debts.

Solvency ratio measures the ability of a sector to meet its long-term obligations

13

4. Next Steps

Next steps to improve the accuracy of households’ financial accounts:

1 Strengthening institutional cooperation between BI and Ministry of Finance to obtain full tax report, especially to capture Assets/Liabilities of unlisted company to households.

2 Evaluating/improving the sample coverage of Household Accounts Survey, especially for high-income group.

3 Coordinating with Statistics Indonesia to obtain households’ financial account data quarterly.

Thank You

  • Compilation and Utilisation of the Financial Account of the Household Sector:
  • Outline
  • 1. Introduction
  • 1. Introduction
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 2. Compilation Practices of Household Sector’s Financial Account
  • 3. Utilisation of Household Sector’s Financial Account
  • 3. Utilisation of Household Sector’s Financial Account
  • 4. Next Steps
  • Thank You
Russian

Составление и использование финансового счета сектора

домохозяйств: Опыт, вызовы и возможности

Брюссель, 11 октября 2023 г.

Банк Индонезии Департамент статистики

Отдел монетарной и фискальной статистики

Содержание

2

1 Введение: Обзор финансовых счета и баланса активов и пассивов Индонезии (FABSI)

2 Практика составления финансового счета сектора домашних хозяйств

3 Использование финансового счета сектора домашних хозяйств

4 Дальнейшие шаги

3

1. Введение

• Анализ ликвидности, финансовых дисбалансов и межотраслевых системных рисков оценка стабильности финансовой системы.

• В качестве исходных данных для секторальных счетов и балансов активов и пассивов Индонезии (SAB) (Инициатива по устранению пробелов в данных G20 DGI, фаза 2, зап. #8)

Назначение

Концепция и структура

ФИНАНСОВЫЙ СЧЕТ (ФС) Отчет, отражающий чистые операции с финансовыми активами и обязательствами между институциональными секторами за определенный период времени.

БАЛАНС АКТИВОВ И ПАССИВОВ (БАП) Отчет о стоимости принадлежащих финансовых активов и обязательств задолженных институциональной единице в определенный момент времени.

Нефинансовые корпорацииs Домохозяйства +

НКОДХ

Другие корпораций, принимающие

депозиты

Другие финансовые корпорации

Центральный банк

Центральные органы

управления Местные

органы управления

Остальной мир

СЕКТОРА

Акционерный капитал

Монетарное золото и СПЗ

Наличная валюта и депозиты

Долговые ценные бумаги

Ссуды Страховые и пенсионные фонды

Производные финансовые инструменты

Прочая дебиторская или кредиторская задолженность

ИНСТРУМЕНТЫ

РУКОВОДСТВА Система национальных счетов (2008)

Описание Финансовый счет и баланс активов и пассивов Индонезии (FABSI) является ежеквартальной внутренней публикацией с задержкой публикации данных – 4 месяца.

Баланс активов и пассивов (начальный)

Финансовый счет (операция)

Переоценка и другие изменения (другие)

Баланс активов и пассивов (заключительный)

ПУБЛИКАЦИЯСОСТАВЛЕНИЕСБОР

Анализ финансовых счетов и БАП

ИСТОЧНИКИ ДАННЫХ

Инфографика

Выпуск

Секторальный счет и балансов активов и

пассивов Индонезии (SAB)– G20 DGI II.8

Стат. управление Индонезии

Внутренний банк Индонезии

Поставка данных для секторальных счетов

и БАП (SAB)

Финансовая отчетность банков

ПБ, МИП, Статистика внешнего долга Индонезии

Статистика Гос. Финанс. - МФ

Bloomberg

Набор данных финансовых счетов

Набор данных БАП

Секторальный БАП – ЦОУ и МОУ

Секторальный БАП - ДКПД

Секторальный БАП – ЦБ Секторальный БАП

- НФК

Матрица «от кого к

кому»

НФК: Нефинансовые корпорации

ЦБ : Центральный банк

ДКПД : Другие корпораций, принимающие депозиты

ДФК : Другие финансовые корпорации

ОУ : Органы госуправления (местные/центральные)

ДХ и НКОДХ: домохозяйства и Некоммерческие организации, обслуживающие домашние хозяйства

ОМ : Остальной мир

Финансовый отчет ЦБ

Финансовый отчет ДФК

Финансовый отчет государственных предприятий

Налоговая отчетность - Мф

Секторальный БАП - ДХ и НКОДХ

Секторальный БАП - ОМ

Секторальный БАП - ДФК

1. Введение

МФ: Министерство финансов ПБ: Платежный баланс МИП: Междун. инвест. позиция СГФ: Статистика госфинансов

Обследование

Центр. Депозит. ценных бумаг

Сист. расч. по бездокументарным ценным бумагам Банка Индонезии

Presenter Notes
Presentation Notes
МОУ – местные органы госуправления, ЦОУ – центральные органы госуправления

Источники данных Периодичность Задержка Source Notes

Обследование счетов домашних хозяйств

Ежегодно ~ 4 месяца Банк Индонезии Выборки: около 6000 домохозяйств в 21 провинции (~90% населения ДХ).

Инструменты: F2, F3, F4, F5, and нефинансовые активы (НФА).

Налоговый отчет Ежегодно ~ 6 месяца Министерство финансов Агрегированные данные.

Инструменты: F2--F8 и НФА.

Статистика по рынку капитала

Ежемесячно ~ 1 месяц Центральный депозитарий ценных бумаг

Инструмент: F3 5

2. Практика составления финансового счета сектора домохозяйств

Наличие данных о ДХ

Финансовые инструменты ДХ

Активы Обязательства

F2 Наличная валюта и депозиты F4 Ссуды

F3 Долговые ценные бумаги F7 Производные финансовые инструменты

F4 Ссуды F8 Прочая дебиторская или кредиторская задолженность

F5 Акционерный капитал

F6 Страхование и пенсионное обеспечение

F7 Производные финансовые инструменты

F8 Прочая дебиторская или кредиторская задолженность

6

Запаздывающие данные

Отсутствие наличия данных

Неполные данные из источников

Вызовы

1

2

3

Решения

1 Зеркальное отображение данных

2 Оценка: например, пропорционально

2. Практика составления финансового счета сектора домохозяйств

Слабые стороны

1 Неточные данные

2 Недооценка данных

ДХA L

Ссуды 120Депозиты 10

Депозиты, принадлежащие ДХ

10

ДКПДA L

Ссуды выданные Домохозяйствам

100

ДФКA L

20

Зеркальное отображение данных

2. Практика составления финансового счета сектора домохозяйств

Ссуды выданные Домохозяйствам

Инструменты Домашние

хозяйства (ДХ)

Нефинансовые Произведенные нефинансовые активы 145.9

Основные средства 140.8 Запасы - Ценности 5.1

Непроизведенные нефинансовые активы 21.3 Всего нефинансовых активов 167.2

Финансовый счет (трлн. Rp)

Net Lending/Borrowing

Инструменты Домашние

хозяйства (ДХ) Финансовые активы Монетарное золото и СДР - Наличная валюта и депозиты 188.2 Долговые ценные бумаги 35.8 Ссуды (2.2) Акционерный капитал 40.3 Страхование и пенсионное обеспечение (12.7) Производные финансовые инструменты (0.0) Прочая дебиторская задолженность 4.0 Всего финансовых активов 253.4 Всего нефинансовых активов 167.2 Всего активов 420.7

Финансовые обязательства Монетарное золото и СДР - Наличная валюта и депозиты - Долговые ценные бумаги - Ссуды 117.1 Акционерный капитал - Страхование и пенсионное обеспечение - Производные финансовые инструменты (0.1) Прочая дебиторская задолженность 1.3 Всего фнансовых обязательств 118.3

Чистое кредитование/заимствование 135.2 8

Оценка данных

Потоки ссуд = 70% потоков НФА

87.3% Фиксированная 96.5% пропорция, 0.0% на основе 3.5% обследования 12.7% счетов 100% домохозяйств

2. Практика составления финансового счета сектора домохозяйств

Зеркальное отображение

данных

Фиксированная пропорция, основанная на данных обследования счетов домашних хозяйств

1

2

3

9

Источники данных

Код Инструмент Источник данных – Активы ДХ

НФК ЦБ ДКПД ДФК ЦОУ ОМ

F1 Мон. золото и СДР

F2 Наличная валюта и депозиты

Зеркальное отобр. данных ЦБ БАП (СФО 1SR)

Отчет о зерк. отобр. данных банка (СФО 2SR)

Недоступно (Н/Д)

F3 Долговые ценные бумаги

Центральный депозитарий ценных бумаг

Сист. расч. по бездокументарным ценным бумагам БИ

Отчет о зерк. отобр. данных банка (СФО 2SR)

Центральный депозитарий ценных бумаг

Сист. расч. по бездокументарным ценным бумагам БИ

Н/Д

F4 Ссуды - Отчет о зерк. отобр. данных банка (СФО 2SR)

Отчет о зерк. отобр. данных ДФК (СФО 4SR)

Н/Д

F5 Акционерный капитал

Bloomberg Отчет о зерк. отобр. данных банка (СФО 2SR)

Отчет о зерк. отобр. данных ДФК (СФО 4SR)

Н/Д

F6 Страховые и пенсионные фонды

Отчет о зерк. отобр. данных ДФК (СФО 4SR)

Н/Д

F7 Производные финансовые инструменты

Отчет о зерк. отобр. данных банка (СФО 2SR)

- Н/Д

F8 Прочая дебиторская задолженность

Bloomberg Зеркальное отобр. данных ЦБ БАП (СФО 1SR)

Отчет о зерк. отобр. данных банка (СФО 2SR)

Отчет о зерк. отобр. данных ДФК (СФО 4SR)

-Министерство финансов

Н/Д

2. Практика составления финансового счета сектора домохозяйств

Не имеет отношения

Presenter Notes
Presentation Notes
СФО – стандартизированная форма отчетности

10

Код Инструмент Источник данных – Обязательства ДХ

НФК ЦБ ДКПД ДФК ЦОУ СМ

F1 Мон. золото и СДР

F2 Наличная валюта и депозиты

F3 Долговые ценные бумаги

F4 Ссуды - Зеркальное отобр. данных ЦБ БАП (СФО 1SR)

Отчет о зеркал. отобр. данных банка (СФО 2SR)

Отчет о зеркал. отобр. данных ДФК (СФО 4SR)

Министерство финансов

Н/Д

F5 Акционерный капитал

F6 Страховые и пенсионные фонды

F7 Производные финансовые инструменты

Отчет о зеркал. отобр. данных банка (СФО 2SR)

F8 Прочая дебиторская задолженность

Bloomberg, Мин. Фин.

Зеркальное отобр. данных ЦБ БАП (СФО 1SR)

Отчет о зеркал. отобр. данных банка (СФО 2SR)

Отчет о зеркал. отобр. данных ДФК (СФО 4SR)

Министерство финансов

2. Практика составления финансового счета сектора домохозяйств

Не имеет отношения

Источники данных

11

3. Использование финансового счета сектора домохозяйств Анализ сетей

Чистое кредитование Чистое заимствование Чистые финансовые активы

Чистые финансовые обязательства

Сеть показывает положение сектора, который описывается узлами , и соединяется ребрами, которые представляют собой размеры взаимосвязанных экспозиций.

Сеть формируется с использованием матрицы «от кого кому», которая содержит информацию о положении с двусторонним воздействием между институциональными секторами.

Сетевой анализ с использованием данных финансового счета (ФС) и баланса активов и пассивов (БАП) позволяет понять взаимосвязь и потенциальную передачу рисков между секторами.

Двусторонняя экспозиция отражает взаимосвязь БАП секторов → потенциальное возникновение системного риска при возникновении потрясений в одном из секторов.

СЕТЬ ЧИСТЫХ ФИНАНСОВЫХ ОПЕРАЦИЙ СЕТЬ ФИНАНСОВОГО ПОЛОЖЕНИЯ

12

3. Использование финансового счета сектора домохозяйств

КОЭФФИЦИЕНТ ФИНАНСОВОГО РЫЧАГА И КОЭФФИЦИЕНТ ПЛАТЕЖЕСПОСОБНОСТИ СЕКТОРА ДОМАШНИХ ХОЗЯЙСТВ

Анализ профиля рисков

Коэффициент финансового рычага измеряет способность отрасли погашать свои долги.

Коэффициент платежеспособности измеряет способность отрасли выполнять свои долгосрочные

обязательства

13

4. Дальнейшие шаги

Дальнейшие шаги по повышению точности финансовых счетов домохозяйств:

1 Укрепление институционального сотрудничества между БИ и Министерством финансов для получения полной налоговой отчетности, особенно для отражения активов/обязательств не включенных в листинг компаний перед домашними хозяйствами.

2 Оценка/улучшение охвата выборки обследования счетов домашних хозяйств, особенно для группы с высокими доходами.

3 Координация со Статистическим управлением Индонезии для получения ежеквартальных данных о финансовых счетах домохозяйств.

Спасибо

  • Составление и использование финансового счета сектора домохозяйств:
  • Содержание
  • 1. Введение
  • 1. Введение
  • 2. Практика составления финансового счета сектора домохозяйств
  • 2. Практика составления финансового счета сектора домохозяйств
  • 2. Практика составления финансового счета сектора домохозяйств
  • 2. Практика составления финансового счета сектора домохозяйств
  • 2. Практика составления финансового счета сектора домохозяйств
  • 2. Практика составления финансового счета сектора домохозяйств
  • 3. Использование финансового счета сектора домохозяйств
  • 3. Использование финансового счета сектора домохозяйств
  • 4. Дальнейшие шаги
  • Спасибо

E-commerce Data Collection in Indonesia - Brilian Surya Budi, Sugiri, I Gede Putu Dharma Yusa (Statistics Indonesia)

Languages and translations
English

E-commerce Data Collection in Indonesia

12 - 14 June 2023

UNECE Expert Meeting on Statistical Data Collection 2023

Outline • WHY: collect e-commerce data in Indonesia

• WHO: types of businesses whose data is recorded

• WHAT: data will be recorded

• WHEN: data recording will be conducted

• HOW: the process of e-commerce data recording

THE NEED TO MEASURE THE DIGITAL ECONOMY FOR DATA-DRIVEN POLICY MAKING …

Digital transformation

brought by technology

improvement

• New Actors • New Products

Change how the economy

works

Required existing

economic measurement

update

DIGITAL ECONOMY

DYNAMIC ENVIRONMENT

PUBLIC-PRIVATE DATA PARTNERSHIP

DATA-DRIVEN POLICY MAKING with minimum lag

… SO IT NEEDS DATA PARTNERSHIP WITH ALL DIGITAL ECONOMIC ACTORS, MAINLY E COMMERCE …

Social commerce

1

Business Scheme

B2B B2C

C2C

2 Electronic retai

Classified

Ride hailing

Marketplace

Daily deals

Price comparison

3 4 5 6 7

Data collection in E- commerce is conducted every quarter.

high-frequency macroeconomics updates (lag: H+35)

Minimum time lag policy formulation …

Time Reference: QUARTERLY

Quarter I

1 Jan – 31 Mar

Quarter II

1 Apr – 30 Jun

Quarter III

1 Jul – 30 Sep

Quarter IV

1 Okt – 31 Des

Timelag: 16 days after after the quarter ends

Data collected from E commerce in Indonesia

E Commerce General Identity and Information

E Commerce Income & Expenses

Labor

Transaction

Origin

Expertise

Payment method

Buyer and Seller Information

Other Information Voluntary

Product Category

Data Collection Process

8

Integrated Statistics Infrastructure System (Sintesis)

Upload Data File

Integrated Collection system

Connect to data sources via ETL tool

Metadata Management System

API

INDAH Portal

Big Data Platform

Single Source of

Truth

Metadata Adjudication

-Bussiness, Operational,

Technical metadata -Katalog Konten

EDL Working Zone

Data Processing Data Analytic

EDL Gold Zone

Data Mart

DWH

Visualisation

Dashboard & Visualization

Suporting System (Knowledge Management, Data Ontology, Collaboration Tool, Identity Access Management)

Data Sharing/Access

- API Management - Data Catalog – Data Visualization

CAWI/CAPI

Data Sharing API

External System

Data Sources

SE CU

RI TY

S YS

TE M

Crawling

Transdata

Hak Akses & Dokumentasi

9

Data collection infrastructure for E commerce

Visit

Integrated Collection

system / FASIH Connect to data sources via ETL

tool

Machine to

Machine

INDAH Portal

Platform Ecommerce

Metadata Adjudication

-Bussiness, Operational, Technical metadata

-Content Catalog

Dashboard

Tabulayion data

Sharing

- API Management - Catalog Data – Tabulaton

E-form

Data Sharing API

Ecommerce Business

Collection Mode

File Upload

Transdata

Access Rights & Documentation

Thank You

Mixed Modes Data Collection Study in Statistics Indonesia - Brilian Surya Budi and Alfatihah Reno MNSPM (Statistics Indonesia)

Languages and translations
English

Mixed Mode Data Collection

12 – 14 Juni 2023

Study in Statistics Indonesia The 2023 Data Collection Expert Meeting

Outline

Why Mixed Mode Data Collection

Business Process

Integrated Collection System

Switching Mode

Respondent Engagement

Why Mixed Mode Data Collection

Pandemic situation, providing more options for interviewers and respondents’ interaction

Increase survey response rate

Maintain engagement with respondents

Business Process Mixed Mode

Interview Scenario : • First attempt : PAPI & CAPI • Second attempt : CATI • Third attempt : CAWI

Integrated Collection System

An integrated data collection system starting from the stages of design (design), development (build), collection (collect), and processing (process) using various

modes of data collection (multimode data collection)

With the process above, the interview with CATI can be done as soon as possible after create ticket

Switching Mode

All data transfer processes between systems are carried out machine-to-machine

Switching Mode (2)

Respondent Engagement

• The contact person for our respondents was obtained from the Frame Register System, which for establishment survey uses the directory in the Statistical Business Register/ using the registration data collection method for companies that are not already in the directory.

• The officer informs in advance that the respondent will be contacted using the official BPS number, this can be done via Whatsapp business or email.

• The officer calls the respondent, and conveys information related to the survey. In certain surveys, data collection is even done by telephone.

• The data collection may end in one call, or be resumed at another time by prior arrangement. Respondents are more flexible in determining the interview schedule, and do not have to meet face to face.

BPS Call Center

THANK YOU

Exploring Supporting-Phenomenon to Improve Official Statistics by Using Natural Language Processing (NLP): A Case Study in East Java, Indonesia - Joko Ade Nursiyono and Ima Sartika Dewi (Statistics Indonesia)

Languages and translations
English

Exploring Supporting-Phenomena to Improve Official Statistics by Using Natural Language Processing (NLP): A Case Study in East Java, Indonesia

Joko Ade Nursiyono, [email protected]

Ima Sartika Dewi, [email protected]

BPS - Statistics Indonesia

UNECE Expert Meeting on Statistical Data Collection

12 – 14 Juni 2023

Supporting-Phenomena as Evidence Base of Official Statistics

• Public awareness of official statistics has been raised over time

• Beside maintaining data collection process, data quality can also be improved by obtaining evidence base

• Supporting-phenomena can be very useful to complement survey- based Official Statistics products

• Text-and news-based measures as source of information to provide supporting-phenomena

Data Source and Data Collection

News scraping from several news sites

(surabayatoday.id, wartaekonomi.co.id, investor.id, cnbcindonesia.com, beritajatim.com, jatim.antaranews.com.)

521 news text data were obtained

Economic growth data of Quarter IV – 2022

(q to q) in East Java Province

Economic Phenomena in East Java Province, Indonesia

Data Processing

Delete duplicate data

Case folding Import Keyword

Dictionary

Headlines Labelling

Labeling Evaluation

Text cleaning Sentiment Labeling

Sentiment per News

Sentiment per Category

Phenomena Relevancy

News Headlines Labeling Phenomena Relevance

News Headlines Labeling using Natural Language Processing (NLP) with Latent Dirichlet Algorithm (LDA).

What we can learn

The accuracy of news headlines labeling To improve the accuracy of news headlines labeling by increasing the effectiveness of the title labeling dictionary

Match 82%

Unmatch 18%

What we can learn (2)

Phenomena data relevancy to economic growth

Category Mean Sentiment q to q Sentiment status q to q status GRDP Accuracy Total Accuracy

Accomodations -2.86 2.89 negative positive

Production Account Component

73.33

72.22

Manufacturing 4.56 1.44 positive positive

Forestry 5.00 14.07 positive positive

Financial and Insurance Activities

5.66 1.54 positive positive

Construction 0.43 4.06 positive positive

Education 8.00 5.59 positive positive

Water Supply Activities -9.56 -0.66 negative negative

Electricity 6.00 1.98 positive positive

Gas 4.03 6.19 positive positive

Food Service Activities -5.60 4.56 negative positive

Wholesale and Retail Trade 8.00 1.37 positive positive

Agriculture -2.79 -24.76 negative negative

Land Transport -2.86 3.73 negative positive

Sea Transport 1.50 1.34 positive positive

Air Transport -1.78 6.37 negative positive

Export 6.82 -6.60 positive negative Good and Services Account

Component 66.67Import -2.50 -3.45 Negative Negative

Gross Fixed Capital Formation 7.26 2.70 positive positive

“The correlation of sentiment news phenomena with economic growth is weak (namely 0.22), but the majority sentiment is in line with economic growth per category of

business fields"

Concluding Remark

• NLP is able to categorize news item text precisely as much as 82.34% • The accuracy of supporting-phenomena to official statistics on economic growth

by industries is 73.33% and by expenditure is 66.67%

• The accuracy of news phenomena to economic growth in total reaches 72.22%

• Thus, NLP are very helpful in producing supporting phenomena data as an evidence base of official statistics.

In the future…

Add more label dictionary in Natural Language Processing

Improve the quality of the sentiment label dictionary

Build a database of news phenomena

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight, Indonesia

Languages and translations
English

BADAN PUSAT STATISTIK

Presenters:

Fathia Utami Afdi BPS - Statistics Indonesia

Meeting of the Group of Experts on Consumer Price Indices

Geneva, 7th-9th June 2023

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight

Authors:

Fathia Utami Afdi Fenanda Dwitha Kurniasari

Zaradia Permatasari BPS - Statistics Indonesia

Outline

2

Introduction01

Methodology02

Results03

Conclusion and Implementation Plan

04

3

01

INTRODUCTION

4

Backgrounds

0

5

10

15

20

25

30

Food Materials Prepared food and beverages

Goods and services

Clothing, footwear, and

headgear

Parties and ceremonies

Housing and household

facilities

Others

W ei

gh t (

% )

Indonesia Expenditure Weight, 2018-2021

2018

2019

2020

2021

The CPI has an important role in determining a country's entire economy

Lesson Learned

From Pandemic

Covid-19

One of the crucial aspects in the CPI calculation is the weighting method

Facing a dynamic and rapid change in consumption behavior, a fixed expenditure weight over a long period can be no longer relevant in describing the enormous shift in household expenditure patterns.

Source: Indonesia- National Socio Economic Survey

5

BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data

as an alternative data source to approach household expenditure weights for compiling the CPI.

Objective of This Study

6

Overview of Consumer Price Survey and Household Budget Survey

Group (11)

Subgroup (43)

Commodity (835)

Price

Headline CPI

Monthly release CPI and inflation

90 cities and national

Fixed basket and weights currently used from HBS 2018

Using the Classification of Individual Consumption by Purpose (COICOP)

Held every 5 years

Currently held in 2022 and will be introduced in January 2024

Expenditure on food and non-food household consumptions

Using the Classification of Individual Consumption by

Purpose (COICOP)

Consumer Price Survey

Household Budget Survey

Presenter
Presentation Notes
Indonesia conducting the HBS every 5 years. Ini masih sejalan dengan rekomendasi pada CPI Manual untuk mengupdate bobot at least 5 tahun 1 kali

7

Overview of National Socio-Economy Survey

Capture household consumption/ expenditure in

city level every year

Availability of data on household welfare, including

education, health, and purchasing power

Using The Classification of Individual Consumption by Purpose (COICOP)

Expenditure on food (15 groups) and non-food (6

groups) household consumptions

02 03

0401

8

METHODOLOGY

03

9

1 2a 2b 2c 3 4 5Methodology 1

1. DATA PROCESSING

Data Source The Indonesian National Socio-Economic Survey (Susenas), 2018-2021

Total of commodities 296 commodities, 539 fewer than HBS 2018

Estimating total household consumption value per month by commodity

Aggregrate the expenditure value for 90 cities covered in CPI

10

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

a. MAPPING COMMODITIES

HBS2018 commodities Susenas Commodities

011101001-Rice 2-Rice

011101001-Rice 3-Sticky Rice

011101008-Sweet Potatoes 10-Cassava/Sweet Potatoes

054501001- Checkup Rates 252-Health test/early detection/Medical Check Up

054501001- Laboratorium Rates 252-Health test/early detection/Medical Check Up

For example:

2a

11

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

b. CALCULATING THE CONSUMPTION VALUE AND IMPUTATION PROCESS

Notation NK’i : Updated expenditure value for ith commodity based on Susenas NKi(hbs) : expenditure value for ith commodity based on HBS NKj(ssn) : Susenas expenditure value for commodity j which is mapped to ith commodity i : index for commodity in HBS. j : index for commodity in Susenas

Commodities Baskets Expenditure Value based on Susenas Data

011101001-Rice The sum of the rice and sticky rice consumption

011101008-Sweet Potatoes Equals to the Cassava/Sweet Potatoes consumption

054501001- Checkup Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

054501001- Laboratorium Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

2b

12

1 2a 2b 2c 3 4 5Methodology

Estimating the true value of expenditure

Proportional approach: In this case, the proportion of expenditure on more detailed commodities in the HBS is allocated to broader categories in the Susenas data

Excluding the expenditure value of the insurance, and the party and ceremonies category

Adjustments were carried out to overcome the differences in HBS and Susenas commodity details such as:

2c

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

c. ADJUSMENTS

13

1 2a 2b 2c 3 4 5Methodology

3. EVALUATION THE WEIGHT BASED ON SUSENAS DATA

Evaluation the Susenas 2018 weight Calculate the correlation

Identify changes in trends of household expenditure

patterns year to year based on Susenas weight

3

Presenter
Presentation Notes
Setelah melakukan berbagai adjustment untuk menyesuaikan Susenas dengan cakupan SBH, dilakukan evaluasi dengan menghitung korelasi

14

1 2a 2b 2c 3 4 5Methodology

4. COMPILING THE ALTERNATIVE PRICE INDICES

Elementary Level Indices

Use the same published commodity price change

As BPS-Indonesia’s practice, for elementary level we use the Jevon Formula

Upper Level Indices

Method : modified Laspeyres

Price reference period = weight reference period

Linking the index :

In this study, we started by comparing the published CPI with the Susenas price index, to see how feasible it is that Susenas data can be

used as an approach to calculate the CPI

4

15

1 2a 2b 2c 3 4 5Methodology

5. VALIDATION

Calculate the MAPE and RMSE for :

MAPE Interpretation

<10% Highly Accurate Forecasting

10-19% Good Forecasting

20-49% Reasonable Forecasting

>50% Inaccurate Forecasting

5

HBS18 weight and Susenas 18 weight in the commodity level

CPI and Alternative Price Indices in 2018

16

RESULTS

03

1717

The comparison of HBS 2018 Weight & Susenas Weight​

25,01

5,41

20,45 5,97

2,62

12,38

5,83

2,15 5,62

8,67 5,89

29,49

4,37

18,255,49 2,62

10,82

5,49 1,58

5,52

10,77

5,6

Household Budget Survey 2018 Susenas 2018

18

Correlation: 0,9812 Correlation: 0,9788

Correlation: 0,9741 Correlation: 0,9659

The larger the year gap between the HBS and Susenas, the less correlation in the weights produced by the two data sources

The correlation of HBS 2018 and Susenas

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 8

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 9

HBS 2018

0

2

4

6

0 1 2 3 4 5

Su se

na s 2

02 1

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

02 0

HBS 2018

19

29,49

28,35

29,33

30,57

2018 2019 2020 2021

Food, Beverages, and Tobacco

4,35 4,59 4,42 3,55

0

1

2

3

4

5

6

2018 2019 2020 2021

Clothing and Footwear

2,61 2,61 2,56 3,19

0

1

2

3

4

5

2018 2019 2020 2021

Health

10,93 11,32 11,48 9,41

2018 2019 2020 2021

Transport

5,48

5,28 5,25

5,64

2018 2019 2020 2021

Information, Communication, and Financial Services

1,57 1,63 1,57 1,2

0

0,5

1

1,5

2

2,5

3

2018 2019 2020 2021

Recreation, Sport, and Culture

10,77 11,12

10,8

9,67

2018 2019 2020 2021

Food and Beverage Serving Services/Restaurant

5,58 5,55 5,63

5,88

2018 2019 2020 2021

Personal Care and Other Services

The Expenditure Weight by Groups Based on Susenas, 2018-2021 (%)

Changes in Consumption Patterns Between Years Based on Susenas

20

Using the Susenas Weight to Condutct the Alternative Price Indices

98

100

102

104

106

108

110

Ja n-

18

M ar

-1 8

M ay

-1 8

Ju l-1

8

Se p-

18

N ov

-1 8

Ja n-

19

M ar

-1 9

M ay

-1 9

Ju l-1

9

Se p-

19

N ov

-1 9

Ja n-

20

M ar

-2 0

M ay

-2 0

Ju l-2

0

Se p-

20

N ov

-2 0

Ja n-

21

M ar

-2 1

M ay

-2 1

Ju l-2

1

Se p-

21

N ov

-2 1

Ja n-

22

M ar

-2 2

Published CPI Alternative Price Indices

The Comparison of CPI and Susenas Price Index

Validity​ Weight Expenditure​ CPI​

RMSE 1.74 0.39

MAPE 12.11% 0.30%

Validation

2121

95

100

105

110

115

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 1

Susenas 01 PUBLISH 01

97 99

101 103 105 107 109

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 2

Susenas 02 PUBLISH 02

97

99

101

103

105

107

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 3

Susenas 03 PUBLISH 03

97

102

107

112

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 4

Susenas 04 PUBLISH 04

95

100

105

110

115

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 5

Susenas 05 PUBLISH 05

97

99

101

103

105

107

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 6

Susenas 06 PUBLISH 06

97

98

99

100

101

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 7

Susenas 07 PUBLISH 07

97 99

101 103 105 107 109

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 8

Susenas 08 PUBLISH 08

95 97 99

101 103 105 107 109 111

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 9

Susenas 09 PUBLISH 09

97

102

107

112

117

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 10

Susenas 10 PUBLISH 10

97

102

107

112

117

122

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 11

Susenas 11 PUBLISH 11

22

CONCLUSION, IMPLEMENTATION

PLAN, AND LIMITATION

04

23

Conclusion and Implementation Plan

Conclusion

• The HBS-18 and Susenas-18 show similar pattern of expenditure weight • The availability of susenas weight every year allows it to be more responsive to the shifting of

consumption patterns. • As the result of data evaluation (correlation, MAPE, and RMSE), Susenas data can be considered as a

feasible method for generating more frequent of CPI expenditure weight • Household Budget Survey (HBS) is still considered as the most established survey to obtain CPI weight

Implementation Plan

• Future research to approach National Account data (HFCE) and scanner data as the data source recommended in the CPI Manual

• Further studies in building a superlative index to estimate the substitution bias of the CPI • We will continue to review the strategy to implement the Susenas weight or other alternative data

sources in compiling the CPI

24

The differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as

the commodities in the HBS.

Our Concern

  • Slide Number 1
  • Outline
  • INTRODUCTION
  • Backgrounds
  • BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data as an alternative data source to approach household expenditure weights for compiling the CPI. ​
  • Overview of Consumer Price Survey and�Household Budget Survey
  • Overview of National Socio-Economy Survey​
  • METHODOLOGY
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • RESULTS
  • The comparison of HBS 2018 Weight & Susenas Weight​
  • The correlation of HBS 2018 and Susenas
  • Changes in Consumption Patterns Between Years Based on Susenas
  • Using the Susenas Weight to Condutct the Alternative Price Indices
  • Slide Number 21
  • CONCLUSION, IMPLEMENTATION PLAN, AND LIMITATION
  • Conclusion and Implementation Plan
  • The differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as the commodities in the HBS.​
  • Slide Number 25

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight, Indonesia

Languages and translations
English

BADAN PUSAT STATISTIK

Presenters:

Fathia Utami Afdi BPS - Statistics Indonesia

Meeting of the Group of Experts on Consumer Price Indices

Geneva, 7th-9th June 2023

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight

Authors:

Fathia Utami Afdi Fenanda Dwitha Kurniasari

Zaradia Permatasari BPS - Statistics Indonesia

Outline

2

Introduction01

Methodology02

Results03

Conclusion and Implementation Plan

04

3

01

INTRODUCTION

4

Backgrounds

0

5

10

15

20

25

30

Food Materials Prepared food and beverages

Goods and services

Clothing, footwear, and

headgear

Parties and ceremonies

Housing and household

facilities

Others

W ei

gh t (

% )

Indonesia Expenditure Weight, 2018-2021

2018

2019

2020

2021

The CPI has an important role in determining a country's entire economy

Lesson Learned

From Pandemic

Covid-19

One of the crucial aspects in the CPI calculation is the weighting method

Facing a dynamic and rapid change in consumption behavior, a fixed expenditure weight over a long period can be no longer relevant in describing the enormous shift in household expenditure patterns.

Source: Indonesia- National Socio Economic Survey

5

BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data

as an alternative data source to approach household expenditure weights for compiling the CPI.

Objective of This Study

6

Overview of Consumer Price Survey and Household Budget Survey

Group (11)

Subgroup (43)

Commodity (835)

Price

Headline CPI

Monthly release CPI and inflation

90 cities and national

Fixed basket and weights currently used from HBS 2018

Using the Classification of Individual Consumption by Purpose (COICOP)

Held every 5 years

Currently held in 2022 and will be introduced in January 2024

Expenditure on food and non-food household consumptions

Using the Classification of Individual Consumption by

Purpose (COICOP)

Consumer Price Survey

Household Budget Survey

Presenter
Presentation Notes
Indonesia conducting the HBS every 5 years. Ini masih sejalan dengan rekomendasi pada CPI Manual untuk mengupdate bobot at least 5 tahun 1 kali&#xd;

7

Overview of National Socio-Economy Survey

Capture household consumption/ expenditure in

city level every year

Availability of data on household welfare, including

education, health, and purchasing power

Using The Classification of Individual Consumption by Purpose (COICOP)

Expenditure on food (15 groups) and non-food (6

groups) household consumptions

02 03

0401

8

METHODOLOGY

03

9

1 2a 2b 2c 3 4 5Methodology 1

1. DATA PROCESSING

Data Source The Indonesian National Socio-Economic Survey (Susenas), 2018-2021

Total of commodities 296 commodities, 539 fewer than HBS 2018

Estimating total household consumption value per month by commodity

Aggregrate the expenditure value for 90 cities covered in CPI

10

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

a. MAPPING COMMODITIES

HBS2018 commodities Susenas Commodities

011101001-Rice 2-Rice

011101001-Rice 3-Sticky Rice

011101008-Sweet Potatoes 10-Cassava/Sweet Potatoes

054501001- Checkup Rates 252-Health test/early detection/Medical Check Up

054501001- Laboratorium Rates 252-Health test/early detection/Medical Check Up

For example:

2a

11

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

b. CALCULATING THE CONSUMPTION VALUE AND IMPUTATION PROCESS

Notation NK’i : Updated expenditure value for ith commodity based on Susenas NKi(hbs) : expenditure value for ith commodity based on HBS NKj(ssn) : Susenas expenditure value for commodity j which is mapped to ith commodity i : index for commodity in HBS. j : index for commodity in Susenas

Commodities Baskets Expenditure Value based on Susenas Data

011101001-Rice The sum of the rice and sticky rice consumption

011101008-Sweet Potatoes Equals to the Cassava/Sweet Potatoes consumption

054501001- Checkup Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

054501001- Laboratorium Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

2b

12

1 2a 2b 2c 3 4 5Methodology

Estimating the true value of expenditure

Proportional approach: In this case, the proportion of expenditure on more detailed commodities in the HBS is allocated to broader categories in the Susenas data

Excluding the expenditure value of the insurance, and the party and ceremonies category

Adjustments were carried out to overcome the differences in HBS and Susenas commodity details such as:

2c

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

c. ADJUSMENTS

13

1 2a 2b 2c 3 4 5Methodology

3. EVALUATION THE WEIGHT BASED ON SUSENAS DATA

Evaluation the Susenas 2018 weight Calculate the correlation

Identify changes in trends of household expenditure

patterns year to year based on Susenas weight

3

Presenter
Presentation Notes
Setelah melakukan berbagai adjustment untuk menyesuaikan Susenas dengan cakupan SBH, dilakukan evaluasi dengan menghitung korelasi

14

1 2a 2b 2c 3 4 5Methodology

4. COMPILING THE ALTERNATIVE PRICE INDICES

Elementary Level Indices

Use the same published commodity price change

As BPS-Indonesia’s practice, for elementary level we use the Jevon Formula

Upper Level Indices

Method : modified Laspeyres

Price reference period = weight reference period

Linking the index :

In this study, we started by comparing the published CPI with the Susenas price index, to see how feasible it is that Susenas data can be

used as an approach to calculate the CPI

4

15

1 2a 2b 2c 3 4 5Methodology

5. VALIDATION

Calculate the MAPE and RMSE for :

MAPE Interpretation

<10% Highly Accurate Forecasting

10-19% Good Forecasting

20-49% Reasonable Forecasting

>50% Inaccurate Forecasting

5

HBS18 weight and Susenas 18 weight in the commodity level

CPI and Alternative Price Indices in 2018

16

RESULTS

03

1717

The comparison of HBS 2018 Weight & Susenas Weight​

25,01

5,41

20,45 5,97

2,62

12,38

5,83

2,15 5,62

8,67 5,89

29,49

4,37

18,255,49 2,62

10,82

5,49 1,58

5,52

10,77

5,6

Household Budget Survey 2018 Susenas 2018

18

Correlation: 0,9812 Correlation: 0,9788

Correlation: 0,9741 Correlation: 0,9659

The larger the year gap between the HBS and Susenas, the less correlation in the weights produced by the two data sources

The correlation of HBS 2018 and Susenas

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 8

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 9

HBS 2018

0

2

4

6

0 1 2 3 4 5

Su se

na s 2

02 1

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

02 0

HBS 2018

19

29,49

28,35

29,33

30,57

2018 2019 2020 2021

Food, Beverages, and Tobacco

4,35 4,59 4,42 3,55

0

1

2

3

4

5

6

2018 2019 2020 2021

Clothing and Footwear

2,61 2,61 2,56 3,19

0

1

2

3

4

5

2018 2019 2020 2021

Health

10,93 11,32 11,48 9,41

2018 2019 2020 2021

Transport

5,48

5,28 5,25

5,64

2018 2019 2020 2021

Information, Communication, and Financial Services

1,57 1,63 1,57 1,2

0

0,5

1

1,5

2

2,5

3

2018 2019 2020 2021

Recreation, Sport, and Culture

10,77 11,12

10,8

9,67

2018 2019 2020 2021

Food and Beverage Serving Services/Restaurant

5,58 5,55 5,63

5,88

2018 2019 2020 2021

Personal Care and Other Services

The Expenditure Weight by Groups Based on Susenas, 2018-2021 (%)

Changes in Consumption Patterns Between Years Based on Susenas

20

Using the Susenas Weight to Condutct the Alternative Price Indices

98

100

102

104

106

108

110

Ja n-

18

M ar

-1 8

M ay

-1 8

Ju l-1

8

Se p-

18

N ov

-1 8

Ja n-

19

M ar

-1 9

M ay

-1 9

Ju l-1

9

Se p-

19

N ov

-1 9

Ja n-

20

M ar

-2 0

M ay

-2 0

Ju l-2

0

Se p-

20

N ov

-2 0

Ja n-

21

M ar

-2 1

M ay

-2 1

Ju l-2

1

Se p-

21

N ov

-2 1

Ja n-

22

M ar

-2 2

Published CPI Alternative Price Indices

The Comparison of CPI and Susenas Price Index

Validity​ Weight Expenditure​ CPI​

RMSE 1.74 0.39

MAPE 12.11% 0.30%

Validation

2121

95

100

105

110

115

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 1

Susenas 01 PUBLISH 01

97 99

101 103 105 107 109

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 2

Susenas 02 PUBLISH 02

97

99

101

103

105

107

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 3

Susenas 03 PUBLISH 03

97

102

107

112

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 4

Susenas 04 PUBLISH 04

95

100

105

110

115

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 5

Susenas 05 PUBLISH 05

97

99

101

103

105

107

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 6

Susenas 06 PUBLISH 06

97

98

99

100

101

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 7

Susenas 07 PUBLISH 07

97 99

101 103 105 107 109

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 8

Susenas 08 PUBLISH 08

95 97 99

101 103 105 107 109 111

Ja n-

18

Ap r-

18

Ju l-1

8

O ct

-1 8

Ja n-

19

Ap r-

19

Ju l-1

9

O ct

-1 9

Ja n-

20

Ap r-

20

Ju l-2

0

O ct

-2 0

Ja n-

21

Ap r-

21

Ju l-2

1

O ct

-2 1

Ja n-

22

Group 9

Susenas 09 PUBLISH 09

97

102

107

112

117

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 10

Susenas 10 PUBLISH 10

97

102

107

112

117

122

Ja n-

18 Ap

r- 18

Ju l-1

8 O

ct -1

8 Ja

n- 19

Ap r-

19 Ju

l-1 9

O ct

-1 9

Ja n-

20 Ap

r- 20

Ju l-2

0 O

ct -2

0 Ja

n- 21

Ap r-

21 Ju

l-2 1

O ct

-2 1

Ja n-

22

Group 11

Susenas 11 PUBLISH 11

22

CONCLUSION, IMPLEMENTATION

PLAN, AND LIMITATION

04

23

Conclusion and Implementation Plan

Conclusion

• The HBS-18 and Susenas-18 show similar pattern of expenditure weight • The availability of susenas weight every year allows it to be more responsive to the shifting of

consumption patterns. • As the result of data evaluation (correlation, MAPE, and RMSE), Susenas data can be considered as a

feasible method for generating more frequent of CPI expenditure weight • Household Budget Survey (HBS) is still considered as the most established survey to obtain CPI weight

Implementation Plan

• Future research to approach National Account data (HFCE) and scanner data as the data source recommended in the CPI Manual

• Further studies in building a superlative index to estimate the substitution bias of the CPI • We will continue to review the strategy to implement the Susenas weight or other alternative data

sources in compiling the CPI

24

The differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as

the commodities in the HBS.

Our Concern

  • Slide Number 1
  • Outline
  • INTRODUCTION
  • Backgrounds
  • BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data as an alternative data source to approach household expenditure weights for compiling the CPI. ​
  • Overview of Consumer Price Survey and�Household Budget Survey
  • Overview of National Socio-Economy Survey​
  • METHODOLOGY
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • RESULTS
  • The comparison of HBS 2018 Weight & Susenas Weight​
  • The correlation of HBS 2018 and Susenas
  • Changes in Consumption Patterns Between Years Based on Susenas
  • Using the Susenas Weight to Condutct the Alternative Price Indices
  • Slide Number 21
  • CONCLUSION, IMPLEMENTATION PLAN, AND LIMITATION
  • Conclusion and Implementation Plan
  • The differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as the commodities in the HBS.​
  • Slide Number 25

The Use of Alternative Data Source As a Proxy to Approach More Frequent Updates of CPI Expenditure Weight, Indonesia

The Consumer Price Index (CPI) is one of the key economic indicators widely used as a guide to make decisions and determine government policy effectiveness. This index is the most well-known inflation indicator that shows the household's price level of goods and services. BPS-Statistics Indonesia updates CPI monthly, and the compilation uses the expenditure weight from the Household Budget Survey held every five years.

Languages and translations
English

The Use of Alternative Data Source As a Proxy to Approach More Frequent Updates of CPI Expenditure Weight

Fathia Utami Afdi1, Fenanda Dwitha2, Zaradia Permatasari3 1Statistics Indonesia ([email protected]) 2Statistics Indonesia ([email protected]) 3Statistics Indonesia ([email protected]) Abstract. The Consumer Price Index (CPI) is one of the key economic indicators widely used as a guide to make decisions and determine government policy effectiveness. This index is the most well-known inflation indicator that shows the household's price level of goods and services. BPS-Statistics Indonesia updates CPI monthly, and the compilation uses the expenditure weight from the Household Budget Survey held every five years. Facing a dynamic and rapid change in consumption behavior, using a fixed expenditure weight over a long period can be no longer relevant in describing the enormous shift in household expenditure patterns. The updated expenditure weight data would continuously provide the data user needs. However, conducting more frequent HBS requires additional cost. Regarding the importance of CPI, the index’s quality and measurement approach are necessarily improved and revised, including the methodologies and data sources. In Statistics Indonesia, one of the alternative data sources that portrays household expenditure is National Socio-Economic Survey (SUSENAS). The focus on this study is to exercise the approach in compile new CPI using weight expenditure derived from the alternative data sources, which are more frequently updated. The updated weights show slightly different of consumption pattern compared to the existing CPI weights. The CPI obtained from the updated weight are evaluated with distribution pattern, Relative Mean Square Error (RMSE), and Mean Percentage Absolute Error (MAPE). The alternative CPI is closely similar to some points of the existing CPI series, in which MAPE are 12.11% for weight expenditure and 0.30% for CPI. also, RMSE are 1.74 and 0.39 for the same indicators. It may conclude that using Susenas data as alternative data sources can be considered as a feasible method for generating more frequent of CPI expenditure weight, since particularly it can address towards latest condition in society and more relevant to updated consumption patterns in force majeure conditions specifically, such as The Covid-19 pandemic. However, this study is subject to several limitations. It can only update consumption expenditure despite the basket of commodities and challenges faced in mapping commodities captured from the alternative data source. BPS- Statistics Indonesia will continue to review the strategy to implement the alternative weight in compiling CPI and we will conduct further studies as necessary.

Keywords: CPI, inflation, expenditure weight, annually re-weight

1. Introduction

Backgrounds

The calculation of the Consumer Price Index (CPI) is one of the main indicators used to measure changes in the price level of goods and services consumed by the public. The CPI is the most commonly used tools to measure inflation and deflation, which is important indicator of an economy’s health1. An accurate and up-to-date CPI plays an important role in economic policy analysis, business decision-making, measuring purchasing power, and monitoring inflation in a country.

One of the crucial aspects in the calculation of CPI is the weighting method used. These weights refer to the relative weight given to each commodity included in the commodity package as the basis for CPI calculation. The weight attached to each good or service determines the impact that its price change will have on the overall index2.

In Indonesia, CPI calculation weights are obtained from the Household Budget Survey (HBS) which is conducted every 5 years. The five-year period between surveys causes limitations in representing dynamic changes in the structure of household expenditure. In a dynamic economy, consumer preferences and spending patterns also change over time.

In recent years, we know that many countries from all over have faced big challenges since the onset of the COVID-19 pandemic. The pandemic has caused significant shifts in consumption patterns. Lockdowns and social restrictions have affected accessibility to certain goods and services and changed consumption preferences. Some sectors of the economy experienced a drastic decline, while others increased. Just for example, the tourism and transportation sectors have been severely affected by the travel restrictions. In this context, the changes of consumption patterns have shown the need for more frequent weight updates to obtain accurate CPI data.

In this study, a new approach is taken using the National Socio-Economic Survey (SUSENAS) data as an alternative data source to obtain more accurate and more frequently updated CPI calculation weights. SUSENAS is a household survey conducted periodically by Central Bureau of Statistics (BPS)-Indonesia that includes more information on the socioeconomic characteristics of households as well as comprehensive information on household expenditures, including prices and quantities of goods consumed.

By utilizing Susenas data as an alternative data source, this study aims to develop an alternative method in calculating the CPI by updating the weights more frequently. This approach is expected to provide a more accurate picture of changes in consumption patterns that occur in households. By considering SUSENAS data available every year, the resulting CPI can reflect more representative price changes and provide more accurate information for economic decision-making.

This study also aims to analyze the effectiveness of using Susenas data for update the CPI weight in Indonesia. In this study, the process of selecting commodities, calculating weights, evaluating the quality of Susenas data, and comparing the results of CPI calculations using the weight from HBS and the Susenas-based method are carried out.

The use of Susenas data as an alternative data source in CPI calculation is expected to help overcome the challenges faced by HBS, such as the cost and time required in conducting more frequent surveys. In the context of a fast-changing economy, the ability to update CPI calculation weights more regularly can provide significant benefits in monitoring inflation, planning price policies, and better understanding public consumption trends. This also relates to the empirical support found by Austalia Bureau of Statistics that higher frequency re-weighting of the CPI better captures consumer’ substitution effects3.

Overview of Household Budget Survey and Consumer Price Survey in Indonesia Consumer Price Survey (CPS), conducted by Statistics Indonesia, is a survey of transactional

price between seller (retailer) and buyer (consumer). This survey aims to provide Consumer Price Index (CPI), one of strategic indicators collected by Statistics Indonesia for policy making. The difference in percentage of CPI, known as inflation or deflation rate, is essential economic indicators.

In history, CPS was held for the first time in 1953 in Jakarta. In 1968 CPI was calculated in eight selected capital cities. Starting from 2018 until now, CPS has been held in 90 cities in Indonesia. Statistics Indonesia releases CPI and inflation/deflation every month, disseminated in 90 cities and in national level.4

In calculating the headline CPI in a city, aggregation is done from a top-down approach, as seen in the figure below.

Figure 1.1. CPI structure

1. Price The data collected is transactional price data between sellers and buyers at the retail level. Prices are collected in traditional and modern markets. Microdata are not disseminated.

2. Commodity Commodity is the types of goods or services whose prices are monitored in consumer price survey. The number of commodities in the basket is different for each city, according to the consumption pattern of the society in each region. The lowest level index of the CPI is calculated at the commodity level. Currently, at the national level there are 835 commodities.

3. Subgroup All commodities are grouped to a higher level based on Classification of Individual Consumption by Purpose (COICOP), with minor modification for Indonesia. Based on the HBS 2018, there are a total of 43 subgroups.

4. Group Based on HBS 2018, there are 11 groups of household expenditure. Detailed descriptions of the 11 groups for national are as follows.

Table 1. The CPI Classification by Groups

Code Group The number of subgroups

The number of

commodities 01 Food, Beverages, and Tobacco 4 348 02 Clothing and Footwear 2 101 03 Housing, Water, Electricity, and Household Fuel 4 39

04 Furnishings, Household Equipment, and Routine Household Maintenance 6 76

05 Health 4 27 06 Transport 4 39

07 Information, Communication, and Financial Services 4 27

08 Recreation, Sport, and Culture 6 37 09 Education 4 15 10 Food and Beverage Serving Services/Restaurant 1 68 11 Personal Care and Other Services 4 58

Total 43 835

5. Headline CPI Headline CPI is the highest level of the index containing all groups, all subgroups, and all commodities, calculated at the city and national level. The change in headline CPI called inflation/deflation shows the rate of increase/decrease in the price of goods/services in general at the level of dissemination.

In Indonesia, the current CPI is disseminated for 90 cities and at the national level. The basket of

goods/services and the weights are obtained from Household Budget Survey (HBS). HBS is a household consumption expenditure survey to obtain patterns of consumption as a material for preparing weights and basket commodities in the CPI calculation. HBS is held for a full year to capture an overview of consumption patterns throughout the year. The data collected includes expenditure on food and non-food consumption. HBS was first held in 1977/1978, and continued in 1988/1989, 1996, 2002, 2007, 2012, and the last is 2018. Currently, the CPI is calculated based on the HBS 2018, which is the 7th survey since it was first implemented. Household Budget Survey (HBS) held every five years. So, the fixed weights are used for five years until the next HBS.

Overview of National Socio-Economy Survey (SUSENAS)

Statistics Indonesia is responsible for the availability of data needed for sectoral and cross- sectoral development planning. One of the data sources needed especially for planning in the Socio- Economic Population sector is the National Socio-Economic Survey (Susenas) which is held by BPS every year. In general, the purpose of data collection through the Susenas is the availability of data on household welfare, including education, health, and purchasing power.

Susenas was first held in 1963. Susenas collects KOR data (main information) and module data (special information). Module data is collected once every 3 years covering the population consumption and income module, the social, cultural, and educational module, and the housing and health module. Since 2015, Susenas has captured the Household Consumption/Expenditure Module every semester, data will be collected every year in March and September. Data on semiannual enumeration results can only be presented in September for both the national and provincial levels, while for March the data can be presented up to the district/city level. Therefore, the data analyzed in this study is data from the Susenas in March, from household consumption/expenditure modul.5

The household consumption module captures food and non-food consumption expenditures. The grouping of goods and services captured in the consumption module Susenas is also guided by the COICOP, the same as was done for the HBS and CPS. Therefore, this data can be used as an alternative approach to annual CPI reweighting. Expenditure Persentage 2018 2019 2020 2021 Cereals and Tubers 6.45 6.08 5.97 6.14 Fish/shrimp/common squid/shells, Meat, Eggs, and Milk 8.76 8.80 8.80 9.20 Vegetables and Fruits 6.06 5.61 6.16 6.33 Legumes, Oil, and Coconut 2.21 2.10 2.11 2.31 Spices and Miscellaneous food items 1.87 1.79 1.83 2.05 Beverages Stuff and Alcoholic Beverage 1.53 1.44 1.50 1.54 Tobacco and betel (Cigarettes) 5.82 6.05 5.99 6.06 Prepared food and beverages 16.82 17.26 16.87 15.63 Housing and household facilities 25.29 25.49 25.19 26.33 Goods and services 12.39 12.40 12.42 12.17 Clothing, footwear, and headgear 2.92 3.03 2.95 2.51 Durable goods 5.14 5.04 4.96 4.60 Taxes and insurance 2.81 3.01 3.38 3.92 Parties and ceremonies 1.94 1.89 1.90 1.21 Total 100.00 100.00 100.00 100.00

According to Susenas data, consumption patterns have changed from year to year. For example,

from 2018 to 2019, there has been a significant shift in consumption patterns from the grains and tubers group to the prepared food group. In 2018, grains and tubers were originally 6.45%, down to 6.08%, and processed food increased from 16.82% to 17.26%. Entering the COVID-19 pandemic, food consumption began to fall. In 2020 it fell to 16.87% and 2021 15.63%. People reduce buying prepared food to minimize contact with people and choose to cook at home. For four years, the consumption of protein in the community has continued to increase, as seen in the percentage of the fish, meat, eggs, and dairy group which has consistently increased, 8.76% in 2018 to 9.20% in 2021. From 2019 to 2020 and 2021, entering the COVID-19 pandemic, people tend to reduce spending on non-food items, meanwhile people still need to eat. This causes the percentage of food expenditure to increase, and non-food expenditure to decrease. For example, the percentage of consumption for the clothing, footwear and headgear group decreased from 3.03% in 2019 to 2.95% in 2020 and 2.51% in 2021. Another example is the consumption of durable goods which fell from 5.04 in 2019 to 4.96% in 2020 and 4.60% ini 2021. In 2021, when the peak of the COVID-19 pandemic occurred, large-scale social restrictions were implemented causing spending on parties and ceremonies to drop significantly from 1.90% to 1.21%.

It should be a concern that consumption patterns have changed even in just one year, especially with the COVID-19 pandemic which has caused people's lifestyles to change. Susenas data available every year can be an alternative to capture information gaps of changes in consumption patterns between years, from one HBS to the next.

2. Methodology Scope

The data used for this study is micro data from Susenas–The Indonesian National Socio- economic survey, an annual household survey conducted by Statistics Indonesia every March and September. Statistics Indonesia collected social and demography data, specifically to measure poverty indicator, education, health, consumption, housing, and other socio-economic indicators through this survey. The susenas questionnaire consists of many modules, each of which is asked according to the needs of the indicators to be generated [3].

In this study, we use the Susenas dataset for 2018-2021. This is in line with the research objective which is to capture differences in consumption patterns in this period, including during the covid-19. Besides, we focused on consumption and expenditure’s modul in Susenas’ questionnaire to obtain consumption value in each commodity that available in Susenas. The number of commodities collected from this survey is 296 commodities, 539 fewer than collected commodities in HBS.

Using National Socio-Economic Survey to Conduct Alternative Expenditure Weight 1. Data Processing

First, we process raw data of Susenas, consists of information on household expenditure, including the price, amount, and quantity of goods and services consumed. The Susenas data used in this study is Susenas data for 2018-2021. In this stage, appropriate statistical data processing techniques are used to obtain relevant and representative information.

2. Conducting the alternative weight based on Susenas data In order to obtain new weights for CPI calculation from alternative data sources (Susenas), it is necessary to establish commodity baskets and updated weight based on Susenas data, as was done when processing data from the Household Budget Survey. In updating the new weights, there are several challenges, they are: a. Mapping the Commodities

In categorizing goods and services, there are differences in classification between the commodity coverage of Susenas and SBH 2018. To overcome the mismatch between Susenas and SBH commodity codes, a commodity code mapping process was carried out, by connecting or linking commodities in the Susenas data with commodities in the SBH 2018. This was done to ensure conformity and consistency in the grouping of goods and services and the determination of their weights. During the mapping process, several conditions occurred, (1) one commodity in Susenas matched to 1 commodity in SBH, (2) one commodity in Susenas was mapped to 2 or more commodities in SBH, (3) two or more commodities in Susenas were mapped to 1 commodity in SBH, (4) there were commodities covered by SBH that were not included in Susenas. This condition is affected by the differences in commodity details between Susenas and SBH, which SBH collects more detailed commodity data than Susenas.

b. Calculating the Consumption Value and Imputation Process The formula used for calculating the expenditure value of the commodity baskets based on Susenas data is

&#x1d441;&#x1d441;&#x1d441;&#x1d441;&#x1d456;&#x1d456;′ = &#x1d441;&#x1d441;&#x1d441;&#x1d441;&#x1d456;&#x1d456;

(ℎ&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;)

∑ &#x1d441;&#x1d441;&#x1d441;&#x1d441;&#x1d456;&#x1d456; (ℎ&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;)

1,2,…&#x1d43c;&#x1d43c; × �&#x1d441;&#x1d441;&#x1d441;&#x1d441;&#x1d457;&#x1d457;

(&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d460;&#x1d460;)

Notation : NK’i : Updated expenditure value for ith commodity based on Susenas NKi(hbs) : expenditure value for ith commodity based on HBS NKj(ssn): Susenas expenditure value for commodity j which is mapped to ith commodity i : index for commodity in HBS j : index for commodity in Susenas To complete the expenditure value of commodities that not covered in Susenas, imputations were made by utilizing available information, the household expenditure weights for those commodities based on SBH2018 results. Using imputation techniques, missing values were filled in with reasonable estimates, thus ensuring data completeness and consistency in the formation of weights.

c. Adjustments In developing the new weights based on Susenas data, adjustments are also needed to obtain more accurate weights. Adjustments are made with the intention of considering changes in consumption patterns or consumer preferences over time.

Differences in HBS and Susenas commodity details

In the HBS, the list of commodities is larger and more detailed, while in the Susenas data, the coverage of commodities is more limited, and some commodities are combined as one unit without more specific details. The limited commodity detail in Susenas may cause expenditure on certain commodities to be aggregated into one broader category, resulting in lower expenditure values than actual. If expenditure on certain commodities is lower than it should be, then the weight on other higher commodities may be too large.

To overcome this problem, it is necessary to adjust the process of developing commodity weights. This adjustment aims to ensure that the resulting commodity weights reflect a more accurate proportion of expenditure and are not distorted by an underestimate of expenditure on certain commodities. Adjustments were carried out such as: a. estimating the true value of expenditure based on other information in the Susenas data

or using more detailed HBS data. b. Proportional approach: used to adjust commodity weights by considering differences in

commodity classification between Susenas and HBS data. In this case, the proportion of expenditure on more detailed commodities in the HBS is allocated to broader categories in the Susenas data.

Adjustments in the Insurance commodity, as well as the party and ceremonies category The Insurance Cost commodity covered in Susenas has a different concept from HBS2018. Insurance costs covered in HBS 2018 are only administrative costs, while insurance costs covered in Susenas include premi and other costs. The commodities in the party/event category covered in Susenas are also not covered in SBH as household expenditure. Therefore, for these commodities, adjustments were made by excluding the expenditure value from the new weight calculation.

3. Evaluation the weight based on Susenas Data

At this stage, the results of the weight conducted from Susenas Data are evaluated. The evaluation is carried out by comparing the expenditure weight from HBS-2018 with the expenditure weight from Susenas-2018. The purpose of this comparison is to ensure the suitability and accuracy of the weights generated from the Susenas data with the published weights from HBS 2018. In

addition, an analysis of the weight movement between Susenas periods is also conducted to identify changes in trends of household expenditure patterns year to year. In statistics, there are several tests and procedures that can be done in a study, where one of them is determining the level of correlation between variables. Correlation itself is one of method that studies the degree of relationship between two or more variables. to determine the level of relationship between the two variables, we can evaluate from the size of the correlation value or what is commonly referred to as the correlation coefficient. The pearson correlation, is a correlation which coefficient measures the linear relationship between pairs of numerical codes for categories of each variable. In this study, we calculate the correlation of the elementary weights (in commodity level) between HBS 2018 and Susenas. The formula used as follow:

&#x1d45f;&#x1d45f;&#x1d465;&#x1d465;&#x1d465;&#x1d465; = &#x1d450;&#x1d450;&#x1d450;&#x1d450;&#x1d450;&#x1d450;(&#x1d465;&#x1d465;,&#x1d466;&#x1d466;) &#x1d70e;&#x1d70e;&#x1d465;&#x1d465;&#x1d70e;&#x1d70e;&#x1d465;&#x1d465;

4. Compiling the Alternative Price Indices

After evaluating the Susenas data to be an alternative data source in determining household expenditure weights, the weights are used to create the alternative price indices, which is then compared to the published CPI. The expenditure data from Susenas is available every year, enabling expenditure weights to be derived annually for the approach of CPI weights. Thus, the expenditure weights can be updated periodically and can captured the changes of household consumption patterns reflected in the Susenas data each year. This is yet another challenge to update the CPI weight regularly every year. In term of implementing the annually update of CPI weight, it needs to be considered whether the weights that have been formed based on Susenas data will be directly used as the weights for CPI calculation. Another choice is by using the Susenas weight movement to update the HBS expenditure in the commodity level. This practice is in line with the ABS (Australian Bureau of Statistics) which updates the CPI weights annually using the HFCE data movements. Meanwhile in this preliminary study, we started by comparing the published CPI with the Susenas price index, to see the feasibility of using the Susenas data as an approach to calculate the CPI. Further research is needed to determine the method that will be used to update the HBS weights continuously. The alternative price index for all groups (headline CPI) is constructed using the weighted index of 835 commodities. The method used to construct the alternative price index at both the elementary level index and the upper level index is the same as that used in the published CPI. a. Elementary Level Indices

Both series, the published CPI and the alternative price index, use the same published commodity price change in the city level. In practice, Indonesia use the Jevon formula to calculate the indices in the elementary level

&#x1d43c;&#x1d43c;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d460;&#x1d460;&#x1d44f;&#x1d44f; 0;&#x1d461;&#x1d461; = � �

&#x1d45d;&#x1d45d;&#x1d456;&#x1d456;&#x1d461;&#x1d461;

&#x1d45d;&#x1d45d;&#x1d456;&#x1d456;0 � 1/&#x1d460;&#x1d460;

&#x1d456;&#x1d456;

&#x1d43c;&#x1d43c;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d43d;&#x1d460;&#x1d460;&#x1d44f;&#x1d44f; 0;&#x1d461;&#x1d461; =

∏ �&#x1d45d;&#x1d45d;&#x1d456;&#x1d456;&#x1d461;&#x1d461;� 1/&#x1d460;&#x1d460;

&#x1d456;&#x1d456;

∏ �&#x1d45d;&#x1d45d;&#x1d456;&#x1d456;0� 1/&#x1d460;&#x1d460;

&#x1d456;&#x1d456;

Where, &#x1d45d;&#x1d45d;&#x1d456;&#x1d456;&#x1d461;&#x1d461; = price in current period &#x1d45d;&#x1d45d;&#x1d456;&#x1d456;0= price in base period

b. Upper Level Indices As the current method used to compile the published CPI in Indonesia is Modified

Laspeyres, the updated price index also uses the same method, which the weight reference period is the same with the price reference period. Since the Susenas expenditure data

collected on March, so the reference period for the updated price index is on March every year. The formula of the Modified Laspeyres is shown as below:

&#x1d43c;&#x1d43c;&#x1d461;&#x1d461; = ∑ &#x1d45d;&#x1d45d;&#x1d456;&#x1d456;&#x1d461;&#x1d461;&#x1d45e;&#x1d45e;&#x1d456;&#x1d456;0&#x1d460;&#x1d460; &#x1d456;&#x1d456;=1

∑ &#x1d45d;&#x1d45d;&#x1d456;&#x1d456;0&#x1d45e;&#x1d45e;&#x1d456;&#x1d456;0&#x1d460;&#x1d460; &#x1d456;&#x1d456;=1

The availability of expenditure weight for every year, means there are several new CPI series

with the difference reference period. As the new weights are introduced, the new series is not comparable to the previous series. However, to fulfill the user's need for a CPI time series that covers a long period of time and provides historical content, we will need to link the series together. In line with CPI Manual (2020), if this linking process continues for multiple years, the linking factors for each year must be derived from the indices on the fixed index reference period or made cumulative by chaining the annual series through time. For example, in this study we make the long CPI series with the index reference period on 2018, so the chain linking method can be expressed as:

&#x1d43c;&#x1d43c;19/21 = &#x1d43c;&#x1d43c;18/19 &#x1d465;&#x1d465; &#x1d43c;&#x1d43c;19/20 &#x1d465;&#x1d465; &#x1d43c;&#x1d43c;20/21

Where, &#x1d43c;&#x1d43c;19/21= continuous chain-linking factor for annual indexes from 2018-2019 to 2020-2021

5. Validation

For testing the method used, we compare result of IHK based on Susenas’ expenditure weight with HBS’. MAPE (Mean Absolute Percentage Error), introduced by Lewis (1982) are performed as the base of prediction test [4]. In addition, MAPE can be used to evaluate the accuracy of Susenas’ sampled data as more frequent alternative expenditure weight before we estimate IHK further in the following years. Similarly, RMSE (Root Mean Square Error) is alternative method measuring the error of prediction model. The formula of MAPE and RMSE are shown as follows,

&#x1d440;&#x1d440;&#x1d440;&#x1d440;&#x1d440;&#x1d440;&#x1d440;&#x1d440; = ∑ �&#x1d436;&#x1d436;&#x1d440;&#x1d440;&#x1d43c;&#x1d43c;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;ℎ − &#x1d436;&#x1d436;&#x1d440;&#x1d440;&#x1d43c;&#x1d43c;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d460;&#x1d460;

&#x1d436;&#x1d436;&#x1d440;&#x1d440;&#x1d43c;&#x1d43c;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;ℎ �

&#x1d45b;&#x1d45b; × 100% … 1)

&#x1d445;&#x1d445;&#x1d440;&#x1d440;&#x1d445;&#x1d445;&#x1d440;&#x1d440; = � (&#x1d436;&#x1d436;&#x1d440;&#x1d440;&#x1d43c;&#x1d43c;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;ℎ − &#x1d436;&#x1d436;&#x1d440;&#x1d440;&#x1d43c;&#x1d43c;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d460;&#x1d460;)2

&#x1d45b;&#x1d45b; … 2)

&#x1d43c;&#x1d43c;&#x1d43c;&#x1d43c;&#x1d441;&#x1d441;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;ℎ represents the monthly IHK based on HBS’ expenditure weight, whereas &#x1d43c;&#x1d43c;&#x1d43c;&#x1d43c;&#x1d441;&#x1d441;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d44f;&#x1d460;&#x1d460; based on Susenas’. N is the total number of observations, which is 12 months in this study. As a result, we also can interpret the MAPE value according to Lewis’ categorization (1982) as shown in Table X. Meanwhile, small RMSE value explains that predicted model is fitted to its true value, in this study represented by IHK based on HBS.

MAPE Interpretation

<10% Highly accurate forecasting 10-19% Good Forecasting 20-49% Reasonable Forecasting >50% Inaccurate forecasting

3. Result

HBS-2018 and Susenas Obtaining the new expenditure value of the commodity packages based on Susenas-18 data, we

conduct the comparative analysis betweeen the resulted weight and the published weight. This comparison is carried out to see the suitability between the two data sources in forming the weight of household expenditure used in the CPI calculation. A comparison of group level expenditure weights for HBS-18 and Susenas-18 is shown in the table below.

Table 3.1. Expenditure Weight in Group Level fos HBS-18 and Susenas-18

Code Group HBS-18 Susenas-18 01 Food, Beverages, and Tobacco 25,01 29,49 02 Clothing and Footwear 5,41 4,37 03 Housing, Water, Electricity, and Household Fuel 20,45 18,25

04 Furnishings, Household Equipment, and Routine Household Maintenance 5,97 5,49

05 Health 2,62 2,62 06 Transport 12,38 10,82

07 Information, Communication, and Financial Services 5,83 5,49

08 Recreation, Sport, and Culture 2,15 1,58 09 Education 5,62 5,52 10 Food and Beverage Serving Services/Restaurant 8,67 10,77 11 Personal Care and Other Services 5,89 5,60

Total 100 100

From the table above, we can see that in the group level category, the HBS-18 and Susenas-18 show similar pattern of expenditure weight. Both based on HBS 2018 and Susenas 2018, household consumption is dominated by expenditure on the food, beverages, and tobacco group, which amounted to 25.01% based on HBS 2018 and 29.49% based on Susenas 2018. the next largest consumption is followed by the Housing, Water, Electricity, and Household Fuel group, which amounted to 20.45% and 18.25% based on HBS 2018 and Susenas 2018, respectively. The transportation group contributed the 3rd largest consumption value based on both data sources. And the group with the smallest percentage of consumption value based on both surveys is the recreation, sport and culture group. These results show that, although there are slight differences in the percentage of expenditure value between the two data sources, there are similarities in the composition and consumption patterns between groups. This comparison provides valuable information regarding the potential use of Susenas data as an alternative in forming expenditure weights.

In addition to descriptively comparing the weights between HBS 2018 and Susenas 2018, we also tried to see how closely the two weights match and relate. At the commodity level, the SBH-18 and Susenas-18 results have a correlation value of 0.9812, which means a very strong correlation. This indicate the methods used to adjust the Susenas data to obtain alternative weight for CPI give consistent result to those derived from household budget survey.

Furthermore, we will compare HBS-18 with the following year's Susenas. HBS-18 with Susenas- 19, Susenas-20, and Susenas-21. The purpose of this analysis is to evaluate how far the weight generated from SBH 2018 can represent changes of household consumption patterns in the following years. The correlation value at the commodity level can be seen in the table below.

Figure 2. The scatter plot of HBS 2018 and Susenas 2018-2021

Table 3.2 Correlation Coefficient between HBS-18 and Susenas 2018-2021

Year of Susenas Correlation with HBS-18 at Commodity Level

2018 0.9812

2019 0.9788

2020 0.9741

2021 0.9659

Based on the correlation test results, it can be seen that there is a strong correlation between the

HBS-2018 weights and the updated weights of Susenas 2018, 2019, 2020, and 2021. However, the further the year difference between the HBS-2018 and Susenas, the lower the correlation. For example, between HBS 2018 and Susenas 2019, the correlation decreased from 0.9812 to 0.9788. Then when there is a 2-year gap, the correlation further decreases to 0.9741, and after 3 years the correlation again decreases to 0.9659. The larger the year gap between the HBS and Susenas, the less conformity in the weights produced by the two data sources. This also strengthens the hypothesis that using a fixed expenditure weight for years can be no longer relevant in describing the enormous shift in household expenditure patterns.

Changes in Consumption Patterns Between Years Based on Susenas Susenas which is available annually, can be an alternative data source to capture changes in household consumption over time. We can analyze and evaluate changes in expenditure patterns over a year by comparing the latest susenas with the previous period. The following table shows the percentage of expenditure by group, based on Susenas data from 2018 to 2021. It can be seen that there are changes in consumption patterns from year to year. Some expenditure groups have increased or decreased, which may be influenced by several factors, such as changes in consumer preferences, or events that have an economic impact, such as the COVID-19 pandemic.

Table 3.3. Result of Expenditure Weight with Alternative Data Sources Susenas 2018 2019 2020 2021

Food, Beverages, and Tobacco 29.49 28.35 29.33 30.57

Clothing and Footwear 4.35 4.59 4.42 3.55

Housing, Water, Electricity, and Household Fuel 18.24 18.71 18.24 19.72

Furnishings, Household Equipment, and Routine Household Maintenance 5.47 5.45 5.15 5.61

Health 2.61 2.61 2.56 3.19

Transport 10.93 11.32 11.48 9.41

Information, Communication, and Financial Services 5.48 5.28 5.25 5.64

Recreation, Sport, and Culture 1.57 1.63 1.57 1.20

Education 5.50 5.40 5.56 5.57

Food and Beverage Serving Services/Restaurant 10.77 11.12 10.80 9.67

Personal Care and Other Services 5.58 5.55 5.63 5.88

The weight of food, beverage, and tobacco group decreased from 2018 to 2019, while in 2020 and

2021 it increased. One of the reasons for this significant increase in 2021 is the COVID-19 pandemic, where people tend to spend more time at home, and reduce nonfood consumption. Large-scale social restrictions, restaurant closures, and health concerns may have encouraged people to make and consume more food at home. This phenomenon is also in line with the percentage of consumption in the food and beverage service / restaurant group, which has decreased in 2021. For four years, 2018 to 2021, the commodites with the biggest decrease weight are rice with side dishes –0.468 and meatballs ready to eat –0.121.

On the other hand, the clothing and footwear group shows a downward trend from 2019 to 2021. Factors such as changes in fashion trends, reduced social activities, and decreased purchasing power due to the pandemic may affect the interest and need for new clothing and footwear.

Furthermore, the health expenditure group showed a significant increase in 2021. This could be related to the COVID-19 pandemic and people's increasing need for health service, including medical expenses and the purchase of medicines and vitamins. The increasing awareness of the importance of health could also be a factor influencing changes in health spending. Weight increasing for some commodities in health group can be seen in table 3.4.

Table 3.4. Result of weight increasing in Health Group in 2018-2021

Commodities in Health Group Increase of Weight 2021 from 2018

Check Up 0.292 Vitamin 0.118 Laboratory 0.118 Hospital 0.050 Medicines By Prescription 0.036 Jamu (Herb) 0.005 Cough Medicine 0.005 Cold Medicine 0.003

The transportation group showed a drastic decline in 2021 due to reduced mobility and the prohibition of domestic and international flights. The impact of the COVID-19 pandemic, where travel restrictions, working from home, and decreased social activities led to a reduced need for daily transportation. The gasoline consumption decreased by –0.493. Air transport fell by around –0.473. Consumption of online taxibike decreased by –0.123, city transportation decreased by –0.122, and inter-city transportation decreased by –0.069 (more details in the table below).

Table 3.5. Result of weight decreasing in Transportation Group in 2018-2021

Commodities in Transportation Group Decrease of Weight 2021 from 2018

Gasoline -0.493

Air Transportation Rates -0.473 Online Taxibike -0.123 City Transportation -0.122 Inter-City Transportation -0.069 Car -0.068 Train -0.058 Motorcycle -0.052 Online Taxi -0.047 Rental Vehicles -0.034 Taxi -0.014 Travel -0.012 Sea Transportation -0.009

The development of technology and expansion of the digital economy can also be shown by the increasing percentage of spending on the information, communication, and financial services group. This is especially shown in the increase in spending in 2021. In addition, the Covid-19 pandemic has also had an impact on increasing community activities that require internet services, such as online schooling and working from home, shown in table below.

Table 3.6. Result of weight increasing in Information, Communication, and Financial Services

Group in 2018-2021 Commodities in Information, Communication, and Financial Services Group

Increase of Weight 2021 from 2018

Internet Subscription Fees 0.954 Laptop/Notebook 0.009

The impact of the Covid-19 pandemic is also reflected in the expenditure of recreation, sports, and culture group, which showed a decline in 2021. Large-scale social restrictions led to the closure of recreational venues, and a shift in household preferences in spending leisure time. The consumption in recreation decreased –0.198 and bioskop was decrease around –0.036 (2021 from 2018).

It can be concluded that changes in consumption patterns reflected in Susenas data show trends related to phenomena that occur in the year concerned, such as the Covid-19 pandemic which began to have an economic effect in 2020 and 2021. Such shifts may indicate significant economic changes in the pattern of consumer purchases. In addition, changes in consumer needs and preferences, technological developments, price fluctuations and socioeconomic developments can also affect changes in the composition and pattern of expenditure. Alternative CPI using Annual Updated CPI Weight

Based on the evaluation of annual updated weight conducted by comparing the weights of Susenas 2018 and SBH 2018, it can be said that there are similarities in consumption patterns from both sources. In addition, changes in consumption patterns captured based on Susenas 2018-2021 data can also describe the phenomena that occur. This means that Susenas data can be used as an alternative to describe household consumption patterns and as an approach to obtain annual updates of CPI weights.

A comparison of the headline CPI from both sources can be seen in the graph below, which the alternative price indexes conducted appear similar and close to the published CPI.

Figure 3. Index Comparison between Susenas and HBS.

From the graph above, we can see that there is no significant difference between the published CPI (based on the SBH 2018 weight) and the Susenas prices indexes throughout 2018. It means that the expenditure weight from Susenas-18 can predict the published CPI throughout 2018 appropriately. The similar conditions of household expenditure in 2018 depicted in the two data sources provide similar results in the CPI. The similarity of the 2018 CPI data generated from both sources indicates that using the Susenas weights directly can be considered as a method to update the HBS weights periodically. However, further research should be conducted to corroborate these hypotheses.

From the graph above, in some points, the two series indexes began to show slight differences, especially in 2020 and 2021, where the covid pandemic greatly affected changes in people's consumption patterns. Overall, the publish CPI and the alternative index grew by 10,25% and 10,63% respectively from Januari 2018 to March 2022.

We already know that during a pandemic, the weight of several commodities changed significantly, such as increased consumption of the health and communication information group and decreased consumption of the transportation, recreation, and restaurant group. Just for example, the increased demand of health goods and services, causing the prices of several goods in health group to increase. The increase in the price of these commodity should have a significant impact during the pandemic and result in a higher headline CPI, due to the higher portion of expenditure for the commodities.

Validation

We check validity Susenas dataset as alternative data source whether appropriate to use them to produce new expenditure weight. According to our result, as predictor consumption pattern, represented by weight expenditure in the same year in 2018, RMSE has small or nearly zero value. In accordance with this result, MAPE also show relatively small value at 12.11% which means that consumption pattern of Susenas’ sampled data in 2018 can be used as predictor for consumption pattern of HBS in the same year.

The table below also depicts the feasibility of alternative price indices through alternative data sources (Susenas). The RMSE of alternative price indices is approximately zero (0.43), that means no difference between alternative price indices as resulted of Susenas and published CPI. It is followed

98,00

100,00

102,00

104,00

106,00

108,00

110,00 Ja

n- 18

M ar

-1 8

M ay

-1 8

Ju l-1

8 Se

p- 18

N ov

-1 8

Ja n-

19 M

ar -1

9 M

ay -1

9 Ju

l-1 9

Se p-

19 N

ov -1

9 Ja

n- 20

M ar

-2 0

M ay

-2 0

Ju l-2

0 Se

p- 20

N ov

-2 0

Ja n-

21 M

ar -2

1 M

ay -2

1 Ju

l-2 1

Se p-

21 N

ov -2

1 Ja

n- 22

M ar

-2 2

Published CPI Alternative Price Indices

Price reference periode : 2018=100

also with the value of MAPE of 0.34% so that we can conclude this predicted PI is highly accurate forecasting for the CPI in 2018.

Validity Weight Expenditure CPI

RMSE 1.74 0.39 MAPE 12.11% 0.30%

In summary, using an alternative dataset is able to describe consumption patterns and predict the price index as accurately as using SBH data. Based on these results, we have a stronger belief that to describe consumption patterns and the consumer price index, we can also use Susenas data in subsequent years.

4. Conclusion and Implementation Plan

Conclusion Indonesia currently updated expenditure weights through Household Budget Survey every five

years at the commodity level. Using alternative data sources can be considered as a feasible method for generating more frequent of CPI expenditure weight, since particularly it can address towards latest condition in society and more relevant to updated consumption patterns in force majeure conditions specifically, such as The Covid-19 pandemic.

In this study, the alternative data source used is Susenas, which is available every year. The alternative weight and CPI conducted from the Susenas data show a price index that is more dynamic and responsive to changes in household consumption patterns. We also conducted empirical testing through validity tests, with MAPE and RMSE indicators, where Susenas data can be considered as an alternative data source for generating CPI expenditure weight annually to describe consumption patterns and conduct the consumer price index.

This study is expected to be a preliminary to the development of a more up-to-date and accurate CPI calculation methodology, as well as strengthening the understanding of the use of alternative data sources in compiling the CPI. However, since Household Budget Survey (HBS) can capture the whole picture of household expenditure and provide more detailed data, it is considered as the most established survey to obtain CPI weight. More frequent of HBS is still expected as the main source to compile the CPI.

Implementation Plan

Through this study, we can see the feasibility of Susenas data that can be used as an alternative source to describe household expenditure patterns. Further studies can be conducted in building a superlative index to estimate the substitution bias of the CPI. We also plan for future research to approach National Account data, namely HFCE as another data source that also captures household consumption expenditure, as one of the surveys recommended in the CPI manual.

Since BPS-Indonesia currently used the modified Laspeyres method for compiling the current Indices, we also plan to exercise the annual updated CPI using the alternative method, Young or Lowe. This study is the preliminary of BPS-Indonesia's plan to conduct more frequent updates of the CPI weight, so we will continue to review the strategy to implement the Susenas weight or other alternative data sources in compiling the CPI.

5. Limitation Susenas is one of the most massive surveys in Indonesia, yet conducted only twice in a year, in

March and September. It captures the consumption and expenditure of households in only those months, whereas HBS is carried out five-yearly and able to capture monthly consumption patterns over a year in the survey period with more detailed commodities.

On the other hand, there are differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as the commodities in the HBS. This causes less coverage of expenditure on some commodities, which also has implications for the expenditure weights. BPS-Indonesia will continue to review the adjustment methods used to solve these issues.

6. Reference

[1] Masterson, V. 2022. What is a consumer price index and why is it important?, World Economic Forum. Available at: https://www.weforum.org/agenda/2022/05/what-is-the- consumer-price-index/.

[2] Graf, B. 2020. Consumer Price Index Manual 2020 Expenditure Weights and Their Sources. Washington DC : International Monetary Fund

[3] ABS (Australia Bureau of Statistics). 2017. An Implementation Plan to Annually re-weight the Australian CPI. Australia.

[4] Lewis, C.D. 1982. Industrial and business forecasting methods. London: Butterworths. [5] Statistics Indonesia. [6] ABS (Australia Bureau of Statistics). 2016. Information Paper: Increasing the Frequency of

CPI Expediture Class Weight Updates,. Australia [7] Household Budget Survey Metadata 2018 and Consumer Price Survey Metadata 2020 and

2021. [8] National Socio-Economy Survey Metadata. 2020.

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight, Indonesia

Languages and translations
English

BADAN PUSAT STATISTIK

Presenters:

Fathia Utami Afdi Dr. Windhiarso Ponco Adi BPS - Statistics Indonesia

Meeting of the Group of Experts on Consumer Price Indices

Geneva, 7th-9th June 2023

The Use of Alternative Data Source as A Proxy to Approach More Frequent Updates of CPI Expenditure Weight

Authors:

Fathia Utami Afdi Fenanda Dwitha Kurniasari

Zaradia Permatasari BPS - Statistics Indonesia

Outline

2

Introduction01

Methodology02

Results03

Conclusion and Impementation Plan

04

3

01

INTRODUCTION

4

Backgrounds

0

5

10

15

20

25

30

Food Materials Prepared food and beverages

Goods and services

Clothing, footwear, and

headgear

Parties and ceremonies

Housing and household

facilities

Others

W ei

gh t (

% )

Indonesia Expenditure Weight, 2018-2021

2018

2019

2020

2021

The CPI has an important role in determining a country's entire economy

Lesson Learned

From Pandemic

Covid-19

One of the crucial aspects in the CPI calculation is the weighting method

Facing a dynamic and rapid change in consumption behavior, a fixed expenditure weight over a long period can be no longer relevant in describing the enormous shift in household expenditure patterns.

Source: Indonesia- National Socio Economic Survey

5

BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data

as an alternative data source to approach household expenditure weights for compiling the CPI.

Objective of This Study

6

Overview of Consumer Price Survey and Household Budget Survey

Group

Subgroup

Commodity

Price

Headline CPI

Monthly release CPI and inflation

90 cities and national

Fixed basket and weights currently used from HBS 2018

Using the Classification of Individual Consumption by Purpose (COICOP)

Held every 5 years

Currently held in 2022 and will be introduced in January 2024

Expenditure on food and non-food household consumptions

Using the Classification of Individual Consumption by

Purpose (COICOP)

Consumer Price Survey

Household Budget Survey

Presenter
Presentation Notes
Indonesia conducting the HBS every 5 years. Ini masih sejalan dengan rekomendasi pada CPI Manual untuk mengupdate bobot at least 5 tahun 1 kali&#xd;

7

Overview of National Socio-Economy Survey

Capture household consumption/ expenditure in city level every year in March

Availability of data on household welfare, including

education, health, and purchasing power

Using The Classification of Individual Consumption by Purpose (COICOP)

Expenditure on food and non-food

household consumptions

02 03

0401

8

METHODOLOGY

03

9

1 2a 2b 2c 3 4 5Methodology 1

1. DATA PROCESSING

Data Source The Indonesian National Socio-Economic Survey (Susenas), 2018-2021

Total of commodities 296 commodities, 596 fewer than HBS 2018

Estimating total household consumption value per month by commodity

Aggregrate the expenditure value for 90 cities covered in CPI

10

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

a. MAPPING COMMODITIES

HBS2018 commodities Susenas Commodities

011101001-Rice 2-Rice

011101001-Rice 3-Sticky Rice

011101008-Sweet Potatoes 10-Cassava/Sweet Potatoes

054501001- Checkup Rates 252-Health test/early detection/Medical Check Up

054501001- Laboratorium Rates 252-Health test/early detection/Medical Check Up

For example:

2a

11

1 2a 2b 2c 3 4 5Methodology

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

b. CALCULATING THE CONSUMPTION VALUE AND IMPUTATION PROCESS

Notation NK’i : Updated expenditure value for ith commodity based on Susenas NKi(hbs) : expenditure value for ith commodity based on HBS NKj(ssn) : Susenas expenditure value for commodity j which is mapped to ith commodity i : index for commodity in HBS. j : index for commodity in Susenas

Commodities Baskets Expenditure Value based on Susenas Data

011101001-Rice The sum of the rice and sticky rice consumption

011101008-Sweet Potatoes Equals to the Cassava/Sweet Potatoes consumption

054501001- Checkup Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

054501001- Laboratorium Rates Use the consumption value of “252-Health test/early detection/Medical Check Up” proportionally based on HBS 2018

2b

12

1 2a 2b 2c 3 4 5Methodology

Estimating the true value of expenditure

Proportional approach: In this case, the proportion of expenditure on more detailed commodities in the HBS is allocated to broader categories in the Susenas data

Excluding the expenditure value of the insurance, and the party and ceremonies category

Adjustments were carried out to overcome the differences in HBS and Susenas commodity details such as:

2c

2. CONDUCTING THE ALTERNATIVE WEIGHT BASED ON SUSENAS DATA

c. ADJUSMENTS

13

1 2a 2b 2c 3 4 5Methodology

3. EVALUATION THE WEIGHT BASED ON SUSENAS DATA

Evaluation the Susenas 2018 weight Calculate the correlation

Identify changes in trends of household expenditure

patterns year to year based on Susenas weight

3

Presenter
Presentation Notes
Setelah melakukan berbagai adjustment untuk menyesuaikan Susenas dengan cakupan SBH, dilakukan evaluasi dengan menghitung korelasi

14

1 2a 2b 2c 3 4 5Methodology

4. COMPILING THE ALTERNATIVE PRICE INDICES

Elementary Level Indices

Use the same published commodity price change

As BPS-Indonesia’s practice, for elementary level we use the Jevon Formula

Upper Level Indices

Method : modified Laspeyres

Price reference period = weight reference period

Linking the index :

In this study, we started by comparing the published CPI with the Susenas price index, to see how feasible it is that Susenas data can be

used as an approach to calculate the CPI

4

15

1 2a 2b 2c 3 4 5Methodology

5. VALIDATION

Calculate the MAPE and RMSE for :

MAPE Interpretation

<10% Highly Accurate Forecasting

10-19% Good Forecasting

20-49% Reasonable Forecasting

>50% Inaccurate Forecasting

5

HBS18 weight and Susenas 18 weight in the commodity level

CPI and Alternative Price Indices in 2018

16

RESULTS

03

1717

The comparison of HBS 2018 Weight & Susenas Weight​

25,01

5,41

20,45 5,97

2,62

12,38

5,83

2,15 5,62

8,67 5,89

29,49

4,37

18,255,49 2,62

10,82

5,49 1,58

5,52

10,77

5,6

Household Budget Survey 2018 Susenas 2018

18

Correlation: 0,9812 Correlation: 0,9788

Correlation: 0,9741 Correlation: 0,9659

The larger the year gap between the HBS and Susenas, the less correlation in the weights produced by the two data sources

The correlation of HBS 2018 and Susenas

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 8

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

01 9

HBS 2018

0

2

4

6

0 1 2 3 4 5

Su se

na s 2

02 1

HBS 2018

0 1 2 3 4 5

0 1 2 3 4 5

Su se

na s 2

02 0

HBS 2018

19

29,49

28,35

29,33

30,57

2018 2019 2020 2021

Food, Beverages, and Tobacco

4,35 4,59 4,42 3,55

0

1

2

3

4

5

6

2018 2019 2020 2021

Clothing and Footwear

2,61 2,61 2,56 3,19

0

1

2

3

4

5

2018 2019 2020 2021

Health

10,93 11,32 11,48 9,41

2018 2019 2020 2021

Transport

5,48

5,28 5,25

5,64

2018 2019 2020 2021

Information, Communication, and Financial Services

1,57 1,63 1,57 1,2

0

0,5

1

1,5

2

2,5

3

2018 2019 2020 2021

Recreation, Sport, and Culture

10,77 11,12

10,8

9,67

2018 2019 2020 2021

Food and Beverage Serving Services/Restaurant

5,58 5,55 5,63

5,88

2018 2019 2020 2021

Personal Care and Other Services

The Expenditure Weight by Groups Based on Susenas, 2018-2021 (%)

Changes in Consumption Patterns Between Years Based on Susenas

20

Using the Susenas Weight to Condutct the Alternative Price Indices

98

100

102

104

106

108

110

Ja n-

18

M ar

-1 8

M ay

-1 8

Ju l-1

8

Se p-

18

N ov

-1 8

Ja n-

19

M ar

-1 9

M ay

-1 9

Ju l-1

9

Se p-

19

N ov

-1 9

Ja n-

20

M ar

-2 0

M ay

-2 0

Ju l-2

0

Se p-

20

N ov

-2 0

Ja n-

21

M ar

-2 1

M ay

-2 1

Ju l-2

1

Se p-

21

N ov

-2 1

Ja n-

22

M ar

-2 2

Published CPI Alternative Price Indices

The Comparison of CPI and Susenas Price Index

Validity​ Weight Expenditure​ CPI​

RMSE 1.74 0.39

MAPE 12.11% 0.30%

Validation

21

CONCLUSION, IMPLEMENTATION

PLAN, AND LIMITATION

04

22

Conclusion and Implementation Plan

Conclusion

• The HBS-18 and Susenas-18 show similar pattern of expenditure weight • The availability of susenas weight every year allows it to be more responsive to the shifting of

consumption patterns. • As the result of data evaluation (correlation, MAPE, and RMSE), Susenas data can be considered as a

feasible method for generating more frequent of CPI expenditure weight • Household Budget Survey (HBS) is still considered as the most established survey to obtain CPI weight

Implementation Plan

• Future research to approach National Account data (HFCE) as one of the data source recommended in the CPI Manual

• Further studies in building a superlative index to estimate the substitution bias of the CPI • We will continue to review the strategy to implement the Susenas weight or other alternative data

sources in compiling the CPI

23

Susenas only capture the household expenditure in only one month. The differences in the classification

and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as the commodities in the HBS.

Our Concern

  • Slide Number 1
  • Outline
  • INTRODUCTION
  • Backgrounds
  • BPS-Statistics Indonesia conducted this preliminary study to examine the feasibility of using Susenas data as an alternative data source to approach household expenditure weights for compiling the CPI. ​
  • Overview of Consumer Price Survey and�Household Budget Survey
  • Overview of National Socio-Economy Survey​
  • METHODOLOGY
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • Methodology
  • RESULTS
  • The comparison of HBS 2018 Weight & Susenas Weight​
  • The correlation of HBS 2018 and Susenas
  • Changes in Consumption Patterns Between Years Based on Susenas
  • Using the Susenas Weight to Condutct the Alternative Price Indices
  • CONCLUSION, IMPLEMENTATION PLAN, AND LIMITATION
  • Conclusion and Implementation Plan
  • Susenas only capture the household expenditure in only one month. The differences in the classification and coverage of commodities in the Susenas data, where the coverage of commodities is more limited and not as detailed as the commodities in the HBS.​
  • Slide Number 24