T.L. Wang Inc. manufactures and sells four products, the inventories of which are priced at cost or

market, whichever is lower. A normal profit margin rate of 30% is usually maintained on each of the

four products.

The following information was compiled as of December 31, 2012.

Product	Original Cost	Cost to Replace	Estimated cost to dispose	Expected Selling price*
A	17.50	14.00	6.00	30.00
B	48.00	78.00	26.00	100.00
C	35.00	42.00	15.00	80.00
D	47.50	45.00	20.50	95.00

*Normal profit margin is 30% of selling price

1) Use a computer spreadsheet to prepare a schedule containing unit values (including