Stock snapshot01 Sep 2026 · Office quantities · D.S through Aug
Scope
Filters
No filters applied — showing everything you have access to
1 Office
2 BU
3 Agency
4 Zone
5 Supervisor
6 Team Leader
7 Rep
8 Items
Office0
›
BU0
›
Agency0
Zone0
Items0
Supervisor0
Team Leader0
Rep0
Stock
🔍
Active
Report workspaceSelect a section without reducing the report canvas
ESC to close
Performance
Inventory
People
⭐ Today's Brief
A 60-second summary before you dive in — the biggest risks, the biggest wins, and where to look next. Every card jumps straight to the detail.
⚠ Needs attention — top 3
🏆 What's working — top 3
Jump to a page
Achievement
Monthly Performance
BU Performance Ranking
Performance Heat Matrix — all periods
Item Intelligence
Quick Stats
Run Rate
Q1 vs Q2 — BU Comparison
⚠ BU Alert Strip — Needs Attention
Pareto focus — the items actually driving your gap
Sorted by shortfall size · the line shows what share of the total gap each item adds
0 items
Click a company row to expand or collapse its items
Item ↕
Quarter
Stock
Expiry Risk
Target
Achieved
Ach %
YTG
Unit
Value
Qty at Risk
Days Left
Find an Item
📋
Select an item to view its profile
Performance, target progress, stock and expiry details will appear here.
Company Overview
YTD performance per office & company
▾ Click any company to view its items
🎯 Executive Scorecard — 80% target line
Sorted worst-first · growth compares this quarter's achieved value to last quarter's
Company
Achievement (line = 80% target)
%
Status
vs Q1
📉 Stock Dashboard — Office Store
Available + QC | Real-time expiry
Stock by BU — Available vs QC
Expiry Risk Distribution
📊 Stock Value TableQuantities and values per item
Brand
Item
Price ($)
Available Qty
QC Qty
Available Value ($)
Max Expiry
Batch Detail — every batch listed individually
BU
Item
Zone
Qty
Expiry
Days Left
Status
🗺 Zone Intelligence
Where at-risk central stock can be saved by moving it, and what waiting costs us
📊 Item performance overview
Target, achievement, and office stock for every item in scope · Value and Unit shown side by side
⚠ Critical risk — 6+ months to expiry, high stock value, very low achievement
Item
Expiry
Stock Value
Ach% (V)
Ach% (U)
All items in scope
Item
Target (V)
Achieved (V)
Ach% (V)
Target (U)
Achieved (U)
Ach% (U)
Stock Value
Units
Batches
📂 Zone Stock
Drugstore stock per governorate — quantity and expiry date only, no analysis
Uses the same BU / Company / Zone filters at the top of the page
Quantity by item × zone
Cell shade = quantity · hover a cell for its expiry date
LowHigh
📋 Stock Detail
Zone
BU
Company
Item
Quantity
Expiry Date
GM Inventory Control
Office Expiry Intelligence
A forward-looking view of saleable office inventory. It combines batch expiry with D.S sales velocity to estimate which quantities and values may remain unsold at expiry.
01 Sep 2026Office stock snapshot Available-for-sale only
i
September update: quantities in this page are the office balance available for sale on 01 September 2026. QC and wholesaler stock are excluded. Forecasts use D.S unit sales from January–August 2026.
Priority BUsForecast expiry value ranked by BU
Forecast overviewExpected outcome based on current D.S velocity and FEFO
Priority
Product
D.S sales velocity
Expiry window
Expiry forecast
Rank
BU
Company
Item
Available qty
Avg / month
Months sold
Months left
Expiry date
Forecast qty
Forecast value
Status
Forecast method: average monthly D.S units = net Jan–Aug sales ÷ 8 calendar months. Expected consumption is allocated to the earliest-expiring batches first (FEFO). Forecast quantity is the estimated balance remaining when each batch expires; forecast value uses the current office unit price. This is a planning estimate and should be reviewed after every stock or sales refresh.
👥 Team
Field team structure and target distribution across provinces, reps, and lines · follows the Period/Value-Units/Office/BU/Manager/Supervisor/Team Leader/Rep filters above
🏗 Team structureAl-Naama Total › BU › Supervisor › Zone › Team Leader › Line › Rep › Item · click a row to expand
Level
Target (Value)
Achieved (Value)
Ach % (Value)
Target (Unit)
Achieved (Unit)
Ach % (Unit)
🌍 Target by Zone / RegionCoverage vs. open positions per region
Zone / Region
Target (Value)
Achieved (Value)
Ach %
Reps present
Vacant
Status
⚠ Reps needing attentionAchievement below 60%
Rep
Target → Achieved
Ach %
👤 Vacant positions — action priorityRanked by target value at stake
Location
Reports to
Target at stake
🌎 Target by Province
Province
Target
Achieved
Ach %
📑 Target by Line
Line
Target
Achieved
Ach %
🎯 My Dashboard
Your target, achievement, and stock — nothing else
📍 Stock in my zone
Item
Qty
Expiry
S.M
🏢 Stock in office
Item
Qty
Expiry
S.M
✅ Performing well
Item
Target
Achieved
Ach %
⚠ Needs attention
Item
Target
Achieved
Ach %
✅ Reps performing well
Rep
Target
Achieved
Ach %
CPA %
⚠ Reps below target
Rep
Target
Achieved
Ach %
CPA %
📄 Update Report Data
ⓘ Required sheets from the Excel file:
DS Value2026.D.S - Value HQ1/Q2/S1/2026 + Jun
DS Unit2026.D.S - Unit HQ1/Q2 units
ST Value2026.ST - ValueQ1/Q2/S1/2026
YTDYTD ST & D.SCompany-level totals
📤
Drag a CSV file here or click to browse
Export the required sheet from Google Sheets as CSV
CSVUTF-8
Data type in this file:
Processing...
🧠 Quick Check — keep the key numbers top of mind
3 quick questions from your own live data. Pick an answer to see if you're right.