60.1K

Verified Solution

Link Copied!

Periodic inventory by three methodsThe units of an item available for sale during the year were as follows:

Jan. $1$ Inventory $2,000$ units at $$4$

Feb. $17$ Purchase $3,800$ units at $$5$

Jul. $21$ Purchase $3,100$ units at $$6$

Nov. $23$ Purchase $1,100$ units at $$7$

There are $1,700$ units of the item in the physical inventory at December $31.$ The

periodic inventory system is used. This information has been collected in the Microsoft

Excel Online file. Open the spreadsheet, perform the required analysis, and input your

answers in the questions below.

Open spreadsheet

a$.$ Determine the inventory cost by the first$-$in$,$ first$-$out method.

$

b$.$ Determine the inventory cost by the last$-$in$,$ first$-$out method.

$

c$.$ Determine the inventory cost by the weighted average cost method. Round your

answer to the nearest dollar.The units of an item available for sale during the year were as follows:

Jan. $1$ Inventory $2,000$ units at $$4$

Feb. $17$ Purchase $3,800$ units at $$5$

Jul. $21$ Purchase $3,100$ units at $$6$

Nov. $23$ Purchase $1,100$ units at $$7$

There are $1,700$ units of the item in the physical inventory at December $31.$ The

periodic inventory system is used. This information has been collected in the Microsoft

Excel Online file. Open the spreadsheet, perform the required analysis, and input your

answers in the questions below.

Open spreadsheet

a$.$ Determine the inventory cost by the first$-$in$,$ first$-$out method.

$

b$.$ Determine the inventory cost by the last$-$in$,$ first$-$out method.

$

c$.$ Determine the inventory cost by the weighted average cost method. Round your

answer to the nearest dollar.

The units of an item available for sale during the year were as follows:

Date Line Item Description Value

Jan. $1$ Inventory $2,000$ units at $$4$

Feb. $17$ Purchase $3,800$ units at $$5$

Jul. $21$ Purchase $3,100$ units at $$6$

Nov. $23$ Purchase $1,100$ units at $$7$

There are $1,700$ units of the item in the physical inventory at December $31.$ The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ Determine the inventory cost by the first$-$in$,$ first$-$out method.

fill in the blank $1$ of $1$$

b$.$ Determine the inventory cost by the last$-$in$,$ first$-$out method.

fill in the blank $1$ of $1$$

c$.$ Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar.

Answer & Explanation Solved by verified expert

See Answer