PLEASE PREPARE CASH BUDGET WITH INFORMATION PROVIDED

A COMPANY expects 10% of sales to be collected in cash from the customer immediately and 90% on credit. Credit sales are always paid in full in the following month.

All direct materials purchases are on credit and are paid in full in the following month. No other payables arise from any other transactions.

As of June 30, the Accounts Receivable balance is $720,000. The Accounts Payable balance is $308,700.

The minimum ending cash balance for all months is $100,000. If necessary, the company borrows enough cash using a short term note to reach the minimum.

Short term notes require an interest payment of 0.5% each month end (before repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short term notes payable balance.

The company expects to declare and pay a dividend of $80,000 in July.

The company does not expect to make any payments for Income Taxes in the budgeted quarter.

Equipment purchases of $25,000 are scheduled for September. No disposals of fixed assets are anticipated.

Cash Budget \begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Production Budget } & July & August & \multicolumn{1}{|c|}{ September } \\ \hline Budgeted Ending Inventory & 18,750 & 20250 & 21750 \\ \hline Budgeted Sales Units & 23000 & 25,000 & 27000 \\ \hline \begin{tabular}{l|l|l|} \hline Less Beginning \\ Inventory \end{tabular} & 17250 & 18750 & 20,250 \\ \hline Total units to be produced in the period & 24500 & 26500 & 28500 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{1}{c|}{ Sales Budget } & July & August & September & October \\ \hline Budgeted Sales In Units & 23,000 & 25,000 & 27,000 & 23,000 \\ \hline Price per Unit & 40 & 40 & 40 & 40 \\ \hline Budgeted Sales in Dollars & 920000 & 1000000 & 1080000 & 920000 \\ \cline { 2 - 5 } & & & & \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ G\&A } & July & August & September \\ \hline Administrative Salaries & 10,000 & 10000 & 10,000 \\ \hline Long Term Note & 1500 & 1500 & 1500 \\ \hline Interest Expense & & & \\ \hline Total G\&A Budget & 11500 & 11500 & 11500 \\ \hline \end{tabular} Cash Budget \begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Production Budget } & July & August & \multicolumn{1}{|c|}{ September } \\ \hline Budgeted Ending Inventory & 18,750 & 20250 & 21750 \\ \hline Budgeted Sales Units & 23000 & 25,000 & 27000 \\ \hline \begin{tabular}{l|l|l|} \hline Less Beginning \\ Inventory \end{tabular} & 17250 & 18750 & 20,250 \\ \hline Total units to be produced in the period & 24500 & 26500 & 28500 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{1}{c|}{ Sales Budget } & July & August & September & October \\ \hline Budgeted Sales In Units & 23,000 & 25,000 & 27,000 & 23,000 \\ \hline Price per Unit & 40 & 40 & 40 & 40 \\ \hline Budgeted Sales in Dollars & 920000 & 1000000 & 1080000 & 920000 \\ \cline { 2 - 5 } & & & & \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{1}{|c|}{ G\&A } & July & August & September \\ \hline Administrative Salaries & 10,000 & 10000 & 10,000 \\ \hline Long Term Note & 1500 & 1500 & 1500 \\ \hline Interest Expense & & & \\ \hline Total G\&A Budget & 11500 & 11500 & 11500 \\ \hline \end{tabular}