Please provide with the excell formula for each answer $1$

Glara Manufacturing is comparing its latest financial results to the planned Budget Use the information below to create a Flexible Budget and calculate variances.

$\backslash$table$[[,\backslash$table$[[$Fixed$],[$Component$]],\backslash$table$[[$Varlable$],[$Component$]]],[$Revenue$,,,$S$,16\mathrm{.}70],[$Cost of ingredlents,,,$$,6\mathrm{.}35],[$Wages and salaries,$5,10,450,,],[$Utilites$,$$$,820,5,0\mathrm{.}20],[$Rent$,$$$,2,240,,],[$Miscellaneous$,5,630,5,0\mathrm{.}80]]$

$\backslash$table$[[$Actual results:,,$],[$Revenue$,$$$,28,220],[$Cost of materials,$$,11,290],[$Wages and salaries,$$,10,170],[$Uullities$,$$$,1,090],[$Rent$,$$$,2,240],[$Miscellaneous$,$$$,2,280]]$

$\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 varlances. If a varlance is $0,$ use F for favorabillty. 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$],[$Varlances$]],$Favorable$/$Unfavorable$,\backslash$table$[[$Planning$],[$Budget$]]],[\backslash$table$[[$Units Sold$],[$Revenue$]],$F$,Y,r,r,,,],[$Expenses:$],[$Cost of materials,F$,Y,r,r,Y,$V$,$F$],[$Miscellaneous$,$V$,r,r,r,$r$,7,$F$],[$Total expenses,E$,F,r,$F$,F,7,$F$],[$Net operating income,$,Y,r,r,$F$,,$E$]]$