Exam 15: Integer Optimization

Use the table below to answer the following question(s)using the standard Solver. A company makes standard 130-inch-wide rolls of thin sheet metal and slits them into smaller rolls to meet customer orders for widths of 10, 14, and 25 inches.Suppose that the company has proposed the following cutting patterns: Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls.Answer the following questions using the standard Solver.Answer the following questions using the standard Solver. -What is the total number of 25-inch rolls produced?

If the Integer Tolerance is set to 0.01, the Solver will stop if it finds an integer solution that is within 10% of the optimal solution.

Use the table below to answer the following question(s)by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: -What is the total return obtained from all five projects?

Use the table below to answer the following question(s)by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: -What is the amount of cash used for Project 2?

Use the table below to answer the following question(s)using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: -What is the inventory at the end of the first quarter?

Use the table below to answer the following question(s)using the standard Solver. Coppell Services contracts with outsourcing partners to handle various customer service functions.Based on a study of call volumes provided by one of the firm's partners, the minimum number of staff needed for each hour of the day is as follows: Hour Minimum Staff Required 8-9 10 -10 12 10-11 10 11- noon 8 hoon-1 16 1-2 15 2-3 20 3-4 15 Mr.Coppell hires 6 permanent employees and wants to staff the remaining requirements using part-time employees who work 4-hour shifts (four consecutive hours starting as early as 8 A.M.or as late as 1 P.M.). -How many part-time employees are present in the 8-9 time slot?

Use the spreadsheet below for Stone Age Surfboards to answer the following question(s)using integer constraints on variables in the optimization models using the standard Solver. -What is the total number of hours used for the finishing operation?

Use the table below to answer the following question(s)by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: -What is the amount of personnel used for Project 2?

What should be the value of Integer Tolerance in order to find the guaranteed optimal integer solution?

Use the table below to answer the following question(s)using the standard Solver. Below is the spreadsheet for a plant location model: -Which of the following constraints is used in Solver?

Use the spreadsheet below for Stone Age Surfboards to answer the following question(s)using integer constraints on variables in the optimization models using the standard Solver. -What is the total profit generated?

Use the spreadsheet below for Stone Age Surfboards to answer the following question(s)using integer constraints on variables in the optimization models using the standard Solver. -What is the quantity of Lava surfboards produced?

Use the spreadsheet below for Stone Age Surfboards to answer the following question(s)using integer constraints on variables in the optimization models using the standard Solver. -What is the quantity of Graystone surfboards produced?

Use the table below to answer the following question(s)using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: -What is the binary constraint at the end of the third quarter?

Solver can generate a Sensitivity report for integer models.

Use the table below to answer the following question(s)using the standard Solver. A company makes standard 130-inch-wide rolls of thin sheet metal and slits them into smaller rolls to meet customer orders for widths of 10, 14, and 25 inches.Suppose that the company has proposed the following cutting patterns: Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls.Answer the following questions using the standard Solver.Answer the following questions using the standard Solver. -What is the total number of 10-inch rolls produced?

Mathematically, a binary variable x can be represented as x > 2 and integer.

Use the table below to answer the following question(s)using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: -Which of the following constraints is used in Solver?

Use the table below to answer the following question(s)by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: -What is the total amount of cash used for all five projects?

Use the table below to answer the following question(s)using the standard Solver. Below is the spreadsheet for a plant location model: -What is the total amount shipped by the Dallas plant to the distribution centers?