Cash budget

$\backslash$table$[[,$September,Octuber,November$],[$Sales$,$$$121,000,$$$154,000,1206,000],[$Manufacturing costs,$51,000,64,000,74,000],[$Selling and administrative expenses,$42,000,46,000,78,000],[$Capital expenditures,,,$49,000]]$ are paid in December. Of the remainder of the manufacturing costs, $80\%$ are expected be be paid in the month in which they are incurred and the balance in the following month. paid in November. Management desires to maintain a minimum cash balance of $$45,000.$

Required:

Prepare a monthly cash budpet and supporting schedules for September, Octobec, and November. Assume $360$ days per par for interest calculations.

Bridgeport Housewares Inc.

Cash Budget

For the Three Months Ending November $30$

$\backslash$table$[[$Line Item Description,September,October,November$],[$Estimated cash receipts from:,,,$],[\backslash$table$[[$