Question: Q1. Use Moving Average with k=2 and 4 (where k is the number of past quarters). What are the revenues for Q1,..Q4 in 2021? Plot

Q1. Use Moving Average with k=2 and 4 (where k is the number of past quarters). What are the revenues for Q1,..Q4 in 2021? Plot the data and the MA lines. What do you observe when you use k=2 and k=4 in MV?

Q2. Do the same forecasting for 2021 with Weighted Moving Average with k=2 and 4. Plot the data and the WMA lines. What do you observe?

Q3. Do the same forecasting for 2021 with Exponential Smoothing with alpha = 0.3 and 0.5. Plot the data and the ES lines. What do you observe?

Q4. Use Linear Regression with Trend to forecast the same revenues in 2021.

YearQuarterRevenue20101156832010213499201031570020104203432011126741201122466720113285712011428270201214633320122391862012335023201243596620131545122013243603201333532320134374722014157594201424564620143374322014442123201517459920152580102015349605201545150120161758722016250557201634235820164468522017178351201725289620173454082017452579201818829320182611372018353265201846290020191843102019 258015201935380920194640402020191819202025831320203596852020464698

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!

Calculate the Market Debt/EBITDA ratio given the following fact pattern. Please enter your answer as a multiple with one decimal (for example, 4.0x) Assume no cash Prior-year EBITDA is $50m but is...

Use the Revenue_Apple file . You want to forecast the revenue of Apple for the next four quarters in 2021. Make sure to indicate which sheet (tab) is used for which question in the file (workbook)....

Using the Assignment Tools to Complete This Exam The tools for working with this exam are found in the Assignment menu. The Instruction Sheet icon displays all tasks for the exam at the same time in...

Please note all the data in this assignment is provided in an Excel file attached in the Assignment tab. (20 points) Consider the quarterly electricity production for years 1-4: Year 1 2 3 4 Q1 99...

1. Use moving average to forecast the number of Auditors needed next quarter If AP=2, AP=4 & AP=6 (5 m) 2. Analyse & explain which of these forecasts exhibits the best forecast accuracy over the past...

please answer question 5 only Quarter Q1 Q2 Year 1 1 1 1 2 2 2 Q3 Q4 Q1 Q2 Q3 2 3 3 3 3 4 Q4 Q1 Q2 Q3 Q4 Q1 Units 20 100 175 13 37 136 245 26 75 155 326 48 92 202 384 82 176 282 445 181 Q2 4 4 4 5 5...

Td 1 : Forecasting and Budget Estimation in a Risky Environment AERO is an industrial subcontractor that manufactures various families of components for the aerospace sector. For the past four years,...

CYCLOTRON BIKES, INC. Cyclotron Bikes, Inc. was established in 1959 by a passionate entrepreneur that wanted people to enjoy the nature as well as to stay healthy by making use of the bike. The...

INFO 564 Homework Assignment 5 (100 pts) This work must be done completely in EXCEL. Answer each question on a separate tab. Label each tab appropriately. You can copy and paste the data given into...

CASE #3 INVENTORY FORECASTING DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for customers while they are in transit to local retailers....

Milos, the Vice-President of Kitchen Appliances at Evtel, decided to produce a new smart home device that sends sounds to other rooms with a single touch. The company is planning to analyze Turkey's...

On March 4, 2020, the company secretary for Reggae Vibes Limited sent out notices to the shareholders of the company advising of the annual general meeting to be held on March 25, 2020. Included in...

Portions of the financial statements for Software Associates are provided below. Required: Prepare the operating activities section of the statement of cash flows for Software Associates using the...

Other postretirement benefits should be expensed a on the employee's retirement date. b as they are received by the employee. c when the employee is hired.

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...