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 40000 Mar 45000 fool 40000 2500 900 700 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 35000 2000 900 700 1000 2250 Abr 43000 3000 30000 2100 900 700 1000 2300 500 200 May 50000 70001 34000 10000 900 700 1000 2850 500 2001 Jun 70000 8 000 45000 5600 900 700 1000 3900 500 2001 450 100 45000 7000 37000 5000 900 700 1000 2600 500 200 450 100 1000 2550 500 450 450 100 100 450 100 1000 Operating income 1900 2100 7750 6300 19650 3550 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. www.euruni.edu Commissions for sales agent, 5%, are paid after receiving full amount from the customers, (direct customers and the distributors). Data in red is given information coming from previous year. Fill in the gaps. Feb May Mar 101.760 40.000 Abr 132.760 Jun 138.910 Jan Starting cash Direct customers Cash from sales delivery Distrib Cash from sales 2nd payment utors ** Cash from sales 3rd payment Total cash in 100.000 9.000 2.500 43.000 3.500 750 70.000 3.500 4.000 1.750 2110 payment 500 450 500 1.500 1.500 1.250 49.250 1.750 77.250 12.450 34.000 6.000 2.000 3.100 35.000 2.500 10.000 Payment local suppliers Payment import suppliers Personnel cost Interest Taxes Commisions Total cash out 5.000 1.500 3.100 450 2.100 3.100 450 5.600 3.100 450 450 100 3.850 10.690 43.650 46.300 Total cash month Total cash accumulated 1.760 101.760 40 points)