The controler of Bridgeport Housewares Inc. Instructs you to prepare a monthlych next three months. You are presented with the following budget information September October November Sales $124,000 $150,000 $207,000 Manufacturing costs 52.000 66.000 75.000 Selling and administrative 40,000 46,000 79.000 expenses Catexpenditures 90.000 The company expects to sell at 10% of merchandise for shows on account, perted to b e the o t hermander the following in controlowing Deprecation In , and property tax expense represent 89,000 of the estimated many mancing the n e wl y we on December or d er of the manufacturing co n expected to be paid in the month in which they were and the balance in the winem ) Current s of September 1 Indude cash of $47,000, mutta securities of $67.000, and conc e (SION 000 2,700 g Sales on out for Jay and August 10,000 and $109,000, respectively. Current s of September include 9.000 of accounts payable incurred in to de t a re sold in case the period they are incred. An estimated Required: 1. Prepare a monthly cash budget and wporting schedules for September October, and Novemberput per year for interest calculations u s as a s decrease and d i ch should be ined with a minus syn. Assume 100 days Bridgeport Howaresing For the three months Ending Novembro September October November Total cos QOU OO 11 QIL QI I ODIJOJ | QIU QUO QUODIU) OOO The bodo indicates that the minimum balance such s the end of September and other the balance be maintained in November. This can be corrected by the minimum de ce of the matter they whole September October $1200051532000 52.000 .000 207.000 75.000 Selling and admin 100 ,000 ,000 50.000 The company expect to bout 10 of merchandise for cash Of e cted to be collected in the month for the sale and the r ider the month(second month following sales Deprecat and tax expense nt 19.000 estimated m y manufacturing costs. The r e is alth , and n o rt e pod in December of the remainder of the manufacturing Co to be in the thin which are no t in the wing ) Current assets as of September lindude 47.000, atteso $6,000, 0 0 0,000 b y salad 20.700 m i les for Juy and August WWE SPR.000 and $109,000, respectively. Current of September 19,000 counts a n d in for a pense pidin cash in the period they are incred. An estimated Income tax payment of $18,000 wit be made in d e oort' regular quarterly dividend of 50.000 is expected to be deed in October ad pod imbe. Hinigene de este mantin minimum cash balance of $46,000 Regled 1. Prearea m ahu get per for interess ions porting de form a nd over Trout a