Question 2a
You will get this Formula Table at the exam so learn well how to apply it in your APM (P5) Exam
Framiltone is a food manufacturer based in Ceeland, whose objective is to maximise shareholder wealth. Framiltone has two divisions: Dairy division and Luxury division. Framiltone began manufacturing dairy foods 20 years ago and Dairy division, representing 60% of total revenue, is still the larger of Framiltone’s two divisions.
Dairy division
This division manufactures cheeses and milk-based desserts. The market in Ceeland for these products is saturated, with little opportunity for growth. Dairy division has, however, agreed profitable fixed price agreements to supply all the major supermarket chains in Ceeland for the next three years. The division has also agreed long-term fixed volume and price contracts with suppliers of milk, which is by far the most significant raw material used by the division.
In contrast to Luxury division, Dairy division does not operate its own fleet of delivery vehicles, but instead
subcontracts this to a third party distribution company. The terms of the contract provide that the distribution company can pass on some increases in fuel costs to Framiltone. These increases are capped at 0·5% annually and are agreed prior to the finalisation of each year’s budget.
Production volumes have shown less than 0·5% growth over the last five years. Dairy division managers have invested in modern production plant and its production is known to be the most efficient and consistent in the industry.
Luxury division
This division was set up two years ago to provide an opportunity for growth which is absent from the dairy foods sector. Luxury division produces high quality foods using unusual, rare and expensive ingredients, many of which are imported from neighbouring Veeland. The product range changes frequently according to consumer tastes and the availability and price of ingredients. All Luxury division’s products are distributed using its own fleet of delivery vehicles.
Since the company began, Framiltone has used a traditional incremental budgeting process. Annual budgets for each division are set by the company’s head office after some consultation with divisional managers, who currently have little experience of setting their own budgets. Performance of each division, and of divisional managers, is appraised against these budgets. For many years, Framiltone managed to achieve the budgets set, but last year managers at Luxury division complained that they were unable to achieve their budget due to factors beyond their control. A wet growing season in Veeland had reduced the harvest of key ingredients in Luxury’s products, significantly increasing their cost. As a result, revenue and gross margins fell sharply and the division failed to achieve its operating profit target for the year.
Framiltone has just appointed a new CEO at the end of Q1 of the current year. He has called you as a performance management expert for your advice.
‘In my last job in the retail fashion industry, we used rolling budgets, where the annual budget was updated to reflect the results of every quarter’s trading. That gives a more realistic target, providing a better basis on which to appraise divisional performance. Do you think we should use a similar system for all divisions at Framiltone?’, he asked.
You have obtained the current year budget for Luxury division and the division’s Q1 actual trading results (Appendix 1) and notes outlining expectations of divisional key costs and revenues for the rest of the year (Appendix 2).
Luxury division current year budget
C$’000 | Q1 | Q2 | Q3 | Q4 | Total | Q1 Actual |
---|---|---|---|---|---|---|
Revenue | 10,000 | 12,000 | 11,000 | 7,000 | 40,000 | 10,400 |
Cost of sales | (6,100) | (7,120) | (6,460) | (4,720) | (24,400) | (6,240) |
Gross profit | 3,900 | 4,880 | 4,540 | 2,280 | 15,600 | 4,160 |
Distribution costs | (600) | (720) | (660) | (420) | (2,400) | (624) |
Administration costs | (2,300) | (2,300) | (2,300) | (2,300) | (9,200) | (2,296) |
Operating profit | 1,000 | 1,860 | 1,580 | (440) | 4,000 | 1,240 |
Appendix 2
Expected key costs and revenues for remainder of the current year
1. Sales volumes are expected to be 2% higher each quarter than forecast in the current budget.
2. Average selling price per unit is expected to increase by 1·5% from the beginning of Q3.
3. The exchange rate between the Ceeland Dollar (C$) and the Veeland Dollar (V$) is predicted to change at the beginning of Q2 to C$1·00 buys V$1·50. For several years up to the end of Q1, C$1·00 has been equivalent to V$1·40 and this exchange rate has been used when producing the current year budget. Food produced in the Luxury division is despatched immediately upon production and Framiltone holds minimal inventory. The cost of ingredients imported from Veeland represents 50% of the division’s cost of sales and suppliers invoice goods in V$.
4. The rate of tax levied by the Ceeland government on the cost of fuel which Luxury uses to power its fleet of delivery vehicles is due to increase from 60%, which it has been for many years, to 63% at the beginning of quarter 3. 70% of the division’s distribution costs are represented by the cost of fuel for delivery vehicles.
5. The CEO has initiated a programme of overhead cost reductions and savings of 2·5% from the budgeted administration costs are expected from the beginning of Q2. Q3 administration costs are expected to be a further 2·5% lower than in Q2, with a further 2·5% saving in Q4 over the Q3 costs.
Required:
(a) Using the data in the appendices, recalculate the current year budget to the end of the current year and
briefly comment on the overall impact of this on the expected operating profit for the year. (12 marks)