Please answer all four parts Add-ins ACROBAT Pate Copy Panter B I 1. Lester Comp
ID: 2564574 • Letter: P
Question
Please answer all four parts Add-ins ACROBAT Pate Copy Panter B I 1. Lester Company sellis many products. Hackenbeery is one of its popular items Below is an analysts of the inventory purchases and sales of Hackenbenry of Manch Lester Units Unit Cost Units Selling Price/Un 60 50 200 ss 4 1-Mat Begi 5 3 Mar Purchase 10 Mar Purchase 8 16 Mat Sales 9 19-Mar Sales 10 25 Mar S0 90 60 $90 40 0-Mar Purchase usarg the "'assumption, calculate the amount charged to cest of goods told for March phow computno b) Using the moving average method, calculate the amount assigned to the inventory on hand on Mach Show computation 16 (c) Uung the LFO assumption, caliculate the amount asigned to the inventory on hand on Marth 3.howcomputations (d) show Cont of goods sold, Closing invermory and Geross profit in separate graphs under each of the methosdsExplanation / Answer
a) FIFO :
COGS = 100*$40 + 60*$50 +90*$55 = $11950
b) Moving Average :
MA price at Mar 10 = (MA of Mar 1 & Mar 3 for 90 units + Purchases of Mar 10 ) / 290
= [ (4000+3000) * 90/160 + 200*55 ] / 290 = $51.51
Ending Inventory = $51.51 * 110 + 40 * $65 = $8266.10
c) LIFO :
Ending Inventory = 40 * $65 + 20 * $55 + 90 * $40 = $7300
d) presentation on graph in module is not possible, please.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.