Units Required: Determine the cost assigned to ending inventory and to cost of goods sold using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Units Required: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Date Activities Units Acquired at Cost Units Sold at Retail Selling Total Sales price per unit Cost per unit Total cost Units January 01 Beginning inventory 160 $8.50 $1,360.00 January 09 Sales 120 $17.50 $2,100.00 January 19 Purchase 100 $7.50 750.00 January 25 Sales 120 $17.50 2,100.00 January 30 Purchase Totals 240 500 $7.00 1,680.00 $3,790.00 240 $4,200.00 Perpetual FIFO Units available 160 units from beginning inventory 100 units purchased on January 19 240 units purchased on January 30 Cost of Goods Sold - Jan 9 Units Cost Cost of per unit goods sold Cost of Goods Sold - Jan 25 Units Cost Cost of per unit goods sold Ending Inventory Units Cost per unit Inventory $8.50 $8.50 $8.50 $7.50 $7.50 $7.50 $7.00 $7.00 $7.00 Totals 0 $0.00 0 $0.00 0 $0.00 Your Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. Required: Determine the cost assigned to ending inventory and cost of goods sold using FIFO and LIFO. Date Units Acquired at Cost Activities Units Cost Total cost Units per unit Units Sold at Retail Selling price per unit Total Sales January 01 Beginning inventory 160 $8.50 $1,360.00 January 09 January 19 Sales 120 $17.50 $2,100.00 Purchase 100 $7.50 750.00 January 25 Sales 120 $17.50 2,100.00 January 30 Purchase 240 $7.00 Totals 500 1,680.00 $3,790.00 240 $4,200.00 ACCT 1100 Review Assignment i 14 Saved Your Company reported the following January purchases and sales data for its only product. The Company uses a perpetual Inventory system. Date 10.5 points January 1 January 9 January 19 January 25 Activities Beginning inventory Sales Purchase Sales Units Acquired at Cost 160 units @ $ 8.50 = Units sold at Retail $ 1,360 120 units @ $ 17.50 100 units @ $ 7.50 = 750 120 units සි $ 17.50 January 30 Purchase Totals 240 units $ 7.00 = 500 units 1,680 $ 3,790 240 units eBook Required: Hint References 1. Determine the cost assigned to ending Inventory and to cost of goods sold using FIFO. 2. Determine the cost assigned to ending Inventory and to cost of goods sold using LIFO. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Open Excel in new tab Units Required: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Date Activities Units Acquired at Cost Units Sold at Retail Selling Total Sales price per unit Cost per unit Total cost Units January 01 Beginning inventory 160 $8.50 $1,360.00 January 09 Sales 120 $17.50 $2,100.00 January 19 Purchase 100 $7.50 750.00 January 25 Sales 120 $17.50 2,100.00 January 30 Purchase Totals 240 500 $7.00 1,680.00 $3,790.00 240 $4,200.00 Perpetual FIFO Units available 160 units from beginning inventory 100 units purchased on January 19 240 units purchased on January 30 Cost of Goods Sold - Jan 9 Units Cost Cost of per unit goods sold Cost of Goods Sold - Jan 25 Units Cost Cost of per unit goods sold Ending Inventory Units Cost per unit Inventory $8.50 $8.50 $8.50 $7.50 $7.50 $7.50 $7.00 $7.00 $7.00 Totals 0 $0.00 0 $0.00 0 $0.00 Your Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. Required: Determine the cost assigned to ending inventory and cost of goods sold using FIFO and LIFO. Date Units Acquired at Cost Activities Units Cost Total cost Units per unit Units Sold at Retail Selling price per unit Total Sales January 01 Beginning inventory 160 $8.50 $1,360.00 January 09 January 19 Sales 120 $17.50 $2,100.00 Purchase 100 $7.50 750.00 January 25 Sales 120 $17.50 2,100.00 January 30 Purchase 240 $7.00 Totals 500 1,680.00 $3,790.00 240 $4,200.00 ACCT 1100 Review Assignment i 14 Saved Your Company reported the following January purchases and sales data for its only product. The Company uses a perpetual Inventory system. Date 10.5 points January 1 January 9 January 19 January 25 Activities Beginning inventory Sales Purchase Sales Units Acquired at Cost 160 units @ $ 8.50 = Units sold at Retail $ 1,360 120 units @ $ 17.50 100 units @ $ 7.50 = 750 120 units සි $ 17.50 January 30 Purchase Totals 240 units $ 7.00 = 500 units 1,680 $ 3,790 240 units eBook Required: Hint References 1. Determine the cost assigned to ending Inventory and to cost of goods sold using FIFO. 2. Determine the cost assigned to ending Inventory and to cost of goods sold using LIFO. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Open Excel in new tab
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
A study of job satisfaction was conducted for four occupations: cabinetmaker, lawyer, physical therapist, and systems analyst. Job satisfaction was measured on a scale of 0 00. The data obtained are...
-
Assume that global lightning on the Earth constitutes a constant current of 1.00 kA between the ground and an atmospheric layer at potential 260 kV. (a) Find the power of terrestrial lightning. (b)...
-
On April 15, Campeche Company sold merchandise to Walters Company for $3,000 on terms of 2/10, n/30. Assume a return of merchandise on April 20 of $600, and collection in full on April 25. What is...
-
Describe the functions of red and yellow bone marrow.
-
What is a statute of limitations? What is the statute of limitations for negligence actions in California?
-
Amalgamated Products has three operating divisions: To estimate the cost of capital for each division, Amalgamated has identified the following three principal competitors: Assume these betas are...
-
What is the dollar cost of the trust receipt loan? Which plan would be recommended and why? If the firm made a purchase of $124000 with terms 1/10 net 30 would it increase the firm's profitability to...
-
What are the national taxes and local taxes in the Philippines and what are the laws governing them? Explain each.
-
The research of Mintzberg and others concludes that managers ____________. (a) work at a leisurely pace (b) have blocks of private time for planning (c) are never free from the pressures of...
-
The managers role in the upside-down pyramid view of organizations is best described as providing ____________ so that workers can directly serve ____________. (a) direction, top management (b)...
-
Resource acquisition and customer satisfaction are important when an organization is viewed as a(n) ____________. (a) bureaucracy (b) closed system (c) open system (d) pyramid
-
Explain how accountability operates in the relationship between (a) a team leader and her team members, and (b) the same team leader and her boss.
-
The highest level in Maslows hierarchy includes ____________ needs. (a) safety (b) esteem (c) self-actualization (d) physiological
-
A battery of cylindrical hollow-fiber membranes is operated at steady state to concentrate a bacterial suspension from a fermenter. 350 kg/min fermenter broth is pumped through a stack of...
-
Represent each of the following combination of units in the correct SI form using an appropriate prefix: (a) m/ms, (b) k m, (c) k s /mg, and (d) k m N.
-
The following transactions are February activities of Swing Hard Incorporated, which offers golfing lessons in the northeastern United States. For each of the following transactions, complete the...
-
Frigid Supplies reported beginning inventory of 200 units, for a total cost of $ 2,000. The company had the following transactions during the month: Jan. 3 Sold 20 units on account at a selling price...
-
Valeri is opening a hair salon but she does not know what business form it should take. What can you tell her about the advantages and disadvantages of operating as a sole proprietorship versus a...
-
Consider the binary variable version of the fixed effects model in Equation (10.11) except with an additional regressor, \(D 1_{i}\); that is, let \[ Y_{i t}=\beta_{0}+\beta_{1} X_{i t}+\gamma_{1} D...
-
Using the regression in Equation (10.11), what are the slope and intercept for a. Entity 1 in time period 1? b. Entity 1 in time period 3? c. Entity 3 in time period 1? d. Entity 3 in time period 3?...
-
Do the fixed effects regression assumptions in Key Concept 10.3 imply that \(\operatorname{cov}\left(\widetilde{v}_{i t}, \widetilde{v}_{i s} ight)=0\) for \(t eq s\) in Equation (10.28)? Explain....
Study smarter with the SolutionInn App