Quick Scheduling Replaces Complex Custom Excel Program

Every manufacturer who has built a complex Excel-based scheduling system knows the fear: what happens when that spreadsheet breaks, or the one person who understands it leaves?

Kyocera Industrial Ceramics lived that reality across two facilities — a ceramics production plant in North Carolina and a fiber optic jumper assembly operation in Tijuana, Mexico. Their custom employee-written Excel scheduling program was "becoming very time consuming and difficult to maintain." Three departments scheduled independently with no commonality between them.

They replaced it all with Resource Manager from User Solutions — using their existing Excel data, which "made implementation a snap."

Read the full Kyocera success story.

---

The Challenge: Three Departments, Zero Coordination

Brian Kendall, Industrial Engineer for Kyocera Industrial Ceramics, described the core problem: "We were looking for a way to schedule three in-line departments and various machines. Scheduling was being completed by the respective department supervisors with no commonality between them."

The Custom Excel Trap

In the Tijuana fiber optic operation, the team had built a custom Excel program to track raw material usage and final product output. This is a common path for manufacturers — start with a simple spreadsheet, add complexity over time, and eventually end up with a fragile, person-dependent system that no one else can maintain.

The custom Excel program had become:

• Time-consuming to update and operate
• Difficult to maintain as complexity grew
• Person-dependent — only its creator fully understood it
• Limited — no finite capacity scheduling or alternate routing support

The Alternate Routing Need

Kendall's major concern was the ability to preprogram alternate routes for certain part numbers to achieve maximum flexibility across all departments. Traditional scheduling approaches lock jobs into fixed routings. Real manufacturing needs the flexibility to shift work between alternative machines and workcenters based on current capacity and availability.

---

The Solution: One Schedule, All Departments

With guidance from User Solutions, Kyocera implemented Resource Manager and solved multiple problems simultaneously.

Unified scheduling — One common computerized production schedule that could be understood by all departments involved. No more separate schedules with no commonality.

Alternate routing flexibility — Pre-programmed alternate routes for part numbers enabled maximum flexibility across departments, ensuring work could flow to wherever capacity was available.

Excel data import — Implementation used data already in Excel format, making the transition seamless. Kyocera also imported previously entered data from an Access database to bring the system online quickly.

Immediate improvement — Brian Kendall reported: "We found immediate improvement in both predicting output and tracking raw material usage in process."

---

Why Excel Replacement Is the Highest-ROI Scheduling Investment

The Kyocera case illustrates why replacing Excel with scheduling software delivers the highest ROI of any scheduling investment.

The Excel Ceiling Is Real

Excel is powerful for simple scheduling tasks. But it hits a ceiling when you need finite capacity constraints, multi-department coordination, alternate routings, or what-if analysis. Every manufacturer who has pushed Excel past its scheduling limits knows the feeling of the system becoming more burden than benefit.

Existing Data Is the Bridge

The biggest fear in switching from Excel to scheduling software is losing the data and logic built up over years. Resource Manager eliminates this fear by accepting Excel-format data directly. Your investment in organizing production data is preserved — you are adding scheduling intelligence on top of it, not starting over.

Multi-Department Visibility Is Transformative

When each department schedules independently, the result is always the same: conflicting priorities, invisible bottlenecks, and missed delivery dates. A unified scheduling view across all departments — which is what Kyocera achieved — eliminates these coordination failures.

---

Lessons for Manufacturers Using Excel for Scheduling

If your Excel scheduling system is understood by only one person, you have a business continuity risk. That person's departure would create immediate scheduling chaos.

If your Excel files are getting slower or breaking more often, you have hit the Excel ceiling. The solution is not a more powerful spreadsheet — it is dedicated scheduling software.

If departments schedule independently, you are losing capacity to coordination failures. A unified scheduling system reveals capacity that was previously invisible.

Your existing Excel data is an asset, not a liability. Resource Manager imports Excel data directly, making the transition fast and preserving your data investment.

---

Frequently Asked Questions

Why did Kyocera replace their custom Excel scheduling program?

Kyocera's custom employee-written Excel program was becoming very time-consuming and difficult to maintain. It could not handle multi-department scheduling or alternate routing flexibility. Resource Manager replaced it using existing Excel-format data, making implementation fast.

How did Kyocera unify scheduling across three departments?

Before Resource Manager, each of Kyocera's three departments had different supervisors scheduling independently with no commonality. Resource Manager created one common computerized production schedule understood by all departments, with pre-programmed alternate routes for maximum flexibility.

Can scheduling software import data from existing Excel files?

Yes. Kyocera implemented Resource Manager using data already in Excel format, which made implementation very fast. Resource Manager is designed to work with existing data formats, eliminating the need for extensive data migration or reformatting.

---

Replace Your Excel Scheduling Today

If your custom Excel scheduling program is becoming a burden instead of an asset, the Kyocera experience shows the path forward. Resource Manager DB and Spreadsheet Scheduler accept your existing Excel data and add the scheduling intelligence your spreadsheets lack.

Ready to upgrade from Excel? Request a free demo and we will show you the transition using your own data.

Read the full Kyocera success story and explore all scheduling success stories.