 So let's say for example, I'm a nice little coffee Food truck sort of person known as pony express and one of the things that I want to know is what is the maximum possible? Revenue I can make on a given day if I sell coffee cups Coffee lattes and mochas at these different prices The problem is we're talking about physical goods and that means that I have certain limitations Obviously, I'm not gonna buy an infinite amount of coffee cups I'm only gonna have five hundred coffee cups. So collectively I can only sell five hundred But then I only have the materials For say a premium latte or a premium mocha I only have enough materials to total sort of make 350 those and on top of that I only have enough material to make at most a 125 mochas, so I can't just say oh, let's just sell mochas all the time So what can I do? Well, this is actually where the solver option can come into play because it allows us to have a little bit more control Than something like the goal seek So how do I do this? Well, I have first installed solver and I click on it This is gonna pull up a nice little objective for me What is my objective to change what value in our case G4 our total revenue now? I can set it to be the maximum the minimum or the value of but in our case, you know We'll leave it as max, but now we get into changing what variables. Well, this is actually where cups sold needs to come into play obviously This is the variables that are gonna change and so I hit D5 But as soon as I hit D9 Notice this changed that becomes very annoying because well, I need all three of these guys So what can I do? Well, I can hold down the control key. I can click on D9 And you see that it now highlights both of them. I can click on D13 and It's gonna select all of them So now we get into our constraints. This is where these can come into play So subject to what constraints in our case, we're just gonna go ahead and hit add Now the part I want to focus in on is no longer this side, but these Things over here like I mentioned. I'm limited by the number of cups I can sell so total cups can only be 500 so in this case total cups can be less than or equal to 500 now, I know what you're thinking you're all well, you know We should probably sell as many as we possibly can but for our sake Now I'm gonna go ahead and hit add Because the next one I want to deal with is my max premiums. So all of a sudden premium cups I can only sell 350 premium cups same kind of thing comes in G7 is less than or equal to 350 I'm gonna hit add one more time And this time we're actually talking about max mocha. I only have enough material to make 125 mochas. So the same thing I'm gonna come in establish that I only have This is the Variable the cell that will be constrained by 125 I'm gonna hit okay now all of a sudden I've built out my constraints and We could go through this song and dance of selecting a solving method Luckily for ours, we'll go ahead and just leave it at GRG nonlinear But you can see we have different options that we can play with Now what I have to do is I basically hit solve And it's gonna go through and you can see I get this nice little oh it found a solution. I need to sell a hundred and fifty normal cups and 225 premium lattes and 125 Premium mocha. So again, that was my cap. I can only sell that many mochas So then it became this sort of song and dance And so all of a sudden I can see that I can list those out and my total revenue suddenly is $918.75