A manufacturing area needs to forecast workhours 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 6 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 Apr 2021 1067 Mar 2021 1888 Feb 2021 1277 Jan 2021 1158 Dec 2020 1871 Nov 2020 1008 Oct 2020 1683 Sep 2020 1290 Aug 2020 1596 Jul 2020 1953 Jun 2020 1658 May 2020 1683 Apr 2020 1820 Mar 2020 1773 Feb 2020 1680 Jan 2020 1030 Dec 2019 1084 Nov 2019 1274 Oct 2019 1185 Sep 2019 1488 Aug 2019 1681 Jul 2019 1720 Jun 2019 1213 May 2019 1121 Apr 2019 1164 Mar 2019 1612 Feb 2019 1901 Jan 2019 1488 Dec 2018 1183 Nov 2018 1135 Oct 2018 1336 Sep 2018 1251 Aug 2018 1023 Jul 2018 1614 Jun 2018 1410 May 2018 1895

The Answer is in the image, click to view ...

Question: A manufacturing area needs to forecast workhours. The data for several months is supplied below. Be careful since the data is listed beginning with the

A manufacturing area needs to forecast workhours. 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 6 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.

Apr 2021: 1067	Mar 2021: 1888	Feb 2021: 1277	Jan 2021: 1158	Dec 2020: 1871	Nov 2020: 1008
Oct 2020: 1683	Sep 2020: 1290	Aug 2020: 1596	Jul 2020: 1953	Jun 2020: 1658	May 2020: 1683
Apr 2020: 1820	Mar 2020: 1773	Feb 2020: 1680	Jan 2020: 1030	Dec 2019: 1084	Nov 2019: 1274
Oct 2019: 1185	Sep 2019: 1488	Aug 2019: 1681	Jul 2019: 1720	Jun 2019: 1213	May 2019: 1121
Apr 2019: 1164	Mar 2019: 1612	Feb 2019: 1901	Jan 2019: 1488	Dec 2018: 1183	Nov 2018: 1135
Oct 2018: 1336	Sep 2018: 1251	Aug 2018: 1023	Jul 2018: 1614	Jun 2018: 1410	May 2018: 1895

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!

A manufacturing area needs to forecast workhours. This is a slightly different project. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast is...

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

A manufacturing area needs to forecast the number of special orders. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting...

A manufacturing area needs to forecast the barrels of patroleum distillate that will be used. The data for several months is supplied below. Be careful since the data is listed beginning with the...

A manufacturing area needs to forecast the wumber of special orders. The data for several months is supplied below. Be careful stace the data is listed beginning with the most recent. The forecasting...

The information technology department sreds to forecast spending on cyber security. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent....

The marketing department to forecast the number of customers purchasing a particular product. The data for several others is supplied below. Ile careful since the data Third beginning with the cest....

Amanufacturing area needs to forecast the banks of patroleum tillate that will be used. The data for several months is supplied below. Be careful since the data is listed beginning with the most...

A body of radius R and mass m is rolling smoothly with speed v on a horizontal surface. It then rolls up a hill to a maximum height h. (a) If h = 3v 2 /4g, what is the body's rotational inertia about...

One kilogram of air expands at a constant temperature from a pressure of 850 kpa and a volume of 2.0 m3 to a pressure of 250 Kpa. Determine; a.the work b.the heat c.the change in internal energy...

Assume the credit terms offered to your firm by your suppliers are 4 / 2 0 , net 3 0 . Calculate the cost of the trade credit if your firm does not take the discount and pays on day 3 0 . ( Hint: Use...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...