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}$

Question

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}

Quizplus · Accepted Answer

The Answer of 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}$

California Products Company Has the Following Data as Part of Its