Prepare a cash budget, Cost Accounting

You have been asked to prepare a cash budget for Whitborrow plc for the next three months, October, November and December. The Managers are concerned that they may not have sufficient cash to pay for a £150,000 investment in equipment in December. The overdraft has reached its limit £70,000 at the present time - the end of September. Sales during September were a total of £400,000 of which £55,000 was received in cash. £165,000 is expected to be paid on October, with the remainder likely to flow in during November. Sales for the next three months are as follows:

                                         Total sales                            Cash sales             Credit sales

            October                      450,000                              90,000                     360,000

            November                  550,000                              110,000                     440,000

            December                  700,000                              140,000                     560,000

There is a gross profit margin of 40 percent on sales. All cost (materials, labour and other) are paid for on receipt. Only 20 percent of customer sales are expected to be paid for in the month f delivery. A further 70 percent will be paid after one month and the remainder after two months. Labour and other costs amount to 10 percent of sales. Debtor levels at the end of September are £400,000 and the investment in stock is £350,000

Required:

a. Prepare a cash budget for October, November and December, and state if the firm will be able to purchase the new equipment.

b. Recommend action that could be taken to improve the working capital position of Whitborrow.

Posted Date: 3/9/2013 2:18:10 AM | Location : United States







Related Discussions:- Prepare a cash budget, Assignment Help, Ask Question on Prepare a cash budget, Get Answer, Expert's Help, Prepare a cash budget Discussions

Write discussion on Prepare a cash budget
Your posts are moderated
Related Questions
1. Why does rent control result in a shortage of rental units. 2. How does price elasticity of demand affect how much of a tax is passed on to the consumer and how much is absor

If fixed costs are $743,122 and variable costs are 69% of sales, what is the break-even point in sales dollars? Select the correct answer. A. $512,754 B. $2,397,168 C. $1,255,876 D

The follow data relates to year 20XX for Plano Manufacturing Company: Units produced - 2,000 Units sold - 1,800 Selling price - $200 / per unit Direct material costs - $80,000 Dire


the total (ie. aggregated) cashflows in respect to operations, with details of annual cash inflows & annual outflows in respect to operations, the total (ie. aggregated) cashflo

Draw the relevant diagrams for a typical farm, and for the market as a whole, when the market for wheat is in long run equilibrium. Assume the farm faces perfect completion. (hint,

Conan O'Brien Logging and Lumber Company owns 3,300 acres of timberland on the north side of Mount Leno, which was purchased in 2000 at a cost of $650 per acre. In 2012, O'Brien be

What is callable preferred stock? Why do corporations issue such stock? Given the different features that are associated with stock (callable, cumulative, preferred, etc.), what ty

Prepare Cash Budget of a Company The given information concerned to the proposed budget for a company for the months ending on 31 December 1996. Additional Information

Conceptualizing Job Costing Start to develop an understanding of job costing by thinking about the simple illustration. Jack Castle owns an electrical constricting company, Cas