Please help.

Required:

Using Excel, answer the question attached. Use one tab per question and also include any written response within Excel.

Note that marks are also allocated for professional presentation and the use of formulas within Excel

Required: Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel. Note that marks are also allocated for professional presentation and the use of formulas within Excel QUESTION 1 (15 marks) Jumbo Giant Limited manufactures three products, namely, Milk, Yoghurt and Ice-cream. The initial joint cost of production is $600,000 for the year. This cost results in an output of 2,000,000 litres. Details relating to the 3 joint products are given below: Milk Yoghurt Icecream Quantity at split-off point 1,000,000 liters 400,000 liters 600,000 liters Selling price at split-off point $ 1.00 per litre $ 2.00 per litre $ 3.00 per litre Separable cost $ 0.50 per litre $ 1.25 per litre $ 1.50 per litre Sales price of ultimate product $ 5.50 per litre $ 4.00 per litre $ 9.00 per litre REQUIRED: 1. Allocate the joint cost between Milk, Yoghurt and Ice Cream using: a) The Physical Units Method. (3 Marks)b) The Relative Sales Value Method. Round percentage to 2 decimal places. (3 Marks) c) Net Realisable Value Method. Round percentage to 2 decimal places. (3 Marks) 2. Jumbo Giant Limited has a request from a prospective customer to further process all its Ice Cream production into Gourmet Ice Cream which will then be bought by the customer for $12.00 per litre. This will increase the separable costs of ice cream per litre to $2.60. Would you advise the company to accept the offer? Why or why not? (6 Marks)