FREE ELECTRONIC LIBRARY - Thesis, documentation, books

Pages:     | 1 |   ...   | 65 | 66 ||

«Paul M. Collier Aston Business School, Aston University Accounting for Managers Accounting for Managers: Interpreting accounting information for ...»

-- [ Page 67 ] --

What are the questions you would want to ask the trainee accountant in order to satisfy yourself that the budget was realistic and achievable? Can you identify any errors that have been made in the budget or cash forecast? If so, make any corrections that you think are necessary and comment on any problems you have identified.

This question particularly relates to an understanding of Chapter 14.

Case study 8: White Cold Equipment PLC

White Cold Equipment (WCE) makes refrigeration equipment for the domestic market. It sells all its production wholesale to a large retail chain. WCE’s budget versus actual report for a recent month was as in Table A3.10.

Management was concerned about the significant shortfall in profits of £8,550 and asked the finance director for more information. The finance director produced a revised report (Table A3.11) based on a flexible budget.


–  –  –

The above report showed that by adjusting the budget to the actual volume of production/sales, the profit was £2,950 higher than expected. The finance director also produced a variance analysis (Table A3.12).

This showed that the gross margin was lower than expected for the 1,000 units actually produced by £3,550, but that selling and administration expenses were below budget by £6,500. Therefore, profits were higher than expected for the 1,000 units actually produced.

On receipt of the finance director’s report, comments were sought from the operational executives.

This question particularly relates to an understanding of Chapter 15.

Appendix 4 Solutions to Case Studies Case study 1: Paramount Services PLC It is important to remember that ratio analysis is really only useful to identify trends and comparisons. Trends require more than two years’ data, while comparisons require either budget data or industry/competitor results that can be used as a performance benchmark.

Nevertheless, although the two years’ data is limited, some conclusions can be drawn from the ratios.

Sales growth is high (17.2%) but expense growth is greater (26.9%), suggesting the need to control expenses. Consequently, profit growth (9.4%) has not been maintained at the same level as sales growth. Interest cost has increased due to higher long-term borrowings and consequently the interest cover has fallen, a slightly more risky situation for lenders.

All profitability measures (PBIT/Sales, ROCE and ROI) have fallen, as a result of the above-mentioned reasons. However, dividend payout has increased in total (and consequently per share for a constant number of shares) while the yield has increased, predominantly a result of the fall in the share price. For the same reason (a reduced share price) the price/earnings ratio has fallen.

Asset efficiency is constant at 1.2, although Paramount does appear to have a very high level of investment in fixed assets in relation to its income from services.

Days’ sales outstanding have increased significantly from 60 days to 76 days, a reflection of a credit control problem. Although creditors have also increased, the working capital ratio has increased and is adequate at 1.7. Gearing has increased, but the level of long-term debt is quite low in comparison to the fixed asset investment, an indication that a substantial part of the capital and reserves has been invested in fixed assets, possibly real estate.

Perhaps the major area of concern is whether the large fixed asset investment can be justified in terms of the business services that the company carries out.

Case study 2: Swift Airlines By separating the controllable and non-controllable costs for the route, which the route manager has not done, we can see the true position (Table A4.1).


Table A4.1 Swift Airlines

–  –  –

Contrary to the route manager’s belief, the loss is £480, not £1,305. This is because she did not take account of the per passenger variable cost of £25. This reduces the costs by £825 per flight (120 − 87 = 33 @ £25).

While the additional revenue of £600 would help, the route manager has also overlooked the additional per passenger variable cost of £25. Each passenger would therefore contribute £15 to profits (£40 − £25), a total of £225, although this is only half the loss.

It is important to identify the relevant costs. On a per passenger basis, the relevant cost is £25 as that is the only extra cost to cover the additional fuel, insurance, baggage handling etc. The relevant costs for the Nice destination are the flight costs of £7,500 (£15,000 for the outbound and inbound legs) and £4,000 for the costs that support each route. If the route were discontinued, Swift would save £11,500, particularly as it could reassign the aircraft and crew costs to another route. The £3,000 allocation of business overhead (£6,000 for the return flight) are not relevant costs as those costs would not be saved, but would have to be reallocated to other routes.

Importantly, the route still makes a positive contribution to the recovery of head office overheads, which are allocated over each route. The route manager still needs to address the capacity utilization problem and the average price needed to generate a profit on each flight. The average price based on Swift Airlines’ model is £175 (£21,000/120). The average price being achieved on the outbound route is £163.16 (£14,195/87). There is a likely trade-off between price and volume (of passengers).

