Home

Column

Dashboard Guide

The Procurement Dashboard provides a summary of Items purchased, Quantities, Expenditures and Savings on each category.

Its 9 sections are defined as follows;

  1. Home
    This contains a summary of all procurement events and Particulars
  2. Seeds
    This contains a summary of all procurement events and Particulars about HouseHold Seeds
  3. Water
    This contains a summary of all procurement events and Particulars about Water related Procurements and expenditures
  4. Livestock
    This contains a summary of all procurement events and Particulars about Livestock
  5. Vegs & Fruits
    This contains a summary of all procurement events and Particulars about Vegetables & Fruits
  6. Organics
    This contains a summary of all procurement events and Particulars about Organics
  7. Tools
    This contains a summary of all procurement events and Particulars about Agriculture Tools & Implements
  8. Feeds
    This contains a summary of all procurement events and Particulars about Livestock Feeds
  9. Pivot Tables
    This contains Drag and Drop handles for analysis. A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.Options here are numerous: Count, Count Unique Values, List Unique Values, Sum, Integer Sum, Average, Sum over Sum, 80% Upper Bound, 80% Lower Bound, Sum as Fraction of Total, Sum as Fraction of Rows, Sum as Fraction of Columns, Count as Fraction of Total, Count as Fraction of Rows, Count as Fraction of Columns

Definitions

  1. Delay Time
    This delay in weeks is the difference between the expected delivery and actual delivery dates. Negative time indicates that the delivery was made earlier than expected.
  2. Delivery Success Rate
    This is the proportion of orders made that have been fulfilled.
  3. Pending orders
    These are orders whose delivery has not yet been made.
  4. Delivered orders
    These are orders whose delivery has been made.
  5. Pending orders
    These are orders whose delivery has not yet been made.
  6. Qty Ordered
    These are the number of items oredered.
  7. Qty Delivered
    These are the number of items that have been delivered.
  8. Planned Order Value/Planned expenditure
    This is the value in UGX of orders that have been made.
  9. Delivered Order Value/Actual expenditure
    This is the value in UGX of orders that have been fulfilled.
  10. Savings
    This is the difference between the planned expenditure and the actual expenditure. A negative value indicates more expenditure than planned while a positive value indicates that less was spent than was planned.
  11. % Savings
    This is the proportion of amount saved on procurement compared to the planned expenditure. A negative value indicates more expenditure than planned while a positive value indicates that less was spent than was planned.
  12. Data Table
    Data tables display information in a grid-like format of rows and columns. They organize information in a way that’s easy to scan so that users can look for patterns and develop insights from data.Data tables can contain: Interactive components (such as chips, buttons, or menus), Non-interactive elements (such as badges), Tools to query and manipulate data

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

140,209.5

Planned Order value

1,962,314,000

Savings

74,226,900

Column

Delivery Success rate

Delivered Orders

915

Qty Delivered

140,209.5

Delivered Order Value

1,888,087,100

% Savings

3.78

Column

Amount saved by Item Category

Amount saved by District

Seeds

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

106,240

Planned Expenditure

752,236,000

Amount Saved

50,896,500

Column

Delivery Success rate

Delivered Orders

135

Qty Delivered

106,240

Actual expenditure

701,339,500

% Savings

6.77

Column

HouseHold Seeds DataTable

Water

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

188

Planned Expenditure

612,435,000

Amount Saved

11,573,000

Column

Delivery Success rate

Delivered Orders

169

Qty Delivered

188

Actual expenditure

600,862,000

% Savings

1.89

Column

Water DataTable

Livestock

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

1,160

Planned Expenditure

358,600,000

Amount Saved

-18,290,000

Column

Delivery Success rate

Delivered Orders

66

Qty Delivered

1,160

Actual expenditure

376,890,000

% Savings

-5.1

Column

Livestock DataTable

Vegs & Fruits

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

1,613.5

Planned Expenditure

39,870,000

Amount Saved

3,826,000

Column

Delivery Success rate

Delivered Orders

418

Qty Delivered

1,613.5

Actual expenditure

36,044,000

% Savings

9.6

Column

Vegetables & Seeds DataTable

Organics

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

10,097

Planned Expenditure

80,447,000

Amount Saved

16,058,400

Column

Delivery Success rate

Delivered Orders

61

Qty Delivered

10,097

Actual expenditure

64,388,600

% Savings

19.96

Column

Organics DataTable

Tools

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

3,491

Planned Order value

87,370,000

Amount Saved

8,421,000

Column

Delivery Success rate

Delivered Orders

58

Qty Delivered

3,491

Delivered Order Value

78,949,000

% Savings

9.64

Column

Tools DataTable

Feeds

Column

Delay Time (Weeks)

Pending Orders

0

Qty Ordered

17,420

Planned Order value

31,356,000

Amount Saved

1,742,000

Column

Delivery Success rate

Delivered Orders

8

Qty Delivered

17,420

Delivered Order Value

29,614,000

% Savings

5.56

Column

Livestock Feeds DataTable

Pivot Tables

Column