Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Walter Company has the following information for the month of March Cash balance

ID: 2554192 • Letter: W

Question

Walter Company has the following information for the month of March Cash balance, March 1 Collections from customers Paid to suppliers Manufacturing overhead Direct labor Selling and administrative expenses $ 16,470 36,950 22,400 6,200 8,300 4,300 Walter pays all expenses in the month incurred. Manufacturing overhead includes $1,250 for machinery depreciation, but the amount for selling and administrative expenses is exclusive of depreciation. Additionally, Walter also expects to buy a piece of property for $7,100 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $10,000 Required Prepare Walter's cash budget for the month of March Answer is complete but not entirely correct Beginning Cash Balance Budgeted Cash Receipts Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed $ 16,470 36,950 47,100 $ 6,320 3,680 $ 10,000 Ending cash balance

Explanation / Answer

Beginning cash balance 16470 Budgeted cash receipts 36950 Budgeted cash payments 47050 =22400+6200+8300+4300-1250+7100 Preliminary cash balance 6370 Cash borrowed 4000 Ending cash balance 10370