Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Justice township tries to keep tight control over the costs of the municipal court system. Since the town is small, its courts operate only a

Justice township tries to keep tight control over the costs of the municipal court system. Since the town is small, its courts operate only a few days a week, and they get by largely with part-time workers. Last month it was expected that court stenographers would cost $25,000, but they actually cost $30,000, which is 20 percent more than the budgeted amount. The municipal judge has argued that the bench heard more cases than expected, and this caused the increase. The director of the towns budget office feels that a 20 percent variance is unreasonable. As an analyst for the budget office, you have been asked to explain the variance . Your investigation shows that it was expected that there would be 125 trial stenographers would be paid $20 per hour, and each trial would take an average 10 hours. Actually, there were 150 trials, lasting 8 hours each on average, and stenographers earned $25 per hour. Calculate the volume, quantity, and rate variances, and provide some possible explanations for each.

The grey cells need to be filled out and It needs to be completed in the format based on the screenshot of the excel I pasted below, there are two sheets the prof wants us to fill in:

image text in transcribed

image text in transcribed

What do I fill in the grey shaded cells

Original Budget Budgeted Volume (Trials) Budgeted Quantity (Hours) Budgeted Rate (per hour) 125 x 10 X 20 - $ 25,000 Flex Budget Actual Volume (Trials) Budgeted Quantity (Hours) Budgeted Rate (per hour) Original Budget versus Flex Budget X Budgeted Volume Actual Volume X X Budgeted Quantity (Hours) Budgeted Quantity (Hours) Budgeted Rate (per hour) Budgeted Rate (per hour) Interpretation Volume Variance VQA Budget Actual Volume (Trials) Actual Quantity (Hours) Budgeted Rate (per hour) Flex Budget versus VOA Budget Actual Volume Actual Volume x X Budgeted Quantity (Hours) Actual Quantity (Hours) Budgeted Rate (per hour) Budgeted Rate (per hour) Interpretation Quantity variance Actual Actual Volume (Trials) Actual Quantity (Hours) Actual Rate (per hour) . VOA Budget versus Actual Budget Actual Volume (Trials) Actual Volume (Trials) Actual Quantity (Hours) Actual Quantity (Hours) Budgeted Rate (per hour) Actual Rate (per hour) Interpretation Price variance Flex VOA Budget Actual Budget Budget Number of trials (volume) Hours per trial (quantity) Payment per hour (price) Total Variance due to Volume Variance due to Quantity Variance due to Price Total Variance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions