Refer to the data in Exercise 16-22. Prepare a sales activity variance analysis for Data-2-Go like the one in Exhibit16.4.

Transcribed Image Text:

Flexible Budget Sales Activity Master Budget (based on planned (based on Variance actual activity based on of 80,000 variance in activity of units) 80,000 20,000 sales volume100,000 units) 100,000 Sales units Sales revenue Lass Variable costs 800,000 200,000 U 1,000,000 304,000 | 72,000 76,000 | E| 18,000 F Variable manufacturing costs 380,000 90,000 $ 376,000 S 94000 470,000 S424,000 106,000 U 530,000 I .91 Variable selling and administrative Total variable costs Contribution margin Fixed costs Fixed manufacturing overhead Fixed selling and administrative costs140,000 200,000 200,000 140,000 340,000 190,000 Total fixed costs Profit S 84,000 106,000 U