A Rescue Dog Kennel had a labor cost budget of $100,000 for the year. It expected its staff costs related to grooming, feeding, walking, and so on to vary in direct proportion with the number of dogs, based on an hourly rate of $20 for staff and a need for 10 hours of staff time per dog (before the dogs were adopted). In its budget for the year, it planned on rescuing 500 dogs. It turned out that it rescued 640 dogs for the year. The staff average cost turned out to be just $16 per hour. Staff were paid for a total of 6,000 hours. What is the total labor variance? Was it favorable or unfavorable? Why?

Did the number of dogs rescued result in a favorable or unfavorable volume variance? (You do not have to calculate the flexible variance.)

Did the number of hours of labor actually consumed for each dog cause a favorable or unfavorable variance? (You do not have to calculate the flexible variance.)

*Please show work and calculations IN EXCEL.