Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Exponential smoothing method for forecasting drug expenditures

M M D'Sa1, R S Nakagawa, D S Hill

  • 1Division of Pharmacy Administration, Faculty of Pharmaceutical Sciences, University of British Columbia, Vancouver, Canada.

American Journal of Hospital Pharmacy
|October 15, 1994
PubMed
Summary

This study introduces an exponential smoothing model to forecast hospital pharmacy drug budgets, improving accuracy in four of six tested departments. The new model offers a more precise and user-friendly approach to budget planning.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Prevalence and factors associated with seizures among patients with infective encephalitis.

The Medical journal of Malaysia·2026
Same author

Exploring the role of quantitative electroencephalography in ischaemic stroke through spectral and topographic mapping.

The Medical journal of Malaysia·2025
Same author

The acute management of Pilon fractures (ENFORCE) study: a national evaluation of practice.

Annals of the Royal College of Surgeons of England·2024
Same author

Oral health assessment of epilepsy patients from a tertiary hospital in Asia.

The Medical journal of Malaysia·2024
Same author

What is a tibial pilon fracture and how should they be acutely managed? A survey of consultant British Orthopaedic Foot and Ankle Society members and non-members.

Annals of the Royal College of Surgeons of England·2023
Same author

Massa intermedia: an innocent bystander?

Acta neurologica Belgica·2023

Area of Science:

  • Health Economics
  • Pharmacy Management
  • Operations Research

Background:

  • Accurate hospital pharmacy drug budget forecasting is crucial for financial stability.
  • Existing forecasting methods may lack precision and ease of use.
  • The need for a statistically sound yet accessible forecasting model is evident.

Purpose of the Study:

  • To develop and evaluate an exponential smoothing model for forecasting hospital pharmacy drug budgets.
  • To assess the model's accuracy compared to current forecasting methods.
  • To determine the impact of workload variables on forecast accuracy.

Main Methods:

  • Developed a forecasting model using exponential smoothing, weighting recent data more heavily.
  • Incorporated drug expenditure data and workload variables (e.g., medication-order volume, inpatient days).

Related Experiment Videos

  • Tested the model on fiscal 1988-1992 drug budget data from 10 British Columbia hospital pharmacy departments.
  • Main Results:

    • The exponential smoothing model achieved a mean absolute deviation of 5.93%, compared to 8.70% for current methods in six departments.
    • The model demonstrated improved forecast accuracy in four of the six departments.
    • Using pharmacy medication-order volume as a workload variable yielded better forecasts than hospital inpatient days.

    Conclusions:

    • The exponential smoothing model offers a more accurate and user-friendly method for hospital pharmacy drug budget forecasting.
    • The model's performance suggests its potential for wider adoption in pharmacy financial planning.
    • Optimizing workload variable selection can further enhance forecasting precision.