please show solving steps

Problem 24-02 Management wants to know if there will be a need for short-term financing in February, Essential information is as follows: a. Estimated sales for January and February are $1.2 million and $750,000, respectively. b. Seventy percent of sales are for cash and 30 percent are credit sales that are collected the next month. c. Cash disbursements that vary with sales are 45 percent of sales. d. Fixed operating disbursements are $300,000 a month. e. Depreciation expense is $50,000 a month. 6. A tax payment of $110,000 is due in January 9. A bond payment of $150,000 is owed and will be due in February h. The cash balance at the beginning of January is $13,000. Management seeks a minimum cash balance of $11,000 3. December credit sales were $70,000. Round your answers to the nearest dollar. Use a minus sign to enter shortage of cash, if any, January February Excess (shortage) of cash 5 $ The firme et need short-term funds in February