Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in the missing amounts for items (a) through (o) as well as a1 through m1 in the following perpetual inventory records: Calculate the cost
Fill in the missing amounts for items (a) through (o) as well as a1 through m1 in the following perpetual inventory records:
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.)
Purchases | Cost of Goods Sold | Balance | ||||||||||||||||||||||
Date | Units | Cost | Total | Units | Cost | Total | Units | Cost | Total | Units | Total Cost | WA Cost Per unit | ||||||||||||
Apr-01 | Beginning Inventory | |||||||||||||||||||||||
29 | $12 | $348 | 29 | $12 | $348 | |||||||||||||||||||
Apr-15 | 47 | $14 | $658 | $ | $ | 29 | $348 | |||||||||||||||||
47 | $658 | |||||||||||||||||||||||
$ | $ | |||||||||||||||||||||||
Apr-20 | 34 | $ | $ | $ | $ | 76 | $1,006 | |||||||||||||||||
-34 | $450.16 | |||||||||||||||||||||||
$ | $ | |||||||||||||||||||||||
Apr-23 | 42 | $15 | $630 | 84 | $ | $ | 42 | $555.84 | ||||||||||||||||
42 | $630 | |||||||||||||||||||||||
$ | $ | |||||||||||||||||||||||
Apr-28 | 47 | $ | $ | 37 | $ | $ | 84 | $1,185.84 | ||||||||||||||||
-47 | $663.64 | |||||||||||||||||||||||
37 | $ | $ | ||||||||||||||||||||||
118 | $1,636 | 81 | $ | 37 | $522.20 |
Calculate the cost of goods sold and ending inventory using FIFO. (HINT: Use two rows to show your cost of goods sold calculation in layers)
Purchases | Cost of Goods Sold | Inventory Balance | ||||||||||||||||
Date | Units | Cost | Total | Units | Cost | Total | Units | Cost | Total | |||||||||
Apr-01 | Beginning Inventory | |||||||||||||||||
29 | $12 | $348 | 29 | $12 | $348 | |||||||||||||
Apr-15 | 47 | $14 | $658 | 29 | $12 | 348 | ||||||||||||
$ | $ | |||||||||||||||||
Apr-20 | 34 - 29 | $ | $ | |||||||||||||||
5 | $ | $ | $ | $ | ||||||||||||||
Apr-23 | 42 | $15 | $630 | $ | $ | |||||||||||||
$ | $ | |||||||||||||||||
Apr-28 | 47 - 42 | $ | $ | |||||||||||||||
5 | $ | $ | 37 | $ | $ | |||||||||||||
118 | $1,636 | 81 | $ | 37 | $555 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started