There has been a lot of interest in the data analytics cases for introductory accounting that have been posted on this blog. I am providing a summary of the seven data analytics cases and related links in the table below to make it more convenient to see, at a glance, what projects are available and […]
Continue reading
Tag Archives: gross profit
Recap of all data analytics projects available
January 4, 2019 
0 Comments
Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. (Heads up: I will be posting a new managerial accounting data analytics case within the next week too!) Here goes: Project 1: Transaction analysis for […]
Continue readingData analytics project: Gross profit analysis for introductory financial accounting
August 3, 2018 4 Comments
This blog post contains a data analytics project that is suitable for introductory financial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned early in the course once the concept of gross profit is reviewed. Overview of project This project uses […]
Continue readingWhat would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?
March 23, 2018 0 Comments
Canadian Solar (NASDAQ: CSIQ) and other solar panel manufacturers are facing a shortage of a key raw material used in the production of solar panels, polysilicon. Environmental regulators in China shut down several factories, triggering the shortage. The cost of polysilicon has risen by as much as 35% in the past several months. A kilogram […]
Continue readingAt Lululemon, how can sales be up while gross margin is down?
January 28, 2016 0 Comments
Founded in 1988, Lululemon Athletica Inc. (LULU) is an athletic apparel company headquartered in Canada. Lululemon has helped to popularize the ubiquitous yoga pants in the U.S. While it has experienced some sales declines due to a recall of yoga pants in 2013 for being too sheer, Lululemon has revamped its product line to update […]
Continue readingWhat is the gross margin on the Apple iPhone 5S and 5C?
October 29, 2013 1 Comment
According to the GottaBe Mobile website in September 2013, the Apple iPhone 5S with 16 GB memory sells off-contract for $649, while the iPhone 5C with 16 GB memory sells off-contract for $549. The same phones with 32 GB memory sell off-contract for $749 and $649. According to Bloomberg Businessweek and IHS iSuppli, the iPhone […]
Continue reading
Accounting in the Headlines 