CASHBGT Cash Budgeting Data Section Beginning cash balance $24,000 Sales $250,000 Gross profit percentage 45% Decrease in accounts receivable (increase) ($24,000) Increase in accounts payable (decrease) $51,000 Decrease in inventory (increase) ($98,000) Variable selling & admin. expenses 15% Fixed selling & admin. expenses $27,000 Answer Section Northern Gifts Cash Budget November Sales Cost of goods sold Decrease in accounts receivable (increase) Increase in accounts payable (decrease) Decrease in inventory (increase) Variable selling & admin. expenses Fixed selling & admin. expenses Net cash change for the month Beginning cash balance for month Projected ending cash balance $1,000