$\backslash$table$[[,\backslash$table$[[$Fixed$],[$Component$]],\backslash$table$[[$Variable$],[$Component$]]],[$Revenue$,,$$$,16\mathrm{.}50,],[$Cost of ingredients,,$$,6\mathrm{.}25,],[$Wages and salaries,$$,10,400,,],[$Utilities$,$$$,800,$$$,0\mathrm{.}20],[$Rent$,$$$,2,200,,],[$Miscellaneous$,$$$,600,$$$,0\mathrm{.}80]]$

$\backslash$table$[[$Actual results:,,$],[$Revenue$,$$$,27,920],[$Cost of materials,$$,11,110],[$Wages and salaries,$$,10,130],[$Utilities$,$$$,1,080],[$Rent$,$$$,2,200],[$Miscellaneous$,$$$,2,240]]$

$\backslash$table$[[$Planning budget activity,$1,800,$units$],[$Actual activity,$1,700,$units$]]$

Required:

Construct a flexible budget performance report.

Note: Use an ABS$()$ formula to calculate variances. If a variance is $0,$ use $F$ for favorability. All amounts should be entered as positive values.

$\backslash$table$[[,,\backslash$table$[[$Actual$],[$Results$]],\backslash$table$[[$Revenue and$],[$Spending$],[$Varlances$]],$Favorable$/$Unfavorable$,\backslash$table$[[$Flexible$],[$Budget$]],\backslash$table$[[$Activity$],[$Variances$]],$Favorable$/$Unfavorable$,\backslash$table$[[$Planning$],[$Budget$]]],[$Units Sold,,$1,700,,,1,700,,,1,800],[$R$$venue$,$$$,27,920,,$Unfavorable,$28,050,,$Unfavorable,$29,700],[$Expenses:$],[$Cost of materials,$$,11,110,.,$Unfavorable,$10,625,,$Favorable,$11,250],[$Wages and salaries,$$,10,130,,$Favorable,,,,$7],[$Utilities$,$$$,1,080,,$Favorable,$1,140,,$Favorable,$1,160],[$Rent$,$$$,2,200,,,,,,$f$.],[$Miscellaneous$,$$$,2,240,,$Unfavorable,$1,960,,$Favorable,$2,040],[$Total expenses,$$,26,760,,$Unfavorable,,,Favorable,$],[$Net operating income,S$,1,160,,$Unfavorable,,,Unfavorable,$]]$

Please Find the Revenue and Spending Cariance for the Actual results and please find if it is favoable or unfavorable Please find the flexible budget and the the activity variances and the planning budget also please find the total expenses and net operating income Thank you!