Report Description
Flower shops use mainly fresh-cut flowers. These are perishable items, and if not sold in their lifespan, become waste. The world is focused on being more environmentally conscious, and that fact is a huge marketable item for many businesses. A flower shop that is able to reduce their waste will increase their profit as well as market their environmentally friendly practices to potential customers. In order to determine their waste, a custom dashboard can be a useful tool. Reducing waste in flower shops can be driven by understanding the lifespan, seasonality, and demand of flowers and perishable plants. All data used in this story was fabricated with ChatGPT as a sample flower shop inventory dataset was not found to be available.
Audience:
- Industry- Floral/Fresh Goods
- Audience: Florist, Inventory Manager, Greenhouse Supplier
Use Case
- Visualize shelf-life of inventory against cost of inventory
- Use to promote short-sale of shorter lifespan products to reduce waste
- Identify quality of items received from suppliers
- Limit over-purchasing inventory not in season, reducing shelf-life
- See cost of inventory and how much is on hand to determine cost of waste
- Enable inventory management best practices
Read the full data story here.
How to Use this Report
This two page report is easy to use with button navigations.
- Navigation: The top right is the navigation buttons. The Aging and Stocks buttons direct to pages described below.
- The Aging page shows how much inventory is on hand against the estimated shelf life. There is a navigation in the top right corner to display the inventory as quantity (count) versus value (cost).
- Inventory On Hand: The left side circles show how much inventory is at each of the flower shop locations, and the colored donut chart allows for click-through to see how much inventory is within an aging group.
- Shelf Life of Inventory: This panel shows the inventory on hand broken out into the aging groups (shelf life)
- The flow chart at the bottom allows for a deeper look into the aging groups to determine products and their seasonality.
- The Stocks page shows a breakdown of the inventory on hand. This is a deeper look into what products are where and which need to be ordered.
- The left side dropdowns allow the user to narrow the inventory list to location, seasonality, product group, and product.
- The visual below these filters allows the user to see inventory counts by Location, Season, Product Group, or Aging to see in these categories which inventory category has the highest to lowest counts of inventory.
- The line chart in the top-middle shows inventory sales over the last 12 months to identify peak demand and slow seasons.
- The table at the bottom of the page is an inventory breakdown by product to identify what is on hand.
- Inventory Quantity- how many are in stock
- Status- The inventory level
- Safety Stock- how many of each product should be on hand at any given time
- Reorder point- how many of the product needs to be in inventory to trigger a refill order
- Average Daily Sales- how many of that product are sold in a work day
