could u add excel formulas plz

+ CH? Sett Update A Do you odales 11 0 K M Flexible Budgets, Direct Cost Variances, and Management Control Flexible Budget 3 Sweeney Enterprises manufactures tires for the Formulai motor racing circuit. The company's budgeted and actual amounts are as follows: 3,550 Budgetedhor August 2017 Units to manufacture and sell Variable cost per tire Total fixed costs 10 Budgeted selling price per tire $72 $54,500 5115 Actual Results for August 2017 Units manufactured and sold 3,500 14 Selling price per tire $116 Total variable costs $280,000 1 Total fixed costs $51,000 10 Use the blue shaded areas for inputs. w Always use cell references and formulas where appropriate to receive full credit. 30 21 Requirement 22 Prepare a performance report that uses a flexible budget and a static budget. 22 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 24 selections for F (favorable) or (unfavorable) when describing the variances. C. For variances with a zero amount, make sure to enter the result of in the appropriate cell and leave the drop-down to identify the variance as either 23 27 Prepare a performance report that uses a flexible budget and a static budget. 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 30 and leave the drop down to identify the variance as either For U blank CA Shape Media Comment Collaborate CH Sheet A Update Do you update EN D L *+ 2. Prepare a performance report that uses a flexible budget and a static budget. 23 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 2 selections for F (favorable) or (unfavorable) when describing the variances. c. For variances with a zero amount, make sure to enter the result of - in the appropriate cell and leave the drop-down to identify the variance as either F 20 21 Prepare a performance report that uses a flexible budget and a static budget. 20 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 20 (favorable) or U (unfavorable) when describing the variances. C. For variances with a zero amount, make sure to enter the result of in the appropriate cell 30 and leave the drop-down to identify the variance as either For U blank. (Always use cell references and formulas where appropriate to receive full credit. If you copy/ paste from the Instruction tab you will be marked wrong.) 13 23 Flexible Budget 3.500 Sales. Volume Variances 100 "Variances should be presented as positive numbers usin 30 Static Budget 3,550 $ 408,250 Actual Flexible-Budget Results Variance Units sold 3,500 0 Revenues $ 406,000 $402, 500 F Variable costs $ 280,000 U Contribution margi $126,000 U Fixed costs 5 51,000 F Operating income $ 75.000 U 3 27 30 40 41 3DS