The Herald Bulletin

Morning Update

Local Business

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
Local Business
  • Senior housing project advances If all the pieces fall into place within the next two weeks, construction on a new senior housing development could begin this fall.

    July 30, 2014

  • Roundabout bids higher than expected Bids for a planned facelift of the gateway into Anderson from Interstate 69 at Scatterfield Road came in considerably higher than the engineer’s estimate for the project.

    July 29, 2014

  • FEA - HB0729 - Senior Falls Aging safely in the comfort of her home Marilyn Moneyhun said being totally reliant on others is difficult. "Losing your independence is a shock to your system," Moneyhun, 84, said. "You are not in control anymore."

    July 29, 2014 1 Photo

  • NWS - HB0728 - business expansion CB Fabricating makes $2 million investment

    A local business founded in 2006 has invested $2 million in new equipment and a building expansion.

    July 29, 2014 1 Photo

  • Charo Boyd: 'My Social Security' simplifies your life So many people buzz through extremely busy and complicated schedules these days. A smartphone in one hand, a computer in front of you, and a digital task list that never seems to end. In addition, to complicate things just a little more, there’s another event you need to add to your list — National Simplify Your Life week.

    July 28, 2014

  • nws - hb0725 - colts - jc - 4.jpg Colts camp's impact: pricey or priceless?

    Football fever is here and the city is flooded with fans eager to catch a glimpse of a favorite player. But officials say they are unclear what kind of economic impact the Indianapolis Colts training camp has on the area.

    July 26, 2014 1 Photo

  • BIZ - HB0727 - Skill gap 2 Seeking a solution today, not tomorrow Tina Warner-Morton says she wants to open her own healthcare business because it is too difficult to work for an employer with unclear employee expectations.

    July 26, 2014 1 Photo

  • BIZ - HB0727 - Cathy Cupboard Biz Profile Business Profile: Cathy's Cupboard focuses on customer satisfaction Cathy McPhearson opened her first storefront in June, but this is not her first venture into business. “I have always wanted to have my own business,” she said. “The problem was finding what people like, but everyone seems to like candles.”

    July 26, 2014 1 Photo

  • IU Health Ball Memorial Hospital named Level III trauma center The Trauma Center at Indiana University Health Ball Memorial Hospital has been verified as a Level III Trauma Center by an ad hoc committee of the Committee on Trauma (COT) of the American College of Surgeons.

    July 26, 2014

  • Clark, Big Joe mug 'Big Joe' Clark: Beat the market or meet your goals? True or not, my experience tells me that goals – especially when written down – undoubtedly serve as catalysts for success. However, danger arises when a goal does not properly focus on the long term result you expect.

    July 25, 2014 1 Photo

Stocks
Hyperlocal Search
Premier Guide
Find a business

Walking Fingers
Maps, Menus, Store hours, Coupons, and more...
Premier Guide