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
- Prepare your data in CSV format with products, profits, and required resources
- Upload the file to the upload page
- Set up the parameters (available resources, goal)
- Please wait for processing (usually 1-3 minutes)
- 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)
| 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:
MAX Maximize profit (standard)
MIN Minimize cost
- 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