Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7.8, Problem 43P
Given the data in the file Stock Beta.xlsx, estimate the beta (and alpha) for Microsoft (MSFT). Do this for each criterion to obtain a table analogous to that in the top right of Figure 7.49. What do you conclude about Microsoft?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A 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,000
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.
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.
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
- 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_forwardSometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)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_forward
- Paraphrase this one. Analyze and elaborate in 120 words. Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include: Weather data Rainfall measurements Temperature readings Heart rate monitoring (EKG) Brain monitoring (EEG) Quarterly sales Stock prices Automated stock trading Industry forecasts Interest ratesarrow_forwardStocks with high market betas have higher expected returns than stocks with low market betas. This evidence is inconsistent withI. The weak form efficient market hypothesisII. The semi-strong form efficient market hypothesisIII. The strong form efficient market hypothesis a) I, II, and III b) I and II c) I d) None of I, II, and IIIarrow_forwardWhich of the following statements is correct for the Black-Scholes model? A) The price of an American call written on a stock is: c = SN(d1)-Ke-rTN(d2) B) The stock price at a future point in time follows a log-normal distribution. C) The continuously compounded return on the stock follows a log-normal distribution. D) Black-Scholes prices may allow for arbitrage opportunities. Please explain and justify your choice.arrow_forward
- A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?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 major source of revenue in Texas is a state sales tax on certain types of goodsand services. Data are compiled and the state comptroller uses them to project future revenuesfor the state budget. One particular category of goods is classified as Retail Trade. Four years ofquarterly data (in $millions) for one particular area of southeast Texas follow:Quarter Year 1 Year 2 Year 3 Year 41 218 225 234 2502 247 254 265 2833 243 255 264 2894 292 299 327 356Compute the Q1, Q2, Q3, & Q4 forecasts for Year 5 given the fact that this data is known to beaffected by: Irregular effects Seasonal effects Trending effectsarrow_forward
- The relationship between marketing expenditures (x) and sales (y) is given by the following formula, y = 9x − 0.05x2 + 9. (Hint: Use the Nonlinear Solver tool). What level of marketing expenditure will maximize sales? (Round your answer to 2 decimal places.) What is the maximum sales value? (Round your answer to 2 decimal places.)arrow_forwardWhich of the following statements are correct? [Select multiple answers] Income gap ratio (IGR) is the total income needed to eliminate poverty relative to the available resources. Poverty gap ratio (PGR) is the total income needed to eliminate poverty divided by the total income in the economy. Total poverty gap (TPG) provides a comprehensive picture of poverty including the severity of poverty since it tells us the total money that is needed to bring everyone to the poverty line. The Foster-Greer-Thorbecke (FGT) measures with values of alpha = {0,1,2} provide a comprehensive picture of poverty.arrow_forwardI need help with d, e, and f. I already did a, b, and c. You do not need to use Solver or solve the problems. Just respond to the problem questions using the outputs provided in the problem. A picture in the attach image is a complete question. 1. Recall the Innis Investments problem (Chapter 2, Problem 39). Letting S= units purchased in the stock fund M= units purchased in the money market fund leads to the following formulation: Min 8S + 3M s.t. 50S + 100M≤ 1,200,000 funds available 5S + 4M≥ 60,000 Annual income M≥ 3,000 Units in money market S, M≥ 0 a. What is the optimal solution, and what is the minimum total risk? Already did this part b. Specify the objective coefficient ranges. Already did this part c. How much annual income will be earned by the portfolio? I also did this part too d. What is the rate of return for the portfolio? e. What is the dual value for the funds available constraint? f. What is the marginal rate of…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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License