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


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
Go the Hershey website to learn how to make Hershey chocolate. Review the process and take a look at some of the videos. Pay particular attention to the process steps of milling an

Importance of Cost Classification Analysis of cost behaviour is significant to all organizations for effective management. It is since many organizations have a unique cost st

ASSUMPTIONS OF BREAK EVEN ANALYSIS 1. Fixed costs for all time remain constant. 2. All costs are divided into fixed and variable costs. 3. Selling price will not alter de

Mission Foods produces two flavors of tacos, chicken and fish, with the following characteristics: Chicken Fish Selling price per taco $3.00 $4.50 Variable cost p

Write a mini report in which you "Critically Describe, Aanlyse and Reflect on the Brand Image Extension.  This task must include evidence of collection primary data on the same

Objectives of Budgetary Planning 1) Coordination The budgetary process needs that visible detailed budgets are developed to cover every activity, function or department

This coursework is intended to help you develop your understanding of shell scripting in both a Windows and Unix environment. You should undertake this coursework in groups cons

Smith Corp. has determined that its contribution margin, (P - MC)/P, is 40%. A recent market research study found the following relationship between adverting outlays and sales rev

Which method of measuring costs associated with production is more widely used in practice A. Normal Costing  B. Actual Costing  C. Both are used equally  D. Neither one

What are the journal entries to recognize each of the below events. a.   The firm records bad debt expense of 5% of credit sales, which were $300.  The firm uses the Percentage