Glenworth high school needs to purchase uniforms for its football players. In previous years, they spent $2,592 on uniforms, at a price of $72 per uniform, with each player receiving 1.2 uniforms on average during the season. (In some cases, uniforms needed to be replaced due to wear and tear.) They anticipated that they would need to budget a similar amount for this year’s season. However, at the end of the season they had spent $3,150 on 42 uniforms. There were 28 players on this year’s team.
Fill in the following blanks:
[Note: Use a hyphen or dash to indicate negative numbers, e.g. -54.67. Do not use parentheses. Round your numbers to TWO decimal places, e.g. 54.12.]
A) The volume variance is $
B) The quantity variance is $
C) The price variance is $
D) Of the 3 variances you calculated above, how many were favorable? [write 0 or 1 or 2 or 3]
Please show in excel?