Roast Coffee Shop - 2023 Financials

This CSV file contains daily financial data for a mock coffee shop for the year 2023. The data includes both forecasted and actual amounts for different revenue and expense categories. Revenue categories include "Coffee Sales" and "Food Sales." Expense categories cover "Ingredients Cost," "Labor," "Rent," "Utilities," and "Marketing."

This dataset was created to enable financial analysis, questions we might ask include:

How do the actual sales and expenses compare with the forecasted figures? Are there any significant variances, and what might be the reasons for these discrepancies?

Are there specific months or seasons when sales peak or decline? What might be driving these trends?
How do expenses trend throughout the year? Are there any notable fluctuations that need to be addressed?

Which months had the highest and lowest profitability? What contributed to these outcomes?
How do the gross and net profit margins vary over the year?

Which expense category has the largest variance from the forecast? What measures can be taken to control these costs more effectively?

Are there any noticeable trends in the cost of ingredients and labor relative to sales?

Between coffee and food sales, which category is performing better in terms of meeting or exceeding forecasts?

What could be the potential financial impact if the rent increases by 10% next year?