Prompt: Please only solve this problem using excel inputs, do not provide raw mathematical calculations Please just provide step by step excel operations I.e. step 1, step 2, step 3, each having excel inputs Please provide a definitive excel answer for each step and show the calculated final answer Prompt: What are the answers to these inputs for the question below 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? Prompt: Please solve excel sheet below using the data and parameters above. Please do not use a new excel sheet to solve, rather the data input and a copy of the data set. Please identify what variable the expected $100,000 in April, for example, whether it is the original Budget, expected budgeted, expected Volume, etc. Please identify all variables given. Please tell why each variable is favorable or unfavorable in one sentence. Hint: Steps should be as follows,

1. Calculate Budgeted Quantity

2. Calculate Original Budget

3. Calculate Flex Budget

4. Determine Volume Variance

5. Calculate VQA Budget

6. Determine Quantity Variance

7. Calculate Actual Budget

8. Determine Price Variance

9. Calculate Total Variance

10. Determine Favorability

11. Rationalize Favorability results

Options to choose from are in the excel sheet below for reference.

Problem 8-30
TEMPLATE
Total Variance	=
Original Budget:			Budgeted Volume	x	Budgeted Quantity	x	Budgeted Rate
Flex Budget:			Actual Volume	x	Budgeted Quantity	x	Budgeted Rate
Original Budget:				x		x		=	$0
Flex Budget:		-		x		x		= -	$0
						Volume Variance	=	$0
Flex Budget:			Actual Volume	x	Budgeted Quantity	x	Budgeted Rate
VQA Budget:			Actual Volume	x	Actual Quantity	x	Budgeted Rate
				x		x		=	$0
		-		x		x		= -	$0
						Quantity Variance =			$0
VQA Budget:			Actual Volume	x	Actual Quantity	x	Budgeted Rate
Actual:			Actual Volume	x	Actual Quantity	x	Actual Rate
				x		x		=	$0
		-		x		x		= -	$0
						Price Variance =	$0