Help please ### Required InformationTrey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Additionally, on December 15, Monson sells 18 units for $10 each.#### Inventory Purchases:1. **Purchases on December 7**: - 8 units @ $4.00 each2. **Purchases on December 14**: - 26 units @ $6.00 each3. **Purchases on December 21**: - 18 units @ $7.00 each### Required:Monson sells 18 units for $10 each on December 15. Monson uses a perpetual inventory system. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. *(Round your per unit costs to 2 decimal places.)* ### Weighted Average - Perpetual Inventory Method#### Goods Purchased| Date | # of Units | Cost per Unit | Inventory Value ||--------------|------------|---------------|-----------------|| December 7 | 8 | $4.00 | $32.00 || December 14 | 26 | $6.00 | $156.00 || **Average Cost** || December 21 | 18 | $7.00 | $126.00 |#### Cost of Goods Sold| Date | # of Units Sold | Cost per Unit | Cost of Goods Sold ||--------------|-----------------|---------------|---------------------|| December 15 | 18 | $5.53 | $99.54 || **Average Cost** |#### Inventory Balance| Date | # of Units | Cost per Unit | Inventory Balance ||--------------|------------|---------------|-------------------|| December 7 | 8 | $4.00 | $32.00 || December 7 | 8 | $4.00 | $32.00 || December 14 | 8 | $4.00 | $32.00 || | 26 | $6.00 | $156.00 || | **Average Cost** || December 15 | 8 | $4.00 | $32.00 || | 26 | $6.00 | $156.00 || | 18 | $5.53 | $99.54 || December 21 | 34 | | |**Total**: $99.54### Explanation for Graphs/DiagramsThis table illustrates how the weighted average perpetual inventory method is applied to track the inventory of goods purchased, cost of goods sold, and inventory balance over time. The breakdown spans significant dates and events:1. **Goods Purchased**: - The quantity of units purchased, their cost per unit, and the total inventory value on specific dates. 2. **Cost of Goods Sold**: - The quantity of units sold, the cost per unit, and the total cost of goods sold by those specific dates. 3. **Inventory Balance**:

Weighted average cost of inventory method in which weighted average cost per unit is used for…

Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Also, on December 15, Monson sells 18 units for $10 each. 8 units @ $4.00 cost 26 units e $6.00 cost 18 units e $7.00 cost Purchases on December 7 Purchases on December 14 Purchases on December 21 Required: Monson sells 18 units for $10 each on December 15. Monson uses a perpetual inventory system. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. (Round your per unit costs to 2 decimal places.)

Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Also, on December 15, Monson sells 18 units for $10 each. 8 units @ $4.00 cost 26 units e $6.00 cost 18 units e $7.00 cost Purchases on December 7 Purchases on December 14 Purchases on December 21 Required: Monson sells 18 units for $10 each on December 15. Monson uses a perpetual inventory system. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. (Round your per unit costs to 2 decimal places.)

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 1.7C

See similar textbooks

Related questions

Q: Please help thanks

A: Equivalent units: This is one of the processes costing methods, under this method the uncompleted…

Q: Student ID Day 63638034 Monday 23957096 Thursday 28080825 Monday Exam Score 61 70 1. How many…

A: =COUNTIF is used to count the cells satisfying the given criteria in the given range.

Q: What is a user view?

A: Database Management: Database management refers to management of databases held within an…

Q: John wishes to borrow 20,000. Lender X and Y offer the following terms: (1) Lender X will be repaid…

A: Present value:Present value is popularly known in short as PV. It is a concept of accounting that…

Q: Denzel Brooks opens a Web consulting business called Venture Consultants and completes the following…

A: Record the transactions in the T accounts:

Q: Statement of Cash Flows–Indirect Method The comparative balance sheet of Merrick Equipment Co. for…

A: Cash flows statement is prepared to present the cash generated or used under various activities of a…

Q: Uncollectible Accounts-Percentage of Sales and Percentage of Recelvab At the end of the current…

A: We shall answer the first question since the exact one was not specified. Please resubmit a new…

Q: Would you mind sharing a secondary example please?

A: Allowance Method - Under allowance method company make provision of uncollectible accounts at the…

Q: I need examples

A: Skimming fraud can be possible in business or personal basis. It is white collor crime. Generally It…

Q: Big help please

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: Activity F stomer Service

A: 1) S. Inc Activity rate = Total activity cost ÷ Activity Base Customer Service = $29,190 ÷ 210 =…

Q: a. Prepare a common-sized income statement comparing the results of operations for Sorenson…

A: Common size income statement is used for vertical analysis wherein each item in the income statement…

Q: What are the advantages and disadvantages of accessing online primary sources?

A: Primary sources are the proof of history, original records or objects created by participants or…

Q: Define advances from customers.

A: Current liability: Current liability is a debt that the companies need to pay the debts from…

Q: Help needed

Q: return filers

A: Every person has to file taxes and pay them on time as designated by the tax authority. Failure to…

Q: Define call protection

A: A financial instrument that does not affect the ownership of the common shareholders or management…

Q: Need help on part A

A: Return on total assets is a ratio that indicates the income earned relative to total assets.

Q: PLEASE HELP ASAP!

A: Journal Entry: Journal entry is the act of keeping records of transactions. Transactions are listed…

Q: Explain an example of external users.

A: Financial Statement: They are annual reports of an organization summarizing the financial…

Q: need help with question 6

A: The purchase term 2/15, n/30 means 2% discount is available if the payment made in 15 days, the…

Q: You want me to get a

A: Approach to solving the question: Detailed explanation: Examples: Key references:

Concept explainers

Market Efficiency

Market efficiency refers to the market's ability to provide investors with all available information about investment options for buying and selling securities. Market efficiency reflects the true value of securities without undervaluing or overvaluing them. When the quality and quantity of information increase, the market becomes more efficient, allowing it to reduce arbitrage and obtain higher market returns from investment. In a well-functioning market, everyone receives all information completely and immediately at no cost. It opens up a plethora of opportunities for investors to access various investment options.

Question

Help please

### Required Information

Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Additionally, on December 15, Monson sells 18 units for $10 each.

#### Inventory Purchases:
1. **Purchases on December 7**:
- 8 units @ $4.00 each
2. **Purchases on December 14**:
- 26 units @ $6.00 each
3. **Purchases on December 21**:
- 18 units @ $7.00 each

### Required:
Monson sells 18 units for $10 each on December 15. Monson uses a perpetual inventory system. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method.
*(Round your per unit costs to 2 decimal places.)*

### Weighted Average - Perpetual Inventory Method

#### Goods Purchased

| Date | # of Units | Cost per Unit | Inventory Value |
|--------------|------------|---------------|-----------------|
| December 7 | 8 | $4.00 | $32.00 |
| December 14 | 26 | $6.00 | $156.00 |
| **Average Cost** |
| December 21 | 18 | $7.00 | $126.00 |

#### Cost of Goods Sold

| Date | # of Units Sold | Cost per Unit | Cost of Goods Sold |
|--------------|-----------------|---------------|---------------------|
| December 15 | 18 | $5.53 | $99.54 |
| **Average Cost** |

#### Inventory Balance

| Date | # of Units | Cost per Unit | Inventory Balance |
|--------------|------------|---------------|-------------------|
| December 7 | 8 | $4.00 | $32.00 |
| December 7 | 8 | $4.00 | $32.00 |
| December 14 | 8 | $4.00 | $32.00 |
| | 26 | $6.00 | $156.00 |
| | **Average Cost** |
| December 15 | 8 | $4.00 | $32.00 |
| | 26 | $6.00 | $156.00 |
| | 18 | $5.53 | $99.54 |
| December 21 | 34 | | |

**Total**: $99.54

### Explanation for Graphs/Diagrams

This table illustrates how the weighted average perpetual inventory method is applied to track the inventory of goods purchased, cost of goods sold, and inventory balance over time. The breakdown spans significant dates and events:

1. **Goods Purchased**:
- The quantity of units purchased, their cost per unit, and the total inventory value on specific dates.

2. **Cost of Goods Sold**:
- The quantity of units sold, the cost per unit, and the total cost of goods sold by those specific dates.

3. **Inventory Balance**:

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%-false 12 為口 Beginning inventory, purchases, and sales for an inventory item are as follows: Sept. 1 Beginning inventory 32 units @ $19 Sale 19 units 17 Purchase 35 units @ $22 30 Sale 33 units Assuming a perpetual inventory system and the first-in, first-out method, determine (a) the cost of the merchandise sold for the September 30 sale and (b) the inventory on September 30. a. Cost of merchandise sold b. Inventory, Septem 30 Previous Next
7 3 ences Given the following: Mc Graw Hill January 1 inventory April 1 June 1 November 1 Cost of ending inventory Number purchased 40 60 50 55 205 Cost of goods sold Cost per unit $ 4 7 8 9 a. Calculate the cost of ending inventory using the weighted-average method (ending inventory shows 61 units_ Note: Round the "average unit cost" and final answer to the nearest cent. AS
Q: If the cost of an item of inventory is $52.00 and the current replacement cost is $68.00, what is the amount included in inventory according to the lower of cost or market? a. $120.00 b. $52.00 c. $16.00 d. $68.00
17. Models of inventory systems frequently consider the relationships among a beginning inventory, a production quantity, a demand or sales, and an ending inventory. For a given production period j, let * 2, d, beginning inventory for period j (ending inventory from period j-1 production quantity in period j demand in period j ending inventory for period j a. Write the mathematical relationship or model that shows ending inventory as a function of beginning inventory, production, and demand. b. What constraint should be added if production capacity for period j is given by C, ? e. What constraint should be added if inventory requirements for period j mandate an ending inventory of at least 1;?
Question 7 of 7 < < Suppose that Best Buy accumulates the following cost and net realizable value (NRV) data at December 31. Inventory Cost NRV Categories Data Data Earbuds $11,500 $10.300 Drones 7.900 8,700 Docking stations 13.900 12,800 What is the lower-of-cost-or-net-realizable-value of the inventory? Lower-of-cost-or-net-realizable-value eTextbook and Media LA As
Suppose the following:Beginning Inventory = 11257Ending Inventory= 12407Beginning Receivables = 6167Ending Receivables = 6879Beginning Payables = 8498Ending Payables = 8829Credit Sales = 93480Cost of Goods Sold = 72325Calculate the following (round final answers to 2 decimal places):Operating Cycle = daysCash Cycle = days
PA4. LO 10.3 Calculate the cost of goods sold dollar value for A74 Company for the sale on March 11, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG). Number of Units Unit Cost Beginning inventory Mar. 1 Purchased Mar. 8 Sold Mar. 11 for $120 per unit 110 140 $87 89 95 Solution А. Number of Units Dollar per Unit Value Cost of goods sold В. Number of Units Dollar per Unit Value Cost of goods sold C. Number of Units Dollar per Unit Value Cost of goods sold PA5. LO 10.3 Use the first-in, first-out (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions. Number Unit Cost of Units Beginning inventory Purchased Mar. 2 Sold Mar, 31 for $75 per unit 105 150 88…
Help solving problem
TB MC Qu. 05-131 (Algo) A company has the following products... A company has the following products in its ending Inventory. Compute lower of cost or market for inventory applied separately to each product Cost per Market per Unit Unit $ 726 $ 696 $ 526 $ 566 $ 676 $ 701 Product Quantity 10 15 20 Product A Product B Product C
Current assets at 30 June 20-7 Martha's capital at 1 July 20-7 Gross profit for the year ending 30 June 20-8 Current assets at 30 June 20-8 TIP Parts a-e of this question require the skill of knowledge and understanding. You need to know the principles of inventory valuation and understand how this is applied to a given scenario. Part frequires the skill of analysis. You need to analyse the effect of the error. 13 Yee's payments for the year ended 31 December 20-8 included the following: Wages 2$ Insurance (for 12 months to 30 June 20-9) 2400 At 1 January 20-8, wages due amounted to $1300 and insurance prepaid amounted to $1140. At 31 December 20-8, wages due amounted to $1550. Write up the wages account and the insurance account as they would appear in Yee's ledger for the year ended 31 December 20-8. Balance the accounts and show the amounts transferred to the income statement. 14 Zeema's financial year ends on 30 September. She sublets part of her premises to Faith at an annual rent…
QUESTION 11 Match the term on the left to the appropriate description on the right. v Cost of goods available for sale (COGAS) A. A valuation rule applied to ending inventory. v LIFO reserve B. The maximum value that cost of goods sold (COGS) can be in a period. C. The amount by which inventory measured under FIFO would exceed inventory measured under LIFO v Lower-of-cost-or-market v Inventory turnover ratio. D. An inventory cost flow assumption. E. A measure for evaluating a company's inventory management. v FIFO (first-in, first out) v Periodic inventory F. A system for calculating COGS based on ending inventory value.
Need answer