need help asap

Indigo Company expects to have a cash balance of $44,700 on January 1. 2022. Indigo has budgeted the following for the first two months of the year 2022: Collections from customers: January $90.900; February $109.000. 2. Payments to suppliers: January $40,000; February $50,300. 3. Direct labour: January $30,100; February $35,100. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,300; February $30,300. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $15,900; February $22,100. These costs do not include depreciation and they are paid as incurred. Sales of investments in January are expected to realize $9.900 in cash. Indigo Company wants to keep a minimum 6. monthly cash balance of $20,000. Ignore any interest on amounts borrowed.Prepare a cash budget for January and February. INDIGO COMPANY Cash Budget For 2022 January February Total receipts Ending cash balance Beginning cash balance Excess of cash over cash disbursements Cash disbursements Financing borrowing needs Cash receipts Total cash available Total cash disbursements VPrepare a cash budget for January and February. INDIGO COMPANY Cash Budget For 2022 January February v Add W Less $INDIGO COMPANY Cash Budget For 2022 January February $ Collection of notes receivable Collections from customers Sale of Investments Purchase of equipment Payment to suppliers Purchase of land Manufacturing overhead Labour Selling and administrative expenses $Prepare a cash budget for January and February. INDIGO COMPANY Cash Budget For 2022 January February v V Beginning cash balance Ending cash balance Cash receipts Total receipts Cash disbursements $ Financing borrowing needs Total cash available Excess of cash over cash disbursements Total cash disbursements eTextDOOK and Media