Need Help!

Carla Vista Company expects to have a cash balance of $115,000 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022. 1. Collections from customers: January $177,500, February $365,000. 2. Payments to suppliers: January $100,000, February $187,500. 3. Wages: January $75,000, February $100,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $52,500, February $60,000. These costs include depreciation of $2,500 per month. All other costs are paid as incurred. 5. Selling expenses: January $37,500, February $50,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $30,000 in cash. Carla Vista Company has a line of credit at a local bank that enables it to borrow up to $62,500. The company wants to maintain a minimum monthly cash balance of $50,000. CARLA VISTA COMPANY Cash Budget For the Two Months Ending February 28, 2022 January February