Case Study 02

Boosting Operational Efficiency & Strategic Growth at Mid State Welding

Mid State Welding is a custom metal fabrication company serving commercial and residential clients across the Black Hills region. Known for its tailored solutions from handrails and aluminum repair to structural welding and mobile services the company thrives on craftsmanship, local connections, and responsive service during high-demand seasons like Rally Week.

The Challenge

AtSign needed a partner who could:

The company faced rapid job flow and frequent walk-ins from both local contractors and out-of-town clients.

Leadership struggled with tracking costs, scheduling projects, and improving client communications.

Administrative operations became difficult to keep lean, organized, and proactive.

At the same time, they needed support identifying new revenue opportunities while managing real-time shop operations.

Executive Assistant Impact

(Daniel Herrera)

Project Tracking & Team Communication

Maintained real-time Google Sheets for project progress updates
Compiled daily and weekly recap reports for team and leadership visibility
Monitored job completion timelines and coordinated schedule gaps

Strategic Support & Reporting

Compiled Rally walk-in revenue logs for trend analysis
Created job log templates to improve workflow tracking
Supported leadership with film crew coordination, client follow-ups, and prep for case studies and public-facing materials

‍

Estimate Creation & Cost Tracking

Built QuickBooks estimates based on labor, materials, and subcontractor rates
Logged detailed cost breakdowns per project to align with weekly revenue goals
Supported development of internal job costing models for decision-making

Lead Generation & Contractor Outreach

Researched and compiled targeted contractor and vendor lists
Initiated outreach campaigns to partner with GCs and secure larger jobs
Built a growing local database of potential collaborators and material vendors

Calendar & Operations Organization

Centralized all ongoing and upcoming jobs into a shared project calendar
Coordinated walk-in tracking, mobile jobs, and recurring client follow-ups

Results

Daniel's support allowed leadership to stay focused on field work and client engagement while increasing back-office clarity. The consistent tracking of project costs vs. revenue targets provided actionable insights, and new lead pipelines positioned the company for higher-margin collaborations.

Looking Ahead

With these systems in place, Mid State Welding is better prepared to scale its operations, win more strategic partnerships, and continue delivering top-tier custom fabrication with tighter project oversight.