A company wants to determine how to allocate its $200,000 advertising budget to market a new cereal.The company is considering newspaper ads,television ads,and radio ads.The following table illustrates the cost of advertising in these different media and the exposure to new customers reached by increasing the number of ads in each medium. $\begin{array}{lccc} \text { Media and Number of Ads } & \text { No. of New Customers reached } & \text { Cost per ad } \\ \text { Newspaper: } 1-5 & 700 & \$ 500 \\ \text { Newspaper: } 6-10 & 500 & \$ 400 \\ \text { Television: } 1-10 & 9000 & \$ 5000 \\ \text { Television: } 11-20 & 7500 & \$ 4000 \\ \text { Radio: } 1-10 & 4000 & \$ 2000 \\ \text { Radio: } 11-20 & 300 & \$ 1500 \end{array}$ Use Excel to formulate and solve this problem to maximize audience exposure.

The answer of A company wants to determine how to...

Speedy Lube has 4 bays in its shop and 3 cars waiting for an oil change.The estimated time (in minutes)to change the oil and filter for each car in each bay is given as follows: $\begin{array}{llll} \text { CarBay } & \mathrm{A}& \mathrm{B}&{\mathrm{C}} \\ 1 & 10 & 12 & 12 \\ 2 & 15 & 13 & 12 \\ 3 & 14 & 12 & 10 \\ 4 & 13 & 11 & 12 \end{array}$ Which car should be assigned to which bay if Speedy Lube wants to minimize its total service time? Use Excel to formulate and solve this problem.

The answer of Speedy Lube has 4 bays in its...

A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits.Production requirements for the products are shown in the following table. \[\begin{array} { l c c c } \text { Product } & \text { Material 1(lbs.) } & \text { Material 2(lbs.) } & \text { Labor (hours) } \\ \mathrm { A } & 3 & 2 & 4 \\ \mathrm {~B} & 1 & 4 & 2 \\ \mathrm { C } & 5 & \text { none } & 3.5 \end{array}\] Material 1 costs $7 a pound,material 2 costs $5 a pound,and labor costs $15 per hour.Product A sells for $101 a unit,product B sells for $67 a unit,and product C sells for $97.50 a unit.Each week there are 300 pounds of material 1;400 pounds of material 2;and 200 hours of labor.Also,there is a weekly demand of 10 units of product C each week.Use Excel to formulate and solve this problem.

The answer of A production manager wants to determine how...

In a small suburban town,firefighters work 8-hour shifts.Assume there are six shifts each day that are divided into six 4-hour periods.The minimum number of firefighters needed on each shift is illustrated below. \[\begin{array} { l c } \text { Shift } & \text { Number of Firefighters Needed } \\ \text { Midnight-4 a.m. } & 5 \\ 4 \text { a.m.-8 a.m. } & 6 \\ \text { 8 a.m.-Noon } & 10 \\ \text { Noon-4 p.m. } & 12 \\ 4 \text { p.m.-8 p.m. } & 8 \\ \text { 8 p.m.-Midnight } & 5 \end{array}\] Firefighters must report to work at the beginning of the above time periods and must work eight consecutive hours.Use Excel to formulate and solve this labor planning problem to determine the minimum number of firefighters needed on each shift.

