Mix Pizza
Product mix optimization with linear programming
What is Mix Pizza?
Mix Pizza is an optimization service that uses linear programming to find the best combination of products to produce/sell, maximizing profit within your resource constraints.
You define the products, their profits, costs, and constraints (time, raw materials, capacity), and the system automatically calculates how much to produce of each item to maximize the outcome.
Usage examples:
- • Decide how many units of each product to manufacture
- • Optimize sales mix in restaurants (menu)
- • Plan production considering limited resources
- • Maximize profit while respecting inventory capacity and labor.
Quick Start
- 1. Prepare your data in CSV format with products, profits, and required resources
- 2. Upload the file to the upload page
- 3. Set up the parameters (available resources, goal)
- 4. Please wait for processing (usually 1-3 minutes)
- 5. See the optimal product mix and the maximum possible profit
How to organize your data
Organize your data in a CSV spreadsheet with the following columns:
Column 1: Product
Product name or SKU. For example: Margherita Pizza, Calabrese Pizza
Column 2: Unit Profit
How much do you earn selling one unit? For example: 15.00, 18.50
Columns 3+: Required Resources
How much of each resource is needed per unit. For example: oven_time (min), cheese (g), dough (g)
Product spreadsheet example:
| produto | lucro | tempo_forno | queijo_g |
|---|---|---|---|
| Margherita | 15.00 | 10 | 200 |
| Calabresa | 18.50 | 12 | 150 |
| Pepperoni | 20.00 | 15 | 180 |
| Vegetariana | 16.00 | 11 | 120 |
💡 Tip: You also need to specify the LIMITS of each resource (e.g., oven available 480 min/day, cheese available 5000g/day). This will be configured in the parameters.
Optimization Settings
Resource Limits
Set the maximum available amount of each resource (time, raw material, capacity).
Examples:
- • Oven time available: 480 minutes/day
- • Cheese available: 5000 grams/day
- • Production capacity: 100 units/day
Objective Function
What do you want to optimize:
Additional Restrictions
Optional: Add extra constraints to the model:
Minimum/Maximum demand
Ex: Produce at least 10 Margherita pizzas
Proportions between products
Ex: Calabresa must be at least 30% of the total
Understanding the results
The system returns the optimal solution: how many units to produce of each product and the maximum value of the objective (profit or minimized cost).
Solution Information
Optimal Quantity per Product
How many units to produce of each item to maximize the outcome.
Example: Margherita: 20, Calabrese: 15, Pepperoni: 10
Maximum Target Value
The maximum profit (or minimum cost) you can achieve with this setup.
Example: Maximum profit = R$ 825.00
Resource Usage
How much of each resource will be used in the optimal solution.
Example: Oven used: 450/480 min (94%), Cheese used: 4800/5000g (96%)
Bottleneck Resources
Resources that are 100% utilized and limit more production.
If these resources are increased, profit may improve
⚠️ Important: If the solution indicates zero units for any product, it means that it is not profitable under the current constraints. Consider reviewing prices, costs, or capacities.
Need help? Contact us: contato@grabatus.com