SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.

Order a Similar Paper Order a Different Paper

During April, Leary Company sold 1,000 units of Product Q. Product Q’s beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.)

Assignment Template attached below.

April 1 Beginning inventory 200 units @ $1
April 5 Purchases 200 units @ $2
April 10 Purchases 200 units @ $3
April 15 Purchases 200 units @ $4
April 20 Purchases 200 units @ $5
April 25 Purchases 200 units @ $6

Required: Use the periodic inventory system to answer the following questions.

  1. Compute the total units available for sale.
  2. Compute the total cost of the units available for sale.
  3. Compute the FIFO cost of goods sold (COGS) in dollars.
  4. Compute the FIFO ending inventory (EI) in dollars.
  5. Compute the LIFO COGS in dollars.
  6. Compute the LIFO EI in dollars.
  7. Compute the weighted average COGS in dollars.
  8. Compute the weighted average EI in dollars.
  9. Prove the sum of COGS and EI for each method equals the goods available for sale for both units and dollars.
  10. Compute the gross profit (GP) for each method assuming the 1000 units were sold for $10 each.


Complete this assignment using an Excel spreadsheet, and date and explain each entry on your deliverable.

"Is this question part of your assignment? We can help"


Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order

Order a Similar Paper Order a Different Paper