IDEAS home Printed from https://ideas.repec.org/a/jfr/afr111/v9y2020i3p13.html
   My bibliography  Save this article

The Reduced Rules Rule Based Forecasting Decision Support System: Details and Functionalities: An Audit Context

Author

Listed:
  • Manuel Bern
  • Edward Lusk

Abstract

In execution of PCAOB audits at the Planning and Substantive Phases, forecasts of various financial account balances are often used to collect information on the veracity of the client’s final reported balances. One of the forecast methods widely acclaimed in the academic context is the Rule Based Forecasting [RBF] model of Collopy and Armstrong [C&A]. However, for the most part, the RBF has not found its way into the panoply of the auditor. In our practice-oriented experiential context, the reason for this seems to be the lack of an enabling Decision Support System[DSS] usually needed to create reliable RBF-forecasts in a timely manner needed at the Substantive Phase of the audit. Focus In this report, we detail a GUI-friendly DSS, the VBA-programming of which is based upon a 2013 revision of an updated C&A model offered by Adya and Lusk. The DSS is called- The Reduced Rules- Rule Based Forecasting- Decision Support System [RR-RBF-DSS]. We provide a comprehensive example of the RR-RBF-DSS in a PCAOB-audit context for a Caterpillar™, Inc.Ò account Panel downloaded from Bloomberg™. This example, carefully details all of the numerous User Form-Launch platforms as well as discusses the statistical and operational Rule-scoring functionalities of the RR-RBF-DSS. The RR-RBF-DSS is available as a download without cost or restrictions on its use.

Suggested Citation

  • Manuel Bern & Edward Lusk, 2020. "The Reduced Rules Rule Based Forecasting Decision Support System: Details and Functionalities: An Audit Context," Accounting and Finance Research, Sciedu Press, vol. 9(3), pages 1-13, August.
    • Handle: RePEc:jfr:afr111:v:9:y:2020:i:3:p:13
    as

    Download full text from publisher

    File URL: https://www.sciedupress.com/journal/index.php/afr/article/download/18408/11505
    Download Restriction: no
    File URL: https://www.sciedupress.com/journal/index.php/afr/article/view/18408
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Makridakis, Spyros & Hibon, Michele & Lusk, Ed & Belhadjali, Moncef, 1987. "Confidence intervals: An empirical investigation of the series in the M-competition," International Journal of Forecasting, Elsevier, vol. 3(3-4), pages 489-508.
    2. Adya, Monica, 2000. "Corrections to rule-based forecasting: findings from a replication," International Journal of Forecasting, Elsevier, vol. 16(1), pages 125-127.
    3. Adya, Monica & Collopy, Fred & Armstrong, J. Scott & Kennedy, Miles, 2001. "Automatic identification of time series features for rule-based forecasting," International Journal of Forecasting, Elsevier, vol. 17(2), pages 143-157.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Edward J. Lusk, 2019. "Time Series Forecasting in Stock Trading Markets: The Turning Point Curiosity," International Journal of Research in Business and Social Science (2147-4478), Center for the Strategic Studies in Business and Finance, vol. 8(4), pages 01-16, July.
    2. Armstrong, J. Scott, 2006. "Findings from evidence-based forecasting: Methods for reducing forecast error," International Journal of Forecasting, Elsevier, vol. 22(3), pages 583-598.
    3. Adya, Monica & Armstrong, J. Scott & Collopy, Fred & Kennedy, Miles, 2000. "An application of rule-based forecasting to a situation lacking domain knowledge," International Journal of Forecasting, Elsevier, vol. 16(4), pages 477-484.
    4. Thiyanga S. Talagala & Feng Li & Yanfei Kang, 2019. "Feature-based Forecast-Model Performance Prediction," Monash Econometrics and Business Statistics Working Papers 21/19, Monash University, Department of Econometrics and Business Statistics.
    5. Thomassey, Sebastien & Happiette, Michel & Castelain, Jean Marie, 2005. "A short and mean-term automatic forecasting system--application to textile logistics," European Journal of Operational Research, Elsevier, vol. 161(1), pages 275-284, February.
    6. Fildes, Robert & Petropoulos, Fotios, 2015. "Simple versus complex selection rules for forecasting many time series," Journal of Business Research, Elsevier, vol. 68(8), pages 1692-1701.
    7. Thiyanga S Talagala & Rob J Hyndman & George Athanasopoulos, 2018. "Meta-learning how to forecast time series," Monash Econometrics and Business Statistics Working Papers 6/18, Monash University, Department of Econometrics and Business Statistics.
    8. Han, Weiwei & Wang, Xun & Petropoulos, Fotios & Wang, Jing, 2019. "Brain imaging and forecasting: Insights from judgmental model selection," Omega, Elsevier, vol. 87(C), pages 1-9.
    9. Athanasopoulos, George & Hyndman, Rob J. & Song, Haiyan & Wu, Doris C., 2011. "The tourism forecasting competition," International Journal of Forecasting, Elsevier, vol. 27(3), pages 822-844.
    10. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios & Chen, Zhi & Gaba, Anil & Tsetlin, Ilia & Winkler, Robert L., 2022. "The M5 uncertainty competition: Results, findings and conclusions," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1365-1385.
    11. Fildes, Robert & Petropoulos, Fotios, 2013. "An evaluation of simple forecasting model selection rules," MPRA Paper 51772, University Library of Munich, Germany.
    12. Makridakis, Spyros & Hyndman, Rob J. & Petropoulos, Fotios, 2020. "Forecasting in social settings: The state of the art," International Journal of Forecasting, Elsevier, vol. 36(1), pages 15-28.
    13. Arvan, Meysam & Fahimnia, Behnam & Reisi, Mohsen & Siemsen, Enno, 2019. "Integrating human judgement into quantitative forecasting methods: A review," Omega, Elsevier, vol. 86(C), pages 237-252.
    14. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios, 2020. "The M4 Competition: 100,000 time series and 61 forecasting methods," International Journal of Forecasting, Elsevier, vol. 36(1), pages 54-74.
    15. Adya, Monica & Collopy, Fred & Armstrong, J. Scott & Kennedy, Miles, 2001. "Automatic identification of time series features for rule-based forecasting," International Journal of Forecasting, Elsevier, vol. 17(2), pages 143-157.
    16. Allen, P. Geoffrey & Morzuch, Bernard J., 1995. "Comparing probability forecasts derived from theoretical distributions," International Journal of Forecasting, Elsevier, vol. 11(1), pages 147-157, March.
    17. Armstrong, J. Scott & Brodie, Roderick J., 1999. "Forecasting for Marketing," MPRA Paper 81690, University Library of Munich, Germany.
    18. Manuel R. Arahal & Manuel G. Ortega & Manuel G. Satué, 2021. "Chiller Load Forecasting Using Hyper-Gaussian Nets," Energies, MDPI, vol. 14(12), pages 1-15, June.
    19. J. Scott Armstrong & Kesten C. Green, 2005. "Demand Forecasting: Evidence-based Methods," Monash Econometrics and Business Statistics Working Papers 24/05, Monash University, Department of Econometrics and Business Statistics.
    20. JS Armstrong, 2004. "Forecasting for Environmental Decision Making," General Economics and Teaching 0412023, University Library of Munich, Germany.

    More about this item

    JEL classification:

    • R00 - Urban, Rural, Regional, Real Estate, and Transportation Economics - - General - - - General
    • Z0 - Other Special Topics - - General

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:jfr:afr111:v:9:y:2020:i:3:p:13. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sciedu Press (email available below). General contact details of provider: https://edirc.repec.org/data/cepflch.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.