Excel Solver & Goal Seek Tutorial 

My CIS 112 class had me to watch this video but I ended up fell in love with your RU-vid channel thank so much for your shares

Can you suggest how to make solver run for all the rows using loop?

👏🏻👏🏻👏🏻

Getting an intuitive understanding of how changes impact complex calculations is very difficult in practice. This would make a great video.

Affflack

Correct: 200 variables and 100 constraints. After that you’ll have to pay up. Optimisation Solvers are big business!

Are there any "PREMIUM" Solver version? If yes, where find???

I hope you found a solution already, if not try these steps hope it helps. To solve your requirement using Solver in Microsoft Excel. Here's how you can do it: 1. Enter the data for the 41 stores in columns A, B, and C. 2. In column D, calculate the traffic per FTE for each store by dividing the traffic by the FTE budget. 3. In column E, create a binary variable for each store, where a value of 1 indicates that the store's traffic per FTE is greater than 900, and a value of 0 indicates that it is less than or equal to 900. 4. In another cell, calculate the total budget by summing the FTE budget for all stores. 5. In yet another cell, calculate the total number of stores that exceed the 900 traffic per FTE threshold. 6. Select the Solver add-in in Excel and set up the Solver Parameters as follows: Set the Set Objective cell to the cell that calculates the total number of stores exceeding the threshold. Set the To Value to 0, as you want all stores to have traffic per FTE less than or equal to 900. Set the By Changing cells to the range of FTE budget cells for all stores. Select the GRG Nonlinear method as the Solving Method. Check the box for "Assume Linear Model." Check the box for "Assume Non-Negative." Check the box for "Use Derivatives for Gradients." 7. Click the Solve button to run the Solver. 8. The Solver will adjust the FTE budget for each store to minimize the number of stores exceeding the 900 traffic per FTE threshold, while keeping the total budget equal to 400. The result will be a new set of FTE budgets that optimizes traffic per FTE.

and btw, it was a greattttt video.thank you

what did I just read.

can you give example for non linear variable that similar to this case sir? :)

I like eating them the most 😁