I need help on part d, thank you
Crane Entertainment Corporation prepared a master budget for the month of November that was based on sales of 195,000 board games. The budgeted Income statement for the period is as follows. $2.925,000 $780,000 292.500 487.500 Sales Revenue Variable expenses Direct materials Direct labor Variable overhead Total variable expenses Contribution margin Fixed overhead Fixed selling and administrative expenses Totalfoed expenses Operating income 1560.000 1365.000 210.000 420.000 630,000 $735.000 During November, Crane produced and sold 180.000 board games. Actual results for the month are as follows $2.620.000 $710.000 257.000 440.000 Sales Revenue Variable expenses Direct materials Direct labor Variable overhead Total variable expenses Contribution margin Fbedoverhead Flved selling and administrative expenses Total expenses Operating income 1.407.000 1213.000 197.000 435.000 632.000 5581.000 (a) Prepare a flexible budget for November. (Roundunit answers to 2 decimal places. e. 5.256 olether answers to decimal places, es. 125) Unit 180.000 games Sales revenue 15 Less Variable expenses Direct material 720000 Direct labor - 1.50 Variable overhead Total variable expenses Contribution margin 1250000 Federe Overhead Selling and Tould expenses Unit 180.000 games 2700000 Sales revenue 15 $ Less Variable expermes Direct material 720000 Direct labor 2.50 270000 Variable overhead 2.50 490000 Total variable expenses 1440000 Contribution margin 1260000 Less Fixed expenses Overhead 210000 Selling and administrative 420000 Total expenses 630000 Operating income 630000 (b) Calculate Crane's static budget variance for November. (Round answers to decimal places.es 12. Enteral warence amounts es positive values. Ifwarianciszem, select "Not Applicable and enter for the comments) Actual Results Static Budget Variance Static Budget 100000 15000 Untavorable 199000 2620000 S 305000 Unfavor S 2925000 720000 70000 Favorable 780000 257000 35500 Favorable 292500 440000 7500 Favorable 1407000 153000 Favorable 1560000 1213000 152000 Unfavorab 1365000 197000 13000 Favorabi 210000 20000 15000 Unfavora 420000 12000 2000 Unfavorable 581000 150300 Untavorable (d) Based on the available information, prepare a performance report for management. (If variance is zero, select "Not Applicable and enter for the amounts.) Actual Results Flexible Budget Variance Init Sales 1 Sales revenue Less : Variable expenses Direct material Direct labor I Variable overhead Total variable expenses . Contribution margin Less Fixed expenses Overhead - Selling and administrative Total fixed expenses $ Operating income (d) Based on the available information, prepare a performance report for management. (If variance is zero, select "Not Applicable" and enter for the amounts.) udget Variance Flexible Budget Sales Volume Variance $ $ (d) Based on the available information, prepare a performance report for management. (If variance is zero, select "Not Applicable" and enter O for the amounts.) Flexible Budget Sales Volume Variance Static Budget $ $