Question

In: Accounting

Skiller Company has the following information regarding its inventory for the second year of operations. Transactions...

Skiller Company has the following information regarding its inventory for the second year of operations.

Transactions Units Sales in units Unit Cost
Beginning Inventory, January 1 35,000 $3.50
Purchases
February 8 45,500 3.60
March 15 100,250 3.80
April 10 62,000 4.10
Units sold- April 22 at $12 155,000
Purchases
May 9 81,000 4.35
June 19 28,000 4.56
Units sold- August 11 at $14 115,000
Purchases
September 30 15,000 4.75
October 30 41,000 4.85
November 17 8,000 4.90
Units sold-December 21 at $16 21,500

A. Compute the ending inventory and cost of goods sold under each of the following cost-flow assumptions assuming a perpetual inventory system. (Round your answers to two decimal places.)

Cost-flow assumption Ending Inventory Cost of Goods Sold Gross Profit
FIFO
LIFO
Moving Average

B. Compute the ending inventory and cost of goods sold under each of the following cost-flow assumptions assuming a periodic inventory system. (Round your answers to two decimal places).

Cost-flow assumption Ending Inventory Cost of Goods Sold Gross Profit
FIFO
LIFO
Weighted Average

Solutions

Expert Solution

Ans. Calculation of Total Sales:
Date Units Rate Total
22-Apr 155000 12 1860000
11-Aug 115000 14 1610000
21-Dec 21500 16 344000
Total sales 291500 3814000
Ans.A 1 Perpetual FIFO:
Purchase Cost of goods sold Balance
Date Quantity Rate Total cost Quantity Rate Total cost Quantity Rate Total cost
1-Jan 35000 3.5 122500
8-Feb 45500 3.6 163800 35000 3.5 122500
45500 3.6 163800
15-Mar 100250 3.8 380950 35000 3.5 122500
45500 3.6 163800
100250 3.8 380950
10-Apr 62000 4.1 254200 35000 3.5 122500
45500 3.6 163800
100250 3.8 380950
62000 4.1 254200
22-Apr 35000 3.5 122500
45500 3.6 163800
74500 3.8 283100 25750 3.8 97850
62000 4.1 254200
9-May 81000 4.35 352350 25750 3.8 97850
62000 4.1 254200
81000 4.35 352350
19-Jun 28000 4.56 127680 25750 3.8 97850
62000 4.1 254200
81000 4.35 352350
28000 4.56 127680
11-Aug 25750 3.8 97850
62000 4.1 254200
27250 4.35 118537.5 53750 4.35 233812.5
28000 4.56 127680
30-Sep 15000 4.75 71250 53750 4.35 233812.5
28000 4.56 127680
15000 4.75 71250
30-Oct 41000 4.85 198850 53750 4.35 233812.5
28000 4.56 127680
15000 4.75 71250
41000 4.85 198850
17-Nov 8000 4.9 39200 53750 4.35 233812.5
28000 4.56 127680
15000 4.75 71250
41000 4.85 198850
8000 4.9 39200
21-Dec
21500 4.35 93525 32250 4.35 140287.5
28000 4.56 127680
15000 4.75 71250
41000 4.85 198850
8000 4.9 39200
Total Cost of goods sold 1133512.5 Ending inventory 577267.5
Ans.2 PERPETUAL LIFO:
Purchase Cost of goods sold Balance
Date Quantity Rate Total cost Quantity Rate Total cost Quantity Rate Total cost
1-Jan 35000 3.5 122500
8-Feb 45500 3.6 163800 35000 3.5 122500
45500 3.6 163800
15-Mar 100250 3.8 380950 35000 3.5 122500
45500 3.6 163800
100250 3.8 380950
10-Apr 62000 4.1 254200 35000 3.5 122500
45500 3.6 163800
100250 3.8 380950
62000 4.1 254200
22-Apr 62000 4.1 254200
93000 3.8 353400 35000 3.5 122500
45500 3.6 163800
7250 3.8 27550
9-May 81000 4.35 352350 35000 3.5 122500
45500 3.6 163800
7250 3.8 27550
81000 4.35 352350
19-Jun 28000 4.56 127680 35000 3.5 122500
45500 3.6 163800
7250 3.8 27550
81000 4.35 352350
28000 4.56 127680
11-Aug 28000 4.56 127680
81000 4.35 352350
6000 3.8 22800 35000 3.5 122500
45500 3.6 163800
1250 3.8 4750
30-Sep 15000 4.75 71250 35000 3.5 122500
45500 3.6 163800
1250 3.8 4750
15000 4.75 71250
30-Oct 41000 4.85 198850 35000 3.5 122500
45500 3.6 163800
1250 3.8 4750
15000 4.75 71250
41000 4.85 198850
17-Nov 8000 4.9 39200 35000 3.5 122500
45500 3.6 163800
1250 3.8 4750
15000 4.75 71250
41000 4.85 198850
8000 4.9 39200
21-Dec 8000 4.9 39200
13500 4.85 65475 35000 3.5 122500
45500 3.6 163800
1250 3.8 4750
15000 4.75 71250
27500 4.85 133375
Total Cost of goods sold 1215105 Ending inventory 495675
Ans.A 3 Weighted Average method:
Purchase Cost of goods sold Balance
Date Quantity Rate Total cost Quantity Rate Total cost Quantity Rate Total cost
1-Jan 35000 3.5 122500
8-Feb 45500 3.6 163800 80500 3.56 286300
15-Mar 100250 3.8 380950 180750 3.69 667250
10-Apr 62000 4.1 254200 242750 3.80 921450
22-Apr 155000 3.8 589000 87750 3.79 332450
9-May 81000 4.35 352350 168750 4.06 684800
19-Jun 28000 4.56 127680 196750 4.13 812480
11-Aug 115000 4.13 474950 81750 4.13 337530
30-Sep 15000 4.75 71250 96750 4.23 408780
30-Oct 41000 4.85 198850 137750 4.41 607630
17-Nov 8000 4.9 39200 145750 4.44 646830
21-Dec 21500 4.44 95460 124250 4.44 551370
Total Cost of goods sold 1159410 Ending inventory 551370
FIFO LIFO Moving Avg.
Sales 3814000 3814000 3814000
less: Cost of goods sold 1133512.5 1215105 1159410
Gross profit 2680487.5 2598895 2654590
Ans.B Available for Sales:
Date Units Rate Total
1-Jan 35000 3.5 122500
8-Feb 45500 3.6 163800
15-Mar 100250 3.8 380950
10-Apr 62000 4.1 254200
9-May 81000 4.35 352350
19-Jun 28000 4.56 127680
30-Sep 15000 4.75 71250
30-Oct 41000 4.85 198850
17-Nov 8000 4.9 39200
Total 415750 1710780
Ans.B 1 No. of units sold = (155000+115000+21500) = 291500
FIFO:    (Cost of Goods Sold)
Date Units Rate Total
1-Jan 35000 3.5 122500
8-Feb 45500 3.6 163800
15-Mar 100250 3.8 380950
10-Apr 62000 4.1 254200
9-May 48750 4.35 212062.5
Total 291500 1133512.5
Cost of ending inventory = Total cost of goods available for sale - Cost of goods sold
1710780 - 1133512.5
577267.5
Ans.B 2 LIFO:    (Cost of Goods Sold)
Date Units Rate Total
17-Nov 8000 4.9 39200
30-Oct 41000 4.85 198850
30-Sep 15000 4.75 71250
19-Jun 28000 4.56 127680
9-May 81000 4.35 352350
10-Apr 62000 4.1 254200
15-Mar 56500 3.8 214700
Total 291500 1258230
Cost of ending inventory = Total cost of goods available for sale - Cost of goods sold
1710780 - 1258230
452550
Ans.B 3
Weighted average cost per unit = Total cost of goods available for sale / Total units available
1710780 / 415750
4.11
Cost of goods sold = No. of units sold * Average cost per unit
291500 * 4.11
1198065
Cost of ending inventory = Total cost of goods available for sale - Cost of goods sold
1710780 - 1198065
512715
FIFO LIFO Moving Avg.
Sales 3814000 3814000 3814000
less: Cost of goods sold 1133512.5 1258230 1198065
Gross profit 2680487.5 2555770 2615935

Related Solutions

The following transactions pertain to Year 1, the first-year operations of Baird Company. All inventory was...
The following transactions pertain to Year 1, the first-year operations of Baird Company. All inventory was started and completed during Year 1. Assume that all transactions are cash transactions. Acquired $4,000 cash by issuing common stock. Paid $700 for materials used to produce inventory. Paid $1,830 to production workers. Paid $862 rental fee for production equipment. Paid $110 to administrative employees. Paid $120 rental fee for administrative office equipment. Produced 320 units of inventory of which 230 units were sold...
The following transactions pertain to Year 1, the first-year operations of Baird Company. All inventory was...
The following transactions pertain to Year 1, the first-year operations of Baird Company. All inventory was started and completed during Year 1. Assume that all transactions are cash transactions. 1.Acquired $4,000 cash by issuing common stock. 2.Paid $700 for materials used to produce inventory. 3.Paid $1,830 to production workers. 4.Paid $862 rental fee for production equipment. 5.Paid $110 to administrative employees. 6.Paid $120 rental fee for administrative office equipment. 7.Produced 320 units of inventory of which 230 units were sold...
The following transactions pertain to Year 1, the first-year operations of Rooney Company. All inventory was...
The following transactions pertain to Year 1, the first-year operations of Rooney Company. All inventory was started and completed during Year 1. Assume that all transactions are cash transactions. Acquired $4,600 cash by issuing common stock. Paid $680 for materials used to produce inventory. Paid $1,800 to production workers. Paid $848 rental fee for production equipment. Paid $100 to administrative employees. Paid $117 rental fee for administrative office equipment. Produced 320 units of inventory of which 220 units were sold...
Packard Company began operations on 1/1/04. For its second year of operations, 2005, it has the...
Packard Company began operations on 1/1/04. For its second year of operations, 2005, it has the following activity: Pretax financial income $250,000 Municipal interest 5,000 Accrual of warranty costs in excess of amounts paid - expected to reverse next year 10,000 Percentage depletion in excess of cost depletion 37,500 In addition to the foregoing, Packard received $25,000 of rents in 2005 of which $15,000 remained unearned as of December 31, 2005. It is anticipated that the remaining amount will be...
The following transactions pertain to 2018, the first-year operations of Gibson Company. All inventory was started...
The following transactions pertain to 2018, the first-year operations of Gibson Company. All inventory was started and completed during 2018. Assume that all transactions are cash transactions. Acquired $12,000 cash by issuing common stock. Paid $4,700 for materials used to produce inventory. Paid $2,400 to production workers. Paid $900 rental fee for production equipment. Paid $350 to administrative employees. Paid $400 rental fee for administrative office equipment. Produced 400 units of inventory of which 360 units were sold at a...
The following transactions pertain to 2018, the first-year operations of Solomon Company. All inventory was started...
The following transactions pertain to 2018, the first-year operations of Solomon Company. All inventory was started and completed during 2018. Assume that all transactions are cash transactions. Acquired $4,400 cash by issuing common stock. Paid $710 for materials used to produce inventory. Paid $1,910 to production workers. Paid $882 rental fee for production equipment. Paid $120 to administrative employees. Paid $116 rental fee for administrative office equipment. Produced 340 units of inventory of which 260 units were sold at a...
Packard Company engaged in the following transactions during Year 1, its first year of operations:
Packard Company engaged in the following transactions during Year 1, its first year of operations: (Assume all transactions are cash transactions.)1) Acquired $950 cash from the issue of common stock.2) Borrowed $420 from a bank.3) Earned $650 of revenues.4) Paid expenses of $250.5) Paid a $50 dividend.During Year 2, Packard engaged in the following transactions: (Assume all transactions are cash transactions.)1) Issued an additional $325 of common stock.2) Repaid $220 of its debt to the bank.3) Earned revenues of $750.4)...
Simmons Company has the following information about its ending inventory. It values its inventory on an...
Simmons Company has the following information about its ending inventory. It values its inventory on an individual-item basis. Determine the value of the ending inventory. Show your work. Item Quantity Cost Estimated Selling Price Cost to Complete and Sell A 700 $2.25 $3.25 $1.40 B 500 3.00 3.90 0.80 C 3,000 1.80 2.50 1.20 D 1,000 4.70 6.00 1.50
The following information pertains to the inventory transactions for La Madeline Company for Year XXXX. January...
The following information pertains to the inventory transactions for La Madeline Company for Year XXXX. January 1 Beginning inventory 500 units @$20 per unit April 1 Purchased inventory 2,500 units @ $25 per unit October 1 Purchased inventory 800 units @ $26 per unit During the year, La Madeline sold 3,400 units of inventory @ $50 per unit and incurred $16,000 of operating expense. La Madeline currently uses the FIFO method but is considering a change to LIFO. Assume that...
During its first year of operations, a company entered into the following transactions: - Borrowed $5,160...
During its first year of operations, a company entered into the following transactions: - Borrowed $5,160 from the bank by signing a promissory note. - Issued stock to owners for $11,600. - Purchased $1,160 of supplies on account. - Paid $560 to suppliers as payment on account for the supplies purchased. 1) what is the amount of total assets at the end of the year? 2) What is the amount of total liabilities at the end of the year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT