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 $ 18,870 45,000 24,000 7,800 9,100 5,900 Walter pays wages and other cash expenses in the month incurred. Manufacturing overhead includes $2,050 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 $8,700 during March. Walter can borrow in increments of $1,000 and would like to maintain a minimum cash balance of $17,000. Required: Prepare Walter's cash budget for the month of March. Beginning Cash Balance Budgeted Cash Receipts Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed Ending cash balance

Bubba Manufacturing Company provided the following information for the fiscal year to June 30, 2020: Inventories                    01/07/2019            30/06/2020 Direct Materials                  $72,000                  $65,000 Work-in-Process                  107,000                   128,000 Finished Goods                     149,500                    141,700   Other information: Office cleaner’s wages 4,500 Sales Revenue 1,031,000 Raw materials purchased 235,000 Factory wages 239,700 Indirect materials 23,500 Delivery truck driver’s wages 15,400 Indirect labor 9,500 Depreciation on factory plant & equipment 32,000 Insurance1 60,000 Depreciation on delivery truck 7,250 Utilities2 118,750 Administrative salaries 41,250 Special Design Costs 5,000 Selling expenses 9,000 Sales Comm ission 2% of gross profit 1 Of the total insurance, 66⅔% relates to the factory facilities & 33⅓% relates to general & administrative costs. 2 Of the total utilities, 80% relates to the…

Vinubhai

Walter Company has the following information for the month of March: $ 17,520 40,450 23,100 Cash balance, March 1 Collections from customers Paid to suppliers Manufacturing overhead Direct labor Selling and administrative expenses Walter pays wages and other cash expenses in the month incurred. Manufacturing overhead includes $1,600 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.800 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. 6,900 8,650 5,000 Beginning Cash Balance Budgeted Cash Receipts Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed Ending cash balance 4