Dark Mode
Dairy Industry Sales and Inventory Data
Food & Beverage Consumption
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This dataset provides detailed information relating to dairy farms, dairy products, sales, and inventory management. It includes a wide range of data points such as farm locations, land area, cow population, production dates, product specifics, brand information, quantities, pricing, shelf life, storage conditions, expiration dates, sales figures, customer locations, sales channels, stock quantities, stock thresholds, and reorder quantities. The dataset is ideal for analysing farm performance, understanding sales and distribution patterns, studying the impact of storage and shelf life, and optimising inventory management. It also supports market research, trend analysis, and the development of predictive models for demand forecasting and pricing strategies.
Columns
- Location: The geographical location of the dairy farm.
- Total Land Area (acres): The total land area occupied by the dairy farm.
- Number of Cows: The number of cows present on the dairy farm.
- Farm Size: The size of the dairy farm in square kilometres.
- Date: The date of data recording.
- Product ID: A unique identifier for each dairy product.
- Product Name: The name of the dairy product, e.g., Curd, Lassi.
- Brand: The brand associated with the dairy product, e.g., Amul, Mother Dairy.
- Quantity (liters/kg): The quantity of the dairy product available.
- Price per Unit: The price per unit of the dairy product.
- Total Value: The total value of the available quantity of the dairy product.
- Shelf Life (days): The shelf life of the dairy product in days.
- Storage Condition: The recommended storage condition for the dairy product, e.g., Refrigerated, Frozen.
- Production Date: The date of production for the dairy product.
- Expiration Date: The date of expiration for the dairy product.
- Quantity Sold (liters/kg): The quantity of the dairy product sold.
- Price per Unit (sold): The price per unit at which the dairy product was sold.
- Approx. Total Revenue (INR): The approximate total revenue generated from the sale of the dairy product.
- Customer Location: The location of the customer who purchased the dairy product.
- Sales Channel: The channel through which the dairy product was sold (Retail, Wholesale, Online).
- Quantity in Stock (liters/kg): The quantity of the dairy product remaining in stock.
- Minimum Stock Threshold (liters/kg): The minimum stock threshold for the dairy product.
- Reorder Quantity (liters/kg): The recommended quantity to reorder for the dairy product.
Distribution
The dataset is provided in CSV format, named
dairy_dataset.csv, with a size of 731.74 kB. It contains 23 columns and 4325 records, with no mismatched or missing values across any of the fields.Usage
This dataset can be used for a variety of purposes:
- Analysing dairy farm performance: Based on attributes like location, land area, and cow population.
- Understanding sales and distribution patterns: For different dairy products across various brands and regions.
- Studying product quality and availability: Investigating the impact of storage conditions and shelf life.
- Analysing customer preferences: Understanding buying behaviour based on location and sales channels.
- Optimising inventory management: By tracking stock quantities, minimum thresholds, and reorder quantities.
- Conducting market research: Identifying trends within the dairy industry.
- Developing predictive models: For demand forecasting and pricing strategies.
Coverage
The dataset includes data from the period between 2019 and 2022. It specifically focuses on selected dairy brands operating in specific states and union territories of India. Key locations for both farms and customers include Delhi and Chandigarh. It should be noted that there is an intentional drift highlighted in the dataset's figures due to its open-source and creative licence.
License
CC0: Public Domain
Who Can Use It
This dataset is particularly useful for:
- Researchers: For market research, trend analysis, and developing predictive models for demand forecasting.
- Analysts: To assess farm performance, sales patterns, customer behaviour, and for inventory optimisation.
- Businesses in the dairy industry: For optimising inventory, understanding distribution networks, and informing pricing strategies.
Dataset Name Suggestions
- Dairy Industry Sales and Inventory Data
- Indian Dairy Farm to Sales Analysis
- Dairy Product Market Insights
- Farm to Retail Dairy Dataset
Attributes
Original Data Source: Dairy Industry Sales and Inventory Data
QUALITY