I think I have the math portion right. How do I use this template?

Exercise 3 - Variance Analysis V > PBAD 3334: Introduction to Public and Nonprofit Financial Management Module 3: Variance Analysis Exercise 3 Note: You should download the Excel template files for these problems. You cannot complete the templates without downloading them first. Problem: 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 (40 hours per fire). 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? Review View File Formulas Home Data Tell me what you want to do Help Insert Page Layout 111 *011 F11 H11 E F G H . D 1 Variance Analysis Problem 2. 3 TEMPLATE 4 5 Total Variance (58,680) 6 7 Original Budget Budgeted Volume 8 Flex Budget Actual Volume 9 10 100 11 x Budgeted Quantity x Budgeted Rate x Budgeted Quantity