Adam S$,$ managing director of "Summer Breeze", a swimsuit manufacturing company, has requested you to prepare a cash budget for the months of January and February $2020.$ To assist in this task, they have provided the following information:

Cash balance at the end of December $2019$ is $$49,900$;

Each swimsuit is sold for $$13$ each and actual sale for November and December $2019$ and projected sale for January and February $2020$ are as follows:

$\backslash$table$[[,$November,December,January,February$],[$Cash Sales $($Quantity$),\backslash$table$[[4,900],[$units$]],7,500$ units,$5,700$ units,$4,100$ units$],[\backslash$table$[[$Credit Sales$],[($Quantity$)]],\backslash$table$[[5,900],[$units$]],9,000$ units,$7,700$ units,$5,300$ units$],[$Total Sales,$\backslash$table$[[10,800],[$units$]],16,500$ units,$13,400$ units,$9,400$ units$]]$

Analysis of past records has shown that credit sales are collected over a three$-$month period. With $60\%$ being collected in the month of the sale, $30\%$ in the next month $($second month$),$ and the remainder in the following month $($third month$)$;

Projected expenditure during January and February $2020$ is as follows:

o A new piece of equipment costing $$80,913$ was purchased in December $2019.$ Upon purchase, the agreed credit terms were $40\%$ on purchased $($in December $2019),40\%$ in January $2020$ and the remainder in February $2020$;

o Manufacturing costs $($paid for immediately upon production$)$ are budgeted at $$6$ per swimsuit $($Assume that all the swimsuits sold are manufactured in the same month$)$;

o Selling and administrative expenses are budgeted to be $$13,200$ each month.

Please do not provide for any workings. Please round your answers to whole dollar value. All answers must be in $ value. If an item is given in Units, please convert these to $ values prior to inputting them in the Schedule of Receipt or Cash Budget.

Schedule of Receipt

$\backslash$table$[[,,$January,,February$],[$November $76,700,$$$,,,],[$December $117,000,$$$,,$$$,],[$January $100,100,$$$,,$$$,],[$February $68,900,,,$$$,],[$Total$,$$$,,$$$,]]$

Cash Budget

January

February

$$

$$

Cash Budget

January

February

Bank balance at beginning of month

$

$

Anticipated Receipts

$\backslash$table$[[$Cash Sale,$$,$$