Expected cash collections:March cash collectionsMarch collections on account:January salesFebruary salesMarch salesTotal cash collectionsPayments to suppliers:Accounts payable for inventory purchases, beginning balanceMarch purchasesTotal cash payments 5573 Cash balance, March 19 Add cash receipts:D Collections from customersTotal cash available23Less disbursements:Payments to suppliersSelling and administrative expenses5 Equipment purchases5 Dividends paidTotal disbursements3 Preliminary cash balanceFinancing:D Additional loan123 Total financing4 Cash balance, March 31Loan repaymentsInterestS&P EnterprisesCash BudgetFor the Month of March

Answered: Image /qna-images/answer/822898cc-6233-457b-847a-1975607ff8bf.jpg

Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest Total financing Cash balance, March 31 S&P Enterprises Cash Budget For the Month of March

Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest Total financing Cash balance, March 31 S&P Enterprises Cash Budget For the Month of March

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 17E

See similar textbooks

Similar questions

Here are the relevant estimates for the budget preparation of Marvel Corporation for the fourth quarter of 2022: Credit sales Credit purchases Cash disbursements: Wages, taxes, and expenses Interest Equipment Credit sales collections: Collected in month of sale Collected month after sale Never collected September credit sales September credit purchases Beginning cash balance Instructions: October 1428 896 857 338 390 432 33 488 0 36% 62% 2% 1271222 762 733 574 653 November 1661 520 996 979 443 094 33 488 177 968 2.1 Explain the role of cash budget. 2.2 Using the above information, complete the following cash budget. purchases are paid one month after the purchase. December 1227 856 736 714 377 608 33 488 107 856 Assume that all credit
Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: April (actual) May (actual) June (forecast) July (forecast) August (forecast) September (forecast) Sales $ 370,000 350,000 325,000 325,000 340,000 380,000 Purchases $ 155,000 145,000 145,000 205,000 225,000 220,000 The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after. Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in June and September. There is a scheduled capital outlay of…
Need to used in formulas Expected cash collections: March cash collections March collections on accounts: January sales February sales March sales Total cash collections Payments to suppliers: Accounts payable for inventory purchase, beginning balance March purchase Total cash payments S & P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available before current financing Less disbursement: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursement Excess (deficiency) of cash available over disbursement Financing: Borrowings Repayments Interest Total financing Cash balancing, March 31
Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: Revenues April May $ 253,000 $ 272,000 $ 299,000 $ 346,000 $ 355,000 June July August Carmen's sales are 60% cash and 40% store credit. The credit sales are collected 60% in the month of sale, the remainder the following month. Accounts receivable on April 1 are $34,000. Carmen's cost of sales averages 65% of revenues. The inventory policy is to carry 30% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 40% in the month of purchase and 60% the following month. Accounts payable on April 1 is $133,000. a. Prepare a purchases budget for as many months as is possible. April May June July August Sales Cost of Sales Percentage % % Cost of Sales Ending Inv Beginning Inv Purchases
ⒸPR 22-5A Cash Budget Obj. 5 The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Sales Manufacturing costs Selling and administrative expenses Capital expenditures September $250,000 150,000 42,000 October $300,000 180,000 48,000 Answer Check Figure: November deficiency, $(8,500) 2. November $315,000 185,000 51,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the…
December cash disbursements for merchandise purchases would be:
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $110,000 $134,000 $183,000 Manufacturing costs 46,000 58,000 66,000 Selling and administrative 39,000 40,000 70,000 expenses Capital expenditures 44,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1…
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: July August $160,000 $185,000 $200,000 66,000 82,000 105,000 51,000 120,000 40,000 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Sales Manufacturing costs Selling and administrative expenses Capital expenditures June Current assets as of June 1 include cash of $42,000,…
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow: July $64,000 August $80,000 September $ 48,000 Budgeted sales Budgeted cash payments for Direct materials 16,160 4,040 20,200 13,440 3,360 16,800 13,760 3,440 17,200 Direct labor Factory overhead Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month- end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office…
1. Budgeted cash receipts in March 2. Budgeted accounts receivable at the end of March 3. Budgeted inventory at the end of February
What about preparing a schedule of expected cash disbursement for merchandise purchases, by month and the total and budgeted income statement for the three-month period ending June 30.
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.