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
Makovka662 [10]
3 years ago
11

The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction

Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40 2,250 90,000 16 Sale 25 2,250 56,250 21 Purchase 35 1,264 44,240 28 Sale 44 2,250 99,000 Required: 1. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Inventory, June 30 $ Cost of goods sold $ 2. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system. Inventory, June 30 $ Cost of goods sold $ 3. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system. Note: Round the weighted average unit cost to the nearest dollar and final answers to the nearest dollar. Inventory, June 30 $ Cost of goods sold $ 4. Compare the gross profit and June 30 inventories using the following column headings. For those boxes in which you must enter subtracted or negative numbers use a minus sign. FIFO LIFO Weighted Average Sales $ $ $ Cost of goods sold Gross profit $ $ $ Inventory, June 30 $ $ $
Business
1 answer:
Pepsi [2]3 years ago
5 0

Answer:

Dunne Co.

1. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system:

a) Inventory, June 30  = $32,864 (26 x $1,264)

b) Cost of goods sold = Cost of goods available for sale - Ending Inventory = $310,776 ($343,640 - $32,864)

2. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system:

a) Inventory, June 30 =  $

Beginning Inventory 25 units at $1,200 = $30,000

Purchase on April 8, 1 unit at $1,240              1,240

Total Ending Inventory                              $31,240

b)Cost of goods sold = Cost of goods available for sale - Ending Inventory

= $311,400 ($343,640 - $32,240)

3. Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system. Note: Round the weighted average unit cost to the nearest dollar and final answers to the nearest dollar:

a) Inventory, June 30 = $32,489.60 (26 x $1,249.60)

b) Cost of goods sold = $311,150.40 (249 x $1,249.60)  

4. Compare the gross profit and June 30 inventories using the following column headings. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

                                     FIFO                  LIFO         Weighted Average

Sales                            $525,250         $525,250         $525,250

Cost of goods sold         310,776              311,400              311,150

Gross profit                  $214,474           $213,850           $214,100

Inventory, June 30       $32,864             $31,240           $32,489.60

Explanation:

a) Purchases and Sales Data:

Date     Transaction     Number of Units    Per Unit       Total

                                       In        Out                                 Cost      Sales

Apr. 3    Inventory          25                       $1,200     $30,000

      8     Purchase          75                         1,240        93,000

     11     Sale                               40          2,000                          80,000

    30    Sale                               30          2,000                          60,000

May 8   Purchase          60                       1,260         75,600

     10   Sale                               50          2,000                         100,000

     19   Sale                               20          2,000                          40,000

    28   Purchase          80                       1,260       100,800

June 5 Sale                              40          2,250                          90,000

     16   Sale                              25          2,250                         56,250

     21   Purchase          35                      1,264        44,240

    28   Sale                              44          2,250                         99,000

b) Goods Available     275                                 $343,640

Cost of goods sold    249                                                   $525,250

Ending Inventory         26

c) Average cost of goods = Cost of goods available for sale/Quantity of goods available for sale = $343,640/275 = $1,249.60

d) FIFO, LIFO, and Weighted Average Costing Method under the periodic inventory system assume that 1) FIFO, the goods bought first are sold first; 2) LIFO, the goods bought last are sold first; and 3) Weighted Average, the cost of goods is the weighted average, and lastly that it is only when physical count is taken of inventory that one can estimate its value.  Unlike the perpetual inventory system, the periodic must wait till the end of a financial period to value stock.  The results for ending inventory under the weighted average method, using the perpetual inventory system differs from the results under the same method, using the periodic inventory system.

You might be interested in
What is the purpose of professional communication?
weqwewe [10]

Answer:

By mastering professional communication, the potential for misunderstandings occurring can be minimised. When you work in a team, you need to be able to regularly communicate with others. You need to listen to other people's ideas, whilst being able to clearly and effectively communicate your own.

Purposes:

The five purposes for communication are to inform, imagine, influence, meet social expectations and express feelings.

