Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: \(\begin{array}{|l|l|l|l|l|l|l|} \hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \begin{array}{l} \text { Plant Location } \\ \text { Model } \end{array} & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\ \hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\ \hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\ \hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\ \hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\ \hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\ \hline 12 & \text { Model } \\ \hline 13 & \\ \hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\ \hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\ \hline 18 & \text { Detroit } \\ \hline 19 & \text { Baltimore } \\ \hline 20 & \text { Supply } \\ \hline 21 & \\ \hline 22 & \text { Total Cost } \\ \hline 23 & \$ 0.00 \\ \hline \end{array}\) -Which of the following constraints is used in Solver?

A) $F$16:$F$19 >= $F$6:$F$9 B) $B$20:$E$20 = $F$6:$F$9 B) $B$20:$E$20 < $B$10:$E$10 C) $B$20:$E$20 = binary D) $F$16:$F$19 <= $F$6:$F$9 D

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: $\begin{array}{|l|c|c|c|c|} \hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} \\ \hline 1 &{\text { Memphis Design Fixed Cost Model }} & & \\ \hline 2 & & & & \\\hline 3 & \text { Data } & \\ \hline 4 & & \\\hline 5 & \text { Cost } & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 6 & \text { Production } & \$ 10.00 & \$ 15.00 & \$ 13.50 \\ \hline 7 & \text { Inventory } & \$ 1.70 & \$ 1.70 & \$ 1.70 \\ \hline 8 & \text { Demand } & 200 & 450 & 75 \\ \hline 9 & \text { Fixed Cost } & \$ 75.00 & \$ 75.00 & \$ 75.00 \\\hline 10 & \\ \hline 11 & \text { Model } \\ \hline 12 & \\\hline 13 & & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 14 & \text { Production } & & & \\\hline 15 & \text { Inventory } \\ \hline 16 & \text { Binary } \\ \hline 17 & \\ \hline 18 & \text { Binary constraints } \\ \hline 19 & \text { Net Production } \\\hline 20 & & \\ \hline 21 & & \text { Cost } \\ \hline 22 & \text { Total } & \\ \hline \end{array}$ -What is the net production at the end of the second quarter?

A) 75 B) 200 C) 450 D) 600 A) 75 B) 200 C) 450 D) 600 C

Use a modern software tool to perform statistical calculations. 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: $\begin{array}{|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\ \hline 1 & \text { Cutting-Stock Problem } & & & & \\ \hline 2 & & & & & \\ \hline 3 & \text { Data } & & & & \\\hline 4 & \text { Pattern } & \text { 10-in rolls } & \text { 14 in. rolls } & \text { 25-in. rolls } & \text { Scrap } \\ \hline 5 & 1 & 0 & 8 & 0 & 10 \\ \hline 6 & 2 & 0 & 2 & 3 & 10 \\\hline 7 & 3 & 3 & 0 & 3 & 4 \\ \hline 8 & 4 & 10 & 0 & 0 & 10 \\ \hline 9 & 5 & 3 & 2 & 2 & 4 \\ \hline 10 & 6 & 8 & 2 & 0 & 4 \\ \hline \end{array}$ Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total scrap produced?

A) 1,389 B) 1,390 C) 1,427 D) 1,445 A) 1,389 B) 1,390 C) 1,427 D) 1,445 B

Use a modern software tool to perform statistical calculations. 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: $\begin{array}{|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\ \hline 1 & \text { Cutting-Stock Problem } & & & & \\ \hline 2 & & & & & \\ \hline 3 & \text { Data } & & & & \\\hline 4 & \text { Pattern } & \text { 10-in rolls } & \text { 14 in. rolls } & \text { 25-in. rolls } & \text { Scrap } \\ \hline 5 & 1 & 0 & 8 & 0 & 10 \\ \hline 6 & 2 & 0 & 2 & 3 & 10 \\\hline 7 & 3 & 3 & 0 & 3 & 4 \\ \hline 8 & 4 & 10 & 0 & 0 & 10 \\ \hline 9 & 5 & 3 & 2 & 2 & 4 \\ \hline 10 & 6 & 8 & 2 & 0 & 4 \\ \hline \end{array}$ Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total number of 14-inch rolls produced?

A) 721 B) 725 C) 728 D) 740 A) 721 B) 725 C) 728 D) 740

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: \(\begin{array}{|l|l|l|l|l|l|l|} \hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \begin{array}{l} \text { Plant Location } \\ \text { Model } \end{array} & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\ \hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\ \hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\ \hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\ \hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\ \hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\ \hline 12 & \text { Model } \\ \hline 13 & \\ \hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\ \hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\ \hline 18 & \text { Detroit } \\ \hline 19 & \text { Baltimore } \\ \hline 20 & \text { Supply } \\ \hline 21 & \\ \hline 22 & \text { Total Cost } \\ \hline 23 & \$ 0.00 \\ \hline \end{array}\) -What is the total amount shipped by the Detroit plant to the distribution centers?

A) 750 B) 1,000 C) 1,400 D) 1,300 A) 750 B) 1,000 C) 1,400 D) 1,300

Use a modern software tool to perform statistical calculations. 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: \[\begin{array} { | l | l | } \hline \text { Hour } & \text { Minimum Staff Required } \\ \hline 8 - 9 & 6 \\ \hline 9 - 10 & 10 \\ \hline 10 - 11 & 12 \\ \hline 11 \text {-noon } & 10 \\ \hline \text { noon-1 } & 8 \\ \hline 1 - 2 & 16 \\ \hline 2 - 3 & 15 \\ \hline 3 - 4 & 20 \\ \hline 4 - 5 & 15 \\ \hline \end{array}\] 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?

A) It is a general integer variable that is restricted to being between -1 and 1. B) It is a general integer variable that is restricted to being a multiple of 2. C) It is a general integer variable that is restricted to being between 0 and 1. D) It is a general integer variable that is restricted to being greater than 2. A) It is a general integer variable that is restricted to being between -1 and 1. B) It is a general integer variable that is restricted to being a multiple of 2. C) It is a general integer variable that is restricted to being between 0 and 1. D) It is a general integer variable that is restricted to being greater than 2.

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: \(\begin{array}{|l|l|l|l|l|l|l|} \hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \begin{array}{l} \text { Plant Location } \\ \text { Model } \end{array} & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\ \hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\ \hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\ \hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\ \hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\ \hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\ \hline 12 & \text { Model } \\ \hline 13 & \\ \hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\ \hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\ \hline 18 & \text { Detroit } \\ \hline 19 & \text { Baltimore } \\ \hline 20 & \text { Supply } \\ \hline 21 & \\ \hline 22 & \text { Total Cost } \\ \hline 23 & \$ 0.00 \\ \hline \end{array}\) -What is the total cost incurred?

A) $ 27,297 B) $ 35,233 C) $ 42,675 D) $ 47,864 A) $ 27,297 B) $ 35,233 C) $ 42,675 D) $ 47,864

Formulate and solve optimization models with binary variables and logical constraints. 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: \(\begin{array}{|l|l|l|l|l|l|l|l|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } & \text { G } \\ \hline & \text { Project Selection } & & & & & & \\ 1 & \text { Model } & & & & & & \\ \hline 2 & & & & & & & \\\hline 3 & \text { Data } & & & & & & \\ \hline 4 & & & & & & & \text { Available } \\ & & \text { Project 1 } & \text { Project 2 } & \text { Project 3 } & \text { Project 4 } & \text { Project 5 } & \text { Resources } \\\hline 5 & \begin{array}{l} \text { Expected Return } \\ (\mathrm{NPV}) \end{array} & \$ 160,000 & \$ 200,000 & \$ 125,000 & \$ 150,000 & \$ 225,000 \\\hline 6 & \begin{array}{l} \text { Cash } \\ \text { requirements } \end{array} & \$ 45,000 & \$ 70,000 & \$ 28,000 & \$ 52,000 & \$ 65,000 &\$175,000\\\hline 7 & \begin{array}{l} \text { Personnel } \\ \text { requirements } \end{array} & 7 & 4 & 2 & 6 & 4 & 10 \\ \hline 8 & & & & & & & \\\hline 9 & \text { Model } \\ \hline 10 & \\ \hline 11 & \begin{array}{l} \text { Project selection } \\ \text { decisions } \end{array} \\\hline 12 & \text { Cash Used } \\ \hline 13 & \text { Personnel Used } \\ \hline 14 & \text { Return } \\ \hline \end{array}\) -What is the total amount of cash used for all five projects?

