Lamia's House of Software (LHS) wants to prepare a cash budgetfor months of

September through Dêcember. Using the followinginformation,

Sales were $50,000 in June and $60,000 in July. Sales havebeen

forecasted to be $65,000, $72,000, $63,000, $59,000, and$56,000 for months

of August, September, October, November, and December,respectively. In the

past, 10 percent of sales were on cash basis, and thecollection were 50

percent in the first month, 30 percent in the second month,and 10 percent in

the third month following the sales.

n

Every four months (three times a year) $500 of dividends frominvestments

are expected. The first dividend payment was received inJanuary.

Purchases are 60 percent of sales, 15 percent of which arepaid in cash, 65

percent are paid one month later, and the rest is paid twomonths after

purchase.

$8,000 dividends are paid twice a year (in March andSeptember).

The monthly rent is $2,000.

Taxes are $6,500 payable in December.

A new machine will be purchased in October for $2,300

$1,500 interest will be paid in November

$1,000 loan payments are paid every month.

Wages and salaries are $1,000 plus 5 percent of sales in eachmonth.

August's ending cash balance is $3,000.

LHS would like to maintain a minimum cash balance of$10,000.

October Cash.

$1,570 ExcessCash

November Cash

$36,900 Excess cash

September cash

$1,570 Required Financing