INFORMATION TECHNOLOGY PART 4:
BACKING UP

How you back up your data and how often is as important, maybe more so, than anything I’ve written about so far about information technology in the bicycle business.

This article on backing up data does not mean your company won’t run the risk of losing data or having it compromised. However, taking these steps may well allow you to rebuild quickly or keep your business running should the unthinkable happen.

Keeping your systems and data secure is as important as making sure your inventory is secure and accurate. In some ways managing your inventory is easier. It has a physical presence. You can see it, touch it and count it. Your business data is a non-physical asset. Like your physical inventory, your data takes up space albeit in a much more compact form than a back room filled with bikes, parts and accessories. Knowing where specific parts of your data are stored and how often inventory is “counted” (updated) is just as important, and maybe more, than your physical inventory itself. Having an accurate and timely backup of your businesses data not only prepares you for a time when your systems go down, but can mitigate other data threats (which I’ll talk about in the next article).

How often should your business data be backed up? Let me expand on the comparison I’m making between your business data and your physical inventory. If you’re like most businesses, you have different categories or types of physical inventory based on value and/or usage. You also likely do inventory counts on a staggered basis. Some items may get counted on a weekly basis, some monthly, some quarterly, and some annually. You do this to insure your inventory is accurate, so that you can correctly calculate the cost of sales and profitability and prepare an accurate balance sheet.

Business data can be viewed the same way. You can, and should, determine what data needs to be backed up and how often.

Important data, (sales receipts, employee time/payroll, etc.) should be backed up every day. Employee records, inventory counts and values and other less critical data can be backed up less often, but probably not less than weekly. A general rule of thumb is to err on backing up more often rather than less often.

If you have software that helps manage your business data, it likely has an automatic backup facility that will perform at regular pre-determined intervals. If you aren’t using data management software, you can still do manual backups. Manual backups should also be done at regular predetermined intervals. Most always backups are done when systems are not in use, meaning after business hours, so having automatic backups scheduled means you don’t have to spend extra time at your place of business.

When you perform backups, the recommendation is the 3-2-1 rule: three copies of your data, two local (on different devices) and one off-site. For most businesses, this means the original data on your computer, a backup on an external hard drive, and another on a cloud backup service. A mix of internal and external/cloud location is critical to make sure your data is protected and can be quickly retrieved if necessary. 

While it is generally agreed that backups need to be done at regular intervals, the next question is what type of backup is appropriate. There are four basic types of backup: full, incremental, differential and synthetic full. Let’s look at each and define what they are.
 
Full Backup

A full backup is exactly what the name implies. It is a full copy of the entire data set of your business. Although a full backup usually provides the best protection, many businesses do not need to do them on a daily basis. The files that are to be copied during the full backup process are designated beforehand by a backup administrator or other data protection specialist.

If you haven’t been doing backups in your business, a full backup is the place to start. The first full backup becomes the baseline against which subsequent backups will be compared and applied.

Full backups consume the most tape or disc capacity and are time consuming, as they back up the most data. Full backups only need to be done once though you may decide that on occasion a new full backup should be done. But keep in mind the 3-2-1 rule. You shouldn’t be making just one copy, and each copy will require adequate storage. The second article in this series addressed finding out how much data you have, which was leading to this, so you would know how much storage, both internal and external (cloud), would be required. 

Incremental

Incremental backups are a way to increase backup speed and decrease storage space compared to doing a full backup. Incremental backups only back up data that have changed since the last backup.

As an example, suppose you created a full backup on Saturday evening, and used incremental backups for the rest of the week. The backup done Sunday evening would only capture the data that changed since Saturday. The backup done Monday evening would only capture data that changed since Sunday, and so on.

The primary disadvantage of using incremental backups is they can be time consuming when a restore is required. Using my previous example, suppose you wanted to restore the backup from Tuesday. To do so, you’d have to restore Saturday’s full backup. After that you’d have to restore Sunday’s backup and then Monday’s backup.
Additionally, if any of the backup is damaged or missing, you will have an incomplete data recovery.   

Differential

Differential and incremental backups are similar as both start with a full backup, and subsequent backups contain only data that have changed. The difference between differential and incremental backups is that an incremental backup only includes data that have changed since the previous backup, while a differential backup contains ALL of the data that have changed since the last full backup.

As an example of a differential backup, suppose you wanted to create a full backup on Sunday evening, and differential backups the rest of the week. Monday’s backup would capture all the data that have changed since Sunday. At that point it would then be identical to an incremental backup. However, on Tuesday the differential backup would back up any data that had changed since Sunday as well.

The advantage a differential backup has over an incremental backup is shorter restore times. Any scenario where downtime is critical, such as disaster recovery, rapid restore is important. Restoring a differential backup never requires more than two backup sets. Incremental backups could require numerous additional backup sets. The tradeoff is as time progresses, differential data can grow and contain much more data than incremental backups and require additional storage resources. 

