ONLINE SPREADSHEET — (Note #5 on “Ingles Upgrades”)

This sample output from a Rouse Spreadsheet lists Bulk Products to be ordered.


Dear Ingles Markets,

It can be time-consuming and confusing to check inventory and order bulk products several times a week. There are 90 bulk products in 88 self-service dispensers, 79 display columns of cups, and 90 plus Back-Up Drawers.

I devised a web-based spreadsheet to manage these tasks efficiently. It works on smartphones, tablets, and portable computers. The spreadsheet’s labels coordinate with markings at each product location, making it easier to find products and assess needs quickly.

An order list is extracted from the spreadsheet and sent by text to the person ordering for the department.

Once implemented system-wide, there is a potential bonus. Valuable local information could be easily collected centrally, analyzed, and used to facilitate corporate planning and management of bulk products.

Come check it out.

G. Rouse, Jr.

Graham Rouse
Produce Associate
Ingles Markets #53
————————
Designer/Inventor (5 USA patents)
Rouse TECHnologies LLC
“Custom Solutions For Superior Results™”
GMR@RouseTECH.com (864) 654-4166

LINKS TO INGLES MARKETS UPGRADE NOTES

#01 — THANK YOU!
#02 — GRAHAM ROUSE?
#03 — BACK UP DRAWERS
#04 — FALSE BOTTOMS
#05 — ONLINE SPREADSHEET
#06 — MOBILE WORK STATION
#07 — AT A GLANCE (A) GRAVITY DISPENSER MARKINGS
#08 — AT A GLANCE (B) SCOOP DISPENSER MARKINGS
#09 — AT A GLANCE (C) TUB DISPENSER DIPSTICK & TAG
#10 — AT A GLANCE (D) TUB “BUD” INVENTORY COUNT
#11 — AT A GLANCE (E) BULK WALL “BUD” INVENTORY COUNT
#12 — QUICK LOAD (1) GRAVITY DISPENSER
#13 — QUICK LOAD (2) SCOOP DISPENSER
#14 — QUICK LOAD (3) TUBS
#16 — QUICK LOAD (4) “BUDs” (price, place, store)
#17 — NEAT MADE EASIER (shelf spa strip)
#18 — ACCESS MADE FASTER (door pull tabs)
#19 — DAILY ROUTINE (1st) fill in top shelf
#20 — DAILY ROUTINE (2nd) fill in lower shelf
#21 — DAILY ROUTINE (3rd) restock BUDs
#22 — DAILY ROUTINE (4th) restock dispensers

35

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.