• Login
    View Item 
    •   Research Bank Home
    • Unitec Institute of Technology
    • Study Areas
    • Computing
    • Computing Dissertations and Theses
    • View Item
    •   Research Bank Home
    • Unitec Institute of Technology
    • Study Areas
    • Computing
    • Computing Dissertations and Theses
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    SAP®’s Univariate Sales Forecasting Functionality: An Empirical Study

    Catt, Peter

    Thumbnail
    Share
    View fulltext online
    fulltext.pdf (1.808Mb)
    Date
    2007
    Citation:
    Catt, P. M. (2007). SAP®’s Univariate Sales Forecasting Functionality: An Empirical Study. Unpublished thesis submitted in partial fulfillment of the degree of Doctor of Computing, Unitec New Zealand, New Zealand.
    Permanent link to Research Bank record:
    https://hdl.handle.net/10652/1275
    Abstract
    The accuracy of sales forecasts is a major determinant of inventory costs and service level driven revenues. Failure to establish future customer demand without a reasonable degree of certainty often leads to poor levels of customer service and/or high levels of the wrong inventory and resulting reductions in company profitability. Enterprise resource planning (ERP) systems such as SAP are widely adopted and typically contain sales forecasting functionality. The sales forecasting accuracy of ERP systems can have a critical impact on business profitability and empirical research into the effectiveness of ERP offerings should be considered a valuable endeavour. However, commonly adopted measures of forecast accuracy, such as mean absolute error (MAE) and mean absolute percentage error (MAPE), do not provide explicit costs associated with forecast errors. This thesis adopts a quantitative case study methodology to evaluate the nine forecasting models (2 moving average and 7 exponential smoothing) of SAP®’s enterprise resource planning system (SAP® ERP). The SAP forecast models are evaluated against both common statistical measures and commercial measures of forecast error, using a 24 month and 60 month product sales data set provided by a New Zealand based importer and retailer of electrical products. The forecast models are a combination of SAP default smoothing parameters, fitted smoothing parameters, baseline statistical forecasts, and event management adjusted forecasts resulting in a total of 38 forecast model combinations. The 38 forecast models are assessed using a rolling-origin holdout approach and evaluated against mean absolute error (MAE), mean absolute percentage error (MAPE), revenue-weighted mean absolute percentage error (RW-MAPE), and two new measures developed by the author; margin-weighted mean absolute percentage error (MW-MAPE) and cost of forecast error (CFE). The findings of the case study support the fitting of forecast smoothing parameters using historical data, the selection of forecasting models based on historical time series characteristics, i.e. level, trend, and seasonality, and length of available history. The study also supports the evaluation of sales forecasts with cost of forecast error (CFE) as a more commercially useful measure than the widely adopted mean absolute error (MAE) and mean absolute percentage error (MAPE) measures. Event management adjustment of baseline statistical forecasts was not found to be statistically significant. However, an argument is presented that significance testing should be de-emphasised in favour of effect size (forecast error cost reduction in the case of this study). However, the results should be viewed as case specific and reflect the particular time series characteristics, costs, and margins of the company in question. The study concludes with methodological recommendations for practitioners, ERP vendors, and academics which are supported by the specific case study results and the reviewed literature.
    Keywords:
    enterprise resource planning, sales forecasting, cost of forecast error, SAP
    ANZSRC Field of Research:
    Information, Computing and Communication Sciences (280000)
    Degree:
    Doctor of Philosphy (Computing and Information Technology), Unitec Institute of Technology
    Supervisors:
    Barbour, Robert H.; Robb, David J.
    Copyright Holder:
    Author

    Copyright Notice:
    All rights reserved
    Rights:
    This digital work is protected by copyright. It may be consulted by you, provided you comply with the provisions of the Act and the following conditions of use. These documents or images may be used for research or private study purposes. Whether they can be used for any other purpose depends upon the Copyright Notice above. You will recognise the author's and publishers rights and give due acknowledgement where appropriate.
    Metadata
    Show detailed record
    This item appears in
    • Computing Dissertations and Theses [90]

    Te Pūkenga

    Research Bank is part of Te Pūkenga - New Zealand Institute of Skills and Technology

    • About Te Pūkenga
    • Privacy Notice

    Copyright ©2022 Te Pūkenga

    Usage

    Downloads, last 12 months
    143
     
     

    Usage Statistics

    For this itemFor the Research Bank

    Share

    About

    About Research BankContact us

    Help for authors  

    How to add research

    Register for updates  

    LoginRegister

    Browse Research Bank  

    EverywhereInstitutionsStudy AreaAuthorDateSubjectTitleType of researchSupervisorCollaboratorThis CollectionStudy AreaAuthorDateSubjectTitleType of researchSupervisorCollaborator

    Te Pūkenga

    Research Bank is part of Te Pūkenga - New Zealand Institute of Skills and Technology

    • About Te Pūkenga
    • Privacy Notice

    Copyright ©2022 Te Pūkenga