Please help with this practice problem for my managerial accounting class.

In September, NEE Company, a merchandising firm that sells one product, assembled the following information and estimates to prepare a budget for October. Expected sales are 42,000 units at a price of $32 per unit. The cost of merchandise purchases is expected to be $18 per unit. Selling and administrative expenses are estimated at $338,000, of which $24,000 is depreciation. The October 1 cash balance is expected to be $47,000. NEE estimates that 60% of each month's sales are collected in the month of sale and the remaining 40% is collected in the month after sale. Expected sales for September are $900,000. The company pays for 20% of its merchandise purchases during the month of purchase, and pays the remaining 80% during the month following purchase. Merchandise purchases for September are estimated to be $720,000 and the purchase cost per unit is $18. All other out-of-pocket expenses are paid for in cash. Requirement (a) NEE plans to purchase 31,000 units of merchandise in October. Prepare a cash budget or statement of estimated cash flows for October for the company. Cash inflows: Cash outflows: Net cash flow Opening cash Ending cash