Group Projects in ACCT 605
Project Summary
Store Revenue
Payroll Expense
In this project, we analyzed the fiscal year of operations for Libayshuns across 5 store locations. The analysis covers revenue, cost of goods sold, gross profit margins, payroll, inventory variance, top sellers, and the impact of customer service on sales. We used SQL to structure data from multiple sources, then organized and structured some of it in Excel to run calculations and visuals. We also used Tableau for visuals and tables.
This analysis breaks down quarterly and annual revenue for each store of the 5 stores. (Eugene, Medford, Portland, Seattle, and Tacoma) The total revenue reached $5,849,638, with Seattle leading store performance and a clear upward trend across quarters from Q4 '25 through Q3 '26.
Payroll expenses were analyzed by store and quarter to compare the differences from across the company. The breakdown revealed that store payroll totaled $507,662 (36%) while corporate payroll reached $920,279, 64% of total payroll. Libayshuns was profitable after its fiscal year. We can use Tableau to transform datasets into easy to understand visuals, creating the bridge between the accounting team and leadership.
Project Summary
Survival Rate by Class
Conclusion
For this project, we investigated whether women were more likely to survive the Titanic disaster than men. We used a dataset of 1,309 passengers with variables including gender, survival status, ticket class, age, fare, and departing port. We explored which passenger groups had the highest survival rates. We used Excel, Powerpoint, and ChatGPT in this presentation.
We broke down survival rates by both gender and ticket class to identify patterns. Among the 339 female survivors, 139 came from 1st class, 94 from 2nd, and 106 from 3rd class. The largest share coming from 1st class. From the 161 male survivors, the distribution was 61 in 1st class, 25 in 2nd, and 75 in 3rd.
Women were significantly more likely to survive than men, with 339 women surviving compared to 161 men (73% vs. 19% survival rates). Class played a crucial role for women specifically, for those in 1st class that had a 97% survival rate. Overall, gender was a strong predictor of survival on the Titanic.