Can’t figure out how to do the lifo KFGH.DARequirementPrepare a perpetual inventory record using, FIFO, LIFO, and weighted-average inventory costing methods,and determine cost of goods sold and ending merchandise inventory. Use cell references from Data Tablefor quantities and unit cost. Use Excel formulas for total costs and total quantities. Format weightedaverage unit cost and total cost to display two decimal places.1 Inventory Flow Assumptions2DATA4DateDescriptionUnitsPer UnitJan 1Inventory on hand1,00046.Jan 3Purchase3,0005.7Jan 6Sale2,750109Jan 15Purchase5,00024610Jan 22Sale4,50010$438,500.001,75010,500.00358,00045.0007,250363738LIFOPurchasesCOGSInventory on Hand39DateQuantityUnit costTotal CostQuantityUnit costTotal CostQuantityUnit costTotal Cost4041Jan 1424344Jan 345464748Jan 649505152Jan 155354555657Jan 225859606162should be 8,250636465Weighted-Average66PurchasesCOGS

Last in first out is also written as LIFO. It is the method used for valuation of material and…

Answered: DATA Units Per Unit Description…

DATA Units Per Unit Description Inventory on hand Purchase Date Jan 1 1,000 2$ 4 Jan 3 3,000 2$ Jan 6 Sale 2,750 10 Jan 15 Purchase 5,000 6 Jan 22 Sale 4,500 10 8,000 2$ 45,000

Century 21 Accounting Multicolumn Journal

11th Edition

ISBN:9781337679503

Author:Gilbertson

Publisher:Gilbertson

Chapter20: Accounting For Inventory

Section20.2: Determining The Cost Of Merchandise Inventory

Problem 1OYO

See similar textbooks

Related questions

Q: bank reconciliation.

A: Bank reconciliation statement means a statement showing the causes of differences in the balance of ...

Q: Brady Manek spends $500,000 on leasehold improvements. It will cost $50,000 to remove the improvemen...

Q: ces ear dropper solution which can be sold for PHP. 125.00 per bottle. Annually, the company can pro...

A: Given as,

Q: Philip Enterprises, distributor of compact disks (CDs), is developing its budgeted cost of goods sol...

A: Direct materials cost utilized during the production process Direct labor cost utilized during the p...

Q: All Things Brass produces brass handles for the furniture industry in a four-stage process -Mixing, ...

A: Equivalent Units Units Physical Units Input Materials Direct Materials Conversion costs ...

Q: During production, to what are the costs in job order costing applied?A. manufacturing overheadB. co...

A: Job order costing system is generally used by the entities involved in the production of goods which...

Q: Question 1 M & C Corporation charter authorizes 1,000,000 shares of common stock and 100,000 shares...

A: These are the accounting transactions that are having a monetary impact on the financial statement o...

Q: Assertions: A. A Cutoff B. Accuracy C. Completene D. Existence E. Valuation

A: a. Decisional roles- The managers oversee and initiate new tasks or projects in order to enhance t...

Q: Mr. John started a T-shirts business to be known as “John T-shirts". He has provided you with the fo...

A: Non-Current Assets are those assets which are expected to be realized or collected in cash beyond 12...

Q: Which of the following is the primary source of revenue for a service business?A. the production of ...

A: A service business seems to be a firm that offers professional services to its customers. The produc...

Q: ontier Corp. sells units for $40, has unit variable costs of $12, and fixed costs of $133,000. Front...

Q: On October 1, 2021, Chrysanthemum Co. purchased equipment by issuing a 9% promissory note with face ...

A: Interest payable on Decemeber 31,2022 = 9% x (1500000-400000) x3/12= 24750

Q: Sylvia is tasked to compute for all the outlays of cash by her company for the last quarter of 2021....

Q: On January 1, 2006, Polk Corp. and Strass Corp. had condensed balance sheets as follows: Polk S...

A: Solution Consolidated balance sheet is a document that shows the entire financial situation of a pa...

Q: Hamlet House makes portable garden sheds that sell for $1,800 each. The tax rate for the company is ...

A: The break even sales are the sales where business earns no profit no loss during the period. The con...

Q: Whichofthefollowingstatementsis(are)correct?

A: A tax system is the system which has been put in place by the government in the country to collect t...

Q: Cara wants to make sure that her stock portfolio will not have to go through probate when she dies. ...

A: Given, In this question, there are some substitutes for Cara to use and we have to choose the better...

Q: 4-5 Saved Help Save & Exit Submit [The following information applies to the questions displayed belo...

A: The FIFO method stands for First in first out, where older inventory is sold first. The LIFO method ...

Q: Wayne Frederick expects sales of Bison Business Solutions's line of computer workstation furniture t...

A: Total cost of goods sold = Cost of goods sold per unit * Number of units produced Gross margin = Tot...

Q: Tl1e shareholders’ equity section of Gaines industries’s balance sheet appeared as follows at Decemb...

A: Comment- Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the quest...

Q: Van der Man Fashions, Inc. Income Statement Years Ended December 31, 2018 and 2017 2018 2017 236,000...

A: Average accounts = ( Previous year account + Current year account ) / 2 So , Average inventory = ( P...

Q: $ 338, 400 194,400 144,000 103, 500 $ 40, 500 Sales (7,200 units) Variable expenses Contribution mar...

A: Formula: Sales price per unit =Total sales value / Number of units sold

Q: Compute Current Ratio and Quick Ratio If Cash is 3.50 Lakhs, ST Investments are 6.50 Lakhs, Bank is ...

A: The current ratio and quick ratio both are used for measuring the liquidity of the business entity. ...

Q: Christoffe Yap is the owner of the CY Small Appliance Repair Shop. On January 1, 2022, the assets. l...

A: In accounting we follow double entry system where every debit has a cor...

Q: Coronado's Bakery makes a variety of home-style cookies for upscale restaurants in the Atlanta metro...

A: Standard cost accounting seems to be a very useful technique for managers trying to build a more rea...

Q: The following costs were incurred in March: Direct materials = PhP1,050,000 Direct Labor = PhP850,...

A: The conversion costs include direct labor and manufacturing overhead. Selling and administrative exp...

Q: Question 6 6.) The instrument in figure 2 exchanges cash flows with different .characteristics O a) ...

A: Figure 2 is an example of Volatility Swap.

Q: Utility Expense.

A: If income and Liabilities are increased then it will be credited

Q: Discuss the legal effect of incorporation or registration of a Limited Liability Partnership. State ...

A: A limited liability partnership is a separate legal and business entity from its partners. Only afte...

Q: Burrell Company purchased a machine for $34,000 on January 2, 2019. The machine has an estimated ser...

A: In this question , we will find depreciation by straight line method and double- declining balance d...

Q: In January direct labor was 40% of conversion cost. If the manufacturing overhead cost for the month...

A: Conversion costs= Direct Labor + Manufacturing Overheads.

Q: George Black lives in Manitoba, a non-participating province that has an 7% provincial sales tax Dur...

A: Purchase price = $ 82000 Trade allowance = $ 36000 Provincial sales tax (PST )= 7% The question requ...

Q: On December 31, 2020, Sack Port Ventures Inc. borrowed $103,000 by signing a four-year, 8.0% install...

A: Formula: Amount of principal in each payment = Total borrowed amount / 4 Years

Q: 5 years or 10,000 hours 180,000 units ue $ 18,000 man uses the machine for 1,700 hours and the depre...

A: The declining balance method refers to the concept which evaluates the depreciation on assets on the...

Q: Oslo Company prepared the following contribution format income statement based on a sales volume of ...

A: Information given in the question is as follows: Sales $ 30,000 Variable expenses 16,500 Cont...

Q: The following costs were incurred in January: Direct materials = PhP1,650,000 Direct labor = Php1,...

A: Conversion costs only include direct labor cost and manufacturing overhead

Q: A firm will produce either product A or B. The total costs (TC) for both products can be estimated b...

A: Net profits: Net profits are the earnings received by the company at the closing of an accounting ye...

Q: ________ are the costs associated with not choosing the other alternative.A. Sunk costsB. Opportunit...

A: The term "cost" alludes to the overall expense incurred in the production of goods and services as w...

Q: y, a recent Western Washington -year loan through Kent Lending, eement violates the applicable usu A...

A: The answer has been mentioned below.

Q: If cash is collected at the sale: A.the operating cycle will be longer than if sold on credit B.the ...

A: Lets understand the basics. Operating cycle is a company's cycle from the investing cash into raw m...

Q: Darlene Company acquires 80% of Juanito Company for P250,000 on January 1, 2010. Juanito reported c...

Q: The schedule presents the trial balance for MM Cafe at the end of the fiscal year. The following inf...

A: Adjusting entries are prepared by management to ensure the accrual basis accounting system. It is pr...

Q: Sunny Groves is Citrus grower in a southern state that has several citrus orchards, Weather forcaste...

A: Solution Working note- Near freezing Temperatures = 25% Probability. Deep freeze condition = 10% pro...

Q: Provide two inherent risk factors in the revenue cycle and identify the accounts that are likely to ...

A: RCM (revenue cycle management) is a procedure used by healthcare systems in the United States and ar...

Q: Acme Inc. has the following information available: Actual price paid for material $0.90 Standard pr...

A: Material Price Variance (MPV) MPV = (SP - AP) x Actual Quantity. Where, SP = Standard Price = $1 AP...

Q: If a journal entry includes a debit or credit to the Cash account, it is most likely which of thefol...

A: A cash account, commonly referred to as a cash book, appears to be a ledger whereby all cash transac...

Q: ation to interested users, I. It is generally favorable for the company to have a high receivable tu...

A: Debt ratio refers to the ratio which measures the leverage of a company in terms of loans or money b...

Q: In a job order cost system, which account shows the overhead used by the company?A. work in process ...

A: In job order costing system costing is done based on different products so each product is separatel...

Q: Problem 12-14 Expected Returns (LO2) Consider the following two scenarios for the economy and the ex...

A: Beta is the systematic risk of the portfolio for the company as a whole.

Q: Refer to information for Stewart Company in E21-11. Based only on the information presented and usin...

A: The cash flow statement represents the different section as cash flow from operating activities, cas...

Question

100%

Can’t figure out how to do the lifo

K
F
G
H.
D
A
Requirement
Prepare a perpetual inventory record using, FIFO, LIFO, and weighted-average inventory costing methods,
and determine cost of goods sold and ending merchandise inventory. Use cell references from Data Table
for quantities and unit cost. Use Excel formulas for total costs and total quantities. Format weighted
average unit cost and total cost to display two decimal places.
1 Inventory Flow Assumptions
2
DATA
4
Date
Description
Units
Per Unit
Jan 1
Inventory on hand
1,000
4
6.
Jan 3
Purchase
3,000
5.
7
Jan 6
Sale
2,750
10
9
Jan 15
Purchase
5,000
24
6
10
Jan 22
Sale
4,500
10
$4
38,500.00
1,750
10,500.00
35
8,000
45.000
7,250
36
37
38
LIFO
Purchases
COGS
Inventory on Hand
39
Date
Quantity
Unit cost
Total Cost
Quantity
Unit cost
Total Cost
Quantity
Unit cost
Total Cost
40
41
Jan 1
42
43
44
Jan 3
45
46
47
48
Jan 6
49
50
51
52
Jan 15
53
54
55
56
57
Jan 22
58
59
60
61
62
should be 8,250
63
64
65
Weighted-Average
66
Purchases
COGS

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 with 2 images

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

Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Use the first-in, first-out method (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Use the last-in, first-out (LIFO) 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.
Inventory Costing: Average Cost Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.)
Inventory Costing: LIFO Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method.
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).
Inventory Write-Down Byron Company has five products in its inventory and uses the FIFO cost flow assumption. Specific data for each product are as follows: Required: 1. What is the correct inventory value, assuming the LCNRV rule is applied to each item of inventory? 2. What is the correct inventory value, assuming the LCNRV rule is applied to the total of inventory? 3. Next Level Comment on any differences that result from applying the LCNRV rule to individual items compared to the total of inventory.
Perpetual and Periodic Inventory Systems Below is a list of inventory systems options. a. Perpetual inventory system b. Periodic inventory system c. Both perpetual and periodic inventory systems Required: Match each option with one of the following: 1. Only revenue is recorded as sales are made during the period; the cost of goods sold is recorded at the end of the period. 2. Cost of goods sold is determined as each sale is made. 3. Inventory purchases are recorded in an inventory account. 4. Inventory purchases are recorded in a purchases account. 5. Cost of goods sold is determined only at the end of the period by subtracting the cost of ending inventory from the cost of goods available for sale. 6. Both revenue and cost of goods sold are recorded during the period as sales are made. 7. The inventory is verified by a physical count.
When inventory items are highly specialized, the best inventory costing method is ________. A. specific identification B. first-in, first-out C. last-in, first-out D. weighted average
( Appendix 6B) Inventory Costing Methods: Periodic Inventory System The inventory accounting records for Lee Enterprises contained the following data: Required: 1. Calculate the cost of ending inventory and the cost of goods sold using the FIFO, LIFO, and average cost methods. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.) 2. CONCEPTUAL CONNECTION Compare the ending inventory and cost of goods sold computed under all three methods. What can you conclude about the effects of the inventory costing methods on the balance sheet and the income statement?