1.
FIFO | |||||||||
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
Date | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost |
May 1 | 65 | 59 | 3835 | ||||||
5 | 145 | 80 | 11600 | 65 | 59 | 3835 | |||
145 | 80 | 11600 | |||||||
13 | 65 | 59 | 3835 | 50 | 80 | 4000 | |||
95 | 80 | 7600 | |||||||
18 | 170 | 90 | 15300 | 50 | 80 | 4000 | |||
170 | 90 | 15300 | |||||||
26 | 50 | 80 | 4000 | 45 | 90 | 4050 | |||
125 | 90 | 11250 | |||||||
Totals | 315 | 26900 | 335 | 26685 | 45 | 4050 |
Gross profit is $10895 using the FIFO inventory costing method.
2.
LIFO | |||||||||
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
Date | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost |
May 1 | 65 | 59 | 3835 | ||||||
5 | 145 | 80 | 11600 | 65 | 59 | 3835 | |||
145 | 80 | 11600 | |||||||
13 | 145 | 80 | 11600 | 50 | 59 | 2950 | |||
15 | 59 | 885 | |||||||
18 | 170 | 90 | 15300 | 50 | 59 | 2950 | |||
170 | 90 | 15300 | |||||||
26 | 170 | 90 | 15300 | 45 | 59 | 2655 | |||
5 | 59 | 295 | |||||||
Totals | 315 | 26900 | 335 | 28080 | 45 | 2655 |
Gross profit is $9500 using the LIFO inventory costing method.
3.
Weighted-Average | |||||||||
Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
Date | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost | Quantity | Unit cost | Total Cost |
May 1 | 65 | 59 | 3835 | ||||||
5 | 145 | 80 | 11600 | 210 | 73.5 | 15435 | |||
13 | 160 | 73.5 | 11760 | 50 | 73.5 | 3675 | |||
18 | 170 | 90 | 15300 | 220 | 86.25 | 18975 | |||
26 | 175 | 86.25 | 15094 | 45 | 86.25 | 3881 | |||
Totals | 315 | 26900 | 335 | 26854 | 45 | 3881 |
Gross profit is $10726 using the weighted-average inventory costing method.
Working:
FIFO | LIFO | Weighted Average | |
Sales (160 x $108) + (175 x $116) | 37580 | 37580 | 37580 |
Cost of goods sold | 26685 | 28080 | 26854 |
Gross profit | 10895 | 9500 | 10726 |
Per HOMEWORKLIB RULES the first question has been answered. Please post the remaining independent question separately. Thank you.
Athletic Word began May with merchandise inventory of 65 cretes or vitamins that cost total of...
For planet began May with with merchandise inventory of 65 crates of of vitamins that cost a total of of $3,835. During the month, fit planet purchased and sold merchandise on account as follows: ms 50f 6 (3 complete) ▼ uring the month, Fit Planet purchased and sold merchandise on account as follows: determine the company's cost of goods sold, ending merchandise inventory, and gross profit. on ha Xhe olde Requirements ota Prepare a perpetual inventory record, using the FIFO...
Athletic world began January with merchandise inventory of 70 crates of vitamins that cost a total of $4,550. During the month, Athletic World purchased and sold merchandise on account as follows. onth, Athletic World purchased and sold merchandise on account as follows: pany's cost of goods sold, ending merchandise inventory, and gross profit method. Enter the transactions in chronological order, calculating new inventory on hand balances after purchased, sold, and on hand at the end of the period. (Enter the...
Fit Gym began October with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on account as follows: EEB (Click the icon to view the transactions.) Read the requirements. Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of...
Athletic World began January with merchandise inventory of 72 crates of vitamins that cost a total of $3,600. During the month, Athletic World purchased and sold merchandise on account as follows: BE: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of...
Please show answers clearly. Fit Gym began July with merchandise inventory of 76 crates of vitamins that cost a total of $4,560. During the month, Fit Gym purchased and sold merchandise on account as follows: (Click the icon to view the transactions.) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and delermine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold...
ntory of 78 crates of vitamins that cost a total of $4,290. During the month, Exercise Planet purch Data Table x using the goods sold, end ending e all oft Enter th Oct. 5 Purchase 156 crates @ $ 64 each 100 each he transactions the quantity and 13 Sale 180 crates @ $ Costo 18 Purchase crates @ $ 75 each crates @ S 18 each o the next question Exercise Planet begon October with marchandise inventory of T...
crates of vitamins that cost a total of $3,600. During the month, Athletic W i Data Table good the tra the qu Oct. 5 Purchase 13 Sale 18 Purchase 26 Sale 120 crates @ 130 crates @ 130 crates @ 140 crates @ $ $ $ $ 58 each 108 each 72 each 112 each stof Print | Done o the next question Activity Details Athletic World began October with merchandise inventory of 80 crates of vitamins that cost a...
Please explain your answer. Thank you. Learning Objectives 2, 3 P6-28A Accounting for inventory using the perpetual inventory system- FIFO, LIFO, and weighted average Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on account as follows: 2. Ending Merch. Inv., $990 Jan. 5 Purchase 156 crates @ $ 64 each 180 crates @ $ 100 each 13 Sale 18 Purchase 26...
Please explain your answer. Thank you. Learning Objectives 2, 3 P6-28A Accounting for inventory using the perpetual inventory system- FIFO, LIFO, and weighted average Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on account as follows: 2. Ending Merch. Inv., $990 Jan. 5 Purchase 156 crates @ $ 64 each 180 crates @ $ 100 each 13 Sale 18 Purchase 26...
TH VOIR. IVICUUIU TI Score: 0 of 1 pt 6 of 6 (5 complete) P6-28A (similar to) Fit World began May with merchandise Inventory of 70 crates of vitamins that cost a total of $4,560. During the month, Fit World purchased and sold merchandise on account as follows: E! (Click the icon to view the transactions.) Read the requirements Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold,...