Contact Us

jpgoulet@cimetech.com

(514) 909-5117


Bromont, (Québec)
Canada

How it Works

The Factory Profit Optimizer methodology 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. The objective is to find the product mix that generates the most profit using different optimization 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 contraints are:

  • 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. The Factory Profit Optimizer methodology does not require you to come up with this kind of equations. Everything is done behind the scene. 

The Factory Profit Optimizer methodology 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

The 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 the Factory Profit Optimizer was able to generate significantly more profit than the other methods. The 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 Profit potential?