Synthetic Full

A synthetic full backup is a variation of an incremental backup. The backup routine begins with taking a full backup followed by a series of incremental backups. Synthetic backups take it a step further.

What differentiates a synthetic backup from an incremental backup is the backup server actually produces a full backup. This is done by combining the existing full backup with data from the combined incremental backups. This creates a synthetic backup that is indistinguishable from a full backup created the traditional way.

The primary advantage of a synthetic full backup is it significantly reduces the time needed to do data restoration. Restoring a synthetic full backup does not require multiple tapes or disc sets like an incremental backup. 

What type of backup you choose depends on how often you want to do a backup, what your need is to possibly restore data, and how much capacity you have, internally and externally, to store the backups. This is a conversation you should have with your system administrator. It’s also important to periodically review your backup requirements and protocols as your business needs may change. 

You also should be doing backups on other devices used in our business. Your smart phones and tablets also need to be backed up to make sure all the data you depend on can be restored when needed.

Next time I’ll discuss the data threats to your business and devices.

Comments? Contact Steve Bina: steve@humanpoweredsolutions.com

IS INVENTORY EVIL? WILL WE SOON BE SWAMPED WITH TOO MUCH STUFF?

I have been asking around the bicycle business, and so far can’t find anyone who knows what the current bicycle inventory-to-sales-ratio (ITSR) is. Or, more specifically, what their ITSR is.

Here is a textbook definition of the ITSR Key Performance Indicator (KPI): the inventory to sales ratio measures the amount of inventory in your store compared to the number of sales you’re fulfilling. The KPI is a broad measure of your store’s inventory management and helps you adjust your stock to maintain high margins.

This is obviously a definition for retail, but it works equally well for businesses of all types and sizes. It uses a broad measure of your inventory management and helps you adjust your inventory to maintain margins, meaning margins of profit.

The National Bicycle Dealers Association (NBDA) is wrapping up the first Cost of Doing Business for Bicycle Retailers study since 2014, so we will have the “typical,” meaning the median, bike shop inventory productivity shortly.

The 2014-2015 NBDA Cost of Doing Business (CODB) study shows the inventory productivity for all reporting bike shops and for high-profit bike shops as follows:

            Inventory Productivity                                             All Reporting             High Profit
                        Gross Margin Percentage on
                                    Merchandise Sales                                     36.04                     37.14
                                    Inventory Turnover                                        1.8                          1.7

While not ITSR, the CODB study does provide an idea of overall inventory productivity for the “typical” American bike shop pre-pandemic. In my opinion, the gross margin percentage on merchandise sales wasn’t that good, and the inventory turnover frankly sucked, but this is just my opinion.

While not focusing on ITSR, the study does give an idea of overall inventory productivity for specialty bicycle retail, showing 1.8 inventory turnover and for the high-profit shops, which by the way represented the top 25 percent of all reporting bike shops, 1.7 inventory turns, and a 37.14 gross margin on merchandise sales.

This was achieved utilizing a supply chain system that had been in place and functioning efficiently for over 30 years, until the pandemic driven disruptions that started during the first quarter of 2020.

One of the most important aspects of the bicycle business changed profoundly by the pandemic has been the just-in-time (JIT) principle of inventory management that was introduced to the American brands and buyers by Shimano and the Taiwanese bicycle and component manufacturers over 30 years ago.

It was the Americans who introduced JIT to Japan during the reconstruction from the world war when manufacturing started with a blank slate. In broad strokes, Toyota taught Shimano, Shimano taught Giant Manufacturing Company, Giant taught the rest of the Taiwanese bicycle manufacturing establishment, and that in turn took JIT to mainland China with them.

The JIT methodology and system worked so well that for the better part of 30 years the American buyers provided their original equipment manufacturers in Asia with forecasts, followed by firm purchase orders and letters of credit. Shipping containers, loaded with bicycles, arrived at U.S. brand warehouses 40 to 45 days after a firm order was placed. There were disruptions from time to time, but they were infrequent, and the overall supply chain returned to normal in relatively short order.

This supply chain lead-time became not only the standard operating procedure, but an accepted rule until the pandemic, and the multiple supply chain disruptions that erupted by mid-2020 and have continued in full force and effect, with new variations through year-to-date 2022.

On and after mid-2020, the lead time for finished goods bicycles from Asia to the U.S. shot up from 100 to 120 days or more, depending on the component lead times, manufacturing plants being open, available containers, container ship sailings, and trucking throughout the supply chain. Transparency and visibility dropped, and it became difficult to track shipments and get reliable information on status and location along the supply chain.

