Question 1

Diet and feed mix problems are special classes of the general product mix problem.

Accepted Answer

A) True 
 B)False  False

Question 2

Use this information to answer the following questions.
A beer distributor wants to prepare an aggregate plan for the next 6 weeks.Demand can be met using regular time production,overtime production,or a combination of both as illustrated below:
  
-Refer to the table above.Assume that beginning inventory is zero.Use Excel to formulate and solve this multiperiod production problem to minimize total costs.

Accepted Answer

The answer of Use this information to answer the following...

Question 3

Use this information to answer the following questions.
Consider the following product mix problem and its associated spreadsheet model.
 $$\begin{array} { l l l } 
\operatorname { Max } & 3 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } & \
\text { Subject to: } & \
& 2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 10 & \text { (constraint \#1) } \
& 3 \mathrm { X } _ { 1 } + 2 \mathrm { X } _ { 2 } \leq 20 & \text { (constraint \#2) } \
&\mathrm { X } _ { 1 } \geq 5 & \text { (constraint \#3) } \
&\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0 & \text { (non-negativity) }
\end{array}$$ 
  
-Refer to the spreadsheet above.Which cell(s)designates the objective function as specified in "Solver"?

Accepted Answer

A) E4 
B) D3 
C) D2 
D) B1:C1 
E) B2:C2 
A) E4 
B) D3 
C) D2 
D) B1:C1 
E) B2:C2 B

Question 4

In a multi-period production scheduling application,the decision variables typically designate:

Accepted Answer

A) the number of units to produce in a given period 
B) minimizing inventory and production costs 
C) the number of units held in inventory in a given period 
D) the number of inventory units to produce in a given period 
E) number of units to produce in a given period,along with the number of units to hold in inventory at the end of each period 
A) the number of units to produce in a given period 
B) minimizing inventory and production costs 
C) the number of units held in inventory in a given period 
D) the number of inventory units to produce in a given period 
E) number of units to produce in a given period,along with the number of units to hold in inventory at the end of each period

Question 5

Use this information to answer the following questions.
Consider the following product mix problem and its associated spreadsheet model.
 $$\begin{array} { l l l } 
\operatorname { Max } & 3 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } & \
\text { Subject to: } & \
& 2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 10 & \text { (constraint \#1) } \
& 3 \mathrm { X } _ { 1 } + 2 \mathrm { X } _ { 2 } \leq 20 & \text { (constraint \#2) } \
&\mathrm { X } _ { 1 } \geq 5 & \text { (constraint \#3) } \
&\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0 & \text { (non-negativity) }
\end{array}$$ 
  
-Refer to the spreadsheet above.Which cell(s)specifies the "changing cells" in Solver?

Accepted Answer

A) B1:C1 
B) D6:D8 
C) B3:C3 
D) D3 
E) B2:C2 
A) B1:C1 
B) D6:D8 
C) B3:C3 
D) D3 
E) B2:C2

Question 6

A manufacturer of 19" LCD monitors encounters the following quarterly production cost,demand,and production capacity for its monitors:
   
To maintain a stable workforce,the manufacturer wants to produce at least 500 units each quarter.To meet unexpected fluctuation in demand,the company wants to hold at least 100 monitors in stock each quarter.The cost of carrying a monitor in stock is $5 each quarter.Assume that beginning inventory is zero.Use Excel to formulate and solve this problem to determine to minimize production and inventory costs.

Accepted Answer

The answer of A manufacturer of 19" LCD monitors encounters...

Question 7

The objective function of the "Diet" problem is usually to maximize the food ingredient combination to satisfy a stated nutritional requirement.

Accepted Answer

A) True 
 B)False

Question 8

Use this information to answer the following questions.
A company can ship its product from any of its three factories,F1,F2,and F3,to any of its retail outlets,R1,R2,and R3.The capacity,demand,and shipping cost information is provided as follows:
 $\begin{array}{ll}
\text { Demand (units) } & \text { Capacity (units) } \
\hline \text { R1:300 } & \text { F1:250 } \
\text { R2: } 500 & F 2: 350 \
\text { R3:200 } & \text { F3:400 }
\end{array}$

Shipping Cost/unit ($)
$ \begin{array}{lll}&&\mathrm{R} 1 & \mathrm{R} 2 & \mathrm{R} 3\end{array} $
$ \begin{array}{llll}\mathrm{F} 1 & 1 & 3 & 2 \ \text { F2 } & 3 & 4 & 2 \ \text { F3 } & 2 & 2 & 3\end{array} $

-Refer to the information above.Assume that demand for retail outlet three (R3)increases to 300 units.How will this affect the shipping cost? Use Excel to formulate and solve this problem

Accepted Answer

The answer of Use this information to answer the following...

Question 9

The media selection problem can have which of the following objectives?

Accepted Answer

A) maximizing audience exposure 
B) minimizing advertising costs 
C) maximizing profit 
D) A and B only 
E) A,B,and C 
A) maximizing audience exposure 
B) minimizing advertising costs 
C) maximizing profit 
D) A and B only 
E) A,B,and C

Question 10

Which of the following statements is False regarding employee staffing applications?

Accepted Answer

A) Employee staffing problems can be formulated as assignment problems. 
B) The goal of employee staffing problems is typically to determine how many employees need to start their work at the different starting times permitted. 
C) The employee staffing problem is a extension of the product mix problem. 
D) It is possible to have multiple optimal solutions in employee staffing applications. 
E) Based on the requirements and constraints,it is possible for an employee staffing problem to become infeasible. 
A) Employee staffing problems can be formulated as assignment problems. 
B) The goal of employee staffing problems is typically to determine how many employees need to start their work at the different starting times permitted. 
C) The employee staffing problem is a extension of the product mix problem. 
D) It is possible to have multiple optimal solutions in employee staffing applications. 
E) Based on the requirements and constraints,it is possible for an employee staffing problem to become infeasible.

Question 11

Use this information to answer the following questions.
A company can ship its product from any of its three factories,F1,F2,and F3,to any of its retail outlets,R1,R2,and R3.The capacity,demand,and shipping cost information is provided as follows:
 $\begin{array}{ll}
\text { Demand (units) } & \text { Capacity (units) } \
\hline \text { R1:300 } & \text { F1:250 } \
\text { R2: } 500 & F 2: 350 \
\text { R3:200 } & \text { F3:400 }
\end{array}$

Shipping Cost/unit ($)
$ \begin{array}{lll}&&\mathrm{R} 1 & \mathrm{R} 2 & \mathrm{R} 3\end{array} $
$ \begin{array}{llll}\mathrm{F} 1 & 1 & 3 & 2 \ \text { F2 } & 3 & 4 & 2 \ \text { F3 } & 2 & 2 & 3\end{array} $

-Refer to the information above.The company wants to come up with an optimal shipping strategy to minimize its total shipping cost.Use Excel to formulate and solve this problem.

Accepted Answer

The answer of Use this information to answer the following...

Question 12

A company produces two products,X₁,and X₂.The constraint that illustrates the consumption of a given resource in making the two products is given by: 3X₁+5X₂ ≤ 120.This relationship implies that both products can consume more than 120 units of that resource.

Accepted Answer

A) True 
 B)False

Question 13

The objective function of a transportation problem is to:

Accepted Answer

A) maximize transportation cost 
B) maximize supply quantities 
C) minimize total demand 
D) minimize total shipping cost 
E) minimize production cost 
A) maximize transportation cost 
B) maximize supply quantities 
C) minimize total demand 
D) minimize total shipping cost 
E) minimize production cost

Question 14

A company is considering various advertising media to promote its new toy.Pertinent information regarding potential customers reached and costs per advertisement is given below:
 $\begin{array}{lccc} 
& \text { No. of Customers } \
\text { Media } & \begin{array}{c}
\text { Maximum Times } \
\text { Reached }
\end{array} & \begin{array}{c}
\text { Cost per } \
\text { Available per Month }
\end{array} & \text { Advertisement } \
 \text { Daytime TV } & 1000 & 10 & \$ 2000 \
\text { Evening TV } & 3000 & 8 & \$ 3500 \
\text { Daytime Radio } & 500 & 15 & \$ 1000 \
\text { Evening radio } & 750 & 15 & \$ 1500 \
\text { Newspaper } & 900 & 4 & \$ 500
\end{array}$
 
Currently,the company has a monthly advertising budget of $150,000.The marketing department has imposed the following restrictions:
•No more than $20,000 may be spent on radio advertising each month.
•At least 5 TV ads must be used each month.
Use Excel to formulate and solve this problem to maximize monthly audience exposure.

Accepted Answer

The answer of A company is considering various advertising media...

Question 15

A company manufactures two types of lawn mowers: riding mowers and push mowers.The company has the option of manufacturing the mowers in-house or outsourcing the entire operation.In-house manufacturing requires the following four operations: production,assembly,electrical wiring,and final inspection.The following table summarizes the weekly hours of processing time available and the processing time required by each operation.
   
The company has a weekly demand of 5 riding mowers and 3 push mowers.The company makes its riding mowers in-house for $500 each and its push mower for $200 each.Alternatively,it can outsource its riding and push mowers for $550 and $225 each,respectively.Use Excel to formulate and solve this "make" or "buy" problem.

Accepted Answer

The answer of A company manufactures two types of lawn...

Question 16

Use this information to answer the following questions.
The following table contains information on the cost to run four jobs (1,2,3,and 4)on four available machines (A,B,C,and D).
  
-Refer to the table above.Use Excel to model and solve this problem to determine the least costly job-machine assignment.

Accepted Answer

The answer of Use this information to answer the following...

Question 17

The "Transportation" problem involves determining the amount of goods to be transported from a number of origins to a number of destinations.

Accepted Answer

A) True 
 B)False

Question 18

Production,inventory,and demand are typical decision variables in a production scheduling,multi-period linear programming application.

Accepted Answer

A) True 
 B)False

Question 19

A furniture manufacturer produces three products,desks,tables,and chairs.These products can be produced during either the morning shift or the evening shift.The morning shift has a labor cost of $20 per hour with a maximum availability of 20,000 hours.The evening shift has a labor cost of $25 per hour and is limited to 15,000 hours.The labor,lumber,and demand requirements are given as follows:
   
Assume that there are 20,000 pounds of lumber and 20,000 pounds of nails available for both shifts.
Use Excel to formulate and solve this problem to minimize total labor cost.

Accepted Answer

The answer of A furniture manufacturer produces three products,desks,tables,and chairs.These...

Question 20

In a multi-period production scheduling application,which equation describes the relationship between demand,production,and inventory?

Accepted Answer

A) productiont + demandₜ - inventoryₜ₋₁ = inventoryₜ 
B) productiont + demandₜ + inventoryₜ₋₁ = inventoryₜ 
C) productiont - demandₜ₋₁ + inventoryₜ₋₁ = inventoryₜ 
D) productiont - demandₜ + inventoryₜ = inventoryₜ₋₁ 
E) productiont - demandₜ + inventoryₜ₋₁ = inventoryₜ 
A) productiont + demandₜ - inventoryₜ₋₁ = inventoryₜ 
B) productiont + demandₜ + inventoryₜ₋₁ = inventoryₜ 
C) productiont - demandₜ₋₁ + inventoryₜ₋₁ = inventoryₜ 
D) productiont - demandₜ + inventoryₜ = inventoryₜ₋₁ 
E) productiont - demandₜ + inventoryₜ₋₁ = inventoryₜ

Diet and feed mix problems are special classes of the general product mix problem.

In a multi-period production scheduling application,the decision variables typically designate:

The objective function of the "Diet" problem is usually to maximize the food ingredient combination to satisfy a stated nutritional requirement.

The media selection problem can have which of the following objectives?

Which of the following statements is False regarding employee staffing applications?

A company produces two products,X₁,and X₂.The constraint that illustrates the consumption of a given resource in making the two products is given by: 3X₁+5X₂ ≤ 120.This relationship implies that both products can consume more than 120 units of that resource.

The objective function of a transportation problem is to:

The "Transportation" problem involves determining the amount of goods to be transported from a number of origins to a number of destinations.

Production,inventory,and demand are typical decision variables in a production scheduling,multi-period linear programming application.

In a multi-period production scheduling application,which equation describes the relationship between demand,production,and inventory?

Introduction to Managerial Decision Making

Linear Programming Models: Graphical and Computer Methods

Linear Programming Sensitivity Analysis

Transportation, Assignment, and Network Models

Integer, Goal, and Nonlinear Programming Models

Project Management

Decision Analysis

Queuing Models

Simulation Modeling

Forecasting Models

Inventory Control Models

Filters

Exam 3: Linear Programming Modeling Applications with Computer Analyses in Excel

Diet and feed mix problems are special classes of the general product mix problem.

In a multi-period production scheduling application,the decision variables typically designate:

The objective function of the "Diet" problem is usually to maximize the food ingredient combination to satisfy a stated nutritional requirement.

The media selection problem can have which of the following objectives?

Which of the following statements is False regarding employee staffing applications?

A company produces two products,X₁,and X₂.The constraint that illustrates the consumption of a given resource in making the two products is given by: 3X₁+5X₂ ≤ 120.This relationship implies that both products can consume more than 120 units of that resource.

The objective function of a transportation problem is to:

The "Transportation" problem involves determining the amount of goods to be transported from a number of origins to a number of destinations.

Production,inventory,and demand are typical decision variables in a production scheduling,multi-period linear programming application.

In a multi-period production scheduling application,which equation describes the relationship between demand,production,and inventory?

Introduction to Managerial Decision Making

Linear Programming Models: Graphical and Computer Methods

Linear Programming Sensitivity Analysis

Transportation, Assignment, and Network Models

Integer, Goal, and Nonlinear Programming Models

Project Management

Decision Analysis

Queuing Models

Simulation Modeling

Forecasting Models

Inventory Control Models

Filters