Question

In: Accounting

   Flexed Budget for October Actual for October Output 40,000 units 40,000 units Sales $500,000 $400,000...

   Flexed Budget for October Actual for October

Output 40,000 units 40,000 units

Sales $500,000 $400,000

Raw materials $100,000 $88,000

Labour $250,000 $180,000

Overheads $325,000 $375,000

The adverse (unfavourable) sales variance of $100,000 is best explained by-:

a. an increase in the expenses incurred by the business in the period

b. the sales manager and sales team not making the target level of sales

c. the price the units were sold for was less than budgeted

d. it is not possible to tell from this information

Solutions

Expert Solution

VARIANCE ANALYSIS TABLE

PARTICULARS BUDGET FOR OCTOBER ACTUAL FOR OCTOBER ANALYSIS
output 40,000 units 40,000 units there is no change from the budgetted output
sales $ 500,000 $ 400,000 the sales revenue has decreased by $100,000 from the budgetted sales revenue and is also seen that output remains as per budget . therefore price of units sold is less than the bugetted price
raw materials $ 100,000 $ 88,000 cost of raw materials is lesser than the budgetted amount therefore the variance favourable by $ 12000
labor $ 250,000 $ 180,000 cost of labor is lesser than the budgetted amount therefore the variance favourable by $ 70,000
overheads $ 325,000 $ 375,000 overheads is more than the budget by $ 50,000 which is adverse

CAUSE OF SALES VARIANCE (adverse)

as per the question above the sales variance ( adverse) $ 100,000 is due the lesser sales price charged per unit than the budget amount. The output level remains the same therefore the adverse sales variance is best explained by option C - the price for which units sold is less than the budgeted.

* the cause for the adverse sales variance is mentioned in highlighted in the analysis table above


Related Solutions

1. A company's flexible budget for the range of 26,000 units to 40,000 units of production...
1. A company's flexible budget for the range of 26,000 units to 40,000 units of production showed variable overhead costs of $3.80 per unit and fixed overhead costs of $69,000. The company incurred total overhead costs of $169,400 while operating at a volume of 40,000 units. The total controllable cost variance is: 2. Parallel Enterprises has collected the following data on one of its products. During the period the company produced 25,000 units. The direct materials price variance is: Direct...
The budgeted and actual results for June 2020 are as follows: Budget Actual Production (units) 150,000...
The budgeted and actual results for June 2020 are as follows: Budget Actual Production (units) 150,000 150,500 Direct material A 300,000m2 £675,000 316,050m2 £695,310 Direct material B 900,000 £18,000 1,053,500 £21,070 Direct labour 37,500 hours £318,750 37,625 hours £323,575 Fixed overheads £287,500 £300,623.75 You are required to: Calculate all possible variances from the information provided above for June and use the variances to reconcile the actual cost of production with the standard cost of production. Evaluate the variances calculated in...
Variances Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg)...
Variances Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg) 400 700 ? Material cost ($) 8,000 See purchases ? Direct Labour (hours) 35,000 46,102 ? Direct Labour ($) 385,000 507,080 ? Variable Overhead ($) 350,000 419,161 ? Fixed Overhead ($) 160,000 161,000 ?             Other Information Overhead is Allocated on Direct Labour Hours During the year, 800 kg of materials were purchased for $5,000 Beginning Inventory: none Ending Inventory:     100kg Required: Calculate the...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg) 400...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg) 400 700 ? Material cost ($) 8,000 See purchases ? Direct Labour (hours) 35,000 46,102 ? Direct Labour ($) 385,000 507,080 ? Variable Overhead ($) 350,000 419,161 ? Fixed Overhead ($) 160,000 161,000 ?             Other Information Overhead is Allocated on Direct Labour Hours During the year, 800 kg of materials were purchased for $5,000 Beginning Inventory: none Ending Inventory:     100kg Required: Calculate the flexible...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg) 400...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 ? Materials used (kg) 400 700 ? Material cost ($) 8,000 See purchases ? Direct Labour (hours) 35,000 46,102 ? Direct Labour ($) 385,000 507,080 ? Variable Overhead ($) 350,000 419,161 ? Fixed Overhead ($) 160,000 161,000 ?             Other Information Overhead is Allocated on Direct Labour Hours During the year, 800 kg of materials were purchased for $5,000 Beginning Inventory: none Ending Inventory:     100kg Required: Calculate the flexible...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 Materials used (kg) 400 700...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 Materials used (kg) 400 700 Material cost ($) 8,000 See purchases Direct Labour (hours) 35,000 46,102 Direct Labour ($) 385,000 507,080 Variable Overhead ($) 350,000 419,161 Fixed Overhead ($) 160,000 161,000             Other Information Overhead is Allocated on Direct Labour Hours During the year, 800 kg of materials were purchased for $5,000 Beginning Inventory: none Ending Inventory:     100kg Required: Calculate the flexible budget amounts for all items. Calculate the...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 Materials used (kg) 400 700...
Original Budget Actual Flexible Budget Units Produced (in units) 10,000 12,000 Materials used (kg) 400 700 Material cost ($) 8,000 See purchases Direct Labour (hours) 35,000 46,102 Direct Labour ($) 385,000 507,080 Variable Overhead ($) 350,000 419,161 Fixed Overhead ($) 160,000 161,000             Other Information Overhead is Allocated on Direct Labour Hours During the year, 800 kg of materials were purchased for $5,000 Beginning Inventory: none Ending Inventory:     100kg Required: Calculate the flexible budget amounts for all items. Calculate the...
Answer must be typed in word or in excel Original Budget Actual Units produced 1,000 units...
Answer must be typed in word or in excel Original Budget Actual Units produced 1,000 units 970 units Materials (kg) 400 kg 409 kg Material Costs $8,000 See other info Direct Labour (Hours)              36,000 hours 34,010 hours Direct Labour Costs $385,000 $365,750 Variable Overhead Costs $255,000 $245,000 Fixed Overhead Costs    $160,000 $165,000 Other Information Overhead is Allocated on Direct Labour Hours During the year, 500 kg of materials were purchased for $9,000 Beginning Inventory: none Ending Inventory:     91kg Required: Calculate...
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...
TUMI Comparative Income Statement July, 20XX Budgeted Actual Sales (1) $       400,000 $   423,500 (1a) A....
TUMI Comparative Income Statement July, 20XX Budgeted Actual Sales (1) $       400,000 $   423,500 (1a) A. Less variable costs Variable cost of goods sold Direct materials (2)              100,000        108,000 B. Direct Labor (3)                60,000          70,000 C. Manufacturing Overhead (4)                80,000           240,000          81,000       259,000 D. Selling costs (5)              50,000         65,000 E. Contribution margin           110,000         99,500 Less Fixed costs Manufacturing overhead                52,000          53,000 F. Selling costs                10,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT