Highlights
Part A information
You have observed that the Board of Directors allocates budgets on an annual basis using an incremental approach, adjusting for known inflationary pressures and then applying a 2% cost efficiency reduction.
The factory is divided into production lines for each range of cars, with each production line having an allocated operational manager who has responsibility for managing the budget.
The Budgets reports are produced by the Management Accounts department after the end of each month and presented and discussed 3 weeks later in monthly performance meetings involving the Budget Manager, the Director of Operations and the Director of Finance. Reports are not distributed before the meeting.
|
BUDGET REPORT |
||||
|
MPM Hatchback 1.4 Production line |
|
|
December 2022 |
|
|
|
Original |
|
|
|
|
|
Budget |
Actual |
Variance |
A or F |
|
Units of output (cars) |
700 |
730 |
|
|
|
|
£000s |
£000s |
£000s |
|
|
Revenue |
14,700 |
15,200 |
500 |
F |
|
|
|
|
|
|
|
Supplies |
(4,830) |
(4,850) |
(20) |
A |
|
Direct Wages |
(1,960) |
(2,003) |
(43) |
A |
|
Direct Utilities |
(770) |
(820) |
(50) |
A |
|
Total variable costs |
(7,560) |
(7,673) |
(113) |
A |
|
Line Management wages |
(16) |
(17) |
(1) |
A |
|
Production line depreciation |
(960) |
(1,100) |
(140) |
A |
|
Selling and Distribution |
(2,030) |
(2,100) |
(70) |
A |
|
Apportioned Headquarters Overhead |
(2,560) |
(2,800) |
(240) |
A |
|
Total Indirect Costs |
(5,566) |
(6,017) |
(451) |
A |
|
Total Profit |
1,574 |
1,510 |
(64) |
A |
|
Profit % |
11% |
10% |
-1% |
A |
In January’s budget meeting the budget manager complained that he doesn’t understand how the December report can show an adverse position, as he feels he is running the department efficiently, as he has a good handle on securing cheap supplies and managing staff performance. He feels his performance is judged on costs that he cannot control, in particular, line management wages, production line depreciation and headquarters overheads.
1. Discuss different approaches to budget setting, critiquing the approach taken by MPM.
2. Recommend improvements to the budget monitoring process, producing an improved revised budget report for December 2022 that more effectively measures the performance of the budget manager in the areas they can control.
Choose and answer either Part B or Part C
Part B) COSTING
1. Critique different approaches to
Series 1 and Series 2 are both produced in the same factory. Selling prices are calculated by adding a 40% mark-up on unit production costs.
2. Using a traditional business wide rate for all overheads based on labour hours calculate the unit costs, mark-up and selling prices of the MPM Series 1 and Series 2 cars.
3. Using an Activity Based Costing approach calculate the unit costs, mark-up and selling prices of the MPM Series 1 and Series 2.
|
|
Series 1 |
Series 2 |
|
Production |
600 |
300 |
|
Hours of Direct Labour per unit |
6 |
16 |
|
|
£ |
£ |
|
Direct Materials per unit |
15000 |
16000 |
|
Direct Labour per unit |
138 |
368 |
|
Activity |
Cost Driver |
Total activity for Series 1 Production |
Total activity for Series 2 Production |
Cost in £ |
|
Machining |
Machine hours |
2,400 |
1,200 |
2,300,000 |
|
Finishing |
Direct Labour hours |
3,800 |
4,800 |
900,000 |
|
Materials Ordering |
No of orders placed |
18 |
12 |
420,000 |
|
Materials issue |
No. of material issues made |
28 |
20 |
380,000 |
|
Scheduling etc. |
No of production runs |
17 |
20 |
310,000 |
|
Total Overheads |
|
|
|
4,310,000 |
Part C) Capital Investment Appraisal
MPM Ltd is considering whether to increase its borrowing and invest in expansion into the new market of Electric cars to increase returns to the business. There is already a Project Team in place, which has begun assessing the opportunity and would deliver the development if it receives board approval. Costs of the team to date are £900,000.
Capital planning has already priced up the new the machinery and the Product Development team have given an estimate of the costs of bringing products to market.
The Sales manager has given a forecast of potential sales and a member of the management accounts team has provided costings. Production line machines have a 6-year lifespan. Details are as follows;
|
|
£000s |
|
|
|
Capital Investment in machinery |
18,000 |
||
|
Additional Product Development expense |
5,100 |
||
|
|
Estimated Sales Revenue |
Estimated Cost of Sales |
Estimated Marketing |
|
|
£000s |
£000s |
£000s |
|
Year 1 |
31,000 |
16,120 |
29,000 |
|
Year 2 |
45,000 |
23,400 |
12,000 |
|
Year 3 |
46,000 |
23,920 |
10,000 |
|
Year 4 |
43,000 |
22,360 |
6,000 |
|
Year 5 |
39,000 |
20,280 |
12,000 |
|
Year 6 |
35,000 |
18,200 |
6,000 |
1. Critique different available approaches to capital investment appraisal.
2. Analyse the proposed electric cars development, calculating the payback period as accurately as possible and the Net Present Value, making a recommendation whether or not to proceed with the investment considering risks and financial and non-financial factors
This ACC1057-N - Accounting has been solved by our PhD Experts at My Uni Paper.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.