menu
bartleby
search
close search
Hit Return to see all results

dAnalysis of variances:Materials variancesEfficiencyTotalPriceinclude formula for materials price variance hereinclude formula for materials efficiency variance hereLabor variancesLabor rateEfficiencyTotalinclude formula for labor rate variance hereinclude formula for labor efficiency variance hereEfficiencyVariable overhead variancesSpendingTotalinclude formula for spending variance hereinclude formula for labor efficiency variance hereAnalysis:

Question

I could use some help with (d) (at the bottom) on this.

 

Porter Corporation has just hired Bill Harlow as its new controller.  Although Harlow has had little formal accounting training, he professes to be highly experiences, having learned accounting "the hard way" in the field.  At the end of his first month's work, Harlow prepared the following performance report:

  Total Actual Costs Total Budgeted Costs Variances
Direct materials $216,630 $237,600 $20,970 F
Direct labor 119,340 132,000 12,660 F
Variable overhead 63,000 66,000 3,000
Fixed overhead 184,000 184,000  
  $582,970 $619,600 $36,630 F

In his presentation at Porter's month-end management meeting, Harlow indicated that things were going "fantastically." "The figures indicate," he said, "that the firm is beating its budget in all cost categories."  This good news made everyone at the meeting happy and furthered Harlow's acceptance as a member of the management team.

After the management meeting, Susan Jones, Porter's general manager, asked you, as an independent consultant, to review Harlow's report.  Jones' concern stemmed from the fact that Porter has never operated as favorably as Harlow's report seems to imply, and she cannot explain the apparent significant improvement.

While review Harlow's report, you are provided the following cost and operating data for June: Porter has a monthly normal capacity of 11,000 direct labor hours or 8,800 units of product.  Standard costs per unit for its only product are direct materials 3 pounds at $9 per pound; direct labor, 1.25 hours at $12 per hour; and variable overhead rate per direct labor hour of $6.  During June, Porter produced 8,000 units of product, using 24,900 pounds of materials costing $8.70 each, 10,200 direct labor hours at an average rate of $11.70 each, and incurred variable overhead costs of $63,000 and fixed overhead costs of $184,000.

After reviewing Porter's June cost data, you tell Harlow that his cost report contains a classic budgeting error, and you explain how he can remedy it.  In response to your suggestion, Harlow revises his report as follows:

  Total Actual Costs Total Budgeted Costs Variances
Direct materials $216,630 $216,000 $630 U
Direct labor 119,340 120,000 660 F
Variable overhead 63,000 60,000 3,000 U
Fixed overhead 184,000 184,000  
  $582,970 $580,000 $2,970 U

Harlow's revised report is accompanied by remarks expressing regret at the oversight in the original report.

 

Required

In your role as consultant,

d) Further analyze Harlow's revised variances, isolating underlying potential causal factors.  How do your analyses indicate bases for concern to management?  Include the formula for the variance rate and efficiency rate.

d
Analysis of variances:
Materials variances
Efficiency
Total
Price
include formula for materials price variance here
include formula for materials efficiency variance here
Labor variances
Labor rate
Efficiency
Total
include formula for labor rate variance here
include formula for labor efficiency variance here
Efficiency
Variable overhead variances
Spending
Total
include formula for spending variance here
include formula for labor efficiency variance here
Analysis:
help_outline

Image Transcriptionclose

d Analysis of variances: Materials variances Efficiency Total Price include formula for materials price variance here include formula for materials efficiency variance here Labor variances Labor rate Efficiency Total include formula for labor rate variance here include formula for labor efficiency variance here Efficiency Variable overhead variances Spending Total include formula for spending variance here include formula for labor efficiency variance here Analysis:

fullscreen
check_circleAnswer
Step 1

Working Note:

Al
AJ
AK
AL
7
16
Comparison
Actual
24900
Budgeted
-8000*3
17 Particulars
Variance
-AK18-AJ18
18 Direct Material
-8000*1.25
10200
-AK19-AJ19
19 Direct Labor hours
20 Variable Cost per labor hour -63000/10200 6
21 Material cost per pound
22 Direct Labor per hour
AK20-AJ20
-AK21-AJ21
8.7
11.7
-AK22-AJ22
12
23
Comparison
Actual
Budgeted Variance
Particulars
Direct Material
24000
24900
900
Direct Labor hours
-200
10200
10000
Variable Cost per labor hour
Material cost per pound
6.1765
6
-0.1765
8.7
9
0.3
help_outline

Image Transcriptionclose

Al AJ AK AL 7 16 Comparison Actual 24900 Budgeted -8000*3 17 Particulars Variance -AK18-AJ18 18 Direct Material -8000*1.25 10200 -AK19-AJ19 19 Direct Labor hours 20 Variable Cost per labor hour -63000/10200 6 21 Material cost per pound 22 Direct Labor per hour AK20-AJ20 -AK21-AJ21 8.7 11.7 -AK22-AJ22 12 23 Comparison Actual Budgeted Variance Particulars Direct Material 24000 24900 900 Direct Labor hours -200 10200 10000 Variable Cost per labor hour Material cost per pound 6.1765 6 -0.1765 8.7 9 0.3

fullscreen
Step 2

Material Variances

Material Variances
Material Price Variance
Actual Quantity (Actual price Standard Price)
24900 (8.7-9) = 24900(0.3) 7470 F
Standard cost per pound (Actual material - standard material)
Material Efficiency Variance
=9 (24900-24000) = 9(900) 8100 U
Material Cost Variance
Actual Cost
Standard Cost
(24000 9) (24900 8.7) 630 U
help_outline

Image Transcriptionclose

Material Variances Material Price Variance Actual Quantity (Actual price Standard Price) 24900 (8.7-9) = 24900(0.3) 7470 F Standard cost per pound (Actual material - standard material) Material Efficiency Variance =9 (24900-24000) = 9(900) 8100 U Material Cost Variance Actual Cost Standard Cost (24000 9) (24900 8.7) 630 U

fullscreen
Step 3

Labor Varia...

Labor Variances
Labor Rate Variance Actual Hours (Actual rate standard rate)
-10200 (11.7-12)
10200 (.3)
3060 F
Standard Rate ( Actual Hours Standard Hours)
Labor Efficiency Variance
-
= 12 ( 10200-10000) 12(200) 2400 U
Labor Cost Variance
Actual Cost Standard Cost
=(10200*11.7) (10000*12) 660F
help_outline

Image Transcriptionclose

Labor Variances Labor Rate Variance Actual Hours (Actual rate standard rate) -10200 (11.7-12) 10200 (.3) 3060 F Standard Rate ( Actual Hours Standard Hours) Labor Efficiency Variance - = 12 ( 10200-10000) 12(200) 2400 U Labor Cost Variance Actual Cost Standard Cost =(10200*11.7) (10000*12) 660F

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in

Business

Accounting

Standard Costing

Related Accounting Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: In two or three paragraphs explain the purpose of variance analysis and its benefits and drawbacks.

A: Click to see the answer

question_answer

Q: Professional Labor Cost Budget for a Service Company Rollins and Cohen, CPAs, offer three types of s...

A: Prepare a professional labor cost budget for each department of  Rollins and Cohen, CPA for the year...

question_answer

Q: Cost of Goods Sold and the Periodic System Hermani Company uses the periodic inventory system. Herma...

A: A periodic inventory system is a system used to determine the inventory at the end of specific perio...

question_answer

Q: 27,000 shares reacquired by Monty Corporation for $56 per share were exchanged for undeveloped land ...

A: Journal entry: Journal entry is a set of economic events which can be measured in monetary terms. Th...

question_answer

Q: 45. PR.03-16.Algo (Algorithmic) Problem 3-16 (Algorithmic) Special Clothing and Uniforms (LO 3.8) Co...

A: Calculate total deduction on their Schedule Cs for special clothing and uniforms: 

question_answer

Q: I need help solving this problem, thanks!

A: a) Compute the number of units in work in process inventory at March 31: 

question_answer

Q: They are going to start a manufacturing company and need help deciding what entity type to choose to...

A: The different types of business entities prevent in an economy are(a)    Sole Proprietorship(b)    P...

question_answer

Q: The Mendholm Company entered into the following transactions: Performed services on account, $21,50...

A: Accounting Equation = Assets = Liabilities + Shareholder’s Equity (Capital + Retained Earnings)(a)  ...

question_answer

Q: I cannot figure out how to do this two department problem   Patterson Laboratories, Inc., produces o...

A: (a) Required journal entries are as follows:

Sorry about that. What wasn’t helpful?