having some trouble getting past thr first step here

1. Prepare a month budget and supporting schedules for May June and trout amounts w e also over G r e y For the Three Months Ending 3 Estimated cash recess from Cash sales Collection of accounts recevable Totalcarsh recot 0011 Selling Other purposes Income tax Dividende Chance and QUI E ncy) and cons on The proceed chcet is prepared o n account schedule of contro The controller of Sonoma Housewares the instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget Information May June July e $89.000 $110.000 $140,000 Handturing costs 37,000 47,000 51.000 Selling and administrative expenses 25.000 30.000 31,000 Capital expenditures 000 The company expect to about 12 of its merchandise for cash of sales on account, 601 are expected to be collected in the month following the remainder the month oth Insurance and property tax expense represent $9.000 of the estimated monthly manufacturing The u nsurance premis paid in Septembead the al property are padin November of the manufacturing co m pete te bepald in the month in which they we incurred and the balance in the following mo Current as of May 1 indude cash of $34.000,marketable securities of 48.000, daccounts receivable of $106.400 88.000 from or 2.400 from Marches and $78,000, respectively. Curren t es as of May 1 incude 11.500 of accounts payable incurred in Apr for manufacturing costs and administrative s are in cash is the led they are in payment of $13.000 will be made in June. Sonoma's regular quarterly dividend of $9.000 s pected to be declared in June and paid in July, Management wants to m ain cash balance 27.000 r other were 000