Week 3: Assignment 3: Instructions for Writer:
Complete the 4 Chapter problems below: Use Excel Templates to perform this work
1) Chapter 5, P5-29A
Journalizing purchase and sale transactions—perpetual inventory [20–25 min]
Thelma’s Amusements completed the following transactions during November 2012:
Nov 1 Purchased supplies for cash, $700.
4 Purchased inventory on credit terms of 3/10, n/eom, and $9,600.
8 Returned half the inventory purchased on November 4. It was not the inventory ordered.
10 Sold goods for cash, $1,200 (cost, $700).
13 Sold inventory on credit terms of 2/15, n/45, $9,900 (cost, $5,300).
14 Paid the amount owed on account from November 4, less the return (November 8) and the discount.
17 Received defective inventory as a sales return from the November 13 sale, $600. Thelma’s cost of the inventory received was $450.
18 Purchased inventory of $4,100 on account. Payment terms were 2/10, net 30.
26 Paid the net amount owed for the November 18 purchase.
28 Received cash in full settlement of the account from the customer who purchased inventory on November 13, less the return and the discount.
29 Purchased inventory for cash, $12,000, plus freight charges of $200.
Requirement : 1. Journalize the transactions on the books of Thelma’s Amusements.
2) Chapter 5, E5-16
Computing inventory and cost of goods sold amounts [10–15 min]
Consider the following incomplete table of merchandiser’s profit data:
Sales Sales Discounts Net Sales Cost of Goods Sold Gross Profit
$ 89,500 $ 1,560 $ 87,940 $ 60,200 (a)
103,600 (b) 99,220 (c) $ 34,020
66,200 2,000 (d) 40,500 (e)
(f) 2,980 (g) 75,800 36,720
Requirement : 1. Calculate the missing table values to complete the table:

3) Chapter 6, E 6-23
Comparing cost of goods sold in a perpetual system—FIFO, LIFO, and average-cost methods [15–20 min]
Assume that a JR Tire Store completed the following perpetual inventory transactions for a line of tires:
Beginning inventory 16 tires @ $ 65
Purchase 10 tires @ $ 78
Sale 12 tires @ $ 90
Requirements :
1. Compute cost of goods sold and gross profit using FIFO.
2. Compute cost of goods sold and gross profit using LIFO.
3. Compute cost of goods sold and gross profit using average cost. (Round average cost per unit to the nearest cent and all other amounts to the nearest dollar.)
4. Which method results in the largest gross profit and why?

4) Chapter 6, E 6-28
Estimating ending inventory by the gross profit method [10–15 min]
Deluxe Auto Parts holds inventory all over the world. Assume that the records for one auto part show the following:
Beginning inventory $ 220,000
Net purchases 800,000
Net sales 1,100,000
Gross profit rate 45%
Suppose this inventory, stored in the United States, was lost in a fire.
Requirement : 1. Estimate the amount of the loss to Deluxe Auto Parts. Use the gross profit method.