A) $ 175,000 B) $ 163,000 C) $ 215,000 D) $ 260,000 A) $ 175,000 B) $ 163,000 C) $ 215,000 D) $ 260,000

Use a modern software tool to perform statistical calculations. 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: \[\begin{array} { | l | l | } \hline \text { Hour } & \text { Minimum Staff Required } \\ \hline 8 - 9 & 6 \\ \hline 9 - 10 & 10 \\ \hline 10 - 11 & 12 \\ \hline 11 \text {-noon } & 10 \\ \hline \text { noon-1 } & 8 \\ \hline 1 - 2 & 16 \\ \hline 2 - 3 & 15 \\ \hline 3 - 4 & 20 \\ \hline 4 - 5 & 15 \\ \hline \end{array}\] 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 total part-time employees needed across all the 4-hour shifts to ensure meeting the staffing requirements?

A) 16 B) 28 C) 24 D) 20 A) 16 B) 28 C) 24 D) 20

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: \(\begin{array}{|l|l|l|l|l|l|l|} \hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \begin{array}{l} \text { Plant Location } \\ \text { Model } \end{array} & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\ \hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\ \hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\ \hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\ \hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\ \hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\ \hline 12 & \text { Model } \\ \hline 13 & \\ \hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\ \hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\ \hline 18 & \text { Detroit } \\ \hline 19 & \text { Baltimore } \\ \hline 20 & \text { Supply } \\ \hline 21 & \\ \hline 22 & \text { Total Cost } \\ \hline 23 & \$ 0.00 \\ \hline \end{array}\) -What is the total amount shipped by the Atlanta plant to the distribution centers?

A) 600 B) 1,000 C) 1,250 D) 1,300 A) 600 B) 1,000 C) 1,250 D) 1,300

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: $\begin{array}{|l|c|c|c|c|} \hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} \\ \hline 1 &{\text { Memphis Design Fixed Cost Model }} & & \\ \hline 2 & & & & \\\hline 3 & \text { Data } & \\ \hline 4 & & \\\hline 5 & \text { Cost } & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 6 & \text { Production } & \$ 10.00 & \$ 15.00 & \$ 13.50 \\ \hline 7 & \text { Inventory } & \$ 1.70 & \$ 1.70 & \$ 1.70 \\ \hline 8 & \text { Demand } & 200 & 450 & 75 \\ \hline 9 & \text { Fixed Cost } & \$ 75.00 & \$ 75.00 & \$ 75.00 \\\hline 10 & \\ \hline 11 & \text { Model } \\ \hline 12 & \\\hline 13 & & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 14 & \text { Production } & & & \\\hline 15 & \text { Inventory } \\ \hline 16 & \text { Binary } \\ \hline 17 & \\ \hline 18 & \text { Binary constraints } \\ \hline 19 & \text { Net Production } \\\hline 20 & & \\ \hline 21 & & \text { Cost } \\ \hline 22 & \text { Total } & \\ \hline \end{array}$ -What is the net production at the end of the third quarter?

A) 75 B) 200 C) 450 D) 600 A) 75 B) 200 C) 450 D) 600

Formulate and solve optimization models with binary variables and logical constraints. 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: \(\begin{array}{|l|l|l|l|l|l|l|l|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } & \text { G } \\ \hline & \text { Project Selection } & & & & & & \\ 1 & \text { Model } & & & & & & \\ \hline 2 & & & & & & & \\\hline 3 & \text { Data } & & & & & & \\ \hline 4 & & & & & & & \text { Available } \\ & & \text { Project 1 } & \text { Project 2 } & \text { Project 3 } & \text { Project 4 } & \text { Project 5 } & \text { Resources } \\\hline 5 & \begin{array}{l} \text { Expected Return } \\ (\mathrm{NPV}) \end{array} & \$ 160,000 & \$ 200,000 & \$ 125,000 & \$ 150,000 & \$ 225,000 \\\hline 6 & \begin{array}{l} \text { Cash } \\ \text { requirements } \end{array} & \$ 45,000 & \$ 70,000 & \$ 28,000 & \$ 52,000 & \$ 65,000 &\$175,000\\\hline 7 & \begin{array}{l} \text { Personnel } \\ \text { requirements } \end{array} & 7 & 4 & 2 & 6 & 4 & 10 \\ \hline 8 & & & & & & & \\\hline 9 & \text { Model } \\ \hline 10 & \\ \hline 11 & \begin{array}{l} \text { Project selection } \\ \text { decisions } \end{array} \\\hline 12 & \text { Cash Used } \\ \hline 13 & \text { Personnel Used } \\ \hline 14 & \text { Return } \\ \hline \end{array}\) -What is the amount of personnel used for Project 2?

