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
Economic Order Quality or EOQ Define the model and the three methods of computing the EOQ. 1. Assumptions of the model. Illustration The given information was extra

need help to achieve my assignment

31. Special Orders Maria’s Food Service provides meals that nonprofi t organizations distribute to handicapped and elderly people. Here is her forecasted income statement for April

Manufacturing statements and cost behavior  Tampa Foundry began operations during the current year, manufacturing various products for industrial use. One such product is light-g

Cowboy Constructions employs a full-time driver and incurs costs for a vehicle to deliver paperwork between each of their building sites. Select Couriers has offered to carry out t

Samuel Construction Company engaged in a contract to construct a building on 1 July 2011 with completion of the contract by the 30 June 2014.  The contract price amounted to a tota

Encik Farid, a sole trader, started his business on 1 May 2010 under the name Farid Enterprise. The following are his business transactions for the month of May a. Encik Farid b

Find Out Overhead Application Rate The given is the budget of Superb Engineering Works for the 2002 year Factory overheads Kshs 62,000

some clarificationon how to compute closing stock and openning stock using marginal costing technique and absorption.

Process Cost Report This is a commonly employed statement that traces the flow of units produced and costs incurred in the production process. The report is prepared for every