Question

In: Accounting

The Master (Static) budget for Alex Thomsen, Inc. is presented below. For June, Alex Thomsen, Inc....

  1. The Master (Static) budget for Alex Thomsen, Inc. is presented below. For June, Alex Thomsen, Inc. manufactured and sold 920 units for $835. During this month the company incurred $460,000 total variable expenses and $180,000 total fixed expenses.
    1. Required
      1. Prepare a flexible budget performance report for June including all variances.

         Master (Static) Budget

Units

1,000

Sales

$800,000

Variable costs

450,000

Contribution margin

$350,000

Fixed costs

150,000

Operating income

$200,000

  1. Alex Thomsen, Inc. used 3,450 pounds of aluminum in June to manufacture 920 units. The company paid $28.50 per pound during the month to purchase aluminum. On June 1, the company had 50 pounds of aluminum on hand. At the end of June, the company had only 30 pounds of aluminum in its warehouse. Thomsen used 4,340 direct labor hours in June, at an average cost of $41.50 per hour.  The standard for aluminum is 4 pounds per unit at a standard cost of $25.00 per pound. The standard for direct labor is 5 hours per unit at a standard rate of $40 per hour.
    1. Compute for June, Alex Thomsen’s Inc.’s
      1. Purchase price variance for aluminum
      2. Direct labor rate and efficiency variance
    2. Thomsen deployed new strategies for both aluminum and labor. For aluminum and labor they invested in better inputs. Did management make good decisions? Please Show All of your work

Solutions

Expert Solution

Answer :

(a).

Flexible Budget Performance Report

For the Month of June

Actual results Revenue and spending variance Flexible Budget Activity variance Master budget
Units 920 920 1,000
Sales $768,200 $32,200 F $736,000(920*$800,000/1,000) $64,000 U $800,000
Variable cost 460,000 46,000 U 414,000(920*$450,000/1,000) 36,000 F 450,000
Contribution margin 308,200 13,800 U 322,000 28,000 F 350,000
Fixed costs 180,000 30,000 U 150,000 0 150,000
Operating income $128,200 $43,800 U $172,000 $28,000 U $200,000

(b).

(i). Purchase price variance = Actual quantity*Standard price - Actual quantity*Actual price

Actual quantity purchased = 3450+30-50 = 3430 units

Purchase price variance = 3,430*$25 - 3,430*$28.50

Purchase price variance = $85,750 - 97,755 = $12,005 Unfavorable

Material usage variance = Standard quantity*Standard price - Actual quantity*Standard price

Material usage variance = 920*4*$25 - 3,450*$25

Material usage variance = $92,000 - 86,250 = $5,750 Favorable

Direct labor rate variance = Actual hours*Standard rate - Actual hours*Actual rate

Direct labor rate variance = 4,340*$40 - 4,340*$41.50

Direct labor rate variance = $173,600 - 180,110 = $6,510 Unfavorable

Direct labor efficiency variance = Standard hours*Standard rate - Actual hours*Standard rate

Direct labor efficiency variance = 920*5*$40 - 4,340*$40

Direct labor efficiency variance = $184,000 - 173,600 = $10,400 Favorable

(ii). No, management did not make good decision as both the purchase price variance for aluminium and labor rate variance are unfavorable.


Related Solutions

The Master (Static) budget for Jack Daniels Inc. is presented below. For June, Jack Daniels Inc....
The Master (Static) budget for Jack Daniels Inc. is presented below. For June, Jack Daniels Inc. manufactured and sold 920 units for $835. During this month the company incurred $460,000 total variable expenses and $180,000 total fixed expenses. Required Prepare a flexible budget performance report for June including all variances.          Master (Static) Budget Units 1,000 Sales $800,000 Variable costs 450,000 Contribution margin $350,000 Fixed costs 150,000 Operating income $200,000 Jack Daniels Inc. used 3,450 pounds of aluminum in June to...
Crane Corporation’s master (static) budget for the year is shown below:   Sales (60,100 units) $ 1,923,200...
Crane Corporation’s master (static) budget for the year is shown below:   Sales (60,100 units) $ 1,923,200   Cost of goods sold:        Direct materials $ 174,290        Direct labor 456,760        Overhead (variable overhead        applied at 45% of direct labor cost) 241,000 872,050   Gross profit $ 1,051,150   Selling expenses:       Sales commissions (all variable) $ 162,270       Rent (all fixed) 41,000       Insurance (all fixed) 31,000   General expenses:       Salaries (all fixed) 92,500       Rent (all fixed) 77,500       Depreciation (all fixed) 51,000 455,270   Operating income $ 595,880 Required: 1....
Crane Corporation’s master (static) budget for the year is shown below: Sales (60,500 units) $ 2,178,000...
Crane Corporation’s master (static) budget for the year is shown below: Sales (60,500 units) $ 2,178,000 Cost of goods sold: Direct materials $ 199,650 Direct labor 484,000 Overhead (variable overhead applied at 30% of direct labor cost) 245,000 928,650 Gross profit $ 1,249,350 Selling expenses: Sales commissions (all variable) $ 161,656 Rent (all fixed) 45,000 Insurance (all short-term fixed) 35,000 General expenses: Salaries (all short-term fixed) 94,500 Rent (all short-term fixed) 79,500 Depreciation (all short-term fixed) 55,000 470,656 Operating income...
Crane Corporation’s master (static) budget for the year is shown below: Sales (60,000 units) $1,860,000 Cost...
Crane Corporation’s master (static) budget for the year is shown below: Sales (60,000 units) $1,860,000 Cost of goods sold: Direct materials$168,000 Direct labor 450,000 Overhead (variable overheadapplied at 40% of direct labor cost) 240,000 858,000 Gross profit $1,002,000 Selling expenses: Sales commissions (all variable)$167,400 Rent (all fixed) 40,000 Insurance (all short-term fixed) 30,000 General expenses: Salaries (all short-term fixed) 92,000 Rent (all short-term fixed) 77,000 Depreciation (all short-term fixed) 50,000 456,400 Operating income $545,600 Required:1. During the year, the company...
1. Another name for the static budget is... select one: a. master budget b. overhead budget...
1. Another name for the static budget is... select one: a. master budget b. overhead budget c. permanent budget d. flexible budget 2. Costs incurrd indirectly and allocated to a responsiblity level are consideted to be... select one: a. nonmaterial b. mixed c. controllable d. noncontrollable 3. It is possible that a company's financial statements may report inventories at... select one: a. budgeted costs b. standard costs c. both budgeted and standard costs d. none of these 4. Under management...
The performance report compares data from Remember When’s Inc. static master budget with the actual costs...
The performance report compares data from Remember When’s Inc. static master budget with the actual costs of its Watch Division for the year ended December 31. Remember When, Inc. Performance Report-Watch Division For the Year Ended December 31 Cost Category Budgeted Costs * Actual Costs † Difference Under (Over) Budget Direct materials $42,000 $46,000 ($4,000) Direct labor 10,325 11,779 (1,454) Variable overhead      Indirect materials 3,500 3,600 (100)      Indirect labor 5,250 5,375 (125)      Utilities 1,750 1,810 (60)     ...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $12,200 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 31,000 $ 41,000 $ 25,000 Cash payments for merchandise 22,200 15,800 16,200 Sales are 70% cash and 30% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,000 in cash, $13,000 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,000 $ 42,000 $ 26,000 Cash payments for merchandise 24,200 14,800 13,500 Sales are 80% cash and 20% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $14,000 in cash, $14,000 in accounts receivable, $11,000 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT