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
Determine the Absorption Rate of Overheads The budgeted production overheads and other budgeted data of compute are given as: Budget Overhead cost for the period = Ks

i asking for start up

maintenance costs at a hospital

Identify and explain many classification of costs for planning, control, performance evaluation and decision making.

Considerations in Variance Investigation As already notice above, not all variances are investigated; this is only the material and meaningful as for cost control reasons vari

introduction on proess costing

Understanding the existing capital requirements and how these are financed will assist us in understanding the process of financing of business and the flow of funds inside the bus

what are the purposes of cost accounting information

The firm currently uses 50,000 workers to produce 200,000 units of output per day. The daily wage per worker is $80, and the price of the firm’s output is $25. The cost of other va

You perform a travel cost study that looks at the relationship between the cost of visiting a lake (including costs of travel, value of time spent not working & any entry fees), it