Question

In: Accounting

1. XYZ Company is a startup company, and it has purchased inventory as follows: Date Quantity...

1. XYZ Company is a startup company, and it has purchased inventory as follows:

Date Quantity Price
2/1/16 1000 1.05
3/1/16 500 1.10
5/1/16 800 1.00
6/1/16 1500 .90
7/1/16 2500 1.02
8/1/16 750 1.15

Assume you have sold 2,250 units in 2016.

Given that fact, how much would inventory be valued on the balance sheet under the following methods and how much Cost of Goods Sold would be recognized as well?

a. LIFO Method

b. FIFO Method

c. Average Cost Method

Solutions

Expert Solution

  • All working forms part of the answer
  • Working for Ending no. of units:

--Units purchased = 1000 + 500 + 800 + 1500 + 2500 + 750 = 7050 units

---Units sold = 2250 units

--Ending Inventory units = 7050 – 2250 = 4,800 units

  • Requirement ‘a’

--LIFO Method

--Under LIFO method, ending Inventory is first valued on the earliest purchases, then moving down to latest purchases.

--Working

Ending Units 4800 units, valued at purchases on:

Units

Rate per unit

Amount of Inventory

01-Feb-16

1000

$                             1.05

$                                        1,050.00

01-Mar-16

500

$                             1.10

$                                           550.00

01-May-16

800

$                             1.00

$                                           800.00

01-Jun-16

1500

$                             0.90

$                                        1,350.00

01-Jul-16

1000

$                             1.02

$                                        1,020.00

Total

4800

$                                        4,770.00

---Answer: Ending Inventory as per LIFO = $ 4770

  • Requirement ‘b’

--FIFO Method

--Under this method, ending inventories are first valued from latest purchases, followed by earlier purchases.

---Working

Ending Units 4800 units, valued at purchases on:

Units

Rate per unit

Amount of Inventory

01-Aug-16

750

$                             1.15

$                                           862.50

01-Jul-16

2500

$                             1.02

$                                        2,550.00

01-Jun-16

1500

$                             0.90

$                                        1,350.00

01-May-16

50

$                             1.00

$                                              50.00

Total

4800

$                                        4,812.50

---Answer: value of ending inventory in Balance Sheet as per FIFO Method = $ 4,812.50

  • Requirement ‘c’

--Average Cost method

---Average cost per unit is calculated and then multiplied by ending units

---Working

Ending Units 4800 units, valued at purchases on:

Units

Rate per unit

Amount of purchases

01-Feb-16

1000

$                             1.05

$                                        1,050.00

01-Mar-16

500

$                             1.10

$                                           550.00

01-May-16

800

$                             1.00

$                                           800.00

01-Jun-16

1500

$                             0.90

$                                        1,350.00

01-Jul-16

2500

$                             1.02

$                                        2,550.00

01-Aug

750

$                             1.15

$                                           862.50

TOTAL

7050

$                                        7,162.50

--Answer—

A

Total Purchases

$                                     7,162.50

B

Total Units purchased

                                               7,050

C=A/B

Average cost per unit

$                                              1.02

D

Ending Units

                                               4,800

E=C x D

Value of ending Inventory

$                                     4,896.00


Related Solutions

XYZ Company is a startup company, and it has purchased inventory as follows: DATE QUANTITY PRICE...
XYZ Company is a startup company, and it has purchased inventory as follows: DATE QUANTITY PRICE 7/1/14 1000 $1.05 8/1/14 500 $1.10 9/1/14 800 $1.00 10/1/14 1500 $.90 11/1/14 2500 $1.02 12/1/14 750 $1.15 Assume you have sold 2,250 units in 2014. Given that fact, how much would inventory be valued on the balance sheet under the following methods and how much Cost of Goods Sold would be recognized as well? LIFO Method FIFO Method Average Cost Method
Problem 1 Company:                        XYZ Company Date of bonds:           &nbsp
Problem 1 Company:                        XYZ Company Date of bonds:                January 1, 2019 Term:                               4 years Face (Par) Value:            $1,000 Stated interest rate:         10% Effective interest rate:    12% Interest payment dates on January 1 and July 1 Compute the market price of the bonds and journalize the issuance of the bonds. Prepare a schedule to amortize the premium or discount using the effective interest method of amortization for the first year and journalize the entries to record the interest payment on July...
Problem 1 Company:                        XYZ Company Date of bonds:           &nbsp
Problem 1 Company:                        XYZ Company Date of bonds:                January 1, 2019 Term:                               4 years Face (Par) Value:            $1,000 Stated interest rate:         10% Effective interest rate:    12% Interest payment dates on January 1 and July 1 Compute the market price of the bonds and journalize the issuance of the bonds. Prepare a schedule to amortize the premium or discount using the effective interest method of amortization for the first year and journalize the entries to record the interest payment on July...
1. The following information relates to inventory for Shoeless Joe Inc. Date Quantity Price March 1...
1. The following information relates to inventory for Shoeless Joe Inc. Date Quantity Price March 1 Beginning Inventory 20 $2 March 7 Purchase 15 3 March 11 Sale 25 7 March 12 Purchase 20 4 At what amount would Shoeless report ending inventory using FIFO cost flow assumptions? 2. Ace Bonding Company purchased inventory on account. The inventory costs $2,000 and is expected to sell for $3,000. How should Ace record the purchase using a perpetual inventory system? A. Inventory...
Answer two of the following three Problems Problem 1 Company:                        XYZ Company Date of bonds:    &nbs
Answer two of the following three Problems Problem 1 Company:                        XYZ Company Date of bonds:                January 1, 2019 Term:                               4 years Face (Par) Value:            $1,000 Stated interest rate:         12% Effective interest rate:    10% Interest payment dates on January 1 and July 1 Compute the market price of the bonds and journalize the issuance of the bonds. Prepare a schedule to amortize the premium or discount using the effective interest method of amortization for the first year and journalize the entries...
Perry Company purchased 100% of Starling Company on 1/1/20X1. At the date of acquisition, the following...
Perry Company purchased 100% of Starling Company on 1/1/20X1. At the date of acquisition, the following differences existed: Starling had a 20-year loan for $500,000. The fair value of the loan was $540,000. Starling had an unrecorded Patent with an estimated remaining life of 5 years. The fair value of the patent was $800,000. Any other differences between book value and fair value were attributable o goodwill. At 12/31/20X4, Starling still had the loan and patent that existed at the...
The company purchased furniture on April 1, 2020 for $5,630. On the same date, furniture with...
The company purchased furniture on April 1, 2020 for $5,630. On the same date, furniture with an original cost of $119,961, was sold for $66,438. Calculate the maximum impact on business income for the year from furniture and other miscellaneous tangible capital assets.
The purchase schedule for Marin and Associates is as follows: Date Items Purchased Cost per Item...
The purchase schedule for Marin and Associates is as follows: Date Items Purchased Cost per Item March 15 6,300 $1.30 July 30 9,500 1.50 December 17 6,600 1.60 Total 22,400 The inventory balance as of the beginning of the year was $15,400 (15,400 units at $1), and an inventory count at year-end indicated that 11,300 items were on hand. Sales and operating expenses (excluding cost of goods sold) totaled $52,500 and $10,400, respectively. The federal income tax is 30 percent...
Question 1 A US company that has purchased inventory from a German supplier would be exposed...
Question 1 A US company that has purchased inventory from a German supplier would be exposed to a net exchange gain on the unpaid balance if a-The amount to be paid was denominated in dollars b-The Dollar weakened in relation to the Euro and the Euro was the denominated currency c-The Dollar strengthened relative to the Euro and the Euro was the denominated currency d-The company signed a forward contract for the purchase of Euros Question 2 When the affiliated...
Your US Company has just purchased a large quantity of parts from a German company for...
Your US Company has just purchased a large quantity of parts from a German company for 2.0 million Euros. Your company will make the payment of 2.0 million Euros in 90 days. The current Spot rate on the EUR is $1.14 ($1.14/1 EUR)   Your company has assumed that the expected spot rate on the EUR in 90 days will be the    same as the spot price today (The expected change in the spot rate over the next 90 days is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT