Explore BrainMass
Share

Explore BrainMass

    Flexible budget analysis (Variance Report)

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. (Hint: It is helpful to solve for the unknowns in the order indicated by the letters in the following table.)

    Standard machine hours per unit of output = 4 hours
    Standard variable overhead rate per machine hour = $8
    Actual variable overhead rate per machine hour = (B)
    Actual machine hours per unit of output = (D)
    Budgeted fixed overhead = $50,000
    Actual fixed overhead = A)
    Budgeted production in units = 25,000
    Actual production in units = (C)
    Variable overhead spending variance = $72,000 (unfavorable)
    Variable overhead efficiency variance = $192,000 (favorable)
    Fixed overhead budget variance = $15,000 (unfavorable)
    Fixed overhead volume variance = (G)
    Total actual overhead = $713,000
    Total budgeted overhead (flexible budget) = (E)
    Total budgeted overhead (static budget) = (F)
    Total applied overhead = $816,000

    Please show intermediate calculations for all missing numbers, thank you.

    © BrainMass Inc. brainmass.com October 9, 2019, 11:09 pm ad1c9bdddf
    https://brainmass.com/business/budgets/missing-numbers-solve-for-the-unknown-flexible-budget-analysis-variance-report-246326

    Solution Preview

    Standard machine hours per unit of output 4 hours
    Standard variable overhead rate per machine hour $8
    Actual variable overhead rate per machine hour $9
    Actual machine hours per unit of output 3 hours
    Budgeted fixed overhead $50,000
    Actual fixed overhead $65,000
    Budgeted production in units 25,000
    Actual production in units 24,000
    Variable overhead spending variance $72,000 (unfavorable)
    Variable overhead efficiency variance $192,000 (favorable)
    Fixed overhead budget variance $15,000 (unfavorable)
    Fixed overhead volume variance $2,000
    Total actual overhead $713,000
    Total budgeted overhead (flexible budget) $818,000
    Total ...

    Solution Summary

    The solution examines flexible budget analysis for a Variance Report.

    $2.19