April 10, 2025

AOP Hell? Escape the Spreadsheet Trap!

SPM Mythbusters Series

3 min read

Key Takeaways

Discover why the annual operating plan (AOP) continues to be a manual, spreadsheet-driven process.
Consolidate the AOP into a single system, enabling better coordination and adjustments.
Employ workforce planning, which is key to understanding how the AOP should change to meet future resource needs.

The annual operating plan (AOP). Just the words can evoke feelings of dread, exhaustion, and spreadsheet-induced eye strain. For many organizations, the AOP process is a laborious, manual exercise involving hundreds of spreadsheets, countless iterations, and a whole lot of frustration.

The spreadsheet struggle

Each department or business unit creates its own staffing plan, estimates its expenses, and then engages in a back-and-forth with finance to reconcile everything. By the time the final plan is approved, it's often based on outdated assumptions and may not accurately reflect the organization's current priorities.

The myth of inevitability

The biggest misconception is that this is just how AOP has to be. That it's an inherently painful process with no easy solutions. But there's a better way.

Consolidation and coordination

The key is to consolidate the AOP process into a single, integrated system. Here are the keys to making this happen:

Centralized data: Bring all your staffing data, expense budgets, and strategic goals into one place.
Real-time visibility: Gain a clear view of your organization's overall resource allocation and financial plans.
Streamlined collaboration: Facilitate communication and collaboration between departments and finance.

From data to insights

This centralized system should also leverage your existing data to provide these actionable insights:

Demand forecasting: Analyze historical demand data to predict future resource needs.
Skills gap analysis: Identify areas where you lack the skills to support your strategic goals.
Resource optimization: Optimize resource allocation to maximize productivity and efficiency.

The value that these systems offer is insights, which give management teams a fighting chance at being successful.

Stop running your business like separate franchises

Is your organization truly aligned, or is it operating like a collection of independent franchises? Would senior management even move people between business units if they wanted to? An integrated AOP process can help you break down silos and ensure that everyone is working towards the same goals.

Taking control of your AOP

Here are some keys to optimizing your AOP:

Invest in the right tools: Implement an SPM solution that supports integrated AOP and workforce planning.
Embrace data-driven decision-making: Use data to inform your staffing and budget decisions.
Foster collaboration: Break down silos and encourage communication between departments.

The AOP doesn't have to be a painful process. By consolidating your planning, leveraging data-driven insights, and fostering collaboration, you can transform your AOP from a burden into a strategic advantage.

Tag(s): ValueOps , Clarity , Strategic Portfolio Management , SPM , Annual Operating Plan , AOP

Jason Kotlinski

Jason Kotlinski serves as Product Manager for Clarity with clients all across the globe. He is responsible for customer-facing aspects of product management, leading development of key marketable features, and assisting senior management with backlog prioritization and new feature definition.

Other resources you might be interested in

Blog December 22, 2025

Top 3 Trends Defining Network Observability in 2026

Discover the three specific trends that will define network observability in 2026. See how unified observability and predictive AI will shape the landscape.

Read Blog

Office Hours December 18, 2025

Rally Office Hours: December 18, 2025

Rally Office Hours features an AI-driven artifact breakdown tool that creates child items from features/stories. The Q&A covers capacity planning, forecasting and burnup charts.

View Recording

Blog December 17, 2025

Why 2025 Shattered the Old Rules of Network Management

This post reveals the five key lessons network operations leaders learned in 2025—and how they need to respond to be successful in 2026.

Read Blog

Blog December 17, 2025

The 2026 VMUG Report: Why Network Observability is the Heart of the New VCF Era

Get the top takeaways from the VMUG Cloud Operations and VCF User Experience Report 2026. See why network observability is key to successful VCF 9 migrations.

Read Blog

Video December 12, 2025

Automic Automation Cloud Integration: SAP S/4 HANA Application Jobs Integration

Simplify your SAP S/4HANA job management. Integrate with Automic Automation for central configuration, monitoring, and orchestration of all your enterprise jobs.

View Video

Video December 12, 2025

Automic Automation Cloud Integration: OpenSSH Integration

Master Open SSH automation. Use Automic Automation for centralized control, secure file transfer, command execution, and full job monitoring.

View Video

Office Hours December 11, 2025

Rally Office Hours: December 11, 2025

Discover Rally's new Ancestors field, static query box deprecation, non-conflicting saves, plus a dashboard demo and query writing tips.

View Recording

Blog December 10, 2025

3 Questions I Expect You to Ask Me

Ask these questions to gain a deeper understanding of a vendor. Find a partner who can solve today’s challenges and prepare you for what’s next.

Read Blog

Solution and Capabilities Briefs December 5, 2025

Carrier-Grade Network Observability: A Technology Brief for Telco Network Operations

Network Observability by Broadcom unifies data to provide contextual, AI-enabled insights for superior service availability, accelerated MTTR and improved MTTI, reduced operational costs, and the...

Read Technology Brief