Kambal Pandesal BreadModel ParametersRecipe Profit

Contribution in Peso

Pan De Sal Mix % per KG

Water % per KG

Nutri Oil % per KG

Yeast % per KG

Ensaymada 10 0.56 0.18 0.05 0.01Pan de Pizza 10 0.69 0.24 0.07 0.00Pan de Pimiento

5 0.69 0.24 0.07 0.00

Pan de Choco España

5 0.69 0.24 0.07 0.00

Available

Supply (in kg)

Pan De Sal Mix

24

Water 10 Nutri Oil 17 Yeast 1

Optimization Model # of breads to

produce

Ensaymada 43.10322581 Total Profit Contribution =

431.03

Pan de Pizza 0 Pan de Pimiento

0

Pan de Choco España

0

kg used Max Avail.

Supply

Pan de Sal Mix

24 <= 24

Water 7.56 <= 10 Nutri Oil 2.28 <= 17 Yeast 0.383225806 <= 1

Model: This is a model of the 4 products Kambal Pandesal products namely Ensaymada, Pan de Pizza, Pan de Pimiento and Pan de Choco España. Their 4 common main ingredients are listed too that are critical to the business. This model maximizes the profit contribution of all the products.

Results: Based on the constraints or the available supply that was shown in the diagram we can conclude that focusing the ingredients on the Ensaymada will yield the most Profit Contribution among all the products. In addition, if there would be one more of the Pan de Sal Mix, we would be able to increase our profit by almost 18 pesos. The amount of Pan de Sal Mix can be increased. If this would happen we would have more profit based on the Sensitivity Report shown in this Model.