Chapter 23, Problem 3BP

1.

To determine

Examine the monthly overhead budget to (a) ascertain the costs per unit for each variable overhead item and its total per unit costs, and (b) identify the total fixed costs per month.

Explanation of Solution

Overhead Budget:

Overhead budget is prepared to predict the manufacturing costs, other than direct materials and direct labor costs.

(a) Ascertain the costs per unit for each variable overhead item and its total per unit costs.

Particulars	Amount in $ (A)	Total  units to  be divided (1) (B)	Variable cost per unit                         $\left(\text{A}÷\text{B}\right)$
Variable costs :
Indirect materials	22,500	15,000	1.5
Indirect labor	90,000	15,000	6
Power	22,500	15,000	1.5
Repairs and maintenance	45,000	15,000	3
Total variable costs	180,000	15,000	12

(Table 1)

Working notes:

Calculate the factory capacity units for 75% capacity level:

$\begin{array}{c}\text{Factory capacity for 75\% = Total capacity of units }\times \text{ 75\%}\\ \text{=20,000 units }\times \text{75\%}\\ \text{=15,000 units}\end{array}$ (1)

(b) Identify the total fixed costs per month.

Particulars	Amount in $
Fixed costs (per month)
Depreciation—Building	24,000
Depreciation—Machinery	72,000
Taxes and insurance	18,000
Supervision	66,000
Total fixed costs	180,000

(Table 2)

2.

To determine

Prepare flexible overhead budgets for October showing the amounts of each variable and fixed cost at the 65%, 75%, and 85% capacity levels.

Explanation of Solution

Prepare flexible overhead budgets for October showing the amounts of each variable and fixed cost at the 65%, 75%, and 85% capacity levels.

Company S
Flexible overhead budgets
For the  month  ended October 31
	Flexible budget		Flexible	Flexible	Flexible
	Variable amount per unit in $	Total fixed cost  in $	Budget for units sales of $13,000  in $	Budget for units sales of $15,000 in $	Budget for units sales of $17,000 in $
Variable overhead costs
Indirect materials	1.5		19,500	22,500	25,500
Indirect labor	6		78,000	90,000	102,000
Power	1.5		19,500	22,500	25,500
Repairs and maintenance	3		39,000	45,000	51,000
Total variable costs	12		156,000	180,000	204,000
Fixed overhead costs
Depreciation—Building		24,000	24,000	24,000	24,000
Depreciation—Mach.		72,000	72,000	72,000	72,000
Taxes and insurance		18,000	18,000	18,000	18,000
Supervision		66,000	66,000	66,000	66,000
Total fixed costs		180,000	180,000	180,000	180,000
Total overhead costs			336,000	360,000	384,000

(Table 3)

3.

To determine

Compute the direct materials cost variance, including its price and quantity variances.

Explanation of Solution

Compute the direct materials cost variance:

Particulars	Amount in $
Direct material cost variances:
Actual units at actual cost $\left[69,000lbs.@\$6.10\right]$	420,900
Less: Standard units at standard cost $\left[\text{67,500 }lbs.(2)@\$6.00\right]$	405,000
Direct material cost variance (unfavorable )	15,900

(Table 4)

Compute the direct materials price variance:

$\begin{array}{c}\text{Price variance =Actual quantity ×}\left(\text{Actual price -Standard price}\right)\\ \text{=69,000lb×}\left(\text{\$6}\text{.10-\$6}\text{.00}\right)\\ \text{=\$6,900}(unfavorable)\end{array}$

Compute the direct materials quantity variance:

$\begin{array}{c}\text{Quantity variance =}\left(\text{Actual quantity}-\text{Standard quantity}\right)\text{ × Standard price}\\ \text{=}\left(\text{69,000lb}-67,500lb(2)\right)\text{×\$6}\text{.00 per lb}\text{.}\\ \text{=\$9,000}(unfavorable)\end{array}$

Working Notes:

Calculate the standard quantity of materials:

 $\begin{array}{c}\text{Standard quantity of materials=}\left(\begin{array}{l}\text{Capacity of units for 75\% of }\\ \text{capacity level (1)}\end{array}\right)\text{×Direct material units}\\ \text{=15,000 units ×4}\text{.5lb}\text{./unit}\\ \text{=67,500 lb}\text{.}\end{array}$ (2)

4.

To determine

Compute the direct labor cost variance, including its rate and efficiency variances.

Explanation of Solution

Compute the direct labor cost variance:

Particulars	Amount in $
Direct labor cost variances:
Actual units at actual cost $\left[\text{22,800 hrs}.@\$12.30\right]$	280,440
Less: Standard units at standard cost $\left[\text{22,500hrs}.(3)@\$12.00\right]$	270,000
Direct labor cost variance (unfavorable )	10,440

(Table 5)

Compute the direct labor rate variance:

$\begin{array}{c}\text{Labor Rate variance =Actual Hours ×}\left(\text{Actual Rate -Standard Rate}\right)\\ \text{=22,800 hrs×}\left(\text{\$12}\text{.30-\$12}\text{.00}\right)\\ \text{=\$6,840 unfavorable}\end{array}$

Compute the direct labor efficiency variance:

$\begin{array}{c}\text{Labor efficiency variance =}\left(\text{Actual Hours}-\text{Standard Hours }\right)\text{ × Standard rate }\\ \text{=}\left(22,800-22,500(3)\right)\text{×\$12}\text{.00 per hr}\text{.}\\ \text{=\$3,600 unfavorable}\end{array}$

Working Notes:

Calculate the standard efficiency variance:

 $\begin{array}{c}\text{Standard efficiency variance =}\left(\begin{array}{l}\text{Capacity of units for 75\% of }\\ \text{capacity level (1)}\end{array}\right)\text{×Direct labor units}\\ \text{=15,000 units ×1}\text{.5hr}\text{./unit}\\ \text{=22,500 hours}\end{array}$ (3)

5.

To determine

Prepare a detailed overhead variance report that shows the variances for individual items of overhead.

Explanation of Solution

Company  S
Overhead variance report
For the month ended October 31
Controllable Variance	Flexible Budget (A)	Actual results (B)	Variances $\left(A-B\right)$
Variable overhead costs
Indirect materials	$22,500	$21,600	$900 F
Indirect labor	$90,000	$82,260	$7,740 F
Power	$22,500	$23,100	$600 U
Repairs and maintenance	$ 45,000	$46,800	$1,800 U
Total variable costs	$180,000	$173,760	$6,240 F
Fixed overhead costs
Depreciation—Building	$ 24,000	$24,000	$0
Depreciation—Machinery	$72,000	$75,000	$3,000 U
Taxes and insurance	$18,000	$16,500	$1,500 F
Supervision	$66,000	$66,000	$0
Total fixed costs	$180,000	$181,500	$1,500 U
Total overhead costs	$360,000	$355,260	$ 4,740 F

(Table 6)

Note:

• Expected production level and production level achieved is 75%
• Favorable condition is denoted by F and Unfavorable condition is denoted by U.