unit 15
hanapospis
Registered Posts: 111 Dedicated contributor 🦉
Hi,
could anyone please help me with the cash budget forecast task. I cannot get around with it.
How can I calculate value of purchases if I am given only projected credit sales and forecast production quantities? I am not give opening nor the closing stock???
anyone please help!
could anyone please help me with the cash budget forecast task. I cannot get around with it.
How can I calculate value of purchases if I am given only projected credit sales and forecast production quantities? I am not give opening nor the closing stock???
anyone please help!
0
Comments
-
This has to be done in 3 stages.
First you take the forecast sales and deduct the opening stock, as they are already made and you dont want to duplicate them, then add the closing stock. This gives the total for the production budget, ie how many items are to be made that month.
Second
For the materials usage, you calculate the previous total, by how much each item costs in terms of the raw materials.
Third
For the materials purchases, which is what you are finaly getting at. You take the usage figure and like the sales, you deduct the opening stock of raw materials (not the finished stock) and add the closing stock. This tells you how much you need to buy that month and multiply it by the unit price, to give you the months total.
Dont forget, you will need to account for it in the month that they are going to be paid, not when you have calculated it. Ie something that is on 30 day terms, when purchased in January, will show in February's figures. Unless the say otherwise.
You will need to do a lot of careful reading in the memos and other information given. This can be like doing some detective work, or solving a difficult jigsaw puzzle.
All the best0 -
Hi,
Thank you for your reply. I was quite confident with this unit untill now. I do understand your post but the thing is I was not given any opening or closing stock figure.. I was given only the forecast sale and foreceast production (how many item is budgeted to be produced) I am so confused....0 -
Are you doing a question or a practice exam from the Osborn book? If you are let us know what one you are doing and i will see if i can find the information. It won't be tonight i'm afraid, but hopefully i will try to come back tomorrow or Thursday. if that's ok.0
-
Hi Mike,
I am doing a question for my college. I am really struggling with this unit. I have sent you PM last night.
Thank you0
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