Excel Applications for Accounting Principles

Business

Quiz 24 :

Material and Labor Variances Primevar

Quiz 24 :

Material and Labor Variances Primevar

Question Type
search
arrow
PROBLEM DATA McGrade Industries manufactures a product whose standard direct materials and direct labor unit costs are as follows: img REQUIREMENT What is the total actual cost of October's production Based on the standards, what should it have cost Compute the total difference (variance) between these two amounts. img
Free
Essay
Answer:

Answer:

Review the worksheet indicated in the problem. Review the problem data. Based on the data, calculate the actual cost, standard cost, and the difference for direct materials and direct labor. To do this, you will need to multiply standard rates for materials and labor by the actual number of units produced.
Once you have made all the calculations, you should have this information:
img

Tags
arrow
PROBLEM DATA McGrade Industries manufactures a product whose standard direct materials and direct labor unit costs are as follows: img REQUIREMENT The president of McGrade Industries wants an analysis prepared to help explain why the variances computed in requirement 1 occurred. Using the worksheet called PRIMEVAR that follows these requirements, calculate the material and labor variances for McGrade Industries. The problem requires you to enter the input in the Data Section as well as formulas in the Answer Section.
Free
Essay
Answer:

Answer:

Review the worksheet indicated. Input your data where indicated in the worksheet using your calculations from the given data. When you finish the data section, your worksheet should look like this:
img

Tags
arrow
PROBLEM DATA McGrade Industries manufactures a product whose standard direct materials and direct labor unit costs are as follows: img REQUIREMENT Open the file PRIMEVAR from the website for this book at cengagebrain.com. Enter the input values or formulas to compute the input values. Then enter the formulas where indicated on the worksheet. As a hint, FORMULA1 can be written as =(D8-D9)*D12. Formulas 8-10 should enter an F if the variance is favorable and a U if it is unfavorable. See the discussion of the =IF function in Appendix A of Excel Quick. Enter your name in cell A1. Save the completed file as PRIMEVAR3. Print the worksheet when done. Also print your formulas. Check figure: Material quantity variance (cell B27), $24,000 U.
Free
Essay
Answer:

Answer:

Open the file indicated in the instructions. Input the information from the worksheet into the data section of the file. In the answers section of the file, enter the formulas to calculate the materials and labor variance for this product using cell references so that the file will automatically update if any data is changed. Use the IF formula to indicate an "F" for a favorable variance and an "U" for unfavorable variance. A positive number is indicative as an unfavorable variance while a negative number indicates a favorable variance.
When you have finished both the data and answers section, your file should look like this:
img

Tags
arrow
WHAT-IF ANALYSIS The worksheet you have developed will handle most simple variance analysis problems. Try the problem below for Pscheidl, Inc.: img Actual production for October was 11,500 units. Compute the direct materials and direct labor variances for Pscheidl, Inc. Be careful when entering your input because this problem presents the information in a different format from the McGrade Industries' data. Save the file as PRIMEVAR4. Print the worksheet when done.
Essay
Answer:
Tags
arrow
CHART ANALYSIS 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.
Essay
Answer:
Tags