Practical Management Science
5th Edition
ISBN: 9781305250901
Author: Wayne L. Winston, S. Christian Albright
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7.4, Problem 21P
Summary Introduction
To make: The appropriate changes and return solver and find the results.
Non-linear programming (NLP):
Non-linear programming (NLP) is used in complex optimization problems where the objectives or constraints or sometimes both are non-linear functions of the decision variables. A model can be termed as non-linear for more than one reason.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
4-2
Consider the following sample data for the relationship between advertising budget and sales for Product A:
Observation
1
2
3
4
5
6
7
8
9
10
Advertising ($)
80,000
80,000
90,000
100,000
100,000
110,000
120,000
120,000
130,000
140,000
Sales ($)
499,000
477,000
546,000
614,000
623,000
653,000
747,000
714,000
785,000
858,000
What is the predicted sales quantity for an advertising budget of $108,000?
Please round your answer to the nearest integer.
Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
A TV program has a rating of 17.6. With approximately 118.4 million television households in the United States as of 2016, what is that program’s CPM if a 30-second commercial costs $600,000? Now assume that an advertiser’s target audience consists only of people aged 25 to 54, which constitute 62 percent of the program’s total audience. What is the CPM-TM in this case?
The marketing department is considering a shift to internet-based advertising. The advertising rates and demographics of several
different options are shown below. The marketing campaign goal is to reach the following audiences:
Age 18 to 25-1,000,000 impressions
Age 26 to 35- 1,500,000 impressions
Age 36 to 45-750,000 impressions
What mix of advertising investment will be most economical while still meeting the goals?
Cost per thousand impressions
Source
A
B
(dollars)
30
20
Investment in Source A ($)
Investment in Source B ($)
Demographic breakdown
18-25 (30%), 26-35 (50 %), 36-45 (20%)
18-25 (10 %), 26-35 (60%), 36-45 (30%)
Note: Round your answer to the nearest whole number value.
Chapter 7 Solutions
Practical Management Science
Ch. 7.3 - Prob. 1PCh. 7.3 - Prob. 2PCh. 7.3 - Pricing Decisions at Madison The Madison Company...Ch. 7.3 - Prob. 4PCh. 7.3 - Prob. 5PCh. 7.3 - Prob. 6PCh. 7.3 - Prob. 7PCh. 7.3 - Prob. 8PCh. 7.3 - Prob. 9PCh. 7.3 - Prob. 10P
Ch. 7.3 - Prob. 11PCh. 7.3 - Prob. 12PCh. 7.3 - Prob. 13PCh. 7.3 - PRICING SUITS AT SULLIVANS Sullivans is a retailer...Ch. 7.3 - Prob. 15PCh. 7.4 - Prob. 16PCh. 7.4 - Prob. 17PCh. 7.4 - Prob. 18PCh. 7.4 - Prob. 19PCh. 7.4 - Prob. 20PCh. 7.4 - Prob. 21PCh. 7.4 - Prob. 22PCh. 7.4 - Prob. 23PCh. 7.5 - Prob. 24PCh. 7.5 - Prob. 25PCh. 7.5 - Prob. 26PCh. 7.5 - Prob. 27PCh. 7.6 - Prob. 28PCh. 7.6 - Prob. 29PCh. 7.6 - Prob. 30PCh. 7.6 - Prob. 31PCh. 7.6 - The method for rating teams in Example 7.8 is...Ch. 7.7 - Prob. 35PCh. 7.7 - Prob. 36PCh. 7.7 - Prob. 37PCh. 7.7 - The stocks in Example 7.9 are all positively...Ch. 7.7 - Prob. 39PCh. 7.7 - Prob. 40PCh. 7.7 - Prob. 41PCh. 7.7 - Prob. 42PCh. 7.8 - Given the data in the file Stock Beta.xlsx,...Ch. 7.8 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Another way to derive a demand function is to...Ch. 7 - Prob. 48PCh. 7 - If a monopolist produces q units, she can charge...Ch. 7 - Prob. 50PCh. 7 - Prob. 51PCh. 7 - Prob. 52PCh. 7 - Prob. 53PCh. 7 - Prob. 54PCh. 7 - Prob. 55PCh. 7 - Prob. 56PCh. 7 - A beer company has divided Bloomington into two...Ch. 7 - Prob. 58PCh. 7 - Prob. 59PCh. 7 - Prob. 60PCh. 7 - Prob. 61PCh. 7 - Prob. 62PCh. 7 - Prob. 63PCh. 7 - Prob. 64PCh. 7 - Prob. 65PCh. 7 - Prob. 66PCh. 7 - Prob. 67PCh. 7 - Prob. 68PCh. 7 - Prob. 69PCh. 7 - Prob. 70PCh. 7 - Based on Grossman and Hart (1983). A salesperson...Ch. 7 - Prob. 73PCh. 7 - Prob. 74PCh. 7 - Prob. 75PCh. 7 - Prob. 76PCh. 7 - Prob. 77PCh. 7 - Prob. 78PCh. 7 - Prob. 79PCh. 7 - Prob. 80PCh. 7 - Prob. 81PCh. 7 - Prob. 82PCh. 7 - Prob. 83PCh. 7 - Prob. 84PCh. 7 - Prob. 85PCh. 7 - Prob. 86PCh. 7 - Prob. 1.1CCh. 7 - Prob. 1.2CCh. 7 - Prob. 1.3CCh. 7 - Prob. 1.4C
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
- Based on the underlying research, which of the following statements accurately interprets the model (above) for the relationship between SFA usage and its outcomes? SFA usage increases the integration and application of customer information which directly improves salesperson performance. Job experience positively influences SFA usage and that increase in SFA usage results in greater salesperson adaptability which indirectly improves relationship quality. SFA usage increases the integration and application of customer information which directly improves the relationship quality with customers. Job experience negatively influences the integration and application of customer information which directly improves salesperson.arrow_forwardThe owner of a nail shop that operates in a local strip mall told her daughter, "Well, after budgeting for all of our expenses for next year, we still have about $7,500 remaining for emergencies. Let's budget 20 percent of that amount for advertising." What budgeting technique is the retailer most likely using? 04 Multiple Choice all-you-can-afford budgeting percentage of sales budgeting competitive parity budgeting objective and task budgeting linear forecast budgetingarrow_forwardmy fav <33 Wag mo nalang sila pakinggang dami alam e now CASE STUDY Instruction: Read the article thoroughly and answer the questions that follow. Divulging or revealing confidential information such as the personal profile of clients is prohibited for employees especially among sales personnel. Any type of information such as trade secrets and other proprietary information should be kept protected by companies. Employees who have access to such information are trusted to keep them confidential. Overhearing information about a client should be dealt with accordingly. In the same manner, having confidential information about a competitor should be treated ethically. If the information about a client can help in boosting sales, execute the appropriate action to make things work out for the client and the company. Whatever personal information obtained should be kept confidential. On the other hand, trade secrets and other types of information should remain confidential within the bounds…arrow_forward
- marketing company is facing some issues with his new marketing strategy since the data he and his team gathered from surveys wasn’t compatible with the analysis tool they’re most comfortable using. Which of the following current issues in Data Warehousing best describes the given scenario? * The company cannot have access to the data. The data gathered by the company is unusable. The data gathered by the company is impossible to understand. The company cannot find the needed data. Which of the following is NOT a characteristic of a Data Warehouse? * A data warehouse is most often than not, normalized. All of the above are characteristics of a data warehouse. The data stored in a data warehouse is usually large. The data stored in a data warehouse came from sources, both inside and outside the organization.arrow_forwardA cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research. Objectives: Why users shop online versus in store How to take advantage of the online channel How to improve the company’s website Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites. Ways to improve consumers’ in-store experience Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.arrow_forward48- The maximum number of sales that can occur in a given period to an individual or businesses that are willing to sell in a given market is known as: a. Product demand b. Market potential c. Market demand d. All the options are correctarrow_forward
- . A McDonald’s Happy Meal® consists of an entrée, a small order of French fries, a small drink, and a toy. In the early 1990s, McDonald’s Corp. began to aim its Happy Meal marketing at children aged one to three. In 1995, McDonald’s began making nutritional information for its food products available in documents known as “McDonald’s Nutrition Facts.” Each document lists the food items that the restaurant serves and provides a nutritional breakdown, but the Happy Meal is not included. Marc Cohen filed a suit in an Illinois state court against McDonald’s. Cohen alleged, among other things, that McDonald’s had violated a state law prohibiting consumer fraud and deceptive business practices by failing to follow the Nutrition Labeling and Education Act (NLEA) of 1990. The NLEA sets out different, less detailed requirements for products specifically intended for children under the age of four. Does it make sense to have different requirements for children of this age? Why or why not? Should…arrow_forwardWhich one of the following responses is not true about an annual fundraising campaign? Group of answer choices An annual campaign is primarily used in the private sector. An annual campaign is conducted each year. An annual campaign is used to support operating expenses. An annual campaign can be used for short-term purposes.arrow_forwardWe need to define a target market in order to guide the development of the product, choices in the sales channel, setting our prices, and guiding communication plans. Group of answer choices True Falsearrow_forward
- Solve for the predicted values of y and the residuals for the following data. Advertising 12.5 3.7 21.5 60.0 37.6 6.1 16.6 41.2 Sales 141 55 338 994 542 89 126 379 (Do not round the intermediate values. Round your answers to 4 decimal places, e.g. 1.7585.) y Predicted ( ŷ ) Residuals (y – ŷ ) 12.5 141 3.7 55 21.5 338 60.0 994 37.6 141 6.1 89 16.6 126 41.2 379arrow_forwardDalina forgot her golf glove, so she bought the brand that was sold in the pro shop before her match. Which type of consumer problem solving did Dalina use?arrow_forwardA brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize, Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager has decided that because television ads have been found to be much more effective than radio ads, at least 70% of the time should be allocated to television. Suppose that we have the following data: Type of Ad Exposure/Minute Cost/Minute Radio 350 $400 TV 800 $2,000 a) Identify the decision variables, objective function, and constraints in simple verbal expressions. b) Mathematically formulate a linear optimization model. c) Use Solver to find an optimal solution.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,