Sales of Orange computer have grown steadily during the past 5 years: Year Sales 1 450 2 295 3 518 4 563 5 584 6 ? My sales manager had predicted, before the business started, that year 1’s sales would be 410 computers. What are required: Develop forecasts for years 2 through 6 by using exponential smoothing with a weight of alpha = 0.30 Develop forecasts for the sales of Orange computers by using smoothing constants of 0.6 and 0.9 Help me to propose the most accurate forecast in smoothing constant, based on forecast at no.2 above. Help me to critically evaluate the effect that the smoothing constant have on the forecast for Orange computers.

Sales of Orange computer have grown steadily during the past 5 years: Year Sales 1 450 2 295 3 518 4 563 5 584 6 ? My sales manager had predicted, before the business started, that year 1’s sales would be 410 computers. What are required: Develop forecasts for years 2 through 6 by using exponential smoothing with a weight of alpha = 0.30 Develop forecasts for the sales of Orange computers by using smoothing constants of 0.6 and 0.9 Help me to propose the most accurate forecast in smoothing constant, based on forecast at no.2 above. Help me to critically evaluate the effect that the smoothing constant have on the forecast for Orange computers.

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 2. 3 4 Requests: 28 30 22 29 30 Predict the number of requests for week 6 using each of these methods: a. Naive Number of requests 30 b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests c. Exponential smoothing with a = 10. Use 28 for week 2 forecast. (Round your intermediate forecast values and finel answer to 2 decimal places.) Number of Requests F3 F4 F5 F6
Consider the following data: Monthly Profit of a Gym Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 6,090 Month Jan-12 Profit ($) 6,500 6.253 5,514 5,357 5,425 6,278 8,119 6,390 Step 3 of 5: Determine the exponentially smoothed forecast for the next time period using a smoothing constant, a, of 0.35. If necessary, round your answer to one decimal place.
Please please solve all parts of the question. Thank you so much.
Below is data collected over 6 specific years. The data collected is the Consumer Price Index (CPI) and the cost of a slice of tuna. We would like to build a model using the CPI to predict the cost of a slice of pizza in a given year. Year 1960 1973 1986 1995 2002 2003 CPI (x) 30.2 48.3 112.3 162.2 191.9 197.8 Cost of a slice of tuna(y) 0.15 0.35 1.00 1.25 1.75 2.00 Plot the data. Are we justified in creating a Linear Regression model to predict the price of a pizza slice using the CPI? Why or why not? Calculate the descriptive statistics. Calculate the sums of squares Calculate the slope, intercept, and correlation. What is this correlation value telling us? Assemble the prediction equation, and interpret the slope within the context of the problem. State the hypotheses for the hypothesis test for regression.
Consider the following data: Month Jan-14 Feb-14 Profit ($) 16,113 16,263 Monthly Profit of an Auto Repair Shop Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 15,055 17,117 18,763 17,210 19,141 18,468 20,254 Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.35. If necessary, round your answer to one decimal place.
You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.) Year Amazon Return Microsoft Return 2013 0.5896 0.1221 2014 -0.2218 0.2416 2015 1.1778 0.1944 2016 0.1095 0.1200 2017 0.5596 0.3766 2018 0.2843 0.1874 2019 0.3216 0.5526 You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns?
If actual period demand varies from the forecast by more than 3MAD, this indicates: there is 3% chance that the forecast is wrong. there is a 98% chance that the forecast is wrong. there is a 97% chance that the forecast is wrong. there is a 3% chance that the forecast is correct Moving to the next question prevents changes to this answer:
1 - A simple exponential smoothing model has a current mean of 156.8. Assuming demand for next period is 170, update the value of the smoothing statistic. Let a = 0.1. 2- An electronics company has sold 145, 157, 124, 169,179, 201, 197, and 230 units of a certain stereo system quarterly for the past two years. Plot the data and fit an appropriate model. Forecast sales for the next two quarters.
Given the following data, use exponential smoothing with α=0.1 and α=0.6 to generate forecasts for periods 2 through 6. Use Mad and MEE to decide which of the two models produce a netter forecast. (Assume the forecast for Period 1 is 17) Period Actual Forecast 1 14 17 2 16 3 16 4 11 5 12 6 17 a.What is the forecast for Period 6 when you use α=0.6? (Express it to 2 decimal places) Answer: b.What is the value of Mean Absolute Deviation (MAD) when α=0.6? Calculate to 3 decimal places. (Use all forecasted values from Period 1 to Period 6.) Answer: c.Which method produces a better forecast? (Use all forecasted values from Period 1 to Period 6.) Select one: α=0.1 produces a better forecast measured both by MAD and MSE. When we use MAD, α=0.1 produces a better forecast. When we use MSE, α=0.1 produces a better forecast. α=0.6 produces a better forecast measured both by MAD and MSE.
The number of banks in a country has been dropping steadily since 1984, and the trend in recent years has been roughly linear. The annual data for the years 1999 through 2008 can be summarized as follows, where x represents the years since 1990 and y the number of banks, in thousands. n=10 Ex-235 ²-5605 Ey-77.564 Ey²=603.80424 Exy-1810.155 a. Find an equation for the least squares line. b. Use your result from part a to predict the number of banks in the year 2020. c. If this trend continues linearly, in what year will the number of banks drop below 6200? d. Find and interpret the correlation coefficient.
Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes
Table 3 gives the market value of a luxury sedan (in dollars) xyears after its purchase. Find an exponential regression model of the form y= ab* for this data set. Estimate the purchase price of the sedan. Estimate the value of the sedan 10 years after its purchase. Round answers to the nearest dollar. TABLE 3 Value ($) 1 23,125 19,050 3 15,625 11,875 5 9,450 6 7,125 2.