The milestone for Project One involves applying accounting principles and methods to current assets and liabilities. You will also evaluate these financial statement components for adherence to accounting principles and methods. In this assignment, which directly supports Project One, you will analyze the scenario in Project One to calculate and record financial data accurately. You will have an opportunity to correct journal entries in Project One based on feedback from your instructor for this assignment. With any accounting, it is imperative to keep accurate and complete records. Directions Using the scenario provided in the Project One Guidelines and Rubric linked from the Supporting Materials section, you will be preparing journal entries related to the current assets and liabilities in the Milestone Journal Entries and Milestone Inventory tabs of the Project One Workbook Template and based on the transactions listed in the Project One Appendix. To access the Project One Workbook Template, use Microsoft Excel on the virtual desktop infrastructure (VDI) to complete this assignment. The Project One Workbook Template is provided for you to prepare the joumal entries. It contains several tabs: Charts of Accounts, Milestone Journal Entries, Corrected Journal Entries, Milestone Inventory, Corrected Inventory, Ledger Accounts, Income Statement, and Balance Sheet. Please keep in mind, for this milestone you will only be completing the Milestone Journal Entries and the Milestone Inventory tabs of the worksheet. Note: Remember to save your file on your OneDrive before exiting the VDI because work is not saved once you exit the VDI. Specifically, you must address the following rubric criteria: Journal Entries Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Journal Entries tab of the workbook, Be sure to refer to the Chart of Accounts tab for the account names when preparing journal entries, Include the following detalls in your response: A. Show calculations necessary to prepare the journal entries, Not all joumal entries will require a calculation. Rows with an asterisk require To access the Project One Workbook Template, use Microsoft Excel on the virtual desktop infrastructure (VDI) to complete this assignment. The Project One Workbook Template is provided for you to prepare the journal entries. It contains several tabs; Charts of Accounts, Milestone Journal Entries, Corrected Journal Entries, Milestone Inventory, Corrected Inventory, Ledger Accounts, Income Statement, and Balance Sheet. Please keep in mind, for this milestone you will only be completing the Milestone Journal Entries and the Milestone Inventory tabs of the worksheet. Note: Remember to save your file on your OneDrive before exiting the VDI because work is not saved once you exit the VDI. Specifically, you must address the following rubric criteria: Journal Entries Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Journal Entries tab of the workbook. Be sure to refer to the Chart of Accounts tab for the account names when preparing journal entries. Include the following details in your response: A. Show calculations necessary to prepare the journal entries. Not all journal entries will require a calculation. Rows with an asterisk require formulas in the debit or credit column. 2. Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Journal Entries tab of the workbook. There are a total of 26 entries, Inventory Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Inventory tab of the workbook. 2. Prepare the worksheet that reflects the products purchased and sold at the new store on the Milestone Inventory tab of the workbook 3. Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Inventory tab of the workbook. There are a total of 18 entries. ACC 317 Project One Appendix 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 15 th, and the other is the 16 th through the end of the month. Paydays are the 20 th for the first pay period and the 5 th of the following month for the second pay period. (No entry required on this date-for 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 employee's 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 1-December 31. December 31: Accrue for interest from August 1 to December 31 on the loan. 2. 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 dub 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. The milestone for Project One involves applying accounting principles and methods to current assets and liabilities. You will also evaluate these financial statement components for adherence to accounting principles and methods. In this assignment, which directly supports Project One, you will analyze the scenario in Project One to calculate and record financial data accurately. You will have an opportunity to correct journal entries in Project One based on feedback from your instructor for this assignment. With any accounting, it is imperative to keep accurate and complete records. Directions Using the scenario provided in the Project One Guidelines and Rubric linked from the Supporting Materials section, you will be preparing journal entries related to the current assets and liabilities in the Milestone Journal Entries and Milestone Inventory tabs of the Project One Workbook Template and based on the transactions listed in the Project One Appendix. To access the Project One Workbook Template, use Microsoft Excel on the virtual desktop infrastructure (VDI) to complete this assignment. The Project One Workbook Template is provided for you to prepare the joumal entries. It contains several tabs: Charts of Accounts, Milestone Journal Entries, Corrected Journal Entries, Milestone Inventory, Corrected Inventory, Ledger Accounts, Income Statement, and Balance Sheet. Please keep in mind, for this milestone you will only be completing the Milestone Journal Entries and the Milestone Inventory tabs of the worksheet. Note: Remember to save your file on your OneDrive before exiting the VDI because work is not saved once you exit the VDI. Specifically, you must address the following rubric criteria: Journal Entries Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Journal Entries tab of the workbook, Be sure to refer to the Chart of Accounts tab for the account names when preparing journal entries, Include the following detalls in your response: A. Show calculations necessary to prepare the journal entries, Not all joumal entries will require a calculation. Rows with an asterisk require To access the Project One Workbook Template, use Microsoft Excel on the virtual desktop infrastructure (VDI) to complete this assignment. The Project One Workbook Template is provided for you to prepare the journal entries. It contains several tabs; Charts of Accounts, Milestone Journal Entries, Corrected Journal Entries, Milestone Inventory, Corrected Inventory, Ledger Accounts, Income Statement, and Balance Sheet. Please keep in mind, for this milestone you will only be completing the Milestone Journal Entries and the Milestone Inventory tabs of the worksheet. Note: Remember to save your file on your OneDrive before exiting the VDI because work is not saved once you exit the VDI. Specifically, you must address the following rubric criteria: Journal Entries Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Journal Entries tab of the workbook. Be sure to refer to the Chart of Accounts tab for the account names when preparing journal entries. Include the following details in your response: A. Show calculations necessary to prepare the journal entries. Not all journal entries will require a calculation. Rows with an asterisk require formulas in the debit or credit column. 2. Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Journal Entries tab of the workbook. There are a total of 26 entries, Inventory Tab 1. Prepare accurate journal entries with the correct ledger accounts on the Milestone Inventory tab of the workbook. 2. Prepare the worksheet that reflects the products purchased and sold at the new store on the Milestone Inventory tab of the workbook 3. Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Inventory tab of the workbook. There are a total of 18 entries. ACC 317 Project One Appendix 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 15 th, and the other is the 16 th through the end of the month. Paydays are the 20 th for the first pay period and the 5 th of the following month for the second pay period. (No entry required on this date-for 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 employee's 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 1-December 31. December 31: Accrue for interest from August 1 to December 31 on the loan. 2. 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 dub 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