The Kalgan Driftwood Company
Questions and guidance on preparing case study
Managerial Finance ACC08402 Assignment – Part 2
This document provides the assignment brief, specification and assessment criteria for your second assessment on the module: Managerial Finance.
1
Case Study
This Case Study will form 45% of your overall mark for this module The Kalgan Driftwood Company
Background
The Kalgan Driftwood Company (Kalgan) was established in 1950. It is located on a 100 hectare site in a beautiful scenic location on the banks of the Kalgan River. The company has built its reputation on making quality furniture at affordable prices from cast-off jarrah wood from a nearby timber mill.
Re- cover service
Kalgan, which sources its fabrics from Indonesia and Vietnam, offers a choice of over 50 different fabrics. Kalgan is considering offering a re-cover service to supply replacement cushions when the existing ones wear out or customers wish to change their fabric since a recent study found that customers kept their Kalgan furniture for an average of 18 years. The re-cover service will make three sizes of covers: large, medium and small.
The company accountant has carried out an investment appraisal of the new re-cover service assuming a project life of 5 years. The net cash flows on a relevant cost basis for each of the five years were as follows:
Year
0 1 2 3 4 5
Net cash flows
£(140,000) £23,240 £45,780 £54,320 £54,320 £54,320
2
Budget data for the first year of the re-cover service are as follows:
Sales (units)
Selling price per unit Direct labour cost per unit Fabric cost per unit Contribution per unit
Large 2,250 £115 £12.60 £44.80 £57.60
Medium 1,450 £90 £8.40 £32.20 £49.40
Small 2,400 £58 £6.30 £21 £30.70
Small 0.25 hours
Specific Fixed Costs:
• Factory power costs: £84,000 per annum
• Lease of equipment for re-cover service: £70,000 per annum The expected time to produce each size of cover is as follows:
Re-cover Service Large Medium
Time to make each cover 0.6 hour 0.4 hour
The production director has now informed the board that the supply of skilled labour for year 1 will be restricted to a maximum of 2,500 hours.
The company’s cost of capital is 8% per annum.
Question A
(i) Calculate the budgeted profit after specific fixed costs, for year 1 of the re-cover operation, assuming demand can be met in full.
(5 marks) (ii) Calculate the sales mix that will maximise budgeted profit for year 1 of the re-cover
operation based on the limited availability of labour.
(iii) Suggest two actions that the company could take to overcome the shortage of labour.
(iv) Calculate the payback period for the re-cover project. (v) Calculate the net present value for the re-cover project.
(10 marks) (5 marks) (5 marks)
3
(5 marks) Total for this part = 30 marks
Question B
The Kalgan Driftwood Company has decided to that it needs to use the budgeting process much more substantially to manage its activities. You are a graduate trainee who has just started work in the accounting department of Kalgan. In your degree studies, you completed a module called Managerial Finance and learned that budgets serve a number of useful purposes including:
(i) Planning annual operations;
(ii) Coordinating the activities of the various parts of the organisation; (iii) Communicating plans to the various responsibility centre managers; (iv) Motivating managers to strive to achieve the organisational goals; (v) Controlling activities;
(vi) Evaluating the performance of managers
You are asked to select four of these purposes and explain in a presentation to your Kalgan work colleagues about how budgets achieve these aims. Write an essay that will form the basis of your presentation.
Total of 1,000 words for this part = 60 marks
Note: The report should be word processed (Arial font size 12) and well presented. Referencing and bibliographies should use the APA 7th System (name and date). For detail of the APA 7th System refer to Learning Information Services (i.e. the Library’s) Referencing web page and Guide or Napier web pages on plagiarism. http://www2(dot)napier(dot)ac(dot)uk/ed/plagiarism/
(10 marks) (Total 100 marks)
4
Marking Schedule
The following report assessment feedback sheet will help you identify the key elements of the report and the manner of evaluating them by your lecturer.
Managerial Finance ACC08402 Report Submission Matriculation Number:
Tutor:
Very Poor
Weak
Satisfactory
Good Very Good
Excellent Marks
30 60 10
Question A Question B
Presentation of work
Overall mark
Comments
5
Assessment criteria for the module report assignment
Below we give you a schedule, which is used as the basis for marking your assignment in Managerial Finance. This will help you to judge what you need to do to achieve any given mark range.
Less than 40% - a very poor/weak assignment, the student has not answered the assignment properly. There may be a number of errors including insufficient explanation of the theory, and a limited ability to interpret the ideas to practical situations.
40-49% - a satisfactory assignment, the student shows partial understanding of the issues but possibly combined with errors and/or insufficient or unclear explanation of the key points. There is limited interpretation of the issues in relation to the real world.
50-59% - a good assignment, with most of the key points correctly stated, the student demonstrates an ability to interpret at least some of the issues and makes a reasonable attempt at explaining the theoretical concepts.
60-69% - a very good assignment with minimal errors. Demonstrates an understanding of the key issues and is thorough in its analysis of the issues and theoretical concepts. The student shows strong critical and analytical ability.
70-79% - an excellent assignment which is well written and explained. It will demonstrate a clear understanding of the issues, using a high level of critical and analytical ability.
80% + - an exceptional assignment, which is sophisticated in its approach while being correct in every particular detail. Extremely high level of critical ability is demonstrated with original thought being evident.
Note that in ALL categories above it is expected that you will provide a bibliography (where applicable) of the material used in preparation of your assignment.
References and bibliography should use the APA 6th System (name and date). You must also be careful not to plagiarise. Help is available for both referencing and plagiarism by following the links from your Edinburgh Napier Student Portal ‘Don’t plagiarise’. If material is simply reproduced from report and accounts using the same words, this will be treated as plagiarism and a fail mark will be given. Material copied from websites or other sources that provide ready-made solutions to report will be deemed an academic offence and subject to disciplinary action.
6
The Kalgan Driftwood Company
Your name
Subject and Section
Professor’s Name
August 24, 2023
PART A.
* Calculate the budgeted profit after specific fixed costs for year 1:
1 Calculate Contribution for Each Size:
Total Contribution = Contribution per unit × Sales (units)
Large
£ 57.60
2,250
£ 129,600.00
Medium
£ 49.40
1,450
£ 71,630.00
Small
£ 30.70
2,400
£ 73,680.00
2 Calculate Total Contribution:
Total Contributions = £129,600 + £71,630 + £73,680 = £274,910
3 Calculate Total Specific Fixed Costs:
Total Specific Fixed Cost = Factory power costs + Lease of equipment
Total Specific Fixed Cost = £84,000 + £70,000 = £154,000
4 Calculate Budgeted Profit:
Budgeted Profit = Total Contribution − Total Specific Fixed Costs
Budgeted Profit = £274,910 − £154,000 = £120,910
So, the budgeted profit after specific fixed costs for year 1 of the re-cover operation, assuming demand can be met in full, is £120,910.
* Calculate the sales mix based on limited availability of labour:
1 Determine Available Labour Time for Each Size:
Large
2250
0.6
1350 hours
Medium
1450
0.4
580 hours
Small
2400
0.25
600 hours
2 Total Time Required
1,350 hours + 580 hours+ 600 hours = 2,530 hours
Note that this is more than the available 2,500 hours. So, we will have to optimise the mix. Thus, we prioritise the items with the highest contribution per labour hour to maximise budgeted profit.
Contribution Per Labour Hour:
Large
£ 57.6
0.6
£ 96/hour
Medium
£ 49.4
0.4
£ 123.5/hour
Small
£ 30.7
0.25
£ 122.8/hour
The Medium covers have the highest contribution per labour hour, followed closely by Small and then Large.
Given the constraint, we will prioritise Medium covers:
2,500 hours - 580 hours (already allocated to Medium) = 1,920 hours left
Now, allocate to Small: 1,920 hours ÷ 0.25 hours = 7,680 units.
However, since the demand is only for 2,400 units, we will allocate 600 hours to Small covers. This leaves us with 1,920 - 600 hours = 1,320 hours for Large covers.
Large Covers allocation: 1,320 hours ÷ 0.6 = 2,200 units of Large covers.
Optimised Sales Mix:
Large
2,200 units
Medium
1,450 units
Small
2,400 units
* Suggest two actions to overcome the shortage of labour:
1 Outsourcing or Subcontract: The company can consider subcontracting or outsourcing a portion of the production process. By contracting third-party vendors or manufacturers, Kalgan can reduce the pressure on its in-house skilled labour. Outsourcing might be particularly effective for less complex tasks, thus allowing in-house skilled labour to focus on specialised tasks (Le Ludec et al., 2023).
2 Training and Skill Development: Kalgan could invest in training programs to upskill existing employees or to train new hires rapidly. By enhancing the skills of the existing workforce, they can increase their productivity, thereby requiring fewer hours to produce the same number of covers (Hashemi-Petroodi et al., 2021). Moreover, a well-trained workforce can improve quality, customer satisfaction, and sales.
* Calculate the payback period for the re-cover project:
The payback period is the time required to recoup the initial investment from the net cash inflows.
Given the Net Cash Flows:
Year
Net Cash Flows
0
-£ 140,000.00
1
£ 23,240.00
2
£ 45,780.00
3
£ 54,320.00
4
£ 54,320.00
5
£ 54,320.00
Cumulative Net Cash Flows:
* End of Year 1: £ (140,000) + £ 23,240 = £ (116,760)
* End of Year 2: £ (116,760) + £ 45,780 = £ (70,980)
* End of Year 3: £ (70,980) + £ 54,320 = £ (16,660)
The payback period falls in the third year. To find the exact payback period:
Payback Period = 2 + (Unrecovered cost at the beginning of Year 3 / Net Cash Flow in Year 3)
Payback Period = 2 + (£16,660 / £54,320)
Payback Period = 2 + 0.31
Payback Period = 2.31
The payback period for the re-cover project is 2.31 years.
* Calculate the Net Present Value (NPV) for the re-cover project:
To calculate the Net Present Value (NPV), we discount each year's net cash flow back to the present using the company's cost of capital (8%).
NPV = ∑ (Net Cash Flow / (1+discount rate)year)
Given the Net Cash Flows and using a discount rate of 8%:
Year
Computation
Net Cash Flows
0
£ (140,000)/ (1 + 0.08)^0
-£ 140,000.00
1
£ 23,240/ (1 + 0.08)^1
£ 21,518.52
2
£ 45,780/ (1 + 0.08)^2
£ 39,248.97
3
£ 54,320/ (1 + 0.08)^3
£ 43,120.97
4
£ 54,320/ (1 + 0.08)^4
&po...
👀 Other Visitors are Viewing These APA Essay Samples:
-
Earthwear Clothiers Corporate Structure and Annual Report
3 pages/≈825 words | 4 Sources | APA | Accounting, Finance, SPSS | Term Paper |
-
Analysis of Twitter Acquisition
11 pages/≈3025 words | 2 Sources | APA | Accounting, Finance, SPSS | Term Paper |
-
Communication: Gaps in Internal Control
4 pages/≈1100 words | 3 Sources | APA | Accounting, Finance, SPSS | Term Paper |