Camelot Caves Inc. (CCI)

A capstone accounting case that combine core management accounting skills with modern analytics

Author

Jianyuan(Andy) Hu

Published

May 31, 2025

Welcome !!

Case “Camelot Caves Inc. (CCI)” is created and designed by:

  • Barbara Sainty
  • Staci Kenno Pinkerton
  • Jianyuan(Andy) Hu

I really take the pleasure to work with Barbara and Staci to heart and contribute to a modern accounting education.

Please see “Special Credits” page of the report for full credits and acknowledgements.

About the Case

Camelot Caves Inc. (CCI) aims to bridge the gap between analytics and management accounting, providing a comprehensive learning experience for students from both disciplines. The case will offer various starting points, catering to different learning appetites, allowing inclusivity and adaptability. The core objective is to implement an end-to-end analytics project, encompassing skills including data extraction, transformation, and loading (ETL), data modeling, documentation, visual analytics, and then use the solution as cornerstone for the application of management accounting techniques, such as contribution margin analysis.

Students will engage with real-life, messy data from a home-grown Canadian winery business, allowing them to apply theoretical knowledge to practical scenarios. The case will emphasize contribution margin analysis and business planning/advisory, integrating both quantitative and qualitative factors for short-term and long-term decision-making.