Excel with formula please and thank you. You guys are awesome BTW. Some times I can figure it out and check the answers and sometimes I just don't understand and need direction. Nevertheless, I applaud my friends at Chegg.

Flexible Budgets, Direct-Cost Variances, and Management Control Flexible budget, working backward The Clarkson Company produces engine parts for car manufacturers. A new accountant intern at Clarkson has accidentally deleted the company's variance analysis calculations for the year ended December 31, 2017. 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 b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances. 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. c. 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.) Actual Results Flexible-BudgetFlexible Budget Sales-Volume Variances Static Budget Variance Units sod Revenues Variable costs Contribution margin Fixed costs 130,000 $715,000 515,000 $200,000 140,000 60,000 120,000 $420,000 240,000 $180,000 120,000 $60,000 Operating income 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.) Actual selling price Budgeted selling price Actual variable cost per unit Budgeted variable cost per unit