70.2K

Verified Solution

Link Copied!

1.

SONOMA HOUSEWARES INC.

Cash Budget

For the Three Months Ending July 31, 2014

May

June

July

Estimated cash receipts from:

Cash sales

Collections from accounts receivable

Total cash receipts

Estimated cash payments for:

Manufacturing costs

Selling and administrative expenses

Capital expenditures

Other purposes:

Income tax

Dividends

Total cash payments

Cash increase (decrease)

Cash balance at beginning of month

Cash balance at end of month

Minimum cash balance

Excess (deficiency)

Supporting calculations:

Collections of accounts receivable:

Sales on

Account

Percentage

May

June

July

March sales

April sales:

Collected in May

Collected in June

May sales:

Collected in June

Collected in July

June sales

Totals

Payments for manufacturing costs:

Costs on

Account

Percentage

Payments

Paid in May:

Incurred in April

Incurred in May

Total

Paid in June:

Incurred in May

Incurred in June

Total

Paid in July

Incurred in June

Incurred in July

Total

Answer & Explanation Solved by verified expert

See Answer