AI Matrx Logo

Pool service

Saltmeadow Grove Pool Care · Pool service · Tucson, AZ

Umar Rosenquist manages the routes at Saltmeadow Grove Pool Care, a four-truck weekly pool service, and he uses this to see what sits on every shelf, reorder before a bucket runs empty and load the Monday truck count without retyping it.

Home servicesInventoryImports4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 checklist · 1 document · 1 notification · 2 stage rule sets · 1 agent
Use this template

Stock board

Supplies
In stock17
Liquid chlorine 12.5%, 1-gal jugSG-101Sanitizer
Trichlor 3-inch tablets, 50 lb bucketSG-102Sanitizer
Calcium hypochlorite shock, case of 12 one-pound bagsSG-104Sanitizer
Pool salt for chlorine generators, 40 lb bagSG-106Sanitizer
Muriatic acid 31.45%, 1-gal jugSG-201Balancer
12 more
Low8
Dichlor granules, 25 lb bucketSG-103Sanitizer
Stabilizer (cyanuric acid), 50 lb bucketSG-105Sanitizer
Calcium hardness increaser, 25 lb bucketSG-204Balancer
Water clarifier, 1-gal jugSG-303Algae control
DPD chlorine reagent, 2 oz bottleSG-502Test supplies
3 more
On order4
Alkalinity increaser (baking soda), 50 lb bagSG-203Balancer
Sodium bisulfate pH decreaser, 25 lb bucketSG-205Balancer
Cartridge filter, 50 sq ftSG-404Filter media
Chlorinator check valveSG-605Pump and plumbing parts
Out1
Total alkalinity titration refillSG-504Test supplies

Tables

Supplies

30 sample rows · 16 columns

Every chemical, filter part and test kit the routes use, with how many are on the shelf and when to reorder.

SupplySKUCategoryUsual supplierUnitOn handReorder at
Algaecide 60%, 1-gal jugSG-301Algae controlOcotillo Basin Pool SupplyGallon jug118
Phosphate remover, 1-gal jugSG-302Algae controlIronwood Aquatic SupplyGallon jug64
Water clarifier, 1-gal jugSG-303Algae controlIronwood Aquatic SupplyGallon jug34
Metal sequestrant, 1-gal jugSG-304Algae controlIronwood Aquatic SupplyGallon jug73
Muriatic acid 31.45%, 1-gal jugSG-201BalancerSaguaro Chemical WholesaleGallon jug2824
pH increaser (soda ash), 25 lb bucketSG-202BalancerOcotillo Basin Pool Supply25 lb bucket43
Alkalinity increaser (baking soda), 50 lb bagSG-203BalancerOcotillo Basin Pool Supply50 lb bag02
Calcium hardness increaser, 25 lb bucketSG-204BalancerOcotillo Basin Pool Supply25 lb bucket22
Sodium bisulfate pH decreaser, 25 lb bucketSG-205BalancerSaguaro Chemical Wholesale25 lb bucket12
DE filter powder, 25 lb bagSG-401Filter mediaArroyo Pump and Filter Parts25 lb bag96
Filter sand grade 20, 50 lb bagSG-402Filter mediaArroyo Pump and Filter Parts50 lb bag1410
Cartridge filter, 100 sq ftSG-403Filter mediaArroyo Pump and Filter PartsEach64

18 more rows

Restock orders

12 sample rows · 10 columns

Every order placed with a supplier, from the day it goes out to the day it lands on the shelf.

Order numberSupplyQuantityOrder totalOrder statusOrdered onExpected on
PO-2408Sodium bisulfate pH decreaser, 25 lb bucket4$232PlacedOct 16, 2026Oct 19, 2026
PO-2407Chlorinator check valve4$190PlacedOct 15, 2026Oct 21, 2026
PO-2406Cartridge filter, 50 sq ft6$444PlacedOct 14, 2026Oct 20, 2026
PO-2409Alkalinity increaser (baking soda), 50 lb bag5$182.50PlacedOct 13, 2026Oct 18, 2026
PO-2404Algaecide 60%, 1-gal jug16$358.40DeliveredOct 9, 2026Oct 12, 2026
PO-2402Six-way test strips, tub of 10020$295DeliveredOct 7, 2026Oct 10, 2026
PO-2405Telescoping pole, 8 to 16 ft4$156CancelledOct 5, 2026Oct 9, 2026
PO-2400Muriatic acid 31.45%, 1-gal jug48$220.80DeliveredOct 4, 2026Oct 8, 2026
PO-2398Liquid chlorine 12.5%, 1-gal jug96$369.60DeliveredOct 2, 2026Oct 6, 2026
PO-2399Pool salt for chlorine generators, 40 lb bag80$512DeliveredSep 30, 2026Oct 5, 2026
PO-2401DE filter powder, 25 lb bag12$414DeliveredSep 28, 2026Oct 3, 2026
PO-2403Pump lid O-ring, 2-inch30$96DeliveredSep 26, 2026Oct 1, 2026

Suppliers

6 sample rows · 8 columns

The wholesalers the shop buys from, with the rep, the delivery day and what ships free.

SupplierSales repRep phoneRep emailAccount numberDelivery leadFree delivery over
Arroyo Pump and Filter PartsTobias Wennerstrom(520) 555-0173tobias.wennerstrom@arroyopumpfilter.netAPF-88314$300
Cholla Lab and Test SupplyWilhelmina Eklund(520) 555-0174wilhelmina.eklund@chollalabsupply.comCL-55202$150
Ironwood Aquatic SupplyCalliope Brandvold(520) 555-0176calliope.brandvold@ironwoodaquatic.comIA-704153$200
Ocotillo Basin Pool SupplyMarisela Quintrell(520) 555-0172marisela.quintrell@ocotillobasinpool.comOB-227643$250
Palo Verde Equipment DistributingEmeka Thornquist(520) 555-0175emeka.thornquist@paloverdeequip.netPVE-312075$350
Saguaro Chemical WholesaleBenedikt Alvarsson(520) 555-0171benedikt.alvarsson@saguaro-chem-wholesale.comSCW-409182$400

Also included

  • Stock levelStage rules
  • Restock orderStage rules
  • Low supplies each morningDigest
  • Monday shelf countChecklist
  • Order confirmation to supplierDocumentThe note sent with a restock order so the supplier can confirm the quantity and delivery day.
  • Supply is lowNotificationTells the warehouse lead the moment a supply drops to its reorder count.

Related templates