Let Us Simplify the given information and calculate the variances
Given Info | State St | Dewey Ave | Mr. Hope Ave |
Expected Installation | 15,000 | 22,500 | 10,000 |
Actual Installations | 14,500 | 22,250 | 11,500 |
Material Cost | 710,500 | 1,346,125 | 759,000 |
Direct Labor Hours | 11,600 | 21,138 | 12,650 |
Actual Labor Rate | 11 | 12 | 13 |
Standards | State St | Dewey Ave | Mr. Hope Ave |
Expected Installation | 15,000 | 22,500 | 10,000 |
Material Cost | 900,000 | 1,350,000 | 600,000 |
Direct Labor Hours | 15,000 | 22,500 | 10,000 |
Standard Labor Cost | 177,000 | 265,500 | 118,000 |
Actual | State St | Dewey Ave | Mr. Hope Ave |
Actual Installation | 14,500 | 22,250 | 11,500 |
Material Cost | 710,500 | 1,346,125 | 759,000 |
Direct Labor Hours | 11,600 | 21,138 | 12,650 |
Actual Labor Cost | 127,600 | 253,656 | 164,450 |
Using the given information in the problem statement, we have calculated above variances. The formulas to calculate these are as follows
Standards
Expected Installations = Given
Material Cost = Standard Material Cost Per Job X Expected Installations
Direct Labor Hours = Expected Installation X Standard Time Per Installation
Standard Labor Cost = Direct Labor Hours X Standard Cost Per Hour
Actual
Actual Installations = Given
Material Cost = Given
Direct Labor Hours = Given
Actual Labor Cost = Direct Labor Hours X Standard Cost Per Hour
Now let us calculate the variances
There are three type of variances for each material and labor i,e. Rate, Efficiency and Cost. Efficiency variance will not be in Materials as there is only one type of material.
Variances | State St | Dewey Ave | Mr. Hope Ave |
Material Rate Variance ($ per job) | 11.00 | (0.50) | (6.00) |
Material Cost Variance ($) | 189,500.00 | 3,875.00 | (159,000.00) |
Labor Rate Variance ($ per Hour) | 0.80 | (0.20) | (1.20) |
Labor Cost Variance ($) | 49,400.00 | 11,844.00 | (46,450.00) |
Labor Efficiency Variance (Hours) | 3,400.00 | 1,362.00 | (2,650.00) |
Favorable variances are the ones in Positive and Unfavorable variances are the one in the Bracket
Formulas to calculate variances
Material Rate Variance = Standard Rate - (Actual Cost / Actual Installations)
Material Cost Variance = Standard Material Cost - Actual Material Cost
Labor Rate Variance = Standard Rate - Actual Rate
Labor Cost Variance = Standard Labor Cost - Actual Labor Cost
Labor Efficiency Variance = Standard Labor Hours - Actual Labor Hours
Relative Comparisons
State Store has performed efficiently in every avenue they are most high performing store
Dewey Avenue has performed inefficient on the rate front, though they have performed greatly on cost front, their performance is statisfactory
Hope Avenue has not met the set expectations they has under performed in every front.
As per the Analysis report of MBA Intern
He states they they had already accounted for warranty on the laid standards. Hence we will have to deduct the number of installations that were done for the warranty purpose to compare it with that of standards
Standards | State St | Dewey Ave | Mr. Hope Ave |
Expected Installation | 15,000 | 22,500 | 10,000 |
Material Cost | 900,000 | 1,350,000 | 600,000 |
Direct Labour Hours | 15,000 | 22,500 | 10,000 |
Standard Labour Cost | 177,000 | 265,500 | 118,000 |
Actuals | State St | Dewey Ave | Mr. Hope Ave |
Actual Installation | 14,000 | 22,150 | 11,492 |
Material Cost | 710,500 | 1,346,125 | 759,000 |
Direct Labour Hours | 11,600 | 21,138 | 12,650 |
Actual Labour Cost | 127,600 | 253,656 | 164,450 |
Variances | State St | Dewey Ave | Mr. Hope Ave |
Material Rate Variance ($ per job) | 9.25 | (0.77) | (6.05) |
Material Cost Variance ($) | 189,500.00 | 3,875.00 | (159,000.00) |
Labor Rate Variance ($ per Hour) | 0.80 | (0.20) | (1.20) |
Labor Cost Variance ($) | 49,400.00 | 11,844.00 | (46,450.00) |
Labor Efficiency Variance (Hours) | 3,400.00 | 1,362.00 | (2,650.00) |
We can see that the warranty installations has not made much difference in our variances and our analysis and conclusion remains as they have been earlier
Complete the essay and quantitative problems below. Staple your answers to the back of your exam....