[go: up one dir, main page]
Scribd
Upload
21 views7 pages

Forecast Analysis

The document presents actual and forecast demand data for smartphones, laptops, and smartwatches from January to June. It includes metrics such as Absolute Percentage Error (APE) and Mean Absolute Percentage Error (MAPE) for each category, highlighting discrepancies between actual and forecasted values. Overall, smartphones have a MAPE of 25%, laptops 19%, and smartwatches 60%, indicating varying levels of forecasting accuracy.

Uploaded by

rajatisbest44
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views7 pages

Forecast Analysis

The document presents actual and forecast demand data for smartphones, laptops, and smartwatches from January to June. It includes metrics such as Absolute Percentage Error (APE) and Mean Absolute Percentage Error (MAPE) for each category, highlighting discrepancies between actual and forecasted values. Overall, smartphones have a MAPE of 25%, laptops 19%, and smartwatches 60%, indicating varying levels of forecasting accuracy.

Uploaded by

rajatisbest44
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Actual Demand (AD) Forecast Demand (FD)

Months Smartphones (AD) Laptops (AD) Smartwatches (AD) Smartphones (FD) Laptops (FD)
January 1600 755 259 2045 1023
February 1649 865 292 2121 1061
March 1569 877 250 2175 1088
April 1750 923 214 2213 1106
May 1920 1000 200 2239 1119
June 2040 1100 196 2257 1129
ast Demand (FD) APE
Smartwatches (FD) Smartphones APE Laptops APE Smartwatches APE
352 28% 36% 36%
361 29% 23% 24%
367 24% 31% 47%
371 26% 20% 73%
373 17% 16% 66%
375 11% 3% 92%

MAPE 25% 19% 60%


Months Smartphones APE Laptops APE Smartwatches APE
January 28% 36% 36%
February 29% 23% 24%
March 24% 31% 47%
April 26% 20% 73%
May 17% 16% 66%
June 11% 3% 92%
Category MAPE
Smartphones 25%
Laptops 19%
Smartwatches 60%
Actual Demand Data (AD) Forecast Demand Data (FD)
Months Smartphones (AD) Laptops (AD) Smartwatches (AD) Smartphones (FD) Laptops (FD)
January 1600 755 259 2045 1023
February 1649 865 292 2121 1061
March 1569 877 250 2175 1088
April 1750 923 214 2213 1106
May 1920 1000 200 2239 1119
June 2040 1100 196 2257 1129

SUM 10528 5520 1411 13050 6527


BIAS
Demand Data (FD) Forecast Realization
Smartwatches (FD) Smartphones Laptops Smartwatches
352 445 268 93
361 472 196 69
367 606 211 117
371 463 183 157
373 319 119 171
375 217 29 175

2191 2522 1007 780


24% 18% 55%
Category Bias
Smartphon 24%
Laptops 18%
Smartwatc 55%

You might also like