please show workings

4.06 One product produced by Warren Ltd is the Sigma 4 Each unit of finished goods costs 6.55 and is sold for 9 One unit of Sigma 4 is made from 0.5kg of material Each kg cost 3 Stock of material at the beginning of June is 10,000 kg This should be increased by 2,000 kg each month One unit of Sigma 4 takes 15 minutes to manufacture 80 employees work in production, each has basic hours of 160 in June Each employee is paid 12 per hour worked with a 50% premium for overtime Variable overheads cost 4 for each labour hour worked Fixed production overheads are 55,000 per month Non-production overheads are 75,000 per month Required: Complete the following schedules for the June budget N1510 Intermediate ma B C D E Production and Finished Goods Inventory Month Sales (units) Opening stock Closing stock Production (unts) June 50.000 25 000 27 500 52 500 Material Usage June Month Material Usage (kg) Material Usage Material Purchases June Month Material Usage (kg) Opening stock of material Closing stock of material Material Purchases (ko) Material Purchases c Labour Budget June Month Hours required Overtime Basic hours cost Overtime cost Labour cost & 3 4 5 6 Variable Overheads June 28 9 30 Month Variable Overheads f Operating Budget for June Sales Opening stock of finished goods Raw materials Direct Labour Variable Production Overheads Fixed Production Overheads Closing stock of finished Goods Cost of goods sold Gross profit DINN Non-production overheads Net profit