Question

Here are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019. April May June Credit sales $689,000 $598,000 $751,000 Credit purchases 302,000 282,000 338,000 Cash disbursements: Wages, taxes, and expenses 137,000 129,000 179,000 Interest 15,600 15,600 15,600 Equipment purchases 53,500 6,600 248,000 The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $561,000. Using this information, complete the following cash budget: April MAY JUNEBeginning cash balance 182,000 Cash receiptCash Collection from the credit saleTotal cash available Cash Disbursement Purchase $289,000 Wages, Taxes, and expenses Interest Equipment purchases Total cash Disbursement Ending cash balance

Answer 1

Answer and Explanation:

The presentation of the cash budget for the three months is shown below:

Particulars April May June

Beginning

cash balance $182,000 $264,650 $434,150

Add:

Cash receipts :

Credit sales

collections $577,750 $622,700 $621,650

Total cash

available $759,750 $887,350 $1,055,800

Less:

Cash disbursements

Purchases -$289,000 -$302,000 -$282,000

Wages, Taxes

and expenses -$137,000 -$129,000 -$179,000

Interest -$15,600 -$15,600 -$15,600

Equipment

purchases -$53,500 -$6,600 -$248,000

Total

cash disbursements -$495,100 -$453,200 -$724,600

Ending

cash balance $264,650 $434,150 $331,200

Working Notes:

Cash collection from credit sales

Particulars March April May June

Credit sales $561,000 $689,000 $598,000 $751,000

Cash collected :

35% cash collected

in month of sales $196,350 $241,150 $209,300 $262,850

60% cash collected

in following month

of sales $0 $336,600 $413,400 $358,800

Total cash

collected from sales $577,750 $622,700 $621,650