please include the excel formulas

LE Paste BIU a. Av Merge & Center $ E10 x fx B D E 1 Flexible Budgets, Direct Cost Variances, and Management Control 2 Flexible Budget G H K 3 Sweeney Enterprises manufactures tires for the Formula 1 motor racing circuit. The company's budgeted and actual 4 amounts are as follows: 5 6 Budgeted for August 2017 7 Units to manufacture and sell 3,550 8 Variable cost per tire $72 9 Total fixed costs $54,500 10 Budgeted selling price per tire $115 11 12 Actual Results for August 2017 13 Units manufactured and sold 3,500 14 Selling price per tire $116 15 Total variable costs $280,000 16 Total fixed costs $51,000 17 18 Use the blue shaded areas for inputs. 19 Always use cell references and formulas where appropriate to receive full credit. 20 21 Requirement 22 Prepare a performance report that uses a flexible budget and a static budget. 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 (favorable) or (unfavorable) 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 For U 23 a. b. 24 C. 25 26 27 Prepare a performance report that uses a flexible budget and a static budget. 28 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 29 (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 30 the drop-down to identify the variance as either For U blank LED Vy - General TWI $ % 9 -3 Conditional Format Cell Formatting as Table Styles pos A a 1 M N 0 P 2 Wrap Text Paste a 3 Marge & Center E10 Xfx C H 27 Prepare a performance report that uses a flexible budget and a state budget. 21 a. Enter all amounts as positive values. Do NOT use parentheses or a minus in for amounts to be subtracted b. Use the Ass function when calculating variances, and use the drop down selections for F (favorable) or U 29 (unfavorable) when describing the variances c. For variances with a vero amount, make sure to enter the result of "ug" in the appropriate cell and leave 30 the drop down to identify the variance as either For U blank ways we cell references and formulas where appropelate to receive full credit. If you coew/paste from the 31 Instruction tab you will be marked wron) 33 'Varlances should be presented as positive numbers using the ABS function 13 30 Units sold 15 Revenues 36 Variable costs 32 Contribution margin 18 Fed costs Operating Income 40 41 12 41 Flexible Flexible SalesVolume Actual Results Variance Budget Variance Static Bluet 3,500 0 3,500 3.50 3,550 106,000 3.500 5 4025004012501 US 10250 5 280.000 28.000 U 252.000 227.600 IS 255,600 126,000 24,500 $ 150,500 5 128, 150) US 152.650 $ 53,000 3,500U S 54,500 5 (51.000 S 54,500 7.000 21.000 US 000 (22150) US 9150