Someone please help thank you I did some of it but i don't think it is correct below is the information for the excel sheet The following events occurred during the year Book the entries necessary for the corresponding transactions that have occurred August 1 The business owner loaned the company $10,000 at 4 interest annually to be paid in full in three years August 15 A new one year lease agreement was signed for a new sporting goods store The rent is $1,350 per month for the year The lease begins on September 1 and is effective through August 31 of the next year A payment of the first month's rent plus a deposit payment of $2,000 was made (Info only The deposit remains in Prepaid Rent until the end of the lease) August 31 Paid $2,400 for a 12 month insurance policy Policy effective dates are September 1 through August 31 September 1 Expense September rent paid in August September 21 A part time worker was hired at $15 per hour to work the customer service desk One pay period is the 1st of the month through the 15th, and the other is the 16th through the end of the month Paydays are the 20th for the first pay period and the 5th of the following month for the second pay period (No entry required on this datefor informational purposes only ) September 30 Sold 15 bicycles on special at $150 each and 5 golf club sets at $350 each The customer put 12 on account and paid cash for the rest September 30 Calculate the payroll accrual for employees first paycheck for 12 hours to be delivered on October 5 October 1 Paid October rent on new sporting goods space October 5 Paid employee for period ending September 30 October 15 Collected $500 on account from customers October 20 Paid employee with 20 hours for period ending October 15 October 31 Accrued wages earned for employee with 15 hours for period of October 16 through October 31 October 31 Sold 5 bicycles at $170 each and 15 golf club sets at $380 each in October with 31 on account November 1 Paid rent on new sporting goods space November 5 Paid employee for period ending October 31 November 17 Collected $950 on account from customers November 20 Paid employee with 17 hours for period ending November 15 November 30 Accrued wages earned for employee with 22 hours for period November 16 through November 30 November 30 Sold 15 bicycles at $170 each and 10 golf club sets at $380 each in November with 28 on account December 1 Paid rent on new sporting goods space December 5 Paid employee for period ending November 30 December 18 Received payments from customers toward accounts receivable in amount of $1,000 December 20 Paid employee with 16 hours for period ending December 15 December 31 Accrued wages earned for employee with 18 hours for period of December 16 through December 31 December 31 Sold 20 bicycles at $180 each and 5 golf club sets at $400 each in December with 22 on account December 31 Book expense for insurance during September 1December 31 December 31 Accrue for interest from August 1 to December 31 on the loan As this is a new store, merchandise has been purchased on account to sell at the store The information below relates to the purchase and sales of the new products Use the perpetual inventory method with the FIFO valuation method Please see the Milestone Inventory tab in your workbook for purchase and sales information August 25 Purchased 15 golf club sets for $240 each to sell at the store from vendor A, on account with terms of 1 10 net 60 September 16 Purchased 25 bicycles for $75 each to sell at the store from vendor B, on account with terms of 1 10 net 60 September 24 Paid $750 toward merchandise from vendor A September 30 Recorded impact of sales transaction on COGS and the inventory asset October 18 Paid $650 toward merchandise from vendor B October 25 Paid remaining payable for merchandise from vendor A October 26 Purchased 25 more golf club sets for $250 each to sell at the store from vendor A, on account with terms of 1 10 net 60 October 31 Recorded impact of sales transaction on COGS and the inventory asset November 10 Paid remaining payable for merchandise from vendor B November 16 Purchased 35 more bicycle sets for $85 to sell at the store each from vendor on account with terms of 2 10 net 30 November 20 Paid vendor B in full and took advantage of the discount (offset COGS) November 30 Recorded impact of sales transaction on COGS and the inventory asset December 10 Paid $4500 toward payable for merchandise from Vendor A December 31 Recorded impact of sales transaction on COGS and the inventory asset FIFO Purchases Sales Ending Inventory Batter Up General Journal Entries No of Date Items Golf Club Sets 25 Aug 30 Sep Unit Price Total Price 15 $240 00 $ 3,600 00 No of Items Unit Price Total Price No of Items Unit Price 15 $ 5 $ 350 00 $1,750 00 10 $ 240 00 240 00 $2,400 00 Total Price $3,600 00 Date Accounts Debit Credit 25 Aug Inventory $ 3,600 00 Accounts Payable (vendor A) $ 3,600 00 26 Oct 25 $250 00 $ 6,250 00 35 $ 8,650 00 31 Oct 15 $ 380 00 $5,700 00 10 $ 31 Oct 5 $ 30 Nov 10 $ 31 Dec 250 00 $1,250 00 380 00 $3,800 00 5 $ 400 00 $2,000 00 20 $ 10 $ 5 $ 250 00 $2,500 00 250 00 $ 5,000 00 250 00 $2,500 00 250 00 $1,250 00 16 Sep Inventory $ 1,875 00 Accounts Payable (vendor B) $ 1,875 00 24 Sep Cash S 750 00 Accounts Payable (vendor A) $ 750 00 Net Inventory 40 $ 9,850 00 40 $8,600 00 5 $ 1,250 00 30 Sep Cost of Gods Sold S Cash Bank Accounts Receivable $ Bicycles 16 Sep 25 $ 75 00 $ 1,875 00 $ 25 $ 75 00 30 Sep 31 Oct 15 $ 5 $ 150 00 $2,250 00 10 $ 170 00 $ 850 00 5 $ $ 1,875 00 75 00 $ 750 00 75 00 $ 375 00 30 Sep Inventory S Sales 16 Nov 35 $ 85 00 $ 2,975 00 40 30 Nov 15 $ 170 00 $2,550 00 30 $ 30 Nov 5 $ 85 00 $ 425 00 25 $ 31 Dec 20 $ 180 00 $3,600 00 5 $ $ 3,350 00 85 00 $ 2,550 00 85 00 85 00 $ 18 Oct Accounts Payable (vendor B) Cash S 650 00 $ 650 00 $ 2,125 00 425 00 25 Oct Insert text Insert text Insert value Insert value Net Inventory 60 $ 4,850 00 60 $9,675 00 5 $ 425 00 26 Oct Insert text Insert value Insert text Insert value 31 Oct Insert text Insert value Insert text Insert value Merchandise Inventory VENDOR A Golf Clubs Bicycles $ 3,600 00 $ VENDOR B 1,875 00 31 Oct Insert text Insert value $ 3,600 00 $ 1,875 00 $ (750 00) $ Insert text Insert value $ $ $ $ Insert value VALUE $ VALUE Insert value $ Insert value $ 10 Nov Insert text Insert value Insert text Insert value VALUE VALUE VALUE VALUE $ 2,850 00 $ 1,875 00 16 Nov Insert text Insert value Insert text Insert value VALUE VALUE 20 Nov Insert text Insert value Insert text Insert text Insert value Insert value

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 20, 2024

