Linear Programming LP Optimization with Excel Solver

YOUR LINK HERE:

http://youtube.com/watch?v=6xa1x_Iqjzg

#excel #solver #linearprogramming • Please SUBSCRIBE: • https://www.youtube.com/subscription_... • http://alphabench.com/data/linear-pro... • Please watch: Linear Programming Optimization Transportation Problem Excel Solver • • How to Setup Solve Linear Programmi... • A tablet computer manufacturer offers two models of its product, the Tablet Pro and the Tablet Mini. The Tablet Pro requires 1 chipset, 15 electronic components and 6 hours of labor and returns a profit of $182. The Tablet Mini requires 1 chipset, 9hours of labor and 10 electronic components and returns a profit of $139. Monthly resources are limited to 1,000 chipsets, 7,000 labor hours and 14,000 electronic components. The tablet manufacturer is interested in maximizing monthly profit. What product mix achieves maximal profit? • Overview of formulating linear programming models and using Solver to find an optimal solution. Includes discussion of sensitivity reports and important terminology. • Demonstration of classic two product profit maximization formulation. • • Spreadsheet used in the video can be downloaded from: • http://alphabench.com/resources.html

#############################

New on site