A manufacturing area needs to forecast workhours. This is a slightly different project. The data for...

50.1K

Verified Solution

Question

General Management

A manufacturing area needs to forecast workhours. Thisis a slightly different project. The data for several months issupplied below. Beside each of the actual numbers in black, theforecast is provided in red. The goal is to calculate three statson the data: MAD, MAPE, and the tracking signal. Be careful sincethe data is listed beginning with the most recent. Please round totwo decimal places. For MAPE, please convert to a percentage beforerounding. Do not enter the percent sign.
Jul 2020: 1693, 1591 Jun 2020: 1408, 1281 May 2020: 1945, 2237 Apr 2020: 1197, 1125 Mar 2020: 1985, 2084 Feb 2020: 1584, 1378
Jan 2020: 1117, 1050 Dec 2019: 1660, 1743 Nov 2019: 1113, 968 Oct 2019: 1127, 958 Sep 2019: 1075, 1204 Aug 2019: 1253, 1103
Jul 2019: 1633, 1437 Jun 2019: 1552, 1443 May 2019: 1689, 1486 Apr 2019: 1775, 1988 Mar 2019: 1523, 1355 Feb 2019: 1634, 1879
Jan 2019: 1675, 1910 Dec 2018: 1488, 1637 Nov 2018: 1399, 1581 Oct 2018: 1071, 975 Sep 2018: 1721, 1807 Aug 2018: 1389, 1195
Jul 2018: 1656, 1457 Jun 2018: 1342, 1409 May 2018: 1022, 910 Apr 2018: 1599, 1391 Mar 2018: 1558, 1636 Feb 2018: 1440, 1310
Jan 2018: 1903, 2169 Dec 2017: 1637, 1833 Nov 2017: 1052, 999 Oct 2017: 1092, 1256 Sep 2017: 1955, 1740 Aug 2017: 1623, 1866
Jul 2017: 1682, 1917
Please enter MAD here--->
Please enter MAPE % here--->
Please enter the tracking signalhere--->

Answer & Explanation Solved by verified expert

3.6 Ratings (582 Votes)

Question A manufacturing area needs toforecast workhours This is a slightly different project The datafor several months is supplied below Beside each of the actualnumbers in black the forecast is provided in See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Jul 2020: 1693, 1591	Jun 2020: 1408, 1281	May 2020: 1945, 2237	Apr 2020: 1197, 1125	Mar 2020: 1985, 2084	Feb 2020: 1584, 1378
Jan 2020: 1117, 1050	Dec 2019: 1660, 1743	Nov 2019: 1113, 968	Oct 2019: 1127, 958	Sep 2019: 1075, 1204	Aug 2019: 1253, 1103
Jul 2019: 1633, 1437	Jun 2019: 1552, 1443	May 2019: 1689, 1486	Apr 2019: 1775, 1988	Mar 2019: 1523, 1355	Feb 2019: 1634, 1879
Jan 2019: 1675, 1910	Dec 2018: 1488, 1637	Nov 2018: 1399, 1581	Oct 2018: 1071, 975	Sep 2018: 1721, 1807	Aug 2018: 1389, 1195
Jul 2018: 1656, 1457	Jun 2018: 1342, 1409	May 2018: 1022, 910	Apr 2018: 1599, 1391	Mar 2018: 1558, 1636	Feb 2018: 1440, 1310
Jan 2018: 1903, 2169	Dec 2017: 1637, 1833	Nov 2017: 1052, 999	Oct 2017: 1092, 1256	Sep 2017: 1955, 1740	Aug 2017: 1623, 1866
Jul 2017: 1682, 1917

Please enter MAD here--->
Please enter MAPE % here--->
Please enter the tracking signalhere--->