6 0
2 years ago
Read 2 more answers
The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​ firm's working capital. The loa
klio [65]
<h2>Question:</h2>

As the data in incomplete, lets consider the data found on the net for the same question

DATE         LIBOR

week 1        1.98%

week 2       1.64%

week 3       1.54%

week 4       1.31%

week 5       1.57%

week 6       1.69%

week 7       1.66%

week 8       1.94%

week 9       1.92%

(This data in not given in the question. If some values differ from this data, just change the that value in the method below and you'll get your answer)

<h2></h2><h2>Answer:</h2>

Floating rate = 0.25%

Maximum rate = 2.24%

Minimum rate = 1.71%

General formula for for finding rate of interest of a week

Week Rate = Previous Week's Rate (LIBOR from table) + Floating Rate

Lets find the values:

Week 2 rate  = Week 1 rate + 0.25%   = 1.98% + 0.25% = 2.23%

Week 3 rate  = Week 2 rate + 0.25%  = 1.64% + 0.25% = 1.89%

Week 4 rate  = Week 3 rate + 0.25%  = 1.54% + 0.25% = 1.79%

Week 5 rate  = Week 4 rate + 0.25%  = 1.31% + 0.25% = 1.56%

Week 5 rate is lower than the minimum rate, rate of Week 5 can be taken as minimum rate

Week 5 rate = 1.71%

Week 6 rate  = Week 5 rate + 0.25%  = 1.57% + 0.25% = 1.82%

Week 7 rate  = Week 6 rate + 0.25%  = 1.69% + 0.25% = 1.94%

Week 8 rate  = Week 7 rate + 0.25%  = 1.66% + 0.25% = 1.91%

Week 9 rate  = Week 8 rate + 0.25%  = 1.94% + 0.25% = 2.19%

Week 10 rate = Week 9 rate + 0.25%  = 1.92% + 0.25% = 2.17%

8 0
2 years ago
Which of the following best describes a project stakeholder
Brilliant_brown [7]
Project Stakeholders can be entities that have an interest in a given project. 
3 0
2 years ago
Review your pre and post scores from "Where Are You Now." Did your scores improve? What activities did you complete that facilit
DIA [1.3K]

Answer:

what do you mean did our scores improve, if so, idk yet

3 0
2 years ago
The Durham-Mills Self-Administering Test of Mental Ability was the first group-administered mental ability test to have widespre
forsale [732]

Answer:

False

Explanation:

The Otis Self-Administering Test of Mental Ability was the first group-administered mental ability test to have widespread use in industry.

This test was first developed in 1922 by Arthur Otis. It was first designed to measure students' general school abilities. Otis's first tests were designed for the Army in 1917 and were known as the Alpha tests (for those who could read) and the Beta tests (for those who couldn't read).

7 0
3 years ago
Other questions:
  • The appropriate cost accounting system to use when inventory items are produced on an assembly line is
    5·1 answer
  • A company has the following budget information: Sales: $118,800; COGS: $48,500; Depreciation expense: $1,500; Interest expense:
    12·1 answer
  • The contribution approach to the income statement:Group of answer choicesOrganizes costs on a functional basis.Shows a contribut
    5·1 answer
  • The sales budget for Modesto Corp. shows that 12,000 units of Product A and 14,000 units of Product B are going to be sold for p
    15·1 answer
  • Which of the following statements is false regarding the risk assessment component of internal control? a. Risk assessment inclu
    9·1 answer
  • Including scholarships and financial aid, Madeline has $41,000 to spend on
    12·1 answer
  • You are asked to study the causal effect of hours spent on employee trainingâ (measured in hours per worker perâ week) in a manu
    10·1 answer
  • Suppose that a country's economy is operating at an unemployment rate 6% higher than its natural rate of unemployment. Then a(n)
    12·1 answer
  • Management of Wee Ones (WO), an operator of day-care facilities, wants the company's profit to be subdivided by center. The firm
    7·1 answer
  • Identify which statement is true of specialty products. Group of answer choices They are made directly available to a consumer t
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!