1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
LenKa [72]
3 years ago
5

The beginning inventory at Midnight Supplies and data on purchases and sales for a three month period ending March 31 are as fol

lows:
Date
Transaction
Number of Units
Per Unit
Total
Jan. 1 Inventory 2,500 $70.00 $175,000
10 Purchase 8,000 78.00 624,000
28 Sale 3,800 140.00 532,000
30 Sale 1,250 140.00 175,000
Feb. 5 Sale 500 140.00 70,000
10 Purchase 17,000 80.00 1,360,000
16 Sale 9,100 145.00 1,319,500
28 Sale 8,700 145.00 1,261,500
Mar. 5 Purchase 14,300 81.60 1,166,880
14 Sale 9,800 145.00 1,421,000
25 Purchase 3,000 82.00 246,000
30 Sale 7,900 145.00 1,145,500

Instructions
1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method.
2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account and date your journal entry March 31. Refer to the Chart of Accounts for exact wording of account titles.
3. Determine the gross profit from sales for the period.
4. Determine the ending inventory cost as of March 31.
5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?
Business
1 answer:
larisa86 [58]3 years ago
6 0

Answer:

1. Journal Entries

January 1

Dr.  Inventory                   $624,000

Cr.  Account Payables    $624,000

January 10

Dr.  Account Receivables $532,000

Cr.  Sales                           $532,000

January 28

Dr.  Account Receivables $175,000

Cr.  Sales                           $175,000

Dr.  Cost of Goods Sold   $276,400

Cr.  Inventory                    $276,400

January 30

Dr.  Cost of Goods Sold   $97,500

Cr.  Inventory                    $97,500

February 5

Dr.  Account Receivables $70,000

Cr.  Sales                           $70,000

Dr.  Cost of Goods Sold   $39,000

Cr.  Inventory                    $39,000

February 10

Dr.  Inventory                    $1,360,000

Cr.  Account Payable       $1,360,000

February 16

Dr.  Account Receivables $1,319,500

Cr.  Sales                           $1,319,500

Dr.  Cost of Goods Sold    $718,100

Cr.  Inventory                     $718,100

February 28

Dr.  Account Receivables    $1,261,500

Cr.  Sales                              $1,261,500

Dr.  Cost of Goods Sold      $696,000

Cr.  Inventory                       $696,000

March 5

Dr.  Inventory                $1,166,880

Cr.  Account Payables $1,166,880

March 14

Dr.  Account Receivables  $1,421,000

Cr.  Sales                            $1,421,000

Dr.  Cost of Goods Sold    $793,040

Cr.  Inventory                     $793,040

March 25

Dr.  Inventory               $246,000

Cr.  Account Payable  $246,000

March 30

Dr.  Account Receivables  $1,145,500

Cr.  Sales                            $1,145,500

Dr.  Cost of Goods Sold    $644,640

Cr.  Inventory                     $644,640

* Assuming Purchases and Sales are made on Account

2.

Sales Value = $5,924,500  

Opening Inventory = $175,000

Closing Inventory = $307,200

Purchases =  $3,396,880

Cost of Goods Sold =  $3,264,680

Gross Profit = $2,659,820

3.

As the prices are increasing the Inventory value using last-in, first-out will be lower because all the unit sold at last are sold and inventory of the old items which was purchased on the lower cost remains in the closing inventory. The cost of Goods sold will be higher in this case.

Explanation:

First In First out (FiFO) is an Inventory method which determines the inventory value and it requires that the unit purchased first will be sold first.

Cost of Goods Sold = Opening Inventory + Purchases - Closing Inventory

Cost of Goods Sold = $175,000 + $3,396,880 - $307,200 =

Gross Profit = Sales Value - Cost of Goods Sold

Gross Profit = $5,924,500 - $3,264,680

Gross Profit = $2,659,820

Inventory Working is made in a MS Excel File, which is attached with this answer please find it.

Download xlsx
You might be interested in
The etruscans developed a special sophistication in casting and engraving on
Archy [21]
The Etruscans developed a special sophistication in casting and engraving on <u>bronze.
</u>The Etruscans were an ancient culture that was located in central and northern Italy. They were very famous for their art, especially for bronze casts and engravings that are an important archaeological relic even today. They weren't the first nation to do this type of art, however, they were the best.<u>
</u>
4 0
3 years ago
The income tax saved by using lifo instead of fifo is equal to the​ ________ times the income tax rate.
marshall27 [118]
C. cost of the ending inventory
3 0
3 years ago
Select three aspects that must be considered when analyzing assets.
serious [3.7K]

Answer:

Explanation:

Living expenses

Income

Financial plan

3 0
3 years ago
Jessica is a violinist who believes she can extend her method of learning music to early childhood education. She opens a presch
Romashka-Z-Leto [24]
This is an example of entrepreneurship!<span />
5 0
3 years ago
Read 2 more answers
Assume you purchased the right to sell 2,300 shares of JCPenney stock in November 2015 at a strike price of $9.00 per share. Sup
Gre4nikov [31]

Answer:

Put options give the holder the right to sell the underlying stock to the seller of the put option.

Put options are advantageous when the price in the market falls below the strike price of the option because the buyer will be able to sell at above market value and make a profit.

The asking price for a strike price of $9.00 is listed to be $0.33 and this is the premium paid by the buyer of the Put Option.

<h2>1. Return if stock sells for $8.00</h2>

= Amount received/ Amount spent

= (No. of shares * ((Strike price - Market price) - Premium paid) ) / (No. of share * premium)

= (2,300 shares * (($9.00 - 8.00) - 0.33))/ ( 2,300 * 0.33)

= 2.03

= 203 %

<h2>2. Return if stock sells for $10.00. </h2>

As this is an option, the investor can decide not to sell to the seller. The market price is higher than the strike price so they will not sell to the seller of the option and the return will be;

= (No. of shares * - Premium paid) ) / (No. of share * premium)

= (2,300 shares * - 0.33)/ ( 2,300 * 0.33)

= -1

= -100 %

4 0
3 years ago
Other questions:
  • The industry-low, industry-average, and industry-high cost benchmarks on pp. 5-6 of the latest issue of the glo-bus statistical
    12·1 answer
  • ______________ did pioneering work on National Income Accounting at the NBER This was very important along with Wesley Mitchell'
    13·1 answer
  • The simple situation in which two parties come together and freely agree to an exchange is ethically legitimate only prima facie
    6·1 answer
  • "An expenditure made in connection with a machine being used by a company to produce inventory should be expensed immediately if
    15·1 answer
  • Scott is a manager at a large electronics company. His primary role within the organization is to plan for the "people needs" of
    8·1 answer
  • Cash equivalents:______.
    15·1 answer
  • Advertisements masquerade as media content by
    14·1 answer
  • In general, which TWO characteristics define a "small" business?
    8·1 answer
  • cnn.com runs a story reporting that the consumer confidence index has risen. having taken an economics class, you predict that s
    10·1 answer
  • 1. Please reflect on how the money multiplier concept can be an important tool of both expansionary as well as contractionary mo
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!