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 assemble 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.

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.