Q 26E-3 - Horngren'S Financial And Managerial Accounting

Question

Assume that Jump Coffee Shop completed the following periodic inventory transactions for a line of merchandise inventory:

Jun. 1 Beginning merchandise inventory                  17 units @ \( 15 each

      12 Purchase                                                              5 units @ \) 19 each

      20 Sale                                                                     14 units @ \( 37 each

      24 Purchase                                                            11 units @ \) 23 each

      29 Sale                                                                     13 units @ $ 37 each

 

Requirements

3. Compute ending merchandise inventory, cost of goods sold, and gross profit using the weighted-average inventory costing method. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.)

Step-by-Step Solution

Answer

Ending Inventory: $108

Cost of goods sold: $495

Gross Profit: $504

Step-by-Step-Solution Step 1: Computation of ending merchandise using LIFO

Using LIFO, the ending inventory would be valued at historical prices.

$$\begin{gathered} \mathit{E}\mathit{n}\mathit{d}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathbf{\left(}\mathit{U}\mathit{n}\mathit{i}\mathit{t}\mathit{s}\mathbf{\right)}\mathbf{=}\mathit{B}\mathit{e}\mathit{g}\mathit{i}\mathit{n}\mathit{n}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathbf{\left(}\mathit{u}\mathit{n}\mathit{i}\mathit{t}\mathit{s}\mathbf{\right)}\mathbf{+}\mathit{T}\mathit{o}\mathit{t}\mathit{a}\mathit{l}\mathit{P}\mathit{u}\mathit{r}\mathit{c}\mathit{h}\mathit{a}\mathit{s}\mathit{e}\mathit{s}\mathbf{\left(}\mathit{U}\mathit{n}\mathit{i}\mathit{t}\mathit{s}\mathbf{\right)}\mathbf{-}\mathit{T}\mathit{o}\mathit{t}\mathit{a}\mathit{l}\mathit{S}\mathit{a}\mathit{l}\mathit{e}\mathit{s}\mathbf{\left(}\mathit{u}\mathit{n}\mathit{i}\mathit{t}\mathit{s}\mathbf{\right)} \\ \mathbf{=}\mathbf{17}\mathbf{+}\left(5+11\right)\mathbf{-}\left(14+13\right) \\ \mathbf{=}\mathbf{17}\mathbf{+}\mathbf{16}\mathbf{-}\mathbf{27} \\ \mathbf{=}\mathbf{6} \end{gathered}$$

$$\begin{gathered} \mathit{A}\mathit{v}\mathit{e}\mathit{r}\mathit{a}\mathit{g}\mathit{e}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathit{C}\mathit{o}\mathit{s}\mathit{t}\mathbf{=}\frac{\mathbf{B}\mathbf{e}\mathbf{g}\mathbf{i}\mathbf{n}\mathbf{n}\mathbf{i}\mathbf{n}\mathbf{g}\mathbf{I}\mathbf{n}\mathbf{v}\mathbf{e}\mathbf{n}\mathbf{t}\mathbf{o}\mathbf{r}\mathbf{y}\mathbf{+}\mathbf{T}\mathbf{o}\mathbf{t}\mathbf{a}\mathbf{l}\mathbf{P}\mathbf{u}\mathbf{r}\mathbf{c}\mathbf{h}\mathbf{a}\mathbf{s}\mathbf{e}}{\mathbf{T}\mathbf{o}\mathbf{t}\mathbf{a}\mathbf{l}\mathbf{I}\mathbf{n}\mathbf{v}\mathbf{e}\mathbf{n}\mathbf{t}\mathbf{o}\mathbf{r}\mathbf{y}} \\ \mathbf{=}\frac{\mathbf{17}\mathbf{\times }\mathbf{\$}\mathbf{15}\mathbf{+}\left(5\times \$19+11\times \$23\right)}{\mathbf{17}\mathbf{+}\mathbf{5}\mathbf{+}\mathbf{11}} \\ \mathbf{=}\frac{\mathbf{\$}\mathbf{255}\mathbf{+}\mathbf{\$}\mathbf{348}}{\mathbf{33}} \\ \mathbf{=}\mathbf{\$}\mathbf{18} \end{gathered}$$

$$\begin{gathered} \mathit{E}\mathit{n}\mathit{d}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathbf{\left(}\mathit{V}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathbf{\right)}\mathbf{=}\mathit{E}\mathit{n}\mathit{d}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathbf{\left(}\mathit{u}\mathit{n}\mathit{i}\mathit{t}\mathit{s}\mathbf{\right)}\mathbf{\times }\mathit{A}\mathit{v}\mathit{e}\mathit{r}\mathit{a}\mathit{g}\mathit{e}\mathit{C}\mathit{o}\mathit{s}\mathit{t} \\ \mathbf{=}\mathbf{6}\mathbf{\times }\mathbf{\$}\mathbf{18} \\ \mathbf{=}\mathbf{\$}\mathbf{108} \end{gathered}$$

Step 2: Computation of cost of goods sold

$$\begin{gathered} \mathit{C}\mathit{o}\mathit{s}\mathit{t}\mathit{o}\mathit{f}\mathit{g}\mathit{o}\mathit{o}\mathit{d}\mathit{s}\mathit{s}\mathit{o}\mathit{l}\mathit{d}\mathbf{=}\mathit{B}\mathit{e}\mathit{g}\mathit{i}\mathit{n}\mathit{n}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathit{V}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathbf{+}\mathit{T}\mathit{o}\mathit{t}\mathit{a}\mathit{l}\mathit{P}\mathit{u}\mathit{r}\mathit{c}\mathit{h}\mathit{a}\mathit{s}\mathit{e}\mathit{V}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathbf{-}\mathit{E}\mathit{n}\mathit{d}\mathit{i}\mathit{n}\mathit{g}\mathit{I}\mathit{n}\mathit{v}\mathit{e}\mathit{n}\mathit{t}\mathit{o}\mathit{r}\mathit{y}\mathit{V}\mathit{a}\mathit{l}\mathit{u}\mathit{e} \\ \mathbf{=}\mathbf{17}\mathbf{\times }\mathbf{\$}\mathbf{15}\mathbf{+}\left(5\times \$19+11\times \$23\right)\mathbf{-}\mathbf{\$}\mathbf{108} \\ \mathbf{=}\mathbf{\$}\mathbf{255}\mathbf{+}\mathbf{\$}\mathbf{348}\mathbf{-}\mathbf{\$}\mathbf{108} \\ \mathbf{=}\mathbf{\$}\mathbf{495} \end{gathered}$$

Step 3: Computation of gross profit

$$\begin{gathered} \mathit{N}\mathit{e}\mathit{t}\mathit{S}\mathit{a}\mathit{l}\mathit{e}\mathit{s}\mathit{R}\mathit{e}\mathit{v}\mathit{e}\mathit{n}\mathit{u}\mathit{e}\mathbf{=}\mathit{S}\mathit{a}\mathit{l}\mathit{e}\mathit{v}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathit{o}\mathit{f}\mathbf{20}\mathit{t}\mathit{h}\mathit{J}\mathit{u}\mathit{n}\mathit{e}\mathbf{+}\mathit{S}\mathit{a}\mathit{l}\mathit{e}\mathit{v}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathit{n}\mathit{o}\mathit{f}\mathbf{29}\mathit{t}\mathit{h}\mathit{J}\mathit{u}\mathit{n}\mathit{e} \\ \mathbf{=}\mathbf{14}\mathbf{\times }\mathbf{\$}\mathbf{37}\mathbf{+}\mathbf{13}\mathbf{\times }\mathbf{\$}\mathbf{37} \\ \mathbf{=}\mathbf{\$}\mathbf{518}\mathbf{+}\mathbf{\$}\mathbf{481} \\ \mathbf{=}\mathbf{\$}\mathbf{999} \end{gathered}$$

$$\begin{gathered} \mathit{G}\mathit{r}\mathit{o}\mathit{s}\mathit{s}\mathit{P}\mathit{r}\mathit{o}\mathit{f}\mathit{i}\mathit{t}\mathbf{=}\mathit{T}\mathit{o}\mathit{t}\mathit{a}\mathit{l}\mathit{S}\mathit{a}\mathit{l}\mathit{e}\mathit{v}\mathit{a}\mathit{l}\mathit{u}\mathit{e}\mathbf{-}\mathit{C}\mathit{o}\mathit{s}\mathit{t}\mathit{o}\mathit{f}\mathit{g}\mathit{o}\mathit{o}\mathit{d}\mathit{s}\mathit{s}\mathit{o}\mathit{l}\mathit{d} \\ \mathbf{=}\mathbf{\$}\mathbf{999}\mathbf{-}\mathbf{\$}\mathbf{495} \\ \mathbf{=}\mathbf{\$}\mathbf{504} \end{gathered}$$