## Business Analytics Study Set 2

Statistics

## Quiz 14 :

Integer and Nonlinear Optimization Models

Looking for Business Statistics & Analytics Homework Help?

Q03 Q03 Q03

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-3) Which of the following constraints does Solver use?

Free

Unlocked

Multiple Choice

A

Q04 Q04 Q04

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-4) What is the quantity of Graystone surfboards produced?

Free

Unlocked

Multiple Choice

Q05 Q05 Q05

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-5) What is the quantity of Lava surfboards produced?

Free

Unlocked

Multiple Choice

Q06 Q06 Q06

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-6) What is the total number of hours used for fabrication?

Free

Unlocked

Multiple Choice

Q07 Q07 Q07

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-7) What is the total number of hours used for the finishing operation?

Free

Unlocked

Multiple Choice

Q08 Q08 Q08

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom works
9.25 hours per day. The finishing department has 5 workers, each of whom works a 6-hour shift per day. Each pair of Graystone surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the Graystone model and $60 on the Lava model. The company anticipates selling at least twice as many Lava models as Graystone models.
Use the spreadsheet below for Stone Age Surfboards to answer the following questions) using integer constraints on variables in the optimization models using the standard Solver.
-8) What is the total profit generated?

Free

Unlocked

Multiple Choice

Q09 Q09 Q09

Use the table below to answer the following questions) 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. 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.
-9) What is the total number of 10-inch rolls produced?

Free

Unlocked

Multiple Choice

Q10 Q10 Q10

Use the table below to answer the following questions) 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. 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.
-10) What is the total number of 14-inch rolls produced?

Free

Unlocked

Multiple Choice

Q11 Q11 Q11

Use the table below to answer the following questions) 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. 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.
-11) What is the total number of 25-inch rolls produced?

Free

Unlocked

Multiple Choice

Q12 Q12 Q12

Use the table below to answer the following questions) 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. 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.
-12) What is the total scrap produced?

Free

Unlocked

Multiple Choice

Q13 Q13 Q13

Use the table below to answer the following questions) 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: 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.).
-13) How many part-time employees are present in the 8-9 time slot?

Free

Unlocked

Multiple Choice

Q14 Q14 Q14

Use the table below to answer the following questions) 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: 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.).
-14) How many excess employees are present in the noon-1 time slot?

Free

Unlocked

Multiple Choice

Q15 Q15 Q15

Use the table below to answer the following questions) 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: 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.).
-15) How many part-time employees are present in the 3-4 time slot?

Free

Unlocked

Multiple Choice

Q16 Q16 Q16

Use the table below to answer the following questions) 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: 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.).
-16) How many excess employees are present in the 4-5 time slot?

Free

Unlocked

Multiple Choice

Q17 Q17 Q17

Use the table below to answer the following questions) 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: 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.).
-17) What is the minimum number of total part-time employees needed across all the 4-hour shifts to ensure meeting the staffing requirements?

Free

Unlocked

Multiple Choice

Q18 Q18 Q18

Use the table below to answer the following questions) 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: 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.).
-18) Which of the following best defines a binary variable?

Free

Unlocked

Multiple Choice

Q19 Q19 Q19

Use the table below to answer the following questions) by invoking the binary constraints on the variables using the standard Solver.
Below is the spreadsheet for a project selection model:
-19) Which of the following cells is set as the objective cell in Solver?

Free

Unlocked

Multiple Choice