Question

In: Accounting

Standard costing Thomas Ltd makes a standard product, which sells at £5 a unit. It’s budget...

Standard costing

Thomas Ltd makes a standard product, which sells at £5 a unit. It’s budget and actual figures for a month are as follows;

Budget

Production for the month 5000 units

Direct materials (0.5kg at £3) £7,500

Direct Labour (15 minutes at £5/hour) £6,250

Fixed overheads £6,000

Actual

Production for the month 5400 units

Labour hours for month 1300 hours

Labour cost for month £6,885

Materials used in month 2,830kg

Materials cost for month £8,770

Fixed overheads £6,350

Actual Operating Profit £4,455

There was no existing stock at the start of the month.

Required:

a) Prepare a flexed budget for the month, showing expected profit.

b) Calculate standard costing variances for the month and reconcile the budgeted and actual profit figures.

Solutions

Expert Solution

Answer :

a) Preparation of flexible budget

Particulars Budgeted results Actual results Flexible budget Calculations
Units produced                         5,000                  5,400                      5,400
Selling price per unit £                             5 £                  4.9 £                          5
Sales revenue £                  25,000 £           26,460 £                27,000
Less : Variable cost
Material cost £                     7,500 £              8,770 £                  8,100 (7500/5000) x 5400
Labour cost £                     6,250 £              6,885 £                  6,750 (6250/5000) x 5400
Contribution £                  11,250 £           10,805 £                12,150
Less : Fixed cost £                     6,000 £              6,350 £                  6,000
Net profit £                     5,250 £              4,455 £                  6,150

Note :1) Calculation of Actual selling price per unit

Actual net profit = 4,445

Fixed costs = 6,350

Contribution = Net profit + Fixed cost = 4,445 + 6,350 = 10,795

Actual Material cost = 8,770

Actual labour cost = 6,885

Sales revenue = Contribution + Material cost + labour cost = 10,795 + 8,770 + 6,885 = 26,450

Units sold = 5,400

Selling price per unit = Sales revenue / Units sold = 26,450 / 5,400 = 4.9

b) Calculation of Standard costing variances

Particulars Budgeted results Standard results Actual results Standard costing Variances Calculations
Units produced                         5,000                       5,400                  5,400
Selling price per unit £                             5 £                           5 £                  4.9
Sales revenue £                  25,000 £                 27,000 £           26,460 (540) (Actual - Standard)
Less : Variable cost
Material cost £                     7,500 £                   8,100 £              8,770 (670) (Standard - Actual)
Labour cost £                     6,250 £                   6,750 £              6,885 (135) (Standard - Actual)
Contribution £                  11,250 £                 12,150 £           10,805 900 (Standard - Budgeted)
Less : Fixed cost £                     6,000 £                   6,000 £              6,350 (350) (Standard - Actual)
Net profit £                     5,250 £                   6,150 £              4,455 1,695 (Standard - Actual)


Reconciliation of Budgeted profit with actual profit

Particulars Amount
Budgeted profit £ 5,250
Less : sales revenue variance (540)
Less : Material cost variance (670)
Less : Labour cost variance (135)
Add : Contribution margin Variance 900
Less : Fixed cost variance (350)
Actual Profit £ 4,455

Related Solutions

Somnath Ltd manufactures and sells product G. The company operates a standard marginal costing system, and...
Somnath Ltd manufactures and sells product G. The company operates a standard marginal costing system, and the standard variable cost of production and selling price of product G is provided in the table below. £ per unit £ per unit Selling price 130 Variable production costs Direct Material A (£4 per kg) 24 Direct Material B (£8 per litre) 16 Direct Labour (£9 per hour) 45 Production overhead (£3 per hour) 15 Total variable costs (100) Contribution 30 The variable...
Q1 a) M Ltd manufactures a single product which it sells for K9 per unit. Fixed...
Q1 a) M Ltd manufactures a single product which it sells for K9 per unit. Fixed costs are K54, 000 per month and the product has a variable cost of K6 per unit in a period when actual sales were K180, 000. Calculate M Ltd´s marginal of safety in units. b). For forthcoming year, G plc,s variable costs are budgeted to be 60 percent of the sales value and fixed costs are budgeted to be 10 percent of sales value....
49. The Arkansas Company makes and sells a product called Product K. Each unit of Product...
49. The Arkansas Company makes and sells a product called Product K. Each unit of Product K sells for $25 dollars and has a unit variable cost of $19. The company has budgeted the following data for November: Sales of $1,162,200, all in cash. A cash balance on November 1 of $49,100. Cash disbursements (other than interest) during November of $1,170,000. A minimum cash balance on November 30 of $62,000. If necessary, the company will borrow cash from a bank....
Williams Ltd. manufactures and sells soaps. production. Thecompany operates a standard costing system. The standard...
Williams Ltd. manufactures and sells soaps. production. The company operates a standard costing system. The standard cost card for the product is as follows:Direct material            1kg @ $8.00 per kg. $ 8.00Direct labour               3hrs @ $4.50 per hr. $13.50variable overhead       3hrs @ $0.50 per hr. $ 1.50Fixed overhead           3hrs @ $7.40 per hr. $22.20                                    Budgeted output for the month of October 2019 was 6,500 units.Actual results for October were as follows.Production:                                         7 100 unitsMaterials consumed in production...
Merline Manufacturing makes its product for $55 per unit and sells it for $141 per unit....
Merline Manufacturing makes its product for $55 per unit and sells it for $141 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,410,000 Cost of goods sold 550,000 Gross profit 860,000 Operating expenses Sales commissions (10%) 141,000 Advertising 222,000 Store rent 25,100 Administrative salaries 45,500 Depreciation—Office equipment 55,500 Other expenses 13,100 Total expenses 502,200 Net income...
Merline Manufacturing makes its product for $70 per unit and sells it for $132 per unit....
Merline Manufacturing makes its product for $70 per unit and sells it for $132 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2019 Sales $ 1,320,000 Cost of goods sold 700,000 Gross profit 620,000 Operating expenses Sales commissions (10%) 132,000 Advertising 204,000 Store rent 24,200 Administrative salaries 41,000 Depreciation—Office equipment 51,000 Other expenses 12,200 Total expenses 464,400 Net income...
Merline Manufacturing makes its product for $70 per unit and sells it for $138 per unit....
Merline Manufacturing makes its product for $70 per unit and sells it for $138 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,380,000 Cost of goods sold 700,000 Gross profit 680,000 Operating expenses Sales commissions (10%) 138,000 Advertising 216,000 Store rent 24,800 Administrative salaries 44,000 Depreciation—Office equipment 54,000 Other expenses 12,800 Total expenses 489,600 Net income...
Merline Manufacturing makes its product for $70 per unit and sells it for $138 per unit....
Merline Manufacturing makes its product for $70 per unit and sells it for $138 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,380,000 Cost of goods sold 700,000 Gross profit 680,000 Operating expenses Sales commissions (10%) 138,000 Advertising 216,000 Store rent 24,800 Administrative salaries 44,000 Depreciation—Office equipment 54,000 Other expenses 12,800 Total expenses 489,600 Net income...
Merline Manufacturing makes its product for $65 per unit and sells it for $131 per unit....
Merline Manufacturing makes its product for $65 per unit and sells it for $131 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows. MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2017 Sales $ 1,310,000 Cost of goods sold 650,000 Gross profit 660,000 Operating expenses Sales commissions (10%) 131,000 Advertising 202,000 Store rent 24,100 Administrative salaries 40,500 Depreciation—Office equipment 50,500 Other expenses 12,100 Total expenses 460,200 Net income...
Z plc makes a single product which it sells for £16 per unit. Fixed costs are £76 800
Z plc makes a single product which it sells for £16 per unit. Fixed costs are £76 800 per month and the product has a contribution to sales ratio of 40%. In a period when actual sales were £224 000, Z plc's margin of safety, in units, was A 2000 B 6000 C 8000 D 12 000 E 14 000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT