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.

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.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.3: Simple Regression Models

Problem 7P

See similar textbooks

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?
The 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.
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.
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 rates
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
I 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…
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…
I 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…
Long-Life Insurance developed a linear model to determine the amount of term life insurance a family of four should have, based on the head of the household's current age. The equation is: y = 163 -0.45xwherey = Insurance needed ($000)x = Current age of head of household Calculate the amount of term life insurance you would recommend for a family of four if the head of the household is 53 years old. (Round your answer to 2 decimal places.)
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).
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?
The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?