please help!

Cath budoet The controlier of Eridgeport Houspwares Inc, imuructs you to presare a monthiy essh budget for the nent three months. You are presented aith the following budget informaton: The comsany expects to sell about 10% of its mechandse for cath, Of saies on acoount, 700 are expected to be collected in the month foliowing the saie and the remander the following month (second month following wie). Oeprecisiof, insurante, and propety tax expense represent 410,000 of the estimated monthy manufacturing costs. The anthual insurance premium is paid in January, and the . annual propety taxes are paid in December of the remainder of the maoufacturing costs, Bpw ere expected to be paid in the meneh in which they are incurred and the balance in the following month. Current assess as of Sephember 1 inclute cash of 556,000 , maketable securhies of 310,000 , and accounts recevabie of st65, 400 (535, 400 trom July saies and 5130,000 froms Avguit saces). Saies on adminierative expenses are pad in cah in the period they wee incurred. An estimeted income tax sayment 121,000 ail be made in october Bridgepors regular puartely dividend of 110,000 is espectes to be declared in octoter and gaid in Nwember Manopement devires to mantain a minimum cavh balance of $55,000. Required 1. Frepare a mogetily cash budget and supporting schedules for September, Octobec, and November Assume 360 says ser year for interest catculations. Brrogeport Housewaresinc. Cash Budget For the Three Months Ending November 30 Line Item Description September October November Estimated cash receipts from: Total cash receipts Less estimated cash payments for: Other purposes: Total cash payments Cash balance at end of month Excess or (deficiency)