Compose a problem with solution in Excel - Allocate joint costs using the net realizable value method

Develop a sample problem and solution in Excel to demonstrate the application of the learning objective (Allocate joint costs using the net realizable value method.) to classmates. Be sure and make your own, original Excel document. The problem should contain the following elements: Problem-solving application of the topic Relevance to the learning objective(s) Clear and thorough explanation of the topic Demonstrated knowledge of the topic including the ability to respond to questions Proficiency in your use of Excel as evidenced by your ability to write and use formulas and cell references.