TUCIES urrent Attempt in Progress Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data: Cash sales Credit sales (55% collected in month of sale) Selling and administrative costs (including depreciation) Depreciation expense Merchandise Inventory, January 1 Merchandise Inventory, January 31 Beginning cash balance Minimum cash balance required Cost of goods sold is 51% of Cooper's selling price All purchases are paid in cash Selling and administrative costs are paid in month of purchase $27.300 354,100 45,860 5,340 19,360 21,600 2.730 2,400 Prepare a cash budget for January (Enter cash needed using either a negative sign preceding the number eg. -4,527 or parentheses es. (4,52710 Prepare a cash budget for January (Enter cash needed using either a negative sign preceding the number e.g. -4,527 or parenthese Total cash available to spend will be auto-submitted on the due date. com/ Beginning cash balance elling pr Borrowing Cash excess (needed) d in mon Cash receipts er cash nee Disbursements Ending cash balance Materials purchases Selling and administrative expenses Total cash available to spend Total cash disbursements TUCIES urrent Attempt in Progress Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data: Cash sales Credit sales (55% collected in month of sale) Selling and administrative costs (including depreciation) Depreciation expense Merchandise Inventory, January 1 Merchandise Inventory, January 31 Beginning cash balance Minimum cash balance required Cost of goods sold is 51% of Cooper's selling price All purchases are paid in cash Selling and administrative costs are paid in month of purchase $27.300 354,100 45,860 5,340 19,360 21,600 2.730 2,400 Prepare a cash budget for January (Enter cash needed using either a negative sign preceding the number eg. -4,527 or parentheses es. (4,52710 Prepare a cash budget for January (Enter cash needed using either a negative sign preceding the number e.g. -4,527 or parenthese Total cash available to spend will be auto-submitted on the due date. com/ Beginning cash balance elling pr Borrowing Cash excess (needed) d in mon Cash receipts er cash nee Disbursements Ending cash balance Materials purchases Selling and administrative expenses Total cash available to spend Total cash disbursements