Sleepy Hollow cmcc
System
Posts: 100,534 🤖 Admin 🤖
Hi
Can anyone tell me if my cash flow forecast is anything like the correct answer?
Task 1 STask 1 SLEEPY HOLLOW LTD
CASH FLOW FORECAST FOR THE FOUR MONTHS ENDING 30 APRIL 2004 Task 1 SLEEPY HOLLOW LTD
CASH FLOW FORECAST FOR THE FOUR MONTHS ENDING 30 APRIL 2004
Jan Feb Mar April
£ £ £ £
Receipts
Trade sales 500,000 500,000 516,000 556,000
Factory sales 12,000
From deposit 153,000
Total Receipts 500,000 500,000 516,000 721,000
Payments
Wood suppliers 180,000 260,000 280,000 250,000
Production wages 52000 56000 60000 67200
Production overheads 90,000 90,000 90,000 90,000
Sales department costs 18,500 18,500 18,500 18,500
Administration costs 25,000 25,000 25,000 25,000
Overdraft interest 5,200 3,907 3441 3050
Total Payments 370,700 453,407 476,941 453,750
Cash Flow for month 129,300 46,593 39,059 267,250
Bank balance brought forward -520,000 -390,700 -344,107 -305,048
Bank balance carried forward -390,700 -344,107 -305,048 -37,798
Sorry you can't post it properly. Hence the closing balance is -£37,798.
If anyone can help thats great as I have lost confidence.
Tori x
Can anyone tell me if my cash flow forecast is anything like the correct answer?
Task 1 STask 1 SLEEPY HOLLOW LTD
CASH FLOW FORECAST FOR THE FOUR MONTHS ENDING 30 APRIL 2004 Task 1 SLEEPY HOLLOW LTD
CASH FLOW FORECAST FOR THE FOUR MONTHS ENDING 30 APRIL 2004
Jan Feb Mar April
£ £ £ £
Receipts
Trade sales 500,000 500,000 516,000 556,000
Factory sales 12,000
From deposit 153,000
Total Receipts 500,000 500,000 516,000 721,000
Payments
Wood suppliers 180,000 260,000 280,000 250,000
Production wages 52000 56000 60000 67200
Production overheads 90,000 90,000 90,000 90,000
Sales department costs 18,500 18,500 18,500 18,500
Administration costs 25,000 25,000 25,000 25,000
Overdraft interest 5,200 3,907 3441 3050
Total Payments 370,700 453,407 476,941 453,750
Cash Flow for month 129,300 46,593 39,059 267,250
Bank balance brought forward -520,000 -390,700 -344,107 -305,048
Bank balance carried forward -390,700 -344,107 -305,048 -37,798
Sorry you can't post it properly. Hence the closing balance is -£37,798.
If anyone can help thats great as I have lost confidence.
Tori x
0
Comments
-
Re:Sleepy Hollow cmcc
I must admit I quite fancied the sound of this one, but after digging out my CMCC book and reading the whole question, there seemed an unbelievable amount of data to be processed for just the one task! I do think that while you're highly likely to get quick or easy answers on the Forums, it'll be unfortunately rare that you'll get ones that need to go into this much depth - sorry!
Anyway, I hope someone else answered it for you or more likely, you know the answer by now anyway!
Best regards,
Robert0 -
Re:Sleepy Hollow cmcc
Hi Robert
No I don't know yet but I decided to just post it to my tutor and wait and see. Yes your right it was really long winded I think that is why I lost confidence. Well if its wrong it doesn't really matter I put loads of workings down so I am sure I might be in the right direction with some of it. Hope the actual skills test isn't quite as bad but revising like mad just in case. Quite like the subject really if that is not a bit sad of me.
Appreciate the reply.
Tori x
0 -
Re:Sleepy Hollow cmcc
ToriT
I don't think this unit is getting easier. I think it is being made more rigorous.
Here are some some points I made a few months ago.
http://forums.aat.org.uk/forums/posts/list/16217.page
You may find that Sleepy Hollow was gentle compared to some in the bank at the moment.
sandy.hood@chichester.ac.uk0