I need help with following spreadsheets. January $20$

January $25$

January $30$

Purchase

Sales

Purchase

Totals

@ $$15\mathrm{.}00=$

$$25\mathrm{.}50$

Assume the perpetual inventory system is used.

Required:

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.

Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.

Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.

Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.

Complete this question by entering your answers in the tabs below.

Specific

Identification

Weighted

Average

FIFO

LIFO

Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Assume the perpetual Inventory system is used.

Required: $$

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identificati

Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.

Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.

Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.

Complete this question by entering your answers in the tabs below.

Specific

Weighted

Identification

Average

FIFO

LIFO

Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.