A) 3 B) 4 C) 6 D) 11 A) 3 B) 4 C) 6 D) 11

Use a modern software tool to perform statistical calculations. 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: $\begin{array}{|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\ \hline 1 & \text { Cutting-Stock Problem } & & & & \\ \hline 2 & & & & & \\ \hline 3 & \text { Data } & & & & \\\hline 4 & \text { Pattern } & \text { 10-in rolls } & \text { 14 in. rolls } & \text { 25-in. rolls } & \text { Scrap } \\ \hline 5 & 1 & 0 & 8 & 0 & 10 \\ \hline 6 & 2 & 0 & 2 & 3 & 10 \\\hline 7 & 3 & 3 & 0 & 3 & 4 \\ \hline 8 & 4 & 10 & 0 & 0 & 10 \\ \hline 9 & 5 & 3 & 2 & 2 & 4 \\ \hline 10 & 6 & 8 & 2 & 0 & 4 \\ \hline \end{array}$ Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total number of 10-inch rolls produced?

A) 940 B) 946 C) 950 D) 960 A) 940 B) 946 C) 950 D) 960

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: \(\begin{array}{|l|l|l|l|l|l|l|} \hline &{\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \begin{array}{l} \text { Plant Location } \\ \text { Model } \end{array} & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & \text { Data } & & & & & \\\hline4&&&\text { Distribution Center }\\\hline 5 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jacksonville } & \text { Memphis } & \text { Capacity } \\ \hline 6 & \text { Dallas } & \$ 11.80 & \$ 16.48 & \$ 12.35 & \$ 18.56 & 1,300 \\ \hline 7 & \text { Atlanta } & \$ 8.54 & \$ 14.65 & \$ 9.58 & \$ 18.25 & 750 \\ \hline 8 & \text { Detroit } & \$ 12.89 & \$ 10.78 & \$ 7.85 & \$ 10.28 & 1,400 \\ \hline 9 & \text { Baltimore } & \$ 14.36 & \$ 18.95 & \$ 14.61 & \$ 6.64 & 1,300 \\ \hline 10 & \text { Demand } & 350 & 450 & 800 & 1,700 & \\\hline 11 & \\ \hline 12 & \text { Model } \\ \hline 13 & \\ \hline 14 & \text { Amount Shipped }&&\text { Distribution Center } \\\hline 15 & \text { Plant } & \text { Houston } & \text { San Jose } & \text { Jack sonville } & \text { Memphis } & \text { Total Shipped } \\ \hline 16 & \text { Dallas } & & & & & \\\hline 17 & \text { Atlanta } \\ \hline 18 & \text { Detroit } \\ \hline 19 & \text { Baltimore } \\ \hline 20 & \text { Supply } \\ \hline 21 & \\ \hline 22 & \text { Total Cost } \\ \hline 23 & \$ 0.00 \\ \hline \end{array}\) -In which of the following plants is the total amount shipped to the distribution centers equal to zero?

A) Dallas B) Atlanta C) Detroit D) Baltimore A) Dallas B) Atlanta C) Detroit D) Baltimore

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: $\begin{array}{|l|c|c|c|c|} \hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} \\ \hline 1 &{\text { Memphis Design Fixed Cost Model }} & & \\ \hline 2 & & & & \\\hline 3 & \text { Data } & \\ \hline 4 & & \\\hline 5 & \text { Cost } & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 6 & \text { Production } & \$ 10.00 & \$ 15.00 & \$ 13.50 \\ \hline 7 & \text { Inventory } & \$ 1.70 & \$ 1.70 & \$ 1.70 \\ \hline 8 & \text { Demand } & 200 & 450 & 75 \\ \hline 9 & \text { Fixed Cost } & \$ 75.00 & \$ 75.00 & \$ 75.00 \\\hline 10 & \\ \hline 11 & \text { Model } \\ \hline 12 & \\\hline 13 & & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\ \hline 14 & \text { Production } & & & \\\hline 15 & \text { Inventory } \\ \hline 16 & \text { Binary } \\ \hline 17 & \\ \hline 18 & \text { Binary constraints } \\ \hline 19 & \text { Net Production } \\\hline 20 & & \\ \hline 21 & & \text { Cost } \\ \hline 22 & \text { Total } & \\ \hline \end{array}$ -What is the inventory at the end of the first quarter?

A) 725 B) 525 C) 50 D) 75 A) 725 B) 525 C) 50 D) 75

Exam 15: Integer Optimization

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: A B C D E F 1 Plant Location Model 2 3 Data 4 Distribution Center 5 Plant Houston San Jose Jacksonville Memphis Capacity 6 Dallas \ 11.80 \ 16.48 \ 12.35 \ 18.56 1,300 7 Atlanta \ 8.54 \ 14.65 \ 9.58 \ 18.25 750 8 Detroit \ 12.89 \ 10.78 \ 7.85 \ 10.28 1,400 9 Baltimore \ 14.36 \ 18.95 \ 14.61 \ 6.64 1,300 10 Demand 350 450 800 1,700 11 12 Model 13 14 Amount Shipped Distribution Center 15 Plant Houston San Jose Jack sonville Memphis Total Shipped 16 Dallas 17 Atlanta 18 Detroit 19 Baltimore 20 Supply 21 22 Total Cost 23 \ 0.00 -Which of the following constraints is used in Solver?

Free

(Multiple Choice)

4.8/5

(32)

Question 1

Correct Answer:

Verified

D

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: 1 Memphis Design Fixed Cost Model 2 3 Data 4 5 Cost Quarter 1 Quarter 2 Quarter 3 6 Production \ 10.00 \ 15.00 \ 13.50 7 Inventory \ 1.70 \ 1.70 \ 1.70 8 Demand 200 450 75 9 Fixed Cost \ 75.00 \ 75.00 \ 75.00 10 11 Model 12 13 Quarter 1 Quarter 2 Quarter 3 14 Production 15 Inventory 16 Binary 17 18 Binary constraints 19 Net Production 20 21 Cost 22 Total -What is the net production at the end of the second quarter?

Free

(Multiple Choice)

5.0/5

(35)

Question 2

Correct Answer:

Verified

C

Use a modern software tool to perform statistical calculations. 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: A B C D E 1 Cutting-Stock Problem 2 3 Data 4 Pattern 10-in rolls 14 in. rolls 25-in. rolls Scrap 5 1 0 8 0 10 6 2 0 2 3 10 7 3 3 0 3 4 8 4 10 0 0 10 9 5 3 2 2 4 10 6 8 2 0 4 Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total scrap produced?

Free

(Multiple Choice)

5.0/5

(42)

Question 3

Correct Answer:

Verified

B

Decision variables that are forced to be integers are called general integer variables.

(True/False)

4.8/5

(34)

Question 4

Use a modern software tool to perform statistical calculations. 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: A B C D E 1 Cutting-Stock Problem 2 3 Data 4 Pattern 10-in rolls 14 in. rolls 25-in. rolls Scrap 5 1 0 8 0 10 6 2 0 2 3 10 7 3 3 0 3 4 8 4 10 0 0 10 9 5 3 2 2 4 10 6 8 2 0 4 Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total number of 14-inch rolls produced?

(Multiple Choice)

4.8/5

(31)

Question 5

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: A B C D E F 1 Plant Location Model 2 3 Data 4 Distribution Center 5 Plant Houston San Jose Jacksonville Memphis Capacity 6 Dallas \ 11.80 \ 16.48 \ 12.35 \ 18.56 1,300 7 Atlanta \ 8.54 \ 14.65 \ 9.58 \ 18.25 750 8 Detroit \ 12.89 \ 10.78 \ 7.85 \ 10.28 1,400 9 Baltimore \ 14.36 \ 18.95 \ 14.61 \ 6.64 1,300 10 Demand 350 450 800 1,700 11 12 Model 13 14 Amount Shipped Distribution Center 15 Plant Houston San Jose Jack sonville Memphis Total Shipped 16 Dallas 17 Atlanta 18 Detroit 19 Baltimore 20 Supply 21 22 Total Cost 23 \ 0.00 -What is the total amount shipped by the Detroit plant to the distribution centers?

(Multiple Choice)

4.9/5

(35)

Question 6

Use a modern software tool to perform statistical calculations. 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 6 9-10 10 10-11 12 11 -noon 10 noon-1 8 1-2 16 2-3 15 3-4 20 4-5 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?

(Multiple Choice)

4.8/5

(29)

Question 7

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

(Multiple Choice)

4.8/5

(37)

Question 8

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: A B C D E F 1 Plant Location Model 2 3 Data 4 Distribution Center 5 Plant Houston San Jose Jacksonville Memphis Capacity 6 Dallas \ 11.80 \ 16.48 \ 12.35 \ 18.56 1,300 7 Atlanta \ 8.54 \ 14.65 \ 9.58 \ 18.25 750 8 Detroit \ 12.89 \ 10.78 \ 7.85 \ 10.28 1,400 9 Baltimore \ 14.36 \ 18.95 \ 14.61 \ 6.64 1,300 10 Demand 350 450 800 1,700 11 12 Model 13 14 Amount Shipped Distribution Center 15 Plant Houston San Jose Jack sonville Memphis Total Shipped 16 Dallas 17 Atlanta 18 Detroit 19 Baltimore 20 Supply 21 22 Total Cost 23 \ 0.00 -What is the total cost incurred?

(Multiple Choice)

4.8/5

(31)

Question 9

Formulate and solve optimization models with binary variables and logical constraints. 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: A B C D E F G Project Selection 1 Model 2 3 Data 4 Available Project 1 Project 2 Project 3 Project 4 Project 5 Resources 5 Expected Return () \ 160,000 \ 200,000 \ 125,000 \ 150,000 \ 225,000 6 Cash requirements \ 45,000 \ 70,000 \ 28,000 \ 52,000 \ 65,000 \1 75,000 7 Personnel requirements 7 4 2 6 4 10 8 9 Model 10 11 Project selection decisions 12 Cash Used 13 Personnel Used 14 Return -What is the total amount of cash used for all five projects?

(Multiple Choice)

4.8/5

(36)

Question 10

Use a modern software tool to perform statistical calculations. 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 6 9-10 10 10-11 12 11 -noon 10 noon-1 8 1-2 16 2-3 15 3-4 20 4-5 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 total part-time employees needed across all the 4-hour shifts to ensure meeting the staffing requirements?

(Multiple Choice)

4.8/5

(32)

Question 11

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: A B C D E F 1 Plant Location Model 2 3 Data 4 Distribution Center 5 Plant Houston San Jose Jacksonville Memphis Capacity 6 Dallas \ 11.80 \ 16.48 \ 12.35 \ 18.56 1,300 7 Atlanta \ 8.54 \ 14.65 \ 9.58 \ 18.25 750 8 Detroit \ 12.89 \ 10.78 \ 7.85 \ 10.28 1,400 9 Baltimore \ 14.36 \ 18.95 \ 14.61 \ 6.64 1,300 10 Demand 350 450 800 1,700 11 12 Model 13 14 Amount Shipped Distribution Center 15 Plant Houston San Jose Jack sonville Memphis Total Shipped 16 Dallas 17 Atlanta 18 Detroit 19 Baltimore 20 Supply 21 22 Total Cost 23 \ 0.00 -What is the total amount shipped by the Atlanta plant to the distribution centers?

(Multiple Choice)

4.8/5

(30)

Question 12

Solver can generate a Sensitivity report for integer models.

(True/False)

4.8/5

(43)

Question 13

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

(Essay)

4.9/5

(36)

