Question: 1. Use the following actual demand data to develop a forecast as follows: (a) Develop three-period moving-average forecasts for periods 4 to 12. (b) Develop

1. Use the following actual demand data to develop a forecast as follows: (a) Develop three-period moving-average forecasts for periods 4 to 12. (b) Develop a single exponential smoothing forecast with 01 = 0.40 for Period 12. Assume the forecast for Period 1 is 800. (c) Calculate MAD and MAPE for (a) and (b). ((1) Find the optimal value for 01 such that it minimizes the MAPE forecast error. Period Demand Period Demand 1 910 l l 7 886 2 790 l l 8 935 3 1035 l l 9 815 4 820 10 1030 5 955 1 1 950 6 1050 l l 12 1 100 (15 Points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

anwser the three questions pls For problems 1 through 3, use the following time series data: 1. () Develop a three-period moving average forecast for periods 13-15. 2. (*) Develop a two-period...

rn The Brazen Head restaurant is a 180-seat restaurant. Assume that you are forecasting for Sunday 9/3 and that the following is the covers served data for the last six Sundays (note: the restaurant...

For problems 1 through 3 , use the following time series data: \ table [ [ PERIOD , DEMAND ] , [ 1 0 , 2 4 8 ] , [ 1 1 , 3 7 0 ] , [ 1 2 , 4 2 4 ] , [ 1 3 , 2 8 6 ] , [ 1 4 , 4 4 4 ] ] ( * ) Develop...

. Efficient operations require that managers match supply to demand. As they lack a crystal ball, they must rely on forecasting to help predict future demand. Forecasts then drive decisions regarding...

please show references for formulas please i am stuck on figuring this problem out Problem 1 (Comparison of 4 Methods) (10 points) Your forecasting team is trying to determine what forecasting method...

The following data represent enrollment in a major at your university for the past six semesters. (Note: Semester 1 is the oldest data; semester 6 is the most recent data.) Semester Enrollment 1 87 2...

20 Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. a...

For Questions 3 and 4, use the following time series data: MONTH DEMAND 1 221 2 232 3 223 4 248 5 223 6 230 7 313 8 305 9 319 10 313 11 294 12 322 Question 3(10 points) Develop a three-period moving...

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. ACTUAL...

Suppose you (or your group) are the manager of a company trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecasts for each given...

The new sewing machine would be depreciated according to the declining-balance method at a rate of 20%. The salvage value is expected to be $380,900. This new equipment would require maintenance...

Courtney wants to sell her grandfather's antique 1932 Ford. She begins to set her price by looking at ads and finds these prices: $24,600, $19,000, $33,000, $15,000, and 20,000. What is the mean...

7. Two stockbrokers are having a discussion. One claims that Netmark will introduce a new product if and only if both Datapro cuts its work force and Compucel expands production. The other claims...

Romero issues $3,400,000 of 10%, 10-year bonds dated January 1, 2020, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $3,010,000. Required 1. Prepare the...