California Products Company Has the Following Data as Part of Its

Essay

California Products Company has the following data as part of its budget for the 2^nd quarter:
$$\begin{array} { | l | r | r | r | } \hline & { \text { Apr } } & { \text { May } } &{ \text { Jun } } \\\hline \text { Cash collections } & \$ 30,000 & \$ 32,000 & \$ 36,000 \\\hline \text { Cash payments: } & & & \\\hline \text { Purdhess af inventory } & 4,500 & 4,600 & 3,800 \\\hline \text { Operating Expenses } & 7,200 & 7,600 & 8,000 \\\hline \text { Capital expenditures } & 0 & 24,500 & 5,200 \\\hline\end{array}$$
The cash balance at April 1 is forecast to be $8,200. Please prepare a cash budget using the following format:
$\begin{array}{|l|l|l|l|}\hline \text { Cash Budget } & \text { Apr } & \text { May } & \text { Jun } \\\hline \text { Beginning cash balance } & & & \\\text { Cash collections } & & & \\\hline \text { Cash available } & & & \\\hline \text { Cash payments: } & & & \\\hline \text { Purchases of inventory } & & & \\\hline \text { Operating expenses } & & & \\\hline \text { Capital expenditures } & & & \\\hline \text { Total cash payments } & & & \\\hline \text { Finding casin balance } & & & \\\hline \end{array}$