QUESTION 4 Given the following information prepare the Combined Cash Budget for FEBRUARY and MARCH All amounts are in dollars (5) Description January February March April May June July Cash Collected (actual cash collections) 29,000 28,000 30,000 28,000 28,000 24,000 30,000 Direct Material Purchases 12,000 13,000 14,000 13,000 12,000 14,000 16,000 Salaries and Wages 11,400 12,600: 12,400 12,200 12.400 12,300 12,500 All Selling Costs 300 100 100 200 200 300 200 Fixed Admin & Equipment Costs (includes $300 in depreciation) 1,800 6,100 2.900 3,000 2,800 1,900 2,700 Disbursement Timing: Direct Materials are paid for in the month following the purchase. Salaries and Wages are paid half in the month earned and half in the month following. All other costs are paid in the month incurred. Bank information: Ending Cash Balance on January 31 is $4,000. The company requires a minimum cash balance of $4,000. The bank requires the company to annual interest rate. The company may borrow from this operating line at any time and pay back the balance plus interest at any time. At the outstanding loans. The company also has no plans to pay back any borrowings or interest until the following quarter. puju Hungere unui the following quarter. Required: Prepare the Combined Cash Budget for FEBRUARY and MARCH. (Note: Show each month seperately) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac)