Page 188 - Microsoft Word - 00 ACCA F9 IWB prelims 2017.docx

Chapter 10

Question 2

Cash forecasting

Material usage quantities for a company are predicted to be as follows:

Month 1 2 3 4 5

(000) 10 12 14 16 18

Production costs are $5 per unit and suppliers are paid in the month after
purchase. The company intends to increase stocks of materials by 2,000 units
each month by the end of months 1 and 2 and by 1,000 units each month by the
end of months 3, 4 and 5.

Calculate the cash payments for material purchases for months 3 to 5.

Cash payments for the month relate to previous month’s purchases. Purchases
will be greater than usages each month due to the intent to increase stock
levels.

Month 3 4 5

Month of purchase 2 3 4

Purchase quantities 12+2 14+1 16+1

At $5 each ($000) 70 75 85

Illustrations and further practice

Now work through the additional questions on full cash flow forecast, statement
of financial position and forecasts from working capital ratios from Chapter 10.

180