Linear Programming Problem

This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems.

Linear Programming (30 Problems)

____ 14. Limited resources are modeled in optimization problems as C a. an objective function. b. constraints. c. decision variables. d. alternatives. ___A_ 15. The number of units to ship from Chicago to Memphis is an example of a(n) a. decision. b. constraint. c. objective. d. parameter. ___B_ 16. The desire to maximize profits is an example of a(n) a. decision. b. constraint. c. objective. d. parameter. ____ 18. The following linear programming problem has been written to plan the production of two products. The company wants to maximize its profits. X1 = number of product 1 produced in each batch X2 = number of product 2 produced in each batch MAX: 150 X1 + 250 ... click for more

Integer Linear Programming (ILP) : Formulation and Optimal Solution

Health Care Systems of Florida (HCSF) is planning to build a number of new emergency-care clinics in central Florida. HCSF management has divided a map of emergency-care clinics in central Florida. HCSF management has divided a map of the area into seven regions. They want to locate the emergency centers so that all seven regions will be conveniently served by at least one facility. Five possible sites are available for constructing the new facilities. The regions that can be served conveniently by each site are indicated in a table in the attached file. a. Formulate an ILP problem to determine which sites should be selected so as to provide convenient service to all locations in the... click for more

Formulate an ILP Problem

Radford Castings can produce brake shoes on six different machines. The following table summarizes the manufacturing costs associated with producing the brake shoes on each machine along with the available capacity on each machine. If the company has received an order for 1,800 brake shoes, how should it schedule these machines? See the table in the attached file. a. Formulate an ILP model for this problem. b. Create a spreadsheet model for this problem and solve it. c. What is the optimal solution?

Nonlinear Programming & Evolutionary Optimization

This is a problem #10, chapter 8 - Nonlinear Programming & Evolutionary Optimization, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis". This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems.