Question: Using the information below, calculate the 5-period weighted moving average for September 2021, October 2021, November 2021, December 2021, and January 2022. month actual sale

Using the information below, calculate the 5-period weighted moving average for September 2021, October 2021, November 2021, December 2021, and January 2022.

month actual sale
February 2021 2000
March 2021 3000
April 2021 3500
May 2021 4000
June 2021 2800
July 2021 3000
August 2021 4500
September 2021 4000
October 2021 3500
November 2021 3000
December 2021 5000
January 2022 2500

The weights are as follow starting with most recent data to the oldest data respectively: 0.35 (most recent); 0.25; 0.2; 0.15 and 0.05 (oldest data)

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!

Q:

C) Using the information below, calculate the 5-period weighted moving average for September 2021, October 2021, November 2021, December 2021, and January 2022. Month Actual Sales February 2021 2 000...

Q:

Using the information below, calculate the 5-period weighted moving average for September 2021, October 2021, November 2021, December 2021, and January 2022 Month Actual Sales February 2021 2 000...

Q:

You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists that operate out of rented premises...

Q:

You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists1 that operate out of rented premises...

Q:

please help me do my homework Part 1: Make or Buy Decisions Mobility Partners makes wheelchairs and other assistive devices. For years it has made the rear wheel assembly for its wheelchairs. A local...

Q:

Classic Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The monthly data and...

Q:

i need help Part 2: Classic Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The...

Q:

please show all work and in excel Classic Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared...

Q:

Please show calculation: Mr.Chong was just appointed as an account manager at Cahaya Sdn Bhd, a retail company selling merchandise for the local market. Mr. Chong is responsible for preparing and...

Q:

Demand Forecast Month September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 3,200 3,300 3,200 3,400 3,600 3,500 3,400 Actual Demand 3,400 3,100 3,600 4,000...

Q:

If a donor gives a charity a gift that the charity must convey to a separate beneficiary, what is the normal method of reporting for each party?

Q:

Grading Modulus (GM) can be associated with soils of different gradation properties. Describe what would be typical of the following types of soil gradations based on GM. (3) GM =0.9 GM =1.7 GM =2.5

Q:

Blue Skydiving Co . is owned by Nick and Amber. Business has been booming, as baby boomers want to prove their moxie, and the younger generations want to post crazy pictures on social media. So Nick...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...