Question: Consider the sales data for Dalworth Company given in Problem. a. Use a three-month weighted moving average to forecast the sales for the months April

Consider the sales data for Dalworth Company given in Problem.
a. Use a three-month weighted moving average to forecast the sales for the months April through December. Use weights of (316), (216), and (1/6), giving more weight to more recent data.
b. Use exponential smoothing with α = 0.6 to forecast the sales for the months April through December. Assume that the initial forecast for January was $20 million. Stan error measurement in April
c. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion, with error measurement beginning in April. Which method would you recommend?
d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion, with error measurement beginning in April. Which method would you recommend?
e. Compare the performance of the two methods by using the mean squared error as the performance criterion, with error measurement beginning in April. Which method would you recommend?

Step by Step Solution

★★★★★

3.27 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Dalworth Company a Threemonth weighted moving average weights of 36 26 and 16 Month Actual Sales Thr... 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

Document Format (1 attachment)

227-B-M-L-S-C-M (1046).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

Consider the sales data for Bell, Inc. given in Problem 2. a. Use a three-month weighted moving average to forecast the sales for the months April through December. Use weights of (3/6), (2/6), and...

Consider the sales data for Computer Success given in Problem 7. a. Use a 3-month weighted moving average to forecast the sales for the months April through December. Use weights of (4/8), (3/8), and...

Three Month Rolling Average 2 Month Weighted Moving Average Exponential Smoothing $2,365.23 $2,366.84 $2,339.28 $8,115.92 $8,074.93 $7,951.89 $35,844.38 $40,131.65 $36,301.60 $11,566.05 $11,647.90...

Bradley s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for...

Consider the sales data of Enron Inc. given in the table. Use a 3-month weighted moving average to forecast the sales for the month of July. Use weights 0.5, 0.3 and 0.2, giving more weight to more...

Can you answer this and explain your steps please.. 2.19. The nonzero stress components are Op, = -90 MPa, on = 50 MPa, and on, = 60 MPa. Determine the principal stresses and maximum shear stress....

Attached are 3 questions that I needanswered: This assignment is due by 2/28/16. Pg. 218 (Problem 7): 7. Arabelle is considering expanding the floor area of her high-fashion import clothing store,...

please provide correct answer as soon as possible Sales for the past 12 months at Dalworth Company are given here. a) Use a 3-month weighted moving average to forecast the sales for the months...

The data above represents a five-month history of sales figures for pants produced by the Gunn Clothing Company. The manager wants to use a three-month weighted moving average to forecast sales....

List four ecological impacts of macroalgae blooms, explain each and provide examples

Discuss with relevant industry examples at least three factors organizations have to consider before locating their facility. Be sure your examples include how and why location factors differ between...

if a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

For calculating the number of members in a private company, joint holders will be treated as . (i) 1 (iii) 3 (ii) 2 (iv) 4

Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about...

A distribution center experiences an average weekly demand of 50 units for one of its items. The product is valued at $650 per unit. Inbound shipments from the factory warehouse average 350 units....

Managing inventory at Crayola is a fine balancing act. With the back-to-school period driving 42 percent of company demand for crayons, markers, paints, modeling compounds, and other products,...

K-Too Everwear Corporation can manufacture mountain climbing shoes for $25.70 per pair in variable raw material costs and $16.95 per pair in variable labor expense. The shoes sell for $126 per pair...

During his speech to the AGM, the Chairman of Banks DIH stated the company was able to achieve an EBIT of 100, depreciation on assets was 40 , interest paid on financing facilities was 20 and final...

Chef Gourmet, Inc., has assembled the following data pertaining to its two most popular products. Blender Food Processor Direct material $ 24 $ 28 Direct labor 17 45 Manufacturing overhead @ $58 per...