Chapter $22$ Problems assignment take frame

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:

$\backslash$begin$\{$tabular$\}\{$lrrr$\}$

& September & October & November $\backslash \backslash$

$\backslash$hline Sales & $\backslash (\backslash$$ $250,000\backslash )$ & $\backslash (\backslash$$ $300,000\backslash )$ & $\backslash (\backslash$$ $315,000\backslash )\backslash \backslash$

Manufacturing costs & $150,000$ & $180,000$ & $185,000\backslash \backslash$

Selling and administrative expenses & $42,000$ & $48,000$ & $51,000\backslash \backslash$

Capital expenditures & & & $200,000$

$\backslash$end$\{$tabular$\}$

are paid in December. Of the remainder of the manufacturing costs, $\backslash (80\backslash \%\backslash )$ are expected to be paid in the month in which they are incurred and the balance in the following month. November. Management desires to maintain a minimum cash balance of $\backslash$$$50,000.$ Required:

$1.$ Prepare a monthly cash budget and supporting schedules for September, October, and November.

Bridgeport Housewares Inc.

Cash Budget

For the Three Months Ending November $30$