Prepare a cash-flow budget and a profit budget

Assignment Help Project Management
Reference no: EM1312988

Learning Outcomes Assessed

This assignment will summative assess the following learning outcome: it should be able to apply and demonstrate an understanding of Various performance strategies and techniques. 

Coursework Question: 

Gringotts Ltd manufactures a product known as the Nimbus 500. A large number of other companies also manufacture the Nimbus 500 and the market price of the Nimbus 500 is forecast to be £220 during 2014. Market demand for the Nimbus 500 is highest towards the end of the year. Customers prefer to place the orders with manufacturers who are able to deliver Nimbus 500s immediately from their inventory.

A summarised version of Gringotts Ltd's balance sheet at 31 December 2013 is shown below.

Summarised balance sheet of Gringotts Ltd as at 31 December 2013

                                                                                                £

Plant and equipment (net)                       780,000

Inventory                                          80,000

Recievables                                                125,000

Cash at bank                                                            30,000

Payables                                                       (20,000)

Net assets                                                     995,000

 

Share capital                                               100,000

16% loan from shareholders                    500,000

Retained earnings                                     395,000

Capital                                                          995,000

 

 

During 2014, Gringotts Ltd is committed to:

  • Repaying £125,000 of the 16% loan from shareholders in June
  • Paying £40,000 interest on the loan in June and £30,000 interest in December
  • Paying interest on its bank overdraft at a rate of 5% per quarter on the balance outstanding on the last day of each quarter
  • Incurring fixed overhead costs (excluding depreciation) at a rate of £200,000 per quarter (all such costs are paid in the month in which they are incurred)
  • Incurring variable production costs at a rate of £100 per Nimbus 500 (75% of these costs are paid for in the month they are incurred and 25% in the month after they are incurred).

Gringotts Ltd's accounting policies include

  • Providing for depreciation at a rate of 5% per quarter on the net book value (i.e. cost less depreciation) of plant and equipment outstanding at the end of each quarter;
  • Valuing inventory (or 'stock') at a standard production cost of £160 per Nimbus 500.

In early January 2014, Gringotts Ltd's executives meet in order to discuss commercial strategy for the coming year. The sales director advocates an aggressive strategy (Strategy 1), involving new investment, high inventories and an expansion of sales. The finance director advocates a conservative strategy (Strategy 2) involving no new investment, minimising inventories and the adoption of a 'tight' credit policy on sales.

Relevant details concerning the two strategies are described in the following section.

Strategy 1

  • In January, acquire new production equipment at a cost of £360,000.
  • Offer 60% (by sales value) of customers, 2 months' credit and require the rest to pay immediately.
  • Make sales at a rate of 900 Nimbus 500s per month (quarters 1 and 2) and 1,100 Nimbus 500s per month (quarters 3 and 4).
  • Produce at a rate of 1200 units per month (quarters 1 and 2) and 1100 units per month (quarters 3 and 4)
  • A review of outstanding debts at the end of 2014 is forecast to result in a bad debt write-off totalling £64,000 (all relating to quarter 4 sales)

Strategy 2

  • Continue the existing credit policy of offering 50% (by sales value) of customers 1 month's credit and require the rest to pay immediately.
  • Make sales at a rate of 800 Nimbus 500s per month (quarters 1 and 2), 1,000 Nimbus 500s per month (quarter 3) and 1,100 Nimbus 500s per month (quarter 4).
  • Produce at a rate of 850 Nimbus 500s per month (quarters 1 and 2) and 1,000 Nimbus 500s per month (quarters 3 and 4).
  • A review of outstanding debts at the end of 2014 is forecast to result in a bad debt write-off totalling £10,000 (all relating to quarter 4 sales). 

Requirements: 

Note: In preparing your answer you may assume that cash is held on current account where it earns no interest and any cash deficit requirement is satisfied by drawing down on the overdraft facility. 

a)    Prepare a cash-flow budget and a profit budget for Gringotts Ltd on the basis of Strategy 1. The budgets should be split into quarterly intervals showing cash-flow and profit forecasts for each individual quarter.

b)    Prepare a cash-flow budget and a profit budget for Gringotts Ltd on the basis of Strategy 2. The budgets should be split into quarterly intervals showing cash flow and profit forecast for each individual quarter.

c)    Compare and contrast the two sets of budgets you have prepared in answer to requirements a) and b). Advise Gringotts Ltd's management on the relative merits of the two alternative strategies. Advise which strategy should be adopted and why.

Reference no: EM1312988

Questions Cloud

Consider the following program segment : Consider test cases  t 1 = ( n  = 3) and  t 2 = ( n  = 5). Although these tour the same prime paths in  printPrimes() , they do not necessarily find the same faults. Design a simple fault that  t 2 would be more likely to discover than  ..
Discuss the limitations of software testing : Discuss the limitations of software testing. How do we say that complete testing is impossible?  What is Software Quality Assurance? What are the objective and goals of SQA?
Human papilloma virus : Human Papilloma Virus. Read this review on how HPV controls the expression of its genes and explain to the class how HPV uses splicing and polyadenylation to regulate production of viral proteins.
Find the mass flow rate in through the vent of the enclosure : Find the mass flow rate in through the vent in question #1 using the following well-known relationship for the mass flow into an opening:
Prepare a cash-flow budget and a profit budget : This assignment will summative assess the following learning outcome: it should be able to apply and demonstrate an understanding of Various performance strategies and techniques.
The position of the neutral layer : A fire in an enclosure has reached flashover, & the gas temperature is assumed to be uniform at 1000oC. The enclosure has an opening 3 m wide & 2 m high. Find the position of the neutral layer, measured from the bottom of the opening.
Change in internal energy using first law of thermodynamics : Find the change in internal energy using first law of thermodynamics.
Internal torque acting at the cross section : A uniform shaft, fixed at one end & free at other, is twisted so that each cross - section rotates through an angle proportional to the distance from the fixed end. If the shaft is released from rest in this position, determine the s
Significance level and power of a test : The significance level of a statistical test is equal to the probability that the null hypothesis is true.

Reviews

Write a Review

 

Project Management Questions & Answers

  Project risk management approach

How does a project risk management approach pro-vide an early warning signal for impending problems or issues

  Create a wbs and a wbs dictionary

Essay Question: You have been assigned to a new innovative project in your organization. The scope has been completed. You next need to create a WBS and a WBS dictionary. What information should be contained in a WBS dictionary?

  Capital revenue in the public sector

Specification Stage, Design Stage, Build Stage, Capital revenue in the Public Sector, recurrent revenue in the Public Sector, Policy Framework (PF),  Vision Statement, Mission Statement

  Identify Risk in project management

Identify "Risk" in project management

  Describe and determine the designed capacity

Understand the primary concepts and practices underpinning Project management and able to devise and implement a project management plan and work effectively within a project team.

  What do you understand by the term scheduling

What do you understand by the term Scheduling? Explain how the following ways for duration compression of a project can be achieved- Fast tracking Crashing

  Questionaire on project management

Questionaire on Project Management

  Prepare a work plan and project schedule - gantt chart

Design an online system for the human resources department to manage available job positions.

  Explain the leadership steps

Determine what leadership steps you would take to enable you to achieve this across the different time zones and cultures. What conclusions can be drawn?

  What do you understand by net present value

You are the project manager of a leading textile engineering company. The company opened its door in year 2000. Today, after 13 years of existence, it is being challenged with a loss in profitability approximating a 65% loss in net revenue

  Explain most important aspect of project management

Explain most important aspect of project management.

  The factors that influence the monitoring of project work

What are the activities that are related to the Management of Project Execution? (b) Monitoring is an aspect of Project Management performed throughout the Project. What are the factors that influence the monitoring and control of project work?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd