Laker Company reported the following January purchases and sales data for its only product. The Company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific Identification, ending Inventory consists of 385 units from the January 30 purchase, 5 units from the January 20 purchase, and 25 units from beginning inventory. Date January 1 January 10 Activities Beginning inventory Sales January 20 Purchase January 25 January 30 Sales Purchase Totals Required: Units Acquired at Cost 235 units $ 16.00- Units sold at Retail $ 3,760 185 units @ $ 25.00 180 units $ 15.00 - 2,700 200 units $ 25.00 385 units 800 units $13.00= 5,005 $ 11,465 385 units 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. 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 Id Weighted Average FIFO LIFO Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. Specific Identification Available for Sale Cost of Goods Sold Ending Inventory Purchase Date Activity # of units Cost Per Unit # of units sold Cost Per Unit COGS Ending Inventory. Units Cost Per Unit Ending Inventory. Cost January 11 January 20 Beginning inventory Purchase 235 S 16.00 180 $ 15.00 25 S 5 S 16.00 S 15.00 400 75 January 30 Purchase 385 S 13.00 0 800 0 $ 0 30 $ 475 Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Goods Purchased Perpetual FIFO: Cost of Goods Sold Date Cost Cost # of units # of units per sold unit per unit Cost of Goods Sold Cost # of units per unit January 1 $ 235 at = 16.00 January 10 S 185 at 16.00 $2,960.00 50 50 > S at = Inventory Balance Inventory Balance 69 3,760.00 800.00 16.00 $ 180 at 15.00 January 201 Total January 20 S 50 at = 16.00 69 69 $ 180 at = 15.00 800.00 2,700.00 3,500.00 January 25 Total January 25 January 30 Totals S 385 at 13.00 S 50 at = $ 800.00 0 16.00 S 150 at = 2,250.00 30 15.00 $3,050.00 1 1 at $ 16.00 S at |= 15.00 0 1 $ at 16.00 $ 30 at 15.00 S 385 at = 13.00 $6,010.00 < Weighted Average LIFO > 69 69 69 450.00 450.00 450.00 5,005.00 $ 5,455.00 Complete this question by entering your answers in the tabs below. Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. (Round cost per unit to 2 decimal places.) Weighted Average - Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per # of units unit sold Cost per Cost of Goods # of units Cost per unit Inventory Balance unit Sold January 1 January 10 January 20 235 at $ 16.00 = $ 3,760.00 185 at $ 16.00 = $ 2,960.00 50 at $ 16.00 = $ 800.00 180 at $ 15.00 50 at $ 16.00 = $ 180 at $ 15.00 = 800.00 2,700.00 Average cost January 20 January 25 230 at $ 3,500.00 200 at 385 at $ 13.00 30 at 30 at January 30 Totals $ 2,960.00 385 at 415 at $ 13.00- 5,005.00 < Specific Id FIFO > Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Perpetual LIFO: Goods Purchased Cost of Goods Sold Date Cost Cost Cost # of units # of units per sold unit per unit Cost of Goods Sold # of units per Inventory Balance Inventory Balance unit S January 1 235 at = S 3,760.00 16.00 January 10 S S 185 at = 16.00 2,960.00 50 50 > S at = S 800.00 16.00 $ 180 at 15.00 January 20 Total January 20 January 25 Total January 25 January 30 Totals $ 385 at 13.00 S 50 at = S 800.00 16.00 180 at S 15.00 = 2,700.00 S 3,500.00 180 at S 15.00 |= S 2,700.00 30 at S 16.00 = S 60 480.00 S 20 at S = 16.00 320.00 0 at = 15.00 S S 480.00 3,020.00 S 30 at = S 480.00 16.00 S 0 at 15.00 S 385 at = 13.00 S 5,980.00 5,005.00 S 5,485.00 < FIFO LIFO >> Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific Identification, ending Inventory consists of 385 units from the January 30 purchase, 5 units from the January 20 purchase, and 25 units from beginning inventory. Date January 1 January 10 Activities Beginning inventory Sales January 20 Purchase January 25 January 30 Sales Purchase Totals Required: Units Acquired at Cost 235 units $ 16.00- Units sold at Retail $ 3,760 185 units @ $ 25.00 180 units $ 15.00 - 2,700 200 units $ 25.00 385 units 800 units $13.00= 5,005 $ 11,465 385 units 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. 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 Id Weighted Average FIFO LIFO Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. Specific Identification Available for Sale Cost of Goods Sold Ending Inventory Purchase Date Activity # of units Cost Per Unit # of units sold Cost Per Unit COGS Ending Inventory. Units Cost Per Unit Ending Inventory. Cost January 11 January 20 Beginning inventory Purchase 235 S 16.00 180 $ 15.00 25 S 5 S 16.00 S 15.00 400 75 January 30 Purchase 385 S 13.00 0 800 0 $ 0 30 $ 475 Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Goods Purchased Perpetual FIFO: Cost of Goods Sold Date Cost Cost # of units # of units per sold unit per unit Cost of Goods Sold Cost # of units per unit January 1 $ 235 at = 16.00 January 10 S 185 at 16.00 $2,960.00 50 50 > S at = Inventory Balance Inventory Balance 69 3,760.00 800.00 16.00 $ 180 at 15.00 January 201 Total January 20 S 50 at = 16.00 69 69 $ 180 at = 15.00 800.00 2,700.00 3,500.00 January 25 Total January 25 January 30 Totals S 385 at 13.00 S 50 at = $ 800.00 0 16.00 S 150 at = 2,250.00 30 15.00 $3,050.00 1 1 at $ 16.00 S at |= 15.00 0 1 $ at 16.00 $ 30 at 15.00 S 385 at = 13.00 $6,010.00 < Weighted Average LIFO > 69 69 69 450.00 450.00 450.00 5,005.00 $ 5,455.00 Complete this question by entering your answers in the tabs below. Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. (Round cost per unit to 2 decimal places.) Weighted Average - Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per # of units unit sold Cost per Cost of Goods # of units Cost per unit Inventory Balance unit Sold January 1 January 10 January 20 235 at $ 16.00 = $ 3,760.00 185 at $ 16.00 = $ 2,960.00 50 at $ 16.00 = $ 800.00 180 at $ 15.00 50 at $ 16.00 = $ 180 at $ 15.00 = 800.00 2,700.00 Average cost January 20 January 25 230 at $ 3,500.00 200 at 385 at $ 13.00 30 at 30 at January 30 Totals $ 2,960.00 385 at 415 at $ 13.00- 5,005.00 < Specific Id FIFO > Specific Id Weighted Average FIFO LIFO Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Perpetual LIFO: Goods Purchased Cost of Goods Sold Date Cost Cost Cost # of units # of units per sold unit per unit Cost of Goods Sold # of units per Inventory Balance Inventory Balance unit S January 1 235 at = S 3,760.00 16.00 January 10 S S 185 at = 16.00 2,960.00 50 50 > S at = S 800.00 16.00 $ 180 at 15.00 January 20 Total January 20 January 25 Total January 25 January 30 Totals $ 385 at 13.00 S 50 at = S 800.00 16.00 180 at S 15.00 = 2,700.00 S 3,500.00 180 at S 15.00 |= S 2,700.00 30 at S 16.00 = S 60 480.00 S 20 at S = 16.00 320.00 0 at = 15.00 S S 480.00 3,020.00 S 30 at = S 480.00 16.00 S 0 at 15.00 S 385 at = 13.00 S 5,980.00 5,005.00 S 5,485.00 < FIFO LIFO >>
Expert Answer:
Answer rating: 100% (QA)
To determine the cost assigned to ending inventory and cost of goods sold using specific identification we match the units sold with their respective purchase costs Lets complete the table Specific Id... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Compute the code that return the matrix M = AT A for a given matrix A- the superscrupt T denoted the transpose. I have started the code for you, which gets the dimension of the matrix, and creates...
-
Audrey has recently purchased a home with a $325,000 mortgage. She opted for monthly payments, a term of 5 years at a rate of 3.2%, and an amortization period of 25 years. Had Audrey chosen, instead,...
-
After each toss of the coin, one person has more money and one person has less. If the person with less money cares about relative rank and status, will he be willing to pay, say, $1 to reduce the...
-
Reverse the slope of the line in Exercise 12.51 by reordering the y observations, as follows: Repeat the steps of Exercise 12.51. Notice the change in the sign of r and the relationship between the...
-
A delicate instrument weighing \(200 \mathrm{~N}\) is suspended by four identical springs, each with stiffness \(50,000 \mathrm{~N} / \mathrm{m}\), in a rigid box as shown in Fig. 9.50. The box is...
-
Packer Concrete Company pours concrete slabs for single-family dwellings. Wolff Construction Company, which operates outside Packers normal sales territory, asks Packer to pour 40 slabs for Wolffs...
-
In what ways might social media be used to predict sales and manage inventory?
-
(b) Now also build a random forest model. Randomly shuffle the data and partition to use 80% for training and the remaining 20% for testing. Compare and report the test error for your classification...
-
. Write a Prolog program that takes a list as its first argument and returns the odd numbers and the sum of the odds as the second and third arguments respectively. For example: 7-sum odd...
-
Write a function: class Solution { public int solution (int[] A, int K, int L); } that, given an array A consisting of N integers denoting the number of apples on each apple tree in the row, and...
-
Data analytics have big attention from our industry in the current days. As a recent graduate, you would like to adventure in the creation of a new company in this area. To set up the company you...
-
Design a simple digital band-stop ('notch') filter with the following characteristics: (i) sampling rate 600 Hz, (ii) rejection of signal components in the range of (60 4) Hz, (iii) approximately...
-
Consider the users of Facebook with links representing friendships between users. (a) Design a data structure (ADT) to represent the users and friendships. (b) Write a C++ class to implement your...
-
A 1577 kg car is travelling down the road at 88.2 km/h. While travelling at this rate of speed, what is the kinetic energy of this vehicle in kilojoules?
-
In Exercises, find the equation of the tangent line at the given point on each curve. 2y 2 - x = 4; (16, 2)
-
An orthotropic AS/3501 carbon/epoxy lamina (see Tables 2.2 and 4.1) is subjected to the plane stress condition \(\sigma_{x}=1000 \mathrm{MPa}, \sigma_{y}=50 \mathrm{MPa}\), and \(\tau_{x y}=50...
-
Determine the longitudinal tensile strength of the hybrid carbon/aramid/ epoxy composite described in Problem 3.4 and Figure 3.10 of Chapter 3 if the fiber packing array is square with the closest...
-
Compare and discuss the estimated longitudinal compressive strengths of Scotchply 1002 E-glass/epoxy based on (a) fiber microbuckling and (b) transverse tensile rupture. Assume linear elastic...
Study smarter with the SolutionInn App