Introduction to the Fuse Forecasting View

Fuse is an intuitive blend of a top-down and bottom-up approach. We usually start with a top-down forecast, by inputting a sales goal and distributing the sales across categories and SKUs. Then we allow you to edit individual SKUs in a bottom-up approach.

To the right is the overall view, which displays your sales by category. To return to this view at any time, simply click on "Forecasting" in the header navigation.

Our forecasting view is an intuitive blend of a top-down and bottoms-up approach.

Setting the Sales Goal

First, set the date range in which you are forecasting. Click on the black triangles to display a calendar drop-down, and select the date you want.

First, input the date range for your forecast.

Then set your overall sales goal for the time period by clicking on the black box under "revenue goal," then editing the number to the total dollars you expect to sell.

Then, input your sales target.

Understanding your Goals

Revenue Goal

The revenue goal is the number of total sales you hope to make in the time period specified. Usually, this number comes from finance, or is calculated based on a YOY growth over last year's sales.

When editing in % mode, you are redistributing sales against the revenue goal.

Forecasted

In contrast, the "Forecasted" number is calculated real-time from edits made to your forecast. Since items are sold in whole numbers, you may notice that this number differs slightly from your goal, because it is the sum of # units sold x retail price.

When you edit in $ or # mode, you may notice that the difference between forecasted sales and the your revenue goal increases as a result.

Fuse adjusts your forecast to be as close to your sales target as possible.

Top-down Forecasting

ChangING THE CATEGORY-LEVEL DISTRIBUTION

Here, I'll walk you through a scenario where you'll need to adjust the distribution on a category level. You may decide that this year, dresses are going to be your main seller (35% of sales), much more than previous years (when they were 20% of sales). To that end, you'd like to re-distribute your sales forecast on a category level.

1) Simply click the black box to edit the number at the category level. Input the new percentage; in this case, 35%. Make sure the toggle next to the black box is in % mode! 

Your initial distribution will automatically pull in from your e-commerce website.

2) Click the "preview" button to re-distribute sales across categories. Since dresses increased to 35% of sales, we re-distribute the remaining 65% of sales across the other categories, preserving the same proportions.

Update the share of a specific category, and the other categories and SKUs will automatically re-distribute

3) Notice that after the re-distribution, Tops were reduced from 22% to 18% of sales. If you're happy with the changes, click "save," or simply click "discard" to start anew.

Simply hit preview to see the results. Discard or save depending on whether you want to toss out or keep your changes.

Changing SKU-level Distributions

Similar to category-level distributions, you can also change the distribution of the category sales into individual SKUs. In this example, we change the Oriana Dress from 20% to 40% of Dress sales. Note: you can edit multiple SKU's at once.

1) Click the black box for the SKU you want to edit. Input the new percentage; in this case, 40%. Again, make sure the toggle next to the black box is in % mode! 

1) Simply click the black box to edit the number at the category level. Input the new percentage; in this case, 35%. Make sure the toggle next to the black box is in % mode! 

2) Click the "preview" button to re-distribute sales across the SKUs in the same category. Like the categories, we preserve the proportions when we re-distribute.

Notice that after the re-distribution, Tops were reduced from 22% to 18% of sales. If you're happy with the changes, click "save," or simply click "discard" to start anew.

3) After the re-distribution, if you're happy with the changes, click "save," or simply click "discard" to start anew.

Click the "preview" button to re-distribute sales across categories. Since dresses increased to 35% of sales, we re-distribute the remaining 65% of sales across the other categories, preserving the same proportions.

Conceptually, the left side of the toggles (% mode) is the top-down forecast, and the right side of the toggles (# and $ mode) is the bottom-up forecast. When a category or SKU are in bottom-up mode, they will be frozen in the value that you set them at. To un-freeze them, simply switch back into % mode, and they will dynamically re-distribute every time you hit "preview." We designed this system so that you can combine both a top-down and bottom-up forecast in one view.

Bottom-up Forecasting

Forecasting from the bottom-up is easy: simply switch the toggle to # mode.

Toggle to see the number of units that your percent distribution implies.

Input the number of units you are forecasted to sell.

Change the units, either increasing or decreasing them, to set a specific number. The units will lock into place and won't redistribute.

Sales of the Brooklyn Beanie will now be kept at 3000 units, and will not be re-distributed unless you switch back into % mode.

 

Fluidity of the Forecast

Easily toggle back to include the SKU in the re-distribution once again.

If you decide that you want the SKU to be part of re-distribution again, simply switch the toggle back to % mode. You'll see that the percentage of sales has been adjusted to 56%, which corresponds to your 3000 units.

You can freeze another SKU, such as the Diva Beanie.

Adjust the units of each SKU as needed.

Click on the "preview" button at the bottom of the sidebar to redistribute. As you can see, the Brooklyn Beanie and the Mia Beanie were re-distributed in the same proportion as they were after you un-froze the Brooklyn Beanie. 

Hit preview to see the implications of your changes.

You can toggle between % and # mode for any number of SKUs at a time. Just remember that when you hit "preview," the SKUs left in # mode will be kept at the number of units you specified, and the SKUs left in % mode will have the remaining cash for the category spend redistributed amongst them, in the same proportions that you left them in.

 

Category Spend

Category spend can also be capped at a certain dollar amount. It works the exact same way that the # mode works on SKUs, except that your input is in $ and not # of units sold. You can toggle between modes for any number of categories that you want


See your current inventory levels, your weeks of supply, the recommended re-order quantity and your recommended re-order date.

Introduction to the Ordering View

After you finish forecasting, click into the ordering view to see:

  1. What you need to order
  2. How much you need to order
  3. By when you need to order


Setting your Order Cycle

We understand that each company has a different ordering cycle; some order in weeks, months, even years. Simply adjust the date to suit your needs. 

Dynamically update your ordering cycle to reflect the unique needs of your business.

Here, we've re-prioritized the urgency of your orders and re-calculated your order amounts, so as to adjust to buying until September 30.

We prioritize based on urgency so that you can quickly and easily see what products you urgently need to re-order.

Understanding the Ordering View

We designed this view to be visual and intuitive. Products are listed here in order of urgency; those with the earliest "order by" dates will display first, so you can prioritize your work day efficiently. The colors of the bars correspond to the urgency of order by dates as well. Here, I'll walk you through each column of the ordering view so that you have a full understanding of the design.

Our ordering view gives you a comprehensive snap shot of your weeks of supply, inventory on hand, projected demand, initial buys and replenishment quantities.

product

The product name.

weeks on hand

The weeks on hand you have left for the product. We calculate this by comparing how much stock you have on hand with how much you've forecasted to sell in the upcoming weeks.

Color Bars

Here we visualize how much stock you have on hand, compared to how much you need. The number on the left is the number of units you have on hand today. The number on the right is how many units you are forecasted to sell by the specified date.

The bar colors correspond to the order by date urgency: red means order within 2 weeks, yellow means order within the next month, and green means you have over a month's worth of stock left.

Eventually, if you tell us how much you have on order, we will factor your inventory on order into our calculations, and will display them as a different color in this bar feature

QTY

This is how much you need to order so that you don't stock out before the date you specified.

Units By

Units is the default Unit of Measure (UOM), but here we will display whatever UOM you have designated for the SKU.

Order By

This is the date by which you must place an order to prevent stock-outs. We calculate this taking into account your weeks on hand and your product's lead time. It is only as accurate as the lead time that you give us, so please make sure that your information is solid!

Total

This is the expected spend that you will need to stock up until your specified date. We calculate it as the units you need to purchase x the SKU's unit cost. Again, it is only as accurate as the unit cost you give us. 


Spree/Solidus Documentation

  1. Make sure the account associated with the API key that Fuse will connect with has admin access.

  2. Add updated_at and created_at to ransackable_attributes for both Products and Orders.

  3. Return the list of line items and associated variant for each order as part of Order Search API, in the same way that line items are returned for the Order Show API.

  4. Return updated_at and created_at in the response to the Product Search API.

 

If a subscriptions channel is supported,

  1. Expose a Subscriptions API according to Fuse’s custom API documentation.

  2. Return subscription_id in the response to the Order Search API for Orders that have an associated subscription.

  3. Add subscription_id to ransackable_attributes for Orders.

 

Contact Us

If you're still experiencing issues, please don't hesitate to contact us using the form below!

 

Please complete the form below

Name *
Name