hig.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard-cite-them-right
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • sv-SE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • de-DE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Forecasting within the Fast-Moving Consumer Goods Industry using Historical Sales and Time Series modelling
University of Gävle, Faculty of Engineering and Sustainable Development, Department of Computer and Geospatial Sciences.
2024 (English)Independent thesis Advanced level (degree of Master (One Year)), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

This thesis employs a quantitative and technical approach to evaluate time series functions as a forecasting method for ice cream sales in Sweden, focusing on two distinct ice cream types. Utilizing weekly historical data spanning from 2021 to 2024, the study explores the application of time series forecasting in @Risk, an add-on application in Microsoft Excel, specifically its "Time Series” functionality, to conduct simulations with user-defined parameters and settings. The thesis investigates the impact of varying settings in @Risk on the forecasting simulations for three different historical data periods throughout the year including high and low season for ice cream sales. Evaluation of the simulations is based on the forecast error which is calculated as the difference between forecasted values and actual sales data divided by the forecasted value. Findings reveal that limited historical data leads to significant variations in simulation results, amplifying uncertainties and rendering forecasts unreliable. However, incorporating seasonality into the settings improves forecast accuracy by decreasing the forecast error in many instances. While the project's conclusions are specific to its context, the methodology and results hold valuable insights for similar projects within the Fast-Moving Consumer Goods (FMCG) industry or for time-series functionality. 

Place, publisher, year, edition, pages
2024. , p. 49
Keywords [en]
Forecasting, time series analysis, Monte Carlo simulations
National Category
Other Engineering and Technologies
Identifiers
URN: urn:nbn:se:hig:diva-45377OAI: oai:DiVA.org:hig-45377DiVA, id: diva2:1892479
Subject / course
Decision, risk and policy analysis
Educational program
Decision, risk och policy analysis - master’s programme (one year)
Supervisors
Examiners
Available from: 2024-08-28 Created: 2024-08-27 Last updated: 2025-02-10Bibliographically approved

Open Access in DiVA

fulltext(1971 kB)155 downloads
File information
File name FULLTEXT01.pdfFile size 1971 kBChecksum SHA-512
abda1c0d400f88b05bcdb4bf39d88221bd7e1e8018623bc218f9e68fd87986ef8b098645583113c6bbab90b2dc9bfb9a6fc1ebb7445c3d96cc303120dcd27f29
Type fulltextMimetype application/pdf

By organisation
Department of Computer and Geospatial Sciences
Other Engineering and Technologies

Search outside of DiVA

GoogleGoogle Scholar
Total: 155 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 402 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard-cite-them-right
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • sv-SE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • de-DE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf