Budgeting 4c from sample aq2013
zaf1987
Registered Posts: 124 Beyond epic contributor 🧙♂️
Hi first i want to say huge thanks to eveyone who helped me in my spreadsheets module.
I passed the assesement. And have now completed level 3. Im actually im middle of budgeting and have come across a question which puzzles me.
Prepare forcast from operating budget and statement of financial position assumptions.
Assumptions
- receivables increase by 2500
Materials payables reduce by 3500
Labour cost paid in month they incurred
Other payables increase 4800
Operatong budget
Sales 103000
Expenditure
Materials 34200
Labour 38500
Other 16400
Operating profit 13900
It seems im doing the oposite to the answer. If materials payables reduce by 3500 i have 30700. But answer is 37700
Thanks zaf
I passed the assesement. And have now completed level 3. Im actually im middle of budgeting and have come across a question which puzzles me.
Prepare forcast from operating budget and statement of financial position assumptions.
Assumptions
- receivables increase by 2500
Materials payables reduce by 3500
Labour cost paid in month they incurred
Other payables increase 4800
Operatong budget
Sales 103000
Expenditure
Materials 34200
Labour 38500
Other 16400
Operating profit 13900
It seems im doing the oposite to the answer. If materials payables reduce by 3500 i have 30700. But answer is 37700
Thanks zaf
0
Comments
-
Hi,
Is this for a cash budget ? If payables are reducing this would mean you are paying out more in cash to reduce the closing payables, similar to if receivables are increasing you are collecting less cash.0 -
Hi first i want to say huge thanks to eveyone who helped me in my spreadsheets module.
I passed the assesement. And have now completed level 3. Im actually im middle of budgeting and have come across a question which puzzles me.
Prepare forcast from operating budget and statement of financial position assumptions.
Assumptions
- receivables increase by 2500
Materials payables reduce by 3500
Labour cost paid in month they incurred
Other payables increase 4800
Operatong budget
Sales 103000
Expenditure
Materials 34200
Labour 38500
Other 16400
Operating profit 13900
It seems im doing the oposite to the answer. If materials payables reduce by 3500 i have 30700. But answer is 37700
Thanks zaf
You are completely the opposite.
Just think about cash:
If you owed someone £5000 at the start of September and reduced this to £1,500 by the end of September you would have had to have paid that person.
So look at your materials payable: You've reduced what you owe by £3,500 (in other words paid that amount) AND you've bought £34,200 worth of materials - so you've paid £37,700.
Tha same applies to the other balances. Does that make sense?
Look from the point of view of cash - if you need to then look back at your level 3 Cash Management notes.Sandy
sandy@sandyhood.com
www.sandyhood.com0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership