Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 13, Problem 49P
Summary Introduction
To determine: Whether advertising dollars are generating this type of sales response using regression.
Introduction: Simulation model is the digital prototype of the physical model that helps to
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between digital advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media, and that the amount of money spent on digital advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for digital advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget in order to maximize the value of total audience exposure?
Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure.
Solve the problem using…
NASA must determine how many of three types of objects to bring on board the space shuttle. The weight and benefit of each of the items are given in the file P06_42.xlsx. If the space shuttle can carry up to 2,000 pounds of items 1 through 3, how many of each item should be taken on the space shuttle, assuming that at least one of each is necessary?
Number of each item to be included
Item 1
Item 2
Item 3
Number included
NASA data
Data on items
Item 1
Item 2
Item 3
Benefit
20
15
12
Weight
500
400
300
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media, and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget in order to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure.
It's…
Chapter 13 Solutions
Practical Management Science
Ch. 13.3 - The file P13_01.xlsx contains the monthly number...Ch. 13.3 - The file P13_02.xlsx contains five years of...Ch. 13.3 - The file P13_03.xlsx contains monthly data on...Ch. 13.3 - The file P13_04.xlsx lists the monthly sales for a...Ch. 13.3 - Management of a home appliance store wants to...Ch. 13.3 - Do the sales prices of houses in a given community...Ch. 13.3 - Prob. 7PCh. 13.3 - The management of a technology company is trying...Ch. 13.3 - Prob. 9PCh. 13.3 - Sometimes curvature in a scatterplot can be fit...
Ch. 13.4 - Prob. 12PCh. 13.4 - A trucking company wants to predict the yearly...Ch. 13.4 - An antique collector believes that the price...Ch. 13.4 - Stock market analysts are continually looking for...Ch. 13.4 - Suppose that a regional express delivery service...Ch. 13.4 - The owner of a restaurant in Bloomington, Indiana,...Ch. 13.6 - The file P13_19.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_20.xlsx contains the monthly sales of...Ch. 13.6 - The file P13_21.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_22.xlsx contains total monthly U.S....Ch. 13.7 - You have been assigned to forecast the number of...Ch. 13.7 - Simple exponential smoothing with = 0.3 is being...Ch. 13.7 - The file P13_25.xlsx contains the quarterly...Ch. 13.7 - The file P13_26.xlsx contains the monthly number...Ch. 13.7 - The file P13_27.xlsx contains yearly data on the...Ch. 13.7 - The file P13_28.xlsx contains monthly retail sales...Ch. 13.7 - The file P13_29.xlsx contains monthly time series...Ch. 13.7 - A version of simple exponential smoothing can be...Ch. 13 - Prob. 31PCh. 13 - Prob. 32PCh. 13 - Management of a home appliance store would like to...Ch. 13 - A small computer chip manufacturer wants to...Ch. 13 - The file P13_35.xlsx contains the amount of money...Ch. 13 - Prob. 36PCh. 13 - Prob. 37PCh. 13 - Prob. 39PCh. 13 - The Baker Company wants to develop a budget to...Ch. 13 - Prob. 41PCh. 13 - The file P13_42.xlsx contains monthly data on...Ch. 13 - Prob. 43PCh. 13 - Prob. 44PCh. 13 - Prob. 45PCh. 13 - Prob. 46PCh. 13 - Prob. 49P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).arrow_forward3-An e-commerce firm selling mobile phone accessories decides to invest in advertising to boost the sales. The firm is expected to sell $25 million worth of the product. It is estimated that a 1 % increase in the advertising budget would increase quantity sold by 6 %. Moreover, it is also estimated that a 1 % increase in the product's price would reduce quantity sold by 0.3 %. Derive the Dorfman-Steiner condition. Calculate the optimal advertising budget for this firm.arrow_forwardMarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales. Car Sales Manufacturer Jan.-Nov.2017 Jan.-Nov.2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota 2,211,533 2,205,762 Fiat Chrysler 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 542,245 Mercedes (includes Sprinter) 332,990 318,012 BMW 271,432 276,657 VW 309,395 322,017 Mazda 262,577 274,455 Audi 199,534 200,558 Tesla (Est.) 40,320 106,050 Land Rover 66,759 81,526 Volvo 71,828 89,437 Mitsubishi 95,185 109,088 Porsche 51,507…arrow_forward
- In the original OJ Simpson trial, it was accepted that OJ had battered his wife. OJ’s lawyer tried to negate the impact of this information by stating that in a one-year period, only 1 out of 2500 battered women are murdered, so the fact that OJ battered his wife does not give much evidence that he was the murderer. The prosecution (foolishly!) let this go unchallenged. Here are the relevant statistics: In a typical year 6.25 million women are battered, 2500 are battered and murdered, and 2250 of the women who were battered and murdered were killed by the batterer. How should the prosecution have refuted the defense’s argument?arrow_forwardI need help with everything, please. Formulate the problem and submit formulation - no need to solve. 1. An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility and thus more uncertainty. Because cash is held in a money market fund, the annual return is lower, but it carries essentially no risk. The objective is to determine the portion of funds allocated to each investment alternative in order to maximize the total annual return for the portfolio subject to the risk level the client is willing to tolerate. Total risk is the sum of the risk for all investment alternatives. For instance, if 40% of a client’s funds are…arrow_forwardA national truck rental services has a surplus of one truck in each of the cities, 1, 2, 3, 4, 5, and 6 and a deficit of one truck in each of the cities 7,8,9,10,11 and 12.The distance (in kilometers) between the cities with a surplus and cities with deficit are displayed below:a) b) How should the trucks be displayed so as to maximize the total distance travelled? 1 2 3 4 5 6 7 41 72 39 52 25 51 8 22 29 49 65 81 50 9 27 39 60 51 32 32 10 45 50 48 52 37 43 11 82 40 40 60 51 30arrow_forward
- Please do not give solution in image formate thanku. 7-16 A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach?arrow_forwardA buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. The buyer must decide on November 1 how many pairs of the manufacturer's newest model of tennis shoes to order for sale during the coming summer season. Assume that each pair of this new brand of tennis shoes costs the department store chain $65 per pair. Furthermore, assume that each pair of these shoes can then be sold to the chain's customers for $85 per pair. Any pairs of these shoes remaining unsold at the end of the summer season will be sold in a closeout sale next fall for $55 each. The probability distribution of consumer demand for these tennis shoes during the coming summer season has been assessed by market research specialists and is provided in the file P09_35.xlsx. Finally, assume that the department store chain must purchase these tennis shoes from the manufacturer in lots of 100 pairs. a. Identify…arrow_forwardA buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. The buyer must decide on November 1 how many pairs of the manufacturer's newest model of tennis shoes to order for sale during the coming summer season. Assume that each pair of this new brand of tennis shoes costs the department store chain $65 per pair. Furthermore, assume that each pair of these shoes can then be sold to the chain's customers for $85 per pair. Any pairs of these shoes remaining unsold at the end of the summer season will be sold in a closeout sale next fall for $55 each. The probability distribution of consumer demand for these tennis shoes during the coming summer season has been assessed by market research specialists and is provided in the file P09_35.xlsx. Finally, assume that the department store chain must purchase these tennis shoes from the manufacturer in lots of 100 pairs. a. Identify…arrow_forward
- A motion picture industry analyst is studying movies based on epic novels. The following data were obtained for 10 Hollywood movies made in the past five years. Each movie was based on an epic novel. For these data, x1 = first-year box office receipts of the movie, x2 = total production costs of the movie, x3 = total promotional costs of the movie, and x4 = total book sales prior to movie release. All units are in millions of dollars. x1 x2 x3 x4 85.1 8.5 5.1 4.7 106.3 12.9 5.8 8.8 50.2 5.2 2.1 15.1 130.6 10.7 8.4 12.2 54.8 3.1 2.9 10.6 30.3 3.5 1.2 3.5 79.4 9.2 3.7 9.7 91.0 9.0 7.6 5.9 135.4 15.1 7.7 20.8 89.3 10.2 4.5 7.9 a) Suppose Hollywood is planning a new epic movie with projected box office sales x1 = 100 million and production costs x2 = 12 million. The book on which the movie is based had sales of x4 = 9.2 million. Forecast the dollar amount (in millions) that should be budgeted for promotion costs x3 and find an 80% confidence interval for your…arrow_forwardZara stores in the United States stocks a particular type of designer denim jeans in theUnited States. It stores 500 pairs of jeans each month from its two suppliers. The HongKong supplier charges Zara $11 per pair of jeans, and the Colombian supplier charges$16 per pair (and then Zara marks them up almost 1,000%). Although the jeans fromHong Kong are less expensive, they also have more defects than those from Colombia.Based on past data, Zara estimates that 7% of the Hong Kong jeans will be defectivecompared to only 2% from Colombia and Zara does not want to import any more than5% defective items. However, Zara does not want to rely on a single supplier, so it wantsto order at least 20% from each supplier every month. D. If the Hong Kong supplier were able to reduce its percentage of defective pairs ofjeans from 7% to %5, what would be the effect on the solution. Solve c in a separatesheet. First copy the sheet you solved a, b and c. Then change the necessary line andre-solve.…arrow_forward(Please use the format of the speadsheet in the image) A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle is required to have 360 grams of protein and 360 grams of fat. Brand X has 5 grams of protein and 10 grams of fat. Brand Y has 10 grams of protein and 5 grams of fat. Rancher has found that Brand X costs $3.5 and brand Y costs $5 per unit. Find out how much of each type should be used by the rancher to minimize cost. Keep in mind that the rancher has to buy at least one unit of each brand. Moreover, the number of brand X has to be twice the number of brand Y. (Possible Answer: $216)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,