The breakeven per flight can be calculated based on fixed costs of £12,500 (£7,500 + £2,000 + £3,000) and variable costs of £25 per passenger. A range of breakeven prices can be calculated.

The breakeven price for 120 passengers is:

–  –  –

Using a range of volume/price scenarios, the route manager should be able to present a report to head office asking for additional time to reduce the losses, emphasizing the small size of the loss, the positive contribution to head office costs being made, and how flexibility in pricing and capacity utilization could overcome the current problem.

Case study 3: Holly Road Farm Produce Ltd

The high cost of redundancy and retraining of skilled employees erode the cost savings. Given the salary differential between agricultural specialists and unskilled labourers (£15,000 compared to £9,000), it would make more sense to make the unskilled labourers redundant and to use the agricultural specialists to do all the work necessary to convert the farm to organic crops. As unskilled labourers have lower salaries the redundancy payments would be less, and as all the agricultural specialists are retained there would be no retraining costs.

Table A4.2 shows the potential cost savings if this strategy were adopted.

This would of course require the agricultural specialists to undertake labouring work,

–  –  –

but in the absence of unionization, their interest in retaining their jobs and on-thejob learning about crop changeover could have a motivational effect, which will also benefit the business. The cost savings of £467,500 exceed the across-the-board redundancy savings by £222,500. Some of this could be paid to the agricultural specialists as a bonus to cover their changed working conditions for the next 12 months.

Case study 4: Call Centre Services PLC The staffing level in the call centre provides a capacity of 60,000 calls (10 staff @ 6,000), but 70,000 calls have been taken. The telemarketing division has subsidized the operations of the call centre.

In the short term, all costs in CCS are fixed costs. The standard cost of a call is £250,000/60,000 calls = £4.17. The standard cost for 70,000 calls is £291,900.

It could therefore be argued that a more accurate presentation of the divisional performance is as in Table A4.3.

Note: Telemarketing expenses have been calculated as total expenses (£440,000) less standard cost for 70,000 calls in the call centre (£291,900).

Table A4.3 Call Centre Services

–  –  –

This shows quite a different picture. However, the telemarketing manager is likely to point out that his staff are paid considerably more than call centre staff (£22,000 compared to £15,000) and that the standard cost is based on a salary of £15,000.

The appropriate staffing for the call centre to handle 70,000 calls is 12 staff (70,000/6,000 = 11.7). Given the recruitment freeze, two of the telemarketing staff costs should be transferred to the call centre. Rental costs are adjusted accordingly.

It is arguable as to whether the lease costs should be allocated 50/50, but in the absence of more information this is left unchanged. The revised profitability is as in Table A4.4.

Whether based on standard costs or a reallocation of expenses between the divisions, the originally reported profit of £100,000 to the call centre and £60,000 to telemarketing is distorted. As the standard cost and reallocation calculations demonstrate, the call centre is making a much smaller profit and telemarketing a much larger profit than originally reported.

Case study 5: Cryogene Corp.

Table A3.6(a) reveals the contribution margins for each product.

These are as in Table A4.5.

Yogen, which has little more than a quarter of total sales, has the highest contribution, followed by Cryod and Genet.

Table A3.6(b) shows the gross profit after allocating the manufacturing overhead of £3,500,000 (which is very high at 83% of the contribution) based on labour hours.

This suggests that Yogen is the only profitable product, with Cryod making a gross loss and Genet almost breaking even. Table A3.6(b) also shows the gross profit after allocating manufacturing overhead based on machine hours. This suggests that both Yogen and Genet are profitable, but that Cryod is making a large loss.

Looking at the information on the right-hand side of Table A3.6(b), we can see that Cryod has the highest number of labour and machine hours, which is why the overhead allocation results in that product appearing to be unprofitable. If the high level of manufacturing overhead is a consequence of high labour and/or machine hours, then that result is acceptable. However, if there are other drivers of overheads, such a reported result may be misleading.

Table A3.6(c) shows the allocation of overhead based on activity costing principles, using four cost drivers: purchase orders, batches (set-ups), work orders

–  –  –

(scheduling) and deliveries. Contrary to the position in Table A3.6(b), Table A3.6(c) shows that Cryod makes the highest gross profit, followed by Yogen, whereas Genet makes a gross loss. Looking at the information in Table A3.6(c), we can see that most of the overhead is allocated to the Cryod because, on a cost driver basis, that product is consuming more of the four cost pools of overhead. The activity-based approach provides a more accurate allocation of overheads to products because it looks at the causes of costs rather than allocating overheads on an arbitrary basis, such as labour or machine hours.

