Question

In: Accounting

Use the transactions below to answer the following questions. Round to the nearest cent for per...

Use the transactions below to answer the following questions. Round to the nearest cent for per unit cost and the nearest dollar for the totals for COGS, Ending Inventory and Gross Profit.

Date Quantity Unit Cost Sale Price
Mar 1 Beginning Inventory 30 $30
Mar 4 Purchase 40 $28
Mar 8 Sale 35 $54
Mar 15 Purchase 50 $26
Mar 20 Sale 42 $55

Using the LIFO Method for inventory costing calculate the following amounts for the month of March. Enter the amount without dollar signs, commas or decimals, i.e. 123 instead of $123 or 123.00.

Total Cost of Goods Sold for March:

Total Cost of Ending Inventory at the end of March:

Solutions

Expert Solution

Answer)

Calculation of cost of goods sold and value of ending inventory using LIFO method

Date

Purchase

Cost of Goods sold

Balance inventory

Quantity

Cost per unit (In $)

Total Cost (in $)

Quantity

Cost per unit (In $)

Total Cost (in $)

Quantity

Cost per unit (In $)

Total Cost (in $)

Mar'1

30

30

            900

Mar'4

40

28

         1,120

30

30

            900

40

28

         1,120

Mar'8

35

28

            980

30

30

            900

5

28

            140

Mar'15

50

26

         1,300

30

30

            900

5

28

            140

50

26

         1,300

Mar'20

42

26

         1,092

30

30

            900

5

28

            140

8

26

            208

Total

90

         2,420

77

         2,072

43

       1,248

Under LIFO method cost of goods sold is $ 2,072 and value of ending inventory is $ 1,248.


Related Solutions

For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent:...
For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent: ​Employee: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​% up to $200,000​, 2.35​% on earnings above $200,000. ​Employer: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​%; ​FUTA: 0.6​% on first $7,000 ​earned; SUTA: 5.4​% on first $7,000 earned. Robinson works at College of Boston and is paid $30 per hour for a​ 40-hour workweek and​ time-and-a-half for hours above 40. For all payroll​ calculations,...
Journalize the transactions​ (explanations are not​ required). ​(Round all amounts to the nearest cent. Record debits​...
Journalize the transactions​ (explanations are not​ required). ​(Round all amounts to the nearest cent. Record debits​ first, then credits. Exclude explanations from journal​ entries.) Trevor Publishing completed the following transactions during 2016 Oct 1   Sold a​ six-month subscription​ (starting on November​ 1), collecting cash of $390 ​, plus sales tax of 4 % Nov 15 Remitted​ (paid) the sales tax to the state of Tennessee. Dec 31 Made the necessary adjustment at​ year-end to record the amount of subscription revenue...
Find the present value PV of the given investment. (Round your answer to the nearest cent.)...
Find the present value PV of the given investment. (Round your answer to the nearest cent.) An investment earns 3% per year and is worth $80,000 after 8 years. PV=
PLEASE ROUND TO THE NEAREST CENT FOR FINAL ANSWER Compare the monthly payments and total loan...
PLEASE ROUND TO THE NEAREST CENT FOR FINAL ANSWER Compare the monthly payments and total loan costs for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$130,000 loan. Option​ 1: a​ 30-year loan at an APR of 9.5​%. Option​ 2: a​ 15-year loan at an APR of 8.5%. -------------------------------------------------------------------- 1.) Find the monthly payment for each option. The monthly payment for option 1 is what? The...
Calculate the present value of the annuity. (round your answer to the nearest cent.) $1800 monthly...
Calculate the present value of the annuity. (round your answer to the nearest cent.) $1800 monthly at 6.1% for 30 years. Determine the payment to amortize the debt. (round your answer to the nearest cent.) Monthly payments on $170,000 at 3% for 25 years.
Determine the payment to amortize the debt. (round your answer to the nearest cent.) Quartey payments...
Determine the payment to amortize the debt. (round your answer to the nearest cent.) Quartey payments on $15,500 at 3.5% for 6 years. Find the unpaid balance on the debt. (Round your answer to the nearest cent) After 7 years of monthly payments on $180,000 at 3% for 25 years.
1. Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After...
1. Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 5 years of monthly payments on $150,000 at 3% for 25 years. 2. Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $11,500 at 3.6% for 6 years. $ 3. Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Monthly payments on $140,000 at 4% for 25 years. $
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7...
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7 years of monthly payments on $150,000 at 4% for 25 years.
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7...
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7 years of monthly payments on $150,000 at 5% for 25 years.
Compute the weighted average (round to the nearest cent) for the following table of values: x...
Compute the weighted average (round to the nearest cent) for the following table of values: x f(x) $ 5 25 $ 20 11 $ 30 8 $ 75 3 $ 100 1 Also, what is the median dollar value from this data? Compute the geometric mean return (rounded to 4 decimal places) for the following: Year Return 1 15% 2 -20% 3 30% 4 -8% 5 25% If you invested $1,200, how much would it be worth after 5 years...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT