Question: please help with the following using this formula: Ft = Ft-1 + a (At-1 Ft-1) Company DMS observes the sales records for the last

please help with the following using this formula:

Ft = Ft-1 + a (At-1 – Ft-1)

Company DMS observes the sales records for the last five (5) periods:

Company DMS observes the sales records for the last five (5) periods: Period Actual Sales (units) 1 1050 2 930 1065 918 1119 3 4 5 Assume the initial forecast is 1000 units, provide your analysis on the following sub- questions: Sub-questions (a) Compute the Mean Absolute Deviation (MAD) using the exponential smoothing method with a smoothing constant of 0.3 for periods 2 to 5. (b) Compute the Mean Absolute Deviation (MAD) using the exponential smoothing method with a smoothing constant of 0.6 for periods 2 to 5. (c) Comments on the results obtained from parts (a) and (b). Sub-total Keep the above workings and answers to ONE (1) decimal place. Marks allocation 10 marks 10 marks 5 marks 25 marks

Step by Step Solution

★★★★★

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer calculate the Mean Absolute Deviation MAD using the exponential smoothing method for the give... 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 General Management Questions!

Please help with the following questions below... 1) Based on your SWOT of Southwest Airlines, explain which one of the 5 generic business strategies you think Southwest is following and why. Explain...

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

I need help solving my accounting project. i did 4-7 workbook which i have attached below. but 7-10 are incorrect. could someone help me correct from 7-10 quickly please. MI5965 I SEE THE LIGHT...

Hello, I am struggling with this project and my teacher is not helping me at all to work through this project. Can I have a tutor give me a step by step solutions for the whole project so I can...

Find the volume generated when the region between the curves is rotated around the given axis. Use both the shell method and the washer method. Use technology to graph the functions and draw a...

Can you help me complete tabs 8 till 18 please You can input the formulas on the cells that way I know how you got the results YZ7742 I SEE THE LIGHT www.cybertext.com, The Book List, Building Blocks...

Hello I've attached an Excel file (NZ1832) and I got these questions wrong: 6.01, 6.02, 6.03, 6.04, 9.01, 9.04, 9.05, 9.06, 9.09, 9.12, 9.13, 10.01, 10.03, 10.04, 10.05, 10.07, 13.01, 15.01, 15.02,...

I need help solving this project I am not sure how to solve some of these, any help will be appreciated OH4808 I SEE THE LIGHT www.cybertext.com, The Book List, Building Blocks of Accounting--A...

On September 1, Dondra purchased $9,500 of inventory items on credit with the terms 1/15, net 30, FOB destination. Freight charges were $100. Payment for the purchase was made on September 18....

Backflushing. The following conversation occurred between Brian Richardson, plant manager at Glendale Engineering, and Charles Cheng, plant controller. Glendale manufactures automotive component...

According to the efficient markets theory, the announcement of a future plant expansion ( with a positive NPV ) should cause the stock price and therefore the value of the firm to Blank _ _ _ _ _ _ .

If a continuous uniform distribution has parameters of = 0 and = 1, then the minimum is - 3 and the maximum is 3 a. For this distribution, find P(-1

Refer to the Environmental Science & Technology (Jan. 2005) study of methyl tert-butyl ether (MTBE) contamination in public and private New Hampshire wells, Exercise 2.12. Recall that data on well...

The following Trueblood case is recommended for use with this chapter. The case provides an excellent opportunity for class discussion, group projects, and writing assignments. The case, along with...

Consider the density function Find the density function of W, where: a. W = Y b. W = 3 - Y c. W = - ln (Y) S3y if 0

Refer to the Human Factors (Dec. 1988) study of color brightness as a body orientation clue, Exercise 7.65. Ninety college students, reclining on their backs in the dark, were disoriented when...

Which of the following is NOT a step in the internal analysis process for finding competitive advantage? (SLO 2)a.Organize the internal analysis process using the value chainb.Identify organizational...

Consider an infinite-period inventory problem involving a single product where, at the beginning of each period, a decision must be made about how many items to produce during that period. The setup...

Read the referenced article that fully describes the OR study summarized in the application vignette in Sec. 9.1. Briefly describe how the model for the transportation problem was applied in this...

Read Selected Reference A10 that describes an OR study done for the Health Department of New Haven, Connecticut. (a) Summarize the background that led to undertaking this study. (b) Outline the...

Explain how buyers incrementally learn as they progressively solve their problems.

The broader range of marketing communication objectives suggested in this chapter includes connection, informing, persuading, learning, and inventing. All are aspects of cooperative interaction or...

Distinguish the activities of diverse consumer market segments during the purchase and use of a particular product, and recognize the factors that contribute to the different patterns of activities.