Use the following information to create a Flex Budget Analysis using a computer spreadsheet. Actual Sales Revenue Direct Materials $640,000 Budget $700,000 260,000 280,000 Direct Labor Fixed Costs Production Volume 120,000 200,000 140,000 200,000 60,000 units 70,000 units Actual Flex Budget Static Budget (50,000 units) (50,000 units) (60,000 Units) Sales Revenue $640,000 $600,000 $700,000 Direct Materials 240,000 Direct Labor 140,000 Total Variable Costs 380,000 420,000 Contribution Margin 240,000 Fixed Costs 200,000 Operating Profit 60,000 40,000 Operating Profit Variances Flex Variance Volume Variance 20,000F Total Variance 20,000U