The controller $of$ Bridgeport Housewares Inc. instructs you $to$ prepare a monthly cash budget for the next three months. You are presented with the following budget information:

Line Item; September; October; November

Sales; $$146,000$; $$180,000$; $$244,000$

Manu. Costs; $$61,000$; $$77,000$; $$88,000$

Selling & Admin Expenses; $$51,000$; $$54,000$; $$93,000$

Capital Expenditures; $$0$; $$0$; $$59,000$

The company expects $to$ sell about $10\%of$ its merchandise for cash. $Of$ sales $on$ account, $70\%$ are expected $tobe$ collected $in$ the month following the sale and the remainder the following month $(second$ month following sale$).$ Depreciation, insurance, and property tax expense represent $$7,000of$ the estimated monthly manufacturing costs. The annual insurance premium $is$ paid $in$ January, and the annual property taxes are paid $in$ December. $Of$ the remainder $of$ the manufacturing costs, $80\%$ are expected $tobe$ paid $in$ the month $in$ which they are incurred and the balance $in$ the following month.

Current assets $asof$ September $1$ include cash $of$ $$55,000,$ marketable $securitiesof$ $$79,000,$ and accounts receivable $of$ $$163,100($$$35,100$ from July sales and $$128,000$ from August sales$).$ Sales $on$ account for July and August were $$117,000$ and $$128,000,$ respectively. Current liabilities $asof$ September $1$ include $$7,000of$ accounts payable incurred $in$ August for manufacturing costs. All selling and administrative expenses are paid $in$ cash $in$ the period they are incurred. $An$ estimated income tax payment $of$ $$22,000$ will $be$ made $in$ October. Bridgeport$s$ regular quarterly dividend $of$ $$7,000is$ expected $tobe$ declared $in$ October and paid $in$ November. Management desires $to$ maintain a minimum cash balance $of$ $$54,000.$

Prepare a monthly cash budget and supporting schedules for September, October, and November. Assume $360$ days per year for interest calculations.