Optimization using Excel – 12.Blending (product-mix) problem

Optimization using Excel
Lecture 12
Soumitra Chakraborty
Play Video

This is the twelfth video of the lecture series Optimization using Excel. In this video, I have discussed how to solve a blending problem which is also known as the ‘Diet’ problem. The problem was solved using Excel and solver. Viewers are advised to watch the previous videos (especially the video regarding the Product Mix problem) in order to decipher the continuity. The problem that is discussed is taken from the following book:

Operations Management: Sustainability and Supply Chain Management, Twelfth Edition