Concept explainers
Learning Goal 4
P4-9 Cash disbursements schedule Maris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. Use the format of Table 4.9 and the following information in its preparation.
Sales: February = $500,000; March = $500,000; April = $560,000;
May = $610,000; June = $650,000; July = $650,000
Purchases: Purchases are calculated as 60% of the next month's sales, 10% of purchases are made in cash, 50% of purchases are paid for 1 month after purchase, and the remaining 40% of purchases are paid for 2 months after purchase.
Rent: The firm pays rent of $8,000 per month.
Wages and salaries: Base wage and salary costs are fixed at $6,000 per month plus a variable cost of 7% of the current month’s sales.
Taxes: A tax payment of $54,500 is due in June.
Fixed asset outlays: New equipment costing $75,000 will be bought and paid for in April.
Interest payments: An interest payment of$30,000 is due in June.
Cash dividends: Dividends of $12,500 will be paid in April.
Principal repayments and retirements: No principal repayments or retirements are due during these months.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
- lesson 9 quiz - financial planning tools and concepts pt. 2 gerry jacobs, a financial analyst for best value supermarkets, has prepared the following sales and cash disbursement estimates for the period of august through december of the current year. month sales cash disbursements august 400 300 september 500 500 october 500 700 november 600 400 december 700 500 90% of sales are for cash, the remaining 10% are collected one month later. all disbursements are on a cash basis. the firm wishes to maintain a minimum cash balance of 50. the beginning cash balance in september is 25. prepare a cash budget for the months of october, november, and december, noting any needed financing or excess cash available.arrow_forwardeBook Show Me How Question Content Area Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $290,000 June 350,000 July 530,000 All sales are on account. 56 percent of sales are expected to be collected in the month of the sale, 34% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July. May June July May sales on account: Collected in May fill in the blank 1 Collected in June fill in the blank 2 Collected in July fill in the blank 3 June sales on account: Collected in June fill in the blank 4 Collected in July fill in the blank 5 July sales on account: Collected in July fill in the blank 6 Total cash collected $fill in the…arrow_forwardDesiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.arrow_forward
- Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.arrow_forwardWhat would be the cash disbursements for month 3? Description Month 1 Month 2 Month 3 Month 4 Material Purchases $ 175,000.00 $ 185,000.00 $ 215,000.00 $ 190,000.00 Amount paid in month of purchase 65.00% Amount paid in month after purchase 30.00% Amount paid two months after purchase 5.00% Discounts in month of purchase 3.50% Discount in month after purchase 1.00% Total Cash disbursements in month 3 Show your work below Description Month 1 Month 2 Month 3arrow_forwardNeed 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 31arrow_forward
- Schedule of expected cash collections Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below: April $300,000 May June Total eted Sales $500,000 $200,000 $1,000,000 From past experience, the company has learned that 15% of the company's sales are for cash. Credit sales are collected as follows: 20% are collected in the month of sale, another 70% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. A. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. B. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.arrow_forwardPreparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardQuestion ANSWER B ONLY AND CALCULATE TOTAL The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows:Month Cash Sales Sales on Account PurchasesAugust $85,000 $640,000 $420,000September 70,000 550,000 550,000October 88,550 600,000 500,000 November 77,160 800,000 600,000December 174,870 500,000 450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50%…arrow_forward
- Ⓒ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…arrow_forwardstimated finished goods inventory balance at the end of July? 13. What is the estimated cost of goods sold and gross margin for July? 14. What is the estimated total selling and administrative expense for July? 15. What is the estimated net operating income for July? Connect EXERCISE 8-1 Schedule of Expected Cash Collections LO8-2 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below- April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: Using Schedule 1 as…arrow_forwardSELF-DEVELOPMENT E-LIBRARY ZAIN HANDBOOKS Morgan Manufacturing is preparing its cash budget for the second quarter. The following amounts are budgeted for materials purchases: April $62.880 May $44,960 June $47.360 Morgan pays for 20% of its purchases in the month of purchase, 60% in the month following purchase, and 20% in the second month after purchase. What are Morgan's budgeted cash payments for purchases in June? O a. $93,120 Ob. $9,472 Oc. $39,552 O d. $49.024 Help Navt nan 10:06 AM РОСОРНONЕ 11/3/202 SHOT ON POCOPHONE F1arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College