Exam 15: Integer Optimization

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 net production at the end of the second quarter?

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 Atlanta plant to the distribution centers?

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.). -What is the minimum number of part-time employees needed for each 4-hour shift to ensure meeting the staffing requirements?

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 scrap 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 total cost incurred by the company?

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 5?

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: -Which of the following cells is set as the objective cell in Solver?

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 3-4 time slot?

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 cost incurred?

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 net production 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.). -Which of the following best defines a binary variable?

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 net production at the end of the third quarter?

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 fabrication?

What is the purpose of a heat map?

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. -Which of the following constraints is used in Solver?

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 Baltimore plant to the distribution centers?

What is the importance of binary variables in integer optimization models?

Explain the method of solving models with general integer variables.

To invoke the binary constraints on the variables, the option bin is chosen from the dropdown box in the Add Constraint dialog.

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 return obtained from Project 3?