please create a chart with step-by-step work

thank you in advance

29. The following data pertains to Louetta Mfg., which was founded on January 1st Jan Feb Mar Apr Sales (all credit) $240,000 220,000 210,000 190,000 230,000 Purchases (all credit) $180,000 160,000 150,000 160,000 170,000 May Louetta pays for purchases over two months: 20% in the month of purchase and the remainder in the following month. Louetta expects to collect on sales over three months: 20% in the month of sale, 25% in the 1st month following, and the remainder in the 2nd month following. At the beginning of January, Louetta has a cash balance of $160,000. What cash balance does Louetta expect to have at the end of March? ANSWER (10pts): JAN FEB MAR APR MAY