---
title: "Commissary Forecast"
slug: "commissary-forecast"
description: "Forecast commissary item order quantities using historical order-to-sales ratios and the Daily Sales Forecast."
updated: 2025-08-27T22:18:24Z
published: 2025-08-27T22:18:24Z
canonical: "docs.restaurant365.com/commissary-forecast"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Commissary Forecast

The Commissary Forecast Report forecasts how much food will be ordered. This is based on previous fulfilled ordered quantities for a set number of weeks compared to its Actual Net Sales, which is calculated from its Daily Sales Summaries. This creates an Order Quantity to Net Sales dollar ratio, which is multiplied by the [Daily Sales Forecast](/doc/docs/forecasting) for the number of days entered to produce a forecasted Order Quantity for each item.

A restaurant is more able to predict the amount of food to buy and prep when this forecast is ran.

---

## Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

1. Open the **Reports** app.
2. Navigate to **My Reports**.
3. Enter all or part of the report name in the **search bar**.
4. The **Results** tab will open with the list of search results.
5. From beneath the report name, click **Run** to run the report with the selected report view. -OR- Click **Customize** to adjust the report parameters and run the report.

![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png)

---

## Report Parameters

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-NEQ6R1WN.png)

| **Field/Column** | **Description** |
| --- | --- |
| **Filter By** | A listing of all the location categories. |
| **Filter** | A listing of all locations associated with the selected location category. |
| **Commissary Category** | This drop-down menu allows the user to select a specific food category. |
| **As Of** | The ending date of the date range for all orders and actual sales history. |
| **Past X Week Avg** | The number of weeks that the system looks back for all orders and actual sales history. |
| **Days to Forecast** | The number of days that need order quantities. |
| **Run Button** | Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. |

---

## Report Columns

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-M1DEP18Q.png)

| **Field** | **Description** |
| --- | --- |
| **Item #** | The number associated with the item in the item record. These are organized by item categories. |
| **Item Name** | The name of the purchased item, as noted in the item record. |
| **U of M** | The unit of measure used to count the item. |
| **Total Order Qty** | The total amount of the item ordered over the past # of weeks (report parameter). |
| **Avg Daily Order Qty** | The average amount that was ordered each day over the past # of weeks (report parameter). |
| **Sales Per Unit** | The total sales for the item over the past # of weeks (report parameter). |
| **Qty Needed Forecast** | The forecasted amount needed for the upcoming week. |

---

## Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to [send, export, or print this report](/doc/docs/my-reports-send-export-or-print-reports).

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-U3S8UCR9.png)