1 | Cost of Goods Sold | Ending Inventory | ||||||||
a. | Specific Identification | $2,735 | $1,855 | |||||||
b. | Average cost | $2,720 | $1,870 | |||||||
c. | FIFO | $2,665 | $1,925 | |||||||
d. | LIFO | $2,773 | $1,817 | |||||||
2 | Highest COGS | Specific Identification | ||||||||
Lowest COGS | FIFO | |||||||||
Because of ending inventory valuation is different in a different method | ||||||||||
Working | ||||||||||
Specific Identification | ||||||||||
Available for Sale | Cost of Goods Sold | Ending Inventory | ||||||||
Date | Activity | Units | Unit Cost | Units Sold | Unit Cost | COGS | Ending Inventory Units | Unit Cost | Ending Inventory Costs | |
Dec 1 | Beginning Inventory | 9 | $165 | 2 | $165 | $330 | 7 | $165 | $1,155 | |
Dec 15 | Purchase | 5 | $166 | 5 | $166 | $830 | - | $166 | $0 | |
Dec 26 | Purchase | 13 | $175 | 9 | $175 | $1,575 | 4 | $175 | $700 | |
27 | 16 | $2,735 | 11 | $1,855 | ||||||
Weighted average | ||||||||||
Units | Unit Cost | |||||||||
9 | $165 | $1,485 | ||||||||
5 | $166 | $830 | ||||||||
13 | $175 | $2,275 | ||||||||
27 | $4,590 | |||||||||
Weighted average cost per unit | $170 | |||||||||
Ending Inventory = 11 x $170 | $1,870 | |||||||||
COGS = Beginning inventory + purchases - ending inventory | ||||||||||
= | $1,485 + $3,105 - $1,870 | |||||||||
= | $2,720 | |||||||||
FIFO | ||||||||||
Units | Unit Cost | |||||||||
11 | $175.00 | $1,925 | ||||||||
Ending Inventory | $1,925 | |||||||||
COGS = Beginning inventory + purchases - ending inventory | ||||||||||
= | $1,485 + $3,105 - $1,925 | |||||||||
= | $2,665 | |||||||||
LIFO | ||||||||||
Units | Unit Cost | |||||||||
9 | $165 | $1,485 | ||||||||
2 | $166 | $332 | ||||||||
Ending Inventory | $1,817 | |||||||||
COGS = Beginning inventory + purchases - ending inventory | ||||||||||
= | $1,485 + $3,105 - $1,817 | |||||||||
= | $2,773 | |||||||||
Inventory and Cost of Goods Sold 33 E6-17A. (Lear (Learning Objective 2: Compare ending inventory and...
f goods sold units sold ar ost, then (c) hding Rour Jul 1 Beginning inventory..... 15 Purchase 26 Purchase 9 units @ $ 5 units @ 13 units @ 165 = $ 1,485 166 = $ 830 175 = $ 2,275 Print Done Fields and then click Check Answer. Clear All A P CUEU L UCU U Triar ELETTRICITICIARELUUTISTE pute cost of goo number of units ) average cost, the ventory using all final ans 1. Compute cost of goods...
Dundas Company's inventory records for its retail division show the following at October 31: (Click the icon to view the accounting records.) At October 31, 11 of these units are on hand. Read the requirements. Requirement 1. Compute cost of goods sold and ending inventory, using each of the following four inventory methods: Begin by entering the number of units sold and number of units in ending inventory. Then calculate cost of goods sold and ending inventory using (a) specific...
Dave Company's inventory records for its retail division show the following at December 31: (Click the icon to view the accounting records.) At December 31, 11 of these units are on hand. Read the requirements Requirement 1. Compute cost of goods sold and ending inventory, using each of the following four inventory methods: Begin by entering the number of units sold and number of units in ending inventory. Then calculate cost of goods sold and ending inventory using (a) specific...
Lea E6-19 Comparing amounts for cost of goods sold, ending inventory, and gross profit-FIFO and LIFO Assume that Toys Galore store bought and sold a line of dolls during December as follows: Dec. 1 Beginning merchandise inventory 8 Sale 14 Purchase 21 Sale 13 units @ $ 9 each 8 units @ $ 22 each 16 units @ $ 14 each 14 units @ $ 22 each Requirements 1. Compute the cost of goods sold, cost of ending merchandise inventory,...
Financial Accounting - 61876 Homework: Week 5: Homework 2 of 4 (1 complete) Score: 0 of 10 pts E6-31B (similar to) Richmond Company's inventory records for its retail division show the following at July 31: (Click the icon to view the accounting records.) At July 31, 11 of these units are on hand. Read the requirements Data Table Requirement 1. Compute cost of goods sold and ending inventory, using each of the follo Begin by entering the number of units...
please assist me with the requirements on
this
Dave Company's inventory records for its retail division show the following at March 31: E: (Click the icon to view the accounting records.) At March 31, 10 of these units are on hand. Read the requirements Requirement 1. Compute cost of goods sold and ending inventory, using each of the following four inventory methods: Begin by entering the number of units sold and number of units in ending inventory. Then calculate cost...
2 of 4 (2 complete) XE6-31B (similar to) Richmond Company's inventory records for its retail division show the following at July 31: T ack the loon to view the accounting records) Al July 31, 11 of these units are on hand, Read the requirements Requirement 1. Compute cost of goods sold and ending inventory, using each of the following four inventory methods: Begin by entering the number of units sold and number of units in ending inventory. Then calculate cost...
Kan Company's inventory records for its retail division show the following at January 31: (Click the icon to view the accounting records.) Al January 31, 11 of these units are on hand. Ken Company calculaled ils cost of goods sold using LIFO as $2.773 and its cost of goods sold using FIFO as $2,665. Read the requirement. How much in taxes would Ken Company, save by using the LIFO method versus FIFO? Sales revenue is $8.960, operating expenses are $1,700,...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...
Required information Problem 6-1A Calculate ending inventory and cost of goods sold for four inventory methods (LO6-3) [The following information applies to the questions displayed below.] Sandra's Purse Boutique has the following transactions related to its top-selling Guccipurse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 S800 $4,800 October 4 Sale 4 October 10 Purchase 5 810 4,050 October 13 Sale 3 October...