Question

Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions...

Required information

Problem 20-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 $ 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 of $15,000 in cash; $45,000 in accounts receivable; and a $5,000 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,000 per month), and rent ($6,500 per month).

rev: 03_17_2020_QC_CS-204679

Problem 20-2A Part 1

(1) 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:
Total cash receipts

Homework Answers

Answer #1
BUILT-TIGHT
Cash Receipts Budget
For July, August, and September
July August September
Sales 64000 80000 48000
Less: ending accounts receivable 51200 64000 38400
Cash receipts from:
Cash sales 12800 16000 9600
Collection of prior month's receivables 45000 51200 64000
Total cash receipts 57800 67200 73600
Workings:
Ending accounts receivable:
July 51200 =64000*80%
August 64000 =80000*80%
September 38400 =48000*80%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 $ 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. 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 $ 59,500 $ 75,500 $ 52,500 Budgeted cash payments for Direct materials 17,060 14,340 14,660 Direct labor 4,940 4,260 4,340 Factory overhead 21,100 17,700 18,100 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...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 Use the following information to prepare the...
Exercise 20-25A Merchandising: Preparing a cash budget LO P4 Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $72,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 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...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $41,000. Budgeted cash receipts from sales in September, $264,000. Raw materials are purchased on account. Purchase amounts are: August (actual), $77,000, and September (budgeted), $108,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget Cash sales $72,000 $68,000 $86,000 Sales on account 86,000 107,000 121,600 Total budgeted sales $158,000 $175,000 $207,600 Schedule of Cash Receipts Current cash...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. 1. July August September Sales Budget Cash sales $67,000 $67,000...
Karim Corp. requires a minimum $9,400 cash balance. If necessary, loans are taken to meet this...
Karim Corp. requires a minimum $9,400 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,800 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. July August September Cash receipts $ 25,400 $...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT