None Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the followingdata from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during theperiod was used in production.Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e.,zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places.Standard price or rate per unit of inputStandard quantity per unit of outputActual quantity used per unit of outputActual price or rate per unit of inputActual outputDirect-material price varianceDirect-material quantity varianceTotal direct-material varianceDirect-labor rate varianceDirect LaborDirect Materialper hour$14.00 per poundhours per unitpounds per unit2.50 hourspounds per unit$18.00 per hour$13.00 per pound8,500 units8,500 units$60,500 F$39,500 FDirect-labor efficiency varianceTotal direct-labor varianceSASA$72,250 F$51,000 F

Answered: Image /qna-images/answer/0d4ae3c8-70a1-48d1-b266-0d8f5b3d8945.jpg

Answered: Part of your company's accounting…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter24: Material And Labor Variances (primevar)

Section: Chapter Questions

Problem 5R: Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical...

See similar textbooks

Similar questions

Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places. Direct Labor Direct Material bok Standard price or rate per unit of input per hour $ 7.00 per pound Standard quantity per unit of output hours per unit pounds per unit Actual quantity used per unit of output 1.80 hours pounds per unit int Actual price or rate per unit of input $ 11.00 per hour $ 6.00 per pound rences Actual output Direct-material price variance Direct-material quantity variance 5,000 units 5,000 units $ 34,000 F $ 14,000 U Total direct-material variance $ 20,000 F…
Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e. zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places. Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output Actual price or rate per unit of input Actual output Direct-material price variance Direct-material quantity variance Total direct-material variance Direct-labor rate variance Direct-labor efficiency variance Total direct-labor variance $ $ $ Direct Labor per hour hours per unit 3.50 hours 21.00 per hour 5,500 units 30,000 F 10,750 F $ $ $ $ Direct Material 8.00 per pound…
Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical representation of the variances computed in requirement 3. Review the chart and answer the following questions: a. Which variances does each bar represent? A __________ B __________ C __________ D __________ b. Which of the variances shown would be of most concern to management for immediate attention? (Consider groups of variances and materiality also.) Explain. When the assignment is complete, close the file without saving it again. Worksheet. McGrade Industries also has the following information regarding overhead for October: actual overhead 375,000, standard variable overhead of 3 per direct labor hour, and standard fixed overhead of 5 per direct labor hour (based on 47,000 hours budgeted). Modify the PRIMEVAR3 worksheet to compute all appropriate overhead variances. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRIMEVART. Hint: Insert several new rows in the Data Section and in the Answer Section. Chart. Using the PRIMEVAR3 file, prepare a 3-D stacked bar chart to compare total standard cost per unit with actual cost per unit. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. You do not need to use cell references when completing the table. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as PRIMEVAR3. Print the chart.
Performance Eval Variances: Refer to the pictures. One has the information and the second has the template. Thank you!
Managers who properly apply the concept called “management by exception” will: * Investigate only favorable variances. Investigate only unfavorable variances. Investigate only variances of a certain size or scope. Always investigate unfavorable and favorable variances regardless of size.
Analyze the variances that you computed in requirements 1 and 2. Was the new service a success from an overall cost-control perspective? Briefly discuss. What seems to have happened that would give rise to customer complaints?
Performance Eval Variances: Refer to the pictures. Thank you! One picture has the info and the second picture has the template.
Gauging the Favorableness of Variances When variances occur, they are described as being either favorable or unfavorable. When actual activity consumes more time or money than initially planned, an unfavorable variance exists. However, when actual activity consumes less time or money than initially planned, a favorable variance exists. Note that the terms favorable and unfavorable are used, rather than saying that a variance is good or bad, because until the cause of a variance is discovered, it is not clear whether a variance is either good or bad. Note: Use the minus sign to indicate negative values (when the budgeted amount is greater than the actual). If a company calculates that the actual cost for materials used was $4,800,000, and the amount budgeted for those materials was $3,400,000, the actual cost for materials used less the budgeted cost for materials used is $ This tells you that the actual cost at actual materials used is greater than -v the budgeted cost at actual hours…
What characteristics of the variance pattern shown in the report should draw the controller’s attention, regardless of the usual investigation rule? Which of the following is the best reason to also follow up on favorable variances? Bias in investigation targets and subsequent reports is reduced. Favorable variances occur more often as activity levels rise. Production efficiencies may be able to be replicated elsewhere in the organization.
Gauging the Favorableness of Variances When variances occur, they are described as being either favorable or unfavorable. When actual activity consumes more time or money than initially planned, an unfavorable variance exists. However, when actual activity consumes less time or money than initially planned, a favorable variance exists. Note that the terms favorable and unfavorable are used, rather than saying that a variance is good or bad, because until the cause of a variance is discovered, it is not clear whether a variance is either good or bad. Note: Use the minus sign to indicate negative values (when the budgeted amount is greater than the actual). If a company calculates that the actual cost for the actual hours worked by employees was $4,300,000, and the amount budgeted for those hours actually worked was $4,800,000, the actual cost for hours worked less the budgeted cost for hours worked is $ 500,000 x. This tells you that the actual cost at actual hours worked is less than…
Gauging the Favorableness of Variances When variances occur, they are described as being either favorable or unfavorable. When actual activity consumes more time or money than initially planned, an unfavorable variance exists. However, when actual activity consumes less time or money than initially planned, a favorable variance exists. Note that the terms favorable and unfavorable are used, rather than saying that a variance is good or bad, because until the cause of a variance is discovered, it is not clear whether a variance is either good or bad. Note: Use the minus sign to indicate negative values (when the budgeted amount is greater than the actual). If a company calculates that the actual cost for the actual hours worked by employees was $4,300,000, and the amount budgeted for those hours actually worked was $4,800,000, the actual cost for hours worked less the budgeted cost for hours worked is $ This tells you that the actual cost at actual hours worked is less than - v the…
By comparing the actual findings with the standards and adopting new standards to avoid or reduce deviations, standard cost variance analysis makes it simple for management to evaluate performance against the benchmark. Focusing on the efficiency of the standard cost system and applying any modifications and updates promptly can help to minimize these effects and produce more accurate results when compared to actual data. Do you believe that the standard cost system can help erase these effects completely?

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS