AI Matrx Logo

Car wash

Thornhollow Creek Car Wash · Car wash · Columbus, OH

Lucia Lorenzetti manages Thornhollow Creek Car Wash, an express tunnel wash on the east side of Columbus, and she uses this so no chemical, tunnel part or sundry ever runs short: each weekend sheet updates what is on the shelf and new items join the list without a duplicate.

AutomotiveInventoryImports4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

Stock board

Supplies
In stock18
Triple foam conditionerCW-4102Soaps and chemicals
Low-pH presoakCW-4113Soaps and chemicals
Bug and tar removerCW-4126Soaps and chemicals
Spot-free rinse additiveCW-4134Waxes and drying aids
Ceramic sealantCW-4145Waxes and drying aids
13 more
Reorder now8
Wheel cleaner, acid-freeCW-4121Soaps and chemicals
Drying agentCW-4152Waxes and drying aids
Wash mitts, chenilleCW-4171Brushes and cloth
Foam brush replacement bundleCW-4189Tunnel parts
Pressure nozzle tipsCW-4214Tunnel parts
3 more
On order3
High-pH presoakCW-4107Soaps and chemicals
Hot wax concentrateCW-4139Waxes and drying aids
Mitter curtain cloth stripsCW-4184Tunnel parts

Tables

Supplies

29 sample rows · 18 columns

Every chemical, part and sundry the wash runs on, how many are on the shelf, and when to reorder.

SupplySKUCategoryUnitKept inOn handReorder point
Air fresheners, vanillaCW-4232Vending and sundriesbox of 144Front office54
Anti-slip bay matsCW-4262Safety and cleanupeachTunnel entrance locker52
Bug and tar removerCW-4126Soaps and chemicals5 gal pailChemical room53
Ceramic sealantCW-4145Waxes and drying aids1 gal jugChemical room74
Conveyor roller bearingsCW-4195Tunnel partsbox of 10Parts cage42
Dryer blower beltsCW-4201Tunnel partseachParts cage32
Drying agentCW-4152Waxes and drying aids5 gal pailChemical room33
Foam brush replacement bundleCW-4189Tunnel partsset of 8Parts cage11
Hand soap refillsCW-4251Safety and cleanupcase of 6Tunnel entrance locker43
High-pH presoakCW-4107Soaps and chemicals55 gal drumChemical room11
Hot wax concentrateCW-4139Waxes and drying aids5 gal pailChemical room23
Low-pH presoakCW-4113Soaps and chemicals5 gal pailChemical room63

17 more rows

Vendors

8 sample rows · 7 columns

The companies the wash orders from, who to call and how many days a delivery takes.

VendorRepPhoneEmailLead time (days)Account numberSupplies
Bluestem Pump and NozzleIngeborg Wakefield(614) 555-0167ingeborg.wakefield@lakewoodcatalog.com6TCW-3359Pressure nozzle tips, Pump seal kit
Cascade Brightline ChemicalDesmond Ibarra(614) 555-0160desmond.ibarra@pikecrossingsupplyorders.net3TCW-3100Triple foam conditioner, High-pH presoak, Low-pH presoak, Wheel cleaner, acid-free, Bug and tar remover
Greenfield Janitorial WholesaleYoshi Ravenscroft(614) 555-0163yoshi.ravenscroft@pikecrossingsupplyorders.net2TCW-3211Shop towels, Hand soap refills
Harlan Tunnel PartsVerity Cardenas(614) 555-0162verity.cardenas@millstreetsales.org7TCW-3174Mitter curtain cloth strips, Foam brush replacement bundle, Conveyor roller bearings, Dryer blower belts, Photo-eye sensor
Millrace Safety and SignageLeontine Fontaine(614) 555-0164leontine.fontaine@lakewoodcatalog.com4TCW-3248Spill absorbent pads, Anti-slip bay mats, Wet floor signs, Traffic cones, reflective
Ohio Valley Wash SupplyYarden Lundqvist(614) 555-0161yarden.lundqvist@lakewoodcatalog.com5TCW-3137Spot-free rinse additive, Hot wax concentrate, Ceramic sealant, Drying agent, Tire shine, ready to use
Redwater Microfiber MillsOlwen Ingersoll(614) 555-0165olwen.ingersoll@millstreetsales.org9TCW-3285Microfiber drying towels, Wash mitts, chenille, Wheel brush heads
Tallgrass Paper and PackagingAldous Vasquez(614) 555-0166aldous.vasquez@pikecrossingsupplyorders.net3TCW-3322Vacuum bay tokens, Air fresheners, vanilla, Wash ticket paper rolls

Orders

21 sample rows · 8 columns

What has been ordered from each vendor, when it is due and when it arrived.

Order numberSupplyQuantityOrderedExpectedReceivedOrder status
PO-71215Mitter curtain cloth strips2Oct 3, 2026Oct 11, 2026—Placed
PO-71209Hot wax concentrate4Oct 1, 2026Oct 8, 2026—Placed
PO-71181Wheel cleaner, acid-free4Sep 30, 2026Oct 4, 2026Oct 4, 2026Received
PO-71204High-pH presoak1Sep 29, 2026Oct 7, 2026—Placed
PO-71172Pressure nozzle tips2Sep 28, 2026Oct 2, 2026Oct 2, 2026Received
PO-71158Air fresheners, vanilla5Sep 27, 2026Oct 1, 2026Oct 2, 2026Received
PO-71140Drying agent5Sep 25, 2026Sep 29, 2026Sep 29, 2026Received
PO-71123Shop towels3Sep 23, 2026Sep 27, 2026Sep 28, 2026Received
PO-71101Dryer blower belts3Sep 20, 2026Sep 26, 2026Sep 26, 2026Received
PO-71090Wheel brush heads5Sep 17, 2026Sep 22, 2026Sep 23, 2026Received
PO-71072Traffic cones, reflective2Sep 14, 2026Sep 20, 2026Sep 20, 2026Received
PO-71063Spill absorbent pads3Sep 11, 2026Sep 16, 2026Sep 17, 2026Received

9 more rows

Views

Count calendar

Supplies
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8Hot wax concentrateMitter curtain cloth strips+2
9
10Triple foam conditionerCeramic sealant+3
11
12
13High-pH presoakDrying agent+2
14
15
16Low-pH presoakTire shine, ready to use+2
17
18
19Wheel cleaner, acid-freeMicrofiber drying towels+2
20
21
22Bug and tar removerWash mitts, chenille+2
23
24
25Spot-free rinse additiveWheel brush heads+2
26
27
28
29
30
31

Forms and booking

Add a supply

Form
Add a supplyUsed whenever a new product is stocked, so it gets a minimum level from its first day.
What is the item called? *
What SKU does it carry? *CW- and four digits.
Which group does it belong to? *Soaps and chemicalsWaxes and drying aidsBrushes and clothVending and sundriesTunnel partsSafety and cleanup
How does it come packed?
How many are on the shelf now?
At what count should it be reordered?
How many should one order bring in?
What does one unit cost?
Add to the stock list

Dashboards

Stock health

Supplies
Supplies by stock status
  • In stock18
  • On order3
  • Reorder now8
Supplies by group
  • Soaps and chemicals5
  • Waxes and drying aids5
  • Brushes and cloth3
  • Tunnel parts7
  • Vending and sundries4
  • Safety and cleanup5
Counts due by week
  • Oct 4, 20269
  • Oct 11, 20268
  • Oct 18, 20268
  • Oct 25, 20264

Also included

  • Monday reorder listDigest
  • Count coming dueNotificationReminds the person counting a couple of days before a shelf count is due.

Related templates