Do question 5 please.
Use exponential smoothing with a=.2 to forecast battery sales. Assume the forecast for January was 22 batteries
Month Battery Sales for cars
January 20
Feb 21
March 15
April 14
Homework Answers
as for exponential smoothing:
forecast =alpha*last period actual+(1-alpha)*last period forecast
| period | actual | Forecast |
| Jan | 20 | 22.00 |
| Feb | 21 | 21.60 |
| Mar | 15 | 21.48 |
| Apr | 14 | 20.18 |
| May | 18.95 |
forecasted battery sales for MAy =18.95
Add Answer to:
Do question 5 please. Use exponential smoothing with a=.2 to forecast battery sales. Assume the forecast for January was 22 batteries Month Battery Sales for cars January 20 Feb 21 March 15 April 14...
1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery...
1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery Sales 17 18 20 20 21 23 Month Month anuary ebruary March pril May uly ugust eptember tober November une ecember a. Develop a three-month moving average b. Compute MAD Q.2 Usesimple exponential smoothing with a 0.33 to forecast the tire sales for February through May. Assume that the forecast for January was for 22 sets of tires Solve these both Qs Displaying 1...
The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16,...
The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar...
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...
1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...
1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...
2. The historical demand for a product is below. Please forecast the demand in April. Month...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)
2. The historical demand for a product is below. Please forecast the demand in April. Month...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)
Use the following sales data to answer the questions. Month Sales January 
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May...
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...
Omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a....
omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as...
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows:...
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Jan Feb Mar Apr May June July Aug Sep Oct Demand 46 47 50 49 50 48 51 49 52 53 Nov. Dec. 52 54 C. Forecast next year January sales using the following methods: I. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use a = 0.2, B = 0.3, for the month...
1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery Sales 17 18 20 20 21 23 Month Month anuary ebruary March pril May uly ugust eptember tober November une ecember a. Develop a three-month moving average b. Compute MAD Q.2 Usesimple exponential smoothing with a 0.33 to forecast the tire sales for February through May. Assume that the forecast for January was for 22 sets of tires Solve these both Qs Displaying 1...
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...
omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as...
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Jan Feb Mar Apr May June July Aug Sep Oct Demand 46 47 50 49 50 48 51 49 52 53 Nov. Dec. 52 54 C. Forecast next year January sales using the following methods: I. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use a = 0.2, B = 0.3, for the month...
Most questions answered within 3 hours.
-
A square current loop 5.4 cm on each side carries a 510 mA
current. The loop...
asked 23 minutes ago -
What are five tips in conducting knowledge assessment/literature
review research? Each of these tips needs to...
asked 59 minutes ago -
Antigen presenting cells link innate and adaptive immune
responses. In the theoretical scenario where phagosomes cannot...
asked 1 hour ago -
Dealing with conflict, in my opinion, is a skill and an art. I
believe that those...
asked 1 hour ago -
6. A long straight wire with circular cross section and radius
1.5 cm carries a 1.2...
asked 1 hour ago -
Deacon Corporation has provided the following financial data
from its balance sheet and income statement:
Year...
asked 2 hours ago -
List and discuss at least three variables from everyday life for
which you expect the variable ...
asked 2 hours ago -
A high-pass filter consists of a 1.60 μF capacitor in series
with a 125 Ω resistor....
asked 2 hours ago -
A newly developed artificial intelligence has trouble
distinguishing hand-written numbers from hand-written alphabets.
There are pictures...
asked 2 hours ago -
The carbonate ion CO3 2- has multiple resonance structures.
a. Draw them and assign the hybridization...
asked 2 hours ago -
In doing an allocation for a basket purchase
Use the individual costs and the total market...
asked 2 hours ago -
what were the social political and economic causes and impacts of
the late 19th century urban...
asked 2 hours ago