Question

In: Accounting

Given the information below, What is the total variance in the actual and static budget? DeFleur...

Given the information below, What is the total variance in the actual and static budget?

DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division transfers the completed frames to the assembly division at the budgeted standard cost of a frame. The budgeted units of production for the framing division is 1,000, all of which will be transferred to the assembly division at the standard full absorption cost.

The budgeted costs for the framing division are as follows:

Direct Materials per unit: 10 layers of carbon-fiber at $20/layer $200.00
Direct Labor per unit: 8 hours at $12/hour $96.00

1.  Standard variable overhead is applied to products on the basis of direct labor hours at a rate of $4/unit produced.

Budgeted Fixed Overhead is $30,000 and the standard fixed cost per unit is based on the budgeted units of production.

Actual data for the period relating to the costs are as follows:

The actual number of units produced was 800
Actual Fixed Overhead costs were $32,000
Actual Variable Overhead costs $4,000

2. The framing division worked 7,500 direct labor hours during the year at a total cost of $93,750.

3.  A total of 9,000 carbon-fiber layers were purchased and used in production during the year at a total cost of $171,000

4. Total Budgeted cost for the framing department was $330,000. The total actual cost was $300,750

(Note that all the questions on variance are with respect to the framing department.)

Solutions

Expert Solution

Solution:

Standard qty of material per unit = 10 layer

Standard rate of material = $20 per layer

Budgeted prodcution = 1000 units

Actual production = 800 units

Standard Qty of direct material = 800*10 = 8000 layers

Actual Qty of direct material = 9000 layers

Actual cost of direct material = $171,000

Actual rate of direct material = $171,000 / 9000 =$19 per layer

Material Price Variance = (SP - AP)* AQ = (20-19)*9000 = $9000F

Material Qty variance = (SQ - AQ) * SR = (8000 - 9000)*20 = $20,000U

Material Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit

= (1000 - 800) *200 = $40000F

Total material variance = Budgeted cost of direct material - Actual cost of direct material

= 200*1000 - $171,000 = $29000F

Standard hours of labor per unit = 8 hours

Standard rate of labor = $12 per hour

Budgeted prodcution = 1000 units

Actual production = 800 units

Standard Hrs of direct labor = 800*8 = 6400 hours

Actual hrs of direct labor = 7500 hours

Actual cost of direct labor = $93,750

Actual rate of direct labor = $93,750 / 7500 =$12.50 per hour

Labor Rate Variance = (SR - AR)* AH = (12-12.50)*7500 = $3,750U

Labor efficiency variance = (SH - AH) * SR = (6400 - 7500)*12 = $13,200U

Labor Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit

= (1000 - 800) *96 = $19200F

Total labor variance = Budgeted cost of direct labor - Actual cost of direct labor

= 96*1000 - $93,750 = $2,250F

Standard hours of labor per unit = 8 hours

Standard variable overhead per unit = $4

Standard variable overhead rate per hour = 4/8 = $0.50 per hour

Standard Hrs of direct labor = 800*8 = 6400 hours

Actual hrs of direct labor = 7500 hours

Actual variable overhead cost = $4,000

Actual rate of variable overhead = $4,000 / 7500 =$0.533 per hour

Variable Overhead Rate Variance = (SR - AR)* AH = (0.50-0.53333333)*7500 = $250U

Variable overhead efficiency variance = (SH - AH) * SR = (6400 - 7500)*0.50 = $550U

Variable Overhead Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit

= (1000 - 800) *4 = $800 F

Total Variable overhead variance = Budgeted cost of variable overhead - Actual cost of variable overhad

= $4,000 - $4,000 = 0

Budget fixed overhead = $30,000

Actual fixed overhead = $32,000

Aborsption rate = Buegetec fixed overhead / Budgeted units = $30,000/1000 = $30 per unit

Applied overhead = $30 * 800 = $24,000 per unit

Fixed overhead price variance = Budgeted Overhead - Fixed Overhead = $30,000 - $32,000 = $2000 U

Fixed overhead volume variance = Budgeted fixed manufacturing Cost - Applied fixed manufacturing cost

=$30,000 - $24,000 = $6,000U

Total Fixed overhead budget variance = Actual fixed overhead - Applied fixed overhead = $32,000 - $24,000 = $8000U


Related Solutions

You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in time period 31 31 31 Staffed Beds 20 20 20 Patient days 527 498 (29.0) -5.5% 415 Total RN FTEs 45.1 50.1 (5.0) -11.1% 36.7 Revenue: Gross patient revenue $460,450 $441.932 ($18,518) -4.0% $417,883 Personnel Expense: Total salaries and wages $171,920 $192,845 ($20,925) -12.2% $141,552 Benefits $51,576 $52,797 ($1,221) -2.4% $42,466 Total personnel expenses $223,496 $245,642 ($22,146) -9.9% $184,018 Overtime wages % 2.0% 6.1%...
Actual overhead is $496,000, while budgeted overhead is $598,000. What is the fixed overhead static-budget variance...
Actual overhead is $496,000, while budgeted overhead is $598,000. What is the fixed overhead static-budget variance if 250,000 units are produced and 350,000 are budgeted? $80,000 favourable $100,000 unfavourable $100,000 favourable $101,000 unfavourable $102,000 favourable
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for March 2018. Master Budget for March 2018 Sales volume………………………...……………….2,100 diskettes Average selling price per diskette……………………$5.00/diskette DM costs per diskette………………………………..$0.85/diskette DM cost per lb……………………………….$17.00/lb DM per diskette……………………………..0.05 lb/diskette Direct Labor: Direct labor cost per hour……………………..$15.00/hr # of diskettes produced per labor hour……….. 30 diskettes Direct Marketing costs………………………………$0.30 /diskette Fixed overhead costs………………………………..$850/month Actual for March 2018 Sales volume ………………………………………..1,800 diskettes Average selling price………………………………..$4,80/diskette DM costs per...
Given the following actual return information, if the mean is 0.057 then what is the variance...
Given the following actual return information, if the mean is 0.057 then what is the variance of the returns for SpaceX? Year    Actual Return        0.256        0.069       -0.154 If Pro Bass Shop’s twenty-year bonds are currently selling for $992, the coupon rate is 4.6% and coupons are semi-annual, then what is the YTM?
The sales-volume variance plus or minus the static budget amount results in A static budget variance...
The sales-volume variance plus or minus the static budget amount results in A static budget variance The variable-budget amount An unfavourable/favourable amount The flexible budget amount
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
In addition to the static budget, the clinic also created a flexible and actual budget to...
In addition to the static budget, the clinic also created a flexible and actual budget to reflect the realized volume & actual volume respectively (see table below). Fill in the blanks on the table below & answer the following questions using the numbers from the table: a-Calculate & interpret the profit variance b-Calculate and interpret the revenue variance c-Calculate & interpret the cost variance d-Calculate & interpret the volume & price variances on the revenue side e-Calculate & interpret the...
In addition to the static budget , the clinic also created a flexible and actual budget...
In addition to the static budget , the clinic also created a flexible and actual budget to reflect the realized volume & actual volume, respectively. Fill in the blanks on the table below & answer the questions using the numbers in the table a)calculate & interpret the profit variance? (b) calculate & interpret the revenue variance (c) calculate & interpret the cost variance (d) calculate & interpret the volume & price variances on the revenue side (e)calculate & interpret the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT