Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The beginning inventory of merchandise at Keats Office Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Number

The beginning inventory of merchandise at Keats Office Supplies and data on purchases and sales for a three-month period are as follows:

Date Transaction Number of Units Per Unit Total
March 3 Inventory 36 $525 $18,900
8 Purchase 72 630 45,360
11 Sale 48 1,750 84,000
30 Sale 30 1,750 52,500
April 8 Purchase 60 700 42,000
10 Sale 36 1,750 63,000
19 Sale 18 1,750 31,500
28 Purchase 60 770 46,200
May 5 Sale 36 1,840 66,240
16 Sale 48 1,840 88,320
21 Purchase 108 840 90,720
28 Sale 54 1,840 99,360

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Keats Office Supplies Schedule of Cost of Merchandise Sold LIFO Method For the three months ended May 31, 2016
Purchases Cost of Merchandise Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Mar. 3 $ $
Mar. 8 $ $
Mar. 11 $ $
Mar. 30
Apr. 8
Apr. 10
Apr. 19
Apr. 28
May 5
May 16
May 21
May 28
May 31 Balances $ $

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

Total sales $
Total cost of merchandise sold $
Gross profit from sales $

3. Determine the ending inventory cost as of May 31, 2016. $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Other Assurance Services

Authors: Alvin Arens, James Loebbecke, W Lemon, Ingrid Splettstoesser

9th Canadian Edition

0130091243, 978-0130091246

More Books

Students also viewed these Accounting questions

Question

1. How does the WTO stimulate growth in international tourism?

Answered: 1 week ago

Question

=+ (c) Show that the Bernoulli shift is mixing.

Answered: 1 week ago