Question

In: Operations Management

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

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

Solutions

Expert Solution

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

Answer: (Make sure to recheck the supplied data with my calculations. Here at my end i couldn't differentiate actual and forecast value colors. And intermediate values are not rounded, only output values are rounded to two decimals. For your convenience i have also provided excel formulas used, refer accordingly)

MAD = 159

MAPE % = 10.60

Tracking Signal = -0.26

Explanation:

Overall Calculation:

Excel Formulas Used:

Formulas:

Mean Absolute Deviation (MAD) = |Error| / n

Here: |Error| = |Actual - Forecast|

Mean Absolute Percent Error (MAPE) = (|Error| / Actual) x 100

Running Sum of Forecast Error (RSFE) = Error

Tracking Signal (TS) = (RSFE / MAD)


Related Solutions

The accounting department needs to forecast the profit for a subsidiary. The data for several months...
The accounting department needs to forecast the profit for a subsidiary. 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 exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.69, a trend smoothing constant (delta) of 0.3, a previous trend amount, seasonally adjusted, of 65, and a previous seasonal forecast of 582. Please round your forecast to...
Etemadi Amalgamated, a U.S. manufacturing firm, is considered a new project in the euro area. You...
Etemadi Amalgamated, a U.S. manufacturing firm, is considered a new project in the euro area. You are in Etemadi's corporate finance dept, and are responsible for deciding whether to undertake the project. The free cash flows in euros are forecast to be the following. Year Free cash flow 0 -15 1 9 2 10 3 11 4 12 You know that the spot exchange rate is $1,1500/E. In addition, the risk-free interest rate on dollars is 4.0% and the risk-free...
The algorithm is basically as follows. The notation is slightly different from that in the website...
The algorithm is basically as follows. The notation is slightly different from that in the website you were given, but there is no difference in the method. Given the initial value problem dy/dx=f(x,y),y(a)= y_0 Euler’s Method with step size h consists in applying the iterative formula y_(n+1)= y_n+h∙f(x_n,y_n ),n≥0 To compute successive approximations y_1,y_2,y_3,⋯ to the (true) values 〖y(x〗_1),〖y(x〗_2),〖y(x〗_3),⋯ of the exact solution y=y(x) at the points x_1,x_2,x_3,⋯, respectively. In plain English: You want to approximate the value of dy/dx...
The algorithm is basically as follows. The notation is slightly different from that in the website...
The algorithm is basically as follows. The notation is slightly different from that in the website you were given, but there is no difference in the method. Given the initial value problem dy/dx=f(x,y),y(a)= y_0 Euler’s Method with step size h consists in applying the iterative formula y_(n+1)= y_n+h∙f(x_n,y_n ),n≥0 To compute successive approximations y_1,y_2,y_3,⋯ to the (true) values 〖y(x〗_1),〖y(x〗_2),〖y(x〗_3),⋯ of the exact solution y=y(x) at the points x_1,x_2,x_3,⋯, respectively. In plain English: You want to approximate the value of dy/dx...
A warehouse needs 3cfm in a control area. the controlled area is 25ft x 50ft. with...
A warehouse needs 3cfm in a control area. the controlled area is 25ft x 50ft. with a height of 20ft. how many cfm would be needed to reach the goal of 3cfm?
Create a new “Area” project. Create a new Visual Studio Project and call it “Area”. This...
Create a new “Area” project. Create a new Visual Studio Project and call it “Area”. This project will be used to calculate the area of certain figures, like circles, squares and rectangles. So add a title to the Form. The Form Title should say “Area”. Also add 3 labels, 3 Buttons, 3 Textboxes and 3 RadioButtons. The 3 Buttons should be near the bottom of the Form and say “Calc Area”, “Clear” and “Exit”. Make sure to give all your...
Sales forecast based on external data.  Raspberry Phones uses external data to forecast the coming​ year's...
Sales forecast based on external data.  Raspberry Phones uses external data to forecast the coming​ year's sales. The company has 7.5 % of all​ new-phone sales in the United States and 5.6 % of all​ replacement-phone sales. Industry forecasts predict 18.9 million​ new-phone buyers and 31.8 million​ replacement-phone buyers in 2014. If the average Raspberry phone costs ​$84.05​, what sales revenues is the company forecasting for​ 2014?
Firms 1 and 2 are in the pizza business, but they face slightly different market conditions....
Firms 1 and 2 are in the pizza business, but they face slightly different market conditions. Each firm faces the following demand for its product: Q1=21-3P1+2P2 for firm 1, and Q2=27-3P2+2P1 for firm 2. The cost to each firm of making a pizza is $5; it is constant. Firms can choose any price. a. Find the solution to the Bertrand game (output, price, and profit for each firm). b. Compare it to the cooperative solution. c. Explain why this game...
Two of the stable isotopes of mercury are 198Hg and 202Hg. These isotopes emit slightly different...
Two of the stable isotopes of mercury are 198Hg and 202Hg. These isotopes emit slightly different wavelengths of light, 546.07532nm and 546.07355nm, respectively. To identify which isotopes are included in a sample of mercury, we can shine the light it emits on a diffraction grating with a screen 6 m away. How many lines per centimeter are necessary in the diffraction grating for the first-order bright fringes of the two wavelengths to be 1.4 cm apart on the screen?
For our discussion, you will address one of three slightly different versions of the case of...
For our discussion, you will address one of three slightly different versions of the case of a ball falling to the base of a 50.0 m tall building. Neglect air resistance. The magnitude of the acceleration is 9.80 m/s2. The eventual position of the ball is at the base of the building, 50.0 m below this initial position. Upward is defined as positive. Displacements, velocities and accelerations directed upwards are positive. Conversely, if directed downwards, these same quantities are negative....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT