Skip to content

Application demo

PR Compass — OPEX PR Tracker

A portfolio simulation of the tracker I build for OPEX purchase requisitions: one table, one truth for PR status, ageing, requestor and cost centre ownership. Search, filter and sort are fully interactive.

Illustrative / Demo Data — No Confidential Company Information

Status logic

  1. Submitted
  2. Ordering
  3. Ordered
  4. Receiving
  5. Received

Composing PRs are not yet in the approval pipeline. Denied and cancelled PRs are routed to the cancelled-PR archive and excluded from open commitment values.

Ageing = Today − Date Submitted

PRs in view

64

Value in view

$4.8M

Open PR value

$2.4M

Average ageing

Calculated from today's date

Portfolio simulation using demo data — no confidential company information.
DescriptionCompanyRequestorPreparerProcurement userCost centre
1PR-4802152026-04-172026-05-16$58,400CancelledContract labour — facility operations3000A. RahmanAnalyst 01Proc. Buyer CCC-1010
2PR-4802222026-04-212026-05-06$144,700OrderedTool installation support services3000S. MenonAnalyst 03Proc. Buyer ACC-2040
3PR-4802292026-02-222026-04-23$99,000OrderedUPS battery bank replacement3000L. FernandesAnalyst 02Proc. Buyer CCC-4120
4PR-4802362026-06-152026-07-07$94,300CancelledUPS battery bank replacement1000M. GuptaAnalyst 02Proc. Buyer BCC-3075
5PR-4802432026-07-152026-09-09$101,700OrderingBMS software licence renewal2000L. FernandesAnalyst 02Proc. Buyer ACC-5300
6PR-4802502026-05-252026-07-26$90,600DeniedCleanroom garment laundering services1000A. RahmanAnalyst 03Proc. Buyer BCC-1010
7PR-4802572026-05-252026-07-22$132,900ComposingCleanroom garment laundering services1000A. RahmanAnalyst 03Proc. Buyer CCC-2040
8PR-4802642026-03-052026-05-12$103,000DeniedUPS battery bank replacement3000A. RahmanAnalyst 02Proc. Buyer CCC-4120
9PR-4802712026-07-032026-08-05$103,200OrderedElectrical spares replenishment2000S. MenonAnalyst 01Proc. Buyer ACC-2040
10PR-4802782026-07-262026-10-02$14,300OrderingElectrical spares replenishment3000A. RahmanAnalyst 01Proc. Buyer CCC-4120
11PR-4802852026-02-122026-04-13$82,100ComposingHVAC filter replacement consumables3000M. GuptaAnalyst 02Proc. Buyer ACC-1010
12PR-4802922026-03-212026-04-08$116,000ComposingWater treatment chemicals supply2000L. FernandesAnalyst 02Proc. Buyer ACC-3075
13PR-4802992026-03-042026-03-19$50,100ComposingHVAC filter replacement consumables1000L. FernandesAnalyst 01Proc. Buyer ACC-2040
14PR-4803062026-06-112026-08-21$48,800ComposingAnnual chiller preventive maintenance contract2000S. MenonAnalyst 03Proc. Buyer CCC-1010
15PR-4803132026-03-072026-04-25$34,500OrderingFire system inspection services1000M. GuptaAnalyst 01Proc. Buyer CCC-2040
16PR-4803202026-06-072026-08-16$110,900OrderedTool installation support services2000L. FernandesAnalyst 02Proc. Buyer ACC-5300
17PR-4803272026-02-062026-03-06$131,400ComposingAnnual chiller preventive maintenance contract3000M. GuptaAnalyst 02Proc. Buyer BCC-3075
18PR-4803342026-02-262026-04-11$17,600ComposingUPS battery bank replacement2000A. RahmanAnalyst 02Proc. Buyer ACC-1010
19PR-4803412026-06-222026-08-12$101,700DeniedTool installation support services2000S. MenonAnalyst 03Proc. Buyer BCC-5300
20PR-4803482026-05-012026-06-11$143,500DeniedCleanroom garment laundering services3000S. MenonAnalyst 02Proc. Buyer ACC-4120
21PR-4803552026-07-182026-09-15$42,000SubmittedElectrical spares replenishment3000L. FernandesAnalyst 03Proc. Buyer CCC-4120
22PR-4803622026-04-022026-04-30$110,200DeniedContract labour — facility operations2000L. FernandesAnalyst 01Proc. Buyer BCC-2040
23PR-4803692026-03-142026-04-03$116,500SubmittedFire system inspection services2000L. FernandesAnalyst 03Proc. Buyer ACC-1010
24PR-4803762026-05-022026-05-21$120,800OrderingContract labour — facility operations2000S. MenonAnalyst 01Proc. Buyer CCC-5300
25PR-4803832026-04-042026-05-28$35,500ComposingFire system inspection services1000M. GuptaAnalyst 03Proc. Buyer BCC-5300
26PR-4803902026-07-232026-09-21$124,100ComposingAnnual chiller preventive maintenance contract1000A. RahmanAnalyst 03Proc. Buyer CCC-4120
27PR-4803972026-04-282026-06-02$42,500ReceivingContract labour — facility operations3000K. IyerAnalyst 01Proc. Buyer BCC-3075
28PR-4804042026-06-152026-06-30$66,000OrderingAnnual chiller preventive maintenance contract2000M. GuptaAnalyst 02Proc. Buyer ACC-2040
29PR-4804112026-05-022026-06-09$24,500ReceivingFire system inspection services3000L. FernandesAnalyst 01Proc. Buyer ACC-2040
30PR-4804182026-06-022026-08-11$84,600CancelledFire system inspection services2000L. FernandesAnalyst 03Proc. Buyer CCC-1010
31PR-4804252026-03-292026-06-07$60,300SubmittedFire system inspection services2000K. IyerAnalyst 02Proc. Buyer CCC-1010
32PR-4804322026-05-172026-06-02$131,600ComposingTool installation support services2000M. GuptaAnalyst 02Proc. Buyer CCC-4120
33PR-4804392026-05-132026-07-05$134,100CancelledTool installation support services1000M. GuptaAnalyst 03Proc. Buyer BCC-2040
34PR-4804462026-04-262026-06-20$23,200OrderingFire system inspection services3000L. FernandesAnalyst 01Proc. Buyer ACC-1010
35PR-4804532026-07-072026-07-29$33,000ReceivingHVAC filter replacement consumables3000M. GuptaAnalyst 01Proc. Buyer BCC-1010
36PR-4804602026-05-272026-08-06$68,600SubmittedElectrical spares replenishment3000M. GuptaAnalyst 03Proc. Buyer ACC-1010
37PR-4804672026-02-192026-04-14$42,600OrderingElectrical spares replenishment3000A. RahmanAnalyst 02Proc. Buyer ACC-4120
38PR-4804742026-06-192026-08-02$98,000OrderingUPS battery bank replacement2000L. FernandesAnalyst 01Proc. Buyer ACC-1010
39PR-4804812026-05-112026-06-10$128,900ReceivingFire system inspection services2000M. GuptaAnalyst 03Proc. Buyer ACC-1010
40PR-4804882026-05-142026-07-01$72,500ReceivedContract labour — facility operations2000M. GuptaAnalyst 02Proc. Buyer CCC-3075
41PR-4804952026-07-092026-08-11$71,300SubmittedFire system inspection services3000S. MenonAnalyst 03Proc. Buyer CCC-5300
42PR-4805022026-04-022026-05-13$21,000DeniedFire system inspection services3000M. GuptaAnalyst 03Proc. Buyer ACC-5300
43PR-4805092026-03-132026-04-05$84,200ReceivedContract labour — facility operations2000A. RahmanAnalyst 03Proc. Buyer ACC-4120
44PR-4805162026-05-302026-06-24$48,800OrderingElectrical spares replenishment3000K. IyerAnalyst 01Proc. Buyer BCC-3075
45PR-4805232026-07-182026-08-22$26,300DeniedWater treatment chemicals supply3000A. RahmanAnalyst 01Proc. Buyer BCC-4120
46PR-4805302026-02-062026-04-07$10,200ReceivedCleanroom garment laundering services1000K. IyerAnalyst 02Proc. Buyer BCC-5300
47PR-4805372026-06-022026-07-26$65,600OrderedCleanroom garment laundering services1000S. MenonAnalyst 01Proc. Buyer ACC-1010
48PR-4805442026-03-082026-05-08$107,900ReceivingBMS software licence renewal1000M. GuptaAnalyst 03Proc. Buyer BCC-2040
49PR-4805512026-07-292026-09-27$84,000ReceivingUPS battery bank replacement3000L. FernandesAnalyst 03Proc. Buyer BCC-2040
50PR-4805582026-04-062026-06-14$14,000ReceivedUPS battery bank replacement2000A. RahmanAnalyst 03Proc. Buyer ACC-1010
51PR-4805652026-04-272026-05-31$25,300SubmittedElectrical spares replenishment3000A. RahmanAnalyst 03Proc. Buyer CCC-4120
52PR-4805722026-06-082026-07-31$70,400OrderingHVAC filter replacement consumables2000L. FernandesAnalyst 01Proc. Buyer CCC-4120
53PR-4805792026-03-082026-03-28$22,100ComposingBMS software licence renewal3000S. MenonAnalyst 03Proc. Buyer CCC-1010
54PR-4805862026-06-282026-08-03$15,800OrderingWater treatment chemicals supply3000K. IyerAnalyst 01Proc. Buyer BCC-1010
55PR-4805932026-02-132026-04-23$65,100DeniedTool installation support services1000L. FernandesAnalyst 03Proc. Buyer CCC-3075
56PR-4806002026-07-182026-09-04$55,100SubmittedBMS software licence renewal3000S. MenonAnalyst 01Proc. Buyer BCC-5300
57PR-4806072026-02-272026-05-06$49,100OrderingWater treatment chemicals supply3000M. GuptaAnalyst 01Proc. Buyer ACC-1010
58PR-4806142026-02-162026-04-20$90,300SubmittedBMS software licence renewal1000M. GuptaAnalyst 01Proc. Buyer ACC-2040
59PR-4806212026-03-162026-04-13$30,800ReceivingWater treatment chemicals supply2000S. MenonAnalyst 03Proc. Buyer ACC-3075
60PR-4806282026-06-042026-07-29$76,500ComposingHVAC filter replacement consumables2000L. FernandesAnalyst 01Proc. Buyer ACC-5300
61PR-4806352026-03-112026-04-08$128,000OrderingContract labour — facility operations1000S. MenonAnalyst 02Proc. Buyer CCC-3075
62PR-4806422026-07-282026-10-09$61,500DeniedWater treatment chemicals supply3000L. FernandesAnalyst 01Proc. Buyer BCC-5300
63PR-4806492026-07-032026-09-03$117,300DeniedFire system inspection services1000S. MenonAnalyst 03Proc. Buyer CCC-1010
64PR-4806562026-04-302026-06-30$133,400OrderingFire system inspection services3000K. IyerAnalyst 03Proc. Buyer ACC-3075