SNS Company is preparing budget for the next four months of 2022 that is January to April, the following forecast information has been made available:

Projected sales

Jan. Feb. March. April.

Quantity (units) 50,000 55,000 55,000 60,000

Projected Purchases:

Jan. Feb March April

Quantity (units) 56,000 55,000 59,000 60,000

1. Selling price is GH15 per unit but expected to remain same till end of the year
2. The purchasing cost is expected to be GH6 per unit
3. Receipts of sales are expected to be 25% in the month of sales, 75% the following month.
4. Goods purchased are paid one month in arrears.
5. Monthly expenses estimated at 12% on sales revenue are paid in the month of incurrence.
6. The company plans to buy a Plant at GH200,000, 50% of the cost to be paid in

March and the balance in May 2022.

vii The owner withdraws GH10,000 monthly for personal expenses

Viii The expected extracts from December 2021 figures are as follows:

1. Debtors GH350,000 out of which GH80,000 is part of November sales
2. Cash GH70,000

Required:

Prepare a monthly cash budget for the four months ending April, 2022.