Please answer these in excel & show the excel formulas please. thank you WILL RATE

1. Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) (Always use cell references and formulas where appropriate to receive full credit) a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted. b. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (unfavorable) when describing the variances. c. For variances with a zero amount, make sure to enter the result of " =0 " in the appropriate cell and leave the drop-down to identify the variance as either F or U blank. 2. What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? (Always use cell references and formulas where appropriate to receive full credit.) The Edinburgh Company produces engine parts for car manufacturers. A new accountant intern at Edinburgy has accidentally deleted the company's variance analysis calculations for the year ended December 31,2020. The partial table of what remains of the data has been provided on the ENTERANSWERS tab. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Requirements 1 Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the b. variances. For variances with a zero amount, make sure to enter the result of " =0 " in the appropriate cell and leave the dropc. down to identify the variance as either F or U blank. 2 What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? 1. Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) (Always use cell references and formulas where appropriate to receive full credit.) 2. What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit? (Always use cell references and formulas where appropriate to receive full credit.)