Question
What must I do mathematically to figure out what the actual hours for the actual fixed manufacturing overhead cost? I believe the Standard hours (direct
What must I do mathematically to figure out what the actual hours for the actual fixed manufacturing overhead cost? I believe the Standard hours (direct labor hours, standard hours of direct labor) for Standard variable manufacturing overhead costs is 74,000 hours, correct?
Actual Hours at Standard Rate = AH SR is also called Same Budgeted Lump Sum (as in Static Budget) Regardless of Output Level.
Standard Variable Overhead Costs (Flexible Budget) is also called Flexible Budget: Same Budgeted Lump Sum (as in Static Budget) Regardless of Output Level.
What is the true identification and/or name for (Actual Input Quantity Budgeted Rate)?
All the information you need is above.
The Quick Bread Company bakes baguettes for distribution to upscale grocery stores. The company has two direct-cost categories: direct materials and direct manufacturing labor. Variable manufacturing overhead is allocated to products on the basis of standard direct manufacturing labor-hours. (Click the icon to (Click the icon to view the budget data for 2017.) view the additional data for 2017.) i Data Table Direct manufacturing labor use 0.02 hours per baguette Variable manufacturing overhead $10.00 per direct manufacturing labor-hour i Data Table Planned (budgeted) output 3,700,000 baguettes Actual production 3,000,000 baguettes Direct manufacturing labor 54,500 hours Actual variable manufacturing overhead $713,950 Read the requirements. 1 Requirements 1. Prepare a variance analysis of fixed manufacturing overhead cost. 2. Is fixed overhead underallocated or overallocated? By what amount? 3. Comment on your results. Discuss the variances and explain what may be driving them. 1 The Quick Bread Company also allocates fixed manufacturing overhead to products on the basis of standard direct manufacturing labor-hours. For 2017, fixed manufacturing overhead was budgeted at $3.00 per direct manufacturing labor-hour. Actual fixed manufacturing overhead incurred during the year was $288,000 *$3.00 is the Budgeted (Planned) fixed"manufacturing overhead-cost per direct manufacturing-labor-hour. I *$288.000-is the-Actual fixed manufacturing overhead cost-incurred during the year. 1 Requirement 1. Prepare a variance analysis of fixed manufacturing overhead cost. Begin by completing the table below for the fixed manufacturing overhead that will be used to calculate the variances. *$288.000 is the Actual-fixed manufacturing overhead-cost incurred during the year. I Same Budgeted Lump Sum Actual Costs Regardless of Incurred Output Level $ 288,000 $ 222,000 $ Flexible Budget 222,000 $ Allocated Overhead 180,000 Fixed MOH Well done! 4-Variance Analysis Fixed MOH Spending Variance 66,000 U Efficiency Variance Production-Volume Variance 42,000 U N Nice work! Requirement 2. Is fixed overhead underallocated or overallocated? By what amount? Fixed manufacturing overhead is underallocated by $ 108,000 Excellent! Requirement 3. Comment on your results. Discuss the variances and explain what may be driving them. The production-volume variance captures the difference between the number of budgeted baguettes and the actual number of baguettes produced. Quick Bread Company's spending variance means that the actual aggregate of fixed costs exceeds the budget amount. For example, monthly leasing rates for baguette-making machines may have increased above those in the budget. Good job! Requirement 1. Prepare a variance analysis of fixed manufacturing overhead cost. Begin by completing the table below for the fixed manufacturing overhead that will be used to calculate the variances. Before we can prepare a variance analysis, we need to first-calculate-some-key (important). amounts that are used in the calculations. --The first amount we will calculate is the fixed. overhead-flexible budget amount. Recall the flexible-budget uses budgeted costs at the budgeted-input-quantity allowed for actual output. Be sure to calculate the budgeted: (planned)-directlabor-hours by multiplying the budgeted number of units by the budgeted (planned) direct manufacturing-labor-hours per unit (=3,700,000 number of baguettes-x-0.02- hours per baguette) Budgeted (Planned)-labor-hours-Formula = Total number of a product-x-Total number of hours per product = Budgeted (Planned)-labor-hours 1 *3.700.000 is Budgeted (Planned) total number of baguettes. I *0.02 hours per baguette. 1 = 3.700,000-Budgeted (Planned) total number of baguettes to produce-X-0.02-hours per baguette =-74.000 Budgeted-(Planned)-labor-hours Flexible-Budget Formula =-Budgeted (Planned)-labor-hours-x-Budgeted (Planned) -allocation base unit 1 = Flexible-Budgetf =-74,000-Budgeted (Planned)-labor-hours-x-$3.00-Budgeted (Planned)-labor-hours rate per direct manufacturing labor-hour =-$222.0001 1 $222,000 is the Flexible-Budget. I Now calculate the allocated overhead using the following formula. 1 Allocated manufacturing overhead cost-(manufacturing overhead)-Formula 1 =-Budgeted-fixed-overhead-x-Budgeted-labor-hours-x #of products Rate per unit+ per product + + actually produced (completed) =Budgeted-fixed-overhead-x-Budgeted-labor-hours-> #of baguettes Rate per unit+ per baguette + actually produced (completed) =-Allocated manufacturing overhead-cost (Allocated overhead) = $3.00-x-0.02-x-3,000,000-Actual total number of baguettes produced (completed) =-0.06-3.000.000-Actual total number of baguettes produced (completed) = $180,0009 V$180,000 is the Allocated total fixed manufacturing-overhead cost.I Finish completing the table for the fixed manufacturing overhead amounts. Recall that the amount in columns 2 and 3 are the same value, budgeted fixed manufacturing overhead costs. *$288.000 is the Actual fixed manufacturing overhead cost incurred during the year. [Financial information from the Word Problem.] $222,000 -is the Flexible:Budget. $180,000 is the Allocated-total-fixed manufacturing-overhead cost. I Actual Costs incurreda Same Budgeted Flexible Allocated Lump Sum (as Budget:--Same Manufacturing in Static Budgeted overhead cost: Budget) Lump Sum (as Budgeted Input: Regardless of in Static Quantity Allowed Output:Levela Budget) for Actual Regardless of Output:x: Output:Levela Budgeted Ratea $222,0000 $222,0000 $180,0000 $288.0000 Fixed Manufacturing overhead costo Actual Hours'at Standard Rate=AH X-SR-is also called Same Budgeted LumpSum (as in StaticBudget) -Regardless of Output:Level. The next step is to complete the 4-variance analysis using the amounts you calculated above. Use the following guide to assist you in selecting the correct variance for each category. (Click to view the information.) When all overhead variances are presented together it is called a 4-variance analysis. 4-variance analysis using the amounts you calculated above. i Reference The difference between columns 1 and 2 measures the spending variance. The difference between columns 2 and 3 measures the efficiency variance (if applicable). The difference between columns 3 and 4 measures the production-volume variance (if applicable) Each overhead category will have 2 variances, which is why we call it a 4-variance analysis, but the 4-variance analysis table has three types of variances. That means that for each category of overhead, one of the variances will never occur. Why? 1 Variable overhead does not have a production-volume variance because the amount of variable overhead allocated is always the same as the flexible-budget amount. Variable costs never have any unused capacity. If the production volume decreases the variable overhead decrease. Fixed overhead has no efficiency variance because a lump-sum amount of fixed costs will be unaffected by the degree of operating efficiency in a given budget period. Use the following columnar presentation to assist in the calculation of the variances. Actual Costs incurreda Same:Budgeted Flexible Allocated Fixed Lump-Sum (as Budget: Same Manufacturing in Static Budgeted overhead cost: Budget) Lump Sum (as Budgeted Input: Regardless of in Static Quantity Allowed Output:Levela Budget) for Actual Regardless of Output:x: Output:Levela Budgeted Rated $222,0000 $222,0000 $180,0000 $288,0000 Fixed Manufacturing overhead costo Spending Variance Production volume variance Actual Hours at Standard-Rate=-AH--SR is also called-Same-Budgeted Lump-Sum (as in: Static-Budget).Regardless of-OutputLevel. 1 Now complete the 4-variance analysis using the discussion above. Remember, when dealing with costs a favorable variance occurs when your actual costs are less than budgeted costs. An unfavorable variance occurs when actual costs are more than budgeted costs. Spending Variance Formula =-Actual Costs incurred ---Same Budgeted-Lump Sum (as in-Static Budget) Regardless of Output- Level 1 =-Spending Variance 1 =-$288,000-$222,000 1 = $66,0001 V$66,000 is the Spending Variance. 1 Because-$288.000, the Actual total fixed manufacturing overhead-cost (expense) incurred, is larger than $222,000, the flexible budgeted total-fixed manufacturing cost (budgeted cost), there is an unfavorable fixed manufacturing-overhead (fixed overhead) spending variance. 1 The variance is unfavorable because the $288,000, the-Actual total fixed manufacturing overhead cost-(expense), is-larger than the flexible-budgeted total fixed manufacturing cost of $222,000,-or- the total fixed manufacturing cost-of-$222,000 budgeted-for-2-2017, which decreases that month's operating income by $66,000.1 The fixed-overhead spending variance is unfavorable because the plant-leasing costs, depreciation costs on plant and equipment, administrative costs, such as salary paid to the plant- manager was-larger than budgeted-(planned). I Reasons for the unfavorable spending variance could be higher plant-leasing costs, higher depreciation on plant and equipment, or higher administrative costs, such as a higher-than- budgeted salary paid to the plant manager. Webb investigated this variance and found that Efficiency Variance Formular 1 =-Same-Budgeted-Lump-Sum (as in Static Budget) Regardless of Output Level - Flexible Budget = Efficiency-Variance =-$222,000-$222,0001 1 =-SOT 1 Because-$222,000, the Lump Sum-Regardless of Output:Level, is equal to-$222,000, the- Flexible:Budget, there is never a variance. Production-Volume Variance Formula 1 =-Flexible Budget: --Same Budgeted:Lump-Sum (as-in-Static Budget) Regardless of Output Level: -Total-allocated-fixed manufacturing overhead cost 1 = Production-Volume-Variance =-$222,000-$180,0001 1 = $42,0001 V $42.000 is the Production-Volume-Variance. Because-$222,000, the flexible budgeted total-fixed manufacturing cost, is-larger than $180,000,- the total fixed manufacturing overhead-cost-allocated on the basis (foundation) of actual baguettes, the output (product), produced (completed), there is an unfavorable production- volume variance, also called denominator-level variance. I 1 The production-volume variance, also referred to as the denominator-level variance, is the difference between the budgeted and allocated fixed overhead amounts. Note that the allocated overhead can be expressed in terms of allocation-base units (machine-hours for Webb) or in terms of the budgeted fixed cost per unit: 4-Variance Analysisa Spending Varianced Efficiency Varianced Production-Volume o Variancea Fixed Manufacturing: 566,000 UO SO-Never a variance $42.000-UO overhead costos . 1 Requirement 2. Is fixed overhead underallocated or overallocated? By what amount? 1 The variances represent the under-or overallocated overhead. If we had unfavorable variances that means our overhead was underallocated, since our budgeted overhead was less than our actual overhead. If we have favorable variances that means our overhead was overallocated, since our budgeted overhead was greater than our actual overhead. Review the overhead costs Referenced Actual.Cost: incurreda Same Budgeted Flexible Allocated Fixed Lump Sum (as Budget:--Same Manufacturing in-Static Budgeted overhead cost: Budget) Lump-Sum (as Budgeted Input Regardless of in Static Quantity Allowed Output:Levela Budget) for Actual Regardless of Output X. Output:Levela Budgeted-Ratea $222,0000 $222,0000 $180,0000 $288,0000 Fixed Manufacturing overhead costo The difference between columns 1 and 4 measures the total fixed manufacturing overhead variance. What is Brown Bread Company's total fixed manufacturing overhead variance? Has the company overallocated or underallocated? 4-Variance Analysisa Spending Varianced Efficiency.Varianced Production-Volume Variancea Fixed-Manufacturing $66,000 UO Never a variance $42.000-U overhead costo =-S66,000 U-+-$42,000-UT 1 =-$108,0001 1 $108,000 is the total fixed manufacturing overhead cost, and the total fixed manufacturing overhead-cost (or fixed manufacturing overhead, fixed manufacturing overhead-cost) is underallocated by $108,000. Actual Costs incurreda Actual Input Quantity-x. Budgeted:Ratea Flexible Allocated Budget:-Same Variable Budgeted Manufacturing Lump-Sum (as overhead cost: in Static Budgeted Input Budget): Quantity Allowed Regardless of for Actual Output:Levela Outputx: Budgeted-Ratea $14,7200 $14,7200 $10,7170 $10,3040 Variable Manufacturing overhead costo Spending Variance Efficiency variance Never a varianceStep 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