Someone please help. thank you! I did some of it but i don't think it is correct. below is the information for the excel sheet.

Someone please help. thank you! I did some of it but i don't think it is correct. below is the information for the excel sheet. image text in transcribed

The following events occurred during the year. Book the entries necessary for the corresponding transactions that have occurred.

August 1: The business owner loaned the company $10,000 at 4% interest annually to be paid in full in three years.

August 15: A new one-year lease agreement was signed for a new sporting goods store. The rent is $1,350 per month for the year. The lease begins on September 1 and is effective through August 31 of the next year. A payment of the first month's rent plus a deposit payment of $2,000 was made. (Info only. The deposit remains in Prepaid Rent until the end of the lease)

August 31: Paid $2,400 for a 12-month insurance policy. Policy effective dates are September 1 through August 31.

September 1: Expense September rent paid in August.

September 21: A part-time worker was hired at $15 per hour to work the customer service desk. One pay period is the 1st of the month through the 15th, and the other is the 16th through the end of the month. Paydays are the 20th for the first pay period and the 5th of the following month for the second pay period. (No entry required on this datefor informational purposes only.)

September 30: Sold 15 bicycles on special at $150 each and 5 golf club sets at $350 each. The customer put 12% on account and paid cash for the rest.

September 30: Calculate the payroll accrual for employees first paycheck for 12 hours to be delivered on October 5.

October 1: Paid October rent on new sporting goods space.

October 5: Paid employee for period ending September 30.

October 15: Collected $500 on account from customers.

October 20: Paid employee with 20 hours for period ending October 15.

October 31: Accrued wages earned for employee with 15 hours for period of October 16 through October 31.

October 31: Sold 5 bicycles at $170 each and 15 golf club sets at $380 each in October with 31% on account.

November 1: Paid rent on new sporting goods space.

November 5:Paid employee for period ending October 31.

November 17: Collected $950 on account from customers.

November 20: Paid employee with 17 hours for period ending November 15.

November 30: Accrued wages earned for employee with 22 hours for period November 16 through November 30.

November 30: Sold 15 bicycles at $170 each and 10 golf club sets at $380 each in November with 28% on account.

December 1: Paid rent on new sporting goods space.

December 5:Paid employee for period ending November 30.

December 18: Received payments from customers toward accounts receivable in amount of $1,000.

December 20: Paid employee with 16 hours for period ending December 15.

December 31: Accrued wages earned for employee with 18 hours for period of December 16 through December 31.

December 31: Sold 20 bicycles at $180 each and 5 golf club sets at $400 each in December with 22% on account.

December 31: Book expense for insurance during September 1December 31.

December 31: Accrue for interest from August 1 to December 31 on the loan.

As this is a new store, merchandise has been purchased on account to sell at the store. The information below relates to the purchase and sales of the new products.

Use the perpetual inventory method with the FIFO valuation method. Please see the Milestone Inventory tab in your workbook for purchase and sales information.

August 25: Purchased 15 golf club sets for $240 each to sell at the store from vendor A, on account with terms of 1/10 net 60.

September 16: Purchased 25 bicycles for $75 each to sell at the store from vendor B, on account with terms of 1/10 net 60.

September 24: Paid $750 toward merchandise from vendor A.

September 30: Recorded impact of sales transaction on COGS and the inventory asset.

October 18: Paid $650 toward merchandise from vendor B.

October 25: Paid remaining payable for merchandise from vendor A.

October 26: Purchased 25 more golf club sets for $250 each to sell at the store from vendor A, on account with terms of 1/10 net 60.

October 31: Recorded impact of sales transaction on COGS and the inventory asset.

November 10: Paid remaining payable for merchandise from vendor B.

November 16: Purchased 35 more bicycle sets for $85 to sell at the store each from vendor on account with terms of 2/10 net 30.

November 20: Paid vendor B in full and took advantage of the discount (offset COGS).

November 30: Recorded impact of sales transaction on COGS and the inventory asset.

December 10: Paid $4500 toward payable for merchandise from Vendor A.

December 31: Recorded impact of sales transaction on COGS and the inventory asset.

FIFO Purchases Sales Ending Inventory Batter Up General Journal Entries No. of Date Items Golf Club Sets 25-Aug 30-Sep Unit Price Total Price 15 $240.00 $ 3,600.00 No. of Items Unit Price Total Price No. of Items Unit Price 15 $ 5 $ 350.00 $1,750.00 10 $ 240.00 240.00 $2,400.00 Total Price $3,600.00 Date Accounts Debit Credit 25-Aug Inventory $ 3,600.00 Accounts Payable (vendor A) $ 3,600.00 26-Oct 25 $250.00 $ 6,250.00 35 $ 8,650.00 31-Oct 15 $ 380.00 $5,700.00 10 $ 31-Oct 5 $ 30-Nov 10 $ 31-Dec 250.00 $1,250.00 380.00 $3,800.00 5 $ 400.00 $2,000.00 20 $ 10 $ 5 $ 250.00 $2,500.00 250.00 $ 5,000.00 250.00 $2,500.00 250.00 $1,250.00 16-Sep Inventory $ 1,875.00 Accounts Payable (vendor B) $ 1,875.00 24-Sep Cash S 750.00 Accounts Payable (vendor A) $ 750.00 Net Inventory 40 $ 9,850.00 40 $8,600.00 5 $ 1,250.00 30-Sep Cost of Gods Sold S Cash/Bank/Accounts Receivable $ Bicycles 16-Sep 25 $ 75.00 $ 1,875.00 $ 25 $ 75.00 30-Sep 31-Oct 15 $ 5 $ 150.00 $2,250.00 10 $ 170.00 $ 850.00 5 $ $ 1,875.00 75.00 $ 750.00 75.00 $ 375.00 30-Sep Inventory S Sales 16-Nov 35 $ 85.00 $ 2,975.00 40 30-Nov 15 $ 170.00 $2,550.00 30 $ 30-Nov 5 $ 85.00 $ 425.00 25 $ 31-Dec 20 $ 180.00 $3,600.00 5 $ $ 3,350.00 85.00 $ 2,550.00 85.00 85.00 $ 18-Oct Accounts Payable (vendor B) Cash S 650.00 $ 650.00 $ 2,125.00 425.00 25-Oct [Insert text] [Insert text] [Insert value] [Insert value] Net Inventory 60 $ 4,850.00 60 $9,675.00 5 $ 425.00 26-Oct [Insert text] [Insert value] [Insert text] [Insert value] 31-Oct [Insert text] [Insert value] [Insert text] [Insert value] Merchandise Inventory VENDOR A Golf Clubs Bicycles $ 3,600.00 $ VENDOR B 1,875.00 31-Oct [Insert text] [Insert value] $ 3,600.00 $ 1,875.00 $ (750.00) $ [Insert text] [Insert value] $ $ $ $ [Insert value] #VALUE! $ #VALUE! [Insert value] $ [Insert value] $ 10-Nov [Insert text] [Insert value] [Insert text] [Insert value] #VALUE! #VALUE! #VALUE! #VALUE! $ 2,850.00 $ 1,875.00 16-Nov [Insert text] [Insert value] [Insert text] [Insert value] #VALUE! #VALUE! 20-Nov [Insert text] [Insert value] [Insert text] [Insert text] [Insert value] [Insert value]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The task involves preparing various journal entries and performing necessary calculations based on the provided transactions information Lets go through the transactions and prepare the necessary jour... blur-text-image