Basic Excel Business Analytics #57: Intro To Linear Programming using Algebra, Pencil & Paper

Learn:
1) (00:10) Intro To Linear Programming
2) (04:12) Use Liner Algebra and the Graphing Method on paper to solve Manufacturing problem where we try to maximize contribution Margin give a set of constraints.
3) (06:02) List parameters (Formula Inputs) and Decision Variables
4) (09:07) List Math Model: Objective Function and Constraint Functions: All are Linear Equations/Inequalities.
5) (15:08) Graph Linear Inequalities.
6) (21:50) Feasible Region and vertices (extreme points) will yield our Optimal Solution.
7) (26:35) Summary

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[angelaexhorts]

You are welcome and I only commented because I like your videos and wanted to make sure I was not missing anything.

[Huanglin]

I'm wondering how you concluded the optimum point simply by calculating the CM at the vertices, when theoretically it could be on some other point along the slope? Is there some sort of rule for that?


I used math to prove that in this case, the optimum point is where x is maximum but is it true that in all cases, optimum point is going to be one of the vertices?

[MySpreadsheetLab]

This entire playlist is amazing! Thank you Mike!

[DIGITAL_COOKING]

Recently I used solver with little knowledge about it was great so I was interested to know more about it
the first idea came to my mind: check what Mike did he all-time do with further details... I was right 🙂

[brightgardenentrepreneuria]

Great vidoe, you're the best.
The video jumps gave me flashbacks of Gumby and Pokey which I watched as a kid may decades ago - as new releases, not reruns(!).

[MrSarky]

Hey Mike & The online excel team,

I wish you all happy holidays, get some rest & take care ! :)

Mike, thank you so much for all of your videos. You made me love excel and thanks to this I pursued even further to visual basic, and pretty much that I want to be a programmer.

[krn]

I kinda like the 700, 000 better. :)
Thanks for producing these videos Mike.

[michielvandenheuvel]

Your work is amazing. Very helpful! Thanks a lot

[ege]

I would like to ask that what is name of textbook that is used for this class?

[mahmoudghanem]

thank you very much ^_^ it was magnificent

[noparking]

I need some help getting an input frequency range 1-2000 to display corresponding switches in a switch calculator assignment without entering it one by one. Switches are A-P in Rows E3-E18 - frequency which is blank and manually entered entered is A3 [1-2000]. I want to list the frequency number small to large and corresponding switches.

[jinmoon]

Maybe it's easier that draw linear and then limit x and y. Just my opinion, but still, very good video, thank you!

[angelaexhorts]

why do you say 700, 000 (seven hundred thousand) when you show 70, 000 (seventy thousand)