• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12

Profitability & Reporting Assignment

Extracts from this document...


Profitability & Reporting Assignment Task 1a) From referring to and using the memo from Bob Harris and the figures in Appendix 1, I will be calculating the total profit. Appendix 1 is illustrated below. Division 1 2 3 4 Product P1 P2 P3 P4 Volume 7,000 6,500 10,000 8,000 S.P per unit (�) 11.00 10.00 10.50 12.00 Turnover 77,000 65,000 105,000 96,000 Materials 28,000 19,500 45,000 40,000 Labour 21,000 16,250 12,500 40,000 Other Costs Apportioned Central Overheads Personnel 10,000 8,000 7,000 10,000 Finance 5,000 6,000 6,000 7,000 Administration 4,000 4,000 6,000 6,000 TOTAL EXPENSES 68,000 53,750 76,500 103,000 PROFIT/LOSS 9,000 11,250 28,500 -7,000 Total Profit = Sum of Product 1 Profit + Sum of Product 2 Profit + Sum of Product 3 Profit + Sum of Product 4 Profit = �9,000 + �11,250 + �28,500 + �-7000 = �41, 750. Task 1b) The Saved Costs are going to be the Variable Costs. The Variable Costs from using the table above are Labour (�40,000) & Materials (�40,000). Labour costs will be saved because if division 4 was to close then Spark Ltd will not need any labour to manufacture product 4 and so no funds will need to be spent on purchasing materials to fabricate that respective product in that particular department. Subsequently, the company will save �80,000. This was determined by adding up the VC's and then deducting it from the table. The Incurred Costs which are still going to take place are the Fixed Costs. Fixed costs are those costs which remain congruent regardless of changes in the level of activity. In the case of Spark Ltd the fixed elements of costs can be identified as being Administration (�6,000), Finance (�7,000) and Personnel (�10,000). By totalling up these fixed costs it is evident that the company are going to incur �23,000. Task 1c) Based on my cost analysis in the previous question, I will now establish the change in total profit if division 4 was to close. ...read more.


To workout the profit/loss at any given point on the graph, all we have to do is measure the gap between the sales revenue and total costs at a chosen number of units, and read the amounts off the "y" axis. To test whether this method works, I will now take any two given points of both profit and loss on the chart and read the figures on the graph for those two specified points and see if they tally with my data. The rationale to calculate a certain level of profit or loss is mentioned below. In relation, these two given points are emphasised on a segregated graph in Appendix 1. The Point of Operating Profit that I have chosen to test is 35,000 units. For example, at an operating profit of 35,000 units, the profit "gap" is �110,000. This was calculated by at first looking at the maximum level of production scheduled for the first year (35,000 units), then going up to the point on the break-even chart until you reach the sales revenue figure of �770,000. Having once pinpointed the sales revenue figure, I then went down directly until I found the point of the total costs figure for 35,000 units which was �660,000. In turn, all I did was subtract the sales revenue figure of �770,000 away from the total costs of �660,000. This as a result gave me an operating profit figure of �110,000. The Selected Point at which Spark Ltd encounters a Loss and to which I have elected to use as an example is 10,000 units At an operating loss of 20,000 units, the loss "gap" is �40,000. In other words, at this point on the break-even chart, Spark Ltd encounters a deficit of �40,000 before they achieve break-even. Using the above example as a basis from which to work the loss out, all I did was simply go across the y axis until I identified 20,000 units. ...read more.


The method I used to verify the contribution per unit per kg was Contribution Per Unit/kg Per Unit. To obtain how much each division's products costs in terms of materials per 1 unit I referred to Appendix 1. Contribution Per Unit Per Kg Division 1 = �4.00 Contribution Per Unit/ 2kg = �2.00 per kg (Ranked 3) Division 2 = �4.50 Contribution Per Unit/1.5kg = �3.00 per kg (Ranked 1) Division 3 = �4.75 Contribution Per Unit/ 2.25kg = �2.1 per kg (Ranked 2) Division 4 = �2.00 Contribution Per Unit/ 2.5kg = 80p per kg (Ranked 4) As a direct consequence of finding out how much it costs each division in terms of contribution per unit per kg, I have now ranked each product according to which one contributes the most for Spark Ltd. If we consider the limiting factor, product 2 would be the most suited for Spark Ltd simply because it contributes/produces the most per unit, per kg. Revised Production Schedule As mentioned on the preceding page, I will now produce a revised production schedule for Spark Ltd. In order to make a final decision as to which product would be the most suitable, I will have to bear in mind the volume of each separate product that each division intends to produce because in the fax from Heather Bull, she specifically stresses that the firm will not be able to accommodate for any more than 50,000kg of materials. To calculate how much kg in terms of materials each separate product provides, I will have to multiply the expected volume of each product with the materials per 1 unit. Therefore, the revised production schedule will take the shape of something like: Product 2 = 6,500 x 1.5kg = 9,750kg Product 3 = 10,000 x 2.25kg = 22,500kg Product 1 = 7,000 x 2kg = 14,000kg Product 4 = 1500 x 2.5kg = 3,750kg Amish Patel PAR Upal Banerjeee ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Accounting & Finance section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Accounting & Finance essays

  1. In this assignment I am opening a tuck shop in the school grounds and ...

    Revenue (selling price) Crisps = 35p Drinks = 45 Chocolates = 30p Total revenue = �1.10 Average cost = 110p/3 = 36.666p (rounded to 37p) To work out my Break even I need to use a formula which is: Fixed cost Selling price - Variable cost �1200 �1200 = =

  2. Discuss the Need for Regulation in Financial Reporting

    beyond the immediate short term but it also requires them to inform users should there be any doubt over the firm's ability to survive in its present form. The accruals concept recognises costs and revenues as they are earned, not necessarily when the cash flow relating to them is paid or received.

  1. Comsat case

    Using Corporate Bonds as the Cost of Debt 13.06% = 7.53% + 5.53% The cost of equity using corporate bonds is 13.06 percent. It was calculated by adding the cost of debt, which was 7.53 percent to the equity risk premium, which was 5.53 percent.

  2. Give an explanation of break-even analysis and explain how it supports the achievement of ...

    Break-even analysis is simple to understand and useful-especially in small firms. Businesses can use break-even to: * Estimate the future level of output they will need to produce and sell in order to meet given objectives in terms of profit.

  1. The business plan

    0.50 Cadbury's Flake 0.45 Cadbury's Twirl Twin Packs 0.45 Toblerone bar 0.45 Ice-cream cone with Vanllia 0.45 Ice-cream cone with Chocolate 0.45 Ice-cream cone with Strawberry 0.45 All the product information See Appendix B 1. Would you like a tuck shop being set up in the house?

  2. What does Finance involve.

    Now that I know I have to raise �17,000 (�16619.61: put in a whole number) in order to finance the start of my business. There are some options available to me these options are borrow form a bank, go into partnership, sell shares, sell or rent out the flat above my shop or re-mortgage my flat.

  1. Describe the following features of their two chosen businesses.

    It is slow to make decisions because everyone has to know. You have to pay dividends, this means that if you own one percent of the share you will receive one percent of the profit. Also you loose control this means that you would not be able to have a

  2. Exploring business purposes

    It is no use developing new products or services if no one knows about them. Marketing is therefore responsible for the promotional activities which tell the customers what is obtainable, such as by advertising, sales promotions and publicity campaigns. The company website is a major way of communicating with prospective

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work