Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i just need the questions answered, I attached the information needed. 3 MASTER INVENTORY RECORD 4 Description (Shelves) # of Units Cost per unit Total
i just need the questions answered, I attached the information needed. 3 MASTER INVENTORY RECORD 4 Description (Shelves) # of Units Cost per unit Total cost 5 400 Beginning inventory Jan 15 purchase 20 $ 27 $ 20.00 22.00 6 594 7 30.00 8 Jan 20 purchase Total Inventory January Sales Ending Inventory 33 $ 80 36 990 1984 answer will be on 9 10 44 each schedule below 11 **Use formulas for these cells 12 16 Calculate the Ending Inventory and Cost of Goods Sold using Periodic FIFO 17 18 19 FIFO Ending Inventory # of Units Cost per unit 11 $ 22.00 33 $ 30.00 Description Jan 15 purchase Jan 20 purchase Total cost 242 990 20 21 22 23 24 Total 1232 25 26 44 FIFO Cost of Goods Sold # of Units Cost per unit 20 $ 20.00 16 $ 22.00 Description Beginning inventory Jan 15 purchase 27 Total cost 400 352 28 29 30 31 Total 36 752 33 Calculate the Ending Inventory and cost of Goods Sold using Periodic LIFO 34 35 36 37 Description Jan 15 purchase Beginning inventory LIFO Ending Inventory #of Units Cost per unit 24 $ 22.00 20 $ 20.00 Total cost 528 400 38 39 40 41 Total 928 42 43 44 LIFO Cost of Goods Sold # of Units Cost per unit 33 $ 30.00 3 $ 22.00 Description Jan 20 purchase Jan 15 purchase 44 Total cost 990 66 45 46 47 48 Total 36 1056 49 50 Calculate the Ending Inventory and cost of Goods Sold using Periodic Weighted Average 51 52 59 WEIGHTED AVERAGE Ending Inventory # of units Cost per unit 44 24.8 Description Ending Inventory Total cost 54 1091.2 55 56 57 58 59 Total 44 1091.2 60 61 62 WEIGHTED AVERAGE Cost of Goods Sold # of units Cost per unit 36 24.8 Description January Sales Total cost 63 892.8 64 65 66 67 60 69 70 71 Total 36 892.8 72 C. Answer the following questions: Which method provides the highest net income? Which method provides the largest asset value on the Balance Sheet? Are your answers always true? Explain. Which method would you choose? Explain
i just need the questions answered, I attached the information needed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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