Grippers expects total sales of $$701,500$ for January and $$350,000$ for February. November sales totaled $$390,000$ and December sales were $$410,000.$

The following schedule of cash receipts for January and February was prepared based upon the collection history given: I.$\text{'}($Click the icon to view the collection history.$)$

$($Click the icon to view the schedule of cash receipts.$)$

Now assume that Grippers' sales are collected as follows

$30\%$ in the month of the sale

$20\%$ in the month after the sale

$45\%$ two months after the sale

$5\%$ never collected

Prepare a revised schedule of cash receipts for January and February, including the calculation for the Net Accounts Receival balance on February $28$

Prepare a schedule of cash receipts from customers for January and February. $($If an input field is not used in the table leave the input field empty; do not enter a zero.$)$ Cash Receipts from Customers

$\backslash$table$[[$Cotal sales$],[$Nov$.-$Credit sales, collection of Nov. sales in Jan.$],[$Dec$.-$Credit sales, collection of Dec. sales in Jan.$],[$Dec$.-$Credit sales, collection of Dec. sales in Feb.$],[$Jan$.-$Credit sales, collection of Jan. sales in Jan.$],[$Feb$.-$Credit sales, collection of Jan. sales in Feb.$],[$Total cash receipts from customers$]]$

Reference