How it works
Cimetech Factory Profit Optimizer is based on the principle of the optimal product mix. The following example will help you understand how the Factory Profit Optimizer can help you increase profits of your factory using existing manufacturing resources.
The following table list the variables of a fictional factory that sells 4 products. We will try to find the product mix that generates the most profit using different techniques. We will use a manufacturing period of 40 hours (2400 minutes). There is also a market constraint that limit the quantity of products that can be sold.
| Product 1 | Product 2 | Product 3 | Product 4 | |
|---|---|---|---|---|
| Unit Price | $60 | $130 | $180 | $200 |
| Material Costs | $20 | $70 | $90 | $100 |
| Gross Profit | $40 | $60 | $90 | $100 |
| Max Quantity / week | 100 | 80 | 60 | 50 |
Each product goes through the same 4 workstations, but with a different cycle time.
| Product 1 | Product 2 | Product 3 | Product 4 | |
|---|---|---|---|---|
| Workstation A | 10m | 25m | 30m | 35m |
| Workstation B | 10m | 15m | 20m | 25m |
| Workstation C | 10m | 10m | 20m | 25m |
| Workstation D | 20m | 10m | 20m | 30m |
| Total Cycle Time | 50m | 60m | 90m | 115m |
Method 1: Maximize Gross Profit per Unit
Products with the highest gross profit per unit should be sold before products with a lower gross profit. In this example, priority should be given to Product 4, then Product 3, Product 2 and Product 1.
| P1 | P2 | P3 | P4 | Total | |
|---|---|---|---|---|---|
| Quantity | 2 | - | 21 | 50 | |
| Workstation A | 20m | - | 630m | 1750m | 2400m |
| Workstation B | 20m | - | 420m | 1250m | 1690m |
| Workstation C | 20m | - | 420m | 1250m | 1690m |
| Workstation D | 40m | - | 420m | 1500m | 1960m |
| Sales | $120 | - | $3,780 | $10,000 | $13,900 |
| Cost of Goods Sold | $40 | - | $1,890 | $5,000 | $6,930 |
| Gross Profit | $80 | - | $1,890 | $5,000 | $6,970 |
The method creates a product mix that generates a gross profit of $6,970. The market constraint for Product 4 and a manufacturing bottleneck for workstation A were detected. However, these might not be the true bottlenecks.
Method 2: Minimize Manufacturing Costs
Manufacturing cost should be minimized. We calculate the cost per minute at the bottleneck to manufacture a product.
| Product 1 | Product 2 | Product 3 | Product 4 | |
|---|---|---|---|---|
| Bottleneck Cost | $1.00/m | $7.00/m | $4.50/m | $3.33/m |
In this example, priority should be given to Product 1, then Product 4, Product 3 and Product 2.
| P1 | P2 | P3 | P4 | Total | |
|---|---|---|---|---|---|
| Quantity | 100 | 1 | - | 13 | |
| Workstation A | 1000m | 25m | - | 455m | 1480m |
| Workstation B | 1000m | 15m | - | 325m | 1340m |
| Workstation C | 1000m | 10m | - | 325m | 1335m |
| Workstation D | 2000m | 10m | - | 390m | 2400m |
| Sales | $6,000 | $70 | - | $1,300 | $8,730 |
| Cost of Goods Sold | $2,000 | $70 | - | $1,300 | $3,370 |
| Gross Profit | $4,000 | $60 | - | $1,300 | $5,360 |
The method creates a product mix that generates a gross profit of $5,360. The market constraint for Product 1 and a manufacturing bottleneck for workstation D were detected. However, these might not be the true bottlenecks.
Method 3: Maximize Unit Sales
Manufacture the most units possible.
| P1 | P2 | P3 | P4 | Total | |
|---|---|---|---|---|---|
| Quantity | 90 | 60 | - | - | |
| Workstation A | 900m | 1500m | - | - | 2400m |
| Workstation B | 900m | 900m | - | - | 1800m |
| Workstation C | 900m | 600m | - | - | 1500m |
| Workstation D | 1800m | 600m | - | - | 2400m |
| Sales | $5,400 | $7,800 | - | - | $13,200 |
| Cost of Goods Sold | $1,800 | $4,200 | - | - | $6,000 |
| Gross Profit | $3,600 | $3,600 | - | - | $7,200 |
The method creates a product mix that generates a gross profit of $7,200. Manufacturing bottlenecks for workstation A and D were detected. However, these might not be the true bottlenecks.
Method 4: Maximize Profits at the bottleneck
Gross profits should be maximized. We calculate the gross profit per minute at the bottleneck.
| Product 1 | Product 2 | Product 3 | Product 4 | |
|---|---|---|---|---|
| Bottleneck Profit | $2.00/m | $2.40/m | $3.00/m | $2.86/m |
In this example, priority should be given to Product 3, then Product 4, Product 2 and Product 1.
| P1 | P2 | P3 | P4 | Total | |
|---|---|---|---|---|---|
| Quantity | - | - | 60 | 17 | |
| Workstation A | - | - | 1800m | 595m | 2395m |
| Workstation B | - | - | 1200m | 425m | 1625m |
| Workstation C | - | - | 1200m | 425m | 1625m |
| Workstation D | - | - | 1200m | 510m | 1710m |
| Sales | - | - | $10,800 | $3,400 | $14,200 |
| Cost of Goods Sold | - | - | $5,400 | $1,700 | $7,100 |
| Gross Profit | - | - | $5,400 | $1,700 | $7,100 |
The method creates a product mix that generates a gross profit of $7,100. The market constraint for Product 3 and a manufacturing bottleneck for workstation A were detected. However, these might not be the true bottlenecks.
Method 5: Optimal Product Mix using Factory Profit Optimizer
A gross profit of $7,200 was reached using one the previous methods. Regardless of which method is chosen, none have came up with an optimal product mix that will generate the maximum of profits. The best way to find it is to reformulate this example as a mathematical equation. The formula for the gross profit is:
P1⋅$40 + P2⋅$60 + P3⋅$90 + P4⋅$100 = Gross Profit
where
- P1 ≤ 100 units
- P2 ≤ 80 units
- P3 ≤ 60 units
- P4 ≤ 50 units
- P1⋅10m + P2⋅25m + P3⋅30m + P4⋅35m ≤ 2400 minutes
- P1⋅10m + P2⋅15m + P3⋅20m + P4⋅25m ≤ 2400 minutes
- P1⋅10m + P2⋅10m + P3⋅20m + P4⋅25m ≤ 2400 minutes
- P1⋅20m + P2⋅10m + P3⋅20m + P4⋅30m ≤ 2400 minutes
We need to find the maximum gross profit that can be achieved while respecting the constraints. Cimetech Factory Profit Optimizer does not require you to come up with this kind of equation. Everything is done behind the scene. You just need to create the process using the process designer.
Cimetech Factory Profit Optimizer will find an optimal solution quickly by trying thousand of combinations.
| P1 | P2 | P3 | P4 | Total | |
|---|---|---|---|---|---|
| Quantity | 60 | - | 60 | - | |
| Workstation A | 600m | - | 1800m | - | 2400m |
| Workstation B | 600m | - | 1200m | - | 1800m |
| Workstation C | 600m | - | 1200m | - | 1800m |
| Workstation D | 1200m | - | 1200m | - | 2400m |
| Sales | $3,600 | - | $10,800 | - | $14,200 |
| Cost of Goods Sold | $1,200 | - | $5,400 | 0 | $6,600 |
| Gross Profit | $2,400 | - | $5,400 | - | $7,800 |
Cimetech Factory Profit Optimizer creates a product mix that generates a gross profit of $7,800. The market constraint for Product 3 and manufacturing bottleneck for workstation A and D were detected, which are the true bottlenecks.
This is a simple example with only 4 small processes, yet Cimetech Factory Profit Optimizer was able to generate significantly more profit than the other methods. Cimetech Factory Profit Optimizer will be even more useful in real life situations when there are a lot more variables to take into account. Has your factory reached its full potential?