60.1K

Verified Solution

Link Copied!

provide a short write up (2-3 paragrpahs) of the cashflow situation at this company after you completed the budgets. What are your concerns and what would you recommend to management?

BELOW ARE THE NUMBERS TO HELP WITH THE SHORT WRITE UP!!!

Required: Using the data above, for the 2 nd quarter ending June 302020 , prepare the following: a. The schedule of the expected cash collections b. The merchandise purchases budget: c. The schedule of expected cash disbursements - merchandise purchases. d. The schedule of expected cash disbursement-Selling and administrative expenses e. The cash budget: f. An absorption costing income statement, for the quarter ending June 302020 g. A balance sheet as of June 30,2020 "Provide a short write up (2-3 paragraphs) of the cashflow situation at this company after you completed the budgets. What are your concerns and what would you recommend to management? C. schedule of cash disbursements-merchandise purchases \begin{tabular}{|l|l|l|l|} \hline particulars & april(\$) & may($) & june(\$) \\ \hline purchases & 49,138 & 43,758 & 41,886 \\ \hline \end{tabular} cash disbursements payment in cash (50\%) payment in the following month (50%) total cash distribution f 24,569 22,400 21,879 20,943 46,969 24,569 21,879 46,44842,822 D. schedule of cash disbursements- selling and administrative expenses particular april ($) may($) june(\$) commissions rent other expenses ( 7% of sales) total cash disbursement 8,500 2,000 8,5008,500 3,850 2,000 2,000 14,350 14,490 14,280 E. Cash budget particulars april($) may($) june(\$) receipts: collections for customers total receipts 43,550 55,520 56,220 43,55055,52056,220 payments: payment for purchases payment for expenses purchase of assets total payments cash surplus (deficit) 20,769 8,918 882 finance: borrowings repayments \begin{tabular}{|r|r|r|} \hline 46,969 & 46448 & 42,822 \\ \hline 14,350 & 14,490 & 14,280 \\ \hline 3,000 & 3,500 & 0 \\ \hline 64,319 & 64,438 & 57,102 \\ \hline \end{tabular} interest payments 20,000 cash balance at the beginning cash balance at the end 4,000 9,000 1,000 0 0 0 0 0 3,231

Answer & Explanation Solved by verified expert

See Answer