Use the following information to create a Flex Budget Analysis using a computer spreadsheet.

	Actual	Budget
Sales Revenue	$400,000	$550,000
Direct Materials	100,000	132,000
Direct Labor	40,000	77,000
Fixed Costs	180,000	180,000
Production Volume	200,000 units	220,000 units

	Actual	Flex Budget (200,000 units)	Static Budget (220,000 Units)
Sales Revenue	400,000	$500,000	550,000
Direct Materials		120,000
Direct Labor			77,000
Total Variable Costs	140,000		209,000
Contribution Margin		310,000
Fixed Costs			180,000
Operating Profit	80,000	130,000
Operating Profit Variances	Flex		Volume
	50,000U	Total Variance
		81,000U