Question

In: Accounting

Zippo manufactures plastic outdoor chairs. The controller put together the following static budget and actual income...

Zippo manufactures plastic outdoor chairs. The controller put together the following static budget and actual income statements and the following additional information.

Actual

Static Budget

Revenue

715,000

600,000

Direct materials

287,375

250,000

Direct manufacturing labor

250,250

150,000

Variable overhead

96,250

50,000

Fixed overhead

90,000

100,000

Operating income

(8,875)

50,000

Budget Information

  • Zippo expects to sell 50,000 chairs during the year
  • Each chair is budgeted to use 10 pounds of plastic and take 1/2 hour to manufacture
  • Variable and fixed overhead are allocated based on direct manufacturing labor hours

Actual Performance

  • Zippo sells 55,000 chairs during the year
  • Each chair used 9.5 pounds of plastic and 0.7 hour to manufacture

Chapter 7 Questions

  1. Prepare a flexible budget
  2. What are the level 1 variances?
  3. Compute price and efficiency variance for both direct material and direct manufacturing labor
  4. Comment on the level 3 variances you computed

Solutions

Expert Solution

Budget Comparison from above data is as follows:

Particulars Actual Amt Actual Qty Actual Rate Budget Amt Budget Qty Budgeted Rate
Revenue                    715,000          55,000            13.00         600,000         50,000                  12.00
Direct Materials                    287,375              9.50              0.55         250,000                10                    0.50
Direct Manufacturing Labour                    250,250              0.70              6.50         150,000             0.50                    6.00
Gross Contribution                    177,375         200,000
Variable Overhead                      96,250          55,000              1.75           50,000         50,000                    1.00
Fixed Overhead                      90,000         100,000
Net Profit / (Loss)                       (8,875)           50,000

Flexible Budget

Particulars Variable Cost p.u. Units Level of Activity
         45,000          50,000           55,000
Direct Materials                          5.00        225,000        250,000         275,000
Direct Manufacturing Labour                          3.00        135,000        150,000         165,000
Variable Overhead                          1.00          45,000          50,000           55,000
Total Variable Cost        405,000        450,000         495,000
Fixed Cost        100,000        100,000         100,000
Total Cost        505,000        550,000         595,000

Level 1 Variance Analysis refers to the variance identified in a static budget to calculate operating income. First, we calculate the operating income as per static budget and then compare with Actual operating income to get the variance.

Labour Efficiency Variance = (Budgeted Labour Rate - Actual Labour Rate) * Actual Labour Hours Worked

= (6 - 6.5) * (0.7*55,000 Units)

= 19,250 Unfavourable

Direct Labour Rate Variance = (Actual Hours * Actual Rate) - (Actual Hours * Budgted Rate)

Actual Hours worked = 0.7*55,000 Units actually produced

= 38,500 Hours

Direct Labour Rate Variance = (38,500*6.5) - (38,500*6)

= 19,250 Unfavourable

Based on the above price variances, we can conclude that the actual cost paid towards direct material and labour rate were higher than the budgeted rate resulting into unfavourable variances and need to be amended in the next flexible budget.


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...
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...
Waterways Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual...
Waterways Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual overhead for March. (Refer to Waterways 9 if you are uncertain about variable versus fixed costs.) Waterways Corporation                                                     Waterways Corporation Manufacturing Overhead Budget Manufacturing Overhead Costs (Actual) (Static) For the Month of March For the Month of March Budgeted Production (Units) 118,000 Production in units 118,500 Indirect materials $ 5,900 Indirect materials $ 5,910 Indirect labor 14,160 Indirect labor 14,195 Utilities 11,800 Utilities...
Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual overhead...
Waterways Corporation is continuing its budget preparations. Waterways had the following static budget and actual overhead costs for March. WATERWAYS CORPORATION Manufacturing Overhead Budget (Static) For the Month of March Budgeted production in units 123,000 Budgeted costs Indirect materials $6,150 Indirect labor 14,760 Utilities 12,300 Maintenance 8,610 Salaries 43,800 Depreciation 16,100 Property taxes 3,000 Insurance 1,200 Janitorial 1,600 Total budgeted costs $107,520 WATERWAYS CORPORATION Manufacturing Overhead Costs (Actual) For the Month of March Production in units 124,000 Costs Indirect materials...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information for last year follows: Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (plastic) 12 sq ft. $ 1.10 per sq. ft. $ 13.20 Direct labor 0.25 hr. $ 13.20 per hr. 3.30 Variable manufacturing overhead (based on direct labor hours) 0.25 hr. $ 2.20 per hr. 0.55 Fixed manufacturing overhead ($579,080 ÷ 934,000 units) 0.62 Parker Plastic had the following actual results...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information for last year follows: Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (plastic) 10 sq ft. $ 0.82 per sq. ft. $ 8.20 Direct labor 0.25 hr. $ 10.20 per hr. 2.55 Variable manufacturing overhead (based on direct labor hours) 0.25 hr. $ 1.40 per hr. 0.35 Fixed manufacturing overhead $270,600 ÷ 902,000 units) 0.30 Parker Plastic had the following actual results...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information for last year follows: Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (plastic) 9 sq ft. $ 1.30 per sq. ft. $ 11.70 Direct labor 0.3 hr. $ 13.50 per hr. 4.05 Variable manufacturing overhead (based on direct labor hours) 0.3 hr. $ 1.30 per hr. 0.39 Fixed manufacturing overhead ($619,080 ÷ 938,000 units) 0.66 Parker Plastic had the following actual results...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information for last year follows: Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (plastic) 8 sq ft. $ 1.02 per sq. ft. $ 8.16 Direct labor 0.3 hr. $ 11.10 per hr. 3.33 Variable manufacturing overhead (based on direct labor hours) 0.3 hr. $ 2.60 per hr. 0.78 Fixed manufacturing overhead ($383,880 ÷ 914,000 units) 0.42 Parker Plastic had the following actual results...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information...
Parker Plastic, Inc., manufactures plastic mats to use with rolling office chairs. Its standard cost information for last year follows: Standard Quantity Standard Price (Rate) Standard Unit Cost Direct materials (plastic) 12 sq ft. $ 0.61 per sq. ft. $ 7.32 Direct labor 0.1 hr. $ 10.00 per hr. 1.00 Variable manufacturing overhead (based on direct labor hours) 0.1 hr. $ 0.50 per hr. 0.05 Fixed manufacturing overhead ($160,000 ÷ 800,000 units) 0.20 Parker Plastic had the following actual results...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT