Dark Mode
Coffee Drink Recipe and Cost Analysis
Retail & Consumer Behavior
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Contains essential information about the menu offerings, focusing on the recipes and prices of different coffee and non-coffee drinks sold by a major coffee chain operating across Europe. The primary goal is to enable users to determine the cost of individual ingredients, analyze how final consumer prices are set, and ultimately identify the least and most profitable items on the menu. Additional insights are provided regarding up-charging mechanisms, such as increasing size or selecting alternative milk types.
Columns
- drink_type: Describes the specific type of beverage (e.g., espresso, latte, frappucino). This column contains 31 unique values.
- price_small: The listed price in euros (€) for the small serving size of the drink.
- price_medium: The listed price in euros (€) for the medium serving size of the drink.
- price_large: The listed price in euros (€) for the large serving size of the drink.
- simple: The price for a simple variation of the coffee, such as a basic filter coffee. Note that data availability is sparse for this column.
- double: The price for items like a double espresso shot. Data availability is very low for this column.
Distribution
The data is typically provided in a CSV file format and contains 6 distinct columns. While the total number of records is 31, pricing data for the small, medium, and large sizes is valid for 26 records, indicating a small number of missing values. Crucially, the
simple and double price columns have a high percentage of missing values (84% and 87% respectively). All prices listed are in euros.Usage
Ideal applications include:
- Determining the theoretical cost of each ingredient utilized in a drink recipe.
- Modelling and understanding the underlying pricing methodology used by the coffee chain.
- Estimating the cost attributed to the manual labour provided by the barista for preparing each item.
- Conducting profitability studies to rank menu items from least to most profitable.
Coverage
The data reflects the pricing and standard recipes of a single, unnamed coffee shop chain operating in Europe. While the core recipes and ingredients are identical across all locations of the chain, prices may experience minor variations between individual stores. The chain's menu also includes food items (e.g., sandwiches), though this data product focuses primarily on beverage pricing and recipes.
License
CC0: Public Domain
Who Can Use It
- Data Scientists and Analysts: For regression analysis, predictive modelling of price changes, and studies in data analytics.
- Retail Management: Business professionals seeking benchmarks for ingredient costing and margin optimization in the food service sector.
- Academic Researchers: Students or academics studying microeconomics, pricing elasticity, and cost analysis within the fast-moving consumer goods environment.
Dataset Name Suggestions
- European Coffee Chain Profitability Metrics
- Retail Beverage Menu Pricing Strategy
- Coffee Drink Recipe and Cost Analysis
Attributes
Original Data Source: Coffee Drink Recipe and Cost Analysis
QUALITYLoading...