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
how the NHS might use ABC to (a) produce ‘product costs’ for services, and to (b) evaluate the internal efficiency, quality and profitability per product or service line. Both bene

Denair Fine Wines, Inc., is planning to bring out a higher-quality wine product than any currently available in Stanislaus county. They've decided on selling the blended, fortified

Elite Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $300,000 cost with an expected four-year life a

Find a journal article online about just-in-time inventory systems. In the subject line of your post, include the title of the article that you read. Post a link to that article wi

Determine the Incremental Cost A company currently makes a component that has the given unit cost structure Direct Material Shs. 100

Financial Statement Issues that are Unique to Manufacturers Different from the retailers, manufacturers have three exclusive inventory category: 1) Raw Materials, 2)Work in

Typical Causes of Material Variances Price Variances a) Paying lower or higher prices than planned. b) Losing or gaining quantity discounts via buying in large

A machine costing $210,400 with a four-year life and an estimated $20,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the mac

what is the implication of applying accounting principle wrongly

With the internal rate of return, how can a company use the ROI methodology as a realistic measurement? Please discuss the pros & cons of each measurement statistic.