Transcript Streamlining the Current System of Compiling SUA/FBS: Results from Prototype 1.0 Testing (Ricardo Sibrian)

Streamlining the Current System of
Compiling SUA/FBS:
Results from Prototype 1.0 Testing
July 2010
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Some conclusions on strengths
and limitations based on testing
exercises of the prototype version
1.0 using platform MSExcel for
India and Uganda
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Proposed prototype (PP)
• the PP inserts automatically many
conversion factors for SUA-elements (Feed,
Seed, Waste etc.)
• the PP imputes missing production to cover
traded product when exports are greater than
imports otherwise imports contribute directly
to supply
• the PP creates multiple process/input subelements to trace the flow of processing as
well as estimate proportion of utilization
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
India case
• Sample of 60 food products with all
elements, years 2003-2008 covering around
65% DES
• The PP yielded total per person per day DES
(Dietary Energy Supply) higher by 30 kcal for
2003-05 compared to current data processing
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Strengths
With a lot of official data for SUA elements, the use of PP
conversion factors saves 25% of manual data input, without
counting time necessary for data search for these elements.
When only trade data are available the PP completes
production estimates if exports are higher than imports which
currently remain unbalanced and not included in totals.
The PP trace multiple processing / input data flows avoiding
manual or automatized calculations that can create errors, so
called negative processing (input amount higher than
processing amount).
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Uganda case
• Tested all 467 agricultural products
(100% DES)
• The PP yielded total per person per day
DES (Dietary Energy Supply) higher by
35 kcal for 2003-05 compared to current
data processing
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Strengths
The use of PP conversion factors saves 5% of manual data input,
without counting time necessary for data search for these
elements.
If only trade data are available the PP completes production
estimates if exports are higher than imports the PP balance the
account (currently remains unbalanced and not included in totals).
The PP traces multiple processing / input data flows avoiding
manual or automatized calculations that can create errors, so
called negative processing (input amount higher than processing
amount).
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Strengths
To create the Uganda complete PP took one week (only once)
saving 5% time but for next year exercise it would save 20% of first
time plus better quality of work.
To create the India partial PP (65% DESpc) took one week (only
once) saving 25% time but for next year exercise it would save
20% of first time plus better quality of work.
The PP avoids calculations producing negative domestic supplies.
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Aspects for further consideration
(limitations?)
This is a delicate task and time consuming, for example, Uganda took one
week, but needed only once; current processing may take one to four
weeks depending on the country.
The conversion factors for SUA elements should be as accurate as
possible in order to have the amounts at the same level as reported by the
country (or neighboring countries if own data not available).
The supply utilization accounts (SUA) should be as reliable as possible in
order to obtain balanced accounts for each item when aggregated and
converted back to primary product status.
The creation of multiple processing / input flow, with relative proportions, is
the most difficult and challenging step in the PP building process.
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Commodity coverage for India and differences between
the prototype approach and actual data
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Differences for Uganda in Total DES between the
prototype approach and actual data
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010
Final consideration
by implementer:
The prototype is worth installing
to the working system.
Workshop on Methodology for the Compilation of Supply Utilization Accounts and Food Balance Sheets: Challenges and Proposals for Improvement
FAO Headquarters, Rome, Italy, 13 July 2010