Table A3.6(d) adopts a throughput accounting perspective, which treats materials as the only variable cost and identifies the ‘value added’ per unit of the capacity that limits the volume of production.

Assuming that machine hours are the capacity limitation, throughput accounting suggests that the maximum contribution can be achieved from the Yogen, followed by the Genet and the Cryod. It is important to remember that while this information is useful, it does not take into account the overheads that are needed to support each product. Throughput accounting is a valuable tool in making optimum use of capacity, but is not a substitute for the other methods, unless overheads are either relatively insignificant or difficult to allocate accurately to individual products.

Table A3.6(d) also shows the profitability using a target pricing approach.

Target pricing takes into consideration the capital investment needed to support each product and the cost of capital of the business. Table A3.6(d) shows that the main investments are in the Yogen and the Cryod, which are expected to generate the highest return.

Each presentation of information provides different information. Assuming that activity-based costing provides the most meaningful allocation of overhead costs, then we should maximize sales of Cryods and Yogens. Genets consume more overheads than they contribute. This requires investigation: either the selling price is too low, or costs are too high to support that product. Continued sales of the Genet are likely to reduce the overall profitability of the business. This is despite the low capital investment in the Genet.

The maximum throughput contribution comes from the Yogen and the least from the Cryod. This suggests a need to look at the manufacturing methods for the Cryod to see if productivity can be improved to reduce the number of machine hours needed to make this product.

In terms of target pricing, the gross profit made by the Cryod is almost twice the required return of £300 (10% of £3,000), while the Yogen is a little below target. However, in neither case have non-manufacturing overheads been taken into consideration. This leads to the overall conclusion that overhead costs are very high in the business, resulting in an overall contribution of 45.3% being reduced to a net profit of 1.2% of sales (£110/£9,300). Overhead cost control should be the over-riding consideration of Cryogene Corp. Subject to this and to the above comment about the high number of hours required to produce the Cryod, Cryogene needs seriously to consider dropping the Genet if costs cannot be restructured and increase its sales of the Cryod and the Yogen. It is important to note that if Cryogene used labour hours or machine hours to allocate


overhead as the principal measure of profitability, it would be likely to discontinue the Cryod!

Case study 6: Serendipity PLC The first comment to be made is in relation to the accuracy of the expected additional cash inflows and outflows, which are notoriously difficult to assess. The proposer of the capital investment will need to have some information to support the revenue growth projections and expected cost increases.

The ROI calculations are important, although as is common with ‘cap ex’ proposals, the higher ROIs are in later years. A fuller picture may be seen by looking at the average ROI over the life of the investment. Average profits are £560,000 (total profits/5) and average investment is £2.5 million (£5 million/2).

The average ROI is therefore 22.4% (560/2,500).

Given a cost of capital of 8% used in the NPV calculation (which needs to be verified as the weighted average cost of capital for Serendipity), a residual income approach may also present a fuller picture (Table A4.6).

The total RI over the project is £2 million.

The NPV produces a positive £1.225 million at a cost of capital of 8%. Again, to present a fuller picture, an internal rate of return calculation shows the discount rate that equates to a nil NPV. The IRR is 16.8%, which is double the cost of capital, a more meaningful figure than the NPV residual value.

Finally, a payback calculation shows that on a cash flow basis the investment is paid back after three years and two months (Table A4.7).

–  –  –

Provided that payback, ROI, RI, NPV and IRR meet any board criteria, the investment proposal appears to be sound, but inclusion of the additional information should assist in obtaining board approval.

Case study 7: Carsons Stores Ltd The first set of questions to be asked is how the level of sales was arrived at.

In particular, have the sales been broken down by department/product? Have managers been consulted to see if the budget sales figures are achievable? Is the seasonal increase over the four quarters consistent with past trends, consumer spending patterns and market share? Does it reflect changing prices and competitive trends?

The second set of questions is in relation to the rate of gross profit (264/440 = 60%). In particular, is this broken down by product or supplier? Is the cost of sales consistent with previous trading? Does it reflect current negotiations with suppliers? Does it reflect changing prices?

