The fire department expected to spend $100,000 in April. Actually, it spent $108,680. The department thought it would pay each member of its team of firefighters $25 per hour. However, it paid them each $26 per hour on average. The department expected that the team of firefighters would work a total of 4,000 hours and fight 100 fires. Of course, many hours the firefighters are on duty in the station house between fires. Those hours are considered to be worked and the firefighters are paid for those hours. The actual results were 4,180 hours worked by the team of firefighters and 110 fires fought by the department. What was the total variance? What were the rate (or price), quantity, and volume variances? Which variances were favorable and which were unfavorable?

Please show work and CALCULATIONS in EXCEL.