Please show how you get each number

5 6 1 Flexible Budgets, Direct-Cost Variances, and Management Control 2 Flexible Budget 3 Sweeney Enterprises manufactures tires for the Formula I motor racing circuit. The company's budgeted and actual 4 amounts are as follows: 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. 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. b. Use the ABS function when calculating variances, and use the drop-down selections for F (favorable) or U (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 20 23 a. a 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 unfavorable when describine the varianas 15 Total variable costs $280,000 16 Totale 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 1 Requirement 22 Prepare a performance report that uses a fleeble budget and a state budget 23 Enter all amounts as positive values. Do NOT ute 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 24 Ffavorable or unfavorable) when describing the variances c For variances with a vero amount, make sure to enter the result of in the 25 appropriate cell and leave the drop-down to identify the variance ether For U 24 27 Prepare a performance report that uses a flexible budget and static budget. 21 la Enterall amounts as positive values. Do NOT use parentheses or amous sign for amounts to be subtracted b. Use the ABS function when calculating variances, and use the drop-down selections for favorable) or U 29 unfavorable) when describing the variances For variances with a vero amount make sure to enter the result of in the appropriate cell and leave the 30 drop-down to identify the varianceseither For U blank (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 31 Instruction tab you will be marked wrone) 32 Flexible Budget Flexible Ses Volume 33 Actual Results Variance Budget Varian Static Budget 34 Units sold 35 Revenues 36 Variable costs * Contribution margin Fixed costs Operating income 0 "Variances should be presented as positive numbers using the ABS function