Compiled by: Jane Chebet
Procurement management professionals in Kenya rely heavily on accurate data to make informed decisions that optimize supply chains, control costs, and ensure compliance with regulations. This chapter introduces elementary statistics foundational to procurement tasks, starting with data collection methods essential for gathering reliable information. Understanding how to collect and interpret data correctly enhances procurement planning, supplier evaluation, and contract management, ultimately improving organizational performance.
Data collection is the process of gathering information relevant to procurement activities such as supplier performance, price trends, and demand forecasting. It forms the basis for statistical analysis and decision-making in procurement management. Accurate and systematic data collection ensures that procurement decisions are evidence-based, reducing risks such as budget overruns or supplier failures. This section explores fundamental concepts and practical approaches to data collection within procurement contexts.
Data in procurement can be qualitative or quantitative, each serving different analytical purposes. Quantitative data includes numeric values such as prices, quantities, and delivery times, while qualitative data involves descriptive information like supplier reputation or contract terms. Understanding the nature of data helps procurement managers select appropriate collection and analysis techniques.
Example 1: A procurement officer records delivery times in days for 5 suppliers: 7, 10, 6, 8, and 9 days. Identify the type of data.
Given: Delivery times (7, 10, 6, 8, 9 days)
This is quantitative data because it consists of numeric values representing measurable delivery durations.
Answer: Quantitative data (delivery times in days)
Example 2: A procurement team rates supplier reliability as "High," "Medium," or "Low" based on past performance. Identify the data type.
Given: Supplier reliability ratings
This is qualitative data because it describes categorical attributes without numeric measurement.
Answer: Qualitative data (categorical supplier ratings)
Example 3: The prices of items procured are recorded as Ksh 500, 750, 620, 800, and 540. What kind of data is this?
Given: Prices (Ksh 500, 750, 620, 800, 540)
This is quantitative data because prices are numeric and measurable.
Answer: Quantitative data (numeric price values)
The purpose of data collection in procurement is to provide accurate, timely information that supports cost-effective purchasing, supplier evaluation, and contract compliance. It enables organizations to analyze trends, forecast demand, and negotiate better terms. Data also helps in risk assessment and maintaining transparency in procurement processes.
Example 1: A procurement officer collects monthly purchase prices to analyze price trends over a year. What is the main purpose?
Given: Monthly purchase prices for 12 months
Purpose: To identify price fluctuations and plan procurement budgets accordingly.
Answer: Price trend analysis for budgeting
Example 2: Data on supplier delivery punctuality is collected to assess their reliability. What is this data used for?
Given: Delivery dates compared to agreed dates
Purpose: Supplier performance evaluation to inform future contracts.
Answer: Supplier reliability assessment
Example 3: Procurement records of quantities ordered and received are collected. What purpose does this serve?
Given: Ordered and received quantities
Purpose: To detect discrepancies and ensure contract compliance.
Answer: Monitoring order fulfillment accuracy
Data collection methods in procurement can be classified mainly into primary and secondary sources. Primary data is collected firsthand directly from suppliers or market observations, while secondary data involves using existing records or reports. Choosing the right method depends on factors such as data accuracy requirements, cost, and time constraints.
Example 1: A procurement officer conducts supplier interviews to gather price quotes. Identify the data collection method.
Given: Direct interviews with suppliers
This is a primary data collection method because data is collected firsthand.
Answer: Primary data collection
Example 2: A procurement team uses past purchase records to analyze supplier performance. Identify the method.
Given: Existing purchase records
This is secondary data collection because it uses already available data.
Answer: Secondary data collection
Example 3: Market price data is obtained from government trade reports. What type of data collection is this?
Given: Government trade reports
This is secondary data collection from published sources.
Answer: Secondary data collection
Systematic data collection involves several steps to ensure accuracy and relevance. These steps guide procurement managers in planning, executing, and validating data gathering processes.
Example 1: Outline the steps to collect supplier price data for a procurement project.
Step 1: Define the objective – Determine the purpose of collecting price data.
Step 2: Identify sources – Select suppliers or market segments to source data from.
Step 3: Choose collection method – Decide on interviews, surveys, or document review.
Step 4: Design data collection tools – Prepare questionnaires or data sheets.
Step 5: Collect data – Execute the data gathering process.
Step 6: Validate data – Check for accuracy and completeness.
Answer: Steps 1 to 6 as above
Example 2: A procurement officer needs to collect delivery performance data. Describe the procedure.
Step 1: Define data requirements – Specify delivery metrics to collect.
Step 2: Identify data sources – Use delivery logs or supplier reports.
Step 3: Select data collection method – Choose direct observation or record review.
Step 4: Prepare collection instruments – Create data entry templates.
Step 5: Collect data – Gather delivery dates and times.
Step 6: Review data – Verify data consistency.
Answer: Steps 1 to 6 as above
Example 3: For demand forecasting, data collection is required. List the steps.
Step 1: Determine forecast objectives.
Step 2: Identify relevant data sources (historical sales, market trends).
Step 3: Select collection method (database extraction, surveys).
Step 4: Develop data collection plan.
Step 5: Execute data collection.
Step 6: Validate and clean data.
Answer: Steps 1 to 6 as above
Identify the type of data collected in the following scenarios: (a) Supplier ratings as Excellent, Good, Poor; (b) Quantities ordered in units; (c) Delivery times in days. (3 marks)
A procurement officer collects monthly prices for a commodity over 6 months: Ksh 500, 520, 510, 530, 525, 540. What is the purpose of this data collection? (2 marks)
Describe the six steps involved in collecting supplier performance data. (6 marks)
Create a free account to open more of this chapter.
Free: practical guides, quick cards, workplace scenarios and more.
Create a free accountThis chapter provides a comprehensive overview of elementary statistics starting with an introduction to data collection, emphasizing its importance in gathering relevant information. It then explores the two main methods of data collection: primary data obtained directly from original sources and secondary data derived from existing records. Sampling techniques are discussed next, distinguishing between probability sampling, which involves random selection, and non-probability sampling, where selection is based on subjective judgment. The chapter further explains various methods of data presentation, including frequency distribution tables and different types of diagrams such as bar charts, pie charts, histograms, and frequency polygons. Additionally, it covers several graph types used for data analysis, including basic time series graphs, z-charts, Lorenz curves, and semi-logarithmic graphs. Finally, the chapter concludes with the use of cumulative frequency curves, also known as ogives, to represent data distributions visually.
A procurement officer collects data on the number of suppliers contacted each day over 5 days: 12, 15, 13, 10, 14. Calculate the mean number of suppliers contacted per day. (2 marks)
From the following data on delivery times (in days) for 8 orders: 3, 5, 4, 7, 6, 5, 4, 3, find the median delivery time. (2 marks)