Write 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 create 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 create and use formulas and cell references.

Edit: There is no question stem. The assignment is to make up a question and show how to answer it by Allocating joint costs using the net realizable value method.