Aerotek Company

Prepare an Excel spreadsheet of the journal entries for the first part of August 2014 for the Pit Bull Sings T-shirt Distributors, based on the following information:


AUG 1 – Purchased merchandise from Aerotek Company for $7,500 under credit terms of 1/10, n/30, FOB destination; invoice dated August 1.

AUG 4 – At Aerotek’s request, Pit Bull Sings paid $200 cash for freight charges on the August 1 purchase, reducing the amount owed to Aerotek.

AUG 5 – Sold merchandise to Laird Corp. for $5,200 under credit terms of 2/10, n/60, FOB destination; invoice dated August 5. The merchandise had a cost of $4,000.

AUG 8 – Paid Aerotek for purchase on August 1 within the discount period.

AUG 9 – Received payment from Laird for sale on August 4 within the discount period.

Instructions:

Complete this assignment using an Excel spreadsheet, and date and explain each entry on your deliverable.