Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE HELP ME WITH TICKLERS! b. Which of the variances shown would be of most concern to management for immediate attention? (Consider groups of variances
PLEASE HELP ME WITH TICKLERS!
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. TICKLERS (optional) 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. Material PRIMEVAR PRIMEVAR Material and Labor Variances Data Section 7 Materials price variance input Actual cost of material per pound (ounce, etc.) Standard cost of mat. per pound (ounce, etc.) $15.90 $16.00 9 39,500 38,000 11 Materials quantity variance input 12 Actual quantity of materials used Standard quantity of mat. used for actual output 14 15 Labor rate variance input 16 Actual cost of labor per hour 17 Standard cost of labor per hour 18 19 Labor efficiency variance input Actual quantity of hours incurred Standard quantity of hours for actual output $8.05 $8.00 44,000 45,600 Answer Section For U 26 Material price variance 27 Material quantity variance ($3,950) 24,000 28 29 Total materials variance $20,050 31 Labor rate variance 32 Labor efficiency variance $2,200 (12,800) (10,600) F 34 Total labor variance 35 36 Total materials and labor variances $9,450.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started