Prepare the cash budget in table form

Here is the cash budget for the three months ending 30 June 2013:

$$\begin{array}{|l|r|r|r|} \hline \textbf{Item} & \textbf{April (\$)} & \textbf{May (\$)} & \textbf{June (\$)} \\ \hline \textbf{Opening Cash Balance} & 28,600 & 76,800 & 132,700 \\ \textbf{Cash Inflows:} & & & \\ \quad \text{Receipts from Sales:} & & & \\ \quad \quad \text{Current month (60\%)} & 84,000 & 90,000 & 78,000 \\ \quad \quad \text{Previous month (20\%)} & - & 28,000 & 30,000 \\ \quad \quad \text{Two months prior (19.6\%)} & - & - & 27,440 \\ \quad \quad \text{From opening trade receivables} & 35,000 & 34,300 & - \\ \textbf{Total Cash Inflows} & \textbf{119,000} & \textbf{152,300} & \textbf{135,440} \\ \textbf{Total Cash Available} & 147,600 & 229,100 & 268,140 \\ \textbf{Cash Outflows:} & & & \\ \quad \text{Payments for Purchases:} & & & \\ \quad \quad \text{Current month (40\%)} & 44,800 & 48,000 & 41,600 \\ \quad \quad \text{Previous month (20\%)} & - & 22,400 & 24,000 \\ \quad \quad \text{Two months prior (20\%)} & - & - & 22,400 \\ \quad \quad \text{Payment of opening trade payables} & 20,000 & 20,000 & 20,000 \\ \quad \text{Operating Expenses} & 6,000 & 6,000 & 6,000 \\ \quad \text{Equipment Purchase} & - & - & 1,500 \\ \textbf{Total Cash Outflows} & \textbf{70,800} & \textbf{96,400} & \textbf{115,500} \\ \textbf{Closing Cash Balance} & \textbf{76,800} & \textbf{132,700} & \textbf{152,640} \\ \hline \end{array}$$

The closing cash balances for each month are:

• April: \boxed{\text{\76,800}}$
• May: \boxed{\text{\132,700}}$
• June: \boxed{\text{\152,640}}$