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 credit sales are
collected in the month following the sale. The June 30 balance
sheet includes balances of $15,000 in cash; $45,700 in accounts
receivable; $5,200 in accounts payable; and a $5,700 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 salaries ($4,700 per month), and
rent ($7,200 per month).
Problem 22-2A Part 2
(2)
Prepare a cash budget for each of the months of July, August, and
September. (Negative balances and Loan repayment amounts
(if any) should be indicated with minus sign. Enter your final
answers in whole dollars.)
Cash reciepts budget | |||||||
For July ,August ,September | |||||||
July | August | September | |||||
Sales | 60,500 | 76,500 | 51,500 | ||||
less:Ending accounts receivable | 42350 | 53550 | 36050 | ||||
Cash receipts from: | |||||||
Cash sales | 18150 | 22950 | 15450 | ||||
collections from prior month's receivables | 45,700 | 42350 | 53550 | ||||
total cash receipts | 63850 | 65300 | 69000 | ||||
Cash budget | |||||||
July | August | September | |||||
Beginning cash balance | 15,000 | 15,000 | 22,669 | ||||
Cash receipts from customers | 63850 | 65300 | 69000 | ||||
Total cash available | 78,850 | 80300 | 91669 | ||||
Cash payments for: | |||||||
Direct Materials | 16,860 | 14,140 | 14,460 | ||||
Direct Labor | 4,740 | 4,060 | 4,140 | ||||
Overhead | 20,900 | 17,500 | 17,900 | ||||
Sales Commissions | 6050 | 7650 | 5150 | ||||
Office salaries | 4,700 | 4,700 | 4,700 | ||||
Rent | 7,200 | 7,200 | 7,200 | ||||
interest on bank loan | 57 | 24 | 0 | ||||
total cash payments | 60,507 | 55,274 | 53,550 | ||||
Preliminary cash balance | 18,343 | 25,026 | 38,119 | ||||
Addittional loan ( loan repayment) | 3,343 | -2,357 | 0 | ||||
Ending cash balance | 15,000 | 22,669 | 38,119 | ||||
loan Balance | |||||||
July | August | September | |||||
Loan Balance -Beginning of month | 5,700 | 2,357 | 0 | ||||
Addittional loan (loan repayment) | -3,343 | -2,357 | 0 | ||||
loan balance-end of month | 2,357 | 0 | 0 | ||||
Problem 22-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.]...
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....
Required information [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,000 $72,000 September $ 56,000 Budgeted sales Budgeted cash payments for Direct materials Direct labor Factory overhead 15,560 3,440 19,600 12,840 2,760 16,200 13,160 2,840 16,600 Sales are 20% cash and 80% on credit. All credit sales are collected in the month...
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. 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...
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: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 $12,000 in cash; $45,000 in accounts receivable; $4,500 in accounts payable; and a $2,000 balance in loans payable. A minimum cash balance of...
Exercise 20-20 Cash budget LO P2 Karim Corp. requires a minimum $8,600 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,000 and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. Cash receipts...
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 July 562,450 43.600 August $81,500 32.009 September $49,609 3 2.30 Cash payments for nerchandise 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 $13.900 in cash, $51,100 in accounts receivable; $6,100 in accounts payable, and a...
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,800 42,800 August $81, 2ee 32,400 September $49,200 33,200 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 $13,500 in cash: $49,600 in accounts receivable: $5.700 in accounts payable, and...
Check my work 5 Exercise 20-20 Cash budget LO P2 Karim Corp. requires a minimum $9,800 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $10,200, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. points еВook September $41,800...
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...