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

E8-16 Preparing Cash Budget [LO 8-4] Walter Company has the following informatio

ID: 2558868 • Letter: E

Question

E8-16 Preparing Cash Budget [LO 8-4]

Walter Company has the following information for the month of March:


Walter pays all expenses in the month incurred. Manufacturing overhead includes $1,500 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,600 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $11,000.
   
Required:
Prepare Walter’s cash budget for the month of March.

Cash balance, March 1 $ 17,220 Collections from customers 39,450 Paid to suppliers 22,900 Manufacturing overhead 6,700 Direct labor 8,550 Selling and administrative expenses 4,800

Explanation / Answer

Prepare Walter’s cash budget for the month of March.

Beginning Cash Balance 17220 Budgeted Cash Receipts 39450 Budgeted Cash Payments (49050) Preliminary Cash Balance 7620 Cash Borrowed 4000 Ending cash balance 11620