Okay, now that you have the solver application activated, let’s go ahead and see how it works. As I mentioned before from the data tab, we go over to the analysis section and choose solver. And it pops up with the dialogue box that you see here. Now what we are going to attempt to do is first of all set our objective and our objective in this situation is the total we want instead of being a million sixty eight units or dollars whatever that amount happens to be. We’ll go ahead and say that we wanted to actually have that a specific value of, in this case I have 1 million dollars or 1 million units whatever the case is, by changing what? By changing the cells that are from January through June for the Americas, Europe, Africa, and Asia. Now in this middle section it gives me an opportunity to set a bunch of constraints. For example, I can say, but I don’t want Asia to be over for January 50,000 units. Okay? So I could set some constraints, but we’ll leave it blank right now. We’ll look at that in more detail later. It also, down at the bottom, gives me some different options. I can use GRG nonlinear and down at the bottom it gives me some suggestions or some descriptions of what those might be. I can choose the simplex method or the evolutionary method. Okay, so let’s go ahead and change the, or select the GRG method for right now and I’ll go ahead and say solve. And you’ll notice that all of the values have now changed to give me very close to and we’ll use the term dollars, one million dollars here. Okay, and it’s changed all the values associated with my different values for January through June Americas through Asia. And it gives some options if I want to keep the solver solution or restore the original values and or return to solver parameters dialogue, which I want to in this case.
Okay, so we go back to our original values. Let me let you see what this simplex is, ILP method is. Now as you can imagine because it has the term simple in it. It’s gonna try the simplest solution first. And I’ll go ahead and solve for the simplex method. And notice what it’s done. It said, well gee, the simplest way to do that is just set one value to a million and I’m done. All right, let’s go ahead and restore to our original values and let’s try and choose the evolutionary method and I’ll say solve. Now in this situation, it said, hey, I’ve got a problem because all variables must have both upper and lower bounds, so let’s go ahead and restore original values and return to the solver and that situation I would have had to have implemented a whole bunch of constraints for each of the values. So in this situation I’ll go back to the, I’m sorry the GRG nonlinear and choose solve. Okay? Now in this situation if I go ahead click keep solver solutions, okay at this point in time, what it’s going to do is I will have lost all of my original values. So what I want to do initially here is go ahead and save this scenario so I’ll go ahead and save this scenario and call it my solver solution, okay, click okay on that and now I’m going to say, restore original values and go ahead and click okay. And at this point in time, let’s close at this point in time. I’m back to my original value and now I probably want to go in and do what? That’s right, create a scenario or what I have right here.[End of Audio]