Open Question (25 points)

The company plans its budget for 2023. For this purpose, the following data was collected: a. Sales Forecast for the first quarter of 2023:

Mandatory Credit NIS 65,000 1,845,000 800,000

240,000 150,000

Cash and cash equivalents) 1 (inventory )2 (suppliers) 3 (employees and other entitlements) 4 (Notes:

NIS 1,200,000 1,275,000 1,840,000

January February March

B. Company Credit Terms: Customer Credit

20% of sales each month are charged in cash. 40% are charged in the following month, 28% are charged two months after the month of sale, and an additional 12% are charged three months after the month of sale. Suppliers credit: 50% of the purchase amount is paid in cash and 50% in the following month.

C. The percentage of gross profit from the company's sales is 40% d. Depreciation expenses per month are NIS 50,000. The following is an extract of data from the "Do and Succeed" company's tester balance sheet for 31.12.2020

1 (of this balance, 960,000 NIS for it in January 2023, 675,000 NIS for it in February 2023, and 210,000 NIS for it in March 2023.

2 (Closing inventory at end of each month is: January 1,275,000 February 1,380,000

3) The balance is due for payment in January 2023. 4 (This is a monthly expense) each month( paid in the following month.

Plans to pay a dividend of NIS 120,000 to its shareholders in January 2023.

1

And. The Company

Required:

A. What was the amount of shopping in January 2023? 5 points (b. Calculate the expected receipts and payments in January 2023, and find the balance

Cash expected at end of January 2023 (10 points)

C. What is the expected customer balance for the end of March 2023) 5 points(

D. What is the company's expected operating profit in the first quarter of 2023? ) 5 points