3 Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible Accounts payable for inventory purchases, March 1 balance Budgeted inventory purchases in March Inventory payments: Month of purchase Month following purchase Total budgeted selling \& administrative expenses in March Budgeted selling \& administrative depreciation in March Other budgeted cash disbursements in March Equipment purchases Dividends to be paid Minimum cash balance to be maintained March 1 cash balance March 1 outstanding borrowings March 1 interest due \begin{tabular}{r|rr|r} \multicolumn{1}{|c|}{ January } & \multicolumn{1}{|c|}{ February } & \multicolumn{1}{c}{ March } \\ \hline$1,600 & $3,750 & $5,100 \\ \hline 25,000 & & 30,000 & 440,000 \\ \hline$26,600 & $33,750 & $45,100 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline 15% \\ \hline 60% \\ \hline 22% \\ \hline 3% \\ \hline \end{tabular} $10,500 $23,500 60%40% $12,500 $3,200 $14,000 $2,000 $10,000 $11,500 $0 $0 \begin{tabular}{|l|l|} \hline 2 & March cash collections \\ \hline 3 & March collections on account: \\ \hline 4 & January sales \\ \hline 5 & February sales \\ \hline 6 & March sales \\ \hline 7 & Total cash collections \\ \hline 8 & \\ \hline 9 & Payments to suppliers: \\ \hline 10 & Accounts payable for inventory purchases, beginning balance \\ 11 & March purchases \\ \hline 12 & Total cash payments \\ \hline 13 & \\ \hline 14 & \\ \hline 15 & \\ \hline 16 & \\ \hline 17 & \\ \hline 18 & Cash balance, March 1 \\ \hline 19 & Add cash receipts: \\ \hline 20 & Collections from customers \\ \hline 21 & Total cash available before current financing \\ \hline 22 & Less disbursements: \\ \hline 23 & Payments to suppliers \\ \hline 24 & Selling and administrative expenses \\ \hline 25 & Equipment purchases \\ \hline 26 & Dividends paid \\ \hline 27 & Total disbursements \\ \hline 28 & Excess (deficiency) of cash available over disbursements \\ \hline 29 & Financing: \\ \hline 30 & Borrowings \\ \hline 31 & Repayments \\ \hline 32 & Interest \\ \hline 33 & Total financing \\ \hline \end{tabular}