Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started