Pharmacy Inventory Demand Forecast

This dataset provides detailed pharmaceutical inventory demand forecasts for pharmacies, leveraging historical demand and seasonal trends to predict future needs. It includes product and pharmacy identifiers, forecast periods, risk assessments, and recommended order quantities, supporting efficient inventory management and minimizing stockouts and waste.

  • opened 9 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Optimizing pharmaceutical inventory levels to reduce stockouts and waste

Sample rows

preview · 8 of 200 rows · all 22 columns
forecast_idstringproduct_unitstringseasonal_factorfloatproduct_categorystringpharmacy_idstringpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringpharmacy_countrystringproduct_idstringproduct_namestringforecast_period_startdateforecast_period_enddatehistorical_demandfloatforecasted_demandfloatcurrent_inventoryfloatrecommended_order_quantityfloatstockout_riskfloatwaste_riskfloatlast_updateddatetime
FCAST-0001tablet1.14analgesicPHRM-10101Central Pharmacy New York123 Main StNew YorkNY10001USAPRD-0001Acetaminophen 500mg2024-07-012024-07-1423002622120014220.090.132024-06-15T14:20:05
FCAST-0002capsule1.05antibioticPHRM-10102Lakeside Medical Supply45 Lakeshore DrChicagoIL60611USAPRD-0002Amoxicillin 250mg2024-07-052024-07-20950997.5200797.50.320.122024-06-18T09:10:25
FCAST-0003tablet1.01antihypertensivePHRM-10103Hilltop Pharmacy7 Hilltop AveDenverCO80202USAPRD-0003Lisinopril 10mg2024-07-102024-07-24680686.865036.80.080.182024-06-13T16:40:30
FCAST-0004tablet0.96antihypertensivePHRM-10104Bay Area Pharmacy88 Market StSan FranciscoCA94105USAPRD-0004Hydrochlorothiazide 25mg2024-07-182024-07-28520499.2350149.20.210.12024-06-20T10:25:18
FCAST-0005tablet1.08analgesicPHRM-10105Riverside Drugstore15 Riverside RdHoustonTX77002USAPRD-0005Ibuprofen 200mg2024-07-122024-07-221500162060010200.170.082024-06-09T18:01:35
FCAST-0006tablet0.99antidiabeticPHRM-10106Toronto Medical Center99 Queen St WTorontoONM5H2M9CanadaPRD-0006Metformin 500mg2024-07-012024-07-10120011884007880.260.112024-06-16T17:34:59
FCAST-0007tablet1.02hormonePHRM-10107Bristol Health Hub221 High StBristolBristolBS13HTUKPRD-0007Levothyroxine 50mcg2024-07-082024-07-21340346.8120226.80.30.142024-06-11T11:15:43
FCAST-0008vial1.2hormonePHRM-10108Sydney Chemist Warehouse12 Pitt StSydneyNSW2000AustraliaPRD-0008Insulin Glargine2024-06-202024-07-04800960509100.940.042024-06-05T15:36:27

What the 200 rows show

from the 200-row sample

Tablet (product unit) stands out: mean seasonal_factor is 1.1, against 1.3 for the rest.

  • 1.1median seasonal_factor
  • 9pharmacy countries
  • 56pharmacy states
  • 410.0median historical_demand
  • 482.3median forecasted_demand
  • 60.0median current_inventory
Mean seasonal_factor by product_unit181 rows
0121.1tablet141 rows1.2vial16 rows1.2capsule14 rows1.6ampule10 rows
seasonal_factor200 rows, in bands of 0.2
070140411311273420.81.62.2seasonal_factor →

Median 1.1, from 0.87 to 2.1.

product_category190 rows with a value · 10 left blank
  1. antihypertensive32
  2. analgesic22
  3. antibiotic19
  4. cholesterol13
  5. emergency12
  6. antidiabetic11
  7. hormone11
  8. antacid11
  9. anticonvulsant11
  10. antihistamine10
22 columns by typefrom the column list below
  • string 12
  • float 7
  • date 2
  • datetime 1

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 12 columns
forecast_idstringUnique identifier for each inventory demand forecast recorduniqueFCAST-0001
pharmacy_idstringUnique identifier for the pharmacy locationPHRM-10101
pharmacy_namestringName of the pharmacyLakeside Medical Supply
pharmacy_street_addressstringStreet address of the pharmacyoptional123 Main St
pharmacy_citystringCity where the pharmacy is locatedoptionalNew York
pharmacy_statestringState or province of the pharmacyoptionalNY
pharmacy_postal_codestringPostal code of the pharmacyoptional10001
pharmacy_countrystringCountry where the pharmacy is located9 countries · optionalUSA
product_idstringUnique identifier for the pharmaceutical productPRD-0001
product_namestringName of the pharmaceutical productAcetaminophen 500mg
product_categorystringCategory of the pharmaceutical product (e.g., antibiotic, analgesic)optionalanalgesic
product_unitstringUnit of measurement for the product (e.g., tablet, vial, bottle)4 units · optionaltablet
Numbers 7 columns
historical_demandfloatTotal historical demand for the product during the same period in previous years0 or more · optional2300
seasonal_factorfloatAdjustment factor based on seasonal trends (e.g., flu season)0 or more · optional1.14
forecasted_demandfloatPredicted demand for the product in the forecast period0 or more2622
current_inventoryfloatCurrent inventory level of the product at the pharmacy0 or more · optional1200
recommended_order_quantityfloatRecommended quantity to order to meet forecasted demand and avoid stockouts0 or more · optional1422
stockout_riskfloatEstimated risk (probability 0-1) of stockout during the forecast period0 to 1 · optional0.09
waste_riskfloatEstimated risk (probability 0-1) of overstock/waste during the forecast period0 to 1 · optional0.13
Dates and times 3 columns
forecast_period_startdateStart date of the forecast period2024-07-01
forecast_period_enddateEnd date of the forecast period2024-07-14
last_updateddatetimeTimestamp when the forecast record was last updated2024-06-15T14:20:05

Use it for

  • median seasona…1.1200 rowsmean seasonal factor …1.1tabl…1.2vial1.2caps…1.6ampu…

    A healthcare dashboard

    Seasonal_factor by product_unit and a breakdown of product_category. Excel, Power BI or Tableau.

  • Why do the 141 tablet rows have a mean seasonal_factor of 1.1?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable forecasts with pharmacy_id, pharmacy_name and pharmacy_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows22 columns
Yours1,000 rows22 columnspharmacy_street_address: UK only

blueprint · pharmacy-inventory-demand-forecast

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Track SKU-level stock movements
  • Log seasonal demand patterns
  • Include purchase order lead times
  • Flag excess and shortage events
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
pharmacy-inventory-demand-forecast

More in Healthcare

Browse all
Also in HealthcarePharmacy Inventory Movement DatasetHealthcare-Insurance Claims IntegrationEmergency Department Triage PatternsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.