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:
What do I fill in the grey shaded cells
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 |
|
Justice township tries to keep tight control over the costs of the municipal court system. Since...
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 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 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 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 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 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, 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 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 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 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...