P8-6 Various inventory costing methods; gross profit ratio EXEL TEMPLATE

P8-6 Various inventory costing methods; gross profit ratio EXEL TEMPLATE

P8-6 Topanga Group began operations early in 2011. Inventory purchase information for the quarter ended March 31, 2011, for Topanga's only product is provided below. The unit costs include the cost of freight. The company uses a periodic inventory system.

 

Sales for the quarter, all at $7.00 per unit, totaled 20,000 units leaving 14,000 units on hand at the end of the quarter.

Required:

1.Calculate the Topanga's gross profit ratio for the first quarter using:

a. FIFO

b. LIFO
c. Average cost

2.Comment on the relative effect of each of the three inventory methods on the gross profit ratio.

 

File name: P8-6-Topanga-Group.xls File type: application/vnd.ms-excel Price: $8