Finance
Edinburgh Napier University Module SOE11144 Global Business Economics and Finance Project 2 Assessment A. Project question Report Assignment in Accounting and Finance You have received an email from the Chief Executive Officer of Clark Casc Logistics plc, where you are employed as manager of the refrigerated goods division, inviting you to the first in a series of budgetsetting meetings and asking you to submit a brief report in advance. You are required to submit your report by 23:59 on Friday, August 27th., 2021, through the Turnitin dropbox in Moodle. You are only permitted to submit your report once. Trial runs are not permitted and no spare, draft or test dropboxes will be provided. It is your responsibility to submit your own work and to ensure that your report is finalised, complete and properly edited before, not after, you submit it. This is an individual assignment. The sharing of files or copying of work between students is not permitted. You are only allowed to submit one document, which must contain your full report, including your reference list. Do not attempt to submit additional documents. Your submission must be either a Word document in .doc or .docx format or a .pdf document. Appendices are not permitted. Report Assignment in Accounting and Finance You have received the following email from the Chief Executive Officer of Clark Casc Logistics plc, where you are employed as manager of the refrigerated goods division, inviting you to the first in a series of budgetsetting meetings and asking you to submit a brief report in advance. Dear “Laser”, For the last financial year Clark Casc Logistics plc made a profit of £32 million – with profits of £18 million in the first six months of this year and the Board believes that there is scope for continuing expansion. We are therefore reaching out to all managers to provide realistic budgets for the income and costs for which they are responsible, so that we can plan ahead with confidence. We will be holding a first round of budget-setting meetings on Thursday next week. As the manager of the refrigerated goods division, the income and expenditure for which you were responsible for the last financial year were as follows. Your expenditure for the first six months of the present financial year is as follows, with a comparison with the budget which, I would remind you, you agreed to this time last year. Year Ended January 31st 2022 Six Months to July 31st 2021 Refrigerated Goods Budget Full Year £000 Budget Year to Date £000 Actual Year to Date £000 Income from Refrigerated Goods Customers 24,760 12,380 12,967 Expenditure Salaries and Associated Payroll Costs Drivers 8,540 4,270 4,321 Depot Operatives 1,952 976 994 Administrative Staff 324 162 163 Total 10,816 10,816 5,408 5,408 5,478 5,478 Buildings Depreciation 56 28 28 Buildings Maintenance 84 42 42 Vehicle Depreciation 1,356 678 694 Vehicle Maintenance 1,266 633 648 Other Equipment Depreciation 254 127 114 Other Equipment Maintenance 152 76 72 Vehicle Fuel 4,758 2,379 2,434 Other Power Supplies 176 88 90 Vehicle Excise Duty 86 43 44 Vehicle Insurance 358 179 184 Staff Training Drivers 240 120 124 Depot Operatives 22 11 11 Administrative Staff 4 2 2 Total 266 266 133 133 137 137 Total Expenditure 19,628 9,814 9,965 Profit 5,132 2,566 3,002 Next Year: Year Ending January 31st 2023 The purpose of next week’s meeting is not to congratulate ourselves on past profits but to plan for the future. We already have a budget for the rest of this year and monitoring progress against this is an entirely separate exercise and not the purpose of this report, so do not include any budget monitoring information, as we already have that. We need a realistic budget for income and expenditure, to tell us how much sales income we intend to make and how much we are going to have to spend to earn it. This year is already underway and what we need is a budget for next year. We need this budget to be agreed well in advance, so that we can make the necessary commitments and contractual arrangements for all our planned expenditure. Please provide a report in advance of the meeting detailing your budget for the year ending January 31st 2023. The format of the proposed budget is up to you, as is the method by which you arrive at the budget. However, please include the following sections in your report. We do not require an executive summary: 1. Introduction 2. Approach to drawing up the refrigerated goods department budget 3. Relevant calculations to show that your budget for the year ending January 31st 2023 is realistic 4. Your proposed budget for the year ending January 31st 2023 with complete income and expenditure figures 5. A conclusion on the likely levels of income and expenditure in your department 6. Recommendations on next steps Please make sure you provide a list of references to any published external material you refer to in your report. Make sure your report is at least 2,250 words to prove you’ve done some work but I’m not reading it if it’s more than 2,750 words apart from the references. I will not waste time reading appendices. If you have something to say, say it in your report. Our growing sales income has already enabled the Board to give employment to the Chief Executive’s son and I was frankly astonished to find that he has been assigned to the Finance department. As I am struggling to find any real use for his talents, I will be reading your report carefully for signs that you “need help” with financial matters, in which case I will have no hesitation in sending young Tony to “help” you on a daily basis. I look forward to receiving your report and seeing you at next Thursday’s meeting. Best Wishes, Iain “Until a man dies, wait and until then never call him happy but only fortunate.” Herodotus This email contains confidential information relating to Clark Casc Logistics plc. If you are not the intended recipient delete this email immediately. Further information As manager of the refrigerated goods division you are responsible for sales income from the transport of refrigerated goods. Note that the figures above are for six months. You are required to provide a budget for a full year and not for six months only. You are responsible for pricing and negotiating each contract. You have complete discretion over pricing and all refrigerated goods contracts must be signed by you or somebody authorised by you. You usually start by offering a price based on £0.22 per tonne per kilometre. However, if a prospective client has asked for sealed bids in a competitive bidding process you submit a bid priced at £0.19 per tonne per kilometre, which is approximately the average price you are able to negotiate with customers. The sales income generated by your department over the past six months has been as follows: February 2021 £000 March 2021 £000 April 2021 £000 May 2021 £000 June 2021 £000 July 2021 £000 Total £000 Income 2,108 2,129 2,156 2,170 2,190 2,214 12,967 As manager of the refrigerated goods division, you are responsible for the following costs: Salaries and Associated Payroll Costs In addition to the salaries below, Clark Casc is required to pay Employer’s National Insurance Contributions. Employer’s National Insurance Contributions are presently assessed as 13.8% of each employee’s salary, including bonuses but excluding the first £8,840 of the employee’s annual salary. Clark Casc is also required to pay an additional 0.5% of total salaries, including bonuses, as an apprenticeship levy. Clark Casc also contributes to an employees’ superannuation scheme. Clark Casc’s contribution is 8.5% of all staff salaries, including bonuses. All of these costs are part of your budget. Heavy Goods Vehicle Drivers: You have 202 drivers earning an average base salary of £35,000 per year. Each driver can presently cover about 125,000 miles per year. Last year, all drivers also qualified for a bonus of 10% of base salary for accident-free driving and there have been no vehicle accidents this year. Employer’s insurance is handled centrally and is not part of your department’s budget. Refrigerated Goods Depot Operatives You have 97 operatives working at you refrigerated goods depot, earning an average salary of £19,000 per year. Administrative Staff You have 11 administrative staff in the refrigerated goods department, earning an average salary of £27,000 per year. Property Plant and Equipment Vehicles Your department uses 151 heavy goods vehicles and 16 other vehicles, all of which are owned by Clark Casc. Each vehicle has an estimated useful life of 12 years in the company after which it can be resold for an estimated 10% of its original cost. The average replacement cost of a heavy goods vehicle is presently £120,000 and the average replacement cost of other vehicles is £24,000 per vehicle. You are responsible for the cost of depreciation on these vehicles. Depreciation is to be charged at current replacement cost. Vehicle Excise Duty Vehicle Excise Duty varies from vehicle to vehicle but is an average of £560 per vehicle per year for heavy goods vehicles and an average of £220 per vehicle per year for other vehicles. Vehicle Insurance Your vehicle insurance costs average £2,400 per vehicle per year for heavy goods vehicles and £400 per vehicle per year for other vehicles. Other Equipment You have just completed a major exercise with the finance department to establish what equipment you are using at the refrigerated goods depot and in the office. The annual depreciation cost at current replacement cost for this equipment is £228,000. Equipment insurance other than vehicle insurance is handled by another department and is not part of your budget responsibilities. Buildings Depreciation The depot and office which you occupy have a current replacement cost of £3,500,000 and a useful life of 50 years. The land which they occupy has a current resale value of £600,000 and the scrap value of the building materials is estimated at £100,000 at current prices. You are required to budget for depreciation on the buildings on a straight-line basis. Buildings Maintenance Buildings maintenance, including cleaning, is carried out by the in-house Buildings Maintenance Department and recharged to your department. It is a fixed cost and averages £7,000 per month. Equipment Maintenance Vehicle Maintenance Clark Casc’s vehicle maintenance department is under separate management. You are responsible for booking the vehicles in your department in for repairs, routine maintenance and annual testing. You are also responsible for ordering the recovery of any vehicles which have broken down or been involved in accidents. All of these services are managed by the vehicle maintenance department. There have been no motor vehicle accidents in your department in the last 18 months. Vehicle maintenance is a semi-variable cost. The vehicle maintenance costs charged to your department over the last six months have been as follows: The sales income generated by your department over the past six months has been as follows: February 2021 £000 March 2021 £000 April 2021 £000 May 2021 £000 June 2021 £000 July 2021 £000 Total £000 Vehicle Maintenance Cost 107 108 108 109 109 110 648 Other Equipment Maintenance Depot and office equipment maintenance is a fixed cost and averages £12,000 per month. Fuel and Power Costs Vehicle Fuel Vehicle fuel is a semi-variable cost. Total vehicle fuel costs for the last six months have been as follows: February 2021 £000 March 2021 £000 April 2021 £000 May 2021 £000 June 2021 £000 July 2021 £000 Total £000 Vehicle Fuel Cost 399 402 405 407 409 412 2,434 Other Power Supplies Gas and electricity supplies to the depot and office are a fixed cost and average £15,000 per month. Staff Training The cost of drivers’ training averages £1,225 per driver per year, including fees for Certificates of Professional Competence. Depot operatives’ training costs average £225 per operative per year. Administrative staff training costs average £275 per person per year. Other Costs There are no other costs in your budget. All other costs, including legal costs, employer’s insurance, public liability insurance and insurance of buildings and nonvehicle equipment, are handled by other departments and you are not responsible for managing them. Step Fixed Costs You presently have enough drivers and vehicles to meet demand up to 140 million tonne kilometres per year (£26,600,000 sales income per year at £0.19 per tonne kilometre). To fulfil orders above this level you will need 2 extra drivers and 1 extra heavy goods vehicle for every 1.4 million extra tonne kilometres per year (£266,000 sales income per year at £0.19 per tonne kilometre). If sales exceed 150 million tonne kilometres per year (£28,500,000 sales income per year at £0.19 per tonne kilometre), your department will need a new depot of the same size and with the same number of depot operatives as the existing depot and you will also need 3 additional administrative staff with salaries of £27,000 per year each. You are responsible for deciding whether to make this extra investment in a new depot or not. Additional Information You are the manager of the refrigerated goods department and you have full access to any additional information required. If more information is required from a published, broadcast or webcast source, you must present that information with a proper reference in the normal referencing format required in the business school. If further information would be required from internal sources at Clark Casc, you must create that information yourself for use in drawing up your report and provide your own indication of internal sources. You must not present a report which concludes that information is incomplete, or that further information is required or which recommends that further information is obtained. This would be a clear indication that you have not completed your report as required. Required: Write your report, addressed to the Managing Director of Clark Casc and containing the following sections, as directed in the Managing Director’s email. Submit your report in the Turnitin dropbox. 1. Introduction 2. Budgeting Approach 3. Relevant Calculations, including any investment appraisal 4. Proposed Income and Expenditure Budget 5. Conclusion 6. Recommendations 7. References Your report must be between 2,250 and 2,750 words in length excluding references. Do not include an executive summary. Appendices are not permitted. B. Project 1 Submission Guidelines Length 2,500 words, +/- 10% (excluding references, graphs, charts and numbers in tables. Presentation Arial 12 fonts, 1 ½ spacing. References All references must use the APA Referencing Style and the Napier house style as shown in the library referencing guide. C. Marking criteria and weights CRITERIA WEIGHTS Report Title, Addressee and Introduction (section 1) 10% Budgeting Approach (section 2) 10% Relevant Calculations and Budget, including any investment appraisal (sections 3-4) 50% Conclusions and Recommendations (sections 5-6) 20% Presentation and Referencing (references in American Psychological Association (APA) Format in Edinburgh Napier house style) 10% Total 100%
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
