Purchase Solution

# Linear Programming Using Excel Solver

Not what you're looking for?

I need the following two attached problems done in excel using the built in excel solver. For these problems we need to formulate our own constraints. For some reason I am getting negative numbers, which is obviously not right. I would appreciate it if someone could formulate the right constraints and solve these problems 100% correctly using excel.

Please see the attached file for the fully formatted problems.

1. On your construction site next week's work schedule requires the number of laborers per day show in the table below. Each laborer receives \$800 per week. A labor requirement must be met that employees work a five consecutive day work week followed by two days off. Allowable shifts are Monday through Friday, Tuesday through Saturday, Wednesday through Sunday, etc. The objective is to cover labor needs with five shifts at a minimum weekly payroll. Formulate this problem in a linear programming format. Determine the dollar value of the minimum program using two of the methods discussed in class.
Day: Mon Tue Wed Thur Fri Sat Sun
Workers: 180 160 150 160 190 140 120
3. The graph below represents possible freeway routes from a city A to an airport F. Each segment of the graph has its carrying capacity indicated in cars per minute. Determine the total capacity (maximum) between A and E of the freeway system (assume only flow in one direction). Note that the rate of flow along each freeway section has to be determined in order to obtain maximum capacity. This is important to regulate traffic during peak hours. Use linear programming.

##### Solution Summary

Linear programming using Excel Solvers are determined. The constraint formulates are analyzed.

Solution provided by:
###### Education
• BE, Bangalore University, India
###### Recent Feedback
• "What does 1 and 0 means in the repair column?"
• "Went through all of the formulas, excellent work! This really helped me!"
• "try others as well please"
• "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."

##### Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

##### Probability Quiz

Some questions on probability