Calibri L36 11 pt x = 1 Month A B Forecast C Actual Sales 2 March...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calibri L36 11 pt x = 1 Month A B Forecast C Actual Sales 2 March 150 170 3 April 220 229 4 May 205 192 5 June 256 241 6 July 250 238 7 August 260 210 8 September 270 225 9 October 280 179 10 000 11 1. Plot the data and provide insights about the time series. 12 13 14 15 16 E F 17 18 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1)+Actual Sales (n-2)/2 Forecast Actual Sales Two period Moving Average 22 Month 23 March 24 April 150 220 + Sheet1 Sheet 1 of 11 Type here to search 170 229 PageStyle Sheet1 Ex De Calibri 11 pt BIU 4abc L36 A fx = B D E F 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1) + Actual Sales (n-2)/2 22 Month Forecast Actual Sales Two period Moving Average 23 March 150 170 24 April 220 229 25 May 205 192 199.5 26 June 256 241 210.5 27 July 250 238 216.5 28 August 260 210 239.5 29 September 270 225 30 October 280 179 31 32 33 225+179/2 = 404/2 = 34 35 36 37 3. What is the forecast for November, using a three-period moving average? 38 (n) =Actual Sales (n-1) + Actual Sales (n-3)/3 39 Error Actual-Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 + Sheet1 Sheet 1 of 11 PageStyle Sheet1 Eng Type here to search O D Calibri 11 pt BI L36 - fx = A B C D E F 37 3. What is the forecast for November, using a three-period moving average? 38 (n) Actual Sales (n-1)+ Actual Sales (n-3)/3 39 Error Actual Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 43 May 205 192 44 June 256 241 197 45 July 250 238 220.66 46 August 260 210 223.66 47 September 270 225 229.66 48 October 280 179 49 50 51 210+225+179/3 614/3= 52 53 54 55 56 57 58 59 60 + Sheet1 Sheet 1 of 1 Type here to search PageStyle Sheet1 Engle O D Calibri L36 11 pt x = 1 Month A B Forecast C Actual Sales 2 March 150 170 3 April 220 229 4 May 205 192 5 June 256 241 6 July 250 238 7 August 260 210 8 September 270 225 9 October 280 179 10 000 11 1. Plot the data and provide insights about the time series. 12 13 14 15 16 E F 17 18 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1)+Actual Sales (n-2)/2 Forecast Actual Sales Two period Moving Average 22 Month 23 March 24 April 150 220 + Sheet1 Sheet 1 of 11 Type here to search 170 229 PageStyle Sheet1 Ex De Calibri 11 pt BIU 4abc L36 A fx = B D E F 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1) + Actual Sales (n-2)/2 22 Month Forecast Actual Sales Two period Moving Average 23 March 150 170 24 April 220 229 25 May 205 192 199.5 26 June 256 241 210.5 27 July 250 238 216.5 28 August 260 210 239.5 29 September 270 225 30 October 280 179 31 32 33 225+179/2 = 404/2 = 34 35 36 37 3. What is the forecast for November, using a three-period moving average? 38 (n) =Actual Sales (n-1) + Actual Sales (n-3)/3 39 Error Actual-Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 + Sheet1 Sheet 1 of 11 PageStyle Sheet1 Eng Type here to search O D Calibri 11 pt BI L36 - fx = A B C D E F 37 3. What is the forecast for November, using a three-period moving average? 38 (n) Actual Sales (n-1)+ Actual Sales (n-3)/3 39 Error Actual Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 43 May 205 192 44 June 256 241 197 45 July 250 238 220.66 46 August 260 210 223.66 47 September 270 225 229.66 48 October 280 179 49 50 51 210+225+179/3 614/3= 52 53 54 55 56 57 58 59 60 + Sheet1 Sheet 1 of 1 Type here to search PageStyle Sheet1 Engle O D
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Sewing industries is a factory located in Divundu that specialises in assembling mini-sewing electrical machines which are portable and which can be used in close proximity. The business has provided...
-
In its 2005 annual report, Waste Management Inc. provided the following note to the financial statements: Financial Interest in Surety Bonding CompanyDuring the third quarter of 2003, we issued a...
-
Below is cash flow information for five companies. 1. Kraft Foods reports operating cash flows of $3.5 billion, investing cash flows of $0.5 billion, and financing cash flows of $4.0 billion. What is...
-
Fraser is a full service yacht brokerage company, specializing in yachts over \(30 \mathrm{~m}\). Access the company's Web site (https://www. fraseryachts.com) and locate one of the yachts that is...
-
According to its original plan, Bailey Consulting Services Company plans to charge its customers for service at $160 per hour in 2014. The company president expects consulting services provided to...
-
is a quality assurance specialist takes measurements and achieves consistent results repeatedly using any appropriate equipment what is this an example of a. repeatability b. reproducibility c....
-
You want to leave a small amount for two of your children, Kira, aged 68 and Fred, aged 63. Kira will retire at 70 (t = 2), as will Fred (t = 7). You want each to have $500,000 per year for the rest...
-
Imagine a cylindrical water tank with a height of 11 meters and a base radius of 5 meters. Calculate the total surface area of the tank, including the top and bottom. Express your answer in terms of .
-
A 696 g mass is placed on top of a spring. The other end of the spring is attached to the floor. You also push down on the mass with a force of 3.1 N. The spring moves downward a total of 0.279 m...
-
5. Ernie is conducting a sound experiment and uses a sound level meter to record some sound. He stands 5 m from a lawn mower and records a sound intensity level of 100 dB. = 1, a. Determine the sound...
-
Add the following vectors: A pilot takes off from the runway, traveling for 1,800 km at 25 degrees W of N. They then travel for 943 km at 48 degrees S of E. What was the pilot's final displacement...
-
A firm's current balance sheet is as follows: Assets $ 120 Debt $ 12 Equity $ 108 A. What is the firm's weighted-average cost of capital at various combinations of debt and equity, given the...
-
6. If we assume that leisure is a normal good, then the income effect associated with a wage increase will always result in (a) an increase in the hours of work. (b) a decrease in the hours of work....
-
Avatar Financials, Inc., located on Madison Avenue, New York City, is a company that provides financial advice to individuals and small- to mid-sized businesses. Its primary operations are in wealth...
Study smarter with the SolutionInn App