unit 15 help please!
Options
lisnic
Registered Posts: 141 Dedicated contributor 🦉
Hi im studying unit 15 via diploma pathway distance learning and am currently at revision stage after completing all the initial study, re-writing my notes and completing questions.
Today im struggling though and have cam across a number of questions i just cant get to match the answers in the bpp text and some i just dont even know how to approach that the course material hasnt covered as such think your just to work out how to approach it!?
My simulation is at the end of oct so time is ticking - this is the first unit ive struggled with a bit pass, 30,31,5 and 6 all first time and have unit 11 and 33 booked for dec exams
the first one im stuck with and would really appreciate some help with is:
The text has the question as
Sarhall Ltd has budgeted sales for June 100,000, for July 120,000 and for August 80,000. 20% of sales are for cash and 80% are on credit. Of the credit sales 60% are paid within 30days and the balance is paid in 60 days. bad debts amount to 1% of sales. What figure for receipts from debtors should be included in the cash flow forecast for august?
My workings and answer to the question are as follows
June July August
Sales 100,000 120,000 80,000
Cash 20,000 24,000 16,000 (20% of total sales)
Credit 79000 94800 63200 (credit figure worked out as 80% of total sales less 1% of sales for bad debts)
Receipts for August
June sales - 79000 x 40%=31600
July sales - 94800 x 60%=56880
August sales - 16000 cash sales
Total receipts= 31600+56880+16000=104,480
The answer provided shows
Cash 20% august sales 16000
Credit 48% july sales 57600
31% june sales 31,000
Total 104,600
Please can you explain where the percentages in the answer provided have came from? i do not understand where the percentages of 48% and 31% have came from and why these percentages have been used?
Hopefully someone will be along to help me very shortly and if so i may even try get some help on my other questions. I have emailed bpp but i wont even get a response for at least 2 working days and from previous experience i have had to chase that even!
Thanks
Lisa
Today im struggling though and have cam across a number of questions i just cant get to match the answers in the bpp text and some i just dont even know how to approach that the course material hasnt covered as such think your just to work out how to approach it!?
My simulation is at the end of oct so time is ticking - this is the first unit ive struggled with a bit pass, 30,31,5 and 6 all first time and have unit 11 and 33 booked for dec exams
the first one im stuck with and would really appreciate some help with is:
The text has the question as
Sarhall Ltd has budgeted sales for June 100,000, for July 120,000 and for August 80,000. 20% of sales are for cash and 80% are on credit. Of the credit sales 60% are paid within 30days and the balance is paid in 60 days. bad debts amount to 1% of sales. What figure for receipts from debtors should be included in the cash flow forecast for august?
My workings and answer to the question are as follows
June July August
Sales 100,000 120,000 80,000
Cash 20,000 24,000 16,000 (20% of total sales)
Credit 79000 94800 63200 (credit figure worked out as 80% of total sales less 1% of sales for bad debts)
Receipts for August
June sales - 79000 x 40%=31600
July sales - 94800 x 60%=56880
August sales - 16000 cash sales
Total receipts= 31600+56880+16000=104,480
The answer provided shows
Cash 20% august sales 16000
Credit 48% july sales 57600
31% june sales 31,000
Total 104,600
Please can you explain where the percentages in the answer provided have came from? i do not understand where the percentages of 48% and 31% have came from and why these percentages have been used?
Hopefully someone will be along to help me very shortly and if so i may even try get some help on my other questions. I have emailed bpp but i wont even get a response for at least 2 working days and from previous experience i have had to chase that even!
Thanks
Lisa
0
Comments
-
Here's my attempt, hope it's ok
July 80% * 60% = 48 % (Of the 80% Credit Sales, 60% paid 30 Days)
June 80% * 40% = 32% * 99% = 31% (Of the 80% Credit Sales 40% Paid 60Days less 1% Bad Debts)
The answer seems to come out at 31.68 % so this may be wrong, although think this is heading in right direction.0 -
thanks for this
yes see that makes sense now you have put an explanation of how you got 48% and 31%, it really frustrates me how in the book there is no explanation or even working of where these percentages came from!!
it also frustrates me how all through the course companion the worked examples are done more like ive answered it than the way they have in this question, at leats cover both so we learn how to tackle both
does anyone know if there is any additional revision material for unit 15 you can purchase? i have the bpp course companion, revision companion and passcards
thanks0 -
Apologies, the 31% is simply just the 32% (80% x 40%) less 1% for bad debts, this brings the total back up to the full 80% eg.
July 48%
June 31%
Bad Debts 1%
Total 80% (Representing the 80% Credit Sales)0 -
thanks, so i could do it the way i can see it in my head too and forget the percentages of 48% and 31% as that is what confused me i think?
june (100,000 *1%=1000 bad debts)
100,000*80%=80,000*40%=32000-1000=31000
july 120,000*80%=96000*60%=57600
aug 16000
31,000+57,600+16,000=104,600
looks like all ive done actually is try to take the bad debts off at the beginning making the credit sales figure incorrect instead of doing it at the 60days step
its so much quicker posting here than emailing bpp i wonder when ill get a response and whether it will even explain it as well as you have!!
can i ask another 2 little ones please?
The following items have been extracted from a companys budget for next month
Sales on credit 240,000
Expected increase in stock next month 20,000
Expected decrease in trade debtors next month 12,000
The budgeted receipt from trade debtors next month is 252,000 true or false?
and similar;
The following items have been extracted from a companys budget for next month
Purchases on credit 360,000
expected decrease in stock over month 12,000
expected increase in trade creditors over the months 15,000
what is the budgeted payment to trade creditors for the month?
333,000, 345,000, 357,000 or 375,000
Not really sure how to tackle these at all at least the other one appears that i just did something in the wrong order!
thanks0 -
Hello, Im afraid I don't know 100% either
The following will have an effect on cash flow as follows:
Expected Increase Stock of 20,000 (This will have a negative effect - less stock has been sold)
Expected Decrease Debtors of 12,000 (Positive effect - more debtors have paid us)
Expected Decrease in Stock 12,000 (Positive - less stock has been pruchased)
Increase in Trade Creditors 15,000 (Positive- paid less cash out to our creditors)0 -
can i ask another 2 little ones please?
The following items have been extracted from a companys budget for next month
Sales on credit 240,000
Expected increase in stock next month 20,000
Expected decrease in trade debtors next month 12,000
The budgeted receipt from trade debtors next month is 252,000 true or false?
and similar;
The following items have been extracted from a companys budget for next month
Purchases on credit 360,000
expected decrease in stock over month 12,000
expected increase in trade creditors over the months 15,000
what is the budgeted payment to trade creditors for the month?
333,000, 345,000, 357,000 or 375,000
Not really sure how to tackle these at all at least the other one appears that i just did something in the wrong order!
thanks
I think you are not giving the full picture of your problem. It is unlikely that you will have to work our debtors and creditors from your sales figure only. you may already have an opening debtors figures at the begining of the problem. we know that 80% of each month's TOTAL SALES= CREDIT SALES is added to debors but 60% of previous month credit sales (30 days old) is taken off and 40% of of 2 months credit sales taken off (60 days) -included 1% bad debt write off-
same as above for creditors- don't have full details of payment to suppliers - so can not advise
increase in stock means next month £20000 extra cash out flow to buy additional stock
increase in creditors means next months less cash flow out of 15000 in creditors settlement
if you post the whole question I can do it for you, or alternatively PM it to me.
I have a very good hand out, easy to follow, that I can e-mail it to you. it expains how to tackle cash flow step by step. if you want it post your e-mail or pm it to me0 -
calculations for your question
JUNE
to find the amount of credit sales
100000*80%=80000
to find the amount paid in August
80000*40%=32000
to deduct bad debts
32000-1%= 31680
JULY
to find the amount of credit sales
120000*80%=96000
tofind the amount paid in august
96000*60%=57600
to deduct the bad debts
57600-1%
August
to find the cash sales
80000*20%=16000
Total cash receipts in August
31680+57600+16000=1052800 -
calculations for your question
JUNE
to find the amount of credit sales
100000*80%=80000
to find the amount paid in August
80000*40%=32000
to deduct bad debts
32000-1%= 31680
JULY
to find the amount of credit sales
120000*80%=96000
tofind the amount paid in august
96000*60%=57600
to deduct the bad debts
57600-1%
August
to find the cash sales
80000*20%=16000
Total cash receipts from debtors in August
31680+57600+=1052800
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.4K For AAT students
- 266 NEW! Qualifications 2022
- 145 General Qualifications 2022 discussion
- 9 AAT Level 2 Certificate in Accounting
- 46 AAT Level 3 Diploma in Accounting
- 66 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 268 VAT
- 90 Software
- 271 Tax
- 133 Bookkeeping
- 7.1K General accounting discussion
- 195 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 578 Job postings
- 16 Who can benefit from AAT?
- 35 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