Unit: Advanced Management Accounting
13 Questions| 1. | The forecast of the increase in sales revenue per annum from the premises is as follows: |
| Year | Sales revenue Sh.“000” | |
| 2022 | 700 | |
| 2023 | 600 | |
| 2024 | 500 | |
| 2025 | 400 | |
| 2026 | 300 |
| 2. | The average contribution to sales ratio is expected to be 40%. |
| 3. | The cost of capital is 16% on the net book values of the investment at the beginning of the year. |
| 4. | At the end of the five-year period, the premises improvements will have nil residual value. |
| 6. | Depreciation is charged on straight line basis. |
| 7. | The Diamond division has a target return on capital employed of 20%. |
Required: | |
| Prepare summary performance statement for the years 2022 to 2026 showing: | |
| (i) | Residual income (RI). |
| (ii) | Return on investment (ROI). |
| Cost driver | Variable cost per unit Sh. | Level of cost driver |
| Units sold | 25 | - |
| Set ups | 225 | 40 |
| Engineering hours | 10 | 250 |
| Product | ||||
| A | B | C | D | |
| Market price per unit (Sh.) | 150 | 146 | 140 | 130 |
| Variable cost of production per unit (Sh.) | 130 | 100 | 90 | 85 |
| Labour hours required per unit | 3 | 4 | 2 | 3 |
| 1. | Product D can be transferred to Division Y, but the maximum quantity that may be required for transfer is 2,500 units only. |
| 2. | The maximum sales in the external market are as follows: |
| 2. | Units | |
| A | 2,800 | |
| B | 2,500 | |
| C | 2,300 | |
| D | 1,600 |
| 3. | Division Y can purchase the same product at a price of Sh.125 per unit from external suppliers instead of receiving transfer of product D from Division X. |
| Annual fixed expenses: | Sh. |
| Staff salaries (excluding room attendants) | 7,500,000 |
| Repairs and maintenance | 2,600,000 |
| Depreciation on buildings and furniture | 2,400,000 |
| Other fixed expenses like dusting and sweeping | 3,250,000 |
| Total | 15,750,000 |
Variable expenses (per guest per day): | Sh. |
| Linen and laundry | 300 |
| Electricity and other facilities | 200 |
| Miscellaneous expenses | 250 |
| The management wishes to realise a profit of 25% on total cost. | |
| Assume a 30 day month in all cases. | |
| Usage during past re-order period Number of bags | Number of times this quantity was used |
| 225 | 9 |
| 300 | 15 |
| 375 | 20 |
| 450 | 3 |
| 525 | 2 |
| 600 | 1 |
| 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 |
| Balanced scorecard perspective | Objectives | Measurements | Target | Initiative |
| S1 |
| M1 Seat revenue | 30% profit margin | J |
| Plane lease cost | 20% customer retention 5% drop in cost | ||
| S2 |
| Arrival on time M2 | Best ranked | Quality management customer loyalty programme |
| S3 |
| On ground time On time departure | 30 minutes | K |
| S4 |
| % Ground crew trained | Year 1: 70% Year 2: 90% Year 5: 100% | - ESOPS - Ground crew training |
| 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 |
Want to join the discussion?
Log in to post comments and interact with tutors.
Login to Comment