Question: 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

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 provided in red. The goal is to calculate three stats on the data: MAD, MAPE, and the tracking signal. Be careful since the data is listed beginning with the most recent. Please round to two decimal places. For MAPE, please convert to a percentage before rounding. 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 signal 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 woman resources department needs to forecast the number of workmee's compensation calm. This is a slightly different project. The data for several months is supplied below. Beside each of the...

Q:

The marketing department needs to forecast the number of complaints arising from a particular defect in a product. This is a slightly different project. The data for several months is supplied below....

Q:

The information technology department needs to forecast spending on cyber security. This is a slightly different project. The data for several months is supplied below. Beside each of the actual...

Q:

Logout David Benson Analytics Manager The purchasing and supply department needs to forecast the number of rolls of aluminum to order. This is a slightly different project. The data for several...

Q:

The information technology department needs to forecast spending on cyber security. This is a slightly different project. The data for several months is supplied below. Beside each of the actual...

Q:

The information technology department needs to forecast spending on cyber security. This is a slightly different project. The data for several months is supplied below. Beside each of the actual...

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:

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Q:

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

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:

Omar is the sole shareholder of Plum Corporation, which has annual taxable income of approximately $200,000. Omar formed a new solely owned corporation, Ivory Corporation, and had Plum Corporation...

Q:

With the aid of separate labelled diagrams in each case, predict and explain the likely effect of the following events on the equilibrium price and quantity of petrol in the UK. Remember to explain...

Q:

stubbs inc. exchanged land ( historical cost of $ 1 2 5 0 0 0 ; recently appraised value of $ 2 8 5 , 0 0 0 ) for marketable equity securities with a market price on the exchange of $ 2 6 0 0 0 0 ....

Q:

What is an example of constructive feedback? provide reference