題目 1 · practical
55 分Vanguard Manufacturers manufactures custom-made components. The following trial balance was extracted from its books on 31 December 2022:
Inventory at 1 January 2022:
- Raw materials: £45,000
- Work in progress: £28,500
- Finished goods (at transfer value): £66,000
Purchases of raw materials: £284,000
Carriage inwards: £12,500
Direct factory wages: £165,000
Indirect factory wages: £58,000
Factory supervisor's salary: £42,000
Factory general expenses: £19,600
Administration expenses: £84,000
Selling and distribution expenses: £63,200
Rent and rates: £48,000
Insurance: £18,000
Plant and machinery (at cost): £250,000
Provision for depreciation of plant and machinery (1 January 2022): £90,000
Revenue (Sales): £840,000
Additional information at 31 December 2022:
1. Inventory on 31 December 2022:
- Raw materials: £38,200
- Work in progress: £31,300
- Finished goods (at transfer value): £55,000
2. Factory direct wages accrued were £4,200, and factory general expenses prepaid were £1,600.
3. Rent and rates and Insurance are to be apportioned as follows:
- Factory: 75%
- Administration: 25%
4. Depreciation on Plant and machinery is to be charged at 20% per annum using the reducing balance method. All plant and machinery is used in the factory.
5. Finished goods are transferred from the factory to the warehouse at a manufacturing profit of 10% on the cost of production.
Investment Appraisal Scenario:
Vanguard Manufacturers is also evaluating the purchase of a new automated packaging machine to replace manual packaging. The details are as follows:
- Initial capital outlay: £150,000
- Residual (scrap) value at the end of Year 4: £30,000
- Annual operating cash savings (inflows) before depreciation:
- Year 1: £50,000
- Year 2: £60,000
- Year 3: £80,000
- Year 4: £30,000
- The scrap value is received at the end of Year 4.
- Vanguard Manufacturers uses a cost of capital (discount rate) of 10% per annum. Discount factors: Year 1 = 0.909, Year 2 = 0.826, Year 3 = 0.751, Year 4 = 0.683.
Required:
(a) Prepare the Manufacturing Account for Vanguard Manufacturers for the year ended 31 December 2022, clearly showing the Prime Cost, Cost of Production, and the Transfer Value of completed goods. (20 marks)
(b) Prepare the Statement of Profit or Loss (Trading Account and Manufacturing Profit section) up to the Gross Profit level for the year ended 31 December 2022, taking into account any adjustment for the provision for unrealised profit. (10 marks)
(c) Calculate the following for the new packaging machine investment:
(i) Payback period in years and months. (5 marks)
(ii) Net Present Value (NPV) using the 10% discount factors. (5 marks)
(iii) Accounting Rate of Return (ARR) based on average investment. (5 marks)
(d) Evaluate whether Vanguard Manufacturers should proceed with the purchase of the automated packaging machine. Your answer should consider both financial and non-financial factors. (10 marks)
Inventory at 1 January 2022:
- Raw materials: £45,000
- Work in progress: £28,500
- Finished goods (at transfer value): £66,000
Purchases of raw materials: £284,000
Carriage inwards: £12,500
Direct factory wages: £165,000
Indirect factory wages: £58,000
Factory supervisor's salary: £42,000
Factory general expenses: £19,600
Administration expenses: £84,000
Selling and distribution expenses: £63,200
Rent and rates: £48,000
Insurance: £18,000
Plant and machinery (at cost): £250,000
Provision for depreciation of plant and machinery (1 January 2022): £90,000
Revenue (Sales): £840,000
Additional information at 31 December 2022:
1. Inventory on 31 December 2022:
- Raw materials: £38,200
- Work in progress: £31,300
- Finished goods (at transfer value): £55,000
2. Factory direct wages accrued were £4,200, and factory general expenses prepaid were £1,600.
3. Rent and rates and Insurance are to be apportioned as follows:
- Factory: 75%
- Administration: 25%
4. Depreciation on Plant and machinery is to be charged at 20% per annum using the reducing balance method. All plant and machinery is used in the factory.
5. Finished goods are transferred from the factory to the warehouse at a manufacturing profit of 10% on the cost of production.
Investment Appraisal Scenario:
Vanguard Manufacturers is also evaluating the purchase of a new automated packaging machine to replace manual packaging. The details are as follows:
- Initial capital outlay: £150,000
- Residual (scrap) value at the end of Year 4: £30,000
- Annual operating cash savings (inflows) before depreciation:
- Year 1: £50,000
- Year 2: £60,000
- Year 3: £80,000
- Year 4: £30,000
- The scrap value is received at the end of Year 4.
- Vanguard Manufacturers uses a cost of capital (discount rate) of 10% per annum. Discount factors: Year 1 = 0.909, Year 2 = 0.826, Year 3 = 0.751, Year 4 = 0.683.
Required:
(a) Prepare the Manufacturing Account for Vanguard Manufacturers for the year ended 31 December 2022, clearly showing the Prime Cost, Cost of Production, and the Transfer Value of completed goods. (20 marks)
(b) Prepare the Statement of Profit or Loss (Trading Account and Manufacturing Profit section) up to the Gross Profit level for the year ended 31 December 2022, taking into account any adjustment for the provision for unrealised profit. (10 marks)
(c) Calculate the following for the new packaging machine investment:
(i) Payback period in years and months. (5 marks)
(ii) Net Present Value (NPV) using the 10% discount factors. (5 marks)
(iii) Accounting Rate of Return (ARR) based on average investment. (5 marks)
(d) Evaluate whether Vanguard Manufacturers should proceed with the purchase of the automated packaging machine. Your answer should consider both financial and non-financial factors. (10 marks)
查看答案詳解收起答案詳解
解題
(a) Manufacturing Account for the year ended 31 December 2022:
- Opening Raw Materials: £45,000
- Add: Purchases: £284,000
- Add: Carriage Inwards: £12,500
- Less: Closing Raw Materials: (£38,200)
- Cost of Raw Materials Consumed: £303,300
- Direct Wages: £165,000 + £4,200 accrued = £169,200
- Prime Cost: £303,300 + £169,200 = £472,500
Factory Overheads:
- Indirect Wages: £58,000
- Factory Supervisor Salary: £42,000
- Factory General Expenses: £19,600 - £1,600 prepaid = £18,000
- Rent and Rates: 75% * £48,000 = £36,000
- Insurance: 75% * £18,000 = £13,500
- Depreciation (Plant and machinery): 20% * (£250,000 - £90,000) = £32,000
- Total Factory Overheads: £199,500
- Total Factory Cost: £472,500 + £199,500 = £672,000
- Add: Opening WIP: £28,500
- Less: Closing WIP: (£31,300)
- Cost of Production: £669,200
- Add: Manufacturing Profit (10%): £66,920
- Transfer Value to Warehouse: £736,120
(b) Statement of Profit or Loss (Trading section) for the year ended 31 December 2022:
- Revenue: £840,000
- Cost of Sales:
- Opening Finished Goods Inventory: £66,000
- Add: Transfer Value: £736,120
- Less: Closing Finished Goods Inventory: (£55,000)
- Cost of Goods Sold: (£747,120)
- Gross Profit on Sales: £92,880
- Add: Manufacturing Profit: £66,920
- Add: Decrease in Provision for Unrealised Profit: £1,000
- Total Gross Profit: £160,800
*Note on Provision for Unrealised Profit (PUP):
- Opening PUP: £66,000 * 10/110 = £6,000
- Closing PUP: £55,000 * 10/110 = £5,000
- Decrease in PUP: £1,000
(c) (i) Payback Period:
- Year 0: (£150,000)
- Year 1: £50,000 (Cumulative: £50,000)
- Year 2: £60,000 (Cumulative: £110,000)
- Remaining to Payback: £40,000
- Year 3 Inflow: £80,000
- Fraction of Year 3: £40,000 / £80,000 = 0.5 years (6 months)
- Payback Period = 2.5 years (or 2 years and 6 months)
(ii) Net Present Value (NPV):
- Year 1: £50,000 * 0.909 = £45,450
- Year 2: £60,000 * 0.826 = £49,560
- Year 3: £80,000 * 0.751 = £60,080
- Year 4: (£30,000 savings + £30,000 scrap) * 0.683 = £40,980
- Total PV of Cash Inflows: £196,070
- Less: Initial Outlay: (£150,000)
- Net Present Value: £46,070
(iii) Accounting Rate of Return (ARR):
- Total Net Cash Inflows from Operations: £220,000
- Total Depreciation: £150,000 - £30,000 = £120,000
- Total Accounting Profit over 4 years: £220,000 - £120,000 = £100,000
- Average Annual Profit: £100,000 / 4 = £25,000
- Average Investment: (£150,000 + £30,000) / 2 = £90,000
- ARR = (£25,000 / £90,000) * 100% = 27.78%
*(Alternatively, if using initial outlay: ARR = (£25,000 / £150,000) * 100% = 16.67%)
(d) Evaluation:
- Financial: The NPV is positive at £46,070, indicating it exceeds the cost of capital. Payback period is short (2.5 years) and ARR is strong (27.78%).
- Non-financial: Automation improves production flow and quality consistency. However, it may require redundancy costs, employee resistance, or retraining costs. Maintenance overheads may also rise.
- Conclusion: The machine is financially viable. It should be purchased provided Vanguard can manage any negative impacts on staff morale and has sufficient short-term cash reserves.
- Opening Raw Materials: £45,000
- Add: Purchases: £284,000
- Add: Carriage Inwards: £12,500
- Less: Closing Raw Materials: (£38,200)
- Cost of Raw Materials Consumed: £303,300
- Direct Wages: £165,000 + £4,200 accrued = £169,200
- Prime Cost: £303,300 + £169,200 = £472,500
Factory Overheads:
- Indirect Wages: £58,000
- Factory Supervisor Salary: £42,000
- Factory General Expenses: £19,600 - £1,600 prepaid = £18,000
- Rent and Rates: 75% * £48,000 = £36,000
- Insurance: 75% * £18,000 = £13,500
- Depreciation (Plant and machinery): 20% * (£250,000 - £90,000) = £32,000
- Total Factory Overheads: £199,500
- Total Factory Cost: £472,500 + £199,500 = £672,000
- Add: Opening WIP: £28,500
- Less: Closing WIP: (£31,300)
- Cost of Production: £669,200
- Add: Manufacturing Profit (10%): £66,920
- Transfer Value to Warehouse: £736,120
(b) Statement of Profit or Loss (Trading section) for the year ended 31 December 2022:
- Revenue: £840,000
- Cost of Sales:
- Opening Finished Goods Inventory: £66,000
- Add: Transfer Value: £736,120
- Less: Closing Finished Goods Inventory: (£55,000)
- Cost of Goods Sold: (£747,120)
- Gross Profit on Sales: £92,880
- Add: Manufacturing Profit: £66,920
- Add: Decrease in Provision for Unrealised Profit: £1,000
- Total Gross Profit: £160,800
*Note on Provision for Unrealised Profit (PUP):
- Opening PUP: £66,000 * 10/110 = £6,000
- Closing PUP: £55,000 * 10/110 = £5,000
- Decrease in PUP: £1,000
(c) (i) Payback Period:
- Year 0: (£150,000)
- Year 1: £50,000 (Cumulative: £50,000)
- Year 2: £60,000 (Cumulative: £110,000)
- Remaining to Payback: £40,000
- Year 3 Inflow: £80,000
- Fraction of Year 3: £40,000 / £80,000 = 0.5 years (6 months)
- Payback Period = 2.5 years (or 2 years and 6 months)
(ii) Net Present Value (NPV):
- Year 1: £50,000 * 0.909 = £45,450
- Year 2: £60,000 * 0.826 = £49,560
- Year 3: £80,000 * 0.751 = £60,080
- Year 4: (£30,000 savings + £30,000 scrap) * 0.683 = £40,980
- Total PV of Cash Inflows: £196,070
- Less: Initial Outlay: (£150,000)
- Net Present Value: £46,070
(iii) Accounting Rate of Return (ARR):
- Total Net Cash Inflows from Operations: £220,000
- Total Depreciation: £150,000 - £30,000 = £120,000
- Total Accounting Profit over 4 years: £220,000 - £120,000 = £100,000
- Average Annual Profit: £100,000 / 4 = £25,000
- Average Investment: (£150,000 + £30,000) / 2 = £90,000
- ARR = (£25,000 / £90,000) * 100% = 27.78%
*(Alternatively, if using initial outlay: ARR = (£25,000 / £150,000) * 100% = 16.67%)
(d) Evaluation:
- Financial: The NPV is positive at £46,070, indicating it exceeds the cost of capital. Payback period is short (2.5 years) and ARR is strong (27.78%).
- Non-financial: Automation improves production flow and quality consistency. However, it may require redundancy costs, employee resistance, or retraining costs. Maintenance overheads may also rise.
- Conclusion: The machine is financially viable. It should be purchased provided Vanguard can manage any negative impacts on staff morale and has sufficient short-term cash reserves.
評分準則
(a) [Total: 20 marks]
- Cost of raw materials consumed: 5 marks (1 mark for opening inventory, purchases, carriage inwards, closing inventory, and final raw materials consumed value of £303,300).
- Direct wages: 2 marks (1 mark for adjustment of accrued wages, 1 mark for correct direct wages of £169,200).
- Prime cost: 1 mark for correct sum of £472,500.
- Overheads: 8 marks (1 mark for indirect wages, 1 mark for supervisor's salary, 2 marks for adjusted general expenses, 1 mark for rent/rates, 1 mark for insurance, 2 marks for depreciation calculation).
- Cost of production: 2 marks (including work-in-progress adjustments).
- Manufacturing Profit and Transfer Value: 2 marks (1 mark for 10% profit calculation of £66,920, 1 mark for transfer value of £736,120).
(b) [Total: 10 marks]
- Revenue and cost of sales: 4 marks (1 mark for revenue, 1 mark for opening finished goods, 1 mark for transfer value, 1 mark for closing finished goods).
- Provision for unrealised profit: 3 marks (1 mark for opening provision of £6,000, 1 mark for closing provision of £5,000, 1 mark for increase/decrease adjustment).
- Final gross profit calculation of £160,800: 3 marks (including addition of manufacturing profit and PUP adjustment).
(c) [Total: 15 marks]
- (i) Payback: 5 marks (2 marks for cumulative cash flow table, 3 marks for correct payback calculation of 2.5 years).
- (ii) NPV: 5 marks (2 marks for correct present value calculations, 1 mark for inclusion of Year 4 residual value, 2 marks for correct final NPV of £46,070).
- (iii) ARR: 5 marks (2 marks for average annual profit, 1 mark for average investment, 2 marks for correct final ARR percentage of 27.78% or 16.67%).
(d) [Total: 10 marks]
- Level 1 (1-3 marks): Simple identification of points for and against.
- Level 2 (4-6 marks): Explanation of both financial and non-financial factors with attempt at balance.
- Level 3 (7-8 marks): Good explanation of factors supported by calculated values (NPV, Payback, ARR) and structured discussion.
- Level 4 (9-10 marks): Thoroughly balanced discussion with a clear logical recommendation based on facts presented.
- Cost of raw materials consumed: 5 marks (1 mark for opening inventory, purchases, carriage inwards, closing inventory, and final raw materials consumed value of £303,300).
- Direct wages: 2 marks (1 mark for adjustment of accrued wages, 1 mark for correct direct wages of £169,200).
- Prime cost: 1 mark for correct sum of £472,500.
- Overheads: 8 marks (1 mark for indirect wages, 1 mark for supervisor's salary, 2 marks for adjusted general expenses, 1 mark for rent/rates, 1 mark for insurance, 2 marks for depreciation calculation).
- Cost of production: 2 marks (including work-in-progress adjustments).
- Manufacturing Profit and Transfer Value: 2 marks (1 mark for 10% profit calculation of £66,920, 1 mark for transfer value of £736,120).
(b) [Total: 10 marks]
- Revenue and cost of sales: 4 marks (1 mark for revenue, 1 mark for opening finished goods, 1 mark for transfer value, 1 mark for closing finished goods).
- Provision for unrealised profit: 3 marks (1 mark for opening provision of £6,000, 1 mark for closing provision of £5,000, 1 mark for increase/decrease adjustment).
- Final gross profit calculation of £160,800: 3 marks (including addition of manufacturing profit and PUP adjustment).
(c) [Total: 15 marks]
- (i) Payback: 5 marks (2 marks for cumulative cash flow table, 3 marks for correct payback calculation of 2.5 years).
- (ii) NPV: 5 marks (2 marks for correct present value calculations, 1 mark for inclusion of Year 4 residual value, 2 marks for correct final NPV of £46,070).
- (iii) ARR: 5 marks (2 marks for average annual profit, 1 mark for average investment, 2 marks for correct final ARR percentage of 27.78% or 16.67%).
(d) [Total: 10 marks]
- Level 1 (1-3 marks): Simple identification of points for and against.
- Level 2 (4-6 marks): Explanation of both financial and non-financial factors with attempt at balance.
- Level 3 (7-8 marks): Good explanation of factors supported by calculated values (NPV, Payback, ARR) and structured discussion.
- Level 4 (9-10 marks): Thoroughly balanced discussion with a clear logical recommendation based on facts presented.