60.1K

Verified Solution

Link Copied!

Blanchet, Incorporated needs to budget for cash in its upcoming quarter. Below is historical information about cash collections and payments.

Sales collected in Cash$20\%$Sales collected on Credit$80\%$

$\%$ of Credit Sales collected in the month of sale$20\%\%$ of Credit Sales collected in the following month$30\%\%$ of Credit Sales collected two months after the month of sale$45\%\%$ uncollectable$5\%$

$\%$ of Accounts Payable paid in the month of purchase$70\%\%$ of Accounts Payable paid in the following month$30\%$

Projected Sales and Purchases are below.

MonthSalesPurchasesJanuary$95,00074,000$February$85,00061,000$March$62,00028,000$April$105,00082,000$May$48,00060,000$June$56,00029,000$July$70,00060,000$

Required:

Prepare a schedule of cash collections.

Prepare a schedule of cash payments.

Navigation:

Use the$$Open Excel in New Tab$$button to launch this question.

When finished in Excel, use the$$Save and Return to Assignment$$button in the lower right to return to Connect.

I need help with this section for april and I notice that i maybe putting in the formula wrong from other help that i seen on chegg they had the answer for $16,800$ which is wrong and need help to why $37,800$ is not right but when adding the total up it is correct for april

Show all imagesShow all images

Answer & Explanation Solved by verified expert

See Answer