WeSteel
All Posts
AI & Technology

What Your Sales Reps Could Do If They Weren't Stuck in Spreadsheets

The average steel sales rep spends 40% of their time on admin. That is two full days per week not selling.

June 16, 20259 min read
What Your Sales Reps Could Do If They Weren't Stuck in Spreadsheets

The average steel sales rep spends roughly 40% of their time on administrative tasks: data entry, quote formatting, order tracking, inventory lookups, and chasing information from the warehouse. That is two full days per week not selling.

In an industry where good salespeople are increasingly hard to find and expensive to keep, productivity per rep is not a nice metric to track. It is a competitive advantage.

A Day in Two Sales Reps' Lives

Consider two sales reps at two different service centers. Both sell flat-rolled products. Both have 10 years of experience and strong customer relationships. The difference is the tools they use.

Rep A arrives at 7:00 AM. Before making a single call, she spends 45 minutes reviewing overnight emails, cross-referencing inventory in MetalTrax, checking customer credit status in QuickBooks, and updating her Excel tracking sheet. Her first quote request came in at 6:30 AM. She starts working on it at 7:50.

The quote requires checking availability for 16-gauge CRC in three widths across two warehouse locations. She opens MetalTrax, searches each width individually, notes the results on a sticky note, opens Excel, enters the line items, looks up the customer's last quoted price in her email history, calculates processing charges with a formula she built three years ago, estimates freight by calling the logistics coordinator, and formats the PDF. She emails the quote at 8:35 AM. Elapsed time: 45 minutes for one quote.

Rep B arrives at the same time. She opens her dashboard and sees the overnight email already parsed. The system identified the customer, pulled their profile, and pre-populated a draft quote with current inventory, the customer's negotiated pricing tier, and estimated freight. Rep B reviews the quote, adjusts one line item (she knows this customer prefers 48" width over 36" when the price difference is small), and sends it at 7:12 AM. Elapsed time: 12 minutes, including the judgment call on width.

By 8:35 AM, when Rep A sends her first quote, Rep B has sent four quotes and is on the phone with a customer discussing a potential blanket order for Q3.

The Capacity Gap Compounds

Rep A generates 6 to 8 quotes per day. Rep B generates 15 to 20. Over a month, that is the difference between 160 quotes and 400 quotes. Assuming similar close rates, Rep B's territory produces 2.5x the revenue with the same headcount.

But the gap is actually larger than the quote volume suggests. Rep B has time for the activities that build long-term revenue: customer visits, jobsite check-ins, prospecting calls, and follow-ups on open quotes. Rep A is so buried in administrative work that she only follows up on quotes when the customer calls her.

In steel sales, the follow-up is where deals close. A quote without a follow-up is a suggestion. The rep who calls two days later, asks if the customer has questions, and offers to adjust the quantities or delivery schedule wins the order more often than not.

Why Service Centers Tolerate This

Most service center owners know their sales teams spend too much time on admin. They have known for years. So why does it persist?

Three reasons. First, the pain is distributed. No single task takes long enough to feel urgent. Five minutes here, ten minutes there. It adds up to two hours per day, but it never appears as one line item on the calendar.

Second, the workarounds are entrenched. Rep A built her Excel quoting template over three years. She has macros for processing charge calculations, conditional formatting for margin targets, and a sheet that links to her email archive for pricing history. Switching to something new means abandoning a system she personally constructed. That is hard to give up, even when the replacement is better.

Third, the cost is invisible. Nobody tracks "revenue lost because a rep was formatting a PDF instead of calling a prospect." But it is real. Every quote that goes out an hour late is a chance for the competitor to get there first. Every follow-up that does not happen is a deal that someone else closes.

What Productivity Per Rep Actually Means

For a 25-person service center with four outside reps and two inside reps, the productivity gap between modern tools and legacy systems translates to roughly $1.5 million to $3 million in annual revenue. That is not a software benefit calculation from a vendor pitch deck. It is the difference between 6 quotes per day and 15 quotes per day, multiplied by average order value and close rate, over 250 selling days.

It also affects retention. The best sales reps, the ones who could work anywhere, do not want to spend their days doing data entry. They want to sell. When a competitor offers a rep the same territory with better tools, the tools tip the decision. Losing one experienced rep costs $200,000 to $500,000 in recruiting, training, and lost customer relationships during the transition.

The spreadsheet is not free. It is the most expensive tool in the sales department.

sales productivitysteel salesspreadsheetsCRMquoting
Steel Sales Reps: Life Beyond Spreadsheets | WeSteel AI