Refer to the data in Exercise 16-16. Prepare a sales activity variance analysis like the one in Exhibit16.4.

Flexible Budget Sales Activity (based orn actual activity of 80,000 units) Variance (based on variance in sales volume) Master Budget (based orn planned activity of Sales units 80,000 20,000 100,000 $800,000 200,000 U 1,000,000 Sales revenue Less Variable costs Variable manufacturing costs Variable selling and administrative Total variable costs Contribution margin Fixed costs Fixed manufacturing overhead Fixed selling and administrative costs Total fixed costs Profit 76,000 F 18,000 F $376,000 94,000F 424,000 106,000 U 304,000 380,000 90,000 470,000 530,000 72,000 200,000 140,000 340,000 $ 84,000 200,000 140,000 $ 340,000 190,000 106,000 U