Refer to the data in Exercise in 17-24. Prepare a profit variance analysis for Lowe & Rent like the one in Exhibit 16.5 of the previouschapter.

Flexible Budget (based on actual activity of Master Budget (based orn Actual (based on actual activity of Manufacturing Sales Price Variance activity of 100,000 units) 80,000 units Variances Variances 80,000 units) Variance Sales revenue $ 840,000 S40,000 F $ 800,000 S200,000 U S1,000,000 Variable costs Variable manufacturing costs Variable selling and administrative Contribution margin Fixed costs $25,680 U $25,680 U 4,500 F $21.180 U 329,680 68,000 $442,320 76,000 F 18,000 F $ 424,000 S 106,000 U 304,000 $4,000 F $4,000 F 40,000 F 380,000 90,000 530,000 72,000 Fixed selling and administrative costs Profit 195,500 132,320 $114,500 7,680 F S11,680 F $40,000 F 200,000 140,000 84,000 S 106,000 U 200,000 140,000 190,000 The individual cost variances are shown in Exhibit 16.11