Homework Answers
(a)
(i)
Moving average is the average of last four months Value.
MAD = (1/N) 
(Forecast -
Actual)
Forecast for Jan 2019 is 51
MAD = 28.28125
(ii)
The forecast for the month is the average of the past four months with averages of 04,0.3,0.2 and 0.1 weights.
MAD = 23.00
Jan 2019 Forecast =66.2
Add Answer to:
You are an operation manager at Gambas Berhad. You plan to use several forecasting methods for...
Here are the actual tabulated demands for an item for a nine-month period (January through September)....
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...
DEMAND FORECASTING CASE STUDY You have been hired as a demand planning intern for the Maui...
DEMAND FORECASTING CASE STUDY You have been hired as a demand planning intern for the Maui Jim Inc. They want you to develop a forecast for their Longboard style of sunglasses. The goal is to determine how many pair they will produce to meet vendor demand ir first meeting, you were handed some data to work with and e about the company's upcoming promotional blitz to support Spring Break '19 in major vacation destinations. 9. During your am talked Month...
You want to compare how two forecasting methods would perform on some historical sales data. You...
You want to compare how two forecasting methods would perform on
some historical sales data. You will forecast the sales for months
4 through 19, calculate the mean absolute deviation (MAD) for both
methods, and you can claim that the one that has lower MAD
performed better, at least for the historical data.
a) The first method is known as the moving average method. The
forecast for a month will be the average sales of three previous
months. So, forecast...
A stock technical analyst uses smoothing methods to predict stock prices. The following table contains the...
A stock technical analyst uses smoothing methods to predict stock prices. The following table contains the monthly price information for Walmart. Date Price 11/30/2018 95.62 12/31/2018 91.71 1/31/2019 94.35 2/28/2019 97.46 3/29/2019 96.54 4/30/2019 101.80 5/31/2019 100.94 6/28/2019 109.95 7/31/2019 109.84 8/30/2019 114.26 9/30/2019 118.68 10/31/2019 117.26 What is the predicted share price for August 30, 2019 if this technical analyst uses an exponential smoothing method with a smoothing constant of .7 and a 5-month moving average as the initial...
A stock technical analyst uses smoothing methods to predict stock prices. The following table contains the...
A stock technical analyst uses smoothing methods to predict stock prices. The following table contains the monthly price information for Walmart. Date Price 11/30/2018 95.62 12/31/2018 91.71 1/31/2019 94.35 2/28/2019 97.46 3/29/2019 96.54 4/30/2019 101.80 5/31/2019 100.94 6/28/2019 109.95 7/31/2019 109.84 8/30/2019 114.26 9/30/2019 118.68 10/31/2019 117.26 What is the predicted share price for August 30, 2019 if this technical analyst uses an exponential smoothing method with a smoothing constant of .7 and a 5-month moving average as the initial...
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...
The manager of a travel agency asked you to come up with a forecasting technique that...
The manager of a travel agency asked you to come up with a forecasting technique that will best fit to the actual demand for packaged tours. You have observed and recorded the actual demand for the last 10 periods. You also identified two possible techniques for consideration: 2-month moving averages (F1), and exponential smoothing (F2) with a smoothing constant of 0.40. Using Cumulative Forecasting Error (CFE) and Mean Absolute Deviation (MAD) as your performance measures you will determine the technique...
b) In your opinion, which one is most critical in a retail sales environment and why?...
b) In your opinion, which one is most critical in a retail sales environment and why? (3.5 marks) Q 2 (10 marks) A car parts manufacturer has had monthly sales for a five-month period as follows: Sales (000 units) Month January February March April May Forecast June's sales volume, using cach of the following: i. A four-month moving average (2 Marks) ii. Exponential smooth with a smoothing constant of 0.10, assuming a February forecast of 19(000). (2 Marks) iii. The...
Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
DEMAND FORECASTING CASE STUDY You have been hired as a demand planning intern for the Maui Jim Inc. They want you to develop a forecast for their Longboard style of sunglasses. The goal is to determine how many pair they will produce to meet vendor demand ir first meeting, you were handed some data to work with and e about the company's upcoming promotional blitz to support Spring Break '19 in major vacation destinations. 9. During your am talked Month...
You want to compare how two forecasting methods would perform on
some historical sales data. You will forecast the sales for months
4 through 19, calculate the mean absolute deviation (MAD) for both
methods, and you can claim that the one that has lower MAD
performed better, at least for the historical data.
a) The first method is known as the moving average method. The
forecast for a month will be the average sales of three previous
months. So, forecast...
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...
b) In your opinion, which one is most critical in a retail sales environment and why? (3.5 marks) Q 2 (10 marks) A car parts manufacturer has had monthly sales for a five-month period as follows: Sales (000 units) Month January February March April May Forecast June's sales volume, using cach of the following: i. A four-month moving average (2 Marks) ii. Exponential smooth with a smoothing constant of 0.10, assuming a February forecast of 19(000). (2 Marks) iii. The...
Please help with questions 7 - 10.
PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
Most questions answered within 3 hours.
-
Why does Max Weber distinguish between "power," "authority," and
different types of authority? What is he...
asked 2 minutes from now -
What would the solow growth model look like if there was a
production function which had...
asked 2 minutes ago -
A company project has an initial cost of $40,000, expected net
cash flows of $9,000 per...
asked 4 minutes ago -
How do you use strategy in your current position or how does
your current position align...
asked 6 minutes ago -
a person's ability to be properly diagnosed with a
disease/condition can be affected by the person;s...
asked 6 minutes ago -
John needs 40 Eternal Light flashlights. Each Eternal Light
flashlight requires 3 bulbs, and each bulb...
asked 14 minutes ago -
1) If Nominal GDP is $16,000 billion and the GDP deflator is 50,
then Real GDP...
asked 20 minutes ago -
D. A student completed 20 courses in the School of Arts and
Sciences. Her grades in...
asked 2 hours ago -
teo
pucks moving on a frictionless air table are about to collide. the
1.5 kg puck...
asked 2 hours ago -
Problem #1
The area between Z = 0 and Z = 2.50
The area between Z...
asked 3 hours ago -
1. What is the meaning of the term communication style?
2. What are the benefits to...
asked 3 hours ago -
9.) You are buying a car that cost $26,500. You make payments of
$412 each month...
asked 3 hours ago