Give short explanaition how it was calculated

You should explain the approach followed for each line of numbers and give results directly on the table. 1.- You have the following monthly budget from a company: Jan Feb 10000 2000 8000 1400 1000 500 500 6001 500 100 500 Direct sales Sales to distributors Purchases to local suppliers Purchases from imports Direct personnel costs Indirect personnel costs Sales department Sales agent Administration Depreciation Interest Taxes Mar 1 1400 2000 9120 1400 1000 500 500 670 Abr 18000 3000 14400 2100 1000 500 5001 0501 May 20000 40001 16000 2800 1000 500 500 1200 500 103 500 Jun 30000 5000 24000 3500 1000 500 500 1750 500 104 500 45000 7000 36000 4900 1000 500 500 500 101 102 500 500 225 500 225 Operating income -1100 -891 123 897 2646 5170 Please prepare a cash forecast considering the following: Direct sales paid 30 days Sales to distributors 50% cash, 25% after 30 days, 25% after 60 days. Local suppliers paid 60 days, import suppliers paid 30 days. Personnel cost (Direct personnel cost + Indirect personnel cost +Sales department + Administration) and taxes, are paid at the end of the month. (Direct customers and distributors). Issions from sales agent (5%) are paid after receiving full amount from the customers Data in red is coming from previous year operations. Fill in the gaps. Jan Feb Mar Abr May Jun Starting cash 200.000 200.910 201.910 208.545 Direct customers 9.000 10.000 18.000 Cash from sales delivery 1.000 1.500 2.000 2.500 Distrib Cash from sales 2nd payment 500 500 750 1.000 utors Cash from sales 3rd payment 450 500 Total cash in 10.950 13.900 30.000 3.500 1.000 35.750 1 6.000 1.400 2.500 8.000 1.400 16.000 3.500 2.100 2.800 5.000 1.500 2.500 500 2.500 Payment local suppliers Payment import suppliers Personnel cost Interest Taxes Commisions Total cash out 2.500 500 500 500 225 225 1.700 10.040 13.295 21.350 910 Total cash month Total cash accumulated 200.910