complete the task 2 in the problem attached below.

S.K.chemical company gives you the following standard and Actual data of its Chemical Product. STANDA ACTU RD AL INPUT MATERIAL ()/Ltr TOTA INPU MATERIAL TOTAL T 400 A @ 50 20,000 420 A @ 45 18,900 200 B @20 4,000 240 B @ 25 6,000 100 C @15 1,500 90 C @15 1,350 700 25,500 750 26,250 LABOUR HOURS LABOUR HOURS 100 @ *2 per hour 200 120 @ *2.50 per hour 300 200 woman @ * 1.50 300 500 240 woman @ * 1.60 384 684 25 normal Loss 75 Actual Loss 675 26000 675 26,934 A newly started Plastic components manufacturing company wishes to prepare cash budget. Prepare a cash budget for the first six months from the following estimated revenue and expenses Month Total Purchases(Rs.) Wages Production Selling & Dist. Sales(Rs. Overheads Overheads January 20000 20000 4000 3200 800 February 22000 14000 4400 3300 900 March 28000 14000 4600 3400 900 April 36000 22000 4600 3500 1000 May 30000 20000 4000 3200 900 June 40000 25000 5000 3600 1200 Cash balance as on 1" Jan. was Rs. 10000. A new machinery is to be installed at Rs. 20000 on credit , to be repaid by two equal installments in March & April. Sales commission @ 5% on total sales is to be paid within a month following actual sales. Rs. 10000 being the amount of 2" call may be received in March. Share premium amounting to Rs.2000 is also obtainable with 2"d call. Period of credit allowed by suppliers - 2 months Period of credit allowed by customers - 1 month Delay in payment of wages 1/2 month & overheads 1 month Assume cash sales to 50% of total sales Task2. You are required to help the management in Forecasting the cash flow for 6 months Jan - June (A.C.2.1)