The answer of In a small suburban town,firefighters work 8-hour...

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 the road leading from factory F1 to retail outlet R1 is currently closed due to construction.How will this affect the shipping cost? Use Excel to formulate and solve this problem.

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

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

Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max 3+3 Subject to: 2+3\leq10 (constraint \#1) 3+2\leq20 (constraint \#2) \geq5 (constraint \#3) ,\geq0 (non-negativity) $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.What formula should be entered in cell D3 to compute total profitability?$ -Refer to the spreadsheet above.What formula should be entered in cell D3 to compute total profitability?

(Multiple Choice)

4.8/5

(37)

Question 21

Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max 3+3 Subject to: 2+3\leq10 (constraint \#1) 3+2\leq20 (constraint \#2) \geq5 (constraint \#3) ,\geq0 (non-negativity) $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 equation should be entered in cell F8 to compute the amount by which the minimal requirement of constraint #3 has been exceeded?$ -Refer to the spreadsheet above.Which equation should be entered in cell F8 to compute the amount by which the minimal requirement of constraint #3 has been exceeded?

(Multiple Choice)

4.8/5

(29)

Question 22

A company wants to determine how to allocate its $200,000 advertising budget to market a new cereal.The company is considering newspaper ads,television ads,and radio ads.The following table illustrates the cost of advertising in these different media and the exposure to new customers reached by increasing the number of ads in each medium. Media and Number of Ads No. of New Customers reached Cost per ad Newspaper: 1-5 700 \ 500 Newspaper: 6-10 500 \ 400 Television: 1-10 9000 \ 5000 Television: 11-20 7500 \ 4000 Radio: 1-10 4000 \ 2000 Radio: 11-20 300 \ 1500 Use Excel to formulate and solve this problem to maximize audience exposure.

(Essay)

4.9/5

(35)

Question 23

Consider the following data that illustrates demand,production costs,and expected capacity for a given product. Month 1 2 3 4 Demand (units) 100 125 200 175 Production cost/Unit \ 20 \ 25 \ 30 \ 35 Production Capacity (units) 150 150 150 150 . Inventory carrying costs are estimated at $4 per unit per month.The firm wants to produce at least 50 units per month to uniformly utilize its existing resources.Assume that beginning inventory is zero.Use Excel to formulate and solve this problem to determine how many units of the product should be produced monthly to meet the expected demand at minimal cost.

(Essay)

4.9/5

(35)

Question 24

Speedy Lube has 4 bays in its shop and 3 cars waiting for an oil change.The estimated time (in minutes)to change the oil and filter for each car in each bay is given as follows: CarBay 1 10 12 12 2 15 13 12 3 14 12 10 4 13 11 12 Which car should be assigned to which bay if Speedy Lube wants to minimize its total service time? Use Excel to formulate and solve this problem.

(Essay)

4.7/5

(38)

Question 25

Three types of fertilizer are manufactured by a company-Regular,Supergro,and Jungle Feeder.Regular should have at least 10 percent nitrogen and 16 percent phosphorous.Supergro should have at least 12 percent nitrogen and 20 percent phosphorous,and Jungle Feeder should have at least 15 percent nitrogen and 18 percent phosphorous.These are made by using two components-A and B.Component A costs $0.30 per pound and is 14 percent nitrogen and 18 percent phosphorous.Component B costs $0.50 per pound and is 20 percent nitrogen and 24 percent phosphorous.The demand for Regular is projected to be 1000 pounds,while each of the others has a demand of 2000 pounds.Formulate and solve the appropriate linear program to determine how many pounds of Components A and B to include in each type of fertilizer,respectively.

(Essay)

4.8/5

(35)

Question 26

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: 2X₁+3X₂ ≤ 10.This relationship implies that each unit of X1 consumes 3 units of that resource.

(True/False)

4.8/5

(37)

Question 27

Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max 3+3 Subject to: 2+3\leq10 (constraint \#1) 3+2\leq20 (constraint \#2) \geq5 (constraint \#3) ,\geq0 (non-negativity) $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 equation should be entered in cell F6 to compute the unused resources of constraint #1?$ -Refer to the spreadsheet above.Which equation should be entered in cell F6 to compute the unused resources of constraint #1?

(Multiple Choice)

4.8/5

(40)

Question 28

A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits.Production requirements for the products are shown in the following table. Product Material 1(lbs.) Material 2(lbs.) Labor (hours) 3 2 4 1 4 2 5 none 3.5 Material 1 costs $7 a pound,material 2 costs $5 a pound,and labor costs $15 per hour.Product A sells for $101 a unit,product B sells for $67 a unit,and product C sells for $97.50 a unit.Each week there are 300 pounds of material 1;400 pounds of material 2;and 200 hours of labor.Also,there is a weekly demand of 10 units of product C each week.Use Excel to formulate and solve this problem.

(Essay)

4.9/5

(29)

Question 29

Which of the following statements regarding the Portfolio selection problem is False?

(Multiple Choice)

4.9/5

(35)

Question 30

A real estate developer is planning to build an office complex.Currently,there are three office sizes under consideration: small,medium,and large.Small offices can be rented for $600 per month,medium offices can be rented for $750 per month,and large offices can be rented for $1000 per month.Each small office requires 600 square feet,each medium office requires 800 square feet,and each large office requires 1000 square feet.The current plot of land available to the developer is 100,000 square feet.The developer wants to ensure that the office complex has at least 3 units of each office size.Use Excel to formulate and solve this problem to maximize total revenue.

(Essay)

4.8/5

(38)

Question 31

Alternate optimal solutions are not common in linear programming applications.

(True/False)

4.8/5

(38)

Question 32

Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max 3+3 Subject to: 2+3\leq10 (constraint \#1) 3+2\leq20 (constraint \#2) \geq5 (constraint \#3) ,\geq0 (non-negativity) $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 equation should be entered in cell D8 to compute the consumption of resource 3 (i.e. ,constraint #3)?$ -Refer to the spreadsheet above.Which equation should be entered in cell D8 to compute the consumption of resource 3 (i.e. ,constraint #3)?

(Multiple Choice)

4.9/5

(30)

Question 33

In a multi-period production scheduling application,the objective function is to:

(Multiple Choice)

4.8/5

(27)

Question 34

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 the beer distributor has the option of "subcontracting" beer cases to supplement the existing capacity.Subcontracting can handle a maximum of 5 cases per week.Subcontracting cost per case is $80.Also,due to an upcoming holiday season,the beer distributor wants to maintain a safety stock of at least 5 cases per week.Use Excel to formulate and solve this multiperiod production scheduling problem.

(Essay)

4.9/5

(27)

Question 35

The marketing research problem has which of the following objectives?

(Multiple Choice)

4.9/5

(34)

Question 36

The "Sinking Fund" problem can be classified as a multi-period linear programming application.

(True/False)

4.8/5

(32)

Question 37

In a small suburban town,firefighters work 8-hour shifts.Assume there are six shifts each day that are divided into six 4-hour periods.The minimum number of firefighters needed on each shift is illustrated below. Shift Number of Firefighters Needed Midnight-4 a.m. 5 4 a.m.-8 a.m. 6 8 a.m.-Noon 10 Noon-4 p.m. 12 4 p.m.-8 p.m. 8 8 p.m.-Midnight 5 Firefighters must report to work at the beginning of the above time periods and must work eight consecutive hours.Use Excel to formulate and solve this labor planning problem to determine the minimum number of firefighters needed on each shift.

(Essay)

4.7/5

(30)

Question 38

Consider the following constraint: X₁ ≥ 40.This implies that at most 40 units of product X₁ can be produced.

(True/False)

4.7/5

(31)

Question 39

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: Demand (units) Capacity (units) R1:300 F1:250 R2: 500 F2:350 R3:200 F3:400 Shipping Cost/unit ($) 1 2 3 1 1 3 2 F2 3 4 2 F3 2 2 3 -Refer to the information above.Assume that the road leading from factory F1 to retail outlet R1 is currently closed due to construction.How will this affect the shipping cost? Use Excel to formulate and solve this problem.

(Essay)

4.9/5

(31)

Question 40

Showing 21 - 40 of 49

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: 2X₁+3X₂ ≤ 10.This relationship implies that each unit of X1 consumes 3 units of that resource.

Which of the following statements regarding the Portfolio selection problem is False?

Alternate optimal solutions are not common in linear programming applications.

In a multi-period production scheduling application,the objective function is to:

The marketing research problem has which of the following objectives?

The "Sinking Fund" problem can be classified as a multi-period linear programming application.

Consider the following constraint: X₁ ≥ 40.This implies that at most 40 units of product X₁ can be produced.

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