PLEASE USE EXCEL

Information related to TELEVISION Model A performance for the year ending December $31,2022,$ is given

below:

Actual Budgeted

Units made and sold $7500070,000$

Selling price $$105$ per unit $ $100$ per unit

Variable costs $ $80$ per unit $$85$ per unit

Fixed costs $ $280,000$ $ $250,000$

Required:

a$.$ Prepare a Television Manufacturing Company's Flexible$-$budget, Static$-$budget, Flexible budget variance, Static Budget variance, and Sales$-$volume variance for $($i$)$ revenues, $($ii$)$ variable costs, $($iii$)$ fixed costs, and $($iv$)$ operating income. Label each variance as favorable $($F$)$ or unfavorable $($U$).($For variances with a $$0$ balance, make sure to enter $"0"$ in the appropriate field.

b$.$ Recommend three strategies to help your Company increase its favorable operating income variance

PLEASE USE EXCEL!!!