TASK $6$:$$

$40$ MARK$5$

You are presented with the following forecasted data for Nqabayezulu Pyt Ltd for the period November $2022$ to March $2023,$ It has been extracted from functional flow forecasts that have already been prepared.

$\backslash$table$[[,$Nov $2022,$Dec $2022,$Jan $2023,$Feb $2023,$Mar $2023],[$Sales$,80000,100000,110000,130000,140000],[$Purchases$,40000,60000,80000,90000,110000],[$Wages$,10000,12000,16000,20000,24000],[$Overheads$,10000,10000,15000,15000,15000]]$

You are also told the following.

Sales are $40\%$ cash $60\%$ credit. Credit sales are paid two months after the month of sale

Purchases are paid the month following purchase.

$75\%$ of wages are paid in the current month and $25\%$ the following month.

Overheads are paid the month after they are incurred.

The opening cash balance is R$15,000.$

Required:

$6\mathrm{.}1$ Prepare the Receipt Schedule and the Payment Schedule. $(20)$

$6\mathrm{.}2.$ Prepare a cash flow forecast for the $3-$month period January to March $2023.(15)$

$6\mathrm{.}3$ Comment on the projected Cash Flow. $(5)$

$\backslash$table$[[$CONTENT$,$MARK ALLOCATION$],[$SECTIONA$,30$ marks$],[$SECTION B$,20$ marks$],[$SECTION C$,50$ marks$],[$Total Marks,$100]]$