VERN-Variance Analysis
Copyright 2013 ACBA - All Rights Reserved
BusinessAllstars.com

XL   Name Date     
ACTUAL BUDGET Revenue
Units   
Quantity per unit   
Rate per quantity   




Direct Materials
Direct Labor
Variable Overhead
Fixed Overhead




Actual
(AU x AQ) x AR
Standard
(AU x AQ) x BR
Flexed
(AU x BQ) x BR
Budget
(BU x BQ) x BR





Enter Data below only for Revenue Calculations
Current Yr Revenue $ Prior Yr Revenue $
Current Yr COGS $ Prior Yr COGS $
Inflation Rate year over year %