Question 14

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: 1 Memphis Design Fixed Cost Model 2 3 Data 4 5 Cost Quarter 1 Quarter 2 Quarter 3 6 Production \ 10.00 \ 15.00 \ 13.50 7 Inventory \ 1.70 \ 1.70 \ 1.70 8 Demand 200 450 75 9 Fixed Cost \ 75.00 \ 75.00 \ 75.00 10 11 Model 12 13 Quarter 1 Quarter 2 Quarter 3 14 Production 15 Inventory 16 Binary 17 18 Binary constraints 19 Net Production 20 21 Cost 22 Total -What is the net production at the end of the third quarter?

(Multiple Choice)

4.8/5

(36)

Question 15

Formulate and solve optimization models with binary variables and logical constraints. 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: A B C D E F G Project Selection 1 Model 2 3 Data 4 Available Project 1 Project 2 Project 3 Project 4 Project 5 Resources 5 Expected Return () \ 160,000 \ 200,000 \ 125,000 \ 150,000 \ 225,000 6 Cash requirements \ 45,000 \ 70,000 \ 28,000 \ 52,000 \ 65,000 \1 75,000 7 Personnel requirements 7 4 2 6 4 10 8 9 Model 10 11 Project selection decisions 12 Cash Used 13 Personnel Used 14 Return -What is the amount of personnel used for Project 2?

(Multiple Choice)

4.8/5

(45)

Question 16

Explain the implementation of a project-selection model.

(Essay)

4.7/5

(38)

Question 17

Use a modern software tool to perform statistical calculations. 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: A B C D E 1 Cutting-Stock Problem 2 3 Data 4 Pattern 10-in rolls 14 in. rolls 25-in. rolls Scrap 5 1 0 8 0 10 6 2 0 2 3 10 7 3 3 0 3 4 8 4 10 0 0 10 9 5 3 2 2 4 10 6 8 2 0 4 Demands for the coming week are 950 10-inch rolls, 725 14-inch roles, and 640 25-inch rolls. Develop a model using the Analytic Solver Platform that will determine how many 130-inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap. -What is the total number of 10-inch rolls produced?

(Multiple Choice)

4.8/5

(30)

Question 18

Formulate and solve optimization models with binary variables and logical constraints. LO2: Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for a plant location model: A B C D E F 1 Plant Location Model 2 3 Data 4 Distribution Center 5 Plant Houston San Jose Jacksonville Memphis Capacity 6 Dallas \ 11.80 \ 16.48 \ 12.35 \ 18.56 1,300 7 Atlanta \ 8.54 \ 14.65 \ 9.58 \ 18.25 750 8 Detroit \ 12.89 \ 10.78 \ 7.85 \ 10.28 1,400 9 Baltimore \ 14.36 \ 18.95 \ 14.61 \ 6.64 1,300 10 Demand 350 450 800 1,700 11 12 Model 13 14 Amount Shipped Distribution Center 15 Plant Houston San Jose Jack sonville Memphis Total Shipped 16 Dallas 17 Atlanta 18 Detroit 19 Baltimore 20 Supply 21 22 Total Cost 23 \ 0.00 -In which of the following plants is the total amount shipped to the distribution centers equal to zero?

(Multiple Choice)

4.8/5

(36)

Question 19

Use a modern software tool to perform statistical calculations. Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: 1 Memphis Design Fixed Cost Model 2 3 Data 4 5 Cost Quarter 1 Quarter 2 Quarter 3 6 Production \ 10.00 \ 15.00 \ 13.50 7 Inventory \ 1.70 \ 1.70 \ 1.70 8 Demand 200 450 75 9 Fixed Cost \ 75.00 \ 75.00 \ 75.00 10 11 Model 12 13 Quarter 1 Quarter 2 Quarter 3 14 Production 15 Inventory 16 Binary 17 18 Binary constraints 19 Net Production 20 21 Cost 22 Total -What is the inventory at the end of the first quarter?

(Multiple Choice)

4.8/5

(32)

Question 20

Decision variables that are forced to be integers are called general integer variables.

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

Solver can generate a Sensitivity report for integer models.

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

Explain the implementation of a project-selection model.

Business Analytics

Analytics on Spreadsheets

Visualizing and Exploring Data

Descriptive Statistical Measures

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Trendlines and Regression Analysis

Forecasting Techniques

Introduction to Data Mining

Spreadsheet Modeling and Analysis

Monte Carlo Simulation and Risk Analysis

Linear Optimization

Applications of Linear Optimization

Decision Analysis

Filters