Home For AAT student members AQ 2013 AAT Level 4 (Level 8 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Budgeting 4c from sample aq2013

zaf1987zaf1987 Well-KnownRegistered Posts: 124
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

Comments

  • crispycrispy Trusted Regular SouthamptonRegistered Posts: 456
    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.
  • SandyHoodSandyHood Font Of All Knowledge Registered, Moderator Posts: 2,034
    zaf1987 wrote: »
    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
    [email protected]
    www.sandyhood.com
Sign In or Register to comment.