ol File Edit View Insert Format Tools Det Window Help AutoSave BE Ch 078 (Empty) Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Calibri (Body 12 AA 23 wrap Text General Paste 8 I U OA Marge Canter 5 % ) 132 A M K M 12 Xfx 0 E 3 Sweeney Enterprises manufactures tires for the Formulai motor racing croat. The company's budgeted and actual amounts are as follow 5 Budgeted for August 2017 7 Units to manufacture and sell 3,600 8 Variable cost per tire 571 9. Totaled costs $55,000 10 Budgeted selling price per tire $114 11 Actual Results for August 2017 11 Units manufactured and sold 3,500 14 Selling price per tire $116 15 Total variable costs $280,000 16 Totalfixed costs $51.000 17 18. Use the blue shaded areas for inputs. 19 Always de 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 23 Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted. ti Use the ABS function when calculatine variances, and use the drop-down selections 24 for F favorable) or (unfavorable) when describing the variances For variances with a zero amount o sure to enter the result of "0" in the appropriate cell and leave the drop down to identify the variance as either FOU C 2 20 27 Prepare a performance report that uses a flexible budget and a static budget 25. 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 favorable or (unfavorable) when describing the variances c. For variants with a zero amount, make sure to enter the result of in the appropriate cell and leave 30. the drop down to identify the variance as eitherto un 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 wrong CHTE 17.004 MacBook Air Fle Edit View Insert Format Tools Data Window Help Eu. 000 Alave GF Home Insert Ch 078 (Empty Tell me Draw Page Layout Formulas Data Review View XLSTAT E C body 12 ' ' P 10 Wrap To Gene Posts BIU- OA Merge Center $ % Canon F Foto 32 Xx A c 0 man 21 repertomance report that uses afebliebend state buteet 23 rall amount item Do NOT le parentheses sin for amounts to be tract Use the ABS function when calling and use the drip down select 24 forbielor Ulustave when the For variances with a remot, male sure to enter the rest in the 15 approprel and wave the drop down to try the wariance as her 26 Prepare a performance report that uses a flexible and it 2 Emeralmente as positive. Do NOT neseseram for amounts to be traced UINAS function when calling races and use the drop-doction for two a for when describing the we For with a mout, to the result in the land we the down to the other Always ferences and form where to lordt you want to the you will be there wrong 13 Flexible Sales Volume 1 Adalet VG Budges Van SB Vad been the Units said Ver IT Twd costs Con CHT 00 4 MacBook Air BOG