A fun practice for accounting!
Challenge38_Cowabunga_Inventory.xlsx (18.2 KB)
Found the missing surfboard count, and then just calculated it through Excel. Here are my journal entries!
My Answer:
Overstatement of revenue. Here’s why.
Challenge38_Cowabunga_Inventory - Ethan Emerson Solution.xlsx (17.5 KB)
Here is my final entry, as others have mentioned the original data file is currently missing some of the original data points so the count and attached journal entry is different.
Excel Challenge- Surfboards- 230918.xlsx (16.5 KB)
Here is mt solution!
Cowabunga failed to include the Sundrift surfboards in their calculations, and this omission was the primary reason for their revenue overstatement.
Here is my solution.
0404_Hladek_Cowabunga_Inventory.xlsx (16.3 KB)
Challenge38_Cowabunga_Inventory.xlsx (18.0 KB)
Here is my completed Data!
Here is my solution!
Challenge38_Cowabunga_Solution.xlsx (16.3 KB)
1 Like
Challenge38_Cowabunga_Inventory.xlsx (17.8 KB)
Canyon_Esplin_Challenge38_Cowabunga_Inventory.xlsx (17.2 KB)
Here is how I did it.
Challenge38_Cowabunga_Inventory.xlsx (17.1 KB)
For this challenge, I used tools from our fourth class lecture. I knew that a comparison would need to be made to find the incorrect aspects shown in the revenue and inventory balances. I used a sumif Excel function to help me make that comparison. Afterward, I made my adjusting entry as if the inventory found was shown as being sold.
1 Like
This challenger was fun and a good refresher on Excel! Here’s my solution.
Here is my Solution. Very fun project. For Prof Summers 9/20/23.
Challenge38_Cowabunga_Inventory.xlsx (16.8 KB)
I got a higher amount than most other people I think. I mainly used if and sum if functions to find the missing surfboards.
Challenge38_Cowabunga_Inventory.xlsx (17.2 KB)