In: Accounting
At the beginning of June 2017, Pina Colada Distributing Company’s ledger showed Cash $18,000, Merchandise Inventory $6,000, and D. Pina Colada, Capital, $24,000. During the month of June, the company had the following selected transactions: June 1 Purchased $8,910 of merchandise inventory from Sun Supply Co., terms 1/15, n/30, FOB destination. 2 The correct company paid $220 cash for freight charges on the June 1 purchase. 5 Sold merchandise inventory to Moose Jaw Retailers for $12,200. The cost of the merchandise was $7,700 and the terms were 2/10, n/30, FOB destination. 6 Issued a $820 credit for merchandise returned by Moose Jaw Retailers. The merchandise originally cost $540 and was returned to inventory. 6 The correct company paid $280 freight on the June 5 sale. 7 Purchased $840 of supplies for cash. 10 Purchased $4,550 of merchandise inventory from Fey Wholesalers, terms 2/10, n/30, FOB shipping point. 10 The correct company paid $150 freight costs on the purchase from Fey Wholesalers. 12 Received a $300 credit from Fey Wholesalers for returned merchandise. 14 Paid Sun Supply Co. the amount due. 15 Collected the balance owing from Moose Jaw Retailers. 19 Sold merchandise for $7,100 cash. The cost of this merchandise was $4,500. 20 Paid Fey Wholesalers the balance owing from the June 10 purchase. 25 Made a $520 cash refund to a cash customer for merchandise returned. The returned merchandise had a cost of $325. The merchandise was damaged and could not be resold. 30 Sold merchandise to Bauer & Company for $4,200, terms n/30, FOB shipping point. Pina Colada's cost for this merchandise was $2,600. A physical inventory count shows $3,900 of inventory on hand on June 30, 2017.
1)Record the transactions assuming Pina Colada uses a periodic inventory system
2) Set up general ledger accounts for merchandise inventory and
all of the temporary accounts used in the merchandising
transactions. Enter beginning balances, and post the
transactions.
| 
 Merchandise Inventory  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 1  | 
 Balance  | 
 √  | 
|||
| 
 Sales  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 5  | 
 J1  | 
||||
| 
 19  | 
 J1  | 
||||
| 
 30  | 
 J1  | 
||||
| 
 Sales Returns and Allowances  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 6  | 
 J1  | 
||||
| 
 25  | 
 J1  | 
||||
| 
 Sales Discounts  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 15  | 
 J1  | 
||||
| 
 Purchases  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 1  | 
 J1  | 
||||
| 
 10  | 
 J1  | 
||||
| 
 Purchases Discounts  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 14  | 
 J1  | 
||||
| 
 June 20  | 
 J1  | 
||||
| 
 Purchases Returns and Allowances  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 12  | 
 J1  | 
||||
| 
 Freight In  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 10  | 
 J1  | 
||||
| 
 Freight Out  | 
|||||
| 
 Date  | 
 Explanation  | 
 Ref.  | 
 Debit  | 
 Credit  | 
 Balance  | 
| 
 June 6  | 
 J1  | 
||||
| 
 PINA COLADA DIST. CO.:  | 
||||
| 
 1) Journal entries of transactions:  | 
||||
| 
 Date  | 
 Acc Titles  | 
 Dr. $  | 
 Cr. $  | 
|
| 
 1-Jun  | 
 Merchandise Inventory  | 
 8910  | 
||
| 
 Accounts payable  | 
 8910  | 
|||
| 
 (purchase of inventory)  | 
||||
| 
 2-Jun  | 
 No entry for Freight, being FOB dist.  | 
|||
| 
 5-Jun  | 
 Accounts Receivable  | 
 12200  | 
||
| 
 Sales revenue  | 
 12200  | 
|||
| 
 (goods sold to Moose)  | 
||||
| 
 COGS  | 
 7700  | 
|||
| 
 Merchandise Inventory  | 
 7700  | 
|||
| 
 (cost of sales recorded)  | 
||||
| 
 6-Jun  | 
 Sales return & Allowances  | 
 820  | 
||
| 
 Accounts Receivable  | 
 820  | 
|||
| 
 (return of goods)  | 
||||
| 
 Merchandise Inventory  | 
 540  | 
|||
| 
 COGS  | 
 540  | 
|||
| 
 (cost of goods returned recorded)  | 
||||
| 
 6-Jun  | 
 Freight Outward  | 
 280  | 