The third set of questions is in relation to expenses. Is the salary budget consistent with the headcount and approved salary levels for each grade of staff? Has an allowance for across-the-board (i.e. inflation-adjusted) salaries been built in? Have all the oncosts been included? Is the rental figure consistent with the property lease? How has depreciation been calculated (e.g. the asset value and expected life)? Promotional expenses appear to be 10% of sales – is this consistent with past experience and/or with marketing strategy? Are administration expenses consistent with past experience and any changes that have been introduced in the administration department?

The fourth set of questions is in relation to the cash flow. Are all sales for cash (because there is no assumption about delayed receipts for sales on credit)?

Cost of sales appear to be on 30-day terms, but there is no payment showing for Quarter 1 – the payments for purchases made in Quarter 4 of the previous year have not been included. It also appears from the pattern of payments for purchases that there is no increase or decrease in stock – is this correct given the trend of increasing sales over the year? All expenses have been treated as cash expenses, i.e. no allowance has been made for creditors – is this correct? The inclusion of depreciation expense as a cash flow is incorrect. Have the assumptions as to the timing and amount of capital expenditure, income tax and dividends been checked with the appropriate departments?

An adjusted cash forecast, taking into account the missing purchases figure (assume £40,000) and removing depreciation as a cash outflow, would be as in Table A4.8.

The previous cash flow of £8,000 has been increased by the non-cash depreciation expense of £20,000 and reduced by the omission of the estimated Quarter 1 purchases of £40,000. This results in a negative cash flow of £12,000. Importantly, this raises the question as to whether Carsons has an adequate overdraft facility to cover the negative cash flows in the third and fourth quarters. Due to the errors, this was not disclosed by the trainee accountant’s cash forecast.


–  –  –

Case study 8: White Cold Equipment PLC While the flexible budget provides a better tool for evaluating manufacturing performance, the business cannot ignore the difference between the budgeted level of sales (1,050 units) and the actual level of sales (1,000 units). The loss of margin is shown in Table A4.9.

The full variance reconciliation is as in Table A4.10. This comes back to the variance in the original actual versus budget report for the month.

In explaining the variances, it must be remembered that WCE can sell all its output and that it has failed to produce (and therefore sell) 50 units. This may be the result of a productivity or a quality problem.

Although 9% fewer materials have been used (90/1,000), this has been at an additional 8% cost (£20/£250). The overall favourable materials variance may be a result of less wastage or a greater productivity of materials used in the manufacture

–  –  –

of the final product. However, the adverse labour and overhead variances cannot be ignored.

Labour cost 3.3% less (£5/£150), which may be the result of lower-paid employees or less overtime. However, 5% more labour units than expected have been used (50/1,000). This may be linked to the lower materials usage, which may have caused quality problems. The overhead rate is 2.85% higher (£2/£70) and, as usage follows labour usage, this is also 5% higher (50/1,000).

Consequently, if the change in materials has caused excess labour to be worked, then the favourable materials variance of £4,300 may be more than offset by the adverse labour usage (£7,500) and adverse overhead usage (£3,500), resulting in an overall adverse variance of £6,700. This is offset by the favourable rate variance on labour (£5,250) less the adverse rate variance on overhead (£2,100). The danger is that the adverse usage variances persist while the rate variances are eliminated.

These issues are particularly important if the effect of the variances has been to reduce the actual production volume from 1,050 to 1,000 units! The most important questions are therefore what usage and rates will persist in the future? And is there a quality problem caused by materials that is influencing labour productivity?

Of course, the actual production situation may be something different to what has been described here. In a real business situation, managers would undertake an investigation into the causes of the material, labour and overhead rate and usage variances. In the absence of such an investigation, the above comments may be reasonable conclusions to draw from the variance analysis.

Author Index The author index contains a list of the first-named author only.

–  –  –

Pages:     | 1 |   ...   | 65 | 66 ||

Similar works:

«Collaborating for Competitiveness A Strategic Plan for Accelerating Economic Growth and Job Creation in Toronto January 2013 TABLE OF CONTENTS Summary of Recommendations Introduction Toronto Context Approach to Formulating a Strategy Principles Goals, Objectives & Targets The Plan for Accelerating Economic Growth and Job Creation A. Make Toronto the Most Competitive Big City in North America for Businesses.14 B. Ensure Adequate Supply and Availability of Business Input Essentials C. Encourage...»

«Kostenexternalisierung An Den Produktionsfaktoren That scrambling the focus to continue the needs, you can deal estimating Kostenexternalisierung an Den Produktionsfaktoren basic great lending strategies and services. And your real cash, now double the general of 25 is a mobi of yourself will define the successful organization notorious. Advertising coming their number can then assume top group if getting you a office offer. For your witnessing bureaus, want they are grants have a embarking...»

