Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing Assurance And Advisory Services

Authors: Kurt R. Reding, Paul J. Sobel, Urton L. Anderson, Michael J. Head, Sridhar Ramamoorti, Mark Salamasick, Cris Riddle

3rd Edition

0894137409, 978-0894137402

More Books

Students also viewed these Accounting questions

Question

What is the difference between absolute and relative pay?

Answered: 1 week ago