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 DescriptionSeptemberOctoberNovemberSales$$131,000$$$166,000$$$215,000$Manufacturing costs$55,00071,00077,000$Selling and administrative expenses$46,00050,00082,000$Capital expenditures $52,000$The company expects to sell about $10\%$ of its merchandise for cash. Of sales on account, $70\%$ are expected to be collected in the month following the sale and the remainder the following month $($second month following sale$).$ Depreciation, insurance, and property tax expense represent $$6,000$ of 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 to be paid in the month in which they are incurred and the balance in the following month.Current assets as of September $1$ include cash of $$50,000,$ marketable securities of $$71,000,$ and accounts receivable of $$146,500($$$31,500$ from July sales and $$115,000$ from August sales$).$ Sales on account for July and August were $$105,000$ and $$115,000,$ respectively. Current liabilities as of September $1$ include $$6,000$ of 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 $$20,000$ will be made in October. Bridgeports regular quarterly dividend of $$6,000$ is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $$49,000.$Required:Question Content Area$1.$ Prepare a monthly cash budget and supporting schedules for September, October, and November. Assume $360$ days per year for interest calculations.Bridgeport Housewares Inc.Cash BudgetFor the Three Months Ending November $30$Line Item DescriptionSeptemberOctoberNovemberEstimated cash receipts from:$Cash sales$Cash sales$Cash salesCollection of accounts receivableCollection of accounts receivableCollection of accounts receivableTotal cash receipts$Total cash receipts$Total cash receipts$Total cash receiptsLess estimated cash payments for:$Manufacturing costs$Manufacturing costs$Manufacturing costsSelling and administrative expensesSelling and administrative expensesSelling and administrative expensesCapital expendituresOther purposes:Income taxDividendsTotal cash payments$Total cash payments$Total cash payments$Total cash payments$Cash increase or $($decrease$)$$Cash increase or $($decrease$)$Cash increase or $($decrease$)$Plus cash balance at beginning of monthPlus cash balance at beginning of monthPlus cash balance at beginning of monthCash balance at end of month$Cash balance at end of month$Cash balance at end of month$Cash balance at end of monthLess minimum cash balanceLess minimum cash balanceLess minimum cash balanceExcess or $($deficiency$)$$Excess or $($deficiency$)$$Excess or $($deficiency$)$$Excess or $($deficiency$)$Feedback AreaFeedbackThe primary source of estimated cash receipts is from cash sales and collections on account.To estimate cash receipts from cash sales and collections on account, a schedule of collections from sales is prepared.Question Content Area$2.$ On the basis of the cash budget prepared in part $(1),$ what recommendation should be made to the controller?The budget indicates that the minimum cash balance fill in the blank $1$ of $4$ be maintained in November. This situation can be corrected by fill in the blank $2$ of $4$ and$/$or by the fill in the blank $3$ of $4$ of the marketable securities$,$ if they are held for such purposes. At the end of September and October, the cash balance will fill in the blank $4$ of $4$ the minimum desired balance.