Registration numbers for an accounting seminar over the past 10 weeks are shown below: Week 1...
Registration numbers for an accounting seminar over the past 10 weeks are shown below:
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Registration | 22 | 21 | 25 | 27 | 35 | 29 | 33 | 37 |
Forecast registration for weeks 5 thru 8 using a 3-week moving average?
Forecast registrations weeks 5-8 using a 3-week weighted moving average with weights of .5 , .3 , and 2. with the most weight going to the most recent data?
which forecasts are more accurate using MAD?
Show your work please
Homework Answers
Add Answer to:
Registration numbers for an accounting seminar over the past 10
weeks are shown below:
Week
1...
Data collected on the yearly registrations to Sigma seminar at the Quality College are shown in the following table:
Data collected on the yearly registrations to Sigma seminar at the Quality College are shown in the following table: a) Develop a 3-year moving average to forecast registrations from year 4 to year 12. b) Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1. c) Graph the original data and...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week >WN Unit Sold 523 587 622 601...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week UWN Unit Sold 523 587 622 601...
The details of the hard drive sales for the past 6 weeks are shown in the...
The details of the hard drive sales for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. You have been told to use 2 period weighted moving average estimation technique to help in forecasting the needs for next week. (k =2 with weights 0.8, 0.2) Week Units sold 88 44 54 65 572 6 85 You are being asked to help forecast for week 7,...
Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially...
Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Calculate the three-period moving-average forecast for periods 4 through 10. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure...
11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table sum...
11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...
Chapter 4 Forecasting Homework Assignment Daily high temperatures in St. Louis for the last week were...
Chapter 4 Forecasting Homework Assignment Daily high temperatures in St. Louis for the last week were as follows: 34, 36, 37, 39, 35, 32, and 36 (yesterday). Forecast the high temperature today, using a 3-day moving average. Forecast the high temperature today, using a 2-day moving average. For questions c-e use all the days where a 3-day forecast value is possible. Calculate the mean absolute deviation based on a 3-day moving average. Compute the mean squared error for the 3-day...
The following table gives the number of pints of type A blood used at Damascus Hospital...
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
a) The forecasted demand for the week of October 12 using a
3-week moving average =_________ pints...
During the past five months the emergency room at the new district Hospital has observed the...
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. Week No of Patients 105 119 122 128 117 136 141 126 143 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. (4 marks) b) What...
please i need asap answer 1. Given the data below, compute for the following: a) Forecasts...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week >WN Unit Sold 523 587 622 601...
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week UWN Unit Sold 523 587 622 601...
The details of the hard drive sales for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. You have been told to use 2 period weighted moving average estimation technique to help in forecasting the needs for next week. (k =2 with weights 0.8, 0.2) Week Units sold 88 44 54 65 572 6 85 You are being asked to help forecast for week 7,...
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
The following table gives the number of pints of type A blood
used at Damascus Hospital in the past 6 weeks:
a) The forecasted demand for the week of October 12 using a
3-week moving average =_________ pints...
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. Week No of Patients 105 119 122 128 117 136 141 126 143 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. (4 marks) b) What...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago