Question: Using the data set below, what would be the forecast for period 5 using the exponential smoothing method? Assume the forecast for period 4

Using the data set below, what would be the forecast for period

Using the data set below, what would be the forecast for period 5 using the exponential smoothing method? Assume the forecast for period 4 is 14000. Use a smoothing constant of a = 0.4 Please submit your worksheet showing the calculation method Period 1 2 3 4 5 6 Actual Demand 10000 12400 13250 14750 15220 18500

Step by Step Solution

★★★★★

3.41 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Calculate the forecast for period 3 using the exponential smoothing formula Forecast 3 Actual Dema... View full answer

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 Accounting Questions!

Ellison Company's balance sheet shows: Common stock, $20 par $2,900,000 Paid-in capital in excess of par 1,040,000 Retained earnings 700,000 Record the following transactions by the cost method....

The data set below shows midterm scores from an Introductory Statistics course. a) Fit a model predicting the second midterm score from the first. b) Comment on the model you found, including a...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Medical researchers have noted that adolescent females are much more likely to deliver low birth weight babies than are adult females. Because low birth weight babies have a higher mortality rate, a...

a. Prepare a plot of the CPI data. Based on this plot, which of the time series forecasting techniques covered in this chapter would not be appropriate for forecasting this time series? b. Apply...

The file P14_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of...

Denton Pet Clinic is a small business owned by two veternarians who employ two full-time staff members and a new part-time busi- ness manager. The business manager believes that Denton could save...

The file P14_32.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of...

In a study of iron catalysts, the BET surface areas of a number of materials were determined using N2 or Ar physisorption near 80 K [7173]. The Po values vary slightly because the bath temperature...

Refer to Integrative Case 9-48 in Chapter 9. Assume that all of the facts in Case 9-48 still hold except that the practical capacity of the machinery is 20,000 hours instead of 10,000 hours. Required...

International Foods Corporation, a U.S.-based food company, is considering expanding its soup-processing operations in Switzerland. The company plans a net investment of $8 million in the project....

Grant wants to make meatballs for pasta supper. He needs to defrost 1.56 kg of ground beef .It takes 12 minutes to defrost 2 Lbs of meat, How long will it take for gran's1.56 kg of ground beef to...

Exercise Set 3.2 In Exercises 1 through 8, find the average rate of change of the given function on the given interval(s). 1) f(x) = x; (-2, 0), (0, 2) 2. f(x) = x; (-3, 0), (0, 3) 3) f(x) = 1/x; (1,...

Three mutually exclusive alternatives are being considered: At the end of its useful life, an alternative is not replaced. If the MARR is 10%, which alternative should be selected: (a) Based on the...

Razor Sharp Company purchased tool sharpening equipment on July 1, 2008, for $48,600. The equipment was expected to have a useful life of three years, and a residual value of $3,000. Instructions...

Consider four mutually exclusive alternatives: Each alternative has a 5-year useful life and no salvage value . The MARR is 10%. Which alternative should be selected, based on (a) Future worth...

Decision Case 23-1 Movies Galore distributes DVDs to movie retailers, including dot.coms. Movies Galores top management meets monthly to evaluate the companys performance. Controller Allen Walsh...

Data for Arma Inc. are presented in P17-9A. Further analysis reveals that accounts payable pertain to merchandise creditors. Instructions Prepare a statement of cash flows for Arma Inc. using the...

Patrick Company had the following information in 2 0 2 4 : View the information. Uncollectible accounts are determined by the percent - of - sales method to be 4 % of credit sales. How much is bad...

Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 12.2. Briefly describe how computer simulation was applied in...

Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 4.3. Briefly describe how spreadsheet modeling was applied in...

Reconsider the Southwestern Airways crew scheduling problem presented in Section 7.4. Because of a blizzard in the Chicago area, all the flights into and out of Chicago (including flights 4, 6, 7,...

An Airbus A320 jetliner has a takeoff mass of 75,000 kg. It reaches its takeoff speed of 82 m/s (180 mph) in 35 s. What is the thrust of the engines? You can neglect air resistance but not rolling...

Seat belts and air bags save lives by reducing the forces exerted on the driver and passengers in an automobile collision. Cars are designed with a crumple zone in the front of the car. In the event...

A 6.5-cm-diameter ball has a terminal speed of 26 m/s. What is the balls mass?