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 16, 2026Oct 24, 2026—Placed
PO-71209Hot wax concentrate4Oct 14, 2026Oct 21, 2026—Placed
PO-71181Wheel cleaner, acid-free4Oct 13, 2026Oct 17, 2026Oct 17, 2026Received
PO-71204High-pH presoak1Oct 12, 2026Oct 20, 2026—Placed
PO-71172Pressure nozzle tips2Oct 11, 2026Oct 15, 2026Oct 15, 2026Received
PO-71158Air fresheners, vanilla5Oct 10, 2026Oct 14, 2026Oct 15, 2026Received
PO-71140Drying agent5Oct 8, 2026Oct 12, 2026Oct 12, 2026Received
PO-71123Shop towels3Oct 6, 2026Oct 10, 2026Oct 11, 2026Received
PO-71101Dryer blower belts3Oct 3, 2026Oct 9, 2026Oct 9, 2026Received
PO-71090Wheel brush heads5Sep 30, 2026Oct 5, 2026Oct 6, 2026Received
PO-71072Traffic cones, reflective2Sep 27, 2026Oct 3, 2026Oct 3, 2026Received
PO-71063Spill absorbent pads3Sep 24, 2026Sep 29, 2026Sep 30, 2026Received

9 more rows

Also included

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

Related templates