Exam 17: Spreadsheet Modeling: an Introduction
Exam 1: Introduction to Operations Management132 Questions
Exam 2: Operations Strategy and Competitiveness135 Questions
Exam 3: Product Design and Process Selection128 Questions
Exam 4: E-Commerce and Supply Chain Management139 Questions
Exam 5: Total Quality Management141 Questions
Exam 6: Statistical Quality Control136 Questions
Exam 7: Just-In-Time and Lean Systems137 Questions
Exam 8: Forecasting138 Questions
Exam 9: Capacity Planning and Facility Location139 Questions
Exam 10: Facility Layout139 Questions
Exam 11: Work System Design132 Questions
Exam 12: Independent Demand Inventory Management137 Questions
Exam 13: Aggregate Planning104 Questions
Exam 14: Resource Planning133 Questions
Exam 15: Scheduling127 Questions
Exam 16: Project Management134 Questions
Exam 16: Spreadsheet Modeling: an Introduction137 Questions
Exam 17: Spreadsheet Modeling: an Introduction133 Questions
Exam 18: Waiting Line Models132 Questions
Exam 19: Master Scheduling and Rough-Cut Capacity Planning69 Questions
Select questions type
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)
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)
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.


(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.
What is the proper objective function?

(Multiple Choice)
4.9/5
(48)
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
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)