Question

In: Accounting

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...

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 $ 55,000 $ 71,000 $ 57,000
Budgeted cash payments for
Direct materials 15,360 12,640 12,960
Direct labor 3,240 2,560 2,640
Factory overhead 19,400 16,000 16,400


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,200 in accounts receivable; and a $4,200 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 ($3,200 per month), and rent ($5,700 per month).

1. Prepare a cash receipts budget for July, August, and September.

BUILT-TIGHT
Cash Receipts Budget
For July, August, and September
July August September
Sales
Less: ending accounts receivable
Cash receipts from:
Cash sales 0 0 0
Collections of prior month’s receivables
Total cash receipts $0 $0 $0

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.)

BUILT-TIGHT
Cash Budget
For July, August, and September
July August September
Beginning cash balance
Total cash available
Cash payments for:
Total cash payments 0 0 0
Preliminary cash balance
Additional loan from bank
Repayment of loan to bank
Ending cash balance 0 0 0
Loan balance
July August September
Loan balance - Beginning of month
Additional loan (loan repayment)
Loan balance - End of month

Solutions

Expert Solution

1) Cash Receipts Budget
BUILT-TIGHT
Cash Receipts Budget
For July, August and September
July August September
Cash Sales ($55,000*20/100); ($71,000*20/100); ($57,000*20/100) $11,000 $14,200 $11,400
Cash Receipts from Credit sales:
   From Accounts Receivable $44,200
   From July Sales ($55,000*80/100) $44,000
   From August Sales ($71,000*80/100) $56,800
Total Cash Receipts $55,200 $58,200 $68,200
2) Cash Budget
BUILT-TIGHT
Cash Budget
For July, August and September
July August September
Beginning Cash Balance $15,000 $15,000 $24,546
Add: Total Cash Receipts $55,200 $58,200 $68,200
Total Cash Available (a) $70,200 $73,200 $92,746
Cash Payments for:
Direct materials $15,360 $12,640 $12,960
Direct labor $3,240 $2,560 $2,640
Factory overhead $19,400 $16,000 $16,400
Sales commissions ($55,000*10/100); ($71,000*10/100); ($57,000*10/100) $5,500 $7,100 $5,700
Office salaries $3,200 $3,200 $3,200
Rent $5,700 $5,700 $5,700
Interest Expense ($4,200*1/100); ($4,200 - $2,760 = $1,440*1/100) $40 $14
Total Cash Payments (b) $52,440 $47,214 $46,600
Preliminary Cash Balance (a - b) $17,760 $25,986 $46,146
Additional loan from bank
Repayment of loan to bank ($17,760 - $15,000) ($2,760) ($1,440) $0
Ending Cash Balance $15,000 $24,546 $46,146
Loan Balance:
July August September
Loan balance - Beginning of month $4,200 $1,440 $0
Additional loan (loan repayment) ($2,760) ($1,440) $0
Loan balance - End of month $1,440 $0 $0

Related Solutions

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
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 $ 64,000 $ 80,000 $ 48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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 $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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 $ 55,000 $ 71,000 $ 57,000 Budgeted cash payments for Direct materials 15,360 12,640 12,960 Direct labor 3,240 2,560 2,640 Factory overhead 19,400 16,000 16,400 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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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 $ 63,000 $ 79,000 $ 49,000 Budgeted cash payments for Direct materials 16,360 13,640 13,960 Direct labor 4,240 3,560 3,640 Factory overhead 20,400 17,000 17,400 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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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 $ 63,000 $ 79,000 $ 49,000 Budgeted cash payments for Direct materials 16,360 13,640 13,960 Direct labor 4,240 3,560 3,640 Factory overhead 20,400 17,000 17,400 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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 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...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
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 $ 58,500 $ 74,500 $ 53,500 Budgeted cash payments for Direct materials 16,060 13,340 13,660 Direct labor 3,940 3,260 3,340 Factory overhead 20,100 16,700 17,100 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...
QUESTION 15: Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted...
QUESTION 15: 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,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance...
Raelynn is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Raelynn 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 August September Sales          69,250          85,400          54,750 Cash payments for merchandise          42,950          39,300          33,600 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;...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
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,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $12,200 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT