In: Accounting
Required information
[The following information applies to the questions
displayed below.]
Laker Company reported the following January purchases and sales data for its only product.
| Date | Activities | Units Acquired at Cost | Units sold at Retail | |||||||||||||||
| Jan. | 1 | Beginning inventory | 160 | units | @ | $ | 8.50 | = | $ | 1,360 | ||||||||
| Jan. | 10 | Sales | 120 | units | @ | $ | 17.50 | |||||||||||
| Jan. | 20 | Purchase | 100 | units | @ | $ | 7.50 | = | 750 | |||||||||
| Jan. | 25 | Sales | 120 | units | @ | $ | 17.50 | |||||||||||
| Jan. | 30 | Purchase | 220 | units | @ | $ | 7.00 | = | 1,540 | |||||||||
| Totals | 480 | units | $ | 3,650 | 240 | units | ||||||||||||
The Company uses a perpetual inventory system. For specific
identification, ending inventory consists of 240 units, where 220
are from the January 30 purchase, 5 are from the January 20
purchase, and 15 are from beginning inventory.
Required:
1. Complete comparative income statements for the month of
January for Laker Company for the four inventory methods. Assume
expenses are $1,450, and that the applicable income tax rate is
40%. (Round your Intermediate calculations to 2 decimal
places.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I need the weighted average!!!!!
| W Avg. | Purchases | Cost of Goods Sold | Ending Balance | |||||||
| Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
| Jan-01 | Beginning Inventory | 160 | $ 8.50 | $ 1,360 | ||||||
| Jan-10 | Sales | 120 | $ 8.50 | $ 1,020 | 40 | $ 8.50 | $ 340 | |||
| Jan-20 | Purchase | 100 | $ 7.50 | $ 750 | 40 | $ 8.50 | $ 340 | |||
| 100 | $ 7.50 | $ 750 | ||||||||
| 140 | $ 7.79 | $ 1,090 | ||||||||
| Jan-25 | Sales | 120 | $ 7.79 | $ 935 | 20 | $ 7.75 | $ 155 | |||
| Jan-30 | Purchase | 220 | $ 7.00 | $ 1,540 | 20 | $ 7.75 | $ 155 | |||
| 220 | $ 7.00 | $ 1,540 | ||||||||
| Total | 320 | $ 2,290 | 240 | $ 1,955 | 240 | $ 7.06 | $ 1,695 | |||
| Weighted | |
| Average | |
| Sales | $ 4,200 |
| Cost of goods sold | $ 1,955 |
| Gross profit | $ 2,245 |
| Expenses | $ 1,450 |
| Income before taxes | $ 795 |
| Income tax expense | $ 318 |
| Net income | $ 477 |