P_00010 — Management questions require spreadsheet reconstruction outside the operating system

One testable operational mismatch: the transactions live in the operating system, while every management reporting modality is reconstructed after export in a spreadsheet.

Problem ID	Name	Solution IDs	Statement type	Status
P_00010	Management questions require spreadsheet reconstruction outside the operating system	S_00009	market_hypothesis	draft

kind: problem_catalog
schema_version: 1
problems:
  - id: P_00010
    solutionsIds:
      - S_00009
    priority: 50
    name: 'Management questions require spreadsheet reconstruction outside the operating system'
    status: approved
    statement_type: market_hypothesis
    applies_to_icp_ids: []
    situation: >-
      A company records sales, purchasing, inventory, manufacturing, or
      accounting transactions in an operating system and relies on those
      transactions for operational and management reporting.
    operational_mismatch: >-
      The transaction record exists in the operating system, but its reporting
      layer does not produce the views the company uses. Every reporting
      modality requires users to export the underlying records and reconstruct
      the answer in a spreadsheet.
    possible_consequences:
      - >-
        Each recurring report depends on repeating the export and spreadsheet
        reconstruction process.
      - >-
        The resulting analysis is maintained separately from the operating
        record rather than refreshing with it.
    observable_signals:
      - 'Users cannot produce a ranked list of top-selling products from the operating system.'
      - 'Vendor or purchasing analysis requires an export followed by spreadsheet work.'
      - 'The company states that every reporting modality depends on Excel.'
      - 'A requested management report is assembled outside the system that owns the transactions.'
    disconfirming_signals:
      - >-
        Users generate a representative set of the company's required reports
        directly from the operating system with the required filters, rankings,
        and calculations.
      - >-
        The generated reports refresh from current transactions and reconcile
        to the underlying records without spreadsheet reconstruction.
    confirmation_questions: []
    evidence_requirement: >-
      A representative sample across the company's reporting modalities, the
      source transactions for each sample, the exact export and spreadsheet
      steps currently performed, and a reconciliation of each result to the
      source records.
    evidence_ids: []
    prohibited_claims:
      - 'That a named ERP is generally incapable of reporting.'
      - 'That every company using a named ERP must export every report.'
      - 'Any quantified delay, labor cost, or error rate without account evidence.'
      - 'That a replacement system will eliminate all manual analysis.'