Proposed prototype (PP)

1. Streamlining the Current System of Compiling SUA/FBS: Results from Prototype 1.0 TestingJuly 2010

2. Some conclusions on strengths and limitations based on testing exercises of the prototype version 1.0 using platform MSExcel for India and Uganda

3. 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 sub-elements to trace the flow of processing as well as estimate proportion of utilization Proposed prototype (PP)

4. 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 India case

5. 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).

6. 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 Uganda case

7. 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).

8. 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.

9. 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.

10. Commodity coverage for India and differences between the prototype approach and actual data

12. Differences for Uganda in Total DES between the prototype approach and actual data

13. Final consideration by implementer: The prototype is worth installing to the working system.