Question: WEBCAM RECORD A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year,

WEBCAM RECORD A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2021. based on the following historical data YEAR Sales- ty 1 2016 2017 2018 2019 2020 SUM 1 2 3 4 5 15 3.000 3.000 6.000 12.000 8.000 24.000 7.000 28.000 10.000 50.000 34.000 117.000 1 4 9 16 25 55 a. What is the forecast for this year, 2021, using a five year simple moving average? (4 pts) b. What is the forecast for this year using exponential smoothing with alpha=0.6. if the forecast for 2019 was 8,000? (4 pts) c. What is the least squares trend equation that shows the best relationship between demand and year? (4 pts) d. What is the forecast for this year, 2021, using the least squares trendline you found in part c? (2 pts)

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!

Case Realica Properties ASA 1. Introduction Realica Properties ASA is a Norwegian company whose shares are traded on the Oslo Stock Exchange. The company was established in the late nineties when a...

Sterling properties an German company whose shares are traded on the German Stock Exchange. The company was established in the late nineties when a major German insurance company moved its portfolio...

10.16 PREPARING AND INTERPRETING FINANCIAL STATEMENT FORECASTS. Wal-Mart Stores, Inc. (Walmart)... 10.16 PREPARING AND INTERPRETING FINANCIAL STATEMENT FORECASTS. Wal-Mart Stores, Inc. (Walmart) is...

Course: Corporate Finance: Theory and Practice Can you help me answer the questions from 1 to 5 in Instruction please? 25557: Case Study 2017 Spring Semester Conservation, Flora and Transformative...

how to calculate BPT's company after-tax WACC,rounded to four decimal places CFTP Case Study 2017 Autumn Semester 1. BPT Corporation was a provider of accommodation solutions and recreation vehicles,...

View the 2013 Annual Report for the Ford Motor Company, a Fortune 50 company, linked here as well as on the Course Information page. Using this report, answer the following questions: Does the...

24. In a negative relationship, a. as X increases, Y increases as X decreases, Y decreases b. C. as X increases, Y increases, and as X decreases, Y decreases d. as X increases, Y decreases 25. The...

Create a JFrame two-dimensional array named frames that has 4 rows and 5 columns. Create and store a JFrame in each entry of the frames. Set the size of each frame to be 200x200 Set the location of...

Which of the following is the best definition for a junk bond ? A bond that is rated as below investment - grade by rating agencies A bond that has declined dramatically in value A bond that has...

What is an example of constructive feedback? provide reference