Question

The owner of a building supply company has requested a cash budget for June. After examining...

The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following:

Cash balance on June 1 is $736.

Actual sales for April and May are as follows:

April May
Cash sales $10,000 $18,000
Credit sales 28,900 35,000
Total sales $38,900 $53,000

Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible.

Inventory purchases average 72% of a month's total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month.

Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner.

Rent is $4,400 per month.

Taxes to be paid in June are $6,780.

The owner also tells you that he expects cash sales of $18,600 and credit sales of $54,000 for June. No minimum cash balance is required. The owner of the company doesn’t have access to short-term loans.

Required:

1. Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments. Round calculations and final answers to the nearest dollar. Be sure to enter percentages as whole numbers.

Cash Budget
For June
Beginning cash balance $
Collections:
Cash sales
Credit sales:
Current month
$ ×  %
May credit sales
$ ×  %
April credit sales
Total cash available $
Less disbursements:
Inventory purchases:
Current month
$ ×  % $
Prior month
$ ×  %
Salaries and wages
Rent
Taxes
Total cash needs
Excess of cash available over needs $

2. Conceptual Connection: Did the business show a negative cash balance for June?

Homework Answers

Answer #1

1.

Cash Budget
For June
Beginning cash balance 736
Collections:
Cash sales 18600
Credit sales:
Current month
$54000 x 40% 21600
May credit sales
$35000 x 30% 10500
April credit sales ($28900 x 20% x 1.02) 5896 37996 56596
Total cash available 57332
Less disbursements:
Inventory purchases:
Current month
$72600 x 72% x 20% 10454
Prior month
$53000 x 72% x 80% 30528
Salaries and wages 11750
Rent 4400
Taxes 6780
Total cash needs 63912
Excess of cash available over needs -6581

2. Yes

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
The owner of a building supply company has requested a cash budget for June. After examining...
The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $1,236. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month....
Cash Budget The owner of a building supply company has requested a cash budget for June....
Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $1,186. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: April May June Credit sales $ 327,000 $ 307,000 $ 367,000 Credit purchases 135,000 158,000 183,000 Cash disbursements Wages, taxes, and expenses 44,700 12,200 63,700 Interest 11,700 11,700 11,700 Equipment purchases 87,000 164,000 0    The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the...
Boston Company developed the following budgeted data for the month of June: a. The June 1st...
Boston Company developed the following budgeted data for the month of June: a. The June 1st cash balance is $34,700. b. Cash sales in June are $75,000. c. Credit sales for June are expected to be $40,000. Credit sales for May were $60,000 and for April were $50,000. 70% of credit sales are collected in the month of sale, 20% are collected in the month following the sale, and the remaining 10% are collected in the second month following the...
roblem 3 Here are some important figures from the budget of Nashville Nougats, Inc., for the...
roblem 3 Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2012:   April   May   June     Credit sales $ 312,000   $ 291,200   $ 350,400     Credit purchases   118,240     141,040     166,800     Cash disbursements                       Wages, taxes, and expenses   43,040     10,800     62,640       Interest   10,480     10,480  ...
Here are some important figures from the budget of Cornell, Inc., for the second quarter of...
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2016: April May June   Credit sales $ 318,000 $ 298,000 $ 358,000   Credit purchases 126,000 149,000 174,000   Cash disbursements     Wages, taxes, and expenses 43,800 11,300 62,800     Interest 10,800 10,800 10,800     Equipment purchases 78,000 146,000 0 The company predicts that 5 percent of its credit sales will never be collected, 20 percent of its sales will be collected in the month of the sale, and...
Here are some important figures from the budget of Marston, Inc., for the second quarter of...
Here are some important figures from the budget of Marston, Inc., for the second quarter of 2016:    April May June Credit sales $ 415,000 $ 364,000 $ 452,000 Credit purchases 192,000 180,000 213,000 Cash disbursements Wages, taxes, and expenses 81,000 76,500 105,200 Interest 10,700 10,700 10,700 Equipment purchases 39,500 12,000 160,000    The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the...
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following...
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following to prepare the budget: 1.         Real Sales 2018:         January                        - $100,000                                                 February                      - $200,000                                                 March                          - $150,000             Projected for 2018:     April                            - $400,000                                                 May                             - $300,000                                                 June                             - $200,000             Sales Payment History:           10% cash                                                             40% Accts. Rec. – collected n/30 days                                                             50% Accts. Rec. – collected n/60...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,110. Actual sales for August and September are as follows: August September Cash sales $6,000     $4,500     Credit sales 58,000     62,000         Total sales $64,000     $66,500     Credit sales are collected over a three-month period: 40 percent in the month of sale, 36...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT