Zygot Biotech Company Is Budgeting for the 3rd Quarter, and Provide

Zygot Biotech Company is budgeting for the 3rd quarter, and provide the following data:
$\begin{array}{|l|r|r|r|}\hline&\text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Cash collections } & \$ 50,000 & \$ 40,000 & \$ 48,000 \\\hline \text { Cash payments: } & & & \\\hline \text { Purchases of inventory } & 31,000 & 22,000 & 18,000 \\\hline \text { Operating expenses } & 12,000 & 9,000 & 11,600 \\\hline \text { Capital expenclitures } & 0 & 19,000 & 0 \\\hline\end{array}$

The cash balance at June 30 is projected to be $5,600. There are no financing transactions planned in the 3rd quarter. Please use the format below and prepare the cash budget:
$$\begin{array} { | l | l | l | l | } \hline \text { Cash Budget } & \text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Beginning cash balance } & & & \\\hline \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 { Ending cash balance } & & & \\\hline\end{array}$$