||
| 
 Cash  | 
 280  | 
|||
| 
 (freight paid for goods dispatched)  | 
||||
| 
 7-Jun  | 
 Supplies  | 
 840  | 
||
| 
 Cash  | 
 840  | 
|||
| 
 (purchased supplies)  | 
||||
| 
 10-Jun  | 
 Merchandise Inventory  | 
 4550  | 
||
| 
 Accounts payable  | 
 4550  | 
|||
| 
 (purchase of inventory)  | 
||||
| 
 Freight Inward  | 
 150  | 
|||
| 
 Cash  | 
 150  | 
|||
| 
 (freight paid for purchases)  | 
||||
| 
 12-Jun  | 
 Accounts payable  | 
 300  | 
||
| 
 Purchase return & allowance  | 
 300  | 
|||
| 
 (credit on return of goods)  | 
||||
| 
 14-Jun  | 
 Accounts payable  | 
 8910  | 
||
| 
 Cash  | 
 8910  | 
|||
| 
 (payment to AP)  | 
||||
| 
 15-Jun  | 
 Cash  | 
 11380  | 
 (12200-820)  | 
|
| 
 Accounts Receivable  | 
 11380  | 
|||
| 
 (payment received)  | 
||||
| 
 19-Jun  | 
 Cash  | 
 7100  | 
||
| 
 Sales revenue  | 
 7100  | 
|||
| 
 (cash sales made)  | 
||||
| 
 COGS  | 
 4500  | 
|||
| 
 Merchandise Inventory  | 
 4500  | 
|||
| 
 (cost of sales recorded)  | 
||||
| 
 20-Jun  | 
 Accounts payable  | 
 4250  | 
 (4550-300)  | 
|
| 
 Cash  | 
 4250  | 
|||
| 
 (payment to AP)  | 
||||
| 
 25-Jun  | 
 Sales return & Allowances  | 
 520  | 
||
| 
 Cash  | 
 520  | 
|||
| 
 (cash sales returned)  | 
||||
| 
 30-Jun  | 
 Accounts Receivable  | 
 4200  | 
||
| 
 Sales revenue  | 
 4200  | 
|||
| 
 (goods sold to Bauer)  | 
||||
| 
 COGS  | 
 2600  | 
|||
| 
 Merchandise Inventory  | 
 2600  | 
|||
| 
 (cost of sales recorded)  | 
| 
 2) General Ledger:  | 
|||
| 
 DEBIT  | 
 AMOUNT $  | 
 CREDIT  | 
 AMOUNT $  | 
| 
 Merchandise Inventory  | 
|||
| 
 OB  | 
 6000  | 
 5  | 
 7700  | 
| 
 1  | 
 8910  | 
 19  | 
 4500  | 
| 
 6  | 
 540  | 
 30  | 
 2600  | 
| 
 10  | 
 4550  | 
 Inventory loss  | 
 1300  | 
| 
 CB  | 
 3900  | 
||
| 
 Acc payable  | 
|||
| 
 12  | 
 300  | 
 1  | 
 8910  | 
| 
 14  | 
 8910  | 
 10  | 
 4550  | 
| 
 20  | 
 4250  | 
||
| 
 Acc Receivable  | 
|||
| 
 5  | 
 12200  | 
 6  | 
 820  | 
| 
 30  | 
 4200  | 
 15  | 
 11380  | 
| 
 CB  | 
 4200  | 
||
| 
 Sales revenue  | 
|||
| 
 CB  | 
 23500  | 
 5  | 
 12200  | 
| 
 19  | 
 7100  | 
||
| 
 30  | 
 4200  | 
||
| 
 COGS  | 
|||
| 
 5  | 
 7700  | 
 6  | 
 540  | 
| 
 19  | 
 4500  | 
 CB  | 
 14260  | 
| 
 30  | 
 2600  | 
||
| 
 Sales return & Allowances  | 
|||
| 
 6  | 
 820  | 
 CB  | 
 1340  | 
| 
 25  | 
 520  | 
||
| 
 Freight Outward  | 
|||
| 
 6  | 
 280  | 
||
| 
 Supplies  | 
|||
| 
 7  | 
 840  | 
||
| 
 Freight Inward  | 
|||
| 
 10  | 
 150  | 
||
| 
 Purchase return & allowance  | 
|||
| 
 12  | 
 300  |