Chapter $13$ & $14$

$(50$ pts$)$

Bay Leaf Industries needs you to do the cash budget. The company's sales were fixed at $$600,000$ per month, but the company anticipates landing another contract for an additional $$30,000$ in the second month of the quarter $($February$).$ Thirty percent of the company's customers pay cash up front with their orders; $40\%$ pay the following month, and the last $30\%$ pay within $2$ months. Assume that Bay Leaf has no interest or other income at this time. Complete Bay Leaf Industries monthly cash collection table through the first quarter. $(14$ pts$)$

Amount of Cash Collected

$\backslash$table$[[,$Sales $($$$),$Oct.,Nov.,Dec.,Jan.,Feb.,Mar.$],[$Oct$.,,,,,,,],[$Nov$.,,,,,,,],[$Dec$.,,,,,,,],[$Jan$.,,,,,,,],[$Feb$.,,,,,,,],[$Mar$.,,,,,,,],[$Total$,,,,,,,],[$Cash$,,,,,,,],[$Receipts$,,,,,,,]]$