Log in
Accounting
1
answer
0
watching
153
views

LIFO Perpetual Inventory

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

Date Transaction Number
of Units		 Per Unit Total
March 3 Inventory 42 $150 $6,300
8 Purchase 84 180 15,120
11 Sale 56 500 28,000
30 Sale 35 500 17,500
April 8 Purchase 70 200 14,000
10 Sale 42 500 21,000
19 Sale 21 500 10,500
28 Purchase 70 220 15,400
May 5 Sale 42 525 22,050
16 Sale 56 525 29,400
21 Purchase 126 240 30,240
28 Sale 63 525 33,075

Required:

1. Record the inventory, purchases, and cost ofmerchandise sold data in a perpetual inventory record similar tothe one illustrated in Exhibit 4, using the last-in, first-outmethod. If units are in inventory at two different costs, enter theOLDEST units first.

Keats Office Supplies
Schedule of Cost of Merchandise Sold
LIFO Method
For the three months ended May 31, 2014
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 ofmerchandise sold, and the gross profit from sales for theperiod.

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

3. Determine the ending inventory cost as ofMay 31, 2014.
$

Watch
1
answer
0
watching
153
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Jarrod Robel
Jarrod RobelLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

The beginning inventory of merchandise at Keats Office Suppliesand data on purchases and sales for a three-month period are asfollows

Date Transaction Number
of Units		 Per Unit Total
March 3 Inventory 54 $600 $32,400
8 Purchase 108 720 77,760
11 Sale 72 2,000 144,000
30 Sale 45 2,000 90,000
April 8 Purchase 90 800 72,000
10 Sale 54 2,000 108,000
19 Sale 27 2,000 54,000
28 Purchase 90 880 79,200
May 5 Sale 54 2,100 113,400
16 Sale 72 2,100 151,200
21 Purchase 162 960 155,520
28 Sale 81 2,100 170,100



Keats Office Supplies
Schedule of Cost of Merchandise Sold
LIFO Method
For the three months ended May 31, 2014
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 ofmerchandise sold, and the gross profit from sales for theperiod.

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

3. Determine the ending inventory cost as ofMay 31, 2014.

The beginning inventory at Funky Party Supplies and data onpurchases and sales for a three-month period ending March 31, 2016,are as follows:

Date

 Transaction Number of Units PerUnit Total
Jan. 1 Inventory 2,500 $60.00 $150,000
10 Purchase 7,500 68.00 510,000
28 Sale 3,750 120.00 450,000
30 Sale 1,250 120.00 150,000
Feb. 5 Sale 500 120.00 60,000
10 Purchase 18,000 70.00 1,260,000
16 Sale 9,000 125.00 1,125,000
28 Sale 8,500 125.00 1,062,500
Mar. 5 Purchase 15,000 71.60 1,074,000
14 Sale 10,000 125.00 1,250,000
25 Purchase 2,500 72.00 180,000
30 Sale 8,750 125.00 1,093,750
Instructions
1. Record the inventory,purchases, and cost of merchandise sold data in a perpetualinventory record similar to the one illustrated in Exhibit 4, usingthe first-in, first-out method.
2. Determine the total sales andthe total cost of merchandise sold for the period. Journalize theentries in the sales and cost of merchandise sold accounts. Assumethat all sales were on account and date your journal entry March31. Refer to the Chart of Accounts for exact wording of accounttitles.
3. Determine the gross profit fromsales for the period.
4. Determine the ending inventorycost as of March 31, 2016.
5. Based upon the preceding data,would you expect the inventory using the last-in, first-out methodto be higher or lower?

2. Determine the total sales and the total cost of merchandisesold for the period. Journalize the entries in the sales and costof merchandise sold accounts. Assume that all sales were on accountand date your journal entry March 31. Refer to the Chart ofAccounts for exact wording of account titles.

CHARTOF ACCOUNTS
FunkyParty Supplies
General Ledger
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
131 Notes Receivable
132 Interest Receivable
141 Merchandise Inventory
145 Office Supplies
146 Store Supplies
151 Prepaid Insurance
181 Land
191 Office Equipment
192 Accumulated Depreciation-OfficeEquipment
193 Store Equipment
194 Accumulated Depreciation-StoreEquipment
LIABILITIES
210 Accounts Payable
221 Notes Payable
222 Interest Payable
231 Salaries Payable
241 Sales Tax Payable
EQUITY
310 Common Stock
311 Retained Earnings
312 Dividends
313 Income Summary
REVENUE
410 Sales
610 Interest Revenue
EXPENSES
510 Cost of Merchandise Sold
515 Credit Card Expense
516 Cash Short and Over
520 Salaries Expense
531 Advertising Expense
532 Delivery Expense
533 Insurance Expense
534 Office Supplies Expense
535 Rent Expense
536 Repairs Expense
537 Selling Expenses
538 Store Supplies Expense
561 Depreciation Expense-OfficeEquipment
562 Depreciation Expense-StoreEquipment
590 Miscellaneous Expense
710 Interest Expense

The beginning inventory at Funky Party Supplies and data onpurchases and sales for a three-month period ending March 31, 2016,are as follows:

Date

 Transaction Number of Units PerUnit Total
Jan. 1 Inventory 2,500 $60.00 $150,000
10 Purchase 7,500 68.00 510,000
28 Sale 3,750 120.00 450,000
30 Sale 1,250 120.00 150,000
Feb. 5 Sale 500 120.00 60,000
10 Purchase 18,000 70.00 1,260,000
16 Sale 9,000 125.00 1,125,000
28 Sale 8,500 125.00 1,062,500
Mar. 5 Purchase 15,000 71.60 1,074,000
14 Sale 10,000 125.00 1,250,000
25 Purchase 2,500 72.00 180,000
30 Sale 8,750 125.00 1,093,750
Instructions
1. Record the inventory,purchases, and cost of merchandise sold data in a perpetualinventory record similar to the one illustrated in Exhibit 4, usingthe first-in, first-out method.
2. Determine the total sales andthe total cost of merchandise sold for the period. Journalize theentries in the sales and cost of merchandise sold accounts. Assumethat all sales were on account and date your journal entry March31. Refer to the Chart of Accounts for exact wording of accounttitles.
3. Determine the gross profit fromsales for the period.
4. Determine the ending inventorycost as of March 31, 2016.
5. Based upon the preceding data,would you expect the inventory using the last-in, first-out methodto be higher or lower?

X

FIFO

1. Record the inventory, purchases, and cost of merchandise solddata in a perpetual inventory record similar to the one illustratedin Exhibit 4, using the first-in, first-out method.

Date Purchases Cost of MerchandiseSold Inventory
2016 Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Jan. 1
10
10
28
28
30
Feb. 5
10
10
16
16
28
Mar. 5
5
14
14
25
25
30
30
31 Balances

PAGE 10

JOURNAL

DATE DESCRIPTION POST.REF. DEBIT CREDIT

1

2

3

4
Company Background & Scenario
The Auto Zone Company is a well-established, publicly-held corporation, operating as a wholesaler in the auto parts industry. Specifically, Auto Zone purchases auto parts from manufacturers and sells them to large business customers. Most purchases and sales are on account, with trade credit terms (specified below).
You’re a Davenport University student pursuing a bachelor’s degree in business and employed at the Auto Zone Company this semester as an intern. You’ve worked in various departments and on several projects so far, learning a lot about the company’s business operations. Management seems impressed with your enthusiasm and the quality of your work.
The company’s accountant has just been called away for a family emergency and will likely be absent for a month or so. The General Manager asks you to take over the accountant’s regular duties on an interim basis. You’re nervous about doing so, but are confident that what you’ve learned in accounting class, plus your personal problem-solving skills, will make this a successful experience. What a great learning opportunity, not to mention an enhancement to your resume!
Part I
Journal Entries
a. Within the "Transactions" worksheet you will find journal entry statements. Use those statements to write the corresponding journal entries. You are to write the journal entries in the proper special journal. The special journals included within this workbook include the Sales Journal, Purchases Journal, Cash Receipts Journal and Cash Payments Journal. Any transaction that does natually work within one of the special journals should be written into the General Journal.
b.Within the "Transactions" worksheet you will find journal entry statements. At the end of this list you will find "adjusting" information. Use this "adjusting" information to write the respective adjusting journal entries. Write all adjusting entries in the worksheet labled "General Journal ADJ".
c. Before starting work, review the entire project: all instructions, business transactions descriptions, workbook sections, check figures, due dates, and submission requirements.
Credit Terms & Inventory Accounting
a. When Auto Zone purchases merchandise from a supplier or vendor on account, they receive credit terms of 2/15, net 30.
b. When Auto Zone sells merchandise to a customer on account, they offer that customer credit terms of 2/30, net 45.
c. Auto Zone uses a perpetual inventory accounting system and a last-in, first-out (LIFO) inventory costing method. Within this workbook there is a worksheet labeled "Inventory Control". You will need to use the "Inventory Control" worksheet to keep a perptual record of your inventory. As part of that process you will be calculating the value of CGS each time you generate a sale. Use the "Inventory Control" worksheet to calcluate your Cost of Goods Sold values.

d. Auto Zone uses the "Gross" method of accounting for purchases and sales. The "Net" method assumes that discounts are taken at the point of sale or purchase.

MAY JOURNAL TRANSACTIONS
May 1 Paid $2,100 to LG for utilities bill that was recorded in April as an Account Payable, Check #1000.
May 1 Purchased 3,000 GPS units on Credit from Yamaha for $35.00 per unit.
May 1 Purchases office supplies from Staples on credit for $1,800
May 1 Signed a one-year 15%, $150,000 note payable with Chase Bank.
May 2 Rented part of the warehouse to a new tenant and received $12,000 for three months rent (May, June, July).
May 2 Sold 2,000 Aux Cords on account to Tesla for $85 per units, Invoice #2000.
May 2 Sold 400 USB Ports for $70 per unit and 1,200 GPS units for $75 per unit on account to Dodge, Invoice #2001.
May 3 Received a bill from the law firm of Davenport Associates for $6,300, payable upon receipt, for bond consulting fees, Check #1001.
May 4 Sold 500 Aux Cords on credit to Buick for $77 per unit, Invoice #2002.
May 4 Purchased 2,100 USB Ports on credit from Shure for $45 per unit.
May 5 Paid for office supplies purchased at Staples on May 1st, Check #1002.
May 7 Sold 200 GPS units on account to Chevrolet for $49 per unit, Invoice #2003.
May 8 Issued 4,750 shares of common stock for $13 per share
May 11 Purchased 1,875 GPS units on credit from Sony for $25 per unit.
May 11 The Board of Directors declared a cash dividend of $7 per share for shareholders of record on May 13th, payable on May 17th.
May 12 Paid in full for the May 1 purchase from Yamaha, Check #1003.
May 13 Received and paid expense reports for travel and entertainment totaling $1,500, Check #1004.
May 13 Took advantage of a special deal to purchase 1,500 Aux Cords on account from Panasonic for $42 per unit.
May 15 Received payment in full from Tesla for the May 2nd sale.
May 15 Sold 1,050 USB Ports on credit to Chevrolet for $57 per unit, Invoice #2004.
May 16 Received payment from Buick for $125,000 of the $300,000 owed from April 5.
May 17 Paid the dividend that was declared on May 11th, Check #1005.
May 17 Check # 1006 was issued for payroll: $14,900 for salaries and $5,100 for wages.
May 20 Issued a credit to Chevrolet for the return of 150 defective units from the May 7th sale. These units has a cost basis of $35 per unit.
May 20 Returned the 150 defective units received from Chevrolet to Yamaha.
May 22 Purchased a $500 international phone card for one of the sales representative's upcoming European business trip, Check #1008.
May 23 Issued bonds payable at face value for $420,000
May 23 Purchased 2,080 USB Ports from Shure for $41 per unit paying in cash, Check #1009
May 24 Check #1010 was issued for payroll: $14,900 for salaries and $5,100 for wages.
May 25 Hired and paid a consultant $50,000 to devise a marketing plan. Auto Zone's management felt this was necessary to develop brand awareness. Check #1011.
May 26 While inspecting the May 11th purchase, it was discovered that the GPS units were programmed for Asia instead of North America. Auto Zone returned the entire order to Sony.
May 27 A bankruptcy judge disallowed Auto Zone's claim for $25,000 due from Jeep. Management Decided to write off this accounts receivable.
May 27 Sold 500 USB Ports on credit to GMC for $61 per unit, Invoice #2005.
May 29 Paid in full for the purchase from Panasonic on May 13, Check #1012.
May 29 Received payment in full from GMC for the May 27th transaction.
May 30 Auto Zone is behind in its mortgage payments to Fifth Third Bank. Paid a total of $20,000 ($5,000 principal and $15,000 interest), Check #1013.
May 31 Paid the first month's principal payment of $12,500 on the note payable. In addition, paid one month's interest, Check #1007
*All purchases on account terms of 2/15, n/30
**All credit sales have terms of 2/30, n/45
May Month-end Adjustments:
( A ) The Company took a physical count of Office Supplies on May 30 and found the following the value of inventory on hand to be $2,500. The beginning inventory was $3,200. Write the adjusting journal entry.
( B ) Auto Zone estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, Auto Zone estimates that the allowance account should be 7.5% of accounts receivable. The ending AR balance is $850,000. At the end of the month (prior to this journal entry) there is a CREDIT balance of $19,000 in the Allowance for Doubtful Accounts account. Write the necessary adjusting entry.
( C ) The Balance of $23,000 in the prepaid insurance account at the beginning of May represents 5 months of coverage. Record the amount of insurance for May.
( D ) The Company took a physical inventory count on May 30 and found the following inventory on hand to be $100,641. The ending balance in the Inventory account (before this adjusting entry) was $128,947. Write the necessary adjusting entry.
( E ) Auto Zone has earned two months of the prepaid rent received from their tenant at the beginning of May.
( F ) Depreciation on the company's fixed assets for the month of May is as follows:
1. The furniture and equipment for the office was purchased last year for $7,350. these assets have a 5 year life, an expected salvage value of $500, and are depreicated using straight-line method.

2. The furniture and equipment for the warehouse was purchased a few years ago for $30,000. These assets have a 8-year life, an expected salvage value of $5,000, and are depreciated using the straight-line method.

Shoe: GPS
Beginning Inventory (BI) Purchases Sales Ending Inventory (EI)
Date BI Units BI $/Unit BI $ Purch Units Purch $/Unit Purch $ Sale Units (CGS) Sale $/Unit (CGS) Sale $ (CGS) EI Units EI $/Unit EI $
1-May 3300 $35.00 $115,500.00 $- $- $115,500.00
Shoe: Aux Cord
Beginning Inventory (BI) Purchases Sales Ending Inventory (EI)
Date BI Units BI $/Unit BI $ Purch Units Purch $/Unit Purch $ Sale Units (CGS) Sale $/Unit (CGS) Sale $ (CGS) EI Units EI $/Unit EI $
1-May 2500 $65.00 $162,500.00 $- $- $162,500.00
Shoe: USB Port
Beginning Inventory (BI) Purchases Sales Ending Inventory (EI)
Date BI Units BI $/Unit BI $ Purch Units Purch $/Unit Purch $ Sale Units (CGS) Sale $/Unit (CGS) Sale $ (CGS) EI Units EI $/Unit EI $
1-May 1400 $40.00 $56,000.00 $- $56,000.00

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in