
Excel: Store Financial Performance
This report provides a snapshot of the sales performance accross 11 stores, detailing their gross sales, net sales, gross profit and gross profit percentage
This report provides a snapshot of the sales performance accross 11 stores, detailing their gross sales, net sales, gross profit and gross profit percentage
This is a sales analysis in our Company Peavo Restaurant in its two years of operation. The metrics to which we carried out this analysis
are data from product sales and customer count.
This report aims to compare the Gross sales, Net sales, Gross Profit and Gross percentage margin of Peavo Restaurant between the fiscal years 2022 and 2023.
As we continue to analyze the sales for the two years, we focus our analysis on the products as the only metric. From the report we could see the top 10 products, their quantities in the two years respectively. An ideal way to get other products to the top is to run a product camapign. Creating awareness for that product can help us sell other products to our customers.