please solve this step by step :) with the table below. thank you :)

35 pts Question 17 QUESTION ZURICH LTD Zurich Ltd's budgeted production and sales of leather gloves for Dec 2021-Apr 2022 months are as follows Production Sales (UNITS) (UNITS) November 800 December 850 800 January 900 850 February 1,000 900 March 1,050 1,000 April - 1100 1,050 May 1,200 1,100 June 1,300 1,200 The selling price per unit will be 210. All sales will be made on credit The business plans to offer a cash discount (of 10% of the amount owed) to those customers who pay within the same of the month of sale. Customers for 70% of units sold are expected to quality for the discount Remaining 30% of the sales is expected to be paid during the next month (.e one month later) It is planned that sufficient finished goods inventories for each month's sales should be available at the end of the previous month. For raw material purchases, the cost of raw material is 37 per unit. It is bought in the month of production and paid one month in arrears (.e later). The direct labour cost, which is variable with the level of production, is planned to be E28 per unit of finished production and it is paid in the month of production. Overhead costs are planned to be 53,000 each month including 8,000 for depreciation. Overhead costs are paid in the same month. Company bought an equipment for 1,200,000 in Jan and equal payments were made over Mar- Aug Opening cash balance at the start of Jan (1") is 55,000. Required: Draw up a cash budget for the 4 months from 1 January to 30 April 2022, with a column for each month. The budget should, among other things, show each end-of-month cash balance. (35 marks) QUESTION...... Production (Units) SALES (UNITS) S.PRICE () REVENUE () CASH BUDGET Cash Now Cash Next Month TOTAL CASH INFLOWS (A) CASH OUTFLOWS Raw Material Labour Overhead Equipment TOTAL CASH OUTFLOWS (B) Net cash surplus/deficit Opening cash Closing cash Dec Jan Jan Feb Feb Mar Mar Apr Apr