You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance).) Standard machine hours per unit of output 4 hours Standard variable-overhead rate per machine 8.00 hour Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fixed overhead Actual fixed overhead Budgeted production in units $ 50,000 25,000 Actual production in units $ 72,000 Unfavorable $ 192,000 Favorable $ 15,000 Unfavorable Variable-overhead spending variance Variable-overhead efficiency variance Fixed-overhead budget variance Fixed-overhead volume variance Total actual overhead $ 713,000 Total budgeted overhead (flexible budget) Total budgeted overhead (static budget) Total applied overhead $ 816,000

You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance).) Standard machine hours per unit of output 4 hours Standard variable-overhead rate per machine 8.00 hour Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fixed overhead Actual fixed overhead Budgeted production in units $ 50,000 25,000 Actual production in units $ 72,000 Unfavorable $ 192,000 Favorable $ 15,000 Unfavorable Variable-overhead spending variance Variable-overhead efficiency variance Fixed-overhead budget variance Fixed-overhead volume variance Total actual overhead $ 713,000 Total budgeted overhead (flexible budget) Total budgeted overhead (static budget) Total applied overhead $ 816,000

Name: Exercise 11-30 Reconstruct Missing Information from Partial Data (LO
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Exercise 11-30 Reconstruct Missing Information from Partial Data (LO 11-2, 11-5)You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you werepreparing. Fortunately, knowing that overhead was

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter24: Material And Labor Variances (primevar)

Section: Chapter Questions

Problem 5R: Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical...

See similar textbooks

Similar questions

You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. (Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the variance by selecting "Positive" or "Negative". Select "None" and enter "O" for no effect (i.e., zero variance).) Standard machine hours per unit of output 3 hours Standard variable-overhead rate per machine hour 10.00 Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fixed overhead Actual fixed overhead Budgeted production in units Actual production in units Variable-overhead spending variance Variable-overhead efficiency variance $ 24,975 18,500 $ 68,600 Unfavorable $ 50,000 Favorable Fixed-overhead budget variance $ 15,000…
You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Note: Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the variance by selecting "Positive" or "Negative". Select "None" and enter "0" for no effect (i.e., zero variance). Standard Machine hours per unit of output 5 hours Standard Variable-overhead rate per machine hour $9 Actual variable-overhead rate per mchine hours ? Actual machine hours per unit of output ? Budgeted fixed overhead $27,500 Actual fixed overhead ? Budgeted production in units 11,000 Actual production in units…
Paragraph 5 1 Normal 1 No Spac... Heading 1 Heading 2 John Fleming, chief administrator for Valley View Hospital, is concerned about the costs for tests in the hospital's lab. Charges for lab tests are consistently higher at Valley View than at other hospitals and have resulted in many complaints. Also, because of strict regulations on amounts reimbursed for lab tests, payments received from insurance companies and governmental units have not been high enough to cover lab costs. Mr. Fleming has asked you to evaluate costs in the hospital's lab for the past month. The following information is available: Two types of tests are performed in the lab-blood tests and smears. During the past month, 1,500 blood tests and 4,400 smears were performed in the lab. Small glass plates are used in both types of tests. During the past month, the hospital purchased 22,000 plates at a cost of $52,800. 3,400 of these plates were unused at the end of the month; no plates were on hand at the beginning of…
please answer all or skip please answer all or leave .If you can't answer all leave it please answer all with all working 1 b. Prepare journal entries to record all activity relating to direct materials for the period. 2. For direct labour. a. Compute the rate and efficiency variances. (Indicate the effect of variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).) 2b . Prepare a journal entry to record the incurrence of direct labour cost for the period. (List debit entries first). Record the incurrence of direct labour cost for the period. Note: Enter debits hefore credits 3. Compute the variable manufacturing overhead spending and efficiency variances. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).) 4. Compute the fixed overhead budget and volume variances. (indicate the effect of variance by selecting "F" for…
You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Note: Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the varlance by selecting "Positive" or "Negative". Select "None" and enter "O" for no effect (l.e., zero varlance). Standard machine hours per unit of output 5 hours Standard variable-overhead rate per machine hour $ 9.00 Actual variable-overhead rate per machine hour Actual machine hours per unit of output Budgeted fixed overhead $ 31,625 Actual fixed overhead Budgeted production in units 11,500 Actual production in units Variable-overhead spending variance $ 34,000 Unfavorable Variable-overhead efficiency variance $ 126,000 Favorable Fixed-overhead budget variance $…
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. 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.
Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places. Direct Labor Direct Material Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output $ 20.00 per hour $ 12.00 per pound 2.68 hours per unit pounds per unit 2.50 hours 4.83 pounds per unit Actual price or rate per unit of input $ 21.00 per hour $ 11.00 per pound Actual output 10,000 units 10,000 units Direct-material price variance $ 52,500 F Direct-material quantity variance $ (18,000) U Total direct-material variance $ 34,500…
Critiquing a Cost Report; Preparing a Performance Report Frank Weston, supervisor of the Freemont Corporation’s matching department, was visibly upset after being reprimanded for his department’s poor performance over the prior month. The department’s cost control report is given below: “I just can’t understand all of these unfavorable variances,” Weston complained to the supervisor of another department. “When the boss called me in, 1 thought he was going to give me a pat on the back because 1 know for a fact that my department worked more efficiently last month than it has ever worked before. Instead, he tore me apart. I thought for a minute that it might be over the supplies that were stolen out of our warehouse last month. But they only amounted to a couple of hundred dollars, and just look at this report. Everything is unfavorable.” Direct labor wages and supplies are variable costs; supervision and depreciation are fixed costs; and maintenance and utilities are mixed costs. The…
Show transcribed image text 15.What activity variances would Adger report with respect to each of its expenses? (Indicate the effect of each variance by selecting F for favorable, U for unfavorable, and None for no effect (i.e., zero variance). Input all amounts as positive values.) [The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers.
Think It Through: Don't "Skirt" the Issue E open You run a fabric store and order materials through a supplier. At the end of the month, you review your materials cost and discover that your direct materials price and quantity variances produced unfavorable results. What could be attributed to these unfavorable outcomes? How would these unfavorable outcomes impact the total direct materials variance?
You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Standard machine hours per unit of output ............................................... 4 hoursStandard variable-overhead rate per machine hour ............................... $8.00Actual variable-overhead rate per machine hour ............................................. bActual machine hours per unit of output ............................................................. dBudgeted fixed overhead .................................................................................... $50,000Actual fixed overhead ..................................................................................................... aBudgeted production in units…
QUESTION 6 Which of the following may be the likely reason for a favorable direct labor rate variance? O overestimated standard labor cost, O changes to the product specification which reduced manufacturing time. O reduction in direct labor costs due to a strike in the factory. O overestimated standard labor time per unit.