Practical Management Science
5th Edition
ISBN: 9781305250901
Author: Wayne L. Winston, S. Christian Albright
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 8.8, Problem 15P
Summary Introduction
To interpret: The four clusters in which the top 25 schools were divided.
Introduction: The variation between the present value of the
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
48.
Because of excessive pollution on the Momiss River, the state of Momiss is going to build some pollution control stations. Three sites are under consideration. Momiss is interested in controlling the pollution levels of two pollutants. The state legislature requires that at least 100,000 tons of pollutant 1 and at least 80,000 tons of pollutant 2 be removed from the river. The relevant data for this problem are shown in the file P06_48.xlsx. The last two rows indicate the number of tons of pollutants removed per ton treated.
a. Determine how to minimize the cost of meeting the state legislature’s goals.
b. Use SolverTable to analyze how a change in the requirement for pollutant 1 changes the optimal solution. Do the same for pollutant 2.
SOLVE STEP BY STEP IN DIGITAL FORMAT
A company that manufactures household appliances carries out its strategic planning with its main suppliers of raw materials. To do this, you must make a sales projection for the next month, since the prices you obtain depend on the volume that is manufactured. Historical sales data for the last 12 months of 20XX are given below in millions of dollars. 10.5, 9.4, 8.5, 9.8, 11.1, 9.2, 9.7, 10.3, 7.5, 8.7, 9.0, 9.1.
a. Lists the time series components present in the company's sales.
b. Forecast the first month of the year 20XY with the moving average technique with k= 2.
c. Forecast sales for the first month of the year 20XY using the simple average technique.
d. Write the strategies that the appliance manufacturer must implement with suppliers.
An investment manager is considering stocks X1, X2, and X3 for investment. Market research shows the following information (per stock)
X1
X2
X3
cost $100
risk measure 8
price annual growth rate: 9%
annual return: $14
cost $120
risk measure 10
price annual growth rate: 13%
annual return: $15
cost $80
risk measure 7
price annual growth rate: 8%
annual return: $20
Based on his experience, the manager has set the following priorities for the investment:
(1) The total amount invested should be at least $90,000. (d1)
(2) The minimum annual average growth rate in stock prices is 12%. (d2)
(3) The risk factor of all stocks should not exceed a total of 5,000. (d3)
(4) The total annual return should be $15,000. (d4)
The constraint for the annual growth rate can be written as:
9X1 + 13X2 + 8X3 ≥ 12
[(9X1 + 13X2 + 8 X3)/(X1+ X2+ X3)] + d2- - d2+ ≥ 12
[(9X1 + 13X2 + 8X3)/(X1+ X2+ X3)] + d2- - d2+ ≤ 0
-3X1+ X2 - 4X3 + d2- - d2+ ≥ 12
-3X1 +…
Chapter 8 Solutions
Practical Management Science
Ch. 8.3 - Prob. 1PCh. 8.3 - Prob. 2PCh. 8.4 - Prob. 3PCh. 8.4 - Prob. 4PCh. 8.4 - Prob. 5PCh. 8.5 - Prob. 6PCh. 8.5 - Prob. 7PCh. 8.5 - In the lawn mower production problem in Example...Ch. 8.6 - Prob. 9PCh. 8.6 - Prob. 10P
Ch. 8.6 - Prob. 11PCh. 8.6 - Prob. 12PCh. 8.7 - Prob. 13PCh. 8.7 - Prob. 14PCh. 8.8 - Prob. 15PCh. 8.9 - Prob. 17PCh. 8.9 - Prob. 18PCh. 8.10 - Prob. 20PCh. 8.10 - Prob. 21PCh. 8.10 - Prob. 22PCh. 8.10 - Prob. 23PCh. 8.10 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Prob. 29PCh. 8 - Prob. 30PCh. 8 - Prob. 31PCh. 8 - Prob. 32PCh. 8 - Prob. 33PCh. 8 - Prob. 34PCh. 8 - Prob. 35PCh. 8 - Prob. 36PCh. 8 - Prob. 37PCh. 8 - Prob. 38PCh. 8 - Prob. 39PCh. 8 - Prob. 40PCh. 8 - Prob. 41PCh. 8 - Prob. 42PCh. 8 - Prob. 43PCh. 8 - Prob. 44PCh. 8 - Prob. 46PCh. 8 - Prob. 1CCh. 8 - Prob. 2C
Knowledge Booster
Similar questions
- The file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year period. a. Fit an exponential trend line to these data. b. By what percentage do you estimate that the company will grow each month? c. Why cant a high rate of exponential growth continue for a long time? d. Rather than an exponential curve, what type of curve might better represent the growth of a new technology?arrow_forwardYou 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_forwardAssume “Jane” saves $10,000 per year for 10 years starting at age 25. At age 35 she no longer is able to save but leaves her accumulated savings invested until age 65 when she retires. Assume “John” does not begin saving until age 35, but then saves $10,000 per year until age 65 when he also retires. Assume John and Jane invest their entire wealth in the same mutual fund. Who accumulates a larger retirement nest egg? 1. Answer this question by building an Excel spreadsheet that allows you to show the difference in wealth at age 65 assuming an annual rate of return of 8%. Make sure your model allows you to change the assumed rate of return and automatically recalculate the difference in wealth at age 65. 2. At what assumed rate of return are John and Jane’s wealth at age 65 equal? Use “Goal Seek” in order to find this rate of return. 3. Create a graph to clearly show how final wealth for John and Jane depends on the rate of return. Start at 0% and increase the rate of return in…arrow_forward
- Three types of gasoline are manufactured by a company – Regular, Super, and Extra. Regular should have at least 11percent additive 1 and 17 percent additive 2. Super should have at least 13 percent additive 1 and 22 percent additive 2. Extra should have at least 17 percent additive 1 and 19 percent additive 2. These are made by using two crudes – A and B. Crude A cost $28 per barrel and is 14 percent additive 1 and 18 percent additive 2. Crude B costs $30 per barrel and is 20 percent additive 1 and 24 percent additive 2. The demand for Regular is projected to be 1,000 barrels, while each of the others has a demand of 2,000 barrels. Formulate this as a linear programming problem to minimize cost while meeting all constraints. Remember to carefully define all decision variables and do not forget to indicate the optimal answer! (Blending application)arrow_forwardDataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price change on a software product. Currently, 40,000 units of the product are sold each week for $45 apiece. The variable cost of the product is $5. The most likely case appears to be that a $10 rebate will increase sales 30%, and half of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 20%.a. Given all other assumptions, what increase in sales from the rebate would make the rebate and price cut equally desirable?b. Dataware does not really know the increase in sales that will result from a rebate or price cut. However, the company is sure that the rebate will increase sales by between 15% and 40% and that the price cut will increase sales by between 10% and 30%. Perform a sensitivity analysis (two-way data table) that could be used to help determine Dataware’s best decision.arrow_forwardLINGO SOFTWARE Consider a production-mix problem where we are concerned with what mix of four products we should produce during the upcoming week. For each product, each unit produced requires a known amount of production time on each of the three machines. Each machine has a certain number of hours of production time available per week. Each product provides a certain profit per unit produced. Figure 3S1.2 shows three types of data: machine-related data, product-related data, and data related to combinations of a machine and product. The objective is to determine how much to produce for each product so that total profit is maximized while not exceeding the limited production capacity of each machine. Requirement: Solve this problem in LINGO software.arrow_forward
arrow_back_ios
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,