please show how you solved this. thank you!

Q Search Sheet Chapter_7_Inc-Class Group Work 1 (1) View Formulas Data Review + Share Home K16 Insert x Page Layout fx SS Bennett Street Table Company manufactures tables for schools. The 2018 operating budget is based on sales of 45,000 units at $55 per table. Operating income is anticipated to be $240,000. SI Budgeted variable costs are $35 per unit, while fixed costs total $660,000. Actual income for 2018 was a surprising $569,000 on actual sales of 46,000 units at $60 each. Actual variable costs were $34 per unit and fixed costs totaled $627,000. L T Required: Prepare a variance analysis report with both flexible-budget and sales volume variances. Bennett Street Table Company Variance Analysis Midend's Camera Shop has prepared the following flexible budget for September and is in the process of interpreting the variances. F denotes a favorable variance and U denotes an unfavorable variance. Variances $ Material A Material B Material Flexible Budget 26,000 39,000 46,000 Price $ 1,200U 400F 1,400U Efficiency $1,600F 800U 2,400F The actual amount spent for Material B was? Group 1 + Ready @ - + 100%