could some one help me for this question?

23. With the following information about the Hilborn, Hayes & Morrone Investment Co. prepare a cash budget for the months of January to April 2018. (40 Marks) The marketing department revenue forecast is as follows: November 2017 $50,000 December 2017 $110,000 January 2018 $185,000 February 2018 $75,000 March 2018 $90,000 April 2018 $125,000 The credit manager provides the following information: 15% of sales / revenue are on a cash basis 70% of sales / revenue are collected after 30 days 15% of sales / revenue are collected after 60 days Cost of sales, which is 40% of sales, 30% of the goods are paid upon purchase 70% of the goods are paid for 30 days after the purchases is made. Monthly selling and administrative expenses are as follows: Salaries $61,000 Telephone $1,000 Rent $3,200 Hydro $1,100 Office Supplies $500 The cash balance on January 1, 2018 is $15,000 Month December January February March April Monthly Revenue 1 10000 185000 75000 90000 125000 Total Monthly Cash Receipts (from previous question) 113750 157250 93750 93000 Cost of Sales / Goods - 40% of Sales / Revenue Cash Sales = 30% 30-day payment = 70% Cash Disbursements: COG Cash Surplus/Deficit