Do not use chatgpt or ill report it. I need the cash budget.

Consider the following data update: In the part that says "The company issued 28,000 shares in February for $25 per share.", it should say "The company issued 2,170 shares in February for $2.5 per share".

The following balance sheet is available for VanBrand Inc. as at December 31,2020 . The company manufactures surfboards and sells them directly to consumers and to retail stores. The company began 2021 with $17,500 in cash; $168,000 in accounts receivable; $95,000 in accounts payable and $0 in raw materials inventory. 3,000 units were sold in December and sales are expected to increase by 10\% more each month DURING 2021. Surfboards sell for $200 each. 30% of sales are directly to consumers, consumers always pay cash at the time of purchase. The rest is sold to retailers on account. 60% of retailer sales are collected in the month of sale, and the rest is collected the month after. Prepare the master budget and get to the budgeted income statement and balance sheet, for Jan-April 2021 Production facts: Finished goods inventory and raw material inventory was 0 at the end of 2020 due to a fire accident in the company's warehouse. 3,000 units were sold in December and sales are expected to increase by 10% more each. Ending inventory equals 30% of the next month's sales. In April, the ending inventory is the same as March's ending inventory. Each surfboard requires 3kg of raw materials, and raw materials are purchased at $10 per kg, the price of materials was the same last year. The company purchases raw materials on account and pays for its purchases in the month following the transaction. The company always keeps 25% of next month's production needs in ending raw materials for the current month. For April, the ending raw material inventory is 50% of March's desired ending raw material inventory. Beginning raw material inventory for May will be zero, because the company is planning to use it entirely in production. Each surfboard requires 2 hours of labour, and workers earn $25 per hour. Variable manufacturing overhead includes sandpaper (\$3/unit); utilities (\$1.50/unit) and wax (\$2/unit). Fixed manufacturing overhead includes $3,000 per month for the supervisor's salary, $2,000 per month for depreciation on production equipment and $1,000 per month for insurance. Selling and Administrative Expenses facts: Selling and administrative expenses include a 10% sales commission, $4,000 per month in head office rent, and $600 per month in head office depreciation. Taxes ASCEND TO \$7,500 per QUARTER. Cash budget facts: The company maintains a minimum cash balance of $15,000 by borrowing from its line of credit when needed. Borrowings and repayments are PAYED every 2 months evenly, after the moment in which the company receives the money. The line of credit carries no interest, because is provided by a family member. Borrowings are made at the beginning of the month and repayments at the end of it. The company purchased new production equipment for $300,000 cash in January. The company declared and paid cash dividends totalling $40,000 in January. The company issued 28,000 shares in February for $25 per share. The company has retained earnings for 2020 of $77,575