Please show work and formulas used in excel

Satin Elle Inc. produces three varieties of satin, Grade 1, Grade 2, & Grade 3 from a joint processing of the raw satin. The amount of each product produced in the first quarter of the current year is 80,000 pounds, 50,000 pounds, and 120,000 pounds respectively. The selling price of each product per pound is $5, $7 & S8 respectively. The joint processing cost is $400,000. The separable processing costs for each product is $30,000, $50,000 and $90,000 respectively. Determine the following: 1. Joint cost allocated to each product (Grade 1, Grade 2, & Grade 3) using the physical volume method, relative sales value method, and net realizable value method. 2. The unit cost of each product (Grade 1, Grade 2, & Grade 3) using the net realizable value method