Use the following information: Beginning cash balance on March 1, $78,000. Cash receipts from sales, $301,000. Budgeted cash payments for direct materials, $140,000. Budgeted cash payments for direct labor, $71,000. Other budgeted cash expenses, $40,000. Cash repayment of bank loan, $10,000. Prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash payments for the month of March and the balance expected on March 31.

Use the following information: Beginning cash balance on March 1, $78,000. Cash receipts from sales, $301,000. Budgeted cash payments for direct materials, $140,000. Budgeted cash payments for direct labor, $71,000. Other budgeted cash expenses, $40,000. Cash repayment of bank loan, $10,000. Prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash payments for the month of March and the balance expected on March 31.

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter8: Budgets And Bank Reconciliations

Section: Chapter Questions

Problem 2.4C

See similar textbooks

Similar questions

Thornton Medical Clinic has budgeted the following cash flows. Cash receipts Cash payments For inventory purchases For S&A expenses January $ 116,000 98,000 39,000 February $ 122,000 80,000 40,000 March $ 142,000 93,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash balance of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Thornton pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget Note: Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign.
Direct materials budget. Schedule of cash receipts. Schedule of cash payments for direct materials.. Cash budget. Budgeted income statement for entire second quarter (not monthly). Budgeted balance sheet at June 30.
RequiredPrepare cash budget, for the three month from October to December showing cash balance at the end of December .
QS 20-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $76,000. b. Cash receipts from sales, $308,000. c. Cash payments for direct materials, $140,000. d. Cash payments for direct labor, $79,000. e. Cash payments for overhead, $37,000. f. Cash payments for sales commissions, $7,000 g. Cash payments for interest, $170 (1% of beginning loan balance of $17,000) h. Cash repayment of loan, $17,000. Prepare a cash budget for March for Gado Company. Total cash available GADO COMPANY Cash Budget March
g. Prepare a schedule of cash collected from customers for the quarter ended March 31, 20X1. h. Prepare the cash budget for the quarter ended March 31, 20X1.
Required:1. Prepare a budgeted income statement for February and March2. Prepare a cash budget for February and Marc
Q.Prepare the Revenues budget for April
Question 1 From the following information prepare a monthly cash budget for the three months ending 31st Dec.2020 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM) June 6,000 3,600 1,300 450 320 July 6,500 4,000 1,500 450 320 Aug. 7,000 4,800 1,500 500 350 Sep. 7,500 4,500 1,500 600 350 Oct. 8,000 4,600 1,600 600 400 Nov. 8,500 5,000 1,800 700 400 Dec. 9,000 5,200 2,000 700 450 Credit terms Sales 3 months to debtors. 10% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material – 2 months. Lag in payment Wages. 1/4 month, overheads 1/2 month. Other information Plant and Machinery to be installed in Aug. at a cost of RM30,000. It will be paid for by monthly installments of RM1,000 each from 1st Oct.; Preference share dividend @ 6% on RM100,000 are to be paid on 1st Dec. Calls on 500 equity shares @ RM2 per share expected on 1st November; Dividends from…
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…
Prepare the cash budget for January and February of Gilmore Company using the following data: February P42,100 January Cash Receipts Cash Disbursements Beginning Cash Balance Ending P46,500 P38,320 P37,220 P5,210 As per computation Required Cash Balance (Minimum) P12,000 P12,000
Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Minden Company Balance Sheet April 30 Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $255,000 for May. Of these sales, $76,500 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $189,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during…
Cash budget for each month, information attached.