Question: The human resources department needs to forecast the total amount of salaries for a particular department. The data for several months is supplied below. Be

The human resources department needs to forecast the total amount of salaries for a particular department. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 4 month moving average after accounting for seasonality. Keep in mind you will need to compute the seasonality factors. Please round your forecast to the nearest whole number.

May 2020: 43216 Apr 2020: 57707 Mar 2020: 55092 Feb 2020: 50800 Jan 2020: 50433 Dec 2019: 57834
Nov 2019: 59211 Oct 2019: 44703 Sep 2019: 59221 Aug 2019: 57167 Jul 2019: 46146 Jun 2019: 42300
May 2019: 57723 Apr 2019: 55484 Mar 2019: 46650 Feb 2019: 52363 Jan 2019: 59446 Dec 2018: 46237
Nov 2018: 46346 Oct 2018: 47403 Sep 2018: 45913 Aug 2018: 48134 Jul 2018: 40453 Jun 2018: 56866
May 2018: 41651 Apr 2018: 46783 Mar 2018: 51848 Feb 2018: 53294 Jan 2018: 49244 Dec 2017: 57268
Nov 2017: 50427 Oct 2017: 52460 Sep 2017: 54975 Aug 2017: 45519 Jul 2017: 43259 Jun 2017: 45407

Please enter your forecast here--->

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:

The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...

Q:

The human resources department needs to forecast the total amount of salaries for a particular department. The data for several months is supplied below. Be careful since the data is listed beginning...

Q:

The human resources department needs to forecast the total amount of salaries for a particular department. The data for several months is supplied below. Be careful since the data is listed beginning...

Q:

The human resources department seeds to forecast the number of employees at a site. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast 1 is...

Q:

The human resources department needs to forecast the number of workmen's compensation claims. The data for several months is supplied below. Be careful since the data is listed beginning with the...

Q:

David Benson Analytics Manager The human resources department needs to forecast the number of workmen's compensation claims. The data for several months is supplied below. Be careful since the data...

Q:

The human resources department needs to forecast the number of sexual harassment investigations for the entire company. The data for several months is supplied below. Be careful since the data is...

Q:

The accounting department needs to forecast electricity expense for one of the buildings. The data for several months is supplied below. Be careful since the data is listed beginning with the most...

Q:

The human resources department needs to forecast the number of sexual harassement investigations for the entire company. The data for several months is supplied below. Be careful since the data is...

Q:

The accounting department needs to forecast electricity expense for one of the buildings. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast #1 is...

Q:

The information technology department needs to forecast maintenance costs on the servers. The data for several months is supplied below. Be careful since the data is listed the most recent. The...

Q:

Four steps in a newly discovered biochemical pathway in Neurospora are shown below. Capital letters R, T, M and Q are intermediates in the pathway that ends with biosynthesis of the product P. Each...

Q:

An automation engineer is looking to deploy a deterministic network in a sheet metal factory. The control system in charge of safety expects a message from the embedded application of a heating...

Q:

Sales for Pete's Sports Equipment are expected to be 42,000 units for October. The company likes to maintain 15 percent of unit sales for each month in ending inventory (that is, end of October)....

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...