Prepare a cash budget for each of the first three months, Financial Accounting

Assignment Help:

Question :

The subsequent data pertain to a shop. The owner has made following sales forecasts for the first 5 months of the coming year.
                                                       £.
January                                       40,000
February                                     45,000
March                                          55,000
April                                             60,000
May                                             50,000

Other data are as follows:

(a) Debtors and creditors' balances at the beginning of the year are £ 30,000 and £14,000 respectively. The balances of other relevant assets and liabilities are:
                                                       £.
Cash balance                              7,500
Stock                                          51,000
Accrued sales commission           3,500

(b) 40% sales are on cash basis. Credit sales are collected in the following month of sale.

(c) Cost of sales is 60% of sales.

(d) The only other variable cost is a 5% commission to sales agents. Sales commission is paid in the month after it is earned, i.e.,time-lag is one month.

(e) Inventory is kept equal to sales needs for the next two months' budgeted sales.

(f) Trade creditors are paid in the subsequent month after purchases.

(g) Fixed costs are £ 5,000 per month, including £ 2,000 depreciation.

Required:

Prepare a cash budget for each of the first three months of the coming year.


Related Discussions:- Prepare a cash budget for each of the first three months

Lenders evaluation, Lenders'  evaluation:   Current  Assets  to  Current  L...

Lenders'  evaluation:   Current  Assets  to  Current  Liabilities,  Quick  Assets  that is current assets minus inventories to Current Liabilities, Long term Debt to Net Assets, to

Consequences of adjudication-adjudication of debtor, Consequences of adjudi...

Consequences of adjudication The consequences of the making of the adjudication order are: 1. The order must be advertised in the gazette and a local paper; 2. The ownershi

ACCOUTING, Ask questio. You have been appointed the accountant of a new org...

Ask questio. You have been appointed the accountant of a new organisation that is preparing its first set of financial statements. In determining the depreciation for the first yea

Flexible budget and static budget, Brabham Enterprises manufactures tires f...

Brabham Enterprises manufactures tires for the Formula One motor racing circuit. For August 2011, Brabham budgeted to manufacture and sell 3,000 tires at a variable cost of $74

Illustrate the changing face of accounting, Illustrate the changing face of...

Illustrate the changing face of accounting Over past 25 years, environment within which businesses operate has become increasingly turbulent and competitive. Numerous reasons h

Nikki., Trying to calculate earnings per share. Is net income the same as ...

Trying to calculate earnings per share. Is net income the same as earnings before interest and taxes?

Would you give to avoid such errors in the future, Notsofast Inc. acquired ...

Notsofast Inc. acquired land for $500,000 on 7/1/2010. It erroneously recorded the full amount as an expense. Explain what Notsofast must do when it discovers the error in 2011. Wh

Illustration of deffered tax-financial statement, Illustration of Deffered ...

Illustration of Deffered Tax A firm bought an item of plant at a total amount of £50,000. During the first year, the firm provided for depreciation of 10,000. The item of plant

Uncertainty concerning the business, Uncertainty concerning the business ...

Uncertainty concerning the business It has been recognised in a variety of studies that the problem of adequately financing SMEs is a problem of uncertainty. A defining feature

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd