Examlex
A marketing research professor is conducting a telephone survey and needs to contact at least 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 to make a daytime call and $4 (because of higher labor costs) to make an evening call. The table shown below lists the expected results. For example, 10% of all daytime calls are answered by a single male, and 15% of all evening calls are answered by a single female. Because of a limited staff, at most half of all phone calls can be evening calls. Determine how to minimize the cost of completing the survey.
-(A) What is the objective function in this problem?
(B) What are the constraints in this problem? Write an algebraic expression for each.
(C) Find an optimal solution to the problem using the formulation given in (A) and (B). What is the call plan, and what is the total cost?
(D) Implement the model in (C) in Excel Solver and obtain an answer report. Which constraints are binding on the optimal solution?
(E) Obtain a sensitivity report for the model in (D). If the professor could cut the cost of evening calls from $4 to $3, what would the new calling plan be?
(F) Again using the sensitivity report obtained for (E), suppose the professor could get by with just 100 calls for single females. What would the call costs be in that case? Explain your answer.
November and December Sales
Refers to the revenue generated from the sale of goods or services during the months of November and December, often a significant period for retailers due to holiday shopping.
Department Store
A large retail store offering a wide range of products and brands under one roof, organized into departments for shopper convenience.
Toy Manufacturer
A business involved in the design, production, and marketing of toys for children and sometimes adults.
Trucking Company
A business entity that specializes in transporting goods across distances using trucks.
Q17: We must deal with uncertainty when we
Q32: A @RISK output range allows us to
Q61: We compare the percent of variation explained
Q66: Discuss how the company's optimal production schedule
Q72: In an optimization model, there can only
Q77: (A) Use Excel to generate a time
Q82: Holt's model differs from simple exponential smoothing
Q82: The t-value for testing <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1387/.jpg" alt="The
Q86: Rounding the solution of a linear programming
Q88: Scatterplots are used for identifying outliers and