Exam 17: Spreadsheet Modeling: an Introduction

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

How can the following Linear Program be characterized? Min X + Y Subject to X ? 20 Y ? -5 X + Y ? 23

(Multiple Choice)
4.8/5
(32)

A feasible solution to an optimization problem is a particular combination of decision variables that satisfies some of the constraints.

(True/False)
4.8/5
(34)

The ________________________ for a constraint is the amount the optimal objective value will change if the right-hand-side of the constraint is increased by one unit.

(Multiple Choice)
4.8/5
(30)

For an optimization problem a(an)__________________ violates at least one of the constraints.

(Multiple Choice)
4.9/5
(32)

What does LP stand for?

(Multiple Choice)
4.9/5
(33)

Uhura Enterprises provides consulting services for customers. Consultants are brought in for two-hour shifts. A consultant will spend one full hour with a customer. The customers remain for that hour and then leaves. Each consultant is paid $25 per hour. Let Xi represent the number of consultants starting their shift at hour i, (i = 1,2,3,4). The firm wishes to minimize salary costs while satisfying demand. Customer demand is as follows. 1:00-2:00 4 2:00-3:00 5 3:00-4:00 10 4:00-5:00 4 5:00-6:00 8 Suppose that if consultants start shifts at both 1:00 and 2:00, then the firm will incur an additional fixed cost of $100 (for secretarial support). Let Y be a binary (0-1)variable that equals 1 if this event occurs, and 0 otherwise. Which of the following would "activate" Y variables.)

(Multiple Choice)
4.8/5
(33)

If C represents the number of chairs produced, which of the following is a proper non-negativity constraint?

(Multiple Choice)
4.8/5
(26)

The algebraic formulation of an optimization problem must state what three things?

(Multiple Choice)
4.9/5
(41)

Consider the following constraints from a two-variable Linear Program. (1)X ? 0 (2)Y ? 0 (3)X + Y ? 50 If constraints (2)and (3)are binding, what is the optimal solution (X, Y)?

(Multiple Choice)
4.9/5
(43)

What do you need to do before using Solver?

(Multiple Choice)
4.7/5
(40)

Which type of constraint does not allow the solution for a decision variable of an optimization problem to be less than zero?

(Multiple Choice)
4.7/5
(37)

A caterer must prepare from five fruit drinks in stock exactly 500 gallons of a punch containing at least 20% orange juice, 10% grapefruit juice, and 5% cranberry juice. If inventory data are as shown below, formulate a linear program that can be used to determine the optimal quantity of each fruit drink that the caterer should use to obtain the required composition at minimum total cost. A caterer must prepare from five fruit drinks in stock exactly 500 gallons of a punch containing at least 20% orange juice, 10% grapefruit juice, and 5% cranberry juice. If inventory data are as shown below, formulate a linear program that can be used to determine the optimal quantity of each fruit drink that the caterer should use to obtain the required composition at minimum total cost.

(Essay)
4.9/5
(33)

Explain what differentiates a Linear Program from a Nonlinear Program.

(Essay)
4.9/5
(49)

Constrained optimization models can be used to either ____________ or ___________ some quantity based on a set of constraints

(Short Answer)
4.9/5
(33)

Capital Co. is considering which of five different projects to undertake in order to maximize its net present value (NPV). Define Xi as a binary (0-1)variable that equals 1 if project i is undertaken and 0 otherwise, for i = 1,2,3,4,5. The NPV and required capital (in thousands)for each project are listed below. Capital Co. is considering which of five different projects to undertake in order to maximize its net present value (NPV). Define X<sub>i</sub> as a binary (0-1)variable that equals 1 if project i is undertaken and 0 otherwise, for i = 1,2,3,4,5. The NPV and required capital (in thousands)for each project are listed below.   What is the proper objective function? What is the proper objective function?

(Multiple Choice)
4.9/5
(48)

Describe the primary advantage of optimization modeling.

(Essay)
4.7/5
(26)

Describe guidelines for spreadsheet model development.

(Essay)
4.8/5
(38)

Uhura Enterprises provides consulting services for customers. Consultants are brought in for two-hour shifts. A consultant will spend one full hour with a customer. The customers remain for that hour and then leave. Each consultant is paid $25 per hour. Let Xi represent the number of consultants starting their shift at hour i, (i = 1,2,3,4). The firm wishes to minimize salary costs while satisfying demand. Customer demand is as follows. 1:00-2:00 4 2:00-3:00 5 3:00-4:00 10 4:00-5:00 4 5:00-6:00 8 What is the proper objective function?

(Multiple Choice)
4.8/5
(33)

A constraint in Excel Solver consists of what three pieces of information?

(Essay)
5.0/5
(36)

Consider the following three functions: g(x, y)= 4x - 3y + 21 H(x, y, z)= 13x2 + y + 3z I(z)= z Which of the following is true regarding the linearity of the functions?

(Multiple Choice)
4.7/5
(43)
Showing 21 - 40 of 133
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)