Problem 5 - Materials and Labor Manufacturing Variances and Analysis |
|
Background: |
|
The following information is for the standard |
|
and actual costs for Happy Corporation. |
|
Standard Costs: |
|
Budgeted units of production - 16000 |
|
Standard labor hours per unit - 4 hours |
|
Standard labor rate - $26 per hour |
|
Standard material per unit - 8 pounds |
|
Standard material cost - $12 per pound |
|
Actual Costs: |
|
Actual production - 16,500 units |
|
Actual materials purchased and used |
|
- 130000 pounds |
|
Actual total material cost = $1,600,000 |
|
Actual labor - 65,000 hours |
|
Actual total labor costs - $1,700,000 |
|
Part 1 - Calculate all Materials and Labor Variances |
|
Mark all variances as FAVORABLE or UNFAVORABLE. |
|
Part 2 - Analyze all variances and share possible |
|
theories as to why each variance turned out the way |
|
it did. Then, share your analysis and conclusion |
|
for how all materials and labor variances could fit |
|
together. |
Problem 5 - Materials and Labor Manufacturing Variances and Analysis | |||||||||||||||||||||
Part 1: | |||||||||||||||||||||
Direct Materials Cost Variances | |||||||||||||||||||||
AQ | AP | AQ | SP | SQ | SP | ||||||||||||||||
|
|
|
|||||||||||||||||||
Direct Materials Price Variance | Direct Materials Quantity Variance | ||||||||||||||||||||
Total Direct Materials Cost Variance | |||||||||||||||||||||
Direct Labor Cost Variances | |||||||||||||||||||||
AH | AR | AH | SR | SH | SR | ||||||||||||||||
|
|
|
|||||||||||||||||||
Direct Labor Rate Variance | Direct Labor Time Variance | ||||||||||||||||||||
Total Direct Labor Cost Variance | |||||||||||||||||||||
Analysis of Materials Variances: | |||||||||||||||||||||
Analysis of Labor Variances: | |||||||||||||||||||||
Standard Price (SP) | 12 | Standard Rate (SR) | 26 |
Actual Price (AP) | 12.30769 | Actual Rate (AR) | 26.15385 |
Standard Quantity (SQ) | 8 | Standard Hour (SH) | 4 |
Actual Quantity (AQ) | 7.878788 | Actual Hour (AH) | 3.939394 |
Direct Material Variance | |||
Material Price Variance | (SP - AP)X AQ | = | -2.42424242 |
Material Quantity/Usage Variance | (SQ - AQ) X SP | = | 1.454545455 |
Total Material Cost Variance | (AQ X AP) – (SQ X SP) | = | 0.96969697 |
Direct Labor Variance | |||
Labor Rate Variance | (SR – AR) X AH | = | -0.60606061 |
Labor Efficiency Variance | (SH – AH) X SR | = | 1.575757576 |
Total Labor Cost Variance | (AH x AR) – (SH x SR) | = | -0.96969697 |
Analysis,
Material variance, the slight increase in price is compensated by decrease in quantity used , hence resulting in a small unfavorable variance of 0.96
Labor Variance, the slight increase in rate is compensated by decrease in hours utilized used , hence resulting in a small favorable variance of 0.96
If we combine material and labor variance, it comes to be zero
Problem 5 - Materials and Labor Manufacturing Variances and Analysis Background: The following information is for...
Exercise 21-15 Direct materials and direct labor variances LO P2 The following information describes production activities of Mercer Manufacturing for the year. Actual direct materials used Actual direct labor used Actual units produced 27,000 lbs. at $4.75 per lb. 8,600 hours for a total of $172,860 51,000 Budgeted standards for each unit produced are 0.50 pounds of direct material at $4.70 per pound and 10 minutes of direct labor at $21.00 per hour. AQ = Actual Quantity SQ = Standard...
The following information describes production activities of Mercer Manufacturing for the year. Actual direct materials used 22,000 lbs. at $4.35 per lb. 6,575 hours for a total of Actual direct labor used $128,870 Actual units produced 36,000 Budgeted standards for each unit produced are 0.50 pounds of direct material at $4.30 per pound and 10 minutes of direct labor at $20.60 per hour. AQ = Actual Quantity SQ = Standard Quantity AP = Actual Price SP = Standard Price AH...
The following information desaribes production activities of Mercer Manufacturing for the year: Actual direct materials Actual direct labor used Actual units produced 29,000 lbs. at S5.10 per lb. 8,100 hours for a total of $164,430 48,000 Budgeted standards for each unit produced are 0.50 pounds of direct material at S5.05 per pound and 10 minutes of direct labor at S22.00 per hour (1) Compute the direct materials price and quantity variances. (Do not round intermediate calculations.) Actual Cost Standard Cost...
The following information describes production activities of Mercer Manufacturing for the year. Actual direct materials used 24,000 lbs. at $4.45 per lb. Actual direct labor used 6,505 hours for a total of $128,799 Actual units produced 36,030 AH = Actual Hours SH = Standard Hours AR = Actual Rate SR = Standard Rate AQ = Actual Quantity SQ = Standard Quantity AP = Actual Price SP = Standard Price Budgeted standards for each unit produced are 0.50 pounds of direct...
The following describes production activities of Mercer Manufacturing for the year. Actual direct materials used Actual direct labor used Actual units produced 31,000 lbs. at $5.80 per lb. 10,600 hours for a total of $217,300 63,000 1,600 hour. 29.9 5. IS DE $217,300 Budgeted standards for each unit produced are 0.50 pound of direct material at $5.75 per pound and 10 minutes of direct labor at $21.50 per hour. AH = Actual Hours SH = Standard Hours AR = Actual...
The following Information describos production activitles of Prichard Manufacturing Company for the year Actual direct materials used Actual direct labor used Actual units produced 380.000 1bs. for a total of $779,000 63,000 hours for a total of $s07.150 128,800 Budgoted standards for each unit produced are 3 pounds of direct material at $200 per pound and 0.5 hours of direct labor at $8.00 per hour AQ Actual Quantity SQ-Standard Quantity AP Actual Price SP-Standard Price AH=Actual Hours SH Standard Hours...
Check my work Exercise 21-15 Direct materials and direct labor variances LO P2 The following information describes production activities of Mercer Manufacturing for the year. points Skipped Actual direct materials used 25,000 lbs. at $4.60 per lb. Actual direct labor used 6,050 hours for a total of $120,395 Actual units produced 36,000 eBook Hint Print Budgeted standards for each unit produced are 0.50 pounds of direct material at $4.55 per pound and 10 minutes of direct labor at $20.90 per...
The following information describes production activities of Mercer Manufacturing for the year Actual direct materials used 22,880 lbs. at $4.35 per lb. 6,575 hours for a total of Actual direct labor used $128,870 Actual units produced 36,000 Budgeted standards for each unit produced are 0.50 pounds of direct material at $4.30 per pound and 10 minutes of direct laborat $20.60 per hour AQ = Actual Quantity SQ = Standard Quantity AP - Actual Pnce SP = Standard Price AH =...
Hutto Corp. has set the following standard direct materials and direct labor costs per unit for the product it manufactures. Direct materials (15 lbs. @ $4 per lb.) Direct labor (3 hrs. @ $15 per hr.) $60 45 During May the company incurred the following actual costs to produce 9,000 units. Direct materials (138,000 lbs. @ $3.75 per lb.) Direct labor (31,000 hrs. @ $15.10 per hr.). $517,500 468, 100 AH = Actual Hours SH = Standard Hours AR =...
1. Compute the direct material, direct labor and variable overhead variances. S 5 ? - X X] H FILE Basic variance analysis for direct materials, direct labor and variable overhead - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME Sign In * Calibri Calibri 111 A A = % V ö Paste B I U - A ont Number Conditional Format as Cell Alignment Number Formatting Table Styles - Cells Editing Clipboard B Font x Styles 41 : fc...