Question

WHICH I COULDN'T COPY HERE IN EXCEL FORMAT. I WOULD APPRECIATE IFSOMEONE COULD HELP ME WITH THIS.. INSTRUCTIONS ARE AT THE END.THANKYOU SO MUCH!!!

P5-1A Sansomite Co. distributes suitcases to retail stores andextends credit terms of 1/10, n/30
to all of its customers. At the end of June, Sansomite's inventoryconsisted of suitcases costing $1,200
During the month of July the following merchandising transactionsoccurred:

July 1 Purchased suitcases on account for $1,800 from TrunkManufacturers, FOB destination, terms
2/10, n/30. The appropriate party also made a cash payment of $100for freight on this date.
July 3 Sold suitcases on account to Satchel World for $2,000 Thecost of suitcases sold is
$1,200
July 9 Paid Trunk Manufacturers in full.
July 12 Received payment in full from Satchel World.
July 17 Sold suitcases on account to The Going Concern for $1,500The cost of suitcases sold is
$900
July 18 Purchased suitcases on account for $1,700 from KingmanManufacturers, FOB shipping point,
terms 1/10, n/30. The appropriate party also made a cash payment of$100 for freight
on this date.
July 20 Received $300 credit (including freight) for suitcasesreturned to Kingman Manufacturers.
July 21 Received payment in full from The Going Concern.
July 22 Sold suitcases on account to Fly-by-Night for $2,250 Thecost of suitcases sold is
$1,350
July 30 Paid Kingman Manufacturers in full.
July 31 Granted Fly-By-Night $200 credit for suitcases returnedcosting $120

Sansomite's chart of accounts includes the following:
101 Cash 401 Sales
112 Accounts Receivable 412 Sales Returns and Allowances
120 Merchandise Inventory 414 Sales Discounts
201 Accounts Payable 505 Cost of Goods Sold

Instructions:
Journalize the transactions for the month of July for Sansomiteusing a perpetual inventory system.

July 1 Merchandise Inventory Amount
Accounts Payable Amount

July 3 Accounts Receivable Amount
Sales Amount

Cost of Goods Sold Amount
Merchandise Inventory Amount

July 9 Accounts Payable Amount
Merchandise Inventory ($1,800 * 2%) Amount
Cash Amount

July 12 Cash Amount
Sales Discount Amount
Accounts Receivable Amount

July 17 Accounts Receivable Amount
Sales Amount

Cost of Goods Sold Amount
Merchandise Inventory Amount

July 18 Merchandise Inventory Amount
Accounts Payable Amount

Merchandise Inventory Amount
Cash Amount

July 20 Accounts Payable Amount
Merchandise Inventory Amount

July 21 Cash Amount
Sales Discount Amount
Accounts Receivable Amount

July 22 Accounts Receivable Amount
Sales Amount

Cost of Goods Sold Amount
Merchandise Inventory Amount

July 30 Account Payable Amount
Cash Amount

July 31 Sales Returns and Allowances Amount
Accounts Receivable Amount

Merchandise Inventory Amount
Cost of Goods Sold Amount