please show workings

408 4.06 One product produced by Warren Ltd is the Sigma 4 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 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 Production and Finished Goods Inventory 427 428 429 June 430 Month Sales (units) Opening stock osing stock Production (units) 50.000 25,000 27.500 52,500 81 432 433 Material Usage June Month Material Usage (kg) Material Usage Material Purchases June 4331 434 135 436 137 138 439 440 141 442 143 444 445 446 147 148 149 450 451 452 453 454 455 456 457 458 Month Material Usage (kg) Opening stock of material Closing stock of material Material Purchases (kg) Material Purchases Labour Budget June Month Hours required Overtime Basic hours cost Overtime cost Labour cost f E F G Variable Overheads Month Variable Overheads June 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 Non-production overheads Net profit 18 marks