Please prepare the journal entries for 2022 in Excel and provide screenshots.

1. ASF uses a perpetual inventory system. Below is a breakdown of inventory on hand at December 31, 2022: 2. The company ran out of a popular helmet. They placed an order for 8 of these helmets on account at a cost of $100 each on December 28,2022 . Terms of this order were 2/10,n/30 FOB shipping point. Olivia received an email notifying her of shipment on December 31 , 2022. Olivia looked forward to replenishingthis popularitem and adding it to inventory upon receipt. 3. A count of supplies was done on December 31,2022 , where $1,550 worth of supplies was found on hand. 4. An insurance policy was purchased in March 2022 for the next 12 months starting April 1 , 2022, and the purchase was properly recorded. 5. Olivia was ecstatic when the custom storefront sign arrived on March 1, 2022; just in time to be put up before the store's official grand opening! She hopes that the sign will last for the next 15 years. Olivia sure had fun designing and setting up the store! The furniture and fixtures she invested in (all of which was incurred within the first couple days of January 2022) are expected to last for the next 10 years. Olivia wanted to ensure that she could monitor the store's operations and her teaching schedule. As such, she invested in both a laptop and tablet. Everything was purchased on January 1, 2022 when she took advantage of some Boxing Day sales prices. She expects that both the laptop and tablet would be valuable for the next 5 years where she would need to expect to upgrade. Straight-line method is used for the storefront sign and the furniture and fixtures, and double declining-balance method is used for the laptop and tablet. Cash received from the sales is deposited in the company's bank account at the end of each month. Bank reconciliations are prepared on an annual basis. There were 10 lesson packages sold in December 2022, but the lessons will not take place until January 2023 due to the Christmas holidays. These were all 5-lesson packages and the customers paid in full and look forward to learningfrom Olivia. These lessons have been recognized as service revenue in December 2022, given it was the period in which cash was collected. 7. A customer bought a 10-lesson package in November 2022, and the lessons occurred in both November and December. The customer promised to pay for the package on December 15 , however they have yet to pay this amount owing and all methods of contacting them have been exhausted and the amount has been deemed uncollectible. This has Olivia worried that 10% of all her accounts receivable at the end of the year will not be collected. 8. The monthly salaries for employees are $8,000 (ignore payroll taxes), and salaries are paid on the 15th of each month for their work done in the previous month. Olivia has recorded salaries expense each month from January to November 2022. 9. ASF is subject to income tax and the tax rate is 30%. 10. Olivia hired a payroll clerk, who is a very hard worker and did not take vacation in 2022. Employees do not typically report payroll errors, so Olivia does not need to monitor the payroll clerk closely