fill out the excel

Variance Analysis

Analyst:
Company:	Andrews
Product:	Able
Segment:	Traditional
		Round 1	Round 2			Round 2		Variance to
	Measure	Actual	Forecast	Forecast Explanation		Actual		Forecast	Variance Explanation		Actions
Market Share
Inventory (units)
Contribution Margin (%)
Customer Survey Score
Other 1
Other 2

Describe the reasons for the difference between the Round 1 Actual value and what you are forecasting for Round 2.

Adjust variance formula so + is good - is bad

Describe the reasons for the difference between the Round 2 Forecasted value and your actual results for Round 2.

Describe actions to be taken in response to a negative variance.

Sheet2

Sheet3