Solution Overview

Organization Profile
From a teeming Web site and a busy store in Ballard, Washington, Cookies sells more than 2,000 cookie-making ingredients, utensils, jars, tins, decorations, and bakeware.

Business Situation
Space is tight and items are seasonal, so daily trips to off-site storage mixed up stock levels. Web customers weren’t happy when they saw an item, but couldn’t get it, because buying hadn’t equaled demand.

Solution
Realizing she needed to computerize, the owner acquired a Microsoft Dynamics™ – Point of Sale system based on an IBM ThinkCentre PC. It came with touch screen, scanner, pole display, and receipt printer.

Benefits

-

Days end earlier because the system automatically tracks every item level

-

Staff know what’s in store and storage

-

Buying occurs by numbers, not memory

-

Any type of shrinkage will be visible

- Owner rests easily, knowing her knowledge is now in the computer


Hardware

-

IBM ThinkCentre PC

-

Elo touch screen

-

Epson TM-T88III receipt printer

-

Epson DM-D110 pole display

- Symbol LS-2208 scanner


Software and Services

-

Microsoft Dynamics POS

- Microsoft Office Accounting
- Microsoft Windows XP Professional


Vertical Industries

-

Retail Industry


Country/Region

-

United States

 


Cookie Paraphernalia Store Solves Inventory, Purchasing, and Transaction Problems

Keeping mental inventory of 2,000 small items and their rates of sale in the store and from the Web site was making Caryn Truitt, owner of Cookies, frazzled. Cookies is in Ballard, Washington, but storage is at home, so Truitt updated a large Microsoft® Excel® spreadsheet daily to track what was where. Days became long and errors crept in. Her electronic cash register didn’t track items so buying required too much guesswork, especially when a stock-out could alienate Web customers. She acquired Microsoft Dynamics™ – Point of Sale, which includes Microsoft Office Accounting 2007. Her specific system came with an IBM ThinkCentre PC and retail peripherals. It resolved a baker’s dozen problems because the software decreases its stock levels with each sale, and sends data to the accounting software. Truitt now buys more wisely, knows item levels, and is very glad for new peace of mind.

BUSINESS SITUATION

A charming shop aptly named Cookies sells nearly everything a home baker would need to make his or her cookies the envy of the party. Owner Caryn Truitt and an associate sell more than 2,000 SKUs (stock-keeping units) from a single register in the nearly 250-square-foot shop on Seattle’s (Washington) well-known Market Street. A very complete and well- organized Web site sells classes and nearly all items available in the store.
 

At first, I thought this system was more than I needed for my size store....Now I see that using all its features will help me grow our revenues to the size I want.
Caryn Truitt
Owner, Cookies

The store and its 120 square feet of offsite storage are filled with aprons, potholders, towels, bakeware, utensils, baking sets, kits, cookbooks, recipe cards, cookie cutters and stamps, cookie jars, plates, tins, ingredients, mixes, specialty sugars, sprinkles, and decorations. Cookies carries items for religious and other holidays, sports, and even regional themes. From season to season, one item may outsell another, but cutters and sprinkles consistently bring in the highest gross.

“My main problems were with inventory,” says Truitt. “Since my store is so small and storage is at my residence, I had to keep an Excel® spreadsheet to track what merchandise I had received and where it was. But when you’re busy or tired, jobs like this don’t always get done, so stock levels weren’t correct. Even when we did them, human error creeps in.”

Business was brisk, she says, but “An ECR [electronic cash register] gives you no way to track sales of each product to manage future ordering. When an item is hot, you want to restock it fast and sell more. I was trying to track 2,000 items, and their different rates of sale, in my head.”

Truitt buys all she can at two annual shows, then fills in with smaller purchases throughout the year. Shelf time varies greatly, partly because she carries Christmas cookie cutters all year long. “And,” she admits, “we had never done a true physical inventory because we have so many little items.”

“A previous business associate had just put items on the floor without price tags. At the register, she just tried to remember or would lowball the item. But that cost us sales because people are wary of asking about unpriced things. Maybe it’s not even for sale. If they ask and the price is too high, will they be embarrassed?”

Truitt considers hers a safe business, “But we had no idea what our shrinkage was, internal or external, and we never knew who was switching price tags on us before the register. With 2,000 items, it’s hard for an associate to memorize everything.”

SOLUTION

Truitt had never automated because she felt her store was too small to justify the cost. She thought she could manage well enough using paper and her electronic cash register (ECR). “I had been looking, but only for future use if I decide to franchise. I was looking into QuickBooks Point of Sale, but the business selling it couldn’t answer any questions about it. They promised to learn the system and call me, but never did. Where would I get support? Since easy daily use and technical support were important to my growth plans, I didn’t have the time to find someone who could demonstrate QuickBooks POS.

“I also considered a system of a small software company, and tried to talk to them at a gift show. Again, I couldn’t get help, so I couldn’t evaluate the product, so I left.

“I saw Microsoft Dynamics™ – Point of Sale at the same show. The company displaying it gave me a demonstration. It was easy to learn and it was very complete. And I knew I could get answers to questions when I needed them.”

In November 2005, one of retail’s busiest months, Cookies installed a Microsoft Dynamics – Point of Sale system combined with an IBM ThinkCentre PC and retail peripherals. Point of Sale comes with Microsoft® Office Accounting 2007 and automatically sends sales and other data to this powerful accounting solution.

The store was crowded with customers, new merchandise, and the system’s boxes. Truitt says she could have sped installation by opening and connecting one peripheral at a time, rather than opening all the boxes. “I was like a kid at Christmas,” she says.

Truitt’s initial impressions about technical support proved accurate. “The Microsoft staff have been very helpful and quite polite not to laugh at some of the questions coming from a computer illiterate, even when I call frantically because I forgot something we covered before.”

BENEFITS

“Microsoft Dynamics – Point of Sale has made me regret I put off automation,” she says. Easy and thorough inventory control resolved a multitude of problems well known to Truitt and other retailers. “It tracks what I receive and when we sold it. And I have reports to prove it,” she says.
 
Short, easy tasks get done sooner than tough ones. Now it’s fast to enter inventory when it comes in, so my stock levels are always current.
Caryn Truitt
Owner, Cookies

“Finally! I don’t have to keep up my Microsoft Excel spreadsheet every day when I receive merchandise or move it to or from storage,” says Truitt. “Getting rid of that chore gives me back so much time.

“Just knowing what I have in stock, or need on the shelves, will cut down my purchasing time and make sure I don’t over-order—or ignore something that’s been selling well. Reports show me what sold best during the last buying period, so I know in advance what to stock up on at my two buying shows.”

Truitt observes, “Short, easy tasks get done sooner than tough ones. Now it’s fast to enter inventory when it comes in, so stock levels are always current. The Management screen in Point of Sale saves me tremendous time entering new merchandise.”

SPEED AND CERTAINTY AT THE POINT OF SALE
The integrated barcoding in the IBM bundle with Point of Sale drives many benefits besides speeding up lines in the busy store. “If an item doesn’t come with a barcode, we barcode and label it with a price here. The software prints our own labels with the barcode, price, and my SKU.

“This has definitely saved me money in shrinkage because no one can get away with switching labels. Scanning an item displays its description on the screen and the pole display. That description better match the item in my hand! If a thirteen-dollar copper cookie cutter displays a description of plain metal two-dollar cutter, everyone knows it.

“This year, I’ll be able to do a complete inventory. That means I’ll be able to get a true feel of whether I’m having problems with theft, and in what lines and departments.”

 

Cookies carries more than 2,000 styles of cookie cutters


EASE OF LEARNING
“My new store associate was very diligent. She took careful notes while I was teaching her the software,” Truitt says. “By the end of the day, she was laughing at herself because the system was so easy. She didn’t need notes. Today, she might refer to them for an unusual transaction, but it only takes a minute to refresh and it all makes sense.”

In many systems, one of retail’s most difficult transactions is removing from the sale an item that a customer has decided against buying. But Truitt says the Remove feature in Point of Sale is an amazing time-saver. “When you have to remove an item, it’s such a relief to do it by just touching one button!”

Returns are equally painless. “I just scan the customer’s receipt and bring up their entire transaction. If they bought it on sale, they get back the sale price, not full price.”

Point of Sale even impresses clientele. “Without doubt, customers’ favorite feature is the pole display,” Truitt says. “It shows them everything I ring up, and the price they’re paying. Several people have commented how nice that is for them. And if we make an error, they’re more likely to catch it immediately, not after they got home.”

RETAIL REPORTING KNOWLEDGE IS POWER
“I definitely use those reports!” asserts Truitt. “I use the time-clock report every time I do payroll. When I think I am running low on some products, I tailor a report to print just out-of-stock items, so I know what to urgently buy. But just as important, I can temporarily pull them from my Web site, so online customers aren’t disappointed by ordering something we can’t deliver.

“I really love our new ability to store every receipt. I’ve only had one bad check since installing it. I felt much calmer just displaying and printing out the actual receipt. Seeing the items jogged my memory and I knew who wrote the bad check.

“I already use Microsoft Office Accounting for deposits, payroll, and credit card sales, because I know it will save me tons of time."

When the time comes,” says Truitt, “I will definitely be using Point of Sale in a second location. I’ll need another register there, and I’ll want one in my office to manage both stores, track sales, and price products. I’ll also use the customer list in Point of Sale for mailers, e-mailers, promotions, and a newsletter.”

TIME FOR ONESELF
“Now I can relax a little knowing that, if I can’t get into the store or take some sick time, all that information that was once only in my head is now in the computer. It gives me peace of mind. And I can eventually take some time off and know the store will be okay”

Truitt feels other retailers should automate early and, “Plan on some time to set up your system and enter your inventory. Once that’s done, the software takes such a burden off of you compared to an ECR you get from an office supply store.”

She warns against a misconception common among smaller retailers. “At first, I thought this system was more than I needed for my size store. I was only checking out systems ‘for the future.’ Now I see that using all its features will help me grow our revenues to the size I want. Now I can confidently think about a second location because this product will make managing the stores and their inventory a lot less daunting. I don’t think I’d attempt it without this software.”

 

HOME    PRODUCTS    Services    SUPPORT    SHOP NOW    Contact Us