Question

Q1. Big City Manufacturing (BCM) is preparing its cash budget and expects to have sales of $450,000 in January, $375,000 in February, and $555,000 in March.  If 20% of the sales are for cash, 45% are credit sales paid in the month after the sale, and another 35% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? 

Q2.In problem 1, Big City Manufacturing (BCM) assumed that all credit sales were paid in full, with no bad debt expense.  For this problem, please assume that bad debt expense is again 0% for BCM.  Purchases for next month's sales are 50% of projected sales for the next month, and April sales are estimated to be $495,000; purchases for April are paid in cash in March.   "Other payments," which include wages, rent, and taxes, are 25% of sales for the current month. Construct a cash budget for March using your expected cash receipts from problem 1 and calculate the average net cash flow during the month of March. 

Answer 1

Q1. Expected Cash Receipts for the Month of March = March Sales * 20% + February Sales * 45% + January Sales * 35%

Expected Cash Receipts for the Month of March = 555000 * 20% + 375000 * 45% + 450000 * 35%

Expected Cash Receipts for the Month of March = $437250

Q2. Average Net Cash Flow = Expected Receipts - Purchases - Other Payments

Average Net Cash Flow = $437250 - 495000 * 0.50 - 555000 * 0.25

Average Net Cash Flow = $51000