Data Analysis Quiz

Assume that a company makes wooden picture frames. Frame style 1 takes 2 hours of skilled labor and 3 linear feet of wood. If the company had 40 hours of skilled labor and 48 linear feet of wood that can be used each week, what is the largest quantity of this item that the company will be able to produce given these resource constraints?

Question 1 options:

Save

Every linear programming problem involves optimizing a:

Question 2 options:

Save

Related to sensitivity analysis in linear programming, when the profit increases with a unit increase in a resource, this change in profit is referred to as the:

Question 3 options:

Save

Consider the following linear programming problem:   Maximize 5x1 + 5x2 Subject to x1 + 2x2 < 8 x1 + x2 < 6 x1, x2 > 0

What is the optimal objective function value?

Question 4 options:

Save

One of the things that can go wrong with a linear programming problem is that it may not be possible to find a set of points that satisfy all of the constraints in the problem. This type of problem is said to be:

Question 5 options:

Save

In using a spreadsheet to solve linear programming problems, the changing cells represent the:

Question 6 options:

Save

In using a spreadsheet to solve linear programming problems, the target cell represents the:

Question 7 options:

Save

In binary integer linear program, the integer variables take only the values:

Question 8 options:

Save

Binary variables are identified with the _____designation in the Solver Parameters dialog box.

Question 9 options:

Save

Questions 10 - 15 are based on the following information:

A farmer in Egypt owns 50 acres of land. He is going to plant each acre with cotton or corn. Each acre planted with cotton yields $400 profit; each with corn yields $200 profit. The labor and fertilizer used for each acre are given in the table below. Resources available include 150 workers and 200 tons of fertilizer.

Formulate a linear programming model that will enable the farmer to determine the number of acres that should be planted cotton and/or corn in order to maximize his profit.  Provide the objective function and constraints in the box below.  

X1 - number of acres planted cotton

X2 - number of acres planted corn

Hint: You will need three constraints.  

Question 10 options:

Save

What are the optimal decision variable values?

Question 11 options:

Save

What is the optimal objective function value?

Question 12 options:

Save

Which of the following constraints is binding?

Question 13 options:

Save

How much should the farmer be willing to pay for an additional worker?

Question 14 options:

Save

How much should the farmer be willing to pay for an additional ton of fertilizer?

Question 15 options:

Save

Questions 16 - 20 are based on the following information:

Dukedom Chemicals blends its private label orchard spray from four individual compounds. Management would like to make the blend at as low a cost as possible while maintaining the requirements for chemical structure. The linear programming problem has been formulated and the SOLVER solution to it is provided.  The objective function is to minimize the total cost.  The two constraints are formulated to meet the minimum requirements for chemicals 1 and 2. 

What is the total cost to make the blend?         

Question 16 options:

Save

How many units of compound 4 should we use?

Question 17 options:

Save

What would happen to the decision variables if the cost of compound 2 were $15?

Question 18 options:

Save

What would happen if 1 more unit of chemical 1 were required in constraint (1)?

Question 19 options:

Save

Which of the constraints is binding?

Question 20 options:

Save