Contains Sample Data. Insert Rows As Required

VARIANCE ANALYSIS
Category
Contains sample data. Insert rows as required.
Jan / Actual Jan / Plan
Jan / Var.
Feb / Actual Feb / Plan
Feb / Var.
Mar / Actual Mar / Plan
Mar / Var.
Q1 / Actual
Q1 / Plan
Q1 / Var.
Apr / Actual Apr / Plan
Apr / Var.
May/ Actual May / Plan
May / Var.
Jun / Actual Jun / Plan
Jun / Var.
Q2 / Actual
Q2 / Plan
Q2 / Var.
Jul / Actual
Jul / Plan
Jul / Var.
Aug / Actual Aug / Plan
Aug / Var.
Sep / Actual Sep / Plan
Sep / Var.
Q3 / Actual
Q3 / Plan
Q3 / Var.
Oct / Actual Oct / Plan
Oct / Var.
Nov / Actual Nov / Plan
Nov / Var.
Dec / Actual Dec / Plan
Dec / Var.
Q4 / Actual Q4 / Plan
Q4 / Var.
Year Actual
Year Plan
Year Var.
Revenue 1
Revenue 1
200
300
250
300
-50
0
200
200
200
200
0
0
200
150
200
200
0
-50
600
650
650
700
-50
-50
200
200
200
200
0
0
200
200
200
200
0
0
200
200
200
200
0
0
600
600
600
600
0
0
200
200
200
200
0
0
200
200
200
200
0
0
200
200
200
200
0
0
600
600
600
600
0
0
200
200
200
200
0
0
200
200
200
200
0
0
200
200
200
200
0
0
600
600
600
600
0
0
2400
2450
2450
2500
-50
-50
Total Revenue
500
550
-50
400
400
350
400
-50
1250
1350
-100
400
400
400
400
400
400
1200
1200
400
400
400
400
400
400
1200
1200
400
400
400
400
400
400
1200
1200
4850
4950
-100
Cost of Goods 1
Cost of Goods 2
100
100
150
100
-50
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
350
300
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
1200
1200
1250
1200
-50
0
200
300
0.60
250
300
0.55
-50
0
200
200
0.50
200
200
0.50
0
0
200
150
0.43
200
200
0.50
0
-50
600
650
1.53
650
700
1.55
-50
0
0
-50
-50
100
100
Total COG
Gross Profit
Gross Margin
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
600
600
1.5
600
600
1.5
0
0
0
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
600
600
1.5
600
600
1.5
0
0
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
200
200
0.50
200
200
0.50
0
0
600
600
1.5
600
600
1.5
0
0
2400
2450
6.029
2450
2500
6.05
-50
-50
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
100
100
100
100
0
0
100
100
100
100
0
0
100
100
100
100
0
0
300
300
300
300
0
0
1200
1200
1200
1200
0
0
200
100
200
100
0
0
200
0
200
0
0
0
200
-50
200
0
0
-50
600
50
600
100
0
-50
200
0
200
0
0
0
200
0
200
0
0
0
200
0
200
0
0
0
600
0
600
0
0
0
200
0
200
0
0
0
200
0
200
0
0
0
200
0
200
0
0
0
600
0
600
0
0
0
200
0
200
0
0
0
200
0
200
0
0
0
200
0
200
0
0
0
600
0
600
0
0
0
2400
50
2400
100
0
-50
Operating Costs
Advertising
Travel
Add categories
Total Operating
Net Profit

Contains Sample Data. Insert Rows As Required

Uploaded by

Copyright:

Available Formats

Contains Sample Data. Insert Rows As Required

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Contains Sample Data. Insert Rows As Required

Uploaded by

Copyright:

Available Formats

VARIANCE ANALYSIS

Contains sample data. Insert rows as required.

Jan / Actual Jan / Plan

Feb / Actual Feb / Plan

Mar / Actual Mar / Plan

Apr / Actual Apr / Plan

May/ Actual May / Plan

Jun / Actual Jun / Plan

Aug / Actual Aug / Plan

Sep / Actual Sep / Plan

Oct / Actual Oct / Plan

Nov / Actual Nov / Plan

Dec / Actual Dec / Plan

You might also like