Question

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 town’s 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:

Original Budget Budgeted Volume (Trials) Budgeted Quantity (Hours) Budgeted Rate (per hour) 125 x 10 X 20 - $ 25,000 Flex Bud

Flex VOA Budget Actual Budget Budget Number of trials (volume) Hours per trial (quantity) Payment per hour (price) Total Vari

What do I fill in the grey shaded cells

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Solution:
Apart from attached sheet image, please see below:
VQA Flex
Actual Budget Budget Budget
Number of trails (Vol) 150 125 125 125
Hours per trial (qty) 8 10 10 10
Payment per query (price) 25 20 20 20
Total 30000 25000 25000 25000
Variance due to volume -5000
Variance due to quantity 6000
Variance due to price -6000
Total variance -5000
Original Budget Budgeted Volume (Trials) Budgeted Quantity (Hours) Budgeted Rate (per hour) 125 x 10 X 20 - $ 25,000 Flex Bud
Add a comment
Know the answer?
Add Answer to:
Justice township tries to keep tight control over the costs of the municipal court system. Since...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Ander's Clothing manufactures embroidered jackets. The company uses a standard cost system to control manufacturing costs....

    Ander's Clothing manufactures embroidered jackets. The company uses a standard cost system to control manufacturing costs. The following data represent the standard unit cost of a​ jacket:   i Data Table $4.15 per sq. ft.) Direct materials 3.0 sq. ft x 12.45 Direct labor $9.70 per hour) ( 2,0 hours x 19.40 Manufacturing overhead: Variable 2.0 hours x $0.68 per hour) 1.36 4.40 5.76 2.0 hours x $2.20 per hour) Fixed 37.61 Total standard cost per jacket Fixed overhead in total...

  • Mastery Problem: Manufacturing Cost Variance (Actual Costs Compared to Standard Costs) Manufacturing cost variances may come...

    Mastery Problem: Manufacturing Cost Variance (Actual Costs Compared to Standard Costs) Manufacturing cost variances may come from material costs that are higher or lower than expected, material usage that is not what was expected, higher or lower labor costs than expected, or more or less time spent to produce an item than expected. Overhead cost and volume variances are another cause for costs to be higher or lower than what was expected. The total manufacturing variance can be broken down...

  • Mastery Problem: Manufacturing Cost Variance (Actual Costs Compared to Standard Costs) Manufacturing cost variances may come...

    Mastery Problem: Manufacturing Cost Variance (Actual Costs Compared to Standard Costs) Manufacturing cost variances may come from material costs that are higher or lower than expected, material usage that is not what was expected, higher or lower labor costs than expected, or more or less time spent to produce an item than expected. Overhead cost and volume variances are another cause for costs to be higher or lower than what was expected. The total manufacturing variance can be broken down...

  • A. The standard costs and actual costs for direct materials for the manufacture of 2,240 actual...

    A. The standard costs and actual costs for direct materials for the manufacture of 2,240 actual units of product are as follows: Standard Costs Direct materials 2,240 kilograms @$8.60 Actual Costs Direct materials 2,300 kilograms The direct materials quantity variance is? Choose the correct answer below $413 favorable $516 unfavorable $516 favorable $413 unfavorable B. The following data relate to direct labor costs for the current period: Standard costs 7,200 hours at $11.30 Actual costs 6,400 hours at $10.80 What...

  • Oakly Variance Case manufactures a single product, XR2. Oakly uses budgets and standards and control functions....

    Oakly Variance Case manufactures a single product, XR2. Oakly uses budgets and standards and control functions. Oakly makes use of its standards in order to budgeted cost per unit. For example, Exhibit A provides information on the budgeted variable costs per unit. When determining direct material costs for the planning (master) budget income statement, the $11.48 budgeted material cost per unit of XR2 would be used in the calculation. Exhibit A Budgeted (Standard) Variable Costs Per Unit of XR2 Raw...

  • Which of the following statements is true? A single Variance clearing account is used to accumulate the individual var...

    Which of the following statements is true? A single Variance clearing account is used to accumulate the individual variances. Closing a favorable variance increases net operating income. Closing a favorable variance decreases net operating income. Closing an unfavorable variance increases net operating income. Knowledge Check 01 Lansing Inc.'s cost of goods sold at standard was $15,000. This represents the amount of cost of goods sold before considering the transaction that closes all variance accounts for the period. The company also...

  • Practice Exam 3 Cost Accounting XYZ Company manufactures and sells patio chairs. For the year 2016,...

    Practice Exam 3 Cost Accounting XYZ Company manufactures and sells patio chairs. For the year 2016, XYZ prepared its master budget on the basis of 4,000 units produced and sold. However, in 2016, because of acute competition in the industry, XYZ was only able to produce and sell 3,000 units. Table 1 provides XYZ Company's static budget and actual results using a contribution margin income statement. Table 1 Flexible-Budget Variances (2) (1)-(3) Sales Volume Variances (4)=(3)-(5) Flexible Budget (3) Actual...

  • Primara Corporation has a standard cost system in which it applies overhead to products based on...

    Primara Corporation has a standard cost system in which it applies overhead to products based on the standard direct labor-hours allowed for the actual output of the period. Data concerning the most recent year appear below: Total budgeted fixed overhead cost for the year Actual fixed overhead cost for the year Budgeted direct labor-hours (denominator level of activity) Actual direct labor-hours Standard direct labor-hours allowed for the actual output $ 473,600 $ 467,000 64,000 65,000 62,000 Required: 1. Compute the...

  • Check my work Songsu Co. is struggling to control costs. We are hired as consultants to...

    Check my work Songsu Co. is struggling to control costs. We are hired as consultants to determine why the company's actual costs exceed budgeted costs. The Tableau Dashboard is provided for our analysis. Direct Materials Direct Labor Standard Actual Standard Actual $7 $17 $6 6 lbs 15 $14 4 lbs 2 2.5 hrs 2 hrs Pounds Per Price Per Pounds Per Price Per Hours Per Price Per Hours Per Price Per Unit Pound Unit Pound Unit Hour Unit Hour Overhead...

  • The standard cost card for the single product manufactured by Cutter, Inc., is given below: Inputs...

    The standard cost card for the single product manufactured by Cutter, Inc., is given below: Inputs Direct materials Direct labor Variable overhead Fixed overhead Total standard cost per unit (1) (2) Standard Standard Quantity Price or Hours or Rate 5.4 yards $ 3.00 per yard 0.8 hours $ 16.00 per hour 0.8 hours $ 3.50 per hour 0.8 hours $ 6.00 per hour Standard Cost (1) x (2) $16.20 12.80 2.80 4.80 $36.60 Manufacturing overhead is applied to production on...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT