Course Outline

  • COA DIMENSIONS & HIERARCHY

    Steps: Dimensions & Hierarchy Definition Procedures Model: P&L Dimensions & Hierarchy Analysis

  • OPEX VARIANCE ANALYSIS

    Steps:Operating Expense checking procedures Model: Cross-line Variance checking Model

  • VOLUME & RATE VARIANCE

    Steps:One Product Line & Mixed Line analysing Model: Variance Substitution Method

  • DYNAMIC CONTROL & FOMATTING

    Steps: Dynamic Elements Editing Methods Model: How to highlight the variance automatically

  • SALES VARIANCE ANALYSIS

    Steps:By Product , customer and product mix analysing Model: Multi-dimension Analysing Method

  • TIME VARIANCE ANALYSIS

    Steps: Recognize timing in variance analysis Model: MTD & YTD variance Analysis

  • STANDARD COSTING ANALYSIS

    Steps:Core business Processing analysing Model: R2R Variance Analysing Method

  • S&W ADJUSTMENT JOURNAL

    Steps: Recognize incentives & termination Model: S&W variance Analysis method

  • CATEGORY VARIANCE ANALYSIS

    Steps:Actual Wrong or Buget Wrong Model: Vertical & horizontal Analysing Method

Course curriculum

  • 1

    FA_P&L Variance Analysis

    • File Download

    • File Download 2

    • Actual vs Budget Variance Analysis Intro

    • P&L Variance Type and methods

    • Volume and Rate Variance

    • Standard Costing

    • S&W Variance Analysis

    • Time Variance Analysis