Edexcel IAS-Level · Thinka-original Practice Paper

2025 Edexcel IAS-Level Accounting (XAC11) Practice Paper with Answers

Thinka Oct 2025 Cambridge International A Level-Style Mock — Accounting (XAC11)

400 marks360 mins2025
An original Thinka practice paper modelled on the structure and difficulty of the Oct 2025 Cambridge International A Level Accounting (XAC11) paper. Not affiliated with or reproduced from Cambridge.

WAC11 Section A

Answer BOTH questions. All calculations must be shown.
2 Question · 110 marks
Question 1 · essay
55 marks
Sanjay is a sole trader who operates a retail electronics business. The following trial balance was extracted from his books of account at 30 June 2023:

Trial Balance as at 30 June 2023:
Revenue: Credit £380 000
Purchases: Debit £210 000
Inventory at 1 July 2022: Debit £34 000
Trade Receivables: Debit £48 000
Allowance for Doubtful Debts (1 July 2022): Credit £1 800
Trade Payables: Credit £31 400
Cash and Bank: Debit £7 300
Leasehold Premises (at cost): Debit £150 000
Equipment (at cost): Debit £80 000
Provision for Depreciation (1 July 2022):
- Leasehold Premises: Credit £30 000
- Equipment: Credit £32 000
Carriage Inwards: Debit £4 500
Carriage Outwards: Debit £6 200
Wages and Salaries: Debit £42 000
Rent, Rates and Insurance: Debit £22 000
General Expenses: Debit £11 800
Capital (1 July 2022): Credit £159 000
Drawings: Debit £18 400
Total: Debit £634 200 / Credit £634 200

Additional information:
1. Inventory at 30 June 2023 was valued at a cost of £38 500. This includes some damaged goods which cost £3 000 but can only be sold for £1 800 after incurring repair costs of £200.
2. On 30 June 2023, Sanjay took goods costing £1 500 for his own use. No entry has been made in the books of account.
3. Wages and Salaries of £1 200 were accrued (outstanding) as at 30 June 2023.
4. Rent, Rates and Insurance includes an insurance premium of £3 600 paid for the 12 months ending 31 October 2023.
5. A trade receivable owing £2 000 has been declared bankrupt and the debt is irrecoverable. It must be written off. The allowance for doubtful debts is to be adjusted to 5% of the remaining trade receivables.
6. Depreciation for the year is to be charged as follows:
- Leasehold Premises: 2% per annum on cost (Straight-line).
- Equipment: 15% per annum using the reducing balance method.

Required:
(a) Prepare Sanjay's Statement of Profit or Loss for the year ended 30 June 2023. [22 marks]
(b) Prepare Sanjay's Statement of Financial Position as at 30 June 2023. [18 marks]
(c) Calculate the following ratios to two decimal places:
(i) Gross Profit Margin,
(ii) Profit for the year as a percentage of revenue,
(iii) Liquid (Acid Test) ratio. [6 marks]
(d) Sanjay has saved £40 000 and is considering two alternative investment options to expand his business:
- Option A: Refurbish the existing physical retail store. This is expected to increase revenue by 10% next year, with an estimated gross profit margin of 45%. Operating expenses will increase by £8 000 per year.
- Option B: Launch an e-commerce website and transition part of the sales online. This is expected to generate £60 000 of new online sales next year. The online sales will have a lower gross profit margin of 35% due to high delivery and packaging costs, and additional digital marketing/hosting expenses will be £10 000 per year.
Evaluate these two options and recommend which option Sanjay should choose. [9 marks]
Show answer & marking scheme

Worked solution

(a) Statement of Profit or Loss for the year ended 30 June 2023:
Revenue: £380 000
Less: Cost of Sales:
- Opening Inventory: £34 000
- Purchases (£210 000 - £1 500): £208 500
- Carriage Inwards: £4 500
- Cost of Goods Available for Sale: £247 000
- Less: Closing Inventory (see note): (£37 100)
Cost of Sales: (£209 900)
Gross Profit: £170 100
Less: Expenses:
- Carriage Outwards: £6 200
- Wages and Salaries (£42 000 + £1 200): £43 200
- Rent, Rates and Insurance (£22 000 - £1 200): £20 800
- General Expenses: £11 800
- Irrecoverable debts: £2 000
- Increase in Allowance for Doubtful Debts (£2 300 - £1 800): £500
- Depreciation - Leasehold Premises: £3 000
- Depreciation - Equipment: £7 200
Total Expenses: (£94 700)
Profit for the Year: £75 400

Note on Closing Inventory: Cost of undamaged goods = £35 500. NRV of damaged goods = £1 800 - £200 = £1 600. Valuation = £35 500 + £1 600 = £37 100.

(b) Statement of Financial Position as at 30 June 2023:
Non-Current Assets:
- Leasehold Premises: Cost £150 000, Accumulated Depreciation £33 000, NBV £117 000
- Equipment: Cost £80 000, Accumulated Depreciation £39 200, NBV £40 800
Total Non-Current Assets: £157 800

Current Assets:
- Inventory: £37 100
- Trade Receivables (£48 000 - £2 000 - £2 300): £43 700
- Prepayments (Insurance): £1 200
- Cash and Bank: £7 300
Total Current Assets: £89 300
Total Assets: £247 100

Capital:
- Opening Capital: £159 000
- Add: Profit for the year: £75 400
- Less: Drawings (£18 400 + £1 500): (£19 900)
Closing Capital: £214 500

Current Liabilities:
- Trade Payables: £31 400
- Accruals (Wages): £1 200
Total Current Liabilities: £32 600
Total Capital and Liabilities: £247 100

(c) Ratio Calculations:
(i) Gross Profit Margin = (\(170 100 / 380 000\)) * 100 = 44.76% (or 44.80%)
(ii) Profit for the Year % = (\(75 400 / 380 000\)) * 100 = 19.84% (or 19.80%)
(iii) Liquid (Acid Test) Ratio = (\(43 700 + 1 200 + 7 300\)) / 32 600 = 52 200 / 32 600 = 1.60 : 1

(d) Evaluation and Recommendation:
Option A (Refurbishment):
- Increased sales = 10% * £380 000 = £38 000.
- Increased Gross Profit = 45% * £38 000 = £17 100.
- Increased Net Profit = £17 100 - £8 000 = £9 100.
- Sanjay already has experience running the physical store, making this lower risk. However, it does not expand the geographical reach of the business.
Option B (E-commerce):
- Online sales = £60 000.
- Increased Gross Profit = 35% * £60 000 = £21 000.
- Increased Net Profit = £21 000 - £10 000 = £11 000.
- This gives a higher net financial benefit by £1 900 (£11 000 - £9 100). It unlocks a wider customer base, but comes with logistics complexities, shipping costs, and tech management risks.
Recommendation: Sanjay should choose Option B because it yields a higher profit return and has greater growth potential in the digital era, provided he can manage the online logistics and security risks.

Marking scheme

(a) Statement of Profit or Loss [Total: 22 marks]
- Revenue: £380 000 [1]
- Opening inventory: £34 000 [1]
- Adjusted purchases: £208 500 [2] (1 mark for showing £210 000 - £1 500)
- Carriage inwards: £4 500 [1]
- Closing inventory: £37 100 [3] (1 mark for undamaged cost £35 500, 1 mark for NRV £1 600, 1 mark for final addition)
- Cost of sales: £209 900 [1]
- Gross Profit: £170 100 [1 OF]
- Carriage outwards: £6 200 [1]
- Wages and salaries: £43 200 [2] (1 mark for showing £42 000 + £1 200)
- Rent, rates and insurance: £20 800 [2] (1 mark for prepaying £1 200)
- General expenses: £11 800 [1]
- Irrecoverable debts: £2 000 [1]
- Allowance for doubtful debts increase: £500 [2] (1 mark for calculating ending allowance £2 300, 1 mark for difference)
- Leasehold Premises Depreciation: £3 000 [1]
- Equipment Depreciation: £7 200 [1]
- Profit for the Year: £75 400 [1 OF]

(b) Statement of Financial Position [Total: 18 marks]
- Non-Current Assets Leasehold Premises NBV: £117 000 [1 OF]
- Non-Current Assets Equipment NBV: £40 800 [1 OF]
- Closing Inventory: £37 100 [1 OF]
- Trade Receivables (net of write-off and allowance): £43 700 [2] (1 mark for subtracting £2 000, 1 mark for subtracting £2 300)
- Prepayments: £1 200 [1]
- Cash and Bank: £7 300 [1]
- Total Assets: £247 100 [1 OF]
- Opening Capital: £159 000 [1]
- Profit for the Year: £75 400 [1 OF]
- Drawings: £19 900 [2] (1 mark for showing £18 400 + £1 500)
- Closing Capital: £214 500 [1 OF]
- Trade Payables: £31 400 [1]
- Accruals: £1 200 [1]
- Total Capital and Liabilities: £247 100 [2 OF] (1 mark if matches Total Assets, 1 mark for details correct)

(c) Ratios [Total: 6 marks]
- Gross Profit Margin: 44.76% (Accept 44.80%) [2] (1 mark for correct formula/working)
- Profit for the Year %: 19.84% (Accept 19.80%) [2] (1 mark for correct formula/working)
- Liquid (Acid Test) Ratio: 1.60 : 1 [2] (1 mark for correct formula/working)

(d) Evaluation & Decision [Total: 9 marks]
- Up to 4 marks for financial calculations of Option A and Option B (2 marks each for finding net profits: £9 100 for Option A, £11 000 for Option B).
- Up to 4 marks for balanced qualitative arguments (advantages/disadvantages of each choice).
- 1 mark for a clear, justified recommendation based on arguments presented.
Question 2 · practical
55 marks
Julian operates a wholesaling business. On 30 April 2023, his trial balance failed to agree, with the debit side exceeding the credit side by \(£1,680\). A suspense account was opened for the difference.

Subsequent investigations revealed the following errors and omissions:
1. A purchase of office equipment costing \(£3,600\) was entered in the repairs to equipment account. Office equipment is depreciated at 10% per annum on cost, with a full year's depreciation charged in the year of purchase.
2. A credit sale of \(£850\) to H. Morgan was posted to the account of H. Morris.
3. The sales journal was undercast by \(£600\).
4. A cash receipt of \(£420\) from a debtor, T. Vance, was correctly entered in the cash book but posted to the credit of his ledger account as \(£240\).
5. Rent paid of \(£1,200\) had been correctly entered in the cash book but posted to the debit of the Rent account as \(£2,100\).
6. A purchase of goods on credit from S. Patel for \(£730\) was completely omitted from the books.

Julian's draft profit for the year ended 30 April 2023 before any corrections was \(£42,500\).

Required:
(a) Prepare the Journal entries to correct errors (1) to (6). (Narratives are not required). (18 marks)
(b) Prepare the Suspense Account to show the corrections, clearing the balance. (8 marks)
(c) Calculate the corrected draft profit for the year ended 30 April 2023. (11 marks)
(d) State and explain two types of errors that do not affect the agreement of the trial balance, using examples from Julian's business. (6 marks)
(e) Evaluate the usefulness of preparing a trial balance and control accounts in maintaining accurate financial records for Julian. (12 marks)
Show answer & marking scheme

Worked solution

(a) Journal Entries:

1. Office Equipment Dr \(£3,600\), Repairs to Equipment Cr \(£3,600\) (To correct capital expenditure treated as revenue expenditure).
Depreciation Expense Dr \(£360\), Provision for Depreciation on Office Equipment Cr \(£360\) (To charge 10% depreciation on newly recognized equipment).
2. H. Morgan Dr \(£850\), H. Morris Cr \(£850\) (To correct posting to wrong debtor's account).
3. Suspense Account Dr \(£600\), Sales Cr \(£600\) (To correct undercast of sales journal).
4. Suspense Account Dr \(£180\), T. Vance Cr \(£180\) (To correct under-credit of cash received from debtor: \(£420 - £240 = £180\)).
5. Suspense Account Dr \(£900\), Rent Cr \(£900\) (To correct over-debit of rent expense: \(£2,100 - £1,200 = £900\)).
6. Purchases Dr \(£730\), S. Patel Cr \(£730\) (To record omitted credit purchase).

(b) Suspense Account:

Debit side:
- Sales (Error 3): \(£600\)
- T. Vance (Error 4): \(£180\)
- Rent (Error 5): \(£900\)
Total Debit: \(£1,680\)

Credit side:
- Difference on trial balance (Balance b/f): \(£1,680\)
Total Credit: \(£1,680\)

(c) Statement of Corrected Profit for the year ended 30 April 2023:

Draft Profit: \(£42,500\)
Error 1: Add: Repairs reduction: \(£3,600\)
Error 1: Less: Depreciation expense: \((£360)\)
Error 2: No effect: \(£0\)
Error 3: Add: Unrecorded sales: \(£600\)
Error 4: No effect: \(£0\)
Error 5: Add: Rent expense reduction: \(£900\)
Error 6: Less: Unrecorded purchases: \((£730)\)
Corrected Profit: \(£46,510\)

(d) Two types of errors not affecting the Trial Balance:
1. Error of Principle: This occurs when a transaction is entered in the wrong class of account. For example, in Error 1, capital expenditure (Office Equipment) was debited to a revenue expense account (Repairs). Both are debit entries, so the trial balance still balances.
2. Error of Commission: This occurs when a transaction is posted to the correct type of account but the wrong individual account. For example, in Error 2, a credit sale was posted to the account of H. Morris instead of H. Morgan. Both are debtor balances (debit entries), so the trial balance balances.
Other acceptable options: Error of Omission (Error 6).

(e) Evaluation of Trial Balance and Control Accounts:

Arguments for Trial Balance:
- Provides a fast and simple check on the mathematical accuracy of the double-entry bookkeeping system.
- Helps quickly identify single-sided posting errors or additions errors, which are then temporarily placed in a suspense account.
- Serves as the starting point for preparing the final financial statements.

Limitations of Trial Balance:
- It will not detect errors of omission, principle, commission, original entry, compensating errors, or complete reversals, as these affect both debit and credit columns equally.

Arguments for Control Accounts:
- Acts as an independent check on the accuracy of the sales and purchases ledgers.
- Helps locate errors to a specific ledger (receivables or payables), saving time for the accountant.
- Deters fraud and internal collusion because ledger clerks do not maintain the control accounts.
- Provides a quick, single balance for trade receivables and trade payables to be used in the Statement of Financial Position.

Limitations of Control Accounts:
- They rely on the same books of prime entry as the individual subsidiary ledgers. If there is an error in a journal (e.g. sales journal undercast or omitted transaction), the control account will also be incorrect.

Conclusion:
Preparing both a trial balance and control accounts is highly recommended as part of Julian's internal control system. Neither tool on its own guarantees absolute accuracy, but combined they dramatically reduce the risk of undetected errors and fraud.

Marking scheme

(a) Journal entries (18 marks total):
- Error 1 (Equipment): Dr Office Equipment \(£3,600\) (1) Cr Repairs \(£3,600\) (1)
- Error 1 (Depreciation): Dr Depreciation \(£360\) (1) Cr Provision for Depreciation \(£360\) (1)
- Error 2: Dr H. Morgan \(£850\) (1) Cr H. Morris \(£850\) (1)
- Error 3: Dr Suspense \(£600\) (1) Cr Sales \(£600\) (1)
- Error 4: Dr Suspense \(£180\) (1) Cr T. Vance \(£180\) (1)
- Error 5: Dr Suspense \(£900\) (1) Cr Rent \(£900\) (1)
- Error 6: Dr Purchases \(£730\) (1) Cr S. Patel \(£730\) (1)

(b) Suspense account (8 marks total):
- Credit opening balance of \(£1,680\) with appropriate label (1)
- Debit entry Sales \(£600\) (2: 1 for label, 1 for amount)
- Debit entry T. Vance \(£180\) (2: 1 for label, 1 for amount)
- Debit entry Rent \(£900\) (2: 1 for label, 1 for amount)
- Account fully balanced/reconciled to nil (1)

(c) Corrected profit statement (11 marks total):
- Starting profit \(£42,500\) (1)
- Repair adjustment adding \(£3,600\) (2)
- Depreciation adjustment deducting \(£360\) (2)
- Sales adjustment adding \(£600\) (2)
- Rent adjustment adding \(£900\) (2)
- Purchases adjustment deducting \(£730\) (2)

(d) Error explanations (6 marks total):
- Correctly naming and defining error 1 (2 marks: 1 for name, 1 for definition) and linking to Julian's business (1 mark).
- Correctly naming and defining error 2 (2 marks: 1 for name, 1 for definition) and linking to Julian's business (1 mark).

(e) Evaluation (12 marks total):
- Level 1 (1-3 marks): Minimal awareness of control accounts/trial balance with unstructured comments.
- Level 2 (4-6 marks): Basic understanding, discussing either trial balance or control accounts with limited evaluation of both sides.
- Level 3 (7-9 marks): Balanced discussion of both trial balance and control accounts, including advantages and limitations. Basic conclusion drawn.
- Level 4 (10-12 marks): Comprehensive, well-structured evaluation showing deep understanding of internal control procedures. Clear judgment/conclusion directly addressing usefulness in maintaining accurate records.

WAC11 Section B

Answer THREE questions from a choice of four.
4 Question · 120 marks
Question 1 · partnership-accounts
30 marks
Alistair and Beatrice are in partnership sharing profits and losses in the ratio 3:2. The following trial balance was extracted from their books on 31 December 2022 before completing their final accounts:

| | Debit (£) | Credit (£) |
| :--- | :---: | :---: |
| Capital Account - Alistair | | 80,000 |
| Capital Account - Beatrice | | 50,000 |
| Current Account - Alistair | | 4,200 |
| Current Account - Beatrice | 1,800 | |
| Drawings - Alistair | 18,000 | |
| Drawings - Beatrice | 15,000 | |
| Trade Receivables | 40,000 | |
| Draft Net Profit for the year | | 48,500 |

**Additional information:**
1. The draft net profit of £48,500 for the year ended 31 December 2022 was calculated before adjusting for the following items:
- Rent paid in advance of £1,500 had been incorrectly recorded as an expense.
- A provision for doubtful debts is to be created at 2% of trade receivables.
- On 1 July 2022, Alistair provided a loan of £20,000 to the partnership at an interest rate of 8% per annum. No interest has yet been paid or recorded in the accounts.
2. The partnership agreement provides for:
- Interest on capital at 6% per annum on the fixed capital balances.
- A partnership salary of £12,000 per annum to Beatrice.
- Interest on drawings to be charged at 5% on total drawings for the year.

**Required:**

(a) Prepare a statement to calculate the revised net profit for the partnership for the year ended 31 December 2022. (6 marks)

(b) Prepare the Partnership Appropriation Account for the year ended 31 December 2022. (10 marks)

(c) Prepare the Current Accounts of Alistair and Beatrice for the year ended 31 December 2022. (8 marks)

(d) Evaluate the proposal that the partnership should maintain a fluctuating capital account system instead of keeping separate fixed capital and current accounts. (6 marks)
Show answer & marking scheme

Worked solution

### **(a) Statement to calculate Revised Net Profit for the year ended 31 December 2022**

| Item | Workings | Amount (£) |
| :--- | :--- | :---: |
| **Draft Net Profit** | Given | 48,500 |
| Add: Prepaid Rent | Prepaid expense added back | 1,500 |
| Less: Provision for Doubtful Debts | \( 2\% \times £40,000 \) | (800) |
| Less: Interest on Partner's Loan | \( £20,000 \times 8\% \times \frac{6}{12} \) | (800) |
| **Revised Net Profit** | | **48,400** |

---

### **(b) Partnership Appropriation Account for the year ended 31 December 2022**

| Item | Alistair (£) | Beatrice (£) | Total (£) |
| :--- | :---: | :---: | :---: |
| **Revised Net Profit** | | | **48,400** |
| **Add: Interest on Drawings** | | | |
| - Alistair (\( 5\% \times £18,000 \)) | 900 | | |
| - Beatrice (\( 5\% \times £15,000 \)) | | 750 | 1,650 |
| | | | **50,050** |
| **Less: Interest on Capital** | | | |
| - Alistair (\( 6\% \times £80,000 \)) | (4,800) | | |
| - Beatrice (\( 6\% \times £50,000 \)) | | (3,000) | (7,800) |
| **Less: Salary** (Beatrice) | | | (12,000) |
| **Residual Profit** | | | **30,250** |
| **Share of Profit (3:2)** | | | |
| - Alistair (\( \frac{3}{5} \times £30,250 \)) | 18,150 | | |
| - Beatrice (\( \frac{2}{5} \times £30,250 \)) | | 12,100 | **(30,250)** |

---

### **(c) Current Accounts for the year ended 31 December 2022**

**Alistair's Current Account**
* **Debits:**
- Drawings: £18,000
- Interest on drawings: £900
- Balance c/d: £8,250
- *Total: £27,150*
* **Credits:**
- Balance b/f: £4,200
- Interest on capital: £4,800
- Share of profit: £18,150
- *Total: £27,150*
- **Balance b/d (1 Jan 2023): £8,250 (Cr)**

**Beatrice's Current Account**
* **Debits:**
- Balance b/f: £1,800
- Drawings: £15,000
- Interest on drawings: £750
- Balance c/d: £9,550
- *Total: £27,100*
* **Credits:**
- Salary: £12,000
- Interest on capital: £3,000
- Share of profit: £12,100
- *Total: £27,100*
- **Balance b/d (1 Jan 2023): £9,550 (Cr)**

---

### **(d) Evaluation of Fluctuating Capital Accounts vs Fixed Capital Accounts**

* **Arguments for Fluctuating Capital Accounts:**
- **Simplicity:** Only one account is maintained per partner rather than two (Capital and Current), which reduces bookkeeping time and entries.
- **Direct Equity View:** Displays the entire net equity of each partner in a single account, making it easier to see their total investment status at any point in time.

* **Arguments against Fluctuating Capital Accounts (Maintaining Fixed Capital and Current Accounts):**
- **Capital Erosion:** Keeping capital fixed prevents partners from inadvertently withdrawing capital through drawings. A separate debit balance on a current account clearly signals that a partner is overdrawing beyond profit allocations.
- **Calculation of Interest:** It is easier to calculate interest on capital when capital balances remain fixed throughout the year.
- **Capital Contribution Ratio:** Fixed capital accounts clearly reflect the original agreed capital investment ratio between partners, which may differ from the profit-sharing ratio.

* **Conclusion:**
- The current system of maintaining fixed capital and current accounts is preferable as it provides better control over drawings, prevents capital erosion, and preserves clear evidence of capital contribution ratios.

Marking scheme

### **(a) Revised Net Profit calculation (6 marks)**
- **1 Mark (AO1)**: Draft Profit (£48,500)
- **1 Mark (AO2)**: Correct adjustment of prepaid rent (+£1,500)
- **2 Marks (AO2)**: Correct provision for doubtful debts expense (-£800) [1 mark calculation, 1 mark treatment]
- **2 Marks (AO2)**: Correct partner loan interest deduction (-£800) [1 mark calculation: \( £20,000 \times 8\% \times \frac{6}{12} \), 1 mark treatment]

### **(b) Partnership Appropriation Account (10 marks)**
- **1 Mark (AO1)**: Correctly starting with adjusted net profit of £48,400 (or of of own figure from (a))
- **2 Marks (AO2)**: Correctly calculating and adding Interest on drawings (Alistair: £900 [1 mark], Beatrice: £750 [1 mark])
- **2 Marks (AO2)**: Correctly calculating and deducting Interest on capital (Alistair: £4,800 [1 mark], Beatrice: £3,000 [1 mark])
- **1 Mark (AO1)**: Correctly deducting Beatrice's salary (£12,000)
- **1 Mark (AO1)**: Correct calculation of residual profit (£30,250)
- **3 Marks (AO2)**: Correct profit sharing calculation (Alistair: £18,150 [1.5 marks], Beatrice: £12,100 [1.5 marks])

### **(c) Current Accounts (8 marks)**
- **1 Mark (AO1)**: Correct balance b/f entries (Alistair: £4,200 Cr, Beatrice: £1,800 Dr)
- **1 Mark (AO1)**: Correct drawings posted to debit side (Alistair: £18,000, Beatrice: £15,000)
- **1 Mark (AO2)**: Correct interest on drawings posted to debit side (Alistair: £900, Beatrice: £750) [of if consistent with (b)]
- **1 Mark (AO2)**: Correct interest on capital posted to credit side (Alistair: £4,800, Beatrice: £3,000) [of if consistent with (b)]
- **1 Mark (AO1)**: Correct Beatrice salary posted to credit side (£12,000) [of if consistent with (b)]
- **1 Mark (AO2)**: Correct profit share posted to credit side (Alistair: £18,150, Beatrice: £12,100) [of if consistent with (b)]
- **2 Marks (AO2)**: Correct balancing and closing balances carried down/brought down (Alistair: £8,250 Cr [1 mark], Beatrice: £9,550 Cr [1 mark])

### **(d) Evaluation (6 marks)**
- **2 Marks (AO1 - Knowledge/Understanding)**: Identifies characteristics of both methods (e.g., fluctuating uses one account; fixed capital uses two accounts).
- **2 Marks (AO2 - Analysis/Application)**: Explains the impact of each choice (e.g., fluctuating accounts risk eroding core capital; current accounts allow easier monitoring of overdrawing and simple interest calculations).
- **2 Marks (AO3 - Evaluation)**: Provides a balanced conclusion recommending whether to change the system based on partnership stability and financial discipline.
Question 2 · essay
30 marks
Oakwood Furniture Ltd manufactures high-quality wooden desks. The management team is preparing its cash and operational budgets for the second quarter (April to June) of the upcoming financial year. The following information is available:

1. Forecast sales (in units) are as follows:
- April: 800 units
- May: 1,000 units
- June: 1,200 units
- July: 900 units

2. The standard selling price of each desk is $150. Sales are made on credit and collected as follows:
- 60% of sales revenue is received in the month of sale.
- 40% of sales revenue is received in the month following the sale.
- Trade receivables at 31 March are budgeted to be $45,000, which represents the remaining balance of March sales to be collected in April.

3. Inventory policy for finished goods:
- The inventory of finished desks at the end of each month must equal 20% of the next month's forecast sales in units.
- Finished goods inventory on 1 April is budgeted to be 160 units.

4. Raw material requirements (timber):
- Each desk requires 3 square metres of timber.
- The inventory of timber at the end of each month must equal 10% of the next month's production requirements in square metres.
- Timber inventory on 1 April is budgeted to be 240 square metres.
- The cost of timber is $12 per square metre, paid in the month of purchase.
- Production in July is estimated to be 950 units.

**Required:**

(a) Prepare the Production Budget (in units) for each of the months April, May, and June. (6 marks)

(b) Prepare the Purchases Budget for timber (in both square metres and value $) for the months of April and May. (10 marks)

(c) Prepare the Trade Receivables Cash Receipts Budget for April, May, and June. (8 marks)

(d) Evaluate the usefulness of budgeting for a business such as Oakwood Furniture Ltd. (6 marks)
Show answer & marking scheme

Worked solution

**(a) Production Budget (in units)**

| | April | May | June |
|---|---|---|---|
| Forecast Sales (units) | 800 | 1,000 | 1,200 |
| Add: Closing Inventory (20% of next month sales) | 200 *(20% of 1,000)* | 240 *(20% of 1,200)* | 180 *(20% of 900)* |
| **Total Needed** | **1,000** | **1,240** | **1,380** |
| Less: Opening Inventory | (160) | (200) | (240) |
| **Budgeted Production (units)** | **840** | **1,040** | **1,140** |

*(Note: July production is given as 950 units. Therefore, July raw material usage = 950 * 3 = 2,850 sq m)*

---

**(b) Material Purchases Budget (Timber)**

| | April | May |
|---|---|---|
| Production Units | 840 | 1,040 |
| Materials required per unit (sq m) | 3 | 3 |
| **Production Material Requirements (sq m)** | **2,520** | **3,120** |
| Add: Closing Inventory (10% of next month production req.) | 312 *(10% of May req: 3,120)* | 342 *(10% of June req: 1,140 * 3 = 3,420)* |
| **Total Material Needed (sq m)** | **2,832** | **3,462** |
| Less: Opening Inventory (sq m) | (240) | (312) |
| **Budgeted Purchases (sq m)** | **2,592** | **3,150** |
| Purchase Cost per sq metre | $12 | $12 |
| **Total Cost of Purchases ($)** | **$31,104** | **$37,800** |

---

**(c) Trade Receivables Cash Receipts Budget ($)**

- April Sales: 800 units * $150 = $120,000
- May Sales: 1,000 units * $150 = $150,000
- June Sales: 1,200 units * $150 = $180,000

| Receipts Source | April ($) | May ($) | June ($) |
|---|---|---|---|
| March Debtors Collected | 45,000 | - | - |
| April Sales (60% April, 40% May) | 72,000 | 48,000 | - |
| May Sales (60% May, 40% June) | - | 90,000 | 60,000 |
| June Sales (60% June) | - | - | 108,000 |
| **Total Cash Receipts** | **117,000** | **138,000** | **168,000** |

---

**(d) Evaluation of Budgeting for Oakwood Furniture Ltd**

**Arguments for:**
- **Planning and Coordination:** Budgeting helps Oakwood coordinate raw material purchasing (timber) and production levels to match projected sales volume, avoiding inventory stock-outs or expensive storage overages.
- **Control and Variance Analysis:** By comparing budgeted costs (such as the $12 per sq m of timber) and sales prices against actual figures, managers can identify inefficiency or favorable performances through variance reports.
- **Cash Flow Management:** Preparing cash receipt forecasts from credit customers ensures the business maintains adequate liquidity to settle liabilities like supplier payments.

**Arguments against:**
- **Uncertainty of Forecasts:** Consumer tastes or economic trends might change unexpectedly, rendering the sales projections inaccurate. As Oakwood sells high-quality furniture, sales are particularly sensitive to disposable income changes.
- **Time and Cost:** Budget preparation is a resource-intensive process that distracts managers from day-to-day operations.
- **Rigidity and Demotivation:** Strict targets may demotivate staff if they are unrealistic, or encourage budget padding (slack).

**Conclusion:**
Budgets are essential planning tools for Oakwood Furniture Ltd to maintain financial viability. However, they must be treated as flexible plans that are updated regularly to reflect real-market conditions rather than absolute mandates.

Marking scheme

**(a) Production Budget (in units): 6 marks**
- April: Correct closing inventory of 200 units (1 OF) and correct production of 840 units (1 OF).
- May: Correct closing inventory of 240 units (1 OF) and correct production of 1,040 units (1 OF).
- June: Correct closing inventory of 180 units (1 OF) and correct production of 1,140 units (1 OF).

**(b) Material Purchases Budget: 10 marks**
- Production material requirements (April: 2,520; May: 3,120) (1 mark for both).
- April Closing inventory of 312 sq m (2 marks if correct, 1 mark for showing 10% of May requirements).
- May Closing inventory of 342 sq m (2 marks if correct, 1 mark for showing 10% of June requirements of 3,420 sq m).
- Correct purchase quantities: April 2,592 sq m (1 OF) and May 3,150 sq m (1 OF).
- Correct purchase values: April $31,104 (1 OF) and May $37,800 (1 OF).
- Correct subtraction of opening inventory (1 mark).

**(c) Trade Receivables Cash Receipts Budget: 8 marks**
- Receipts from March Debtors in April: $45,000 (1 mark).
- April sales collection: $72,000 in April (1 mark) and $48,000 in May (1 mark).
- May sales collection: $90,000 in May (1 mark) and $60,000 in June (1 mark).
- June sales collection: $108,000 in June (1 mark).
- Correct monthly totals: April $117,000 (1 OF) and May $138,000 (1 OF) and June $168,000 (1 OF for both May/June).

**(d) Evaluation of Budgeting: 6 marks**
- 2 marks: Points in support of budgeting (planning, coordination, control, motivation).
- 2 marks: Points against budgeting (rigidity, time-consuming, dynamic market, unrealistic goals).
- 2 marks: Evaluative conclusion summarizing whether budgeting is beneficial for Oakwood Furniture Ltd.
Question 3 · essay
30 marks
VeloGear Ltd manufactures high-quality cycling helmets. The following trial balance excerpt and additional information were extracted from its books on 31 December 2023:

| Account | Debit (£) | Credit (£) |
| :--- | :---: | :---: |
| Revenue | | 520,000 |
| Inventory at 1 January 2023: | | |
| - Raw materials | 24,000 | |
| - Work in progress | 18,500 | |
| - Finished goods (at transfer price) | 46,200 | |
| Purchases of raw materials | 145,000 | |
| Carriage inwards on raw materials | 5,400 | |
| Factory direct wages | 96,000 | |
| Factory indirect wages | 38,000 | |
| Factory supervisor's salary | 28,000 | |
| Royalties | 12,000 | |
| Rent and rates | 40,000 | |
| Electricity and power | 32,000 | |
| Office salaries | 54,000 | |
| Factory machinery (at cost) | 150,000 | |
| Accumulated depreciation on factory machinery (1 January 2023) | | 60,000 |
| Office equipment (at cost) | 60,000 | |
| Provision for unrealised profit (1 January 2023) | | 4,200 |

**Additional information at 31 December 2023:**
1. Inventories at 31 December 2023:
- Raw materials: £21,500
- Work in progress: £16,200
- Finished goods (valued at transfer price): £49,500
2. Accrued wages at 31 December 2023:
- Factory direct wages: £4,000
- Factory indirect wages: £1,500
3. Rent and rates prepaid at 31 December 2023 was £4,000. Rent and rates are to be allocated: 75% to the factory and 25% to the administration.
4. Electricity and power accrued at 31 December 2023 was £3,000. Electricity and power are to be allocated: 80% to the factory and 20% to the administration.
5. Depreciation is to be charged as follows:
- Factory machinery at 20% per annum using the reducing balance method.
- Office equipment at 10% per annum using the straight-line method.
6. Finished goods are transferred from the factory to the warehouse at cost plus a manufacturing profit of 10%.

**Required:**
(a) Prepare the Manufacturing Account for VeloGear Ltd for the year ended 31 December 2023, showing clearly the Prime Cost, Cost of Production, and the Transfer Price to the warehouse. (14 marks)
(b) Prepare the Statement of Profit or Loss for VeloGear Ltd for the year ended 31 December 2023, showing the Gross Profit from trading, the Total Gross Profit, and the Profit for the Year. (10 marks)
(c) Explain the term 'prime cost' and give one example of direct expenses other than royalties and direct materials/labour. (2 marks)
(d) VeloGear Ltd is considering outsourcing the production of its cycling helmets to an external supplier who has offered to supply the helmets at a cost of £4.20 per helmet. VeloGear Ltd currently produces 100,000 helmets per year.
Evaluate whether VeloGear Ltd should continue to manufacture the helmets or buy them from the external supplier. (4 marks)
Show answer & marking scheme

Worked solution

(a) Manufacturing Account for VeloGear Ltd for the year ended 31 December 2023:

Opening Inventory of Raw Materials: £24,000
Add: Purchases of Raw Materials: £145,000
Add: Carriage Inwards: £5,400
Less: Closing Inventory of Raw Materials: (£21,500)
Cost of Raw Materials Consumed: £152,900
Add: Factory Direct Wages (£96,000 + £4,000): £100,000
Add: Royalties: £12,000
PRIME COST: £264,900

Factory Overheads:
Factory Indirect Wages (£38,000 + £1,500): £39,500
Factory Supervisor's Salary: £28,000
Rent and Rates (75% of (£40,000 - £4,000)): £27,000
Electricity and Power (80% of (£32,000 + £3,000)): £28,000
Depreciation on Factory Machinery (20% of (£150,000 - £60,000)): £18,000
Total Factory Overheads: £140,500

Total Manufacturing Cost: £405,400
Add: Opening Work in Progress: £18,500
Less: Closing Work in Progress: (£16,200)
COST OF PRODUCTION: £407,700
Add: Manufacturing Profit (10%): £40,770
TRANSFER PRICE TO WAREHOUSE: £448,470

(b) Statement of Profit or Loss for VeloGear Ltd for the year ended 31 December 2023:

Revenue: £520,000
Cost of Sales:
Opening Inventory of Finished Goods: £46,200
Add: Transfer from Factory: £448,470
Less: Closing Inventory of Finished Goods: (£49,500)
Cost of Sales: (£445,170)
Gross Profit from Trading: £74,830
Add: Manufacturing Profit: £40,770
Less: Increase in Provision for Unrealised Profit (£4,500 - £4,200): (£300)
Total Gross Profit: £115,300

Expenses:
Office Salaries: £54,000
Rent and Rates (25% of (£40,000 - £4,000)): £9,000
Electricity and Power (20% of (£32,000 + £3,000)): £7,000
Depreciation on Office Equipment (10% of £60,000): £6,000
Total Expenses: (£76,000)
PROFIT FOR THE YEAR: £39,300

(c) Prime cost is the sum of direct materials, direct labour, and direct expenses. It represents the direct costs that can be traced entirely to the production of a single unit of output. An example of a direct expense other than royalties is the hire of specialist machinery or software licenses required for a specific production run.

(d) Evaluation:
- Arguments for continuing to manufacture:
1. Financial: The current production cost per helmet is £4.08 (£407,700 / 100,000), whereas buying them costs £4.20 per helmet. It is cheaper to manufacture by £0.12 per helmet, saving £12,000 per year.
2. Fixed costs: If production is outsourced, fixed overheads like rent and rates (£27,000) and machinery depreciation (£18,000) may still be incurred, increasing the net cost of outsourcing further.
3. Quality and delivery control: In-house production ensures VeloGear Ltd maintains direct quality control over its high-quality cycling helmets and avoids supply chain disruptions.

- Arguments for buying from an external supplier:
1. Capacity: Outsourcing frees up factory floor space and resources, which could be used to manufacture other higher-margin products.
2. Reduction in operational risk: VeloGear Ltd would not have to manage factory labor, machinery breakdowns, or raw material supply issues.

- Conclusion:
VeloGear Ltd should continue to manufacture the helmets. It is financially cheaper by £12,000 per year, and manufacturing is a core competency that ensures the safety quality of cycling helmets is maintained.

Marking scheme

(a) Manufacturing Account [14 marks in total]:
- Raw materials consumed working/value: £152,900 [1 mark]
- Direct wages adjusted: £100,000 [1 mark]
- Royalties: £12,000 [1 mark]
- Prime cost: £264,900 [1 mark]
- Indirect wages adjusted: £39,500 [1 mark]
- Factory supervisor salary: £28,000 [1 mark]
- Rent and rates factory share: £27,000 [1 mark]
- Electricity & power factory share: £28,000 [1 mark]
- Depreciation factory machinery: £18,000 [1 mark]
- Work in progress adjustments: £18,500 and (£16,200) [1 mark for both]
- Cost of production: £407,700 [1 mark]
- Manufacturing profit: £40,770 [1 mark]
- Transfer price: £448,470 [1 mark]
- Correct presentation and headings [1 mark]

(b) Statement of Profit or Loss [10 marks in total]:
- Revenue: £520,000 [1 mark]
- Opening finished goods: £46,200 [1 mark]
- Transfer of finished goods: £448,470 [1 mark]
- Closing finished goods: £49,500 [1 mark]
- Gross Profit from Trading: £74,830 [1 mark]
- Manufacturing profit added: £40,770 [1 mark]
- Provision for unrealised profit adjustment: £300 [1 mark]
- Total Gross Profit: £115,300 [1 mark]
- Expenses (all 4 correctly adjusted and summed): £76,000 [1 mark]
- Profit for the year: £39,300 [1 mark]

(c) Prime cost definition and example [2 marks in total]:
- Explanation: Total of all direct costs of production (direct materials, direct labour, and direct expenses) [1 mark]
- Example: Hire of specialist tools/machinery, product design/patent costs, or licenses [1 mark]

(d) Evaluation [4 marks in total]:
- Up to 2 marks for analysis of financial benefits (e.g. current cost £4.08 vs £4.20, fixed costs continuing).
- Up to 2 marks for non-financial benefits (quality control, supplier reliance, capacity).
- 1 mark for a clear, justified conclusion/recommendation.
Question 4 · Ratio Analysis & Decision Making
30 marks
Oakwood Furniture Ltd is a medium-sized retail business selling home furnishings. The directors are concerned about the declining profitability and liquidity of the business despite an increase in total revenue during the last financial year. Given below is the financial information for the years ended 31 December 2022 and 31 December 2023.

**Extract from the Income Statement for the year ended 31 December:**

| | 2022 (£) | 2023 (£) |
|---|---|---|
| Revenue | 480 000 | 600 000 |
| Cost of sales | (300 000) | (420 000) |
| **Gross profit** | **180 000** | **180 000** |
| Operating expenses | (105 000) | (115 000) |
| **Operating profit** | **75 000** | **65 000** |
| Interest on Debentures | (5 000) | (5 000) |
| **Profit for the year** | **70 000** | **60 000** |


**Extract from the Statement of Financial Position as at 31 December:**

| | 2022 (£) | 2023 (£) |
|---|---|---|
| **Non-current assets** | 250 000 | 280 000 |
| **Current assets** | | |
| Inventory | 40 000 | 70 000 |
| Trade receivables | 35 000 | 65 000 |
| Bank | 15 000 | 5 000 |
| **Total current assets** | **90 000** | **140 000** |
| **Total assets** | **340 000** | **420 000** |
| | | |
| **Capital and reserves** | | |
| Ordinary share capital | 200 000 | 200 000 |
| Retained earnings | 60 000 | 70 000 |
| **Total equity** | **260 000** | **270 000** |
| **Non-current liabilities** | | |
| 10% Debentures | 50 000 | 50 000 |
| **Current liabilities** | | |
| Trade payables | 30 000 | 80 000 |
| Bank overdraft | - | 20 000 |
| **Total equity and liabilities** | **340 000** | **420 000** |

**Requirements:**

**(a)** Calculate the following ratios for **both** 2022 and 2023. Show your workings and state formulas where appropriate. (Round all percentages and ratios to **two decimal places**):
1. Gross profit percentage (margin)
2. Profit for the year to revenue percentage (net profit margin)
3. Return on Capital Employed (ROCE) using Operating Profit
4. Current ratio
5. Liquid (acid test) ratio
6. Inventory turnover (in days, using closing inventory)
*(12 marks)*

**(b)** Explain **two** reasons why the liquid (acid test) ratio is a more reliable measure of liquidity for a retail business than the current ratio.
*(4 marks)*

**(c)** The directors are considering offering a 5% trade discount to cash customers and reducing credit terms for credit customers from 60 days to 30 days to improve liquidity. Evaluate whether Oakwood Furniture Ltd should implement these proposed changes.
*(14 marks)*
Show answer & marking scheme

Worked solution

**Part (a)**

**1. Gross profit percentage (margin):**
Formula: \( (\text{Gross Profit} / \text{Revenue}) \times 100 \)
* **2022:** \( (180 000 / 480 000) \times 100 = 37.50\% \)
* **2023:** \( (180 000 / 600 000) \times 100 = 30.00\% \)

**2. Profit for the year to revenue percentage (net profit margin):**
Formula: \( (\text{Profit for the year} / \text{Revenue}) \times 100 \)
* **2022:** \( (70 000 / 480 000) \times 100 = 14.58\% \)
* **2023:** \( (60 000 / 600 000) \times 100 = 10.00\% \)

**3. Return on Capital Employed (ROCE):**
Formula: \( (\text{Operating Profit} / \text{Capital Employed}) \times 100 \)
Note: Capital Employed = Total Equity + Non-current Liabilities = £260 000 + £50 000 = £310 000 (2022) and £270 000 + £50 000 = £320 000 (2023).
* **2022:** \( (75 000 / 310 000) \times 100 = 24.19\% \)
* **2023:** \( (65 000 / 320 000) \times 100 = 20.31\% \)

**4. Current ratio:**
Formula: \( \text{Current Assets} : \text{Current Liabilities} \)
* **2022:** \( 90 000 : 30 000 = 3.00 : 1 \)
* **2023:** \( 140 000 : 100 000 = 1.40 : 1 \)

**5. Liquid (acid test) ratio:**
Formula: \( (\text{Current Assets} - \text{Inventory}) : \text{Current Liabilities} \)
* **2022:** \( (90 000 - 40 000) : 30 000 = 1.67 : 1 \)
* **2023:** \( (140 000 - 70 000) : 100 000 = 0.70 : 1 \)

**6. Inventory turnover (days):**
Formula: \( (\text{Closing Inventory} / \text{Cost of Sales}) \times 365 \)
* **2022:** \( (40 000 / 300 000) \times 365 = 48.67 \text{ days} \)
* **2023:** \( (70 000 / 420 000) \times 365 = 60.83 \text{ days} \)


**Part (b)**
Two reasons why the liquid (acid test) ratio is more reliable than the current ratio:
1. **Excludes Inventory:** Inventory is the least liquid of all current assets. In a furniture business, stock items might move slowly and cannot be immediately converted into cash to meet urgent short-term debts.
2. **Avoids overstating liquidity:** If a company has a massive level of slow-moving/obsolete inventory (as seen in the jump from £40,000 to £70,000), the current ratio may look healthy (1.40:1) while the company actually struggles with a cash deficit. The acid test excludes inventory and highlights actual liquidity strain (dropping to 0.70:1).


**Part (c)**

**Arguments in favor of the proposal:**
* **Accelerates cash inflows:** Offering a 5% trade discount to cash customers will incentivize immediate cash payments, which directly reduces the dependence on bank overdraft (£20,000 bank overdraft in 2023), helping to eliminate high-interest overdraft charges.
* **Reduces receivables collection period:** Tightening credit terms from 60 to 30 days will release the working capital locked in trade receivables, which has alarmingly risen from £35,000 to £65,000 in 2023.
* **Improves Liquidity ratios:** These combined efforts will raise cash balances, improving both the current and acid test ratios, moving closer to safe benchmarks.
* **Reduces Bad Debt exposure:** Quicker collections reduce the risk of credit defaults.

**Arguments against the proposal:**
* **Lowers profit margins:** Offering a 5% discount on cash sales will compress gross profit margins. The gross profit percentage has already declined from 37.50% to 30.00% in 2023; this action could damage profitability further.
* **Loss of competitive advantage:** Customers in the home furniture market often expect long credit terms. Forcing them to settle accounts in 30 days instead of 60 days could alienate regular customers and drive them to competitors, lowering overall sales volumes.
* **Administrative efforts:** Extra administration will be needed to enforce credit controls and ensure payments are received within the shorter 30-day limit.

**Conclusion / Evaluation:**
While the business's liquidity is in a critical state (indicated by a liquid ratio of 0.70:1 and a new bank overdraft of £20,000), implementing these measures too aggressively might lead to customer loss and further erode profitability (which is already declining, as seen in the drop in ROCE from 24.19% to 20.31%). The directors should consider a balanced approach: offer the discount selectively to high-volume buyers, and gradually reduce credit terms to 45 days first rather than instantly halving it to 30. Additionally, they must address their inventory management, as slow-moving inventory (turning over in 60.83 days up from 48.67) is a primary driver of the cash flow issue.

Marking scheme

**Part (a) - 12 Marks**
Give 1 mark for each correct calculation/ratio per year. Award method marks if there is an arithmetic error but correct formula/method is shown.
* Gross profit margin: 1 mark for 2022 (37.50%), 1 mark for 2023 (30.00%)
* Net profit margin: 1 mark for 2022 (14.58%), 1 mark for 2023 (10.00%)
* ROCE: 1 mark for 2022 (24.19%), 1 mark for 2023 (20.31%)
* Current ratio: 1 mark for 2022 (3.00:1), 1 mark for 2023 (1.40:1)
* Liquid ratio: 1 mark for 2022 (1.67:1), 1 mark for 2023 (0.70:1)
* Inventory turnover days: 1 mark for 2022 (48.67 days), 1 mark for 2023 (60.83 days)

**Part (b) - 4 Marks**
Award up to 2 marks per reason explained.
* Reason 1: Excludes inventory (1 mark) + explanation that inventory is slow-moving/difficult to convert to cash quickly (1 mark).
* Reason 2: Exposes structural cash flow/liquidity issues (1 mark) + explanation that a high current ratio can hide a severe cash deficit if inventory levels are bloated (1 mark).

**Part (c) - 14 Marks**
Use the Level-Based Marking Grid:
* **Level 1 (1–4 marks):** Basic points of knowledge identified. Very limited or no evaluation/application to the context.
* **Level 2 (5–8 marks):** Explains advantages/disadvantages of the discount and tighter credit terms. Standard application using calculations from Part (a). Balanced discussion lacks depth.
* **Level 3 (9–11 marks):** Good analysis of both cash discount and credit terms. Utilizes calculations (e.g., overdraft, decline in profitability, slow inventory turnover) to construct arguments. Balanced discussion leading to a clear conclusion.
* **Level 4 (12–14 marks):** Fully integrated and comprehensive evaluation. Critically discusses both the cash flow benefits and profitability drawbacks. Clear, logical recommendation or compromise strategy proposed based on the calculations.

WAC12 Section A

Answer BOTH questions. All calculations must be shown.
2 Question · 110 marks
Question 1 · subjective
55 marks
Aventis plc is a manufacturing company. The following trial balance was extracted from the books of the company on 31 December 2023:

| | Debit (£) | Credit (£) |
|---|---|---|
| Revenue | | 1,950,000 |
| Purchases | 1,050,000 | |
| Inventory (1 January 2023) | 140,000 | |
| Salaries and wages | 210,000 | |
| Other administrative expenses | 115,000 | |
| Other distribution costs | 75,000 | |
| Land (at cost) | 250,000 | |
| Buildings (at cost) | 500,000 | |
| Plant and Equipment (at cost) | 360,000 | |
| Accumulated depreciation (1 January 2023): | | |
| - Buildings | | 80,000 |
| - Plant and Equipment | | 120,000 |
| Trade receivables | 185,000 | |
| Allowance for doubtful debts (1 January 2023) | | 4,000 |
| Trade payables | | 112,000 |
| Bank | 186,000 | |
| Ordinary shares (£0.50 each) | | 400,000 |
| Share premium | | 80,000 |
| Retained earnings (1 January 2023) | | 125,000 |
| 8% Debentures (repayable 2030) | | 200,000 |
| **Total** | **3,071,000** | **3,071,000** |

**Adjustments and additional information at 31 December 2023:**
1. Inventory at 31 December 2023 was valued at a cost of £155,000. This includes some damaged items costing £12,000, which can be repaired at a cost of £2,000 and then sold for £9,000.
2. Depreciation is to be charged as follows:
- Buildings: 2% per annum on cost using the straight-line method. (Note: Land is not depreciated). Depreciation of buildings is to be allocated entirely to Administrative expenses.
- Plant and Equipment: 15% per annum using the reducing balance method. Depreciation of plant and equipment is to be allocated entirely to Cost of Sales.
3. Salaries and wages outstanding at 31 December 2023 were £15,000. Salaries and wages are to be allocated: 60% to Administrative expenses and 40% to Distribution costs.
4. Administrative expenses prepaid at 31 December 2023 were £5,000.
5. The allowance for doubtful debts is to be adjusted to 4% of trade receivables.
6. No interest has been paid or recorded during the year for the 8% debentures.
7. Taxation for the year is estimated at £24,000.
8. During the year, the land was revalued to £350,000. This revaluation has not yet been recorded in the books.

**Required:**

(a) Prepare the Statement of Profit or Loss and Other Comprehensive Income for Aventis plc for the year ended 31 December 2023. (20 marks)

(b) Prepare the Statement of Financial Position for Aventis plc as at 31 December 2023. (18 marks)

(c) Calculate the following ratios for Aventis plc at 31 December 2023 (show your workings and give your answers to two decimal places):
(i) Debt-to-Equity ratio (using non-current liabilities / total equity)
(ii) Gearing ratio (using non-current liabilities / total capital employed)
(iii) Return on Capital Employed (ROCE)
(5 marks)

(d) Aventis plc is considering raising an additional £300,000 to fund an expansion project. They are evaluating two options:
- **Option 1**: Issuing an additional £300,000 of 8% debentures.
- **Option 2**: Issuing 600,000 new ordinary shares at par value (£0.50 each).

Evaluate these two options from the perspective of gearing, risk, control, and profitability. Recommend which option Aventis plc should choose. (12 marks)
Show answer & marking scheme

Worked solution

### **(a) Statement of Profit or Loss and Other Comprehensive Income for the year ended 31 December 2023**

| | £ | £ |
|---|---|---|
| Revenue | | 1,950,000 |
| Cost of sales *(W1)* | | (1,076,000) |
| **Gross profit** | | **874,000** |
| Distribution costs *(W2)* | | (165,000) |
| Administrative expenses *(W3)* | | (258,400) |
| **Profit from operations (EBIT)** | | **450,600** |
| Finance costs *(W4)* | | (16,000) |
| **Profit before tax** | | **434,600** |
| Income tax expense | | (24,000) |
| **Profit for the year** | | **410,600** |
| **Other Comprehensive Income:** | | |
| Gain on revaluation of land *(W5)* | | 100,000 |
| **Total comprehensive income for the year** | | **510,600** |

**Workings:**
* **W1: Cost of Sales**
* Opening Inventory: £140,000
* Purchases: £1,050,000
* Less Closing Inventory: \(155,000 - (12,000 - (9,000 - 2,000)) = 155,000 - 5,000 = £(150,000)\)
* Depreciation of Plant & Equipment: \((360,000 - 120,000) \times 15\% = £36,000\)
* \(\text{Cost of Sales} = 140,000 + 1,050,000 - 150,000 + 36,000 = £1,076,000\)
* **W2: Distribution Costs**
* Salaries & Wages: \((210,000 + 15,000) \times 40\% = £90,000\)
* Other distribution costs: £75,000
* \(\text{Total} = 90,000 + 75,000 = £165,000\)
* **W3: Administrative Expenses**
* Salaries & Wages: \((210,000 + 15,000) \times 60\% = £135,000\)
* Other admin expenses: \(115,000 - 5,000 = £110,000\)
* Depreciation of Buildings: \(500,000 \times 2\% = £10,000\)
* Increase in allowance for doubtful debts: \((185,000 \times 4\%) - 4,000 = 7,400 - 4,000 = £3,400\)
* \(\text{Total} = 135,000 + 110,000 + 10,000 + 3,400 = £258,400\)
* **W4: Finance Costs**
* Debenture Interest accrued: \(200,000 \times 8\% = £16,000\)
* **W5: Gain on Revaluation of Land**
* Revalued Land (£350,000) - Historical Cost Land (£250,000) = £100,000

---

### **(b) Statement of Financial Position as at 31 December 2023**

| **ASSETS** | Cost / Revalued (£) | Accum. Depr (£) | Carrying Value (£) |
|---|---|---|---|
| **Non-current assets** | | | |
| Land and Buildings *(W6)* | 850,000 | 90,000 | 760,000 |
| Plant and Equipment | 360,000 | 156,000 | 204,000 |
| | **1,210,000** | **246,000** | **964,000** |
| **Current assets** | | | |
| Inventories *(W1)* | | | 150,000 |
| Trade receivables \((185,000 - 7,400)\) | | | 177,600 |
| Prepayments *(W3)* | | | 5,000 |
| Bank | | | 186,000 |
| **Total current assets** | | | **518,600** |
| **Total assets** | | | **1,482,600** |
| | | | |
| **EQUITY AND LIABILITIES** | | | |
| **Equity** | | | |
| Ordinary shares | | | 400,000 |
| Share premium | | | 80,000 |
| Revaluation reserve | | | 100,000 |
| Retained earnings \((125,000 + 410,600)\) | | | 535,600 |
| **Total Equity** | | | **1,115,600** |
| **Non-current liabilities** | | | |
| 8% Debentures | | | 200,000 |
| **Current liabilities** | | | |
| Trade payables | | | 112,000 |
| Accruals \((15,000 \text{ salaries} + 16,000 \text{ interest})\) | | | 31,000 |
| Taxation payable | | | 24,000 |
| **Total current liabilities** | | | **167,000** |
| **Total equity and liabilities** | | | **1,482,600** |

**Workings:**
* **W6: Land & Buildings**
* Land: revalued to £350,000 (no depr).
* Buildings: cost £500,000. Accumulated depreciation = \(80,000 + 10,000 = £90,000\). Carrying value = £410,000.
* Total Land & Buildings Carrying Value = \(350,000 + 410,000 = £760,000\).

---

### **(c) Ratio Calculations**

* **Capital Employed** = \(\text{Total Equity} + \text{Non-current liabilities} = 1,115,600 + 200,000 = £1,315,600\)

**(i) Debt-to-Equity Ratio**
$$\text{Debt-to-Equity} = \frac{\text{Non-current Liabilities}}{\text{Total Equity}} \times 100 = \frac{200,000}{1,115,600} \times 100 = 17.93\%$$

**(ii) Gearing Ratio**
$$\text{Gearing Ratio} = \frac{\text{Non-current Liabilities}}{\text{Capital Employed}} \times 100 = \frac{200,000}{1,315,600} \times 100 = 15.20\%$$

**(iii) Return on Capital Employed (ROCE)**
$$\text{ROCE} = \frac{\text{Profit from Operations (EBIT)}}{\text{Capital Employed}} \times 100 = \frac{450,600}{1,315,600} \times 100 = 34.25\%$$

---

### **(d) Evaluation of Options**

* **Option 1: £300,000 of 8% Debentures**
* **Gearing & Financial Risk**: Increases long-term debt to £500,000. The gearing ratio will rise from 15.20% to \(\frac{500,000}{1,615,600} \times 100 = 30.95\%\). While this is still a moderate level of gearing (below 50%), it represents a significant increase in financial risk. Interest charges will increase by £24,000 per annum (total £40,000), which must be paid regardless of profit levels.
* **Control**: There is no dilution of ownership or voting power for existing shareholders.
* **Profitability/Taxation**: Interest is a tax-deductible expense, which reduces taxable profit and the tax burden. Furthermore, since ROCE is currently high at 34.25%, which is much higher than the interest rate of 8%, borrowing to invest will create positive leverage, boosting returns to ordinary shareholders.

* **Option 2: 600,000 Ordinary Shares at par value**
* **Gearing & Financial Risk**: Equity will increase by £300,000, and long-term debt remains £200,000. Capital employed increases to £1,615,600. The gearing ratio falls to \(\frac{200,000}{1,615,600} \times 100 = 12.38\%\). Financial risk is minimized as there are no compulsory interest payments.
* **Control**: Issuing 600,000 new shares (bringing the total to 1,400,000 shares) will dilute the control of existing shareholders if they do not purchase these shares pro-rata.
* **Profitability**: Dividends are not tax-deductible and are paid out of post-tax profits. Earnings per share (EPS) may be diluted in the short run until the new project starts generating returns.

* **Conclusion / Recommendation**:
Aventis plc should choose **Option 1 (Debentures)**. The current gearing ratio is very low (15.20%), and even after the issue, gearing will remain low-to-moderate at 30.95%. Given that the current ROCE (34.25%) is significantly higher than the debenture interest cost (8.00%), the company can successfully utilize debt leverage to increase shareholder wealth without diluting ownership control.

Marking scheme

### **(a) Statement of Profit or Loss and Other Comprehensive Income (20 Marks)**
- Revenue: **(1)** for £1,950,000
- Opening inventory & Purchases: **(1)** for both correct values in cost of sales calculation
- Closing inventory adjustment: **(2)** for £150,000 [1 mark for net realizable value logic, 1 mark for final closing inventory]
- Plant & Equipment depreciation: **(2)** for £36,000 [1 mark for reducing balance calculation, 1 mark for correct treatment in cost of sales]
- Gross Profit: **(1 OF)** for £874,000 (following student's COS)
- Salaries allocation (Distribution): **(1)** for £90,000
- Other distribution costs: **(1)** for £75,000
- Salaries allocation (Administrative): **(1)** for £135,000
- Other administrative expenses: **(1)** for £110,000
- Buildings depreciation: **(1)** for £10,000
- Allowance for doubtful debts adjustment: **(2)** for £3,400 [1 mark for correct new provision £7,400, 1 mark for increase of £3,400 charged to P&L]
- Profit from Operations: **(1 OF)** for £450,600
- Finance costs: **(1)** for £16,000 (accrued)
- Taxation: **(1)** for £24,000
- Profit for the year: **(1 OF)** for £410,600
- Gain on revaluation of land: **(2)** for £100,000 [1 mark for OCI presentation, 1 mark for amount]

### **(b) Statement of Financial Position (18 Marks)**
- Land & Buildings carrying value: **(2)** for £760,000 [1 mark for land revalued at £350,000, 1 mark for buildings NBV £410,000]
- Plant & Equipment carrying value: **(2)** for £204,000 [1 mark for cost £360,000, 1 mark for total accumulated depr £156,000]
- Inventories: **(1 OF)** for £150,000
- Trade receivables: **(2)** for £177,600 [1 mark for net of allowance, 1 mark for correct amount]
- Prepayments: **(1)** for £5,000
- Bank: **(1)** for £186,000
- Ordinary shares & Share premium: **(1)** for both correct (£400,000 & £80,000)
- Revaluation reserve: **(1 OF)** for £100,000
- Retained earnings: **(2 OF)** for £535,600 [1 mark for opening + profit for the year, 1 mark for final correct amount]
- 8% Debentures (Non-current liabilities): **(1)** for £200,000
- Trade payables: **(1)** for £112,000
- Accruals: **(2)** for £31,000 [1 mark for showing both salaries £15,000 and interest £16,000 accrued, 1 mark for final sum]
- Taxation payable: **(1)** for £24,000

### **(c) Ratio Calculations (5 Marks)**
- **(i) Debt-to-Equity Ratio**: **(1 OF)** for \(17.93\%\) (workings must be shown)
- **(ii) Gearing Ratio**: **(2 OF)** [1 mark for formula/denominator of £1,315,600, 1 mark for final answer of \(15.20\%\)]
- **(iii) ROCE**: **(2 OF)** [1 mark for formula/EBIT, 1 mark for final answer of \(34.25\%\)]

### **(d) Evaluation & Recommendation (12 Marks)**
- **AO1 (Knowledge and Understanding - 3 marks)**: Demonstrates clear understanding of gearing, interest obligations, and equity dilution.
- **AO2 (Application - 3 marks)**: Applies ratios calculated in (c) to discuss both options (e.g., gearing rises to 30.95% or falls to 12.38%; ROCE is 34.25% vs 8% cost of debt).
- **AO3 (Analysis - 3 marks)**: Analyzes the effects of leverage, tax deductibility of interest, control dilution of issuing 600,000 shares, and risk of fixed interest.
- **AO4 (Evaluation/Recommendation - 3 marks)**: Provides a balanced, well-supported recommendation on whether to choose Option 1 or Option 2 based on risk and reward profile of the company.
Question 2 · essay
55 marks
Zephyr Electronics Ltd manufactures three types of smart sensors: Standard, Advanced, and Premium. The following budgeted information is available for the upcoming production period:

\begin{tabular}{lccc}
\hline
\textbf{Per Unit Data} & \textbf{Standard} & \textbf{Advanced} & \textbf{Premium} \\
\hline
Selling price & £40 & £65 & £90 \\
Direct materials (at £6 per kg) & £12 & £18 & £24 \\
Direct labour (at £10 per hour) & £10 & £20 & £30 \\
Variable overheads & £3 & £5 & £8 \\
\hline
\textbf{Maximum Market Demand (units)} & 3,000 & 2,500 & 1,500 \\
\hline
\end{tabular}

**Additional Information:**
1. Total fixed overheads for the period are budgeted at £42,000.
2. Due to global supply shortages, the availability of the raw material (silicon substrate used for direct materials) is strictly limited to 12,000 kg for the upcoming period.
3. The company is considering replacing its legacy costing system with an integrated Enterprise Resource Planning (ERP) system to improve inventory control and real-time management accounting reporting.

**Required:**

**(a)** State **four** basic assumptions of marginal costing. *(4 marks)*

**(b)**
(i) Calculate the contribution per unit for each of the three types of sensors. *(6 marks)*
(ii) Calculate the contribution per kg of direct material for each sensor and determine the ranking order of production. *(6 marks)*
(iii) Prepare the optimal production plan for the upcoming period, showing the allocation of direct materials (in kg) and the number of units of each product to be produced. *(6 marks)*

**(c)** Prepare a budgeted marginal costing statement to show the maximum net profit achievable for the period under the optimal production plan. *(8 marks)*

**(d)** An alternative supplier has offered to sell Zephyr Electronics Ltd an additional 4,000 kg of the same high-quality direct material, but at a premium price of £8.50 per kg (instead of the normal price of £6.00 per kg).

Calculate the revised optimal production plan and evaluate the financial viability of this proposal, showing the overall change in budgeted net profit if the offer is accepted. *(9 marks)*

**(e)** Discuss how the implementation of an Enterprise Resource Planning (ERP) system would benefit Zephyr Electronics Ltd's management accounting and inventory control functions. *(8 marks)*

**(f)** Evaluate whether Zephyr Electronics Ltd should accept the alternative supplier's offer to purchase the additional materials at a premium. You should consider both financial and non-financial factors in your response. *(8 marks)*
Show answer & marking scheme

Worked solution

**(a) Assumptions of Marginal Costing:**
1. All costs can be clearly classified into fixed and variable components.
2. Total fixed costs remain constant throughout the relevant range of activity.
3. Variable cost per unit remains constant at all levels of output.
4. Selling price per unit remains constant regardless of volume sold.
5. Technology and efficiency levels of production remain unchanged.
*(Any 4 points for 1 mark each)*

**(b) (i) Contribution per unit:**
* **Standard:**
\( \text{Selling Price} = £40 \)
\( \text{Variable Costs} = £12 \text{ (materials)} + £10 \text{ (labour)} + £3 \text{ (overheads)} = £25 \)
\( \text{Contribution per unit} = £40 - £25 = £15 \)
* **Advanced:**
\( \text{Selling Price} = £65 \)
\( \text{Variable Costs} = £18 \text{ (materials)} + £20 \text{ (labour)} + £5 \text{ (overheads)} = £43 \)
\( \text{Contribution per unit} = £65 - £43 = £22 \)
* **Premium:**
\( \text{Selling Price} = £90 \)
\( \text{Variable Costs} = £24 \text{ (materials)} + £30 \text{ (labour)} + £8 \text{ (overheads)} = £62 \)
\( \text{Contribution per unit} = £90 - £62 = £28 \)

**(ii) Contribution per kg of direct material & Ranking:**
* Direct material cost is £6 per kg.
* **Standard:**
\( \text{Material per unit} = \frac{£12}{£6} = 2 \text{ kg} \)
\( \text{Contribution per kg} = \frac{£15}{2 \text{ kg}} = £7.50 \text{ per kg} \)
* **Advanced:**
\( \text{Material per unit} = \frac{£18}{£6} = 3 \text{ kg} \)
\( \text{Contribution per kg} = \frac{£22}{3 \text{ kg}} = £7.33 \text{ per kg} \)
* **Premium:**
\( \text{Material per unit} = \frac{£24}{£6} = 4 \text{ kg} \)
\( \text{Contribution per kg} = \frac{£28}{4 \text{ kg}} = £7.00 \text{ per kg} \)

**Ranks:**
1st: Standard (£7.50/kg)
2nd: Advanced (£7.33/kg)
3rd: Premium (£7.00/kg)

**(iii) Optimal Production Plan (Total Materials = 12,000 kg):**
1. **Standard (1st Rank):**
Produce maximum demand of 3,000 units.
\( \text{Materials used} = 3,000 \text{ units} \times 2 \text{ kg} = 6,000 \text{ kg} \)
\( \text{Remaining materials} = 12,000 - 6,000 = 6,000 \text{ kg} \)
2. **Advanced (2nd Rank):**
Allocate remaining 6,000 kg.
\( \text{Units produced} = \frac{6,000 \text{ kg}}{3 \text{ kg/unit}} = 2,000 \text{ units} \) (Demand is 2,500 units, so 2,000 units is acceptable).
\( \text{Remaining materials} = 0 \text{ kg} \)
3. **Premium (3rd Rank):**
No materials remaining.
\( \text{Units produced} = 0 \text{ units} \).

**Optimal Plan summary:**
* Standard: 3,000 units
* Advanced: 2,000 units
* Premium: 0 units

**(c) Budgeted Marginal Costing Statement:**

\begin{tabular}{lrrr}
\hline
& \textbf{Standard} & \textbf{Advanced} & \textbf{Total} \\
\hline
Units & 3,000 & 2,000 & \\
& £ & £ & £ \\
Revenue & 120,000 & 130,000 & 250,000 \\
Less: Variable Costs & (75,000) & (86,000) & (161,000) \\
\hline
**Contribution** & **45,000** & **44,000** & **89,000** \\
Less: Fixed Costs & & & (42,000) \\
\hline
**Net Profit** & & & **47,000** \\
\hline
\end{tabular}

**(d) Revised Optimal Production Plan & Financial Viability:**
* Additional materials available = 4,000 kg.
* Total available materials = \( 12,000 \text{ kg} + 4,000 \text{ kg} = 16,000 \text{ kg} \).
* We must first satisfy the original plan from part (b) using the cheaper regular stock. Then, the extra 4,000 kg (costing £8.50 per kg) will be allocated based on our priority rankings to satisfy outstanding demand.
* Outstanding demand:
* Standard: Completed (0 units outstanding)
* Advanced: Demand is 2,500 units; we already made 2,000 units. Outstanding = 500 units. Requires \( 500 \times 3 \text{ kg} = 1,500 \text{ kg} \).
* Premium: Outstanding = 1,500 units. Requires \( 1,500 \times 4 \text{ kg} = 6,000 \text{ kg} \).

**Allocation of premium materials (4,000 kg):**
1. **Advanced (Rank 2):** Produce remaining 500 units using 1,500 kg.
\( \text{Remaining premium materials} = 4,000 - 1,500 = 2,500 \text{ kg} \).
2. **Premium (Rank 3):** Allocate remaining 2,500 kg to Premium production.
\( \text{Units of Premium produced} = \frac{2,500 \text{ kg}}{4 \text{ kg/unit}} = 625 \text{ units} \).

**Revised Production Plan:**
* Standard: 3,000 units
* Advanced: 2,500 units
* Premium: 625 units

**Financial Viability / Change in profit:**
* Incremental units produced and sold:
* Advanced: 500 units
* Premium: 625 units
* Incremental contribution from extra units using standard costs:
* Advanced: \( 500 \text{ units} \times £22 = £11,000 \)
* Premium: \( 625 \text{ units} \times £28 = £17,500 \)
* Total standard incremental contribution = \( £11,000 + £17,500 = £28,500 \)
* Less: Premium surcharge paid on materials:
* Additional price per kg = \( £8.50 - £6.00 = £2.50 \text{ per kg} \)
* Total premium paid = \( 4,000 \text{ kg} \times £2.50 = £10,000 \)
* **Net Incremental Profit** = \( £28,500 - £10,000 = £18,500 \).

Since net profit increases by £18,500 (revised net profit = \( £47,000 + £18,500 = £65,500 \)), the proposal is financially viable.

**(e) ERP System Benefits:**
1. **Real-Time Data Access:** ERP integrates sales, inventory, and finance departments, giving management accountants real-time feedback on product contribution margins and actual versus budgeted material consumption.
2. **Improved Material Requirements Planning (MRP):** Real-time monitoring of raw materials ensures that stockouts of key limiting factors (such as silicon substrate) are minimized, and automatically updates production plans when resource constraints change.
3. **Reduced Waste and Inventory Holding Costs:** By implementing Just-In-Time (JIT) scheduling within the ERP, inventory levels can be kept optimal, minimizing holding costs and waste due to obsolescence.
4. **Accurate Standard Costing & Variance Analysis:** Direct materials usage and actual direct labour hours are automatically tracked through shop floor scanning, allowing for rapid calculation of variances and quick corrective actions.

**(f) Evaluation of the Alternative Supplier Offer:**
* **Arguments for accepting:**
* Net profit increases by £18,500 (from £47,000 to £65,500), which represents a 39.4% profit growth.
* Allows the company to meet the full market demand for Standard and Advanced sensors, maintaining market share and protecting long-term buyer relationships.
* Enables the launch of the Premium sensor line (producing 625 units), which generates brand presence and lets Zephyr capture high-end customers.
* Utilises spare assembly capacity (labour hours), as the initial plan left labourers underutilised.
* **Arguments against / Risks:**
* Quality issues: The quality of the silicon substrate from the alternative supplier must be verified. Poor materials could cause sensor failure, increase scrap rates, or lead to customer returns/damage to reputation.
* Reliability: Delay in deliveries from the new supplier could disrupt production flow and lead to idle time costs.
* Price pressure: Setting a precedent of purchasing at £8.50 per kg may hurt relationships with the existing supplier or reduce overall gross margin percentages.
* **Conclusion:**
Zephyr Electronics Ltd should accept the alternative supplier's offer. The financial gain of £18,500 is very significant. However, the purchase should be subject to strict quality control, sample testing of the first batch, and contract terms that guarantee delivery dates.

Marking scheme

**(a) Assumptions of Marginal Costing (Max 4 marks):**
* 1 mark for each valid assumption listed (up to 4).

**(b) Breakdowns (Total 18 marks):**
* **(i) Contribution per unit (6 marks):**
* 2 marks for Standard (1 calculation, 1 answer)
* 2 marks for Advanced (1 calculation, 1 answer)
* 2 marks for Premium (1 calculation, 1 answer)
* **(ii) Contribution per kg and Ranking (6 marks):**
* 3 marks (1 mark for each sensor's correct contribution per kg: Standard = £7.50, Advanced = £7.33, Premium = £7.00)
* 3 marks (1 mark for each correct ranking: Standard 1st, Advanced 2nd, Premium 3rd)
* **(iii) Optimal Production Plan (6 marks):**
* 2 marks for Standard (3,000 units, 6,000 kg)
* 2 marks for Advanced (2,000 units, 6,000 kg)
* 2 marks for Premium (0 units, 0 kg)

**(c) Budgeted Marginal Costing Statement (8 marks):**
* 1 mark for correct total revenue (£250,000)
* 2 marks for variable costs of Standard (£75,000) and Advanced (£86,000)
* 2 marks for correct individual contributions and total contribution (£89,000)
* 1 mark for fixed costs (£42,000)
* 2 marks for final correct profit (£47,000)

**(d) Proposal Analysis (9 marks):**
* 2 marks for revised production units (Advanced = 500 units, Premium = 625 units)
* 2 marks for showing calculation of incremental contribution before premium (Advanced: £11,000; Premium: £17,500)
* 2 marks for calculating total premium cost of materials (4,000 kg * £2.50 = £10,000)
* 2 marks for correct final incremental profit calculation (£18,500)
* 1 mark for a clear financial viability statement.

**(e) ERP Benefits (8 marks):**
* Up to 2 marks per benefit discussed (1 mark for identifying, 1 mark for analytical development/linking to inventory control or management accounting context) - max 4 benefits.

**(f) Evaluation (8 marks):**
* 2 marks for arguments in favour (financial profit and market share aspects).
* 2 marks for arguments against (quality, supplier reliability, and margin compression risks).
* 2 marks for quality of accounting terminology and structure.
* 2 marks for a clear, reasoned recommendation.

WAC12 Section B

Answer THREE questions from a choice of four.
4 Question · 120 marks
Question 1 · Standard Costing & Variance Analysis
30 marks

Veloce Bikes Ltd manufactures a specialized electric scooter frame, Model E-1. The company uses a standard costing system. The standard cost details for the production of one unit of Model E-1 are as follows:

  • Direct Materials: 4 kg @ $12 per kg = $48
  • Direct Labour: 3 hours @ $15 per hour = $45

The budgeted production for October 2023 was 1,500 units of Model E-1.

Actual production and cost data for October 2023 were as follows:

  • Actual production: 1,400 units
  • Direct Materials purchased and used: 5,800 kg at a total cost of $66,700
  • Direct Labour: 4,100 hours paid at a total cost of $63,550

Required:

(a) Calculate the following variances for October 2023, clearly indicating whether each variance is Favourable (F) or Adverse (A):
(i) Direct material price variance [4 marks]
(ii) Direct material usage variance [4 marks]
(iii) Direct labour rate variance [4 marks]
(iv) Direct labour efficiency variance [4 marks]

(b) Prepare a reconciliation statement for October 2023, starting with the standard cost of actual production and reconciling to the actual cost of production for both direct materials and direct labour combined. [8 marks]

(c) Evaluate the performance of the production and purchasing departments for October 2023, explaining the possible interrelationships between the calculated variances. [6 marks]

Show answer & marking scheme

Worked solution

(a) Variance Calculations:

(i) Direct Material Price Variance
\(\text{Actual Price (AP)} = \frac{\$66,700}{5,800 \text{ kg}} = \$11.50 \text{ per kg}\)
\(\text{Material Price Variance} = (\text{Standard Price} - \text{Actual Price}) \times \text{Actual Quantity}\)
\(= (\$12.00 - \$11.50) \times 5,800 \text{ kg} = \$0.50 \times 5,800 = \$2,900 \text{ Favourable (F)}\)

(ii) Direct Material Usage Variance
\(\text{Standard Quantity for actual production (SQ)} = 1,400 \text{ units} \times 4 \text{ kg} = 5,600 \text{ kg}\)
\(\text{Material Usage Variance} = (\text{Standard Quantity} - \text{Actual Quantity}) \times \text{Standard Price}\)
\(= (5,600 \text{ kg} - 5,800 \text{ kg}) \times \$12.00 = -200 \text{ kg} \times \$12.00 = \$2,400 \text{ Adverse (A)}\)

(iii) Direct Labour Rate Variance
\(\text{Actual Rate (AR)} = \frac{\$63,550}{4,100 \text{ hours}} = \$15.50 \text{ per hour}\)
\(\text{Labour Rate Variance} = (\text{Standard Rate} - \text{Actual Rate}) \times \text{Actual Hours}\)
\(= (\$15.00 - \$15.50) \times 4,100 \text{ hours} = -\$0.50 \times 4,100 = \$2,050 \text{ Adverse (A)}\)

(iv) Direct Labour Efficiency Variance
\(\text{Standard Hours for actual production (SH)} = 1,400 \text{ units} \times 3 \text{ hours} = 4,200 \text{ hours}\)
\(\text{Labour Efficiency Variance} = (\text{Standard Hours} - \text{Actual Hours}) \times \text{Standard Rate}\)
\(= (4,200 \text{ hours} - 4,100 \text{ hours}) \times \$15.00 = 100 \text{ hours} \times \$15.00 = \$1,500 \text{ Favourable (F)}\)

(b) Reconciliation Statement:

Reconciliation of Direct Costs for October 2023$$Standard Cost of Actual Production (1,400 units):Direct Materials (\(1,400 \times \$48\))67,200Direct Labour (\(1,400 \times \$45\))63,000130,200Add: Adverse VariancesDirect Material Usage Variance2,400Direct Labour Rate Variance2,0504,450134,650Less: Favourable VariancesDirect Material Price Variance(2,900)Direct Labour Efficiency Variance(1,500)(4,400)Actual Cost of Production:130,250

Check: Actual Cost of Materials ($66,700) + Actual Cost of Labour ($63,550) = $130,250.

(c) Evaluation:
The total standard cost budgeted for the actual level of output ($130,200) was very close to the actual cost incurred ($130,250), representing an overall minor adverse net variance of just $50. However, this overall result masks some significant individual variances and interrelationships:
1. Material Trade-off: There is a clear link between the Favourable Material Price Variance ($2,900 F) and the Adverse Material Usage Variance ($2,400 A). The purchasing manager bought cheaper materials (saving $0.50/kg). However, this lower-cost material may have been of inferior quality, leading to higher wastage, rejects, and overall material usage being 200 kg over standard. Since the net effect is positive ($500 F), the purchase could be seen as financially viable, but it could risk final product quality.
2. Labour Trade-off: There is a clear link between the Adverse Labour Rate Variance ($2,050 A) and the Favourable Labour Efficiency Variance ($1,500 F). The company paid a higher average wage rate ($15.50 vs $15.00 standard). This could be due to employing more skilled workers or paying overtime rates. This higher skill level directly contributed to completing the production in 100 fewer hours than standard (efficiency savings of $1,500). Financially, the net labour impact is negative ($550 A), indicating the extra wage premium paid was higher than the value of time saved.

Marking scheme

(a) Variances [16 Marks total]:
- (i) Material Price Variance: 1 mark for calculating actual price $11.50/kg, 1 mark for formula/working, 1 mark for $2,900, 1 mark for Favourable (F). [4 marks]
- (ii) Material Usage Variance: 1 mark for calculating standard quantity 5,600 kg, 1 mark for formula/working, 1 mark for $2,400, 1 mark for Adverse (A). [4 marks]
- (iii) Labour Rate Variance: 1 mark for calculating actual rate $15.50/hr, 1 mark for formula/working, 1 mark for $2,050, 1 mark for Adverse (A). [4 marks]
- (iv) Labour Efficiency Variance: 1 mark for calculating standard hours 4,200 hours, 1 mark for formula/working, 1 mark for $1,500, 1 mark for Favourable (F). [4 marks]

(b) Reconciliation Statement [8 Marks total]:
- 1 mark for correct Standard Material Cost ($67,200) and Standard Labour Cost ($63,000) leading to Total Standard Cost ($130,200).
- 2 marks for listing both adverse variances with correct figures ($2,400 and $2,050) and adding them.
- 2 marks for listing both favourable variances with correct figures ($2,900 and $1,500) and subtracting them.
- 1 mark for showing correct final Actual Cost total ($130,250).
- 2 marks for overall layout, professional presentation, and correct arithmetic alignment.

(c) Evaluation [6 Marks total]:
- 1 mark for identifying the net overall cost variance is minimal ($50 adverse).
- 2 marks for discussing the material interrelationship (cheaper price leading to higher waste/usage) and its implications.
- 2 marks for discussing the labour interrelationship (higher rate paid leading to improved/favourable efficiency) and its financial outcome.
- 1 mark for a concluding recommendation or quality concern point (e.g., impact of cheaper materials on scooter frames).
Question 2 · structured
30 marks
Hesperis plc is an energy storage company listed on the stock exchange. The following information has been extracted from its financial records for the year ended 31 December 2023:

- Issued share capital: 5,000,000 Ordinary shares of £0.50 each
- 8% Preference shares of £1.00 each: 1,000,000 shares
- Retained earnings at 31 December 2023: £1,800,000
- Operating profit (Profit before interest and tax): £1,200,000
- Finance costs (6% Debentures): £120,000
- Taxation for the year: £216,000
- Ordinary dividend paid/proposed: £300,000
- Preference dividend paid/proposed: £80,000
- Market price per ordinary share at 31 December 2023: £2.40

**Required:**

**(a)** Calculate the following investment ratios for the year ended 31 December 2023, showing your workings and rounding to two decimal places:
(i) Earnings per share (EPS) (in pence) **(4 marks)**
(ii) Price earnings (P/E) ratio **(3 marks)**
(iii) Dividend yield **(3 marks)**
(iv) Dividend cover **(3 marks)**
(v) Dividend payout ratio **(3 marks)**

**(b)** Calculate the book value (net asset value) per ordinary share at 31 December 2023. **(4 marks)**

**(c)** Evaluate whether a potential investor should purchase ordinary shares in Hesperis plc. You should consider both the financial indicators calculated and relevant non-financial factors. **(10 marks)**
Show answer & marking scheme

Worked solution

**(a) Investment Ratios Calculation:**

**(i) Earnings per share (EPS):**
- \(\text{Profit for the year} = \text{Operating profit} - \text{Finance costs} - \text{Taxation}\)
- \(\text{Profit for the year} = £1,200,000 - £120,000 - £216,000 = £864,000\)
- \(\text{Earnings attributable to ordinary shareholders} = \text{Profit for the year} - \text{Preference dividends} = £864,000 - £80,000 = £784,000\)
- \(\text{Number of ordinary shares} = 5,000,000\)
- \(\text{EPS} = \frac{£784,000}{5,000,000} = £0.1568\) or **15.68p**

**(ii) Price earnings (P/E) ratio:**
- \(\text{P/E ratio} = \frac{\text{Market price per share}}{\text{Earnings per share}} = \frac{£2.40}{£0.1568} = \mathbf{15.31\text{ times}}\)

**(iii) Dividend yield:**
- \(\text{Dividend per ordinary share (DPS)} = \frac{£300,000}{5,000,000} = £0.06\) or **6p**
- \(\text{Dividend yield} = \frac{\text{DPS}}{\text{Market price}} \times 100\% = \frac{6\text{p}}{240\text{p}} \times 100\% = \mathbf{2.50\%}\)

**(iv) Dividend cover:**
- \(\text{Dividend cover} = \frac{\text{Earnings per share}}{\text{Dividend per share}} = \frac{15.68\text{p}}{6\text{p}} = \mathbf{2.61\text{ times}}\)
- *(Alternative calculation: \(\frac{£784,000}{£300,000} = 2.61\text{ times}\))*

**(v) Dividend payout ratio:**
- \(\text{Dividend payout ratio} = \frac{\text{Dividend per share}}{\text{Earnings per share}} \times 100\% = \frac{6\text{p}}{15.68\text{p}} \times 100\% = \mathbf{38.27\%}\)
- *(Alternative calculation: \(\frac{£300,000}{£784,000} \times 100\% = 38.27\%\))*

---

**(b) Book Value (Net Asset Value) per Ordinary Share:**
- \(\text{Ordinary Share Capital} = 5,000,000 \times £0.50 = £2,500,000\)
- \(\text{Retained Earnings} = £1,800,000\)
- \(\text{Total Equity Attributable to Ordinary Shareholders} = £2,500,000 + £1,800,000 = £4,300,000\)
- \(\text{Book value per ordinary share} = \frac{£4,300,000}{5,000,000\text{ shares}} = \mathbf{£0.86}\) (or **86p**)

---

**(c) Evaluation:**

**Financial Factors for Purchase:**
- **Earnings Strength:** An EPS of 15.68p is solid relative to the nominal share value of 50p.
- **Dividend Safety:** Dividend cover of 2.61 times is strong, indicating that profits comfortably cover current dividend payout levels. There is substantial room to maintain dividends even if profits fall slightly, or to increase payouts in the future.
- **Growth Potential (P/E Ratio):** The P/E ratio of 15.31 reflects a positive market outlook, showing that investors are willing to pay a premium for future earnings potential.
- **Interest Cover:** Operating profit is £1,200,000, whereas finance costs are £120,000, meaning interest is covered 10 times. This shows very low default risk on corporate debt.

**Financial Factors Against Purchase:**
- **Low Dividend Yield:** A dividend yield of 2.50% is relatively low and may not attract income-focused investors who could get higher returns elsewhere.
- **Premium over Book Value:** The market price of £2.40 is significantly higher than the book value of £0.86. Investors are paying a premium of nearly 2.8 times the tangible book assets, which carries risk if the expected earnings growth does not materialize.

**Non-Financial Factors:**
- Hesperis plc operates in the **energy storage sector**, which is a high-growth sector with significant green energy tailwinds. However, it also features high technological disruption risks and potential regulatory shifts.
- There is potential need for massive future capital expenditure to remain competitive, which could dilute existing shareholders if new shares are issued.

**Conclusion/Recommendation:**
- **Growth-oriented investors** should purchase the shares because of the robust dividend cover, solid earnings, and sector growth potential.
- **Income-seeking/conservative investors** might avoid the stock due to the modest dividend yield and high market-to-book ratio premium.

Marking scheme

**(a) [Total: 16 marks]**
- **(i) EPS (4 marks):**
- 1 mark for calculating Profit for the year: \(£1,200,000 - £120,000 - £216,000 = £864,000\).
- 1 mark for finding Earnings attributable: \(£864,000 - £80,000 = £784,000\).
- 1 mark for correct division by 5,000,000 ordinary shares.
- 1 mark for final correct answer of 15.68p (or £0.1568).
- **(ii) P/E Ratio (3 marks):**
- 1 mark for formula or correct substitute values: \(\frac{£2.40}{EPS}\).
- 1 mark for calculation process.
- 1 mark for correct answer of 15.31 times (accept of-own-figure (OOF) based on part i).
- **(iii) Dividend Yield (3 marks):**
- 1 mark for DPS: \(\frac{£300,000}{5,000,000} = 6\text{p}\).
- 1 mark for division: \(\frac{6\text{p}}{240\text{p}} \times 100\%\).
- 1 mark for final correct answer of 2.50%.
- **(iv) Dividend Cover (3 marks):**
- 2 marks for correct calculation process (either \(\frac{15.68}{6}\) or \(\frac{£784,000}{£300,000}\)).
- 1 mark for final correct answer of 2.61 times (accept OOF).
- **(v) Dividend Payout Ratio (3 marks):**
- 2 marks for correct calculation process (either \(\frac{6}{15.68} \times 100\%\) or \(\frac{£300,000}{£784,000} \times 100\%\)).
- 1 mark for final correct answer of 38.27% (accept OOF).

**(b) [Total: 4 marks]**
- 2 marks for calculating total equity attributable to ordinary shareholders: Ordinary share capital (\(5,000,000 \times £0.50 = £2,500,000\)) + Retained earnings (\(£1,800,000\)) = £4,300,000.
- 1 mark for dividing by 5,000,000 shares.
- 1 mark for final correct answer: £0.86 or 86p.

**(c) [Total: 10 marks]**
- **Level 1 (1–3 marks):** Identifies basic financial indicators or general statements about buying shares. No balanced analysis, calculation figures used in isolation.
- **Level 2 (4–6 marks):** Evaluates several investment ratios calculated in parts (a) and (b). Discusses some implications (e.g., security of dividend cover, growth expected from high P/E). Includes minor reference to non-financial context. Lacks a fully supported recommendation.
- **Level 3 (7–10 marks):** Thorough and balanced analysis of both positive and negative financial metrics (including the premium of market price over book value) as well as the industry context (energy storage). Offers a highly clear, reasoned, and tailored recommendation to different investor profiles.
Question 3 · multi-part
30 marks
Alpha and Beta are in partnership sharing profits and losses in the ratio of 3:2. On 31 December 2022, they decided to sell their business to Gamma plc. The statement of financial position of the partnership at that date was as follows:

**Statement of Financial Position as at 31 December 2022**
**Non-current assets:**
Premises: £120,000
Equipment: £40,000

**Current assets:**
Inventory: £18,000
Trade Receivables: £22,000 (less Provision for doubtful debts £1,000 = £21,000)
Bank: £5,000
**Total Assets:** £204,000

**Capital Accounts:**
Alpha: £115,000
Beta: £75,000

**Current Liabilities:**
Trade Payables: £14,000
**Total Capital and Liabilities:** £204,000

**Terms of the acquisition by Gamma plc:**
1. Gamma plc agreed to purchase all assets (except the bank balance) and take over the trade payables.
2. The agreed values of assets acquired were:
- Premises: £150,000
- Equipment: £30,000
- Inventory: £16,000
- Trade Receivables: £20,000
3. Trade payables were taken over at book value.
4. The total purchase consideration was agreed at £230,000. This was settled by:
- Cash payment of £50,000.
- The balance by the issue of 120,000 ordinary shares of £1 each in Gamma plc, issued at a premium of £0.50 per share.
5. Shares in Gamma plc were distributed to the partners in their profit-sharing ratio. Any remaining capital account balances were settled in cash using the partnership bank account.

**Required:**
(a) Prepare the Realisation Account in the books of the partnership. [10 marks]
(b) Prepare the Partners' Capital Accounts, showing the final closure of the partnership. [8 marks]
(c) Calculate the Goodwill arising on the acquisition, and prepare the Journal Entries in the books of Gamma plc to record the acquisition and settlement of the purchase consideration. (Narrations are not required). [8 marks]
(d) Evaluate whether converting the partnership and selling the business to Gamma plc was beneficial for the partners Alpha and Beta. [4 marks]
Show answer & marking scheme

Worked solution

**(a) Realisation Account in the Partnership Books**

**Debit side:**
- Premises (book value): £120,000
- Equipment (book value): £40,000
- Inventory (book value): £18,000
- Trade Receivables (gross): £22,000
- Share of Profit transferred to:
- Alpha Capital Account \((\frac{3}{5} \times £45,000)\): £27,000
- Beta Capital Account \((\frac{2}{5} \times £45,000)\): £18,000
*Total Debits:* £245,000

**Credit side:**
- Provision for Doubtful Debts: £1,000
- Trade Payables: £14,000
- Gamma plc (Purchase Consideration): £230,000
*Total Credits:* £245,000

**(b) Partners' Capital Accounts**

**Alpha Capital Account:**
- *Credit side:* Balance b/d: £115,000; Realisation Profit: £27,000. (Total Cr = £142,000)
- *Debit side:* Shares in Gamma plc \((\frac{3}{5} \times £180,000)\): £108,000; Bank (final settlement): £34,000. (Total Dr = £142,000)

**Beta Capital Account:**
- *Credit side:* Balance b/d: £75,000; Realisation Profit: £18,000. (Total Cr = £93,000)
- *Debit side:* Shares in Gamma plc \((\frac{2}{5} \times £180,000)\): £72,000; Bank (final settlement): £21,000. (Total Dr = £93,000)

*(Note: Total cash distributed to partners = £34,000 + £21,000 = £55,000. This is fully funded by the initial £5,000 cash in bank + £50,000 cash from Gamma plc).*

**(c) Goodwill calculation and Journal Entries in Gamma plc's books**

*Goodwill calculation:*
Agreed values of assets acquired: £150,000 (Premises) + £30,000 (Equipment) + £16,000 (Inventory) + £20,000 (Trade Receivables) = £216,000.
Less: Liabilities taken over: £14,000 (Trade Payables).
Net Assets Acquired = £202,000.
Purchase Consideration = £230,000.
Goodwill = Purchase Consideration - Net Assets Acquired = £230,000 - £202,000 = £28,000.

*Journal Entries:*
1. **Acquisition entry:**
- Debit: Premises £150,000
- Debit: Equipment £30,000
- Debit: Inventory £16,000
- Debit: Trade Receivables £20,000
- Debit: Goodwill £28,000
- Credit: Trade Payables £14,000
- Credit: Liquidators of Alpha & Beta £230,000

2. **Settlement entry:**
- Debit: Liquidators of Alpha & Beta £230,000
- Credit: Bank £50,000
- Credit: Ordinary Share Capital (120,000 shares of £1) £120,000
- Credit: Share Premium (120,000 shares of £0.50) £60,000

**(d) Evaluation**
- **Benefits:** Alpha and Beta gained a realization profit of £45,000, which increased their final capital balances. They received significant liquidity (£55,000 total cash) and shares worth £180,000 in a limited company, granting them limited liability status.
- **Drawbacks:** They lose managerial control of their own business and will become minority shareholders in Gamma plc. Their future income depends on dividends rather than direct partnership profits.
- **Conclusion:** On balance, the sale was financially very beneficial because of the substantial goodwill realized, though they must accept the loss of daily management control.

Marking scheme

**(a) Realisation Account [10 Marks]**
- Transfer of Assets (Premises, Equipment, Inventory, Trade Receivables) at book values to Debit: 4 marks (1 mark per asset)
- Transfer of Liabilities and Provision (Trade Payables, Provision for doubtful debts) to Credit: 2 marks (1 mark each)
- Purchase Consideration on Credit: 1 mark
- Calculation of Realisation Profit (£45,000): 1 mark
- Correct division of profit (Alpha £27,000, Beta £18,000): 2 marks

**(b) Partners' Capital Accounts [8 Marks]**
- Opening balances b/d: 1 mark
- Realisation profit transferred: 1 mark
- Distribution of Gamma plc shares (Alpha £108,000, Beta £72,000): 3 marks
- Final cash settlement (Alpha £34,000, Beta £21,000): 3 marks

**(c) Goodwill & Journals [8 Marks]**
- Calculation of Net Assets Acquired (£202,000) and Goodwill (£28,000): 2 marks
- Journal entry to record assets/liabilities acquired (incorporating Goodwill): 3 marks (all debits/credits correct)
- Journal entry to record settlement (incorporating Share Capital £120k and Share Premium £60k): 3 marks

**(d) Evaluation [4 Marks]**
- Award 1 mark for each valid point evaluated (up to 3 marks): e.g., cash liquidity, realization profit, limited liability, loss of control, dividend dependency.
- Award 1 mark for a justified conclusion.
Question 4 · written
30 marks
Vanguard Logistics Ltd is considering investing in a new automated sorting system to increase operational efficiency.

The initial cost of the machinery is \(£450,000\). It is estimated to have a useful life of 5 years, after which it will have an estimated residual value of \(£50,000\). Vanguard Logistics Ltd uses the straight-line method to depreciate all its non-current assets.

The project is expected to generate the following annual operating profits (after charging straight-line depreciation):

- Year 1: \(£60,000\)
- Year 2: \(£90,000\)
- Year 3: \(£80,000\)
- Year 4: \(£40,000\)
- Year 5: \(£10,000\)

The cost of capital for Vanguard Logistics Ltd is 10%.

**Discount factors at 10%:**
- Year 1: 0.909
- Year 2: 0.826
- Year 3: 0.751
- Year 4: 0.683
- Year 5: 0.621

**Required:**

(a) Calculate the net cash flows for each of the 5 years. (6 marks)

(b) Calculate the payback period for this investment project in years and months. (6 marks)

(c) Calculate the Net Present Value (NPV) of the investment project. (10 marks)

(d) Evaluate the proposed investment project and provide a recommendation to the directors of Vanguard Logistics Ltd on whether they should proceed, using both financial and non-financial factors. (8 marks)
Show answer & marking scheme

Worked solution

**(a) Net Cash Flows Calculation**

First, calculate the annual depreciation expense:

\(\text{Annual Depreciation} = \frac{\text{Cost} - \text{Residual Value}}{\text{Useful Life}} = \frac{£450,000 - £50,000}{5} = £80,000\text{ per annum}\)

To find the net cash flows, add depreciation back to the operating profit. In Year 5, also add the residual value inflow of \(£50,000\).

- **Year 0:** \((£450,000)\) (Initial Outflow)
- **Year 1:** \(£60,000 + £80,000 = £140,000\)
- **Year 2:** \(£90,000 + £80,000 = £170,000\)
- **Year 3:** \(£80,000 + £80,000 = £160,000\)
- **Year 4:** \(£40,000 + £80,000 = £120,000\)
- **Year 5:** \(£10,000 + £80,000 + £50,000\text{ (residual)} = £140,000\)

---

**(b) Payback Period Calculation**

**Cumulative Cash Flows:**
- Year 0: \((£450,000)\)
- Year 1: \((£450,000) + £140,000 = (£310,000)\)
- Year 2: \((£310,000) + £170,000 = (£140,000)\)
- Year 3: \((£140,000) + £160,000 = +£20,000\)

Payback occurs during Year 3.

\(\text{Remaining amount to recover at start of Year 3} = £140,000\)
\(\text{Cash flow during Year 3} = £160,000\)

\(\text{Fraction of Year 3} = \frac{140,000}{160,000} = 0.875\text{ years}\)

In months: \(0.875 \times 12 = 10.5\text{ months}\)

**Payback Period = 2 years and 10.5 months** (or 2.875 years).

---

**(c) Net Present Value (NPV) Calculation**

| Year | Cash Flow (£) | Discount Factor (10%) | Present Value (£) |
|---|---|---|---|
| 0 | (450,000) | 1.000 | (450,000) |
| 1 | 140,000 | 0.909 | 127,260 |
| 2 | 170,000 | 0.826 | 140,420 |
| 3 | 160,000 | 0.751 | 120,160 |
| 4 | 120,000 | 0.683 | 81,960 |
| 5 | 140,000 | 0.621 | 86,940 |
| **NPV** | | | **+106,740** |

**Net Present Value (NPV) = +£106,740**

---

**(d) Evaluation and Recommendation**

**Arguments for accepting the project (Financial & Non-Financial):**
- The project has a positive NPV of \(£106,740\), meaning it increases shareholder wealth after accounting for the 10% cost of capital.
- The payback period of 2 years and 10.5 months is relatively quick, which reduces the liquidity risk and is well within the 5-year project life.
- The automation project could improve processing speed, reduce errors, and enhance competitive advantage in the logistics sector.

**Arguments against / Risks of the project:**
- The calculations are heavily reliant on estimates of cash flows and residual values, which might be overly optimistic.
- Implementation of high-tech automation may result in disruption to operations during installation, staff redundancy costs, or training requirements which may not be fully factored into the profits.

**Conclusion/Recommendation:**
- The directors should proceed with the project because it is financially viable (positive NPV, fast payback). However, they must put robust project-management controls in place to manage the transition and mitigate potential disruptions.

Marking scheme

**(a) Net Cash Flows: 6 Marks**
- 1 Mark [1OF] for annual depreciation of \(£80,000\).
- 1 Mark [1] for each year's correct net cash flow calculation (5 marks total).

**(b) Payback Period: 6 Marks**
- 2 Marks [2] for correct cumulative cash flow schedule.
- 2 Marks [2OF] for the fraction calculation working \((140,000 / 160,000)\).
- 2 Marks [2OF] for the correct final answer of 2 years 10.5 months (or 2.875 years).

**(c) Net Present Value (NPV): 10 Marks**
- 1 Mark [1] for correct Year 0 PV.
- 5 Marks [5OF] for calculating correct PVs for Years 1 through 5 (1 mark per year).
- 2 Marks [2] for summing up PVs of inflows correctly (\(£556,740\)).
- 2 Marks [2OF] for final correct NPV of \(+£106,740\).

**(d) Evaluation and Recommendation: 8 Marks**
- **Level 3 (6-8 Marks):** A balanced and well-structured response evaluating both financial factors (NPV and Payback) and non-financial factors (redundancy, training, technology benefits) with a clear, justified recommendation based on the calculations.
- **Level 2 (3-5 Marks):** A partially balanced evaluation that covers some financial and non-financial aspects, with a recommendation that has weak justification.
- **Level 1 (1-2 Marks):** Superficial answer identifying only one or two basic points with no clear structure or recommendation.

Wondering how well you actually know this?

Thinka is an AI practice app for DSE students — unlimited questions, instant auto-marking, and detailed step-by-step solutions. 100,000+ students use it to confirm they actually know it, not just think they do.

Want more questions like this? Practice unlimited on Thinka — instant answers included.

Start Practising Free