Full Text Available
Note: Clicking the button above will open the full text document at the original institutional repository in a new window.
How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand
Mini Dissertation (B Eng. (Industrial and Systems Engineering))--University of Pretoria, 2018.
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | English English |
| Published: |
University of Pretoria. Faculty of Engineering, Built Environment and Information Technology. Dept. of Industrial and Systems Engineering
2019
|
| Subjects: | |
| Tags: |
No Tags, Be the first to tag this record!
|
| _version_ | 1867613645076168704 |
|---|---|
| access_status_str | Open Access |
| author | Vally, Mohammed Alli |
| author_browse | Vally, Mohammed Alli |
| author_facet | Vally, Mohammed Alli |
| author_sort | Vally, Mohammed Alli |
| collection | Thesis |
| dc_rights_str_mv | © 2018 University of Pretoria. All rights reserved. The copyright in this work vests in the University of Pretoria. No part of this work may be reproduced or transmitted in any form or by any means, without the prior written permission of the University of Pretoria. |
| description | Mini Dissertation (B Eng. (Industrial and Systems Engineering))--University of Pretoria, 2018. |
| format | Thesis |
| id | oai:repository.up.ac.za:2263/68344 |
| institution | University of Pretoria (South Africa) |
| language | English English |
| last_indexed | 2026-06-10T12:39:26.088Z |
| license_str | Other — see source repository |
| provenance_str_mv | Harvested via OAI-PMH from UPSpace — University of Pretoria Institutional Repository |
| publishDate | 2019 |
| publishDateRange | 2019 |
| publishDateSort | 2019 |
| publisher | University of Pretoria. Faculty of Engineering, Built Environment and Information Technology. Dept. of Industrial and Systems Engineering |
| publisherStr | University of Pretoria. Faculty of Engineering, Built Environment and Information Technology. Dept. of Industrial and Systems Engineering |
| record_format | dspace |
| source_str | UPSpace — University of Pretoria Institutional Repository |
| spelling | oai:repository.up.ac.za:2263/68344 How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand Vally, Mohammed Alli Mini-dissertations (Industrial and Systems Engineering) Mini Dissertation (B Eng. (Industrial and Systems Engineering))--University of Pretoria, 2018. SPAR-Roodeplaat is part of an international group of independently owned and operated retailers who work together in partnership under the SPAR franchise brand. The store does not only offer a wide range of day-to-day grocery products, but they also have their own in-store bakery, deli and butchery. SPAR has been finding inventory management and planning of their ‘departments’ (bakery and deli) challenging as they do not have a set ordering system in place. Products produced by the bakery and deli are perishable items as the freshness of these products decrease daily and therefore can only be sold to customers for a few days. Consequently, items not sold at the end of the day are considered as wastage and this leads to a loss. However, running out of stock also leads to a loss of revenue and will have an impact on customer satisfaction. An ABC analysis was conducted to investigate the problem and to determine the number of stock-outs occurring. A literature review was conducted to obtain a better understanding of the problem and to get a general idea of how similar problems were solved. After reviewing the appropriate literature, the project goals have been determined. The project aim is to determine the most accurate and appropriate forecasting technique to be used for the bakery and deli departments. Numerous forecasting techniques were investigated but emphasis was placed on multiple linear regression, Prophet forecasting, autoregressive integrated moving average (ARIMA) and artificial neural networks (ANN) models. The four models mentioned above were developed using R and were compared using four metrics to determine the most accurate model. Mean average percentage error (MAPE), mean average squared error (MASE), mean absolute difference (MDAE) and mean average error (MAE) were the four metrics used. The overall accuracy, as per experimentation, and other practical reasons have concluded that Prophet forecasting is both the most practical and accurate of the four algorithms as defined by the methodology of this project. However, recommended improvements to be made include further optimisation of each model, the inclusion of promotional dates and better understanding of the each product unique time series. A proposed implementation plan has also been discussed. The visual form of a Gantt chart was used as a guideline to complete the necessary activities within the given deadlines. On completion of this project, it is apparent that an accurate forecasting model will make inventory planning easier within their bakery and deli departments. An accurate forecasting model will not only assist the retail store with production and inventory planning, but will also be useful when making important business decisions in areas of finance and marketing. 2019-01-31T13:04:14Z 2019-01-31T13:04:14Z 2018 2018 Mini Dissertation http://hdl.handle.net/2263/68344 en en © 2018 University of Pretoria. All rights reserved. The copyright in this work vests in the University of Pretoria. No part of this work may be reproduced or transmitted in any form or by any means, without the prior written permission of the University of Pretoria. PDF application/pdf University of Pretoria. Faculty of Engineering, Built Environment and Information Technology. Dept. of Industrial and Systems Engineering |
| spellingShingle | Mini-dissertations (Industrial and Systems Engineering) Vally, Mohammed Alli How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title | How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title_full | How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title_fullStr | How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title_full_unstemmed | How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title_short | How Much Will They Buy? Optimal Forecast Selection for Predicting a Bakery’s Demand |
| title_sort | how much will they buy optimal forecast selection for predicting a bakery s demand |
| topic | Mini-dissertations (Industrial and Systems Engineering) |
| url | http://hdl.handle.net/2263/68344 |
| work_keys_str_mv | AT vallymohammedalli howmuchwilltheybuyoptimalforecastselectionforpredictingabakerysdemand |