Effect of changes in sales price or costs

Question

Note - spreadsheet is attached and just needs to be filled in and answers completed from below:

Q1. What alternative to sell or process further are available to Mission?

Q2. Compute the product costs for each main product in total and per unit for each alternative presented in requirement (1).

Q3. Build your own spreadsheet to solve requirement (2).

Q4. How can your spreadsheet be used to demonstrate the effect of changes in sales price or costs on Mission's decision to sell Product Y at split off or process it further?

Product	X	Y	Z	Total
Quantity, liters	1,000,000	500,000	100,000
Sales price at splitoff	$                  0.09	$                  0.05
No further processing	-	-
Further processing		$              20,000	$                1,500
Sales price after further processing		$                  0.10	$                  0.02
Joint processing cost				$            160,000
Alternative 1:
Sell X & Y at splitoff and Z after further processing	X	Y	Z	Total
Sales value
Further processing cost
NRV
Joint cost allocations	X	Y	Z	Total
Quantities
% Quantity
Joint cost allocation
Further processing
Total cost
Cost/unit
Alternative 2:
Sell X at splitoff and Y & Z after further processing	X	Y	Z	Total
Sales value
Further processing
NRV
Joint cost allocations	X	Y	Z	Total
Quantities
% Quantity
Joint cost allocation
Further processing
Total cost
Cost/unit