please do this in excel sheet

Mallett plc has the following income and expense statement based on absorption costing principles: Product: R S T Total 000s 000s 000s 000s 820 660 450 1,930 250 230 Revenues Less: Direct Materials Direct Wages Production overheads (fixed) Gross Margin Selling & admin overheads: Variable Fixed Net Profit 320 190 90 220 150 180 90 30 720 600 230 380 50 130 50 100 40 40 30 40 (40) 120 180 80 70 50 From the above information, the Managing Director has suggested that the company discontinues product T. This does mean there will be spare capacity in the factory but the MD suggests there is no point in using resources to make a product which is making a loss. However the company has been approached by a local school which is interested in Mallett producing a special "one-off' order for them, but would like the price to be kept as low as possible. The company could undertake the order if it stopped producing product T. The new order would need the existing direct labour used for product T and would also use 60,000 of direc materials. The order could be produced on the existing machines in the factory, apart from one special machine that would need to be hired costing 20,000. There would be no selling costs incurred. Required: Re-draft the above information to provide a more useful statement and consider the various options available to Mallett ple. You should include a calculation of the minimum price at which the new order could be sold to the local school