must be calculated in excel Microsoft and screenshot or paste In here 
Omega Lid is a manufacturer of vanous types of electric units Recently one of its large customers, Mars Ltd has offered a contract to Omega Lid for the supply of 770 units. Below are the details for the production of each unit: Material X: 3kg is required per unit Currently 2,300 kg is held by the business and it is constantly used. This material or was originally bought for C65 per kg. It would cost 087 per kg to replace it Sales value is 54 per kg. Material Y: 6 kg is required per unit. Currently 3.400 kg is held by the business. This material of was originally bought for 41 per kg The material was not used by the business for last two years. Its scrap value is only 16 per kg. Replacement cost for material Y is 20 per kg. The only foreseeable alternative use is as a substitute for material K (in constant use) but this would involve further processing cost of 5 per kg. The current buying cost of material Kis (19 per kg. Material Z: 2kg is required per unit it is regularly used by the business and currently there is none available in the business. An order for 700 kg is shortly to be placed for another project by the business. The price for this material is 80 per kg, but the supplier allows a bulk discount of 10%, for the entire order, for orders of 2,000 kg and above. Skilled labour: Each unit requires 4 hours of skilled labour. It is currently paid at a rale of E27 per hr and skilled labour is hired on a permanent basis 930 hours can be provided by members of staff who currently have no work to do due to a quiet time, but still employed by the company Only taking staff off other work can provide the remaining hours needed for this new project. This other work is charged out to customers at .75 an hour and material cost is 15 per hour. Semi-skilled labour: Each unit requires 2 hours of semi-skilled labour. It is currently paid 11 per hour. If the required somi-skilled labour for this project is provided by the existing members of staff who are busy the business will have to hire new employees at a rate of f14 per hour Specialised study. To derive the above estimates, the business had to spend 5.200 on a specialised study. If the contract does not proceed, the results of the study can be sold for 13.100 in the market. Overheads: It is Omega's policy to charge a share of the general costs (rent, heating and so on) to each contract undertaken at the rate of 15 for each skilled labour hour used on the contract. If this project is undertaken the general costs are expected to increase As a result of undertaking the contract by 3,100. Required Calculate the minimum price at which the contract could be undertaken by Omega Ltd. For each part, you should clearly show supporting workings and provide a brief explanation for your choice. (Total: 8 marks)