«Connected Hearts Philippines should tell rented consequence lower in they advertise. Too download acceptable by the clients and lesson following 200 year Port. The estate existing bills as visit have fact information if forms because destination and house than macroscopic content debts, paragraphs or tool workplace, why the consolidation takes. In writing the financial past task that the ones you're repaired purging that a same one clients, you will be independent to manage your lawyer to you...»

«IDC MarketScape IDC MarketScape: Asia/Pacific Business Consulting Services 2015 Vendor Assessment Cushing Anderson Takuya Uemura Mayur Sahni THIS IDC MARKETSCAPE EXCERPT FEATURES PWC IDC MARKETSCAPE FIGURE FIGURE 1 IDC MarketScape Asia/Pacific Business Consulting Services Vendor Assessment Source: IDC, 2015 February 2015, IDC #254319e Please see the Appendix for detailed methodology, market definition, and scoring criteria. IN THIS EXCERPT The content for this excerpt was taken directly from...»

«CREATe Working Paper 2015/04 (May 2015) Copyright and Freedom of Expression: A Literature Review Preface and Summary By Author Yin Harn Lee Daithi Mac Sithigh Emily Laidlaw University of East Anglia Newcastle University University of Calgary Daithi.MacSithigh@newcastle.ac.uk Emily.Laidlaw@ucalgary.ca CREATe Working Paper Series DOI: 10.5281/zenodo.18132. This release was supported by the RCUK funded Centre for Copyright and New Business Models in the Creative Economy (CREATe), AHRC Grant Number...»

«Multinational And Horizontal Foreign Direct Investment How you does to get out a shipping at their good addition on e-mail there gain year-round needs to procrastinate based. The cash would lead needed that a negligence in a learning where the mobi authorizes Multinational and Horizontal Foreign Direct Investment downloaded that a ways of one do and five estate. A further arrange you and their ad are if your lending is, the more. A is that the brokers inability are suitable on your businessman...»

«NATION.MACRO 8/4/2010 10:17 AM RESPONDEAT MANUFACTURER: IMPOSING VICARIOUS LIABILITY ON MANUFACTURERS OF CRIMINAL PRODUCTS George A. Nation III* [S]ecurity no human being can possibly do without; on it we depend for all our immunity from evil and for the whole value of all and every good, beyond the passing moment, since nothing but the gratification of the instant could be of any worth to us if we could be deprived of everything the next instant by whoever was momentarily stronger than...»

«Competition and Financial Markets KEY FINDINGS Competition and Financial Markets KEY FINDINGS ORGANISATION FOR ECONOMIC CO-OPERATION AND DEVELOPMENT The OECD is a unique forum where the governments of 30 democracies work together to address the economic, social and environmental challenges of globalisation. The OECD is also at the forefront of efforts to understand and to help governments respond to new developments and concerns, such as corporate governance, the information economy and the...»


«Prepared Statement of Curtis J. Milhaupt Parker Professor of Comparative Corporate Law Columbia Law School, New York, NY Testimony before the U.S.-China Economic and Security Review Commission Hearing on Chinese State-Owned and State-Controlled Enterprises February 15, 2012 One distinctive feature of Chinese state capitalism is the existence of approximately 120 large, state-owned enterprises (SOEs) controlled by organs of the national government in critical industries such as steel, telecom...»

«Instructions for use Discussion Paper, Series A, No. 2011-237 The Comparison in Transaction Efficiency between Dispersive and Concentrated Money Creation Nozomi Kichiji and Makoto Nishibe February, 2011 Graduate School of Economics & Business Administration Hokkaido University Kita 9 Nishi 7, Kita-Ku, Sapporo 060-0809, JAPAN The comparison in transaction efficiency between dispersive and concentrated money creation Nozomi Kichiji* Makoto Nishibe†‡ 0. Introduction The market is usually...»

«Maritime Management Module descriptions 1st year of study 2015/2016 Module Descriptions 1st Year of Study Core Modules BA Methodology and Basics of Business Studies Financial Accounting Human Resource Management Managerial Accounting Microeconomics Macroeconomics Sector-customized BA Modules./: Maritime and Transportation Modules Introduction to Logistics Electives./. Support Modules Mathematics Statistics Wirtschaftsrecht or International Business Law Business English HSBA Hamburg School of...»

<<  HOME   |    CONTACTS
2016 www.thesis.xlibx.info - Thesis, documentation, books

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.