Reference no: EM131075863

Monahan Media

Which units are sold? Which units remain?

Nick's merchandise sales take off in the month of May. Unfortunately, he didn't know how to record the activity.  Nick allowed some customers a discount, but isn't sure whether or not it's a good idea to continue.

Sales Date	Customer	Item	Quantity	Unit Price	Discount	Collection Date
15-May	ABC Deli	Key Chains	175	$3.00	3/10, n30	30-May
17-May	Vienna Sausage Co	Mugs	550	$5.00	2/10, n30	25-May
19-May	Tree-trimmers	Bags	350	$6.00	1/15, n30	31-May
25-May	KLEEN House Cleaning	Water Bottles	105	$2.50	None	17-June

When you visit Nick's home office, you discover several disorganized boxes of merchandise. When you sit down to count the merchandise, you find:

325 key chains; 50 mugs; 248 bags;495water bottles

Nick is unsure about the profitability of this aspect of the business. You agree, a better idea of the results of his merchandising activities is needed. You agree to help with the following:

1. Record each of the sales transactions: date of sale and date cash is received.  Follow the perpetual inventory method using the FIFO method for computing Cost of Goods Sold.

2. Record each of the sales transactions: date of sale and date cash is received.  Follow the perpetual inventory method using the LIFO method for computing Cost of Goods Sold.

3. Determine the value of the ending merchandise inventory.  Use the cost information you calculated when the purchase transactions were recorded. And, since you are trying to provide a complete picture of the results, report the Ending Inventory values for each product under the FIFO and LIFO methods.

4. Provide a summary of the findings, including a comparison of the differences between the FIFO and LIFO outcomes by product.  If Nick's goal is minimize the company's tax liability, which method do you recommend?

5. How should missing inventory be handled?  What might account for the shortage of units?  Provide Nick some recommendations to avoid future inventory losses.