1 / 6

MODULE 3. Price Incentives and Disincentives SESSION 3. Data Management and Documentation

This module outlines a standardized framework for data management related to price incentives and disincentives. It includes step-by-step instructions for gathering, analyzing, and storing data, as well as providing consistent documentation for each data point used. Users will work with a basic Excel template to enter product pricing in different currencies, set exchange rates, and categorize products as imports or exports. Additionally, the module emphasizes the importance of thorough documentation for data availability and decision-making, facilitating consistency and replicability over time.

teenie
Download Presentation

MODULE 3. Price Incentives and Disincentives SESSION 3. Data Management and Documentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MODULE 3. Price Incentives and DisincentivesSESSION 3. Data Management and Documentation

  2. Module objectives: • Share a common framework for data gathering, analysis and storage • Provide a consistent background documentation for each data included

  3. Data storage • Basic Excel workbook “TEMPLATE FINAL TRIS.XLSX” • Introduce as many sheets as products in the list • Cells highlighted in yellow need to be filled in • Set local currency and reference currency for units • Price in International currency (i.e. EUR/TON, USD/TON) in cell C6 • Exchange rate (i.e. KSH/USD) in cell C7 • Price In local currency (i.e. KSH/TON) in cell C8 • Select type of product (import / export) in cell G4 • Sets note for benchmark price • Sets calculations for access costs

  4. Data storage • Introduce data for concepts and relevant years • Introduce production volumes in rows “58”for calculating total incentive or disincentive for product • The data introduced then feeds into the built-in formulae as explained in module 2 • In particular: • Defining the product as export or import • Including data for the “shadow concepts”

  5. Data Documentation • In each country data availability guides decisions on how to treat the data • Ideally this documentation should allow to recalculate data if approaches are not consistent across countries and/or commodities • For each data point fill in the document “Data_backup_information.doc” • If there is no data available for a specific concept the document should document the closest data available and potential paths to gather that data. • This document should be the backbone of the data gathering exercise and allow other users to: • check consistency of decisions made across countries and commodities • replicate the analysis in subsequent years

  6. Thank you!

More Related