Linear programming with excel
Not what you're looking for?
Linear Programming Models in Excel (Solver)
TABLE: Hours for Judicial Problem
Jan 400 July 200
Feb 300 Aug 400
Mar 200 Sept 300
April 600 Oct 200
May 800 Nov 100
June 300 Dec 300
Suppose each judge works all 12 months and can handle up to 120 hours per month of casework. To avoid a backlog, all cases must be handled by the end of December. Determine how many judges are needed.
If each judge receives 1 month of vacation each year, how does your answer change?
Solve this problem using Excel Solver.
Purchase this Solution
Solution Summary
This shows how to use Excel to solve a problem regarding how many judges are needed.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts