Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Chapter 14.3, 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
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.
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.
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
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_forwardThe file P13_03.xlsx contains monthly data on production levels and production costs during a four-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced. Use the resulting equation to predict total cost in month 49, given that the proposed production level for that month is 450 units. Do you see anything wrong with the analysis? How should you modify your analysis if your main task is to find an equation useful for predicting future costs, and you know that the company installed new machinery at the end of month 18? Write a concise memo to management that describes your findings.arrow_forwardThe 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.arrow_forward
- 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…arrow_forwardA golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales. Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best? Interpret your best-fitting equation. Using the best-fitting equation, predict sales during a month in which the price is $470. File data: Price Demand $400 20,000 $420 19,000 $440 17,000 $460 16,000 $500 14,000 $380 22,000 $290 31,000 $340 26,000 $220 41,000 $700 6,000arrow_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
- Which of the following statements is not true? Group of answer choices An transshipment problem is a special case of a transportation problem in which all supplies and all demands are equal to 1. Transshipment problems can also be solved by general purpose linear programming codes. Transshipment problems are transportation problems in which a shipment may move through intermediate nodes before reaching a particular destination node. Transshipment problems can be converted to larger transportation problems and solved by a special transportation program.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
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,