Question

Complete the essay and quantitative problems below. Staple your answers to the back of your exam. All essay components should

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Complete the essay and quantitative problems below. Staple your answers to the back of your exam....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT