Question

In: Accounting

You are given the following information for the May overhead expenses as follows:     Budgeted output...

  1. You are given the following information for the May overhead expenses as follows:

    Budgeted output quantity                                        12,800

    Budgeted fixed manufacturing overhead          $80,000

    Budgeted variable manufacturing overhead      $20/direct labor hour

    Budgeted direct manufacturing labor hours       8 hours/unit

    Fixed manufacturing costs incurred                 $104,000

    Direct manufacturing labor hours used                28,800

    Variable manufacturing costs incurred            $142,400

    Actual quantity manufactured                               13,600   

a.    Compute a 4-variance analysis

b.    Compute a 3-variance analysis

c.     Compute a 2-variance analysis

d.    Compute the flexible-budget variance.

Solutions

Expert Solution

(a) 4-variance analysis:

  • Variable overhead spending variance = $142,400 - (28,800 x $20) = $433,600 favorable
  • Variable overhead efficiency variance = $20 x [28,800 - (13,600 x 8)] = $1,600,000 favorable
  • Fixed overhead spending variance = $104,000 - $80,000 = $24,000 unfavorable
  • Fixed overhead production-volume variance = $80,000 - (13,600 x 8 x $0.78125*) = $5,000 favorable

*$80,000/(12,800 units x 8 hours) = $0.78125

(b) 3-variance analysis:

  • Spending variance = $433,600 favorable + $24,000 unfavorable = $409,600 favorable
  • Efficiency variance = $1,600,000 favorable
  • Production-volume variance = $5,000 favorable

(c) 2-variance analysis:

  • Flexible-budget variance = $433,600 favorable + $1,600,000 favorable + $24,000 unfavorable = $2,009,600 favorable
  • Production-volume variance = $1,250 favorable

(d) Flexible-budget variance:

Actual Flexible Budget Variance
Fixed overhead $ 104,000 $ 85,000 $ 19,000 Unfavorable
Variable overhead $ 142,400 $ 2,176,000 $ 2,033,600 Favorable
Flexible-budget variance $ 2,014,600 Favorable

Related Solutions

The following data are given for product DRIM69 Budgeted output for the year:        9800 units Standard...
The following data are given for product DRIM69 Budgeted output for the year:        9800 units Standard details for one unit: Direct materials:                               40 square metres at K5.30 per square metre Direct wages: Bonding department                                   48 hours at K12.50 per hour Finishing department                                  30 hours at K7.60 per hour Budgeted costs and hours per annum: Variable overhead:                                      (K)                                           (hours) Bonding department                                   375000                                   500000 Finishing department                                  150000                                   300000 Fixed overhead:                                           (K)                              ...
The following information is budgeted for Plumbing Limited for next quarter: April ($) May ($) June...
The following information is budgeted for Plumbing Limited for next quarter: April ($) May ($) June ($) Sales 110,000 130,000 180,000 Merchandise purchases 85,000 92,000 105,000 Selling and administrative expenses 50,000 50,000 50,000 All sales at the company are on credit: 40% are collected in the month of sale, 58% in the month following the sale, and the remaining 2% are uncollectible. Merchandise purchases are paid in full the month following the month of purchase. The selling and administrative expenses...
M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000...
M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000 $45,000 $55,000 •        Cost of goods sold is 50% of sales. Accounts payable is used only for inventory acquisitions. •        M&H purchases and pays for merchandise 50% in the month of acquisition and 50% in the following month. •        Selling and administrative expenses are budgeted at $30,000 for May and are expected to increase 2% per month. They are paid during the month of...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows:...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows: Division A B C D Sales $504,000 $948,000 $960,000 $1,240,000 Cost of goods sold 440,000 930,000 765,000 925,000 Selling & admin costs 96,000 202,500 144,000 210,000 Operating income (loss) $(32,000) $(184,500) $51,000 $105,000 Further analysis of costs reveals the following percentages of variable costs in each division: A B C D Cost of goods sold 90% 80% 90% 85% Selling & admin costs 50%...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows:...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows: Division A B C D Sales $504,000 $948,000 $960,000 $1,240,000 Cost of goods sold 440,000 930,000 765,000      925,000 Selling & admin costs 96,000 202,500 144,000      210,000 Operating income (loss) $(32,000) $(184,500) $51,000    $105,000 Further analysis of costs reveals the following percentages of variable costs in each division: A B C D Cost of goods sold 90% 80% 90% 85% Selling &...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows:...
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows: Division A B C D Sales $504,000 $948,000 $960,000 $1,240,000 Cost of goods sold 440,000 930,000 765,000      925,000 Selling & admin costs 96,000 202,500 144,000      210,000 Operating income (loss) $(32,000) $(184,500) $51,000    $105,000 Further analysis of costs reveals the following percentages of variable costs in each division: A B C D Cost of goods sold 90% 80% 90% 85% Selling &...
Brownsville Novelty Store prepared the following budget information for the month of May: Sales are budgeted...
Brownsville Novelty Store prepared the following budget information for the month of May: Sales are budgeted at $381,000. All sales are on account and a provision for bad debts is made for each month at three percent of sales for the month. Inventory was $104,000 on April 30; an inventory increase of $16,000 is planned for May 31. All inventory is marked to sell at cost plus 50 percent. Estimated cash disbursements for selling and administrative expenses for the month...
Widmer Watercraft’s predetermined overhead rate is 200% of direct labor. Information on the company’s production activities during May follows.
Widmer Watercraft’s predetermined overhead rate is 200% of direct labor. Information on the company’s production activities during May follows. Purchased raw materials on credit, $240,000. Materials requisitions record use of the following materials for the month.         Job 136 $ 49,500   Job 137   32,000   Job 138   19,600   Job 139   22,600   Job 140   7,000   Total direct materials   130,700   Indirect materials   21,000   Total materials used $...
Widmer Watercraft’s predetermined overhead rate is 200% of direct labor. Information on the company’s production activities during May follows.
Widmer Watercraft’s predetermined overhead rate is 200% of direct labor. Information on the company’s production activities during May follows. Purchased raw materials on credit, $200,000. Materials requisitions record use of the following materials for the month.         Job 136 $ 50,000   Job 137   33,000   Job 138   20,000   Job 139   23,200   Job 140   6,600   Total direct materials   132,800   Indirect materials   19,500   Total materials used $...
The following budgeted information is available:                                         ...
The following budgeted information is available:                                                         X-Rays   Ultrasound   CT Scan   MRI   Total       Technician Labour   $61,440   $105,600   $96,000   $105,000   $368,040       Depreciation   $32,240   $268,000   $439,000   $897,500   $1,636,740       Materials   $22,080   $16,500   $24,000   $31,250   $93,830       Administration                   $20,610       Maintenance                   $247,320       Sanitation                   $196,180       Utilities                   $134,350       Totals   $115,760   $390,100  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT