Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this question. I'm suppose to enter all that new overhead data under the data and answer section to the excel spreadsheet

image text in transcribed

image text in transcribed

I need help with this question. I'm suppose to enter all that new overhead data under the data and answer section to the excel spreadsheet I made earlier but I'm having trouble finding out what titlesumbers would go in the cells to add that new overhead information.

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. PRIMEVAR Material and Labor Variances Data Section Materials price variance input Actual cost of material per pound (ounce, etc.) Standard cost of mat. per pound (ounce, etc.) $10.50 $10.00 Materials quantity variance input Actual quantity of materials used Standard quantity of mat. used for actual output 13,800 14,375 Labor rate variance input Actual cost of labor per hour Standard cost of labor per hour $5.85 $6.00 Labor efficiency variance input Actual quantity of hours incurred Standard quantity of hours for actual output 46,000 40,250 Answer Section For U Material price variance Material quantity variance $6,900.00 (5,750) Total materials variance $1,150 Labor rate variance Labor efficiency variance ($6,900) 34,500 Total labor variance 27,600 Total materials and labor variances $28,750 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. PRIMEVAR Material and Labor Variances Data Section Materials price variance input Actual cost of material per pound (ounce, etc.) Standard cost of mat. per pound (ounce, etc.) $10.50 $10.00 Materials quantity variance input Actual quantity of materials used Standard quantity of mat. used for actual output 13,800 14,375 Labor rate variance input Actual cost of labor per hour Standard cost of labor per hour $5.85 $6.00 Labor efficiency variance input Actual quantity of hours incurred Standard quantity of hours for actual output 46,000 40,250 Answer Section For U Material price variance Material quantity variance $6,900.00 (5,750) Total materials variance $1,150 Labor rate variance Labor efficiency variance ($6,900) 34,500 Total labor variance 27,600 Total materials and labor variances $28,750

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_2

Step: 3

blur-text-image_3

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

Fraud Examination And Prevention

Authors: W. Steve Albrecht, Chad O. Albrecht

1st Edition

053872689X, 978-0538726894

More Books

Students also viewed these Accounting questions

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago