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 June 15, Dej Company sold merchandise for $2,600 on terms of n/30 to Musan Company. On June 20, Musan Company returned some of the merchandise for a credit of $600, and on June 25, Musan paid the...
-
Convert each of the following to a numeral in the base indicated. 6652 to base 12
-
Discuss the themes, theory, and/or phenomenon that would be anticipated to emerge as a result of the examination. Develop a hypothetical research scenario that would necessitate the use of the Action...
-
For the past several years, Abby Brown has operated a part-time consulting business from her home. As of June 1, 2012, Abby decided to move to rented quarters and to operate the business, which was...
-
Problem 1: JIT Setup Cost and Time Suppose that Roger, a production manager, is trying to run JIT. The product Annual Demand is 300,000 units, with 250 working days in a year, which means daily...
-
Search the Internet or Strayer databases for a company with a financial restatement from within the last 12 months. 1.Evaluate the contributing factors to the financial statement restatement. Explain...
-
Explain how you would use the five tips to track the economy to form an outlook of the economy and job market you are hoping to enter after finishing your education. Go online to find data that will...
-
At a family gathering, one of your cousins says, We spend so much more on imports than other countries spend on our exports. It isnt fair and we should raise tariffs on imports to reduce how much we...
-
In January 2019, inflation expectations in the United Kingdom fell from 2.9% to 2.6%. What effect will this have on inflation in the United Kingdom if nothing else changes in the economy? Explain...
-
Spending on Medicare and Social Security is expected to grow over the next few decades as the share of the population who are elderly grows. Explain why an aging population increases government...
-
Determine whether each of the following is an example of an import, export, financial inflow, or financial outflow. If it is a financial flow, is it an example of foreign direct investment or of...
-
J. B. Kenton employs Sharla Knox at a salary of $33,100 a year. Kenton is subject to employer Social Security taxes at a rate of 6.2% and Medicare taxes at a rate of 1.45% on Knox's salary. In...
-
l ask this second time correnct answer is 38,01 can we look pls Consider a non-conducting rod of length 8.8 m having a uniform charge density 4.5 nC/m. Find the electric potential at P, a...
-
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...
-
Given your response to item 2, how would these measures be useful? What could they be used for? Turnover is costly for organizations. In addition to the direct costs of recruiting, hiring, and...
-
How does New Belgium introduce fun into the workplace? How does having fun keep employees engaged and enthusiastic about their work and the company? Kim Jordan and Jeff Lebesch, the husband and wife...
-
Visit the New Belgium Brewing Web site (www.newbelgium.com) to learn more about the company. The company has a strong culture that values environmental sustainability. Here are its core beliefs: We...
Study smarter with the SolutionInn App