JIT was pushed aside and replaced with Just-In-Case (JIC) inventory management throughout the supply chain that encouraged hoarding and overstocking to meet customer demand. This in turn has resulted in some bloated inventories and even longer lead times throughout the channels of trade that have been tolerated and accepted, as long as consumer demand stayed intense enough to drive all the supply chains.

What is often overlooked amongst the plethora of disruptions is the simple fact that in March 2020, when COVID-19 shut everything down and a pandemic was declared, consumers who were isolated switched from spending money on services, like eating out, going to movies and entertainment venues, to buying goods, merchandise, and other “stuff” in large quantities online.

Chart A shows this graphically, and the bicycle business got caught up in this increase in consumer demand, including for service and repair.

Sales and demand for bicycles shot through the roof, and the bicycle business got caught up in thinking we were in the midst of a second “Bike Boom” as every supply chain in the business struggled to provide product and service.

Dealers ordered more from brands and suppliers, suppliers ordered more from manufacturing plants in Asia, and manufacturing plants ordered more components and raw materials from their suppliers, who ordered more upstream.

Chart A


Enter the Bullwhip Effect. Here is what Robert Armstrong wrote in a Financial Times Opinion piece, Friday, May 27, 2022, titled: The bullwhip effect, redux.

“Inventories crack that whip. Way back in December I wrote about the bullwhip effect. It works like this: in response to a drop in supply or pop in demand, companies in a supply chain over-order or hoard inventory to protect themselves.

“The over-ordering amplifies as it moves up the chain from retailer to wholesaler to manufacturer to supplier. The whip cracks when suddenly demand weakens and there is too much inventory in the chain, leading to a glut. I wrote: The question is whether bullwhip effects might go into reverse next year (2022), leading to oversupply at just the same time as rabid end demand for goods is cooling anyway because (please, please) Covid is subsiding.”

Is the bullwhip effect in reverse? On May 28 Washington Post article titled Consumers are shifting their spending from goods to services, David J. Lynch wrote: “Now consumers are returning to their previous habits with the balance between goods and services spending back to where it stood in May 2020, according to data adjusted for inflation from Flexport, a freight forwarder. A separate metric cited by Goldman Sachs shows goods consumption about 5 percent higher from before the pandemic, down from a peak gap of 15 percent.”

“We are just in the early stages of seeing the rotation of consumer spending from goods to services. As time goes on, you are going to see more of that. Food services are quite strong. Travel is picking up, airfares and hotel occupancy,” said Kathy Bostjancic, chief U.S. economist at Oxford Economics. “The consumer is looking more to services spending, especially with spring and summer upon us.”

Walmart and Target, the number one and number two largest retailers of bicycles in the U.S., were both caught off guard in recent weeks as consumer preferences abruptly shifted, leaving both with what has been described in the media as a mountain of products like appliances and televisions that both have been forced to discount. Disclosure in both retailers’ quarterly investment calls led to their stock dropping to levels last seen in the 1980’s. Are bicycles part of either or both mass merchant’s inventory problem? I don’t know for sure, but they both clearly have ITSR issues.

When Bill Austin first came to the Schwinn Bicycle Company in the late 1970’s after the first (and only) Bicycle Boom, and was new to the bicycle business, he told those of us in sales and marketing that: “inventory is evil!”

He continued to advocate this throughout his career in the business. I know he believed in the JIT system of inventory management, and wonder how he would have adapted and adjusted to the shift in consumer demand in March 2020, and the resulting bicycle business migration from JIT to JIC inventory management.

Damned if you do and damned if you don’t! Consumers not only demanded more new and used bicycles, but service and repair for those they already owned. They also changed and shifted the way they shopped, purchased, interacted and communicated with retailers and brands.

Brands and retailers followed as best they could, including turning their backs on the JIT system out of what was broadly seen and accepted as a necessity to ensure there was enough product available to meet the demands of consumers.

Too much inventory, safety stock and actual hoarding were condoned and accepted up and down the bicycle supply chains as one of the costs of keeping up with consumer demand, the increase in riders and ridership, and the immediate gross revenue.

In saying this, I am not judging, but feel obliged to point out that the JIC logic and inventory system is only as good as consumer demand, and will become “evil” when consumers don’t want it or as much of it.

Unlike Robert Armstrong, the Financial Times Op Ed columnist, HPS and this writer have opined on the probability of consumer demand for bicycles ebbing in the current year, and warned about the potential of an inventory “problem” based on both past history, and the current consumer research conducted by Sports Marketing Surveys for the NBDA, before the Russian invasion of the Ukraine.  

This takes me back to my question. What is your Inventory-To-Sales-Ratio for bicycles, and what is your inventory, merchandising and sales plan for the rest of this year?

Please, contact me if you have questions or would like more information about anything in this article. jay@humanpoweredsolutions.com