Concept explainers
The cash balance, May 31, 20x4, is $ 15.000. Sales proceeds are collected as follows: 80% the month od sale, 10% the second month, and 10% the third month.
Exhibit 7-13, Carlson Company - Budgetes Income Statement for the Month Ended June 30, 20x4 (in thousands)
Sales $290
Inventory, May 31 $50
Purchases 192
Available for sale 242
Inventory, June 30 40
Cost of goods sold 202
Gross margin 88
Operating expenses
Wagnes $36
Utilities 5
Advertising 10
Depreciation 1
Office expenses 4
Insurance and property taxes 3
Operating expenses 59
Operating income $29
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
- Determine the anticipated total cash receipts for the month of January for Madison Co. in preparing a Cash Budget, given the following info: Accounts Receivable balance as of January 1 $296,000.00 Budgeted Sales for January = $860,000.00 Madison Co. assumes all monthly sales are on account. And that 75% of the sales on account will be collected in the month of the sale, and that the remainder will be collected the following month. $688,000.00 $812,000.00 $941,000.00 O $468,000.00arrow_forwardFedor, Inc. has prepared the following direct materials purchases budget: Budgeted DM Purchases $69.000 77,000 78,700 77,800 76,200 All purchases are paid for as follows: 40% in the month of purchase, 50% in the following month, and 10% two months after purchase. Calculate total budgeted cash payments made in October for purchases. Month June July August September October OA. $77,250 OB. $46,770 OC. $38,350 O D. $69,380arrow_forwardplease step by step answer.arrow_forward
- Soru Muscat Inc. is working on its cash budget for December. The budgeted beginning cash balance is $14,000. Budgeted cash receipts total $127,000 and budgeted cash disbursements total $126,000. The desired ending cash balance is $50,000. How much the company needs to borrow a. $35,000 b. $0 c. $50,000 d. $70,000 tictheiournalentry to assien indirect raw materials to a iob W Parrow_forwardCash budget-Basic Grenoble Enterprises had sales of $50,100 in March and $59,800 in April. Forecast sales for May, June, and July are $70,400, $79,700, and $99,800, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 23% of sales for cash, 64% are collected in the next month, and the remaining 13% are collected in the second month following sale. (2) The firm receives other income of $2,100 per month. (3) The firm's actual or expected purchases, all made for cash, are $50,400, $69,900, and $79,800 for the months of May through July, respectively. (4) Rent is $3,000 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $3,400 will be paid in June. (7) Payment of principal and interest of $3,600 is due in June. (8) A cash purchase of equipment costing $6,400 is…arrow_forwardHow do I prepare the cash budget for the quarter ended March 31, 20X1?arrow_forward
- Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…arrow_forwardThornton, Inc. has budgeted sales for the months of September and October at S304,000.00 and $288,000.00, respectively. Monthly sales are 20% credit and 80% cash. Of the credit sales, 50% are collected in the month of sale, and 50% are collected in the following month. Calculate cash collections for the month of October. O A. $289,600.00 O B. $302.400.00 OC. $259,200.00 O D. $273,600.00arrow_forwardCash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $1,236. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. Inventory purchases average 72% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner. Rent is $5,400 per month. Taxes to be paid in June are $6,780. The owner also…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education