Friday Pharmacy Company produces three main products which share joint costs from a joint process, Altor, Loral, and Hycor. A hazardous waste product called Dorzinox is also produced from the process. Data regarding those products is included in the spreadsheet called Friday posted on D2L.

The president of Friday, Susan Franklin, is considering new opportunities that would change the way the products are processed and sold. Proposed changes are described below.

ALTOR: Altor is presently sold at the splitoff point to a manufacturer of face cream. Altor can also be refined for use to treat dandruff. However, there would be extra processing which would cause a loss of 20,000 units of Altor. The separable costs to further process Altor will be $250,000 each year. The final product would sell for $5.50 per unit.

LORAL: Currently Loral is processed further after the split-off point and sold by Friday as a vitamin. Friday has an offer from another company to purchase Loral at the split-off point for $2.25 per unit.

HYCOR: Hycor is produced from the joint process and is currently sold at the split-off point to a makeup company. Fridays R&D people have suggested that they refine this product further and sell it as muscle relaxing gel. This extra refining would cost $75,000 annually and would result in 25 percent more units of product (due to adding water). The muscle gel sell for for $1.80 per unit.

DORZINOX: The joint process also produces 50,000 units of Dorzinox, a hazardous chemical waste product. The company must pay $0.035 per unit to dispose of the Dorzinox properly. This cost of disposal is treated as an operating expense, and is not included in the joint processing cost. ABC Chemicals is interested in purchasing the Dorzinox for use as a paint remover. In order to do this, Friday would have to refine the Dorzinox at a cost of $43,000. ABC Chemicals would purchase all the refined Dorzinox produced by Friday and is willing to pay $0.75 for each unit.

Required:

1. Using Friday Pharmacys current processes to sell their products calculate the allocation of joint costs using the Constant Gross Margin NRV Method. Prepare an Excel spreadsheet calculating the amount of joint costs allocated to each product. Make sure to use EXCEL capabilities.

2. Prepare a Word memo for Susan Franklin to advise her on which, if any, of the opportunities Friday should pursue. Include an Excel spreadsheet with calculations. Make sure to use EXCEL capabilities. Numbers included in the information above can be added to the Data sheet. When I click on Show Formulas, every cell should be a formula with no hard coded numbers (loss of 5 points).

3. In addition to the analysis you prepare above, Franklin also questions whether the method chosen to allocate the joint costs will affect your analysis of whether to process each chemical further or not.

She also is curious as to whether the refining of the Dorzinox into a Byproduct, rather than disposing of it, will have any effect as to how the joint costs should be allocated. Please provide an explanation to Franklin about these questions.

Friday Pharmacy Company
Current Production Information
	Altor	Loral	Hycor	Dorzinox
Units produced	170,000	500,000	330,000	50,000
Sales value per unit at split-off	$ 3.50	$ -	$ 2.00
Joint cost					1,800,000
Separable costs	$ -	$ 1,400,000	$ -
Final sales value per unit	$ -	$ 5.00	$ -
Cost of disposal per unit				$ 0.035
Dorzinox is a hazardous waste product from this process.