unit 15 help please!

lisnic

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

crispy

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.

lisnic

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

thanks

crispy

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)

lisnic

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!

thanks

crispy

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)

sdv

lisnic wrote: »

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 me

tboza

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=105280

tboza

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+=105280