Sales are 65% cash and 35% on credit. All credit sales are
collected in the month following the sale. The March 31 balance
sheet includes balances of $12,700 in cash, $12,700 in accounts
receivable, $11,000 in accounts payable, and a $2,700 balance in
loans payable. A minimum cash balance of $12,700 is required. Loans
are obtained at the end of any month when a cash shortage occurs.
Interest is 2% 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 include sales
commissions (5% of sales), shipping (2% of sales), office salaries
($3,700 per month), and rent ($5,700 per month).
April May June
Sales........................................... 31,300 40,700 24,700
Cash payments for merchandise 21,600 16,100 16,500
Prepare a cash budget for each of the months of April, May, and June. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)
Solution
Cash Budget | |||
for April, May and June | |||
April | May | June | |
Beginning Cash Balance | $ 12,700 | $ 12,700 | $ 18,803 |
Cash sales | $ 20,345 | $ 26,455 | $ 16,055 |
Collection on account | $ 12,700 | $ 10,955 | $ 14,245 |
Total Cash Available | $ 45,745 | $ 50,110 | $ 49,103 |
Cash Payments For | |||
Merchandise | $ 21,600 | $ 16,100 | $ 16,500 |
Sales Commission | $ 1,565 | $ 2,035 | $ 1,235 |
shipping | $ 626 | $ 814 | $ 494 |
office salaries | $ 3,700 | $ 3,700 | $ 3,700 |
Rent | $ 5,700 | $ 5,700 | $ 5,700 |
Interest on loan | $ 54 | $ 58 | $ - |
Total Cash Payments | $ 33,245 | $ 28,407 | $ 27,629 |
Preliminary Cash Balance | $ 12,500 | $ 21,703 | $ 21,474 |
Additional loan (loan repayment) | $ 200 | $ (2,900) | |
Ending Cash Balance | $ 12,700 | $ 18,803 | $ 21,474 |
Loan Balance | |||
Loan Balance-Beginning of the month | $ 2,700 | $ 2,900 | $ - |
Additional Loan (Loan Repayment) | $ 200 | $ (2,900) | $ - |
Loan Balance End of Month | $ 2,900 | $ - | $ - |
Working
Cash receipts from sales | |||
April | May | June | |
Total Sales | $ 31,300 | $ 40,700 | $ 24,700 |
Cash Sales | $ 20,345 | $ 26,455 | $ 16,055 |
Collection for Previous month | $ 12,700 | $ 10,955 | $ 14,245 |
Sales are 65% cash and 35% on credit. All credit sales are collected in the month...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,900 $ 41,100 $ 25,100 Cash payments for merchandise 22,400 15,700 16,100 Sales are 70% cash and 30% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,100 in cash, $13,100 in accounts receivable, $11,000 in...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts $518,000 404,000 464,000 Cash payments $465,900 351,900 531,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at...
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 August September Budgeted sales $ 58,000 $ 74,000 $ 54,000 Budgeted cash payments for Direct materials 15,960 13,240 13,560 Direct labor 3,840 3,160 3,240 Factory overhead 20,000 16,600 17,000 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
Problem 22-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,500 $ 76,500 $ 51,500 Budgeted cash payments for Direct materials 16,860 14,140 14,460 Direct labor 4,740 4,060 4,140 Factory overhead 20,900 17,500 17,900 Sales are 30% cash and 70% on credit. All...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....
Exercise 20-32A Merchandising: Cash budget LO P4 Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted Sales Cash payments for merchandise July $62,100 44,200 August $81,900 31,700 September $49,900 32,500 Sales are 15% cash and 85% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $14,200 in cash; $52,500 in accounts...
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. 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; $44,400 in accounts receivable; $3,900 in accounts payable; and a $4,400 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at...
Required information Problem 22-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August $56,500 $ 72,500 September $ 55,500 Budgeted sales Budgeted cash payments for Direct materials Direct labor Factory overhead 15,660 3,540 19,700 12,940 2,860 16,300 13,260 2,940 16,700 Sales are 20% cash and 80% on credit....
Aztec Company sells its product for $190 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 8,000 $1,520,000 May (actual) 2,600 494,000 June (budgeted) 7,500 1,425,000 July (budgeted) 8,000 1,520,000 August (budgeted) 4,000 760,000 All sales are on credit. Recent experience shows that 28% of credit sales is collected in the month of the sale, 42% in the month after the sale, 27% in the second...
Aztec Company sells its product for $190 per unit its actual and budgeted sales to low. Units Dollars $950,000 Aprill (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 5.000 2,000 7,500 6,000 4,300 380,000 1.425,000 1.140,000 817,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....