Answered step by step
Verified Expert Solution
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
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,750Step 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