Unit: Advanced Management Accounting
Sign in to download the full Topic PDF and enable offline revision mode.
Login to Access| Compound material | Sh. | |
| D | 0.51 kg at Sh.800 per kg | 408 |
| N | 0.28 kg at Sh.600 per kg | 168 |
| M | 0.21 kg at Sh.1,400 per kg | 294 |
| 1 | 870 |
| 1. | Actual units produced were 5,200 units of a cough syrup using 2,500kg of D, 1,500kg of N and 1,000kg of M. |
| 2. | Zitamol uses activity-based costing (ABC) to allocate its overheads. One of its main overheads for ABC is machine-setup costs. The following information is available for the period ended 31 July 2025: |
| 2. | Activity | Budget | Actual |
| Number of units produced | 250,000 | 300,000 | |
| Number of set-ups | 1,700 | 1,830 | |
| Fixed set-up costs | Sh.476,000 | Sh.550,000 |
| For the year ended 31 March 2025 | ||
| Budget | Sh.“000” | Sh.“000” |
| 12,500 kilometres of cleaning each at Sh.6,200 | - | 77,500 |
| Direct labour (3,200 hours each at Sh.7,000) | 22,400 | |
| Direct materials (1,250Kgs each at Sh.5,000) | 6,250 | |
| Variable overheads (3,200 hours each at Sh.4,500) | 14,400 | |
| Fixed overheads (3,200 hours each at Sh.8,000) | 25,600 | (68,650) |
| Budget surplus | - | 8,850 |
Actual | Sh.“000” | Sh.“000” |
| 11,750 kilometres cleaned each at Sh.6,200 | - | 72,850 |
| Direct labour (3,050 hours each at Sh.7,100) | 21,655 | |
| Direct materials, (1,160Kgs each at Sh.5,000) | 5,800 | |
| Variables overheads | 13,945 | |
| Fixed overheads | 25,100 | (66,500) |
| Actual surplus | - | 6,350 |
| Actual cost incurred: | Sh. |
| Direct material used (165,000 kilograms) | 15,675,000 |
| Direct labour (80,000 hours) | 5,800,000 |
| Variable production overheads | 16,800,000 |
| Fixed production overheads | 6,750,000 |
| Favourable | Adverse | |
| Planning and operating variances | Sh. | Sh. |
| Direct material price variance | 825,000 | |
| Direct material usage variance | 1,500,000 | |
| Direct labour rate variance | 200,000 | |
| Direct labour efficiency variance | 350,000 | |
| Variable production overhead: | ||
| Expenditure variance | 800,000 | |
| Efficiency variance | 1,000,000 | |
| Fixed production overhead: | ||
| Expenditure variance | 1,250,000 | |
| Volume variance | 6,250,000 |
| Type of clothes made | Shirts “Sh. Per unit” | Suits “Sh. Per unit” | Jeans “Sh. Per unit” |
| Selling price | 1,600 | 10,000 | 4,000 |
| Direct material (Sh.800 per \(\text{m}^2\)) | 400 | 4,000 | 1,200 |
| Direct labour (Sh.480 per hour) | 480 | 1,440 | 1,080 |
| Variable overheads (Sh.120 per machine hour) | 120 | 360 | 280 |
| Budgeted demand in September 2024 (units) | 6,000 | 2,000 | 4,000 |
| Adverse Sh.“000” | Favourable Sh.“000” | Total Sh.“000” | |
| Budgeted profit | 30,000 | ||
| Sales variances: | |||
| 6,000 | ||
| 3,600 | ||
| Material cost variances: | |||
| 37,500 | ||
| 4,500 | ||
| Labour cost variances: | |||
| 10,200 | ||
| 1,200 | ||
| Variable overhead variances: | |||
| 3,900 | ||
| 600 | ||
| Fixed overhead variances: | |||
| 300 | ||
| 1,500 | ||
| 2,700 | ||
| Total variances | (53,700) | 18,300 | (35,400) |
| Actual profit/(loss) | (5,400) |
| Sh.“000” | |
| Direct material (15 kilograms at Sh.5,000 per kilogram | 75 |
| Direct labour (5 hours at Sh.6,000 per hour) | 30 |
| Variable overheads (5 hours at Sh.3,000 per hour) | 15 |
| Fixed overheads (5 hours at Sh.2,000 per hour) | 10 |
| Standard cost | 130 |
| Standard margin | 20 |
| Standard selling price | 150 |
| Sh. | ||
| Selling price per unit | 880 | |
| Cost per unit: | ||
| Direct material: A | (2 kgs at Sh.100 per kg) | 200 |
| Direct.material:.B | (1 litre at Sh.150 per litre) | 150 |
| Direct labour | (3 hours at Sh.90 per hour) | 270 |
| Variable overhead | (3 hours at Sh.20 per direct labour hour) | 60 |
| 1. | Zeta Ltd. budgeted sales and production for the month of July 2023 was 10,000 units. |
| 2. | Annual budgeted fixed overheads were Sh.14,400,000 which are assumed to be incurred evenly throughout the year. |
| 3. | The company uses marginal costing system for internal profit measurement purposes. |
| 4. | The actual data for the month of July 2023 were as follows: | |
| Actual production and units sold | 9,000 Units | |
| Selling price | Sh.900 | |
| Direct materials consumed: | ||
| A: 19,000 kgs consumed at a cost of Sh.2,090,000 | ||
| B: 10,100 litres consumed at a cost of Sh.1,414,000 | ||
| Direct labour incurred 28,500 hours at a cost of Sh.2,736,000 | ||
| Variable overheads incurred | Sh.520,000 | |
| Fixed overheads incurred | Sh.1,160,000 | |
| Variable costs: | Sh. |
| Direct labour | 33 |
| Direct material | 77 |
| Marginal cost | 110 |
| Fixed costs: | |
| Production overheads | 100 |
| Full cost | 210 |
| 1. | Details of the three products for the period is as follows: | |||
| Product | P | Q | R | |
| Annual output (units) | 2,000 | 1,600 | 400 | |
| Annual direct labour hours | 200,000 | 220,000 | 80,000 | |
| Selling price per unit (Sh.) | 4,000 | 6,000 | 8,000 | |
| Raw material cost per unit (Sh.) | 400 | 600 | 900 | |
| 2. | The annual cost driver volumes relating to each activity and for each type of product are as follows: | |||
| Product | Number of deliveries to retailers | Number of set-ups | Number of purchase orders | |
| P | 100 | 35 | 400 | |
| Q | 80 | 40 | 300 | |
| R | 70 | 25 | 100 | |
| 250 | 100 | 800 | ||
| 3. | The annual costs relating to these activities and their cost drivers are as follows: | ||
| Sh. | Cost driver | ||
| Deliveries to retailers | 2,400,000 | Number of deliveries to retailers | |
| Set-up costs | 6,000,000 | Number of set-ups | |
| Purchase orders | 3,600,000 | Number of orders | |
| 4. | All direct labour is paid at a rate of Sh.5 per hour. The company operates on a just in time (JIT) production policy. |
Required: | |
| (i) | Prepare activity based budget statement for the period. |
| (ii) | Compute the profit or loss per unit for each product. |
| Budget | Actual | Variance | |
| Number of units sold (“000”) | 640 | 720 | 80 |
| Sh.“000” | Sh.“000” | Sh.“000” | |
| Sales | 1,024 | 1,071 | 47 |
| Cost of sales: | |||
| Direct materials | 168 | 144 | 24 |
| Direct labour | 240 | 288 | (48) |
| Overheads | 32 | 36 | (4) |
| 440 | 468 | (28) | |
| Fixed labour cost | 100 | 94 | 6 |
| Selling and distribution costs: | |||
| Fixed | 72 | 82 | (11) |
| Variable | 144 | 153 | (9) |
| Administrative costs: | |||
| Fixed | 184 | 176 | 8 |
| Variable | 48 | 54 | (6) |
| 548 | 560 | (12) | |
| Net profit margin | 36 | 43 | 7 |
| Standard cost per unit | Sh. | |
| Direct material Q | 7 kilograms at Sh.70 per kilogram | 490 |
| Direct labour | 5 hours at Sh.50 per hour | 250 |
| Overheads (fixed and variable) | 5 hours at Sh.66 per hour | 330 |
| 1,070 |
| 1. | The overhead allocation rate is based on direct labour hours and comprises an allowance for both fixed and variable overhead costs. |
| 2. | With the aid of regression analysis, the fixed element of overhead cost has been estimated at Sh.90,000 per week and the variable overhead costs have been estimated at Sh.6 per direct labour hour. |
| 3. | The fitting department comprises its own premises, and all of the department’s overhead costs can be regarded as being the responsibility of divisional managers. |
| 4. | In week 5, the division casted 294 spectacles and actual costs incurred were: |
| 4. | Sh. | |
| Direct material Q (2,030 kilogram used) | 141,250 | |
| Direct labour (1,520 hours worked) | 78,540 | |
| Overhead expenditure | 102,000 |
| 5. | The 1,520 hours worked by direct labour included 40 hours overtime, which is paid at a rate of 50% above the normal pay rates. |
| Sh. | |
| 5 litres of material M at Sh.7 per litre | 35 |
| 3 litres of material R at Sh.5 per litre | 15 |
| 2 litres of material N at Sh.2 per litre | 4 |
Actual input was as follows: | |
| Sh. | |
| 53,000 litres of material M at Sh.7 per litre | 371,000 |
| 28,000 litres of material R at Sh.5.30 per litre | 148,400 |
| 19,000 litres of material N at Sh.2.20 per litre | 41,800 |
| Product Jipe | Standard marginal cost per unit Sh. |
| Direct materials: 6 kgs at Sh.40 per kg | 240 |
| Direct labour: 1 hour at Sh.70 per hour | 70 |
| Variable production overhead | 30 |
| 340 |
| Number of units of product Jipe produced | 18,500 |
| Sh. | |
| Direct materials purchased and used (113,500 kgs) | 4,426,500 |
| Direct labour (17,800 hours) | 1,299,400 |
| Variable production overheads incurred | 588,000 |
| Fixed production overhead incurred | 1,040,000 |
| Actual production cost | 7,353,900 |
| Product | Sales quantity (Units) | Revenue (Sh.) | Costs (Sh.) | Profit (Sh.) |
| Bingo | 400 | 8,000 | 6,000 | 2,000 |
| Boost | 300 | 12,000 | 11,100 | 900 |
| 2,900 | ||||
| Actual sales were as follows: | ||||
| Bingo | 280 units with a profit of Sh.5.30 per unit. | |||
| Boost | 630 units with a profit of Sh.2.80 per unit. | |||
| Fixed budget for full capacity | Flexible budget for 75% level | |
| Sales | 1,350,000 | 1,012,500 |
| Direct materials | 425,000 | 318,750 |
| Direct labour | 185,000 | 138,750 |
| Variable overheads | 215,000 | 161,250 |
| Semi variable overheads | 365,000 | 323,750 |
| Profit | 160.000 | 160.000 |
| (a) | Using the least squares regression model above, estimate the weekly holiday demand for 2019. |
| (b) | Identify three weaknesses of the least square regression |
| (c) | The fixed budget and actual cost for the 10-day happy holiday for the year ended 31st December 2021 is given below: |
| (c) | Details | Fixed budget | Actual | Variance |
| Air tickets | 2,800,000 | 2,920,000 | 120,0000A | |
| Coach bus hire | 100,000 | 80,000 | 20,000F | |
| Room charges | 1,000,000 | 1,020,000 | 20,000A | |
| Meals | 480,000 | 440,000 | 40,000F | |
| Tour guide charges | 360,000 | 330,000 | 30,000F | |
| Advertising | 400,000 | 350,000 | 50,000F | |
| Total cost | 5,140,000 | 5,140,000 | 0 |
| (c) | Key: A represents adverse while F represents favorable results. The finance manager availed the following additional information: |
| (c) | 1. | Each holiday lasts for 10 days with full accommodation. |
| 2. | The return air ticket is Sh.70,000 per passenger on condition that booking is done in batches of 20 seats. | |
| 3. | The hiring charges for coach bus, tour guide and advertisement are fixed. | |
| 4. | Meal cost was budgeted at Sh.1,200 per guest per day. | |
| 5. | Charges for single room was budgeted at Sh.3,500 while for double room at Sh.5,000 per guest per day. Out of the 38 guests who travelled for the holiday, 4 booked single rooms while 17 booked double rooms. | |
| 6. | The price of a holiday is Sh.10,000 more if one books a single room. | |
Required: | ||
| (i) | Prepare a flexible budget and identify any resulting variances. | |
| (ii) | Explain which one between the fixed and flexible budgets is more useful for cost management. | |
| (iii) | Identify three factors to consider in deciding whether or not to investigate individual variances. | |
| Sh. | |
| Catering | 4,500,000 |
| Laundry | 1,500,000 |
| Pharmacy | 5,000,000 |
| 11,000,000 |
| Patient days p.a | Supervisors | Nurses | Assistants |
| Upto 20,500 | 4 | 10 | 20 |
| 20,501 – 23,000 | 4 | 13 | 24 |
| Over 23,000 | 4 | 15 | 28 |
| Sh. | |
| Supervisors | 220,000 |
| Nurses | 160,000 |
| Assistants | 120,000 |
| Sh. | |
| Administration | 8,500,000 |
| Security | 800,000 |
| Rent and property | 7,200,000 |
| 16,500,000 |
| Actual | Budgeted | |
| Sales volume (units) | 4,900 | 5,000 |
| Selling price per unit (Sh.) | 150 | 140 |
| Production volume (units) | 5,400 | 5,000 |
| Direct materials (kilograms) | 10,600 | 10,000 |
| Direct materials price per kilogram (Sh.) | 6 | 5 |
| Direct labour hours per unit | 5.5 | 5.0 |
| Direct labour rate per hour (Sh.) | 11.4 | 12.0 |
| Fixed production overheads (Sh.) | 103,000 | 100,000 |
| Variable production overheads at Sh.8 per direct labour hour (Sh.) | 215,000 | 200,000 |
| Sh. | |
| Direct material (20 square metres at Sh.200 per metre) | 4,000 |
| Direct labour (5 hours at Sh.400 per hour) | 2,000 |
| Variable overheads (5 hours at Sh.200 per hour) | 1,000 |
| Fixed overheads (5 hours at Sh.100 per direct labour hour) | 500 |
| 7,500 |
| 1. | The standard unit selling price of product K20 is Sh.9,800. |
| 2. | Monthly budget production and sales is set at 1,000 units. |
| 3. | The following figures relate to the month of October 2020: | |
| Sales | 150 units at Sh. 10.400 | |
| Production | 1,200 units (there was no opening stock) | |
| Direct material 18,800 square metres at Sh.400 per square metre | ||
| Direct wages | 5,800 hours at Sh.500 per hour. | |
| Total variable overheads | Sh. 942,000 | |
| Total fixed overheads | Sh.600,000 | |
| Sh. | Sh. | |
| Selling price per printer | 17,500 | |
| Variable production cost: | ||
| Direct materials (800 grams at Sh.7,500 per kg) | 6,000 | |
| Direct labour (75 minutes at Sh.3,000 per hour) | 3,750 | |
| Variable overheads (60% of direct labour) | 2,250 | (12,000) |
| Contribution per printer | 5,500 |
| (a) | Determine the standard labour cost for the month of December 2020. |
| (b) | Prepare a budget for the month of December 2020 showing the budgeted profit. |
| (c) | Assume the actual results for the month of December 2020 for the production level of 3,000 printers are as follows. |
| Sh."000" | ||
| Sales (3,000 at Sh. 18,000 each) | 54,000 | |
| Direct materials (2,700 kgs at Sh. 7,000 per kg) | 18,900 | |
| Direct labour (1,700 hours at Sh.3,250 per hour) | 5,525 | |
| Variable overheads | 3,400 | |
| Fixed costs | 5,075 | |
| 21,100 |
| 1 | Standard cost per unit of product XP: |
| Material | Kgs | Price per Kg Sh. | Total Sh. | |
| F G H | 15 12 8 | 4 3 6 | 60 36 48 | |
| Labour | Hours | Rate per hour Sh. | ||
| Department P Department Q | 4 2 | 10 6 | 40 12 196 |
| 2 | Budgeted sales for the period amount to 4,500 units at Sh.260 per unit. |
| 3 | There were no budgeted opening and closing inventories of product XP. |
| 4 | The actual materials and labour used were as follows: |
| Materials | Kgs | Price per Kg | Total Sh. | |
| F G H | 59,800 53,500 33,300 | 4.25 2.80 6.40 | 254,150 149,800 213,120 |
| Labour Department | Hours | Rate per hour Sh. | Sh. | |
| P Q | 20,500 9,225 | 10.60 5.60 | 217,300 51,660 |
| 5 | During the period, 4,100 units of product XP were produced and sold for Sh.1,158,000. |
| Budget | Actual | |
| Output (batches) | 6 | 6 |
| Labour hours | 2,400 | 1,950 |
| Total labour cost (Sh.) | 1,680,000 | 1,365,000 |
| Total labour cost variance | Sh.315,000 (favourable) |
| Labour rate variance | Nil |
| Labour efficiency variance | Sh.315,000 (favourable) |
| Type of sofa set | |||
| American | Butterfly | Comfy | |
| Production and sales (units) | 900 | 800 | 1,000 |
| Selling price per unit (Sh.) | 40,000 | 20,000 | 30,000 |
| Price cost per unit (Sh.) | 35,000 | 16,000 | 24,000 |
| 1 | The company's budgeted overhead costs for the coming period are: |
| Sh. | ||
| Processing services | 3,480,000 | |
| Assembly services | 2,562,000 | |
| Quality control | 1,930,500 | |
| Selling and administration | 3,007,500 | |
| 10,980,000 |
| 2 | The overheads are currently absorbed to products based on assembly labour hours. |
| 3 | Production of each type of sofa set takes place in batches of 50 units. |
| 4 | The company has also provided the following estimates for the coming period: |
| Type of sofa set | ||||
| America | Butterfly | Comfy | ||
| Machine hours per unit | 4 | 3 | 6 | |
| Direct labour hours per unit | 7 | 5 | 8 | |
| Number of customer orders | 30 | 40 | 50 | |
| 5 | The management accountant has just learnt of activity based costing (ABC) and would be willing to apply it. |
| Sh. | |
| Wood (25 kgs at Sh.32 per kg) | 800 |
| Labour (4 hours at Sh.80 per hour) | 320 |
| Variable overheads (4 hours at Sh.40 per hour) | 160 |
| Fixed overheads (4 hours at Sh.160 per hour) | 640 |
| Total standard cost | 1,920 |
| Selling price | 2,200 |
| Standard profit | 280 |
| 1 | Overheads are absorbed on the basis of labour hours and the company uses an absorption costing system. |
| 2 | Stocks are valued at standard cost. There were no stocks at the beginning of the month of October 2017. |
| 3 | Actual results for the month of October 2017 were as follows: |
| Sh."000" | ||
| Wood (80.000 kgs at Sh.35 per kg) | 2,800 | |
| Labour (16,000 hours at Sh.70 per hour) | 1,120 | |
| Variable overheads | 600 | |
| Fixed overheads | 1,960 | |
| Total production cost (3,600 benches) | 6,480 | |
| Closing stock (400 benches at Sh.1,920 each) | (768) | |
| Cost of sales | 5,712 | |
| Sales (3,200 benches) | 7,200 | |
| Actual profit | 1,488 |
| 4 | The average monthly production and sales for some years prior to October 2017 had been 3,400 units and budgets had previously been set at this level. Very few operating variances had historically been generated by the standard cost used. |
| 5 | The finance director suggested that an absorption costing system is misleading and that marginal costing system should be considered at some stage in the future to guide decision making. |
| Budget | Actual | Variance | |
| Number of units sold | 640,000 | 720,000 | 80,000 |
| Sh. "000" | Sh. "000" | Sh. "000" | |
| Sales | 1,024 | 1,071 | 47 |
| Cost of sales (all variable): | |||
| Materials | 168 | 144 | |
| Labour | 240 | 288 | |
| Overheads | 32 | 36 | |
| Total variable costs | 440 | 468 | (28) |
| Fixed labour cost | 100 | 94 | 6 |
| Selling and distribution costs: | |||
| Fixed | 72 | 83 | (11) |
| Variable | 144 | 153 | (9) |
| Administrative costs: | |||
| Fixed | 184 | 176 | 8 |
| Variable | 48 | 54 | (6) |
| 548 | 560 | (12) | |
| Net profit | 36 | 43 | 7 |
| 1 | The night shift workers normally consist of 30 skilled men, 15 semi-skilled men and 10 unskilled men, who are paid at standard hourly rates of Sh.80, Sh.60 and Sh.40 respectively. |
| 2 | A normal working week consists of 40 hours. |
| 3 | The weekly output for night shift workers is expected to be 2,000 units. |
| 4 | In the second week of the month of October 2016, the night shift workers consisted of 40 skilled men, 10 semi-skilled men and 5 unskilled men, who were paid at Sh.70, Sh.65 and Sh.30 respectively. During that week, 4 hours were lost due to abnormal idle time and 1,600 units were produced. |
| Standard marginal cost per unit Sh. | |
| Direct materials: 6 kgs at Sh.40 per kg. | 240 |
| Direct labour: 1 hour at Sh.70 per hour | 70 |
| Variable production overhead | 30 |
| 340 |
| 1 | Variable production overheads vary with units produced. | |
| 2. | Budgeted fixed production overheads per month amount to Sh.1,000,000. | |
| 3. | Budgeted production for product Exa amounted to 20,000 units per month. | |
| 4. | Budgeted selling price per unit amounted to Sh.440. | |
| 5. | The actual results for the month of April 2016 were as follows: | |
| Units of Exa produced | 18,500 | |
| Sh. | ||
| Direct materials purchased and used (113,500 kgs.) | 4,426,500 | |
| Direct labour (17.800 hours) | 1,299,400 | |
| Variable production overheads incurred | 588,000 | |
| Fixed production overheads incurred | 1,040,000 | |
| 7,353,900 | ||
| Actual selling price per unit Sh.480 | ||