Question

FIFO –LIFO - Please type answers The Inventory Company has provided you with three months of...

  1. FIFO –LIFO - Please type answers

The Inventory Company has provided you with three months of their inventory and purchases for the last three months:

Date

Item

Quantity

Unit Price

July 1

Begin Inventory

2,500

$38

July 15

Purchase

3,300

$37

July 29

Purchase

5,500

$36

Aug 11

Purchase

4,100

$36

Aug 30

Purchase

6,700

$35

Sept 14

Purchase

3,900

$34

During three months the company sold 18,200 units. Selling price is $78 and the company’s tax rate is 32%.

Required:

A. Complete the worksheet for FIFO, LIFO and the income statement for the above information – similar to the example we completed in class and also posted on the Excel worksheet created during this week’s class.

Example --- Worksheet for FIFO and LIFO

Date

Item

Qty

Unit $

Total $

End Inventory

CGS

B. Complete the required income statement comparison, as we did in class.

FIFO

LIFO

Sales $$

CGS (Cost of Goods Sold)

Gross Profit

Income Tax

Profit after Taxes

C. Explain which method you would recommend that the company should use and explain the reason for your decision.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan.1 Inventory 4 units at $44 Aug.7 Purchase 19 units at $47 Dec. 11 Purchase 13 units at $48 Total 36 units $1693 There are 19 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the...
1 part A eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of...
1 part A eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 6 units at $44 $264 Aug. 7 Purchase 19 units at $46 874 Dec. 11 Purchase 13 units at $47 611 38 units $1,749 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...
The records of Glenn Aviation include the following accounts for inventory of aviation parts atJuly31 of...
The records of Glenn Aviation include the following accounts for inventory of aviation parts atJuly31 of the current​ year: Inventory Aug 1 Balance 800 units @ $7.00 $5,600 Nov 5 Purchase 500 units @ $7.10 3,550 Jan 24 Purchase 8,100 units @ $7.50 60,750 Apr 8 Purchase 600 units @ $8.50 5,100 Sales Revenue Jul 31 9,050 units $129,415 Requirement 1. Prepare a partial income statement through gross profit under the​ average, FIFO, and LIFO methods. Round average cost per...
Mondetta Clothing prepared its annual financial statements dated December 31. The company used the FIFO inventory...
Mondetta Clothing prepared its annual financial statements dated December 31. The company used the FIFO inventory costing method, but it failed to apply LCM to the ending inventory. The preliminary income statement follows: Net Sales $ 440,000 Cost of Goods Sold Beginning Inventory $ 50,000 Purchases 283,000 Goods Available for Sale 333,000 Ending Inventory (FIFO cost) 99,600 Cost of Goods Sold 233,400 Gross Profit 206,600 Operating Expenses 98,000 Income from Operations 108,600 Income Tax Expense (30%) 32,580 Net Income $...
If a company values inventory at the lower of cost or market, which of the following...
If a company values inventory at the lower of cost or market, which of the following is the value of merchandise inventory on the balance sheet? Apply the lower-of-cost-or-market method to inventory as a whole. Item Inventory Quantity Unit Cost Price Unit Market Price Product C 420 $ 6 $ 5 Product D 370 12 14 a.$6,540 b.$7,700 c.$6,960 d.$7,280 During times of rising prices, which of the following is not an accurate statement? a.LIFO will result in higher income...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 540 units @ $55 per unit Feb. 10 Purchase 460 units @ $53 per unit Mar. 13 Purchase 100 units @ $40 per unit Mar. 15 Sales 745 units @ $80 per unit Aug. 21 Purchase 170 units @ $61 per unit Sept. 5 Purchase 430 units @ $54...
Emily Company uses a periodic inventory system. At the end of the annual accounting period, December...
Emily Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 2: Units Unit Cost Inventory, December 31, prior year 2,890 $ 12 For the current year: Purchase, April 11 8,860 13 Purchase, June 1 7,930 18 Sales ($55 each) 10,860 Operating expenses (excluding income tax expense) $ 191,500 Required: 1. Prepare a separate income statement through pretax income that details...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 72 $300 $21,600 8 Purchase 144 360 51,840 11 Sale 96 1,000 96,000 30 Sale 60 1,000 60,000 May 8 Purchase 120 400 48,000 10 Sale 72 1,000 72,000 19 Sale 36 1,000 36,000 28 Purchase 120 440 52,800 June 5 Sale 72 1,050...
Presented below is information related to Blowfish radios for the Marigold Company for the month of...
Presented below is information related to Blowfish radios for the Marigold Company for the month of July. Date Transaction Units In Unit Cost Total Units Sold Selling Price Total July 1 Balance 140 $4.40 $  616 6 Purchase 1,120 4.50 5,040 7 Sale 420 $7.00 $ 2,940 10 Sale 420 7.30 3,066 12 Purchase 560 4.80 2,688 15 Sale 280 7.40 2,072 18 Purchase 420 4.90 2,058 22 Sale 560 7.40 4,144 25 Purchase 700 4.88 3,416 30 Sale 280 7.50...
Exercise 8-13 Presented below is information related to Blowfish radios for the Tamarisk Company for the...
Exercise 8-13 Presented below is information related to Blowfish radios for the Tamarisk Company for the month of July. Date Transaction Units In Unit Cost Total Units Sold Selling Price Total July 1 Balance 160 $3.90 $  624 6 Purchase 1,280 4.00 5,120 7 Sale 480 $7.00 $ 3,360 10 Sale 480 7.30 3,504 12 Purchase 640 4.30 2,752 15 Sale 320 7.40 2,368 18 Purchase 480 4.40 2,112 22 Sale 640 7.40 4,736 25 Purchase 800 4.38 3,504 30 Sale...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT