Shin Company sells one product. Presented below is information for January for S

Question

Shin Company sells one product. Presented below is information
for January for Shin Company.

Jan. 1 Inventory 300 units at $10 each
4 Sale 240 units at $16 each
11 Purchase 450 units at $12 each
13 Sale 360 units at $17.50 each
20 Purchase 480 units at $14 each
27 Sale 300 units at $18 each

1. Assume Shin uses a periodic system and FIFO. Use the information above to determine the ending inventory and cost of goods sold as of January 31st.

2. Assume Shin uses a periodic system and LIFO. Use the information above to determine the ending inventory and cost of goods sold as of January 31st.

3. Assume Shin uses a perpetual system and the average cost assumption. Use the information above to determine the ending inventory and cost of goods sold as of January 31st.

4. Assume Shin uses a perpetual system and LIFO. Use the information above to determine the ending inventory and cost of goods sold as of January 31st.

5. If you were to recalculate question 1 using a perpetual system rather than the stated periodic system, indicate whether you feel that cost of goods sold for the period will be higher, lower, or the same as you calculated for question 1.

Explanation / Answer

1. Periodic FIFO Date Amount $ Amount left 1-Jan 300.00 $10.00 300@10 4-Jan -100.00 $16.00 200@10 5-Jan -140.00 $16.00 60@10 11-Jan 450.00 $12.00 60@10+450@12 13-Jan -360.00 $17.50 150@10 20-Jan 480.00 $14.00 150@10+480@14 27-Jan -300.00 $18.00 330@14 31-Jan Periodic Weighted average/unit = 300*10+450*12+480*14/1230=12.29 COGS=12.29*1230= $15,116.7 Ending Inventory=330*14= $4620.00 2) Periodic LIFO Date Amount $ Amount left 1-Jan 300.00 $10.00 300@10 4-Jan -100.00 $16.00 200@10 5-Jan -140.00 $16.00 60@10 11-Jan 450.00 $12.00 60@10+450@12 13-Jan -360.00 $17.50 60@10+90@12 20-Jan 480.00 $14.00 60@10+90@12+480@14 27-Jan -300.00 $18.00 60@10+90@12+180@14 Periodic Weighted average/unit = 300*10+450*12+480*14/1230=12.29 COGS=12.29*1230= $15,116.7 Ending Inventory = 60*10+90*12+80*14=$2800 3) Perpetual Average Cost Date Amount $ Amount left COGS 1-Jan 300.00 $10.00 300@10 0 4-Jan -100.00 $16.00 200@10 $1,000.00 5-Jan -140.00 $16.00 60@10 $1,400.00 11-Jan 450.00 $12.00 510@11.76 0 13-Jan -360.00 $17.50 150@11.76 $4,233.60 20-Jan 480.00 $14.00 640@13.47 27-Jan -300.00 $18.00 340@13.47 $4,041.00 COGS=1000+1400+4233.60+4041.00=$10674.60 Ending Inventory =340*13.47= $4579.80 5) COGS will be lower in the Perpetual system. Using FIFO and an increasing cost with time, the COGS uses low values used to calculate the average COGS during periodic.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.