Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Prepare Summerlea council’s cash budget from January 2022 to April 2022 from the following budgeted data

Prepare Summerlea council’s cash budget from January 2022 to April 2022 from the following budgeted data

Accounting

  1. Prepare Summerlea council’s cash budget from January 2022 to April 2022 from the following budgeted data.

Budgeted data

January

February

March

April

 

£

£

£

£

Sales

14,000

15,400

15,800

16,600

Purchases

13,000

12,600

12,800

13,400

Wages

600

680

740

800

Other overheads

1,100

1,080

1,150

1,180

Capital expenditure

 

 

6,500

 

 

The following additional information is available:

  1. 35% of the customers pay cash and the remainder take 1 month to pay.
  2. Rent is paid in advance for 6 months on 1st of May and 1st of November each year.
  3. 45% of the purchases are paid for after 1 month and the remainder in 2 months’ time.
  4. Wages are paid in the current month.
  5. Other overheads are paid after 2 months.
  6. Capital expenditure is paid in the following month.

Opening cash balance for June was £2,800 overdraft.

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE