Question

In: Accounting

[The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for...

[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 $ 57,000 $ 73,000 $ 55,000
Budgeted cash payments for
Direct materials 15,760 13,040 13,360
Direct labor 3,640 2,960 3,040
Factory overhead 19,800 16,400 16,800


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,600 in accounts receivable; and a $4,600 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,600 per month), and rent ($6,100 per month).

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

BUILT-TIGHT
Cash Receipts Budget
For July, August, and September
July August September
Less: ending accounts receivable
Cash receipts from:
0 0 0
Total cash receipts

Prepare a cash budget for each of the months of July, August, and September.

Solutions

Expert Solution

A) A cash receipts budget for July, August, and September is as follows:

  BUILT-TIGHT

  Cash Receipts Budget

For July, August and September   

July($) August ($) September($)
Sales 57,000 73,000 55,000
Less: Ending Account Receivable (80%) 45,600 58,400 44,000
Cash Receipt:
Cash Sale (20%) 11,400 14,600 11,000
Collection of account receivable 44,600 45,600 58,400
Total Cash Receipt $56,000 $60,200 $69,400

B)A cash budget for July, August, and September is as follows:

BUILT-TIGHT

Cash Budget

For July, August and September

July ($) August($) September($)
Cash Balance at begining 15,000 15,000     22,522
Cash receipt   56,000   60,200 69,400
Total Cash Available 71,000 75,200 91,922
Cash Payment:
Direct materials 15,760 13,040 13,360
Direct labor 3,640 2,960 3,040
Factory overhead 19,800   16,400 16,800
Sales commissions (10% of sales) 5,700 7,300 5,500
office salaries ($3,600 per month)   3,600   3,600 3,600
Rent ($6,100 per month)   6,100   6,100 6,100
Interest (1%) 46 32 0
Total Cash Payment 54,646 49,432 48,400
Cash Surplus (Deficit) 16,354 25,768 43,522
Borrowing 0 0 0
Repayment (1,354) (3,246) 0
Ending Cash Balance $15,000 $22,522 $ 43,522
Loan Balance :
Loan Balance at Begining 4,600   3,246 0
Borrowing 0 0 0
Repayment (1,354) (3,246) 0
Loan Balance at Ending $3,246 $ 0 $ 0

Related Solutions

Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master...
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 September Budgeted sales $ 57,000 $ 73,000 $ 55,000 Budgeted cash payments for Direct materials 15,760 13,040 13,360 Direct labor 3,640 2,960 3,040 Factory overhead 19,800 16,400 16,800 Sales are 20% cash and 80% on credit. All credit sales are collected in...
Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master...
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 September Budgeted sales $ 56,000 $ 72,000 $ 56,000 Budgeted cash payments for Direct materials 15,560 12,840 13,160 Direct labor 3,440 2,760 2,840 Factory overhead 19,600 16,200 16,600 Sales are 20% cash and 80% on credit. All credit sales are collected in...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,300,000 Cost of goods sold Direct materials $ 945,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($60,000 is variable) 195,000 Plant management salaries 210,000 1,935,000 Gross...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 915,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($60,000 is variable) 195,000 Plant management salaries 210,000 1,905,000 Gross...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 195,000 Plant management salaries 210,000 1,950,000 Gross profit 1,050,000...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 975,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 210,000 Plant management salaries 210,000 1,995,000 Gross profit 1,155,000...
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. 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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT