The Herald Bulletin

Afternoon Update

Columns

September 9, 2013

Emmett Dulaney: Databases that automate the errors

I recently conducted a bit of an experiment to determine the accuracy of databases we interact with every day. Before discussing it in more detail, however, it is important to explain the logic behind it.

Today, every packaged product sold in a store has a bar code and the cashier is really just a cog in the conveyor belt making sure each item goes across the scanner the right way before bagging. The database does all the work – identifying the product, the category, whether it is taxable or not, and so on – and this is a great thing on many levels. It helps with inventory control, it helps with pricing, and it is especially helpful with navigating through the convoluted sales tax status of items. I haven’t heard anyone complain about sales tax being incorrectly calculated for quite a while even though the laws regarding it are so complex.

For example, the Indiana Department of Revenue published Information Bulletin #29 and made it effective Feb. 1, 2012. This document specifically spells out what is taxable and nontaxable as it relates to food and even goes so far as to name a number of individual products in one category or another. The category “Candy and confections,” for example, are listed as taxable items but “Nestle Crunch bars” are explicitly listed as “Non-taxable Food Items” (I guess that they can pass for a tasty breakfast just like mother would make). By having a database for a point-of-sale (POS) register, the merchant need only have identified Crunch bars as non-taxable within the last 18 months, but left Hershey bars and Bit-O-Honeys as taxable, and let the cashiers take the money identified as the total at the end of the transaction without question.

From the standpoint of a consumer, an awful lot of blind faith is put in those databases and this brings me to my experiment. Over a seven-day period, I bought a fair number of Nestle Crunch bars and checked to see if I was charged sales tax. The result is that I was not charged sales tax at four Anderson stores. I was, however, incorrectly charged sales tax at three others. An accuracy rate below 60 percent certainly delivered a blow to my trust in the system.

Text Only
Columns
Featured Ads
More Resources from The Herald Bulletin
AP Video
Raw: Grief After Deadly Airstrikes in Gaza Officer Who Pointed Gun at Protesters Suspended Kathy Griffin Challenges Minaj to 'a Booty Off' Johnson: Six Arrests, No Tear Gas in Ferguson Raw: Rescue, Relief Efforts at Japan Landslide Cadavers, a Teen, and a Medical School Dream Raw: Woman Escorted From Ferguson Protests California Drought Stings Honeybees, Beekeepers Officer Who Pointed Gun at Protesters Suspended Holder Hopes to Bring Calm to Ferguson US Mission to Rescue Hostages in Syria Failed Manfred, Torre and MLB Take Ice Bucket Challenge Bank of America Reaches Record $17B Settlement Holder Reassures Ferguson Community With Visit GlobalPost CEO Remembers Foley As a Brave Man
Parade
Magazine

Click HERE to read all your Parade favorites including Hollywood Wire, Celebrity interviews and photo galleries, Food recipes and cooking tips, Games and lots more.
Hyperlocal Search
Premier Guide
Find a business

Walking Fingers
Maps, Menus, Store hours, Coupons, and more...
Premier Guide
Helium debate
Helium
Front page
Poll

Have you been to Mounds Mall to see the “Imagine Mounds Lake” display?

Yes, and it solidified my support
Yes, but I'm still opposed
No
     View Results