I hope for a solution, focusing on the value of purchases and inventory, last and first in the solution

Al Noor Company is a trading company that sells one product. The company has planned inventory, production, and unit sales for the next three months as follows:

	October	November	December
Inventory at the beginning of the period	500	500	500
Purchases of goods	5000	7000	6000
sales	4000	4000	4000
Closing stock	1500	3500	2500

The unit is sold at a price of 15 riyals. Half of the value is paid in the same month of sale and the rest is paid in the following month. Accounts receivable on September 30 are 1000 riyals.

The goods are purchased at 4 per unit. Half of the value is paid in the same month of purchase and the remainder is paid in the following month of purchase. The planned selling and administrative expenses, which will be paid monthly, 5000 riyals per month. Transfer expenses per month 6000 riyals, including 500 riyals depreciation on equipment. The balance of accounts payable on September 30 is 30,001 riyals.

The cash balance on September 30 is estimated at 10,000 riyals. The value of purchasing equipment will be paid during the month of November at a value of 6,000 riyals, and a dividend of 9,000 riyals will be paid during December. The company wants to keep a minimum of 10,000 riyals of cash at the end of each month

Required:

a. Prepare a table of expected cash collections for each of the three months, October, November, and December.

B. Create a schedule of expected cash payments for purchases for each of the three months, October, November, and December.

c. Prepare the projected cash budget for each of the three months, October, November, and December.