Dairy Farm Operations and Sales Dataset

Project Objectives:

• Analyze dairy farm performance based on location, land area, and cow population.
• Study the sales and distribution patterns of different dairy products across various brands and regions.
• Examine the impact of storage conditions and shelf life on dairy product quality and availability.
• Understand customer preferences and buying behaviors based on location and sales channels.
• Optimize inventory management by tracking stock levels, minimum thresholds, and reorder quantities.

Problem Statement:

• Predict dairy product demand and sales patterns.
• Identify trends in dairy product consumption across different regions.
• Optimize dairy farm operations and sales channels.
• Enhance inventory management by maintaining appropriate stock levels and reorder quantities.

Dataset Features:

• 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 in the dairy farm.
• Farm Size (sq.km): The size of the dairy farm in square kilometers.
• Date: The date the data was recorded.
• Product ID: A unique identifier for each dairy product.
• Product Name: The name of the dairy product.
• Brand: The brand associated with the dairy product.
• 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.
• Storage Condition: The recommended storage condition for the dairy product.
• Production Date: The date the dairy product was produced.
• Expiration Date: The date the dairy product expires.
• 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 total revenue generated from the sale of the dairy product.
• Customer Location: The location of the customer who purchased the 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 reorder quantity for the dairy product.

Usage:

• Sales analysis to understand trends and patterns in dairy product consumption.
• Inventory management optimization by tracking stock levels and reorder quantities.
• Demand forecasting to predict future sales and optimize product pricing.
• Market research to study the dairy industry's performance across various regions.
• Predictive modeling for pricing and sales strategies.

Coverage:

License:

Who can use it:

• Data analysts and researchers studying the dairy industry.
• Dairy producers and farmers looking to optimize their sales and operations.
• Retailers and distributors analyzing sales trends and inventory management.
• Policy makers in the agricultural and food industry.
• Machine learning practitioners working on predictive models for demand forecasting and sales optimization.

How to use it:

• Develop predictive models for dairy product demand forecasting and pricing strategies.
• Conduct exploratory data analysis to uncover trends in dairy sales and inventory.
• Analyze market and customer preferences based on sales channels and geographic regions.
• Optimize inventory management strategies by analyzing stock thresholds and reorder quantities.

Dataset Information:

• License: CC0
• Region: India
• Type: Dairy Sales and Inventory Data
• Version: 1.0