Blue Spruce Company expects to have a cash balance of $45,100 on January 1, 2022. Blue...

Transcribed Image Text:

Blue Spruce Company expects to have a cash balance of $45,100 on January 1, 2022. Blue Spruce has budgeted the following for the first two months of the year 2022; 1. Collections from customers: January $89,900; February $109,500. 2 Payments to suppliers: January $40,000: February $50,300. 3. Direct labour: January $29,900; February $34,900. Wages are paid in the month they are incurred. 4. 5. 6. Manufacturing overhead: January $24,800; February $30,300. Overhead costs are paid as incurred. Selling and administrative expenses: January $16,000; February $22,100. These costs do not include depreciation and they are paid as incurred. Sales of investments in January are expected to realize $10,100 in cash. Blue Spruce Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed. Prepare a cash budget for January and February. BLUE SPRUCE COMPANY Cash Budget For 2022 January $ $ $ February Blue Spruce Company expects to have a cash balance of $45,100 on January 1, 2022. Blue Spruce has budgeted the following for the first two months of the year 2022; 1. Collections from customers: January $89,900; February $109,500. 2 Payments to suppliers: January $40,000: February $50,300. 3. Direct labour: January $29,900; February $34,900. Wages are paid in the month they are incurred. 4. 5. 6. Manufacturing overhead: January $24,800; February $30,300. Overhead costs are paid as incurred. Selling and administrative expenses: January $16,000; February $22,100. These costs do not include depreciation and they are paid as incurred. Sales of investments in January are expected to realize $10,100 in cash. Blue Spruce Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed. Prepare a cash budget for January and February. BLUE SPRUCE COMPANY Cash Budget For 2022 January $ $ $ February