Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7, Problem 55P
a)
Summary Introduction
To determine: The amount of money the company must spend on each market to maximize the sales revenue.
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.
b)
Summary Introduction
To use: The solver table to know the impact of change in the advertising budget affects the optimal sales revenue.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Company XYZ is specialized in producing and selling smart watches. The company currently has two
products and is planning to improve it profits in the coming years. The company is thinking of introducing a
sales commission to encourage its sales people to make more sales and improve company's profitability.
When designing the sales commission the company should base the sales commission on:
O a. None of the given answers
O b. The selling price
O c. The color of the product
d. The contribution margin
O e. The number of employees
14:02
W
A a d0) ENG
15-04-2021
re to search
hp
prt sc
end
pg up
delete
home
40
96
&
num
2$
backspace
lock
3
6.
8.
V.
8 A
E
R
U
home
to
4 į 5 0
enter
D
G
J
K
L.
pause
1 shift
2
C
end
alt
ctrl
ins
This data sufficiency problem consists of a question and two statements, labeled (1) and (2), in which certain data are given. You have to decide whether the data given in the statements are sufficient for answering the question. Using the data given in the statements, plus your knowledge of mathematics and everyday facts (such as the number of days in July or the meaning of the word counterclockwise), you must indicate whether:- Statement (1) ALONE is sufficient, but statement (2) alone is not sufficient to answer the question asked.- Statement (2) ALONE is sufficient, but statement (1) alone is not sufficient to answer the question asked.- BOTH statements (1) and (2) TOGETHER are sufficient to answer the question asked, but NEITHER statement ALONE is sufficient to answer the question asked.- EACH statement ALONE is sufficient to answer the question asked.- Statements (1) and (2) TOGETHER are NOT sufficient to answer the question asked, and additional data specific to the problem are…
The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987–1997 (where year 1 corresponds to 1987). a. Fit a power and an exponential trend curve to these data. Which fits the data better? b. Use your part a answer to predict 1999 sales for Dell. c. Use your part a answer to describe how the sales of Dell have grown from year to year. d. Search the Web for more recent Dell sales data. Then repeat the preceding parts using all of the data.
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 - Prob. 32PCh. 7.6 - Prob. 33PCh. 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 - You have 50,000 to invest in three stocks. Let Ri...Ch. 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
- 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_forwardWhich of the following statements about what-if analysis is TRUE? Multiple Choice Changes in an objective function coefficient will always lead to changes in decision variable values. Changes to constraint right-hand side values will always lead to changes in decision variable values. Changes in an objective function coefficient will never lead to changes in decision variable values. Changes to constraint right-hand side values will never lead to changes in decision variable values. None of the answer choices is correct.arrow_forwardA C AD 4 A D BC B D ACD C AB ABCD The table above represents a target population; each box is one household. Your campaign is one advertisement on 3 different TV programs (A, B, and C) and 3 advertisements on program D, each program airing one time. The pattern of viewership is shown in the table. Assume that 17 households were watching TV. Calculate share for program D.arrow_forward
- 1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers. 2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.arrow_forwardMULTIPLE CHOICE QUESTIONS An ecommerce company decides to send a gift voucher worth $1000 to a set of customers they believe would make a purchase of at least $5000. They develop a model to identify potential customers who can make a purchase of $5000 if we send the $1000 voucher. Which of the following is more critical about the model? O False negative is worse than False positive if voucher amount crosses $5000 O Both False positive and negative are acceptable O False positive is worse than a False negative O False negative is worse than a False positive Which of the following statements is TRUE? O Tree based models are normally not affected by outliers O Presence of outliers in the data has no effect on Regression models O Standard scaler performs well on features that have outliers O Tree-based models do not rely on dividing the feature space into sub-sectionsarrow_forwardPLEASE USE SIMPLEX METHOD. Thank you! Manufacturer of bicycles builds racing, touring, and mountain models. The bicycles are made of both aluminum and steel. The company has available 9793 units of steel and 7430 units of aluminum. The racing, touring, and mountain models need 16, 13, and 18 units of steel and 15,9, 14 units of aluminum, respectively. The company makes a profit of $22 per racing bike, $38 per touring bike and $24 per mountain bike. Assume that the company wants to maximize their profit, what is the schedule and the optimum solution,Manufacturer of bicycles builds racing, touring, and mountain models. The bicycles are made of both aluminum and steel. The company has available 9793 units of steel and 7430 units of aluminum. The racing, touring, and mountain models need 16, 13, and 18 units of steel and 15, 9, 14 units of aluminum, respectively. The company makes a profit of $22 per racing bike, $38 per touring bike and $24 per mountain bike. Assume that the company…arrow_forward
- In linear programming problems, you always need to include a(n) ___________ constraint, to ensure that all decision variables are greater than or equal to 0. Group of answer choices positive time production non-negativityarrow_forwardYou are required to create the following tables in a database named STUDENT_REGISTRATIONS. Ensure that you create the database and table objects exactly as depicted below. STUDENTS STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY STUDENT_NAME VARCHAR(40) NOT NULL STUDENT_SURNAME VARCHAR(40) NOT NULL MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY MODULE_NAME VARCHAR(40) NOT NULL MODULE_CREDIT SMALLINT NOT NULL STUDENT_MODULES STUDENT_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES STUDENTS(STUDENT_ID) MODULE ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURERS LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY LECTURER_NAME VARCHAR(40) NOT NULL LECTURER_SURNAME VARCHAR(40) NOT NULL O The Independent Institute of Education (Pty) Ltd 2021 Page 3 of 10 19, 20; 21 2021 LECTURER_MODULES MODULE_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES MODULES(MODULE_ID) LECTURER_ID VARCHAR(8) NOT NULL PRIMARY KEY FOREIGN KEY REFERENCES LECTURERS(LECTURER_ID)arrow_forwardA firm is planning to spend $75,000 on advertising. It costs $3000 per minute to advertise on television and $1000 per minute to advertise on radio. If the firm buys X minutes of television advertising and Y minutes of radio advertising, its revenue in thousands of dollars is given by -0.3x^2-0.4y^2+0.8xy+5x+10y. How can the firm maximize its revenue? Formulate the written model and solver model.arrow_forward
- ythos.content.blackboardcdn.com/5c1c67a3c99fc/2929686?X-Blackboard-Expiration=D1606219200000&X 1/ 1 QUESTION 1 Swearingen and McDonald, a small furniture manufacturer, produces fine hardwood tables and chairs. Each product must go through three stages of the manufacturing process: assembly, finishing, and inspection. Each table requires 12 hours of assembly, 20 hours of finishing, and 2 hours of inspection. Each chair requires 4 hours of assembly, 16 hours of finishing, and 3 hours of inspection. The profit per table is $150 while the profit per chair is $100. Currently, each week there are 300 hours of assembly time available, 220 hours of finishing time, and 30 hours of inspection time. To keep a balance, the number of chairs produced should be at least twice the number of tables. Also, the number of chairs cannot exceed 6 times the number of tables. (You may use QM-software for this problem. All the detailed output should be displayed). a) Formulate this as a linear programming…arrow_forwardSelect the least accurate statement regarding RISKSIMTABLE. RISKSIMTABLE is a feature that is included in Excel. RISKSIMTABLE is helpful for automating the process of running multiple simulations with different input values. One difference between the RISKSIMTABLE functionality and the data table functionality is that it runs a simulation for each input value and data table does not. O When multiple simulation runs are specified, the RISKSIMTABLE function is used to control in the value of a particular input cell that is used for each simulation. O The RISKSIMTABLE function is inserted into a cell with an input value and points to a range of values that the input value will take on.arrow_forwardThis section contains questions regarding the 2nd part of the Unit 1 with the following topics: 1. Financial Planning2. Savings and budgeting3. Investing 1.Mutual Fund is when an investor directly acquires a claim on a security or property True False 2. The "Rule of 75" is used to determine the number of yearss needed to double the value of your money